SQL suddenly not working?
rdubz
Newbie
Posts: 4
#1
2011-10-20, 17:34
I'm not sure whats changed, but I've looked everywhere for the solution to this problem, nothing specific to xbmc and sql, just one or the other.

After a recent update to xbmc, I noticed a big slow down in the ui, which means somethings wrong w/ the DB. I just get "preparing" on the home screen.

Looking at the logs, here's what I see of interest.

NOTICE: UpdateLibraries - Starting video library startup scan
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5656 [1049](Unknown database 'MyVideos5656')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5655 [1049](Unknown database 'MyVideos5655')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5654 [1049](Unknown database 'MyVideos5654')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5653 [1049](Unknown database 'MyVideos5653')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5652 [1049](Unknown database 'MyVideos5652')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5651 [1049](Unknown database 'MyVideos5651')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5650 [1049](Unknown database 'MyVideos5650')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5649 [1049](Unknown database 'MyVideos5649')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5648 [1049](Unknown database 'MyVideos5648')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5647 [1049](Unknown database 'MyVideos5647')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5646 [1049](Unknown database 'MyVideos5646')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5645 [1049](Unknown database 'MyVideos5645')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5644 [1049](Unknown database 'MyVideos5644')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5643 [1049](Unknown database 'MyVideos5643')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5642 [1049](Unknown database 'MyVideos5642')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5641 [1049](Unknown database 'MyVideos5641')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5640 [1049](Unknown database 'MyVideos5640')
11:26:55 T:140018321364960 ERROR: Unable to open database: MyVideos5639 [1049](Unknown database 'MyVideos5639')


Then it spits this out:
NOTICE: Old database found - updating from version 0 to 56
11:26:56 T:140018321364960 ERROR: SQL: Can't create database for copy: 'MyVideos56'
Error: Success
11:26:56 T:140018321364960 ERROR: exception in CApplication::FrameMove()

Then moved to music DB to do the same thing. I looked at mysql, and new DBs were created, but if I try to use them, I get the same errors.

What am I missing here? I've granted ALL to 'xbmc'. Never had this issue before, and can't seem to get much from the logs. When I point to my original DBs (xbmc_video, and xbmc_music2) same error messages?
Find
Reply
spiff
Team-Kodi Member
Posts: 12,706
#2
2011-10-20, 18:40
known issue that should be fixed in HEAD
Find
Reply
rdubz
Newbie
Posts: 4
#3
2011-10-20, 18:45
YARRRGHH! Thanks for the update, I will resume NOT pulling my hairs out. Forgive me, but whats HEAD?
Find
Reply
spiff
Team-Kodi Member
Posts: 12,706
#4
2011-10-20, 18:51
HEAD is the tip of git, i.e. the latest commit.
Find
Reply
rdubz
Newbie
Posts: 4
#5
2011-10-20, 19:06
Excellent, thanks again Spiff! I am using the git version from a ppa.
Being that you are a Grumpy Bastard Dev... I'd like to thank you for all your hard work... XBMC is incredible.
Find
Reply
HellFire
Junior Member
Posts: 27
#6
2011-10-21, 15:58
Seems there's still some issues.

Tested with 357d11d66b and the log is just lots of:
Code:
13:48:10 T:2979707760   ERROR: Unable to open database: MyVideos2 [1203](User xbmc already has more than 'max_user_connections' active connections)
13:48:10 T:2979707760   ERROR: Unable to open database: MyVideos1 [1203](User xbmc already has more than 'max_user_connections' active connections)
13:48:10 T:2979707760   ERROR: Unable to open database: xbmc_video [1203](User xbmc already has more than 'max_user_connections' active connections)
13:48:10 T:2979707760   ERROR: Unable to open database: MyVideos56 [1203](User xbmc already has more than 'max_user_connections' active connections)
<snip>
13:48:10 T:3016820496   ERROR: Unable to open database: xbmc_music [1203](User xbmc already has more than 'max_user_connections' active connections)
13:48:10 T:2979707760   ERROR: Unable to open database: MyVideos55 [1203](User xbmc already has more than 'max_user_connections' active connections)
13:48:10 T:3016820496   ERROR: Unable to open database: MyMusic17 [1203](User xbmc already has more than 'max_user_connections' active connections)
<snip>

My max_user_connections is 250. Looking at MySQL and netstat, XBMC actually has that many open.
Find
Reply
supahfly
Member
Posts: 69
#7
2011-10-29, 09:27
I am getting loads of these too ...
After resetting the MySQL server, things are back to normal.
Seems like xbmc is not killing the connections it is using up, so that in one moment in time the max number are used up and you get these errors?

09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_music
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_music [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_music
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_music [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_music
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_music [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_music
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_video [1040](Too many connections)
09:13:27 T:139714950084416 ERROR: Unable to open database xbmc_video
09:13:27 T:139714950084416 ERROR: Unable to open database: xbmc_music [1040](Too many connections)
Find
Reply
Znubbis
Junior Member
Posts: 31
#8
2011-11-12, 18:03
I have the same problem with 35748c2
Find
Reply
wonslung
Senior Member
Posts: 154
#9
2011-11-17, 23:10
I'm having this issue as well...It's driving me crazy
Find
Reply

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
SQL suddenly not working?0