Murmur "Unable to Open Database, Unable to fetch row" on XP

It crashed, it is bugged, ...
Post Reply
etmegabyte
Posts: 1
Joined: 18 May 2010, 17:21

Murmur "Unable to Open Database, Unable to fetch row" on XP

Post by etmegabyte »

I am getting a strange error when starting Murmur. Once this error comes up (right away), Murmur.exe dies...

<F>DATE/TIME SQL Error [INSERT INTO `slog` (`server_id`, `msg`) VALUES(?,?)]: unable to open database file Unable to fetch row

This server isn't anything special. One server, running on Windows XP Pro. The only "odd" thing about this setup is that though Mumble/Murmur is installed in c:\program files\mumble, the sqlite database and the log file have been moved to "D:\Murmur". I did this because C: is a compactflash drive, and I don't want a bunch of writes to that flash disk...

It is not a corrupt database, I grabbed the murmur.sqlite from another machine that is running just fine, and it still gives the error.

Just a bit of background here. The goal was to migrate the murmur server to this new machine from an old machine that I'm planning on putting to pasture soon. So I shut down murmur on the old machine, copied the murmur.sqlite file from the old one to the new one, then started it on the new one. That would effectively eliminate the possibility of it being a corrupt database (which is what the faq suggests as a possible problem). Murmur still runs just fine on the old machine, with no errors.

It's not a permissions issue, as the drive where the sqlite database file and log is is formatted FAT32.

It's not a size issue, as the sqlite databae file is just over 3 megabytes.

Just for testing, I deleted the "migrated" sqlite file and tried to let it re-create it fresh. When starting murmur, it creates a new, empty file in the proper location, but gives a different (yet similar) error:

<F>DATE/TIME SQL Error [CREATE UNIQUE INDEX `config_key` ON `config` (`server_id`, `key`)]: Unable to open database file Unable to fetch row....

The relevant changes in murmur.ini are as follows:
database=d:/murmur/murmur.sqlite
logfile=d:/murmur/murmur.log

The rest of the file is identical to the one on the properly running server.

And finally, a direct copy from murmur.log...
<W>2010-10-04 12:59:06.687 Initializing settings from C:/Program Files/Mumble/murmur.ini (basepath C:/Program Files/Mumble)
<W>2010-10-04 12:59:06.890 SSL: Added CA certificates from system store 'Ca'
<W>2010-10-04 12:59:06.937 SSL: Added CA certificates from system store 'Root'
<W>2010-10-04 12:59:06.968 SSL: Added CA certificates from system store 'AuthRoot'
<W>2010-10-04 12:59:07.015 ServerDB: Openend SQLite database D:/murmur/murmur.sqlite
<W>2010-10-04 12:59:07.015 Meta: Failed to load qWave.dll, no QoS available
<W>2010-10-04 12:59:07.062 DBus registration succeeded
<W>2010-10-04 12:59:07.078 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2010-10-04 12:59:07.078 Murmur 1.2.2 (1.2.2) running on Win: 5.1.2600.1: Booting servers
<F>2010-10-04 12:59:07.093 SQL Error [INSERT INTO `slog` (`server_id`, `msg`) VALUES(?,?)]: unable to open database file Unable to fetch row

-----

I've tried just about everything I can think of. Mumble works fine on that machine. I've even copied the mumble directory from a known working machine in it's entirety. I've tried changing the config back to put the sqlite file and the log in the same directory as the program. None of it helps. The error perplexes me, since it's telling me that it can't open the database, when 5 lines above in the same log it tells me that it DID open the database. I can't figure out what I could possibly be missing here... The user account trying to run murmur is a computer administrator. Everything is as it seems like it should be... Except, of course, that it doesn't run...

Am I missing something?

Post Reply