I cranked log to debug=9 and got
2007-11-14 13:20:39 (00002403): Executing: select count(*) FROM songs
2007-11-14 13:20:39 (00002403): Creating new db handle
2007-11-14 13:20:39 (00002403): Executing: select count(*) FROM playlists
2007-11-14 13:20:39 (00002403): Updating Content-Type from application/x-dmap-tagged to text/xml
2007-11-14 13:20:39 (00002403): Updating Connection from keep-alive to Close
2007-11-14 13:20:39 (00002403): Emitting reponse header Expires: -1
2007-11-14 13:20:39 (00002403): Emitting reponse header Cache-Control: no-cache
2007-11-14 13:20:39 (00002403): Emitting reponse header DAAP-Server: firefly/svn-1696
2007-11-14 13:20:39 (00002403): Emitting reponse header Accept-Ranges: bytes
2007-11-14 13:20:39 (00002403): Emitting reponse header Content-Language: en_us
2007-11-14 13:20:39 (00002403): Emitting reponse header Content-Type: text/xml
2007-11-14 13:20:39 (00002403): Emitting reponse header Server: mt-daapd/svn-1696
2007-11-14 13:20:39 (00002403): Emitting reponse header Connection: Close
2007-11-14 13:20:39 (00002403): Emitting reponse header Date: Wed, 14 Nov 2007 13:20:39 GMT
2007-11-14 13:20:39 (00002403): malloc error in vasprintf
2007-11-14 13:20:39: Aborting
2007-11-14 13:20:39 (00000400): Processing rendezvous message
2007-11-14 13:20:39 (00000400): Rendezvous socket closed (daap server crashed?) Aborting.
2007-11-14 13:20:39: AbortingAlso I tried the sql manually, and that returns as expected
bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> select count(*) from playlists;
12
sqlite>Hope that helps ?
BTW running firefly version 1696 on my slug.
[edit]
Memory usage is OK… I get
CPU[###***** 13.0%] Tasks: 61 total, 1 running
Mem[|||||||||||||||||||||||||##########**************13/29MB] Load average: 1.06 1.02 1.00
Swp[||||| 9/117MB] Uptime: 13 days, 02:45:27[/edit]