Opened 9 years ago
Closed 9 years ago
#12574 closed Bug Report - General (Invalid)
TV list fails
| Reported by: | Owned by: | ||
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | MythTV - General | Version: | Unspecified |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
Trying to enter tv listing fails
datetime: 2015-12-29 19:47:59 (AEDT) errornum: 256
error type: User Error
error string: !NoTrans: SQL Error: Table './mythconverg/program' is marked as crashed and last (automatic?) repair failed #144!!
filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
error line: 79
==========================================================================
Backtrace:
file: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php line: 79
class:
function: trigger_error
type: args: Array
(
[0] => SQL Error: Table './mythconverg/program' is marked as crashed and last (automatic?) repair failed #144 [1] => 256
)
file: /usr/share/mythtv/mythweb/classes/Database.php line: 261
class: Database_Query_mysql
function: execute
type: -> args: Array
(
[0] => Array
(
[0] => Array ( )
)
)
file: /usr/share/mythtv/mythweb/classes/Database.php line: 324
class: Database
function: query
type: -> args: Array
(
[0] => SELECT TO_DAYS(min(starttime)) - TO_DAYS(NOW()) FROM program [1] => Array ( )
)
file: /usr/share/mythtv/mythweb/modules/tv/list.php line: 69
class: Database
function: query_col
type: -> args: Array
(
[0] => SELECT TO_DAYS(min(starttime)) - TO_DAYS(NOW()) FROM program
)
file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php line: 29
class:
function: date_select
type: args: Array
(
[0] => id="date_select" onchange="list_update($('date_select')[$('date_select').selectedIndex].value);"
)
file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php line: 78
class:
function: require_once
type: args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php
)
file: /usr/share/mythtv/mythweb/modules/tv/list.php line: 45
class:
function: require_once
type: args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php
)
file: /usr/share/mythtv/mythweb/modules/tv/handler.php line: 82
class:
function: require_once
type: args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/list.php
)
file: /usr/share/mythtv/mythweb/mythweb.php line: 35
class:
function: require_once
type: args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
)
==========================================================================
$_SESSION: Array (
[cache_engine] => Cache_Null [stream] => Array
(
[include_user_and_password] =>
)
[prefer_channum] => 1 [recorded_pixmaps] => 1 [guide_favonly] => [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 20 [max_stars] => 4 [star_character] => ★ [show_popup_info] => 1 [show_channel_icons] => 1 [sortby_channum] => 1 [recorded_paging] => [genre_colors] => 1 [show_video_covers] => 1 [settings] => Array
(
[screens] => Array
(
[tv] => Array
(
[upcoming recordings] => Array
(
[title] => on [channel] => on [record date] => on [length] => on
)
)
)
[last] => Array
(
)
[host] => 192-168-1-14.tpgi.com.au
)
[backend] => Array
(
[192.168.1.5] => Array
(
[proto_version] => Array
(
[last_check_version] => 77 [last_check_time] => 1451375115
)
)
[timezone] => Array
(
[value] => Australia/Melbourne? [last_check_time] => 1451375115
)
)
[language] => English [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 (%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 [date_job_status] => %a %b %e, %Y, %I:%M %p [time_format] => %I:%M %p [tv] => Array
(
[last] => Array
(
[0] => list
)
[show_advanced_schedule] => 1
)
[list_time] => 1451378700 [recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] => 1
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[recording_details] => Array
(
[show_Conflict] => 1 [show_PreviousRecording] => 1 [show_EarlierShowing] => 1 [show_CurrentRecording] => 1 [show_WillRecord] => 1
)
[video_sortby] => Array
(
[0] => Array
(
[field] => title [reverse] =>
)
)
[scheduled_recordings] => Array
(
[disp_scheduled] => 1 [disp_duplicates] => 1 [disp_deactivated] => [disp_conflicts] => 1 [disp_recgroup] => [disp_title] =>
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[schedules_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[search] => Array
(
[type] => q [s] => mekong [ctype] => Array
(
)
[categories] => Array
(
[0] => All
)
[stars_gt] => 0 [stars_lt] => 1 [starttime] => now [endtime] => + 2 weeks [as] => Array
(
[0] => cambodian
)
[af] => Array
(
[0] => Array
(
[0] => title
)
)
[aj] => Array
(
[0] => AND
)
[hd] => [commfree] => [unwatched] => [scheduled] => [generic] => [distinctTitle] => [airdate_start] => [airdate_end] =>
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[recorded_title] => Agatha Christie's Poirot [] => Array ( ) [recorded_recgroup] =>
)
==========================================================================
$_SERVER: Array (
[REDIRECT_STATUS] => 200 [hostname] => mythbuntu [HTTP_HOST] => 192.168.1.5 [HTTP_CONNECTION] => keep-alive [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit?/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36 [HTTP_REFERER] => http://192.168.1.5/mythweb/ [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8,vi;q=0.6,id;q=0.4,ms;q=0.2 [HTTP_COOKIE] => mythweb_id=kjeekfagltm8jf25nabh9n94o3 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] => <address>Apache/2.4.7 (Ubuntu) Server at 192.168.1.5 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.4.7 (Ubuntu) [SERVER_NAME] => 192.168.1.5 [SERVER_ADDR] => 192.168.1.5 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.1.11 [DOCUMENT_ROOT] => /var/www [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] => /var/www [SERVER_ADMIN] => [no address given] [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php [REMOTE_PORT] => 37312 [REMOTE_USER] => colintan [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] => /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_USER] => colintan [PHP_AUTH_DIGEST] => username="colintan", realm="MythTV", nonce="CSpVegUoBQA=d82a41c55ac5d8f14041695f82360fd14e2df77f", uri="/mythweb/tv/list", algorithm=MD5, response="049b756968e55f8c39eb2878a8f63da4", qop=auth, nc=00000002, cnonce="582ae8214c292d78" [REQUEST_TIME_FLOAT] => 1451378879.923 [REQUEST_TIME] => 1451378879 [STATUS] => 200 [URL] => /mythweb/tv/list [HTTP_PORT] => 80
)
==========================================================================
$constant_listuser?: Array (
[ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024 [WebDBSchemaVer] => 4 [dupsin_all] => 15 [dupsin_newepisodes] => 16 [dupsin_oldrecorded] => 2 [dupsin_recorded] => 1 [error_email] => [gb] => 1073741824 [hostname] => mythbuntu [http_host] => 192.168.1.5 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => tv [modules_path] => /usr/share/mythtv/mythweb/modules [num_time_slots] => 36 [prefer_channum] => 1 [rectype_always] => 4 [rectype_daily] => 2 [rectype_dontrec] => 8 [rectype_findone] => 6 [rectype_once] => 1 [rectype_override] => 7 [rectype_template] => 11 [rectype_weekly] => 5 [root] => /mythweb/ [root_auth_url] => http://192.168.1.5/mythweb/ [root_url] => http://192.168.1.5/mythweb/ [searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4 [searchtype_power] => 1 [searchtype_title] => 2 [skin] => default [skin_img_url] => http://192.168.1.5/mythweb/skins/default/img/ [skin_url] => http://192.168.1.5/mythweb/skins/default/ [star_character] => ★ [stream_url] => http://192.168.1.5:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/
)
This is your problem
The program table in the database has become corrupt.
Make sure the drive with the DB on hasn't run out of free space and try running optimize_mythdb.pl
If you search the mailing list archives you will find lots of help on this subject and other things to try.