Opened 12 years ago
Last modified 12 years ago
#10831 closed Bug Report - Crash
Corrupted record in database — at Initial Version
| Reported by: | Owned by: | ||
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | MythTV - General | Version: | 0.25 |
| Severity: | medium | Keywords: | msql corrupt record |
| Cc: | Ticket locked: | no |
Description
mythbackend version: fixes/0.25 [0.25-6.fc16
MythBackend?: Starting up as the master server. 2012-06-13 19:12:30.690212 E [1675/1675] CoreContext? mythdbcon.cpp:823 (prepare) - Error preparing query: SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM oldrecorded WHERE programid <> 2012-06-13 19:12:30.690241 E [1675/1675] CoreContext? mythdbcon.cpp:825 (prepare) - Driver error was [2/145]: QMYSQL3: Unable to prepare statement Database error was: Table './mythconverg/oldrecorded' is marked as crashed and should be repaired 2012-06-13 19:12:30.690272 E [1675/1675] CoreContext? mythdb.cpp:192 (DBError) - DB Error (CheckProgramIDAuthorities): Query was: SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM oldrecorded WHERE programid <> No error type from QSqlError? Strange... 2012-06-13 19:12:30.690284 I [1675/1675] CoreContext? programinfo.cpp:2052 (CheckProgramIDAuthorities) - Found 1 distinct programid authorities 2012-06-13 19:12:30.690528 I [1675/2430] Scheduler mythdbcon.cpp:422 (getStaticCon) - New static DB connectionSchedCon 2012-06-13 19:12:30.695036 E [1675/2430] Scheduler mythdbcon.cpp:823 (prepare) - Error preparing query: UPDATE oldrecorded SET recstatus = :RSABORTED WHERE recstatus = :RSRECORDING OR recstatus = :RSTUNING 2012-06-13 19:12:30.695049 E [1675/2430] Scheduler mythdbcon.cpp:825 (prepare) - Driver error was [2/145]: QMYSQL3: Unable to prepare statement
PDF showing partial mysql.php trace back