[mythtv-users] wierd mysql errors, preventing me from accessing mythweb
Gabe Rubin
gaberubin at gmail.com
Wed Jun 28 22:22:03 UTC 2006
I have been getting some wierd errors as of late from mythweb. When I
go into mythweb, and look at recorded programs, I get no programs
listed and the following message: programs, using B () out of 269 GB
(91 GB free).
On the listings page, I get a pretty verbose error output:
Fatal Error at /var/www/html/mythweb/includes/db.php, line 360:
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).
Details:
datetime: 2006-06-28 15:19:52 (PDT)
errornum: 256
error type: User Error
error string: SQL Error: Got error 28 from storage engine [#1030]
filename: /var/www/html/mythweb/includes/db.php
error line: 360
==========================================================================
Backtrace:
file: /var/www/html/mythweb/includes/db.php
line: 360
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Got error 28 from storage engine [#1030]
[1] => 256
)
file: /var/www/html/mythweb/includes/db.php
line: 133
class: Database_Query_mysql
function: execute
type: ->
args: Array
(
[0] => Array
(
[0] => ♦
[1] => 4
[2] => 4
)
)
file: /var/www/html/mythweb/includes/programs.php
line: 170
class: Database
function: query
type: ->
args: Array
(
[0] => SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
CONCAT(repeat(?, program.stars * ?),
IF((program.stars * ? * 10) % 10,
"½", "")) AS starstring,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
oldrecorded.recstatus,
channel.channum
FROM program
LEFT JOIN programrating USING (chanid, starttime)
LEFT JOIN oldrecorded
ON oldrecorded.recstatus IN (-3, 11)
AND IF(oldrecorded.programid AND
oldrecorded.seriesid,
oldrecorded.programid =
program.programid
AND oldrecorded.seriesid
= program.seriesid,
oldrecorded.title AND
oldrecorded.subtitle
AND oldrecorded.description
AND oldrecorded.title
= program.title
AND oldrecorded.subtitle
= program.subtitle
AND
oldrecorded.description = program.description
)
LEFT JOIN channel ON program.chanid = channel.chanid
WHERE program.chanid IN
(1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,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,1068,1069,1070,1071,1072,1073,1074,1077,1079,1080,1081,1119,1120,1121,1122,1125,1126,1128,1134,1135,1136,1138,1146,1149,1161,1162,1164,1178,1180,1182,1183,1186,1189,1190,1191,1192,1194,1201,1204,1215,1216,1220,1222,1228,1229,1230,1231,1241,1242,1243,1244,1245,1246,1247,1248,1251,1252,1254,1255,1256,1257,1258,1259,1260,1261,1262,1271,1272,1273,1274,1275,1276,1400,1401,1402,1406,1407,1408,1409,1410,2410,1413,1414,1415,1416,1417,1418,1421,1422,1423,1424,1425,1426,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1476,1481,1482,1484,1486,1501,1502,1503,1504,1505,1516,1517,1518,1520,1522,1524,1528,1530,1550,1551,1553,1555,1556,1557,1559,1560,1586,1603,1615,2702,2703,2704,2705,2707,2709,1725,2725,2730,1800,1814,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1947,1948,1949,1950,1951,1952,1953,1954)
AND (program.endtime > FROM_UNIXTIME('1151532900') AND
program.starttime < FROM_UNIXTIME('1151543700') AND program.starttime
!= program.endtime) GROUP BY program.chanid, program.starttime ORDER
BY program.starttime
[1] => ♦
[2] => 4
[3] => 4
)
file: /var/www/html/mythweb/modules/tv/list.php
line: 49
class:
function: load_all_program_data
type:
args: Array
(
[0] => 1151532900
[1] => 1151543700
)
file: /var/www/html/mythweb/modules/tv/handler.php
line: 40
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/list.php
)
file: /var/www/html/mythweb/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/handler.php
)
==========================================================================
$_SESSION: Array
(
[language] => English
[Theme] => default
[Skin] => default
[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_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[list_time] => 1151532900
[schedules_sortby] => Array
(
[0] => Array
(
[field] => title
[reverse] =>
)
[1] => Array
(
[field] => airdate
[reverse] =>
)
)
[siunits] => NO
[scheduled_recordings] => Array
(
[disp_scheduled] => 1
[disp_duplicates] => 1
[disp_deactivated] => 1
[disp_conflicts] => 1
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[] => Array ( )
[search] => Array
(
[searchstr] => talent
[search_title] => 1
[search_subtitle] => 1
[search_description] =>
[search_category] =>
[search_category_type] =>
)
[video_sortby] => Array
(
[0] => Array
(
[field] => title
[reverse] =>
)
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => mustbethemoney.mine.nu:8080
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4
[HTTP_ACCEPT] =>
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://mustbethemoney.mine.nu:8080/mythweb/tv/upcoming
[HTTP_COOKIE] => mythweb_id=bi6e0vhngevjg60kn5k79lq8e1;
phpMyAdmin=6BbsHParYrPNlPN-i0cw5QHTHB2;
mp3act=ljgo7vj413qoslajnrv66i1sh2
[PATH] => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
[SERVER_SIGNATURE] => <address>Apache/2.0.54 (Fedora) Server at
mustbethemoney.mine.nu Port 80</address>
[SERVER_SOFTWARE] => Apache/2.0.54 (Fedora)
[SERVER_NAME] => mustbethemoney.mine.nu
[SERVER_ADDR] => 192.168.1.103
[SERVER_PORT] => 80
[REMOTE_ADDR] => 71.128.38.98
[DOCUMENT_ROOT] => /var/www/html
[SERVER_ADMIN] => root at localhost
[SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
[REMOTE_PORT] => 63698
[REMOTE_USER] => gabe
[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/html/tv/list
[PHP_SELF] => /mythweb/mythweb.php/tv/list
[argv] => Array ( )
[argc] => 0
[STATUS] => 200
[URL] => /mythweb/tv/list
)
More information about the mythtv-users
mailing list