Hi, 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 reading from the DB but only one to three active threads writing. The way my code is set up, though is that each thread would have to wait for the previous thread to finish writing before its turn to write.
Each process works as follows... Gather information. Format the information Enter the write routine using synclock (Visual Basic) Write the record Exit the write routine. I'm using Visual Studio 2015 Visual Basic Samsung 2TB SSD 64GB RAM 8 Core AMD Processor Could any of the 30 or so concurrent reads be messing up my writes? Here is my Create string... Dim CreateNewDBConString As String = "Data Source=" + Trim(MyPath) + "\LoAndBehold.DB3;Version=3;New=True;Max Page Count=10485760;Compress=True;journal_mode=WAL;" Here is my read/write string... Dim Myconstring As String = "Data Source=" + Trim(MyPath) + "\LoAndBehold.DB3;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 Subject: Re: [sqlite] new Error database disk image is malformed 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 disk image is malformed...? :) More seriously, what you probably meant to ask is: "Any idea why my file gets corrupt in this way?" To which the best answer is: No idea, but here are some things that are typical culprits: https://sqlite.org/howtocorrupt.html Once you've checked all those, and you still are not sure what could cause the corruption, please write again but then include all information, OS, storage media, file system, use case, etc. and likely someone here would have had similar experience or run a similar system (or perhaps see some other obvious problem). Good luck! Ryan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
