[mythtv-users] Backend connects but no tv / listings - possible database corruption?

[Big Wave Dave]

On 6/20/06, Christopher Friend <christopher_friend at hotmail.com> wrote:
> Ok sorry for the kinda repost, but just trying to clear some stuff up now
> i've got a better idea of what's happening....
>
>
> I'm having problems getting the frontend to connect to the backend. It's set
> up alright, and I can access music / recorded programs from mythweb /
> frontend / nuvexport. But I can't access live tv or any info on listings /
> recording schedules.
>
> I don't get any errors about the backend not being connected.
> Mythfilldatabase starts and ends with:
>
> 2006-06-20 16:19:19.675 Using runtime prefix = /usr
> 2006-06-20 16:19:19.821 New DB connection, total: 1
> 2006-06-20 16:19:19.828 Connected to database 'mythconverg' at host:
> localhost
> 2006-06-20 16:19:19.890 New DB connection, total: 2
> 2006-06-20 16:19:19.891 Connected to database 'mythconverg' at host:
> localhost
>
> trying to watch tv does this:
>
> 2006-06-20 16:28:25.069 Connecting to backend server: 127.0.0.1:6543 (try 1
> of 5)
> 2006-06-20 16:28:25.079 Using protocol version 26
> 2006-06-20 16:28:25.106 TV: Attempting to change from None to WatchingLiveTV
> 2006-06-20 16:28:25.122 Using protocol version 26
> 2006-06-20 16:28:45.132 ReadStringList timeout (quick).
> 2006-06-20 16:28:45.132 RemoteEncoder::SendReceiveStringList(): No response.
> 2006-06-20 16:28:45.134 GetEntryAt(-1) failed.
> 2006-06-20 16:28:45.135 EntryToProgram(0 at Thu Jan 1 01:00:00 1970) failed to
> get pginfo
> 2006-06-20 16:28:45.135 TV Error: LiveTV not successfully started
> 2006-06-20 16:28:45.135 TV Error: LiveTV not successfully started
> 2006-06-20 16:28:45.153 TV: Deleting TV Chain in destructor
>
>
> It was all working fine a few days ago, then I moved onto a new network,
> changed a couple network based settings (but not in myth, like I say it
> still works ok with some stuff...). Also, due to kde not falling back on
> monitor settings when i changed to one with a lower refresh rate, I had to
> manually reset from the case button. Last time I did this I had to rebuild
> the mythweb sessions database, but nothing else has ever been affected.
>
> Running a check on the mythconverg database gives:
>
> mythconverg.callsignnetworkmap                     OK
> mythconverg.capturecard                            OK
> mythconverg.cardinput                              OK
> mythconverg.channel                                OK
> mythconverg.codecparams                            OK
> mythconverg.credits                                OK
> mythconverg.dtv_multiplex                          OK
> mythconverg.dtv_privatetypes                       OK
> mythconverg.dvdinput                               OK
> mythconverg.dvdtranscode                           OK
> mythconverg.favorites                              OK
> mythconverg.filemarkup                             OK
> mythconverg.gallerymetadata                        OK
> mythconverg.gamemetadata                           OK
> mythconverg.gameplayers                            OK
> mythconverg.housekeeping                           OK
> mythconverg.inuseprograms                          OK
> mythconverg.jobqueue                               OK
> mythconverg.jumppoints                             OK
> mythconverg.keybindings                            OK
> mythconverg.keyword                                OK
> mythconverg.mamemetadata                           OK
> mythconverg.mamesettings                           OK
> mythconverg.musicmetadata                          OK
> mythconverg.musicplaylist                          OK
> mythconverg.mythlog                                OK
> mythconverg.mythweb_sessions                       OK
> mythconverg.neskeyword                             OK
> mythconverg.nestitle                               OK
> mythconverg.netflix                                OK
> mythconverg.networkiconmap                         OK
> mythconverg.newssites                              OK
> mythconverg.oldfind                                OK
> mythconverg.oldprogram                             OK
> mythconverg.oldrecorded                            OK
> mythconverg.people                                 OK
> mythconverg.phonecallhistory                       OK
> mythconverg.phonedirectory                         OK
> mythconverg.pidcache                               OK
> mythconverg.playgroup                              OK
> mythconverg.profilegroups                          OK
>
> and it hangs there. google'd it and it seems that after profilegroups there
> should be a load of program type stuff. so that might be the problem.
>
> If it is, I've got an old backup of mythconverg (well, i hope that's what
> the file called "mythtv_backup.sql" i've got somewhere is...). Any ideas if
> restoring that would fix stuff, and what would it break? I've got a load of
> new recordings that I still wanna access, so will it stop access to them or
> what? Any help appreciated...
>
> Christopher
>

I recently had a /somewhat/ similar situation.  It ended up being that
my computer lost its time.... as such it was showing it was 2002
instead of 2006... making the listing show "unknown".  So, you may
want verify you have the right date and time.  I doubt its your
problem... but its an easy thing to check.

Dave

-- 

----------------------------------------------------------
Are Your Friends Lemmings?
-- http://www.lemmingshirts.com