Skip Menu |
 

This queue is for tickets about the minismokebox CPAN distribution.

Report information
The Basics
Id: 69006
Status: new
Priority: 0/
Queue: minismokebox

People
Owner: Nobody in particular
Requestors: njh [...] bandsman.co.uk
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 0.54
Fixed in: (no value)



Subject: Fails to recover after system crash
Download (untitled) / with headers
text/plain 2.5k
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?)
From: njh [...] bandsman.co.uk
Download (untitled) / with headers
text/plain 131b
I've found the file to delete - it's called ~/.metabase/relay.db. Does this mean that if the system crashes it loses queued files?


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.