Re: [sqlite] new Error database disk image is malformed

2018-01-05 Thread Ron Barnes
I'm coding that now. I never thought about it. Thank you! -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Friday, January 5, 2018 1:34 PM To: SQLite mailing list Subject: Re: [sqlite] new Error database

Re: [sqlite] new Error database disk image is malformed

2018-01-05 Thread Jens Alfke
> On Jan 4, 2018, at 6:29 PM, Peter Da Silva > wrote: > > Since you're I/O bound on socket connections, and not CPU or database bound, > you might want to just have one database thread that communicates using > native inter-thread messaging to pass out work and accept responses from the > w

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Peter Da Silva
> Ok. I've read the Document and I think I may be having a rouge thread issue. > I hope not since I use synclock in my code when ever a thread is attempting a > write to the database. That seems like the only issue from that page that I > may be doing. I could have up to 30 or more threads re

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Richard Damon
On 1/4/18 8:02 PM, Jens Alfke wrote: On Jan 4, 2018, at 4:51 PM, Ron Barnes wrote: I hope not since I use synclock in my code when ever a thread is attempting a write to the database. That seems like the only issue from that page that I may be doing. I could have up to 30 or more threads

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Ron Barnes
and-behold/9nblggh533kc -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Thursday, January 4, 2018 8:03 PM To: SQLite mailing list Subject: Re: [sqlite] new Error database disk image is malformed > On Jan 4, 201

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Jens Alfke
> On Jan 4, 2018, at 4:51 PM, Ron Barnes wrote: > > I hope not since I use synclock in my code when ever a thread is attempting a > write to the database. That seems like the only issue from that page that I > may be doing. I could have up to 30 or more threads reading from the DB but > on

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Ron Barnes
;Version=3;New=False;Max Page Count=10485760;Compress=True;journal_mode=WAL;" Regards, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, January 4, 2018 3:14 PM To: sqlite-users@mailinglists.sqlite.org S

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Ron Barnes
Thank you - I will and report back! -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, January 4, 2018 3:14 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] new Error database disk image is

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread Jens Alfke
(1) Try opening & querying the database file using the `sqlite3` tool, to verify whether it’s actually corrupted. (2) If it is, check the documentation page “How To Corrupt A SQLite Database” and see if you’re making any of those mistakes. —Jens ___ sq

Re: [sqlite] new Error database disk image is malformed

2018-01-04 Thread R Smith
On 2018/01/04 9:49 PM, Ron Barnes wrote: Hi All, I keep generating this error and I can't figure out why. I have deleted and re-created the database but it keeps popping up. Error database disk image is malformed Any ideas why? This is a wild guess, but I'm thinking it's because the

[sqlite] new Error database disk image is malformed

2018-01-04 Thread Ron Barnes
Hi All, I keep generating this error and I can't figure out why. I have deleted and re-created the database but it keeps popping up. Error database disk image is malformed Any ideas why? -Ron ___ sqlite-users mailing list sqlite-users@mailin