Opened 12 years ago

Closed 12 years ago

#4119 closed defect (invalid)

mythweb fails to display listings for trunk version 14776

Reported by: Ryan H. <majost@…> Owned by: xris
Priority: blocker Milestone: unknown
Component: mythweb Version: unknown
Severity: medium Keywords:
Cc: Ticket locked: no

Description

This error was displayed while running trunk version 14776 of mythtv, and the mythplugins.

---

Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database/Query/mysql.php, line 83: SQL Error: Got error 28 from storage engine #1030

If you choose to submit a bug report, please make sure to include a brief description of what you were doing, along with the following backtrace as an attachment (please don't paste the whole thing into the ticket). Backtrace:

datetime: 2007-11-01 12:52:58 (PDT) errornum: 256

error type: User Error

error string: SQL Error: Got error 28 from storage engine #1030

filename: /usr/share/mythtv/mythweb/includes/objects/Database/Query/mysql.php

error line: 83

==========================================================================

Backtrace:

file: /usr/share/mythtv/mythweb/includes/objects/Database/Query/mysql.php line: 83

class:

function: trigger_error

type: args: Array

(

[0] => SQL Error: Got error 28 from storage engine #1030 [1] => 256

)

file: /usr/share/mythtv/mythweb/includes/objects/Database.php line: 261

class: Database_Query_mysql

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /usr/share/mythtv/mythweb/modules/tv/includes/programs.php line: 167

class: Database

function: query

type: -> args: Array

(

[0] => SELECT program.*,

UNIX_TIMESTAMP(program.starttime) AS starttime_unix, UNIX_TIMESTAMP(program.endtime) AS endtime_unix, IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS rating, channel.callsign, channel.channum

FROM program

LEFT JOIN programrating USING (chanid, starttime) LEFT JOIN channel ON program.chanid = channel.chanid

WHERE program.chanid IN (3145,39865,4226,2233,4281,40868,4291,4293,4308,3326,3327,3328,3329,39868,39867,4446,4447,4453,3485,3486,3488,3489,3491,3492,3493,3494,3496,3497,3519,40869,4545,4549,4557,4562,4564,4572,3599,39866,39863,39864,2710,2712,2843,38864,2848,2852,38865,4858,2861,2862,2863,2866,2867,2868,2869,2881,2882,2883,2884,2984,3995,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1070,1095,1096,1099,1100,2189,2254,2257,2274,2397,2398,2465,2466,2467,2468,2469,2470,2471,2473,2475,2476,2477,2573,2690,2697,2706,2709,2727,2728,2730,2781,2782,2790,2791,2792,2793,2794,2795,2796,2802,2806,2809,2810,2811,2812,2813,2814,2815,2817,2818,2819,2821,2825,2827,2829,2830,2831,2832,2833,2835,2839,2840,2841,2842,2844,2845,2846,2849,2850,2851,2853,2880,2885,2886,2887,2888,2891,2892,2893,2894,2895,2897,2898,2979,2983,3092,3093,3100,3101,3102,3103,3104,3106,3108,3109,3110,3116,3117,3122,3124,3125,3130,3135,3137,3139,3142,3144,3147,3149,3150,3153,3155,3158,3178,3184,3187,3188,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3208,3209,3213,3214,3215,3216,3217,3218,3219,3220,3221,3225,3226,3227,3228,3229,3230,3231,3232,3235,3237,3238,3239,3240,3241,3242,3250,3252,3253,3255,3256,3258,3259,3261,3265,3266,3267,3268,3269,3270,3279,3280,3281,3282,3283,3284,3290,3291,3294,3295,3296,3297,3298,3300,3302,3306,3307,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,3320,3321,3322,3323,3324,3325,3330,3331,3332,3333,3334,3335,3336,3348,3351,3352,3353,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3381,3386,3387,3388,3389,3390,3392,3393,3394,3401,3402,3404,3406,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3424,3425,3426,3427,3429,3430,3431,3432,3433,3434,3436,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3451,3452,3454,3455,3457,3458,3459,3462,3463,3464,3478,3479,3481,3500,3502,3503,3505,3506,3508,3509,3510,3512,3514,3515,3522,3523,3524,3526,3527,3528,3529,3548,3550,3551,3552,3554,3555,3556,3557,3558,3559,3560,3561,3562,3564,3567,3569,3570,3575,3576,3577,3579,3580,3581,3582,3602,3604,3605,3606,3609,3616,3617,3618,3619,3620,3622,3625,3626,3628,3630,3635,3636,3637,3638,3639,3640,3641,3642,3651,3660,3698,3700,3701,3703,3708,3712,3731,3732,3742,3748,3750,3751,3752,3753,3754,3755,3756,3757,3758,3759,3760,3779,3805,3896,3905,3906,3908,3912,3913,3914,3922,3924,3926,3928,3929,3931,3932,3933,3934,3936,3939,3940,3941,3942,3944,3945,3950,3951,3952,3954,3956,3957,3960,3961,3962,3963,3965,3966,3967,3969,3970,3971,3972,3977,3980,3981,3982,3986,3993,3994,4100,4103,4109,4111,4113,4115,4119,4121,4123,4126,4133,4141,4147,4149,4151,4152,4156,4157,4163,4167,4175,4177,4178,4179,4185,4186,4187,4188,4190,4191,4192,4193,4194,4195,4196,4197,4198,4203,4207,4211,4216,4218,4219,4220,4221,4223,4225,4227,4229,4231,4265,4271,4272,4280,4282,4283,4284,4285,4286,4298,4307,4309,4313,4314,4321,4323,4324,4329,4330,4341,4342,4343,4344,4345,4346,4347,4351,4354,4400,4401,4402,4406,4407,4408,4409,4411,4433,4437,4439,4440,4441,4442,4443,4444,4445,4448,4449,4450,4451,4452,4454,4456,4457,4458,4459,4461,4462,4463,4464,4465,4466,4467,4481,4483,4484,4485,4487,4488,4492,4494,4498,4499,4500,4503,4504,4506,4507,4508,4510,4511,4512,4513,4514,4515,4516,4517,4518,4519,4520,4521,4522,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4534,4535,4536,4537,4538,4539,4540,4548,4551,4560,4566,4568,4569,4570,4825,4828,4830,4831,4835,4836,4837,4838,4839,4840,4841,4842,4843,4844,4845,4853,4854,4855,4857,4859,4862,4863,4865,4868,4870,4872,4873,4876,4877,4883,4884,4886,4888,4892,4893,4896,4897,4898,4899,4919,4988,4999,5101,5105,5106,5107,5108,5110,5112,5114,5116,5117,5118,5120,5122,5124,5127,5128,5129,5130,5131,5132,5135,5136,5137,5138,5139,5140,5142,5143,5144,5145,5146,5148,5150,5153,5158,5159,5160,5161,5162,5166,5168,5169,5170,5171,5172,5173,5174,5176,5180,5181,5182,5183,5184,5189,5200,5202,5204,5205,5208,5209,5210,5212,5213,5214,5215,5222,5224,5228,5232,5234,5235,5236,5238,5239,5249,5251,5252,5254,5255,5260,5261,5262,5263,5270,5273,5281,5299,5300,5301,5302,5303,5304,5305,5310,5311,5312,5318,5319,5320,5322,5327,5328,5332,5333,5340,5350,5352,5353,5355,5356,5404,5405,5410,5412,5413,5414,5415,5416,5417,5418,5419,5420,5422,5423,5424,5425,5426,5427,5428,5429,5430,5431,5432,5434,5435,5436,5438,5446,5447,5453,5455,5460,5480,5482,5486,5489,5490,5495,5496,5497,5502,5505,5509,5600,5819,5820,5821,5822,5823,5824,5827,5833,5846,5847,5874,5878,5879,5880,5881,5882,5885,5887,5889,5890,5891,5894,5920,5921,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5935,5936,5937,5938,5939,5940,5941,5942,5943,5944,5945,5946,5947,5948,5949,5950,5951,5952,5953,5954,5955,5956,5957,5958,5959,5960,5961,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5973,5974,5975,5976,5977,5978,5979,5980,5981,5983,9000,9001,9002,9003,9004,9005,13575,9740,9741,9742,9743,9744,9747,9749,9756,9770,9771,9772,9773,9774,9775,9776,9777,9778,9800,9801,9804,9805,9806,9807,9808,9809,9810,9811,9812,9813,9817,9818,9819,9820,9821,9822,9823,9824,9825,9828,9830,9831,9856,9878,12882,9897,9900,9901,9902,10407,10408,10409,10410,10767,10802,10803,10814,10815,10816,10829,10832,10833,10836,10879,10880,11001,11002,11003,11004,11005,11006,11007,11008,11009,11010,11011,11012,11013,11014,11015,11016,11017,11018,11019,11020,11021,11022,11023,11024,11025,11026,11027,11028,11029,11030,11031,11032,11033,11034,11035,11036,11037,11040,11043,11045,11050,11051,11053,11060,11061,11062,11063,11065,11066,11068,11070,11071,11072,11073,11074,11075,11077,11080,11085,11086,11090,11092,11097,11116,11451,11452,11454,11455,11457,11458,11459,11462,11463,11464,12200,12201,12202,12203,12241,12306,12490,12491,12492,12493,12526,12548,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12815,12816,12822,12823,12836,12839,12841,12843,12844,12845,12846,12851,12853,12854,12855,12856,12866,12871,12872,12874,12875,12876,12888,12903,12904,12905,12908,12909,12913,12926,12927,12928,12931,12932,12965,12966,12967,12968,12969,12970,12971,12972,12973,12974,12975,12976,12977,12978,12979,12980,12991,12992,12997,12998,12999,13004,13030,13031,13032,13033,13034,13036,13037,13038,13039,13100,13101,13102,13103,13104,13105,13175,13204,13264,13322,13323,13324,13325,13326,13327,13396,13397,13398,13400,13401,13403,13404,13407,13410,13415,13420,13421,13422,13423,13448,13456,13460,13465,13467,13568,13601,13611,13612,13615,13645,13775,13794,13800,13834,13856,13900,13945,13946,13998,14328,14346,14411,14412,14414,14602,18613,14801,18002,18003,18004,18005,18006,18007,18008,18009,18010,18011,18012,18013,18015,18016,18017,18018,18019,18021,18022,18023,18026,18095,18096,18097,18099,18102,18103,18223,18254,18255,18256,18271,18272,18443,18468,18469,18470,18471,18544,18545,18555,18556,18557,18593,18601,18619,18620,18622,18648,18684,18697,18698,18699,18757,18759,18760,18817,18818,18870,18872,19050,19059,19065,19081,19535,19809,19859,19871,19936,19949,23001,23002,23004,23007,23017,23018,23026,23027,23029,23038,23039,23048,23049,23050,23051,23055,23058,23059,23060,23063,23070,23077,23086,23087,23090,23091,23092,23093,23097,23098,23100,23101,23123,23124,23140,23141,24000,24010,24012,24030,24031,24032,24066,24067,24068,24073,24075,24076,24140,34200,34201,35200,35201,35500,35510,36500,36510,36767,36768,37767,37768,39861,39862,40610,40700,40849,40850,40855,40857,40859,40860,40861,40863,40864,40865,40866,40867,41608,41610,41860,41861,41862) AND (program.endtime > FROM_UNIXTIME('1193946300') AND program.starttime < FROM_UNIXTIME('1193957100') AND program.starttime != program.endtime)

GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime )

file: /usr/share/mythtv/mythweb/modules/tv/list.php line: 49

class:

function: load_all_program_data

type: args: Array

(

[0] => 1193946300 [1] => 1193957100

)

file: /usr/share/mythtv/mythweb/modules/tv/handler.php line: 75

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/list.php

)

file: /usr/share/mythtv/mythweb/mythweb.php line: 28

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/handler.php

)

==========================================================================

$_SESSION: Array (

[language] => English [tmpl] => default [skin] => default [prefer_channum] => 0 [date_statusbar] => %a %b %e, %Y, %I:%M %p [date_scheduled] => %a %b %e, %Y (%I:%M %p) [date_scheduled_popup] => %a %b %e, %Y [date_recorded] => %a %b %e, %Y<br />(%I:%M %p) [date_search] => %a %b %e, %Y, %I:%M %p [date_listing_key] => %a %b %e, %Y, %I:%M %p [date_listing_jump] => %a %b %e, %Y [date_channel_jump] => %a %b %e, %Y [time_format] => %I:%M %p [recorded_pixmaps] => 1 [guide_favonly] => [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 20 [max_stars] => 4 [star_character] => &diams; [list_time] => 1193946300 [schedules_sortby] => Array

(

[0] => Array

(

[field] => title [reverse] => 1

)

[1] => Array

(

[field] => recpriority [reverse] =>

)

[2] => Array

(

[field] => airdate [reverse] =>

)

)

[recorded_title] => [recorded_recgroup] => [recorded_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] => 1

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[search] => Array

(

[s] => chennel 10 news [type] => q [ctype] => Array

(

[0] => [1] => series [2] => sports [3] => tvshow

)

[stars_gt] => 0.75 [stars_lt] => 1 [starttime] => 0 [endtime] => +15 days [as] => Array

(

[0] => How-to [1] => moving

)

[af] => Array

(

[0] => Array

(

[0] => category

)

[1] => Array

(

[0] => description

)

)

[aj] => Array

(

[0] => AND [1] => AND

)

[hd] => [commfree] => [airdate_start] => [airdate_end] =>

)

[search_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[scheduled_recordings] => Array

(

[disp_scheduled] => 1 [disp_duplicates] => [disp_deactivated] => 1 [disp_conflicts] => 1

)

[scheduled_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[date_job_status] => %a %b %e, %Y, %I:%M %p [use_myth_uri] => 1 [tv] => Array

(

[last] => Array

(

[0] => list

)

[show_advanced_schedule] => 1

)

[settings] => Array

(

[last] => Array

(

[0] => stream [1] => protocol

)

[host] =>

)

[weather] => Array

(

[siunits] => NO [locale] => USCA1030

)

[stream] => Array

(

[force_http] => 1 [force_http_port] => 9090

)

[] => Array ( ) [recording_details] => Array

(

[show_Conflict] => 1 [show_PreviousRecording] => 1 [show_EarlierShowing] => 1 [show_CurrentRecording] => 1 [show_WillRecord] => 1

)

)

==========================================================================

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [HTTP_USER_AGENT] => Opera/9.24 (X11; Linux i686; U; en) [HTTP_HOST] => CENSOREDHOST:9090 [HTTP_ACCEPT] => text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.9 [HTTP_ACCEPT_CHARSET] => iso-8859-1, utf-8, utf-16, *;q=0.1 [HTTP_ACCEPT_ENCODING] => deflate, gzip, x-gzip, identity, *;q=0 [HTTP_REFERER] => http://CENSOREDHOST:9090/mythweb/status [HTTP_COOKIE] => mythweb_id=e132b8d42b6fab06924373fc5953f098; utma=10402854.749458042.1180480148.1180480148.1180480148.1; utmz=10402854.1180480148.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none) [HTTP_COOKIE2] => $Version=1 [HTTP_CACHE_CONTROL] => no-cache [HTTP_CONNECTION] => Keep-Alive, TE [HTTP_TE] => deflate, gzip, chunked, identity, trailers [PATH] => /usr/local/bin:/usr/bin:/bin [SERVER_SIGNATURE] => <address>Apache/2.2.3 (Debian) PHP/5.2.0-8+etch5~pu1 Server at CENSOREDHOST Port 80</address>

[SERVER_SOFTWARE] => Apache/2.2.3 (Debian) PHP/5.2.0-8+etch5~pu1 [SERVER_NAME] => CENSOREDHOST [SERVER_ADDR] => 192.168.1.50 [SERVER_PORT] => 80 [REMOTE_ADDR] => 198.172.200.5 [DOCUMENT_ROOT] => /var/www [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php [REMOTE_PORT] => 62029 [REMOTE_USER] => mythtv [AUTH_TYPE] => Digest [REDIRECT_URL] => /mythweb/tv/list [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /mythweb/tv/list [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /tv/list [PATH_TRANSLATED] => /var/www/tv/list [PHP_SELF] => /mythweb/mythweb.php/tv/list [PHP_AUTH_DIGEST] => username="mythtv", realm="MythTV", uri="/mythweb/tv/list", algorithm=MD5, nonce="4aJtYuM9BAA=5c55d28c46239628cab39028eb6b2d0347bed77a", cnonce="ZmNwWqfCpdZ7xIlcENAtHY2V2GVrFb1zlXt9kvuWL9N=", qop=auth, nc=0000001c, response="13c6842f9eccca62260fc90cb750d46d" [REQUEST_TIME] => 1193946778 [argv] => Array ( ) [argc] => 0 [STATUS] => 200 [URL] => /mythweb/tv/list

Change History (1)

comment:1 Changed 12 years ago by xris

Resolution: invalid
Status: newclosed

"storage engine" means the database. This is an issue with a corrupt database file, not MythWeb code.

Note: See TracTickets for help on using tickets.