November 22, 201312 yr A couple nights ago I was scanning the contents of my Movie folder into my sql database, this was on a Windows 8 PC running XBMC 12.2. The application crashed while this was going on. XBMC on win 8 and 7 crashes constantly. So I put OpenElec on the HTPC. When I booted I was not able to access the contents of the db, sources and advancedsettings were a direct copy from my Rpi. Did a little digging and I found that my database was corrupted, i ran mysqlcheck and fixed the database everything started showing up again on Openelec I watched an episode of TV, and at the end of the episode Openelec rebooted, and kept going through a reboot cycle, same with the Rpi. Tried running mysqlcheck again but I got the following errors. Error : Table 'directorlinktvshow' is read only status : Operation failed MyVideos76.episode Error : Table 'episode' is read only status : Operation failed MyVideos76.files Error : Table 'files' is read only status : Operation failed MyVideos76.genre Error : Table 'genre' is read only status : Operation failed So I brought down the array and rebooted Unraid server, once it booted I was able to run mysqlcheck again. Left it overnight. Today I tried watching Man of Tai Chi, started on my Rpi it played for 5 min, but then I stopped it because I wanted to continue watching in the living room. Once I stopped the playback the Rpi started going through the reboot cycle again. Tried running mysqlcheck again and got the same permission error as before. The db is on /mnt/system which is a user mounted disk dedicated to all my program installations. Another weird thing is my SabNzbd is giving me a permission error on my cache drive all of a sudden. I checked the permissions on the cache drive and system drive the all look ok. Also my subsonic which is on my system drive started giving me permission errors about it not having permissions to the install location. Any ideas?
November 23, 201312 yr Author I will if it happens again. I tried something on for size, I ran the permissions script, shutdown the server, pulled the flash drive, formatted it, installed Unraid 5.0.2, and removed some old entries from the GO script. Now I rebooted, and SabNzbd started downloading again. Right now I'm repairing the mysql db. I'm going to try Man of Tai Chi again.
November 23, 201312 yr Author It seems to be fine now. Since I did all that the sql db is no longer being corrupted and the server is downloading things again.
Archived
This topic is now archived and is closed to further replies.