Login at Kodi Home

DejaVu · 2011-11-06, 20:09

It seems like every 20 minutes, my ATV2 is completely giving up and just stops.

I have managed to hunt down the logs, but as far as I can see, there is no explanation in the Debug logs. It just literally bums out and has to be reloaded.

Is this a bug that the Dev's are aware of?

Rarred up my Logs as Pastebin did not allow a large 3Mb 'Debug' paste unless I upgraded to 'Pro' Rolleyes

This (logs.gif) image is a RAR file with the logs in (117Kb!).
Right click, save, rename logs.gif to logs.rar and Extract! Wink

.
Help would be hugely appreciated, it's getting quite annoying now.

If your wondering how this image was made.

DejaVu · (This post was last modified: 2011-11-06, 20:31 by DejaVu.)

It just happened again and the only explanation I can see that is reocurring is the Log file hits just over 3Mb and it bums out. I restart and the XBMC.log starts from scratch.

Can the ATV2 only cope with a small Log file I wonder?!

EDIT
Just looked through all the settings to turn anything that is in Debug mode. But they are all off!?
All updates for Apple are blocked and all things recommended in the Wiki are installed. Wink

DejaVu · 2011-11-08, 04:41

I decided to delete and rebuild the library as mentioned in another thread.

It was fine for a while, but seems the library gets to a certain point and breaks again almost like their is a limit on the size of the library.

I'm now considering one central MySQL database/library created by my main server. Would this sort it once and for all?

g-off · 2011-11-08, 05:55

You manage to get a 3mb logfile in 20 minutes?! There must be a busted skin/addon or something

Make sure you are not updating the library on startup and that you have thumbnails turned off in system-settings-file list.

Try and post a logfile. You really haven't provided much information at all. Use megaupload or something if it is too big for pastebin.

DejaVu · 2011-11-08, 20:05

Log file IS posted in the Image in the first post. Wink

DejaVu · 2011-11-08, 20:50

The log file being so huge it to do with millions of entries that are all like -

Code:
07:57 T:107827200   DEBUG: RunQuery took 39 ms for 40 items query: select * from episodeview where idShow IN (154,227,342) and (c12=2 or (c12=0 and (c15=0 or c15=2)))

07:57 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:57 T:107827200   DEBUG: Previous line repeats 1 times.

07:57 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=154) order by idShow

07:57 T:107827200   DEBUG: RunQuery took 43 ms for 52 items query: select * from episodeview where idShow IN (154,227,342) and (c12=3 or (c12=0 and (c15=0 or c15=3)))

07:58 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:58 T:107827200   DEBUG: Previous line repeats 1 times.

07:58 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow

07:58 T:107827200   DEBUG: RunQuery took 5 ms for 3 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile  join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow IN (155,228,343)  group by episode.c12

07:58 T:107827200   DEBUG: RunQuery took 4 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow IN (155,228,343)

07:58 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:58 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow

07:58 T:107827200   DEBUG: RunQuery took 5 ms for 0 items query: select * from episodeview where idShow IN (155,228,343) and c12=0

07:58 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:58 T:107827200   DEBUG: Previous line repeats 1 times.

07:58 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow

07:58 T:107827200   DEBUG: RunQuery took 8 ms for 12 items query: select * from episodeview where idShow IN (155,228,343) and (c12=1 or (c12=0 and (c15=0 or c15=1)))

07:59 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:59 T:107827200   DEBUG: Previous line repeats 1 times.

07:59 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow

07:59 T:107827200   DEBUG: RunQuery took 29 ms for 14 items query: select * from episodeview where idShow IN (155,228,343) and (c12=2 or (c12=0 and (c15=0 or c15=2)))

07:59 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:59 T:107827200   DEBUG: Previous line repeats 1 times.

07:59 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=155) order by idShow

07:59 T:107827200   DEBUG: RunQuery took 6 ms for 1 items query: select * from episodeview where idShow IN (155,228,343) and (c12=3 or (c12=0 and (c15=0 or c15=3)))

07:59 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:59 T:107827200   DEBUG: Previous line repeats 1 times.

07:59 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow

07:59 T:107827200   DEBUG: RunQuery took 7 ms for 3 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile  join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = 296  group by episode.c12

07:59 T:107827200   DEBUG: RunQuery took 2 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow = 296

07:59 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

07:59 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow

07:59 T:107827200   DEBUG: RunQuery took 25 ms for 0 items query: select * from episodeview where idShow = 296 and c12=0

07:59 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:00 T:107827200   DEBUG: Previous line repeats 1 times.

08:00 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow

08:00 T:107827200   DEBUG: RunQuery took 30 ms for 24 items query: select * from episodeview where idShow = 296 and (c12=1 or (c12=0 and (c15=0 or c15=1)))

08:00 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:00 T:107827200   DEBUG: Previous line repeats 1 times.

08:00 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow

08:00 T:107827200   DEBUG: RunQuery took 11 ms for 24 items query: select * from episodeview where idShow = 296 and (c12=2 or (c12=0 and (c15=0 or c15=2)))

08:00 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:01 T:107827200   DEBUG: Previous line repeats 1 times.

08:01 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=296) order by idShow

08:01 T:107827200   DEBUG: RunQuery took 8 ms for 7 items query: select * from episodeview where idShow = 296 and (c12=3 or (c12=0 and (c15=0 or c15=3)))

08:01 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:01 T:107827200   DEBUG: Previous line repeats 1 times.

08:01 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow

08:01 T:107827200   DEBUG: RunQuery took 35 ms for 8 items query: select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile  join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = 297  group by episode.c12

08:01 T:107827200   DEBUG: RunQuery took 22 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie where movielinktvshow.idShow = 297

08:01 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:01 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow

08:01 T:107827200   DEBUG: RunQuery took 6 ms for 0 items query: select * from episodeview where idShow = 297 and c12=0

08:01 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:01 T:107827200   DEBUG: Previous line repeats 1 times.

08:01 T:107827200   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=297) order by idShow

08:01 T:107827200   DEBUG: RunQuery took 31 ms for 11 items query: select * from episodeview where idShow = 297 and (c12=1 or (c12=0 and (c15=0 or c15=1)))

08:01 T:107827200   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

08:01 T:107827200   DEBUG: Previous line repeats 1 times.

chuckles · 2011-11-08, 22:24

DejaVu Wrote:Log file IS posted in the Image in the first post.

I must be new to the internet, I cant see any image but those in your sig

g-off · 2011-11-08, 22:27

You are too clever for me. I can't find the magical logfile in the first post. I think wally might have got bored and taken it home with him.

DejaVu · (This post was last modified: 2011-11-08, 22:56 by DejaVu.)

Right click the XBMC Image.

This one -
http://s9.postimage.org/wgp3x0919/logs.gif

Save it to your computer. Rename it to XBMC.RAR and extract it.

WELCOME TO THE INTERNET!! :p

I dont get how my log is getting so big so quick. It has DEBUG written everywhere and there at least 10 entries a second.
Debugging is disabled in Settings > System > Debugging.

**Memphiz** · 2011-11-08, 23:00

DejaVu Wrote:This one -
http://s9.postimage.org/wgp3x0919/logs.gif

Save it to your computer. Rename it to XBMC.RAR and extract it.

WELCOME TO THE INTERNET!! :p

sorry ... but i can't find the right words for this ... i think this is really worth ignoring you ...

ps: my real statement is encrypted in the whitespaces ...

DejaVu · 2011-11-08, 23:19

Because I used an inventive way of uploading and compressing a 3Mb log file?
I thought it was clever, unique and great bandwidth saving and did not make Pastebin 'Connection Reset'.

Gives me a warm fuzzy feeling knowing I spend a lot of time trying to help others! Thanks.

For those that would like to try to help me solve this issue, which seems to me that the most recent ATV2 nightly's are debugging by default without the option of switching it off, here is my most recent Log that Ubuntu's Pastebin did allow me to upload.

12488 Lines in 30 minutes is a bit much IMO.
Might take a while to load... It's BIG.

http://pastebin.ubuntu.com/732440/

In the meantime, I'm going to remove and reinstall XBMC back to my ATV2 with the latest.

g-off · 2011-11-09, 02:16

Turn off auto library update on startup and make another logfile.

Get the logfile and print it double-spaced on a daisy-wheel printer using yellow paper.
Using a HB pencil make sure that all zeros are slashed to ensure readability.
Put the printout into a attache case and bury at a crossroad.
Store the GPS location of crossroad using steganography into a picture of a cute kitten.
Upload the picture to imgur.com
Broadcast the url from imgur using a Numbers Station.
And lastly: Check the complicated klugded method that you use to post logfiles actually works on browsers other than the one you are using. Because I don't see shit with either Opera or IE.

~~Ned Scott~~ · 2011-11-09, 02:33

I had no problem getting the log file.

DejaVu · 2011-11-09, 03:10

I can always appreciate a good bit of sarcasm.

So I'm kinda guessing the OP doesn't look like this on your computer...!?
Broken X perhaps, IE has never liked the internet.

DejaVu - Courtesy of Google Chrome Wrote:
(Does this one show up I wonder!!)

I thought the image was hard to miss myself... Laugh

@ned.
Thank you for saving my sanity.
I thought it was just me going bonkers.

g-off · (This post was last modified: 2011-11-09, 04:08 by g-off.)

Webkit browsers (Safari, Chrome) allow malformed gifs to be displayed.
Opera displays nothing.
Firefox displays nothing.
IE shows a broken image icon that you cannot do anything with..