| Subject: | Fails to recover after system crash |
Summer has arrived, and with it the inevitable Pepco power cuts.
Today's lasted a couple of hours.
Now that the system has come back, metabase-relayd seems to be unable to
start, it gives these cryptic messages:
Running metabase-relayd with options:
debug 1
url http://metabase.cpantesters.org/api/v1/
dbfile /home/njh/.metabase/relay.db
idfile /home/njh/.metabase/nhorne.json
address 192.168.1.2,127.0.0.1
port 8080
multiple 1
Listening on 'compaq.bandsman.co.uk:8080'
Listening on 'localhost:8080'
DB error (0.13288402557373s): {
"sql" : "PRAGMA synchronous = OFF",
"event" : "_generic_db_result",
"placeholders" : [],
"_ts" : 1308700283.9541,
"session" : "5",
"action" : "do",
"error" : "DBD::SQLite::db prepare_cached failed: database disk image
is malformed",
"id" : "0"
}
DB error (0.134739875793457s): {
"sql" : "CREATE TABLE IF NOT EXISTS queue ( id varchar(150),
submitted varchar(32), attempts INTEGER, data BLOB )",
"event" : "_generic_db_result",
"placeholders" : [],
"_ts" : 1308700283.95418,
"session" : "5",
"action" : "do",
"error" : "DBD::SQLite::db prepare_cached failed: database disk image
is malformed",
"id" : "1"
}
DB error (0.137315988540649s): {
"sql" : "CREATE INDEX IF NOT EXISTS queue_id ON queue ( id )",
"event" : "_generic_db_result",
"placeholders" : [],
"_ts" : 1308700283.95422,
"session" : "5",
"action" : "do",
"error" : "DBD::SQLite::db prepare_cached failed: database disk image
is malformed",
"id" : "2"
}
DB error (0.139075994491577s): {
"sql" : "CREATE INDEX IF NOT EXISTS queue_att_sub ON queue (
attempts, submitted )",
"event" : "_generic_db_result",
"placeholders" : [],
"_ts" : 1308700283.95426,
"session" : "5",
"action" : "do",
"error" : "DBD::SQLite::db prepare_cached failed: database disk image
is malformed",
"id" : "3"
}
DB error (0.0178840160369873s): {
"sql" : "VACUUM",
"event" : "_generic_db_result",
"_process" : 1,
"placeholders" : [],
"_ts" : 1308700284.07745,
"session" : "5",
"error" : "database disk image is malformed",
"action" : "do",
"id" : "4"
}
DBD::SQLite::db prepare_cached failed: database disk image is malformed
Nowhere can I work out in these error messages what do to.
Metabase-relayd doesn't actually stop with an error code, it keeps going
so you think it's working when it isn't.
What can I do?
Is there a file I can remove, and if so what's it called (and why isn't
the name printed?)