[Roums]

Hello everybody,

since yesterday I am not able to brows my TV Shows anymore, it's just blank.
If I choose to browse files, I see the directories but I can't log into them.

I look at the xbmc log and saw some MySQL errors (see http://pastebin.com/2Ms37Uaz for the log file)

Then I logged into MySQL Query Browser, and saw that I can only see one database, xbmc_video, which is my old video database. xbmc_video58 and xbmc_music18 are not displayed.

I used another login, the one I use for the connection of XBMC from Windows and the AppleTV2, and I can see the xbmc_video58 and xbmc_music18 databases.

This is the first weird point, as I always was able to see al my databases with both logins.

I then ran a command, just to check:

Code:

SELECT count(1) FROM tvshowview LIMIT 1

And got:

Table './xbmc_video58/episode' is marked as crashed and should be repaired

I then launched MySQL Administrator to check the tables, here is the result :

http://pastebin.com/eryLvZvE

I don't know what happened, I have a backup of my Database from 2 weeks ago, so it is not really a problem for me, but I think I should notice it to the community.

If you need further information to investigate, just let me know it.

[xbmcg]

just delete the databases and rescrape your media. It will create a new db.

[Roums]

I have 1500 movies and around 2000 tv episodes. I don't intent to rescrap them again (especially because I always have to make manual adjustments to some titles/thumbnails/...)

And I said I have a backup, I am just reporting a problem in case it can be useful to the devs.

[jmarshall]

The log errors are after the fact, so no use unfortunately. Thanks for posting it anyway.

[Roums]

That's true, it's after.

I restored my database, everything was working fine and it happened again.
I wonder if it happens when I access to the MySQL database with AppleTV2 and Windows at the same time.

Last time it was for the Series, but this time it is for the Movies, I can go to "Movies" in the Library, but not "Title". The "Working" icon is displayed but nothing happens, and in the xbmc log file I have :

15:08:51 T:7364 ERROR: SQL: Undefined MySQL error: Code (1194)
Query: select genre.idgenre,genre.strgenre,count(1),count(files.playCount) from genre join genrelinkmovie on genre.idgenre=genrelinkmovie.idgenre join movie on genrelinkmovie.idMovie=movie.idMovie join files on files.idFile=movie.idFile group by genre.idgenre
15:08:51 T:7364 ERROR: CVideoDatabase::GetNavCommon failed
15:08:51 T:10848 ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://1/1/
15:08:51 T:10848 ERROR: CGUIMediaWindow::GetDirectory(videodb://1/1/) failed
15:09:21 T:7364 ERROR: CVideoDatabase::GetMoviesByWhere failed
15:09:21 T:10848 ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://1/2/
15:09:21 T:10848 ERROR: CGUIMediaWindow::GetDirectory(videodb://1/2/) failed

Here is my current Windows xbmc.log file: http://pastebin.com/MazaNu7S
The xbmc.old.log: http://pastebin.com/QD3aDztb

My AppleTV2 xbmc.log: http://pastebin.com/uS8FHJtg
AppleTV2 xbmc.old.log: http://pastebin.com/pyzYXY9D

XBMC has only be restarted once on the ATV2 since the restore, and yesterday everything was working fine.

I wanted to post MySQL logs but I can't have access them remotely, and as MySQL is installed on my NAS there isn't many option to have access to them (no MySQL Workbench).
I logged into phpMyAdmin to have a look, but there isn't a lot of informations (I don't have a "Binary Log" tab, just statistical informations when I look into the tab "State").

As Eden Beta has created new MySQL databases (xbmc_video58 and xbmc_music18) do I have to change my advancedsettings.xml from :

<videodatabase>
<type>mysql</type>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<name>xbmc_music</name>
</musicdatabase>

To:

<videodatabase>
<type>mysql</type>
<name>xbmc_video58</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<name>xbmc_music18</name>
</musicdatabase>

It is just a guess because there is no real reason why it would cause a crash on my tables.

Edit: I could access and copy MySQL log file: http://pastebin.com/QMvpiX2M
From what I see, it's not really helpful, it just says there is an error (we can see there was no more errors after the restore, and new errors showed up today à 14h37)

Maybe I should try to launch MySQL with the request or binary log option to investigate.

Just for the record: before upgrading to Eden Beta 1, I never had any problem with my XBMC database.

[imtammer]

I am having the same issue...i completely wiped my original database and am attempting to have xbmc eden recreate the library..but unless i let it name itself it will not work..however when i let it name myself it creates the DB using a diff char set than latin1_general_ci...when i specify xbmc_video58 and xbmc_music18 (as that what it has created) in the advancedsettings.xml i get messages like this in my log:

12:10:44 T:6872 ERROR: Unable to open database: xbmc_music1818 [1049](Unknown database 'xbmc_music1818')
12:10:44 T:1336 ERROR: Unable to open database: xbmc_video5858 [1049](Unknown database 'xbmc_video5858')
12:10:44 T:6872 ERROR: Unable to open database: xbmc_music1817 [1049](Unknown database 'xbmc_music1817')
12:10:44 T:1336 ERROR: Unable to open database: xbmc_video5857 [1049](Unknown database 'xbmc_video5857')

prior to eden the DB connection worked flawlessly. Any constructive input as to what we are doing wrong would be welcome.

here is my xbmc log:

http://pastebin.com/yu2UXE9x

[Ned Scott]

Don't change <name> to point to <name>xbmc_video58</name>. XBMC will automatically add the DB number to the end, so if you manually add it that will make XBMC look for xbmc_video5858.

Be sure to check out HOW-TO:Synchronize multiple XBMC libraries#Upgrading XBMC from v10 to v11

[Roums]

Well, it is a different problem from the one I mentionned.
Mine is to have corrupted tables since I updated to Eden Beta 1.

Maybe I should run xbmc in debug mode to figure this out, I couldn't see anything useful in the logs.