Is there a 64 bit sqlite3.exe available to avoid out of memory error?
(1) By anonymous on 2021-06-29 11:47:33 [link] [source]
Hi, I'm trying to recover a broken database using the ".recover" feature. I run into a out of memory error while running the command unfortunately.
Is there a workaround for this issue? I thought a 64 bit version of sqlite3.exe may solve the problem as it could allocate more memory.
Any help would be much appreciated.
(2) By Larry Brasfield (larrybr) on 2021-06-29 16:45:34 in reply to 1 [link] [source]
With either of two readily available C compilers, you can build a 64-bit sqlite3.exe . See Compiling The Command-Line Interface. That executable is much less likely to suffer an OOM failure.
(3) By Donald Griggs (dfgriggs) on 2021-06-29 17:16:10 in reply to 1 [link] [source]
(4) By anonymous on 2021-06-29 18:39:16 in reply to 3 [link] [source]
Thanks for the link.
I tried the x64 version... but I still get the same error. The sqlite3 process isn't using more than 6 mb of memory. The broken database has a total size of 142 mb.
So it's probably no real out of memory error.
(5) By Simon Slavin (slavin) on 2021-06-30 14:49:26 in reply to 4 [source]
Agreed. If you want ways to work on this …
.dump command dump any information at all ? Table structure ? Any rows up to the point of corruption ?
sqlite3_analyzer.exe tell you anything about the database ?
I don't need to know the answers, but they might tell you something that lets you rescue some of the data.