Ticket #3941: list.htm

File list.htm, 8.5 KB (added by jonathan.martens@…, 13 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>