On 7 August 2010 18:35, Brian May <brian@microcomaustralia.com.au> wrote:
As for how to do sqlite data recovery, try googling. e.g. http://www.mail-archive.com/sqlite-users@sqlite.org/msg17538.html
Thanks for the reference. I tried looking but obviously wasn't looking for the right search term.
Curiously I had the same problem reoccur. Unfortunately freeswitch appears to work until some time after the initial problem, makes it hard to find out what happened. The power has failed recently though, maybe connected? [ etc ] 2010-08-17 04:30:40.728489 [CRIT] switch_core_sqldb.c:938 SQL thread unable to commit transaction, records lost! 2010-08-17 04:31:00.653705 [ERR] switch_core_sqldb.c:448 SQL ERR [database disk image is malformed] [ etc ] huey:/opt/freeswitch/db# ls -l core2.db -rw-r--r-- 1 freeswitch daemon 1502208 2010-08-15 17:11 core2.db huey:/opt/freeswitch/db# sqlite3 core2.db SQLite version 3.5.9 Enter ".help" for instructions sqlite> .dump BEGIN TRANSACTION; COMMIT; This is ext2 on flash memory. Maybe I should move core.db on to tmpfs? I get the impression persistence isn't required for this file... -- Brian May <brian@microcomaustralia.com.au>