Ticket #3941: list.htm

File list.htm, 8.5 KB (added by jonathan.martens@…, 18 years ago)

Backtrace of the mythweb error

Line 
1<hr><p><b>Fatal Error</b> at /var/www/html/includes/objects/Database/Query/mysql.php, line 83:<br />SQL Error: Got error 28 from storage engine [#1030]</p>
2<p>If you choose to <b><u><a href="http://svn.mythtv.org/trac/newticket" target="_blank">submit a bug report</a></u></b>, please make sure to include a<br />brief description of what you were doing, along with the following<br />backtrace as an attachment (please don't paste the whole thing into<br />the ticket).
3<hr>
4<b>Backtrace</b>:<br />
5<pre> datetime: 2007-09-08 17:40:50 (CEST)
6 errornum: 256
7 error type: User Error
8error string: SQL Error: Got error 28 from storage engine [#1030]
9 filename: /var/www/html/includes/objects/Database/Query/mysql.php
10 error line: 83
11
12==========================================================================
13
14Backtrace:
15
16 file: /var/www/html/includes/objects/Database/Query/mysql.php
17 line: 83
18 class:
19function: trigger_error
20 type:
21 args: Array
22(
23 [0] =&gt; SQL Error: Got error 28 from storage engine [#1030]
24 [1] =&gt; 256
25)
26
27 file: /var/www/html/includes/objects/Database.php
28 line: 261
29 class: Database_Query_mysql
30function: execute
31 type: -&gt;
32 args: Array
33(
34 [0] =&gt; Array ( )
35)
36
37 file: /var/www/html/modules/tv/includes/programs.php
38 line: 162
39 class: Database
40function: query
41 type: -&gt;
42 args: Array
43(
44 [0] =&gt; SELECT program.*,
45 UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
46 UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
47 IFNULL(programrating.system, &quot;&quot;) AS rater,
48 IFNULL(programrating.rating, &quot;&quot;) AS rating,
49 channel.callsign,
50 channel.channum
51 FROM program
52 LEFT JOIN programrating USING (chanid, starttime)
53 LEFT JOIN channel ON program.chanid = channel.chanid
54 WHERE program.chanid IN (1109,1110,1111,1112,1007,1056,1057,1095,1092,1081,1083,1093,1059,1101,1096,1100,1091,1064,1024,1085,1089,1097,1108,1099,1106,1068,1073,1104,1080,1069,1102,1107,1070,1063,1066,1062,1103,1094,1013) AND (program.endtime &gt; FROM_UNIXTIME('1189265400') AND program.starttime &lt; FROM_UNIXTIME('1189276200') AND program.starttime != program.endtime)
55GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime
56)
57
58 file: /var/www/html/modules/tv/list.php
59 line: 49
60 class:
61function: load_all_program_data
62 type:
63 args: Array
64(
65 [0] =&gt; 1189265400
66 [1] =&gt; 1189276200
67)
68
69 file: /var/www/html/modules/tv/handler.php
70 line: 75
71 class:
72function: require_once
73 type:
74 args: Array
75(
76 [0] =&gt; /var/www/html/modules/tv/list.php
77)
78
79 file: /var/www/html/mythweb.php
80 line: 28
81 class:
82function: require_once
83 type:
84 args: Array
85(
86 [0] =&gt; /var/www/html/modules/tv/handler.php
87)
88
89
90==========================================================================
91
92$_SESSION: Array
93(
94 [language] =&gt; English
95 [tmpl] =&gt; default
96 [skin] =&gt; default
97 [prefer_channum] =&gt; 1
98 [date_statusbar] =&gt; %a %b %e, %Y, %I:%M %p
99 [date_scheduled] =&gt; %a %b %e, %Y (%I:%M %p)
100 [date_scheduled_popup] =&gt; %a %b %e, %Y
101 [date_recorded] =&gt; %a %b %e, %Y (%I:%M %p)
102 [date_search] =&gt; %a %b %e, %Y, %I:%M %p
103 [date_listing_key] =&gt; %a %b %e, %Y, %I:%M %p
104 [date_listing_jump] =&gt; %a %b %e, %Y
105 [date_channel_jump] =&gt; %a %b %e, %Y
106 [date_job_status] =&gt; %a %b %e, %Y, %I:%M %p
107 [time_format] =&gt; %I:%M %p
108 [use_myth_uri] =&gt; 1
109 [recorded_pixmaps] =&gt; 1
110 [guide_favonly] =&gt;
111 [timeslot_size] =&gt; 300
112 [num_time_slots] =&gt; 36
113 [timeslot_blocks] =&gt; 3
114 [timeslotbar_skip] =&gt; 20
115 [max_stars] =&gt; 4
116 [star_character] =&gt; &amp;diams;
117 [weather] =&gt; Array
118 (
119 [siunits] =&gt; NO
120 )
121
122 [tv] =&gt; Array
123 (
124 [last] =&gt; Array
125 (
126 [0] =&gt; list
127 )
128
129 )
130
131 [list_time] =&gt; 1189265400
132 [scheduled_recordings] =&gt; Array
133 (
134 [disp_scheduled] =&gt; 1
135 [disp_duplicates] =&gt; 1
136 [disp_deactivated] =&gt; 1
137 [disp_conflicts] =&gt; 1
138 )
139
140 [scheduled_sortby] =&gt; Array
141 (
142 [0] =&gt; Array
143 (
144 [field] =&gt; airdate
145 [reverse] =&gt;
146 )
147
148 [1] =&gt; Array
149 (
150 [field] =&gt; title
151 [reverse] =&gt;
152 )
153
154 )
155
156 [recorded_title] =&gt; Ray Mears' extreme survival
157 [recorded_recgroup] =&gt;
158 [recorded_sortby] =&gt; Array
159 (
160 [0] =&gt; Array
161 (
162 [field] =&gt; airdate
163 [reverse] =&gt; 1
164 )
165
166 [1] =&gt; Array
167 (
168 [field] =&gt; title
169 [reverse] =&gt;
170 )
171
172 )
173
174 [search] =&gt; Array
175 (
176 [s] =&gt; canned:Music Specials
177 [type] =&gt; q
178 [ctype] =&gt; Array
179 (
180 [0] =&gt;
181 [1] =&gt; series
182 [2] =&gt; sports
183 )
184
185 [stars_gt] =&gt; 0
186 [stars_lt] =&gt; 0
187 [starttime] =&gt; now
188 [endtime] =&gt; + 2 weeks
189 [as] =&gt; Array
190 (
191 [0] =&gt; a
192 )
193
194 [af] =&gt; Array
195 (
196 [0] =&gt; Array
197 (
198 [0] =&gt; title
199 )
200
201 )
202
203 [aj] =&gt; Array
204 (
205 [0] =&gt; AND
206 )
207
208 [hd] =&gt;
209 [commfree] =&gt;
210 [airdate_start] =&gt;
211 [airdate_end] =&gt;
212 )
213
214 [search_sortby] =&gt; Array
215 (
216 [0] =&gt; Array
217 (
218 [field] =&gt; airdate
219 [reverse] =&gt;
220 )
221
222 [1] =&gt; Array
223 (
224 [field] =&gt; title
225 [reverse] =&gt;
226 )
227
228 )
229
230 [video_sortby] =&gt; Array
231 (
232 [0] =&gt; Array
233 (
234 [field] =&gt; title
235 [reverse] =&gt;
236 )
237
238 )
239
240 [settings] =&gt; Array
241 (
242 [last] =&gt; Array
243 (
244 [0] =&gt; mythtv
245 [1] =&gt; settings
246 )
247
248 [host] =&gt; mythtv.snetram.nl
249 )
250
251 [video] =&gt; Array
252 (
253 [path] =&gt; /
254 )
255
256)
257
258==========================================================================
259
260$_SERVER: Array
261(
262 [REDIRECT_STATUS] =&gt; 200
263 [HTTP_HOST] =&gt; mythtv.snetram.nl
264 [HTTP_USER_AGENT] =&gt; Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
265 [HTTP_ACCEPT] =&gt; text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
266 [HTTP_ACCEPT_LANGUAGE] =&gt; en-us,en;q=0.5
267 [HTTP_ACCEPT_ENCODING] =&gt; gzip,deflate
268 [HTTP_ACCEPT_CHARSET] =&gt; ISO-8859-1,utf-8;q=0.7,*;q=0.7
269 [HTTP_KEEP_ALIVE] =&gt; 300
270 [HTTP_CONNECTION] =&gt; keep-alive
271 [HTTP_REFERER] =&gt; http://mythtv.snetram.nl/video?path=/
272 [HTTP_COOKIE] =&gt; mythweb_id=1upu146lmi5sehjuvr4vpeub42
273 [PATH] =&gt; /sbin:/usr/sbin:/bin:/usr/bin
274 [SERVER_SIGNATURE] =&gt; &lt;address&gt;Apache/2.2.3 (CentOS) Server at mythtv.snetram.nl Port 80&lt;/address&gt;
275
276 [SERVER_SOFTWARE] =&gt; Apache/2.2.3 (CentOS)
277 [SERVER_NAME] =&gt; mythtv.snetram.nl
278 [SERVER_ADDR] =&gt; 10.0.0.101
279 [SERVER_PORT] =&gt; 80
280 [REMOTE_ADDR] =&gt; 10.0.0.100
281 [DOCUMENT_ROOT] =&gt; /var/www/html
282 [SERVER_ADMIN] =&gt; root@localhost
283 [SCRIPT_FILENAME] =&gt; /var/www/html/mythweb.php
284 [REMOTE_PORT] =&gt; 1367
285 [REDIRECT_URL] =&gt; /tv/list
286 [GATEWAY_INTERFACE] =&gt; CGI/1.1
287 [SERVER_PROTOCOL] =&gt; HTTP/1.1
288 [REQUEST_METHOD] =&gt; GET
289 [QUERY_STRING] =&gt;
290 [REQUEST_URI] =&gt; /tv/list
291 [SCRIPT_NAME] =&gt; /mythweb.php
292 [PATH_INFO] =&gt; /tv/list
293 [PATH_TRANSLATED] =&gt; redirect:/mythweb.php/tv/list/list
294 [PHP_SELF] =&gt; /mythweb.php/tv/list
295 [REQUEST_TIME] =&gt; 1189266049
296 [STATUS] =&gt; 200
297 [URL] =&gt; /tv/list
298)
299
300
301</pre>