Reply To: SVN-1450 nslu2 cant open DB

#7957
fizze
Participant

hm, not more than the syslog…..

<25>Dec 15 17:39:51 mt-daapd[1998]: Rescanning database
<25>Dec 15 17:40:11 mt-daapd[1997]: Rendezvous socket closed (daap server crash
<25>Dec 15 17:45:14 mt-daapd[24337]: Starting with debuglevel 2
<25>Dec 15 17:45:14 mt-daapd[24337]: Starting rendezvous daemon
<25>Dec 15 17:45:14 mt-daapd[24339]: Starting signal handler
<25>Dec 15 17:45:15 mt-daapd[24339]: Initializing database
<25>Dec 15 17:45:37 mt-daapd[24339]: Query: vacuum
<25>Dec 15 17:45:37 mt-daapd[24339]: Error: disk I/O error
<25>Dec 15 17:45:37 mt-daapd[24338]: Rendezvous socket closed (daap server cras
<25>Dec 15 17:47:17 mt-daapd[24375]: Firefly Version svn-1450: Starting with de
<25>Dec 15 17:47:17 mt-daapd[24375]: Starting rendezvous daemon
<25>Dec 15 17:47:17 mt-daapd[24377]: Starting signal handler
<25>Dec 15 17:47:18 mt-daapd[24377]: Old database version: 12, expecting 13
<25>Dec 15 17:47:18 mt-daapd[24377]: Upgrading db: 12 --> 13
<25>Dec 15 17:47:32 mt-daapd[24377]: Query: create temp table tempsongs as sele
<13>Dec 15 17:47:32 INTEGER DEFAULT 0, disc INTEGER DEFAULT 0,
<25>Dec 15 17:47:32 mt-daapd[24377]: Error: database is full
<25>Dec 15 17:47:32 mt-daapd[24377]: Error upgrading db: Misc SQL Error: databa
<25>Dec 15 17:47:32 mt-daapd[24377]: Error opening db: Misc SQL Error: database

I do only have about 4MB space left on my stick though. I desperatley want to unsling to the HD. Did I ever mention I need some vacation? 😉

Alrighty, I’ll try to play with that stuff later this weekend.

edit:
OK, I ran it with my conf file and -r and the output is the same:

<25>Dec 16 09:28:21 mt-daapd[24841]: Starting rendezvous daemon
<25>Dec 16 09:28:21 mt-daapd[24843]: Starting signal handler
<25>Dec 16 09:28:21 mt-daapd[24843]: db_sqlite2_open: unable to open database: /share/hdd/data/.mt-daapd/songs.db (/share/hdd/data/.mt-daapd/songs.db)
<25>Dec 16 09:28:21 mt-daapd[24843]: Error opening db: Misc SQL Error: unable to open database: /share/hdd/data/.mt-daapd/songs.db
<25>Dec 16 09:28:21 mt-daapd[24843]: Stopping signal handler

I’ll just remove the DB and start from scratch.
I dont quite get it because I can get in with sqlite. Prolly you dont properly check any return values from your SQLite routines?

edit:

<25>Dec 16 11:32:52 mt-daapd[24902]: Firefly Version svn-1450: Starting with debuglevel 2
<25>Dec 16 11:32:52 mt-daapd[24902]: Starting rendezvous daemon
<25>Dec 16 11:32:53 mt-daapd[24904]: Starting signal handler
<25>Dec 16 11:32:53 mt-daapd[24904]: Error: enum_begin failed (error 1): Misc SQL Error: no such table: config
<25>Dec 16 11:32:53 mt-daapd[24904]: Can't get db version. New database?
<25>Dec 16 11:32:53 mt-daapd[24904]: Initializing database
<25>Dec 16 11:32:53 mt-daapd[24904]: Error: enum_begin failed (error 1): ?
<25>Dec 16 11:32:53 mt-daapd[24904]: Error: enum_begin failed (error 1): ?
<25>Dec 16 11:32:53 mt-daapd[24904]: Full reload...
<25>Dec 16 11:32:53 mt-daapd[24904]: Starting mp3 scan

Alrighty, there seems to be a permission problem as well.
I had to 777 the DB dir. I had it chown’d to the user mt-daapd runs as first, and hat it set to 700. didnt work. weird.
Next I chown’d it to root:root and it didnt work either. Now with 777 it of course runs.
At what point does mt-daapd revoke its root:root rights and demonizes?
Or am i missing something here?