Hi.
I noticed strange problem with some of my sqlite databases. It does not
affect all of them.
I have a db file, which I modify from the crontab using sqlite3 cli.
Every once in a while, file goes bad.
In the sense that when I connect to it using sqlite3 cli and do any
select I get error message
"Error: file is encrypted or is not a database"
When I do a hex dump of db file, I get
0000000 5153 694c 6574 6620 726f 616d 2074 0033
0000010 0004 0101 4000 2020 0e03 13b2 0000 0000
0000020 6600 9079 0000 0200 0000 1800 0000 0100
0000030 0000 0000 0000 0000 0000 0100 0000 0000
0000040 0000 0000 0000 0000 0000 0000 0000 0000
*
while it is good and once it goes bad I get
0000000 6166 6c69 6465 7420 206f 706f 6e65 6420
0000010 7461 6261 7361 2065 7274 6e61 6173 7463
0000020 6f69 206e 3632 3a20 6620 6c69 2065 7369
0000030 6520 636e 7972 7470 6465 6f20 2072 7369
0000040 6e20 746f 6120 6420 7461 6261 7361 2065
0000050 684f 6d20 2e79 5720 2065 6166 6c69 6465
0000060 7420 206f 6f72 6c6c 6162 6b63 7420 6172
Any explanation for this? I do not believe I have sqlite v2 sitting
anywhere on that computer.
--
Dmitri Priimak
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
