Upgrading from FroDo to Gotham - MYSQL Issues
#31
(2014-07-26, 15:23)black_eagle Wrote: Yeah, the log you posted over there is showing a lot of 'table does not exist' errors which in basic terms means xbmc is expecting to find data in the db, but that data is missing for some reason.

Now, you said that initially, everything was working properly, but that after several hours, stuff 'disappeared'. In my experience, stuff doesn't just disappear, it goes for a reason. The fact that complete tables are missing is a bit worrying. I'd have thought that they were maybe not created in the first place, but seeing as you said it was OK to start with, I'd rule that option out.

Is it possible someone has dropped the tables via MySQL maintenance ? Is it possible your HDD is corrupted/failing ?

Hi,

Yeah, I really can't explain it. All the configured clients were scraping data and all showed album art, etc. They all synched the watched status as well. Then I went to sleep and woke up in the morning and it was all gone. For safe measure I blew away the DB's and started again, same thing happened the following morning. Nobody else has access to the servers in my house and the HDD is in good health. MySQL is the only thing installed on that drive except for the UnMenu plugin for UnRAID.

It still won't provide the data to the clients.
Reply
#32
(2014-07-29, 00:44)Tony_YYZ Wrote: All the configured clients were scraping data and all showed album art, etc.

What does this mean ? Don't scrape with multiple clients with a MySQL set up. Just scrape with one. Set it going and let it do it's thing. You can have the other clients connected to the db, but don't set them off scraping. Also, is it possible at all that one of your clients is still on Frodo and is attempting to upgrade an old db to Gotham ?

I'm just trying to think out loud here really and find a reason for the missing tables. Do you have any MySQL logs that you can look at on your NAS that might give you a clue as to why entire tables appear to be dropped from the db?

If it was me, I'd scrape with just one machine, wait until the db's are complete, shut down the client and then immediately copy the music and video databases to somewhere safe as a backup. Get some logging going on the NAS and one client, and see if the issue repeats. If yes, there will be something in some log somewhere to show why. If not, add a second client. Repeat until problem re-appears. Last client connected must be causing the issue.

If the tables are dropped when no clients are connected, then it's the NAS doing something weird. I know this is a long winded way of trouble shooting, but it should give you the answer.

*** EDIT ***

As a further thought, lets make sure the db is getting created correctly. Put one client in debug. Exit it, restart it and set it off scraping. Let it do half a dozen movies or so and then stop it and stick the log on pastebin or xbmclogs and post a linkback to it. That should show if it's writing the correct info into the db tables as something is definitely squiffy here !!
Learning Linux the hard way !!
Reply
#33
(2014-07-29, 10:08)black_eagle Wrote:
(2014-07-29, 00:44)Tony_YYZ Wrote: All the configured clients were scraping data and all showed album art, etc.

What does this mean ? Don't scrape with multiple clients with a MySQL set up. Just scrape with one. Set it going and let it do it's thing. You can have the other clients connected to the db, but don't set them off scraping. Also, is it possible at all that one of your clients is still on Frodo and is attempting to upgrade an old db to Gotham ?

I'm just trying to think out loud here really and find a reason for the missing tables. Do you have any MySQL logs that you can look at on your NAS that might give you a clue as to why entire tables appear to be dropped from the db?

If it was me, I'd scrape with just one machine, wait until the db's are complete, shut down the client and then immediately copy the music and video databases to somewhere safe as a backup. Get some logging going on the NAS and one client, and see if the issue repeats. If yes, there will be something in some log somewhere to show why. If not, add a second client. Repeat until problem re-appears. Last client connected must be causing the issue.

If the tables are dropped when no clients are connected, then it's the NAS doing something weird. I know this is a long winded way of trouble shooting, but it should give you the answer.

*** EDIT ***

As a further thought, lets make sure the db is getting created correctly. Put one client in debug. Exit it, restart it and set it off scraping. Let it do half a dozen movies or so and then stop it and stick the log on pastebin or xbmclogs and post a linkback to it. That should show if it's writing the correct info into the db tables as something is definitely squiffy here !!


Sorry, I might have confused the situation. I didn't mean that all clients were scraping. I meant that they were all showing the data that one client scrapes and populates the DB with.

I just took a quick look at the NAS logs and came across the following, i noticed the same time stamp (3:40am) on the mysql files/folders after I started experiencing this issue:

Code:
Jul 29 03:40:01 Watchtower logger: mover started
Jul 29 03:40:01 Watchtower logger: skipping apps/
Jul 29 03:40:01 Watchtower logger: moving mysql/
Jul 29 03:40:01 Watchtower logger: ./mysql/mysql-bin.000003
Jul 29 03:40:01 Watchtower logger: >f+++++++++ mysql/mysql-bin.000003
Jul 29 03:40:09 Watchtower logger: ./mysql/Watchtower.err
Jul 29 03:40:09 Watchtower logger: >f+++++++++ mysql/Watchtower.err
Jul 29 03:40:09 Watchtower logger: ./mysql/mysql/procs_priv.MYD
Jul 29 03:40:09 Watchtower logger: >f+++++++++ mysql/mysql/procs_priv.MYD
Jul 29 03:40:09 Watchtower logger: ./mysql/mysql/procs_priv.MYI
Jul 29 03:40:09 Watchtower logger: >f+++++++++ mysql/mysql/procs_priv.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/columns_priv.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/columns_priv.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/columns_priv.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/columns_priv.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/tables_priv.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/tables_priv.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/tables_priv.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/tables_priv.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/db.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/db.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/db.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/db.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/host.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/host.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/host.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/host.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/user.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/user.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql/user.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/mysql/user.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/mysql
Jul 29 03:40:10 Watchtower logger: ./mysql/MyVideos78/directorlinkepisode.MYD
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/MyVideos78/directorlinkepisode.MYD
Jul 29 03:40:10 Watchtower logger: ./mysql/MyVideos78/directorlinkepisode.MYI
Jul 29 03:40:10 Watchtower logger: >f+++++++++ mysql/MyVideos78/directorlinkepisode.MYI
Jul 29 03:40:10 Watchtower logger: ./mysql/MyVideos78/files.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/files.MYD
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/files.MYI
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/files.MYI
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/movielinktvshow.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/movielinktvshow.MYD
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/movielinktvshow.MYI
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/movielinktvshow.MYI
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/movie.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/movie.MYD
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/movie.MYI
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/movie.MYI
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/actors.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/actors.MYD
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/actors.MYI
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/actors.MYI
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/country.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/country.MYD
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/country.MYI
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/country.MYI
Jul 29 03:40:11 Watchtower logger: ./mysql/MyVideos78/seasons.MYD
Jul 29 03:40:11 Watchtower logger: >f+++++++++ mysql/MyVideos78/seasons.MYD
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/seasons.MYI
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/seasons.MYI
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/tvshow.MYD
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/tvshow.MYD
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/tvshow.MYI
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/tvshow.MYI
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/directorlinkmovie.MYD
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/directorlinkmovie.MYD
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/directorlinkmovie.MYI
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/directorlinkmovie.MYI
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/episode.MYD
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/episode.MYD
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/episode.MYI
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/episode.MYI
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/actorlinkepisode.MYD
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinkepisode.MYD
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/actorlinkepisode.MYI
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinkepisode.MYI
Jul 29 03:40:12 Watchtower logger: ./mysql/MyVideos78/tag.MYD
Jul 29 03:40:12 Watchtower logger: >f+++++++++ mysql/MyVideos78/tag.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/tag.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/tag.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/studiolinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/studiolinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/studiolinkmovie.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/studiolinkmovie.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/actorlinktvshow.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinktvshow.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/actorlinktvshow.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinktvshow.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/version.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/version.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/version.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/version.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/path.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/path.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/path.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/path.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/studio.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/studio.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/studio.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/studio.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/writerlinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/writerlinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/writerlinkmovie.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/writerlinkmovie.MYI
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/countrylinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/countrylinkmovie.MYD
Jul 29 03:40:13 Watchtower logger: ./mysql/MyVideos78/countrylinkmovie.MYI
Jul 29 03:40:13 Watchtower logger: >f+++++++++ mysql/MyVideos78/countrylinkmovie.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/settings.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/settings.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/settings.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/settings.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/genre.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/genre.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/genre.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/genre.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/tvshowlinkpath.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/tvshowlinkpath.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/tvshowlinkpath.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/tvshowlinkpath.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/streamdetails.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/streamdetails.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/streamdetails.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/streamdetails.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/studiolinktvshow.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/studiolinktvshow.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/studiolinktvshow.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/studiolinktvshow.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/bookmark.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/bookmark.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/bookmark.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/bookmark.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/sets.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/sets.MYD
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/sets.MYI
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/sets.MYI
Jul 29 03:40:14 Watchtower logger: ./mysql/MyVideos78/art.MYD
Jul 29 03:40:14 Watchtower logger: >f+++++++++ mysql/MyVideos78/art.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/art.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/art.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/genrelinkmovie.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/genrelinkmovie.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/genrelinkmovie.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/genrelinkmovie.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/actorlinkmovie.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinkmovie.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/actorlinkmovie.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/actorlinkmovie.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/taglinks.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/taglinks.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/taglinks.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/taglinks.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/writerlinkepisode.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/writerlinkepisode.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/writerlinkepisode.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/writerlinkepisode.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/genrelinktvshow.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/genrelinktvshow.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/genrelinktvshow.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/genrelinktvshow.MYI
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/musicvideo.MYD
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/musicvideo.MYD
Jul 29 03:40:15 Watchtower logger: ./mysql/MyVideos78/musicvideo.MYI
Jul 29 03:40:15 Watchtower logger: >f+++++++++ mysql/MyVideos78/musicvideo.MYI
Jul 29 03:40:16 Watchtower logger: ./mysql/MyVideos78
Jul 29 03:40:16 Watchtower logger: ./mysql/mysql-bin.index
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/mysql-bin.index
Jul 29 03:40:16 Watchtower logger: ./mysql/ib_logfile0
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/ib_logfile0
Jul 29 03:40:16 Watchtower logger: ./mysql/ib_logfile1
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/ib_logfile1
Jul 29 03:40:16 Watchtower logger: ./mysql/ibdata1
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/ibdata1
Jul 29 03:40:16 Watchtower logger: ./mysql/MyMusic46/song.MYD
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/MyMusic46/song.MYD
Jul 29 03:40:16 Watchtower logger: ./mysql/MyMusic46/song.MYI
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/MyMusic46/song.MYI
Jul 29 03:40:16 Watchtower logger: ./mysql/MyMusic46/song_artist.MYD
Jul 29 03:40:16 Watchtower logger: >f+++++++++ mysql/MyMusic46/song_artist.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/song_artist.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/song_artist.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/version.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/version.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/version.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/version.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/path.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/path.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/path.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/path.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/album_artist.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/album_artist.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/album_artist.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/album_artist.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/album.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/album.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/album.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/album.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/karaokedata.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/karaokedata.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/karaokedata.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/karaokedata.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/artist.MYD
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/artist.MYD
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46/artist.MYI
Jul 29 03:40:17 Watchtower logger: >f+++++++++ mysql/MyMusic46/artist.MYI
Jul 29 03:40:17 Watchtower logger: ./mysql/MyMusic46
Jul 29 03:40:17 Watchtower logger: ./mysql/
Jul 29 03:40:17 Watchtower logger: mover finished

Not sure if you can make anything of this. I'll give your suggestions a try once I return home later today.
Reply
#34
OK, I'm not completely clear on what that's telling me, other than I think its something to do with unRAID's mover app, which moves things off the cache drive onto parity protected disks.

I may be talking without my hat here as I don't run unRAID, but my best guess is that your MySQL server is pointing at the db's on the cache drive, not at the parity protected drives. This would mean that everything would work until mover does it's stuff (it works on a schedule) when it all falls over.

I could be completely wrong of course, but unRAID support would be the best place to ask about this if that is indeed what's happening.
Learning Linux the hard way !!
Reply
#35
(2014-07-29, 13:33)black_eagle Wrote: OK, I'm not completely clear on what that's telling me, other than I think its something to do with unRAID's mover app, which moves things off the cache drive onto parity protected disks.

I may be talking without my hat here as I don't run unRAID, but my best guess is that your MySQL server is pointing at the db's on the cache drive, not at the parity protected drives. This would mean that everything would work until mover does it's stuff (it works on a schedule) when it all falls over.

I could be completely wrong of course, but unRAID support would be the best place to ask about this if that is indeed what's happening.

Yeah, MySQL exists on the cache drive as do the DB's I believe. This way if the main disks spin down, the DB is still always accessible as the cache drive is always awake.

I don't know if that 'mover' operation is what kills the DB setup. I'll try to post over at the UnRAID forums to see if they can shed any additional insight. I'll be sure to give your instructions that you posted above a try tonight after work.
Reply
#36
Hmmm, not knowing anything about unRAID makes it difficult, but is there not a method of excluding any paths starting with mysql from the mover ? That way it would leave your db's alone. Looking at the log you posted, I'm almost certain that it's moving the tables elsewhere, so XBMC connects to the MySQL server OK, but when it tries to query it, the server can't find the tables anymore. Hence the 'table doesn't exist' error being returned to XBMC.

Don't think you need to follow any of that troubleshooting. I'd bet my car against a bent penny that if you stop mover interfering with the mysql stuff, the problem will be solved.
Learning Linux the hard way !!
Reply
#37
(2014-07-29, 15:28)black_eagle Wrote: Hmmm, not knowing anything about unRAID makes it difficult, but is there not a method of excluding any paths starting with mysql from the mover ? That way it would leave your db's alone. Looking at the log you posted, I'm almost certain that it's moving the tables elsewhere, so XBMC connects to the MySQL server OK, but when it tries to query it, the server can't find the tables anymore. Hence the 'table doesn't exist' error being returned to XBMC.

Don't think you need to follow any of that troubleshooting. I'd bet my car against a bent penny that if you stop mover interfering with the mysql stuff, the problem will be solved.

I'm thinking the same. Only thing is I've never seen this mover operation before and am not sure how to stop it. I'm scouring the net for info in between tasks.

I've started a thread here: http://lime-technology.com/forum/index.p...ic=34357.0

It's gathered a few replies already.
Reply
#38
Yes, seemingly from those posts and that screenshot, that should indeed cure your issue, and you can then enjoy the awesomeness that is gotham over multiple clients, with one database between the lot Nod
Learning Linux the hard way !!
Reply
#39
(2014-07-29, 16:51)black_eagle Wrote: Yes, seemingly from those posts and that screenshot, that should indeed cure your issue, and you can then enjoy the awesomeness that is gotham over multiple clients, with one database between the lot Nod

I hope it's that simple. I'll adjust the share settings tonight and blow away the DB's + start over again.
Reply
#40
If they have been moved to the array, why not just find 'em and copy them back ? Would be a much quicker solution, assuming all the data is intact (no reason it wouldn't be).
Learning Linux the hard way !!
Reply
#41
(2014-07-29, 16:57)black_eagle Wrote: If they have been moved to the array, why not just find 'em and copy them back ? Would be a much quicker solution, assuming all the data is intact (no reason it wouldn't be).

I'll see if I can find it, but it wasn't modified in any way. It was just scraped data. Takes like 10-15 minutes to rescrape it all. I didn't adjust any watched status'.

I'll try to find the data so at least i know where it went.
Reply
#42
Well, I changed the mysql share to only reside on the cache drive yesterday, setup the library again and when I woke up this morning it was still working!

Looks like it is all well for now. Just have to figure out why I'm seeing artifacting now on my Windows 7 box.
Reply
#43
Well done mate !! Good luck with the Win 7 box Smile
Learning Linux the hard way !!
Reply
#44
(2014-07-30, 17:02)black_eagle Wrote: Well done mate !! Good luck with the Win 7 box Smile

Thank you once again for all of your help. I really appreciate your time. I owe you a beer.
Reply
#45
Keep in mind RAID adds additional complexity and thus an elevated risk for data corruption. Regular file systems already cannot track data corruption, RAID and bigger drives only complicate that further. You might have bumped into a file system problem without realising it (e.g. corrupted database).
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply

Logout Mark Read Team Forum Stats Members Help
Upgrading from FroDo to Gotham - MYSQL Issues0