Opened 12 years ago

Closed 12 years ago

#5400 closed defect (invalid)

Cannot view "previously recorded" after upgrade to DBSchemaVer=1214

Reported by: lane@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version: unknown
Severity: medium Keywords:
Cc: Ticket locked: no


After upgrade to 0.21.20080304-1 (that is from mythfrontend) on gentoo, I can no longer see what has been previously recorded: When I select <Media Library><Previously Recorded> the system "churns" for several minutes then says "The connection to the master backend server has gone away for some reason..."

Then, when I acknowledge that message, the "All Programs" group appears with "There are no recordings available."

There are over 1800 entries in the "recorded" table

Every entry in table 'storagegroups' points to the same directory:

| 4 | Default | myth | /newfs/store/ | | 5 | LiveTV | myth | /newfs/store/ |

and the "recorded" table has only 'Default' in its storagegroup column.

How do I retrieve what has already been recorded?


Change History (3)

comment:1 Changed 12 years ago by anonymous

Lane, can you please provide some more information? e.g. Is the backend actually running? If not, what does it report when you try to start it in a shell? What does 'mythfrontend -v most' reveal?

comment:2 Changed 12 years ago by lane@…

Sure, thanks for the interest.

Indeed, the backend is running. Here is the log output for important,general a few minutes after I restarted mythbackend:

2008-06-02 07:55:56.351 Using runtime prefix = /usr, libdir = /usr/lib 2008-06-02 07:55:56.360 Empty LocalHostName?. 2008-06-02 07:55:56.360 Using localhost value of localhost 2008-06-02 07:55:56.371 New DB connection, total: 1 2008-06-02 07:55:56.377 Connected to database 'mythconverg' at host: 2008-06-02 07:55:56.378 Closing DB connection named 'DBManager0' 2008-06-02 07:55:56.379 Connected to database 'mythconverg' at host: 2008-06-02 07:55:56.380 New DB connection, total: 2 2008-06-02 07:55:56.381 Connected to database 'mythconverg' at host: 2008-06-02 07:55:56.383 Current Schema Version: 1214 Starting up as the master server. 2008-06-02 07:55:56.524 New DB connection, total: 3 2008-06-02 07:55:56.525 Connected to database 'mythconverg' at host: 2008-06-02 07:55:56.604 New DB scheduler connection 2008-06-02 07:55:56.605 Connected to database 'mythconverg' at host: Analog is defined, but isn't attached to a cardinput. 2008-06-02 07:55:56.644 MediaServer:: Loopback address specified - Disabling UPnP 2008-06-02 07:55:56.645 Main::Registering HttpStatus? Extension 2008-06-02 07:55:56.645 mythbackend version: 0.21.20080304-1 2008-06-02 07:55:56.646 Enabled verbose msgs: important general 2008-06-02 07:55:56.648 AutoExpire?: CalcParams?(): Max required Free Space: 1.0 GB w/freq: 15 min 2008-06-02 07:55:59.611 Reschedule requested for id -1. 2008-06-02 07:56:01.772 Scheduled 160 items in 2.2 = 0.46 match + 1.70 place 2008-06-02 07:56:01.777 Seem to be woken up by USER

mythfrontend -v most complains about upgrading mythmusic schema.

I think I'm just going to bite the bullet and reinstall everything.

Again, thanks for your interest.


comment:3 Changed 12 years ago by stuartm

Resolution: invalid
Status: newclosed

Putting this down to database corruption.

Note: See TracTickets for help on using tickets.