SQLite Forum

Is there a 64 bit sqlite3.exe available to avoid out of memory error?
Login

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]

Compiling sqlite yourself gives you maximum configurability, but Nalgeon kindly hosts 64-bit CLI's at https://github.com/nalgeon/sqlite/releases/

and also packages some extensions together at: https://github.com/nalgeon/sqlean

(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 …

Does the .dump command dump any information at all ? Table structure ? Any rows up to the point of corruption ?

Does 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.