Mysql server issue RC2.

Using 2:10.00~svn35567-lucid1 I am seeing issues with the music database updating. On reboot of the machine the music database update works fine but trying another update after a period of time fails. At a guess it seems that the original connection used to update the music DB is not being closed on the xbmc side but is by the mysql server During scan and a few mins after:
$ sudo netstat -pant | grep 3306
tcp 0 0 192.168.1.100:3306 0.0.0.0:* LISTEN 1166/mysqld
tcp 0 0 192.168.1.100:53028 192.168.1.100:3306 ESTABLISHED 1865/xbmc.bin
tcp 0 0 192.168.1.100:3306 192.168.1.100:53028 ESTABLISHED 1166/mysqld

When scan fails :

$ sudo netstat -pant | grep 3306
tcp 0 0 192.168.1.100:3306 0.0.0.0:* LISTEN 1166/mysqld


I have tried using the mysql cli client (using the same credentials) at this stage and it works fine for the query that xbmc is trying ( ).

The odd thing is the video db works at all time..

Log section:

11:02:22 T:140145942591552 M:756662272 DEBUG: ------ Window Init (DialogMusicScan.xml) ------
11:02:22 T:140145942591552 M:756662272 INFO: Loading skin file: DialogMusicScan.xml
11:02:22 T:140145942591552 M:756662272 INFO: Music scan has started... Enabling tag reading, and remote thumbs
11:02:22 T:140145942591552 M:759455744 ERROR: SQL: The MySQL server has gone away
Query: select strPath from path
11:02:22 T:140145942591552 M:760172544 ERROR: GetPaths failed
11:02:22 T:140145423587088 M:760172544 DEBUG: thread start, auto delete: 0
11:02:22 T:140145423587088 M:760172544 DEBUG: Process - Starting scan
11:02:22 T:140145434748688 M:760172544 DEBUG: thread start, auto delete: 0
11:02:22 T:140145434748688 M:760172544 DEBUG: Thread 140145434748688 terminating
11:02:22 T:140145423587088 M:760172544 DEBUG: Process - Finished scan
11:02:22 T:140145423587088 M:760172544 NOTICE: My Music: Scanning for music info using worker thread, operation took 00:00
11:02:22 T:140145423587088 M:760037376 INFO: Music scan was stopped or finished ... restoring FindRemoteThumbs
11:02:22 T:140145423587088 M:760037376 DEBUG: Thread 140145423587088 terminating
11:02:22 T:140145942591552 M:760037376 DEBUG: ------ Window Deinit (DialogMusicScan.xml) ------


advancedsettings.xml section :

<videodatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.1.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>

When the scan fails ::

$ mysql -h localhost -u xbmc -pxbmc
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 107
Server version: 5.1.41-3ubuntu12.8 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use xbmc_music;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(strPath) from path;
+----------------+
| count(strPath) |
+----------------+
| 903 |
+----------------+
1 row in set (0.00 sec)

mysql>


If I try a video update at this stage the scan works fine.

Thanks,

D.

Hi, I was seeing exactly the same thing on Dharma 10.1 and it turns out that the DB was hosed. I had to drop xbmc_music and create it again and then XBMC started scanning files just fine.