1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

database index failing...troubleshoot?

Discussion in 'TiVo Underground' started by angra, Nov 18, 2017.

  1. angra

    angra Member

    171
    1
    Apr 12, 2002
    One of my S3 tivos has guide data, but the indexing is failing, resulting in SPs no longer working, and guide filtering showing no matches. Examining SPs finds no upcoming showings of the series despite there being showings of the series present in the guide.

    in /var/log/tverr, I see the following:


    Nov 19 02:10:39 (none) DbIndexWriter[1384]: Finish is returning 0x1102f
    Nov 19 02:10:47 (none) DbMasterIndexer[1384]: Error building showing index: 0x1102f
    Nov 19 02:10:47 (none) DbMasterIndexer[1384]: missing file /GuideIndexV3.temp/Genre.key
    Nov 19 02:10:47 (none) DbMasterIndexer[1384]: Program guide index files were not built

    Anyone have insight on what could be causing this and how to repair?
     
  2. rpj22

    rpj22 New Member

    8
    1
    Mar 26, 2016
    I haven't seen this particular symptom, but I have had several problems over the years stemming from the fragility of the indexes. The solution for me was always to clear things out by going through guided setup with a bogus zip code (12345 always worked for me), followed by doing guided setup again with your actual zip.
     
  3. angra

    angra Member

    171
    1
    Apr 12, 2002
    Thanks! That's an idea I have not tried. I did go through a guided setup, but only for my current lineup.

    I have tried a few things, including a KS57 and a KS52. Neither solved it.

    I removed a bunch of channels from my "channels you receive" list. Am currently running dbgc-mcp to see if that helped. This was in response to seeing the following in tverr:


    Nov 19 13:53:36 (none) DbGc::LogMemoryUsage[2726]: name=dbgc-mcp pool TOO FULL limit/inUse/poolSize = ( 1048576/ 1052008/ 4167128) : After DbShowingIndexer::VisitAllStationDays
    Nov 19 13:53:47 (none) DbIndexWriter[2726]: Finish is returning 0x1102f
    Nov 19 13:53:55 (none) DbGc::LogMemoryUsage[2726]: name=dbgc-mcp pool TOO FULL limit/inUse/poolSize = ( 1048576/ 1052008/ 4167128) : pSeriesIndexerM
    Nov 19 13:53:55 (none) DbMasterIndexer[2726]: Error building showing index: 0x1102f
    Nov 19 13:53:55 (none) DbGc::LogMemoryUsage[2726]: name=dbgc-mcp pool TOO FULL limit/inUse/poolSize = ( 1048576/ 1052008/ 4167128) : After running pShowingIndexer
    Nov 19 13:53:55 (none) DbMasterIndexer[2726]: missing file /GuideIndexV3.temp/Genre.key
    Nov 19 13:53:55 (none) DbMasterIndexer[2726]: Program guide index files were not built

     
  4. Sparky1234

    Sparky1234 Totally

    1,241
    118
    May 8, 2006
    Clean and restore?
     
  5. jmbach

    jmbach der Neuerer

    1,994
    94
    Jan 1, 2009
    Consider running the drive through diagnostic testing to make sure there are no bad or weak spots on the drive.


    Sent from my iPad using Tapatalk
     
  6. angra

    angra Member

    171
    1
    Apr 12, 2002
    removing channels I don't actually get from "Channels I receive" and a few rounds of

    dbgc-mcp -fg-gc
    dbgc-mcp -fg-index

    seem to have brought it back to life so far.
     
  7. angra

    angra Member

    171
    1
    Apr 12, 2002
    So, this helped for a while, but the problems returned.

    I have 2 tivoHD in my house - one that I had upgraded swap to 256MB and the failing one that had a stock swap.

    Using MFSTools 3.2, it was not super painful to increase SWAP to 1G. So far, all indexing has succeeded.
     
    kpeters59 likes this.

Share This Page