Gekko Forum
SQLITE_CORRUPT error - Printable Version

+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Gekko (https://forum.gekko.wizb.it/forum-13.html)
+--- Forum: Technical Support (https://forum.gekko.wizb.it/forum-19.html)
+--- Thread: SQLITE_CORRUPT error (/thread-57813.html)



SQLITE_CORRUPT error - chrisb647100 - 01-04-2019

I had Gekko running for awhile on my Win 10 Pro machine, but am now receiving the error, "{ Error: SQLITE_CORRUPT: database disk image is malformed errno: 11, code: 'SQLITE_CORRUPT' }", when I try to "Scan available data" in the Gekko UI.

Can someone help me with the Bash commands to uninstall the DB and start all over?

I have already tried to uninstall Ubuntu (which I downloaded from the Windows store) and reinstall it, but that did not fix the issue.

Any other advice to get it up and running again on my Win 10 Pro box would be helpful. Thanks.


RE: SQLITE_CORRUPT error - chrisb647100 - 01-05-2019

(01-04-2019, 06:08 PM)chrisb647100 Wrote: I had Gekko running for awhile on my Win 10 Pro machine, but am now receiving the error, "{ Error: SQLITE_CORRUPT: database disk image is malformed errno: 11, code: 'SQLITE_CORRUPT' }", when I try to "Scan available data" in the Gekko UI.

Can someone help me with the Bash commands to uninstall the DB and start all over?

I have already tried to uninstall Ubuntu (which I downloaded from the Windows store) and reinstall it, but that did not fix the issue.

Any other advice to get it up and running again on my Win 10 Pro box would be helpful. Thanks.

**UPDATE - I navigated to "C:\Users\Christopher Bradley\AppData\Local\Packages\CanonicalGroupLimited.UbuntuonWindows_79rhkp1fndgsc\LocalState\rootfs\home\chrisb", and appended the folder names, "gekko", ".node-gyp", and ".npm" with ".old", then ran through the entire installation process from start to finish.

The installation seems to be functioning properly again.


RE: SQLITE_CORRUPT error - chrisb647100 - 01-07-2019

(01-05-2019, 12:56 PM)chrisb647100 Wrote:
(01-04-2019, 06:08 PM)chrisb647100 Wrote: I had Gekko running for awhile on my Win 10 Pro machine, but am now receiving the error, "{ Error: SQLITE_CORRUPT: database disk image is malformed errno: 11, code: 'SQLITE_CORRUPT' }", when I try to "Scan available data" in the Gekko UI.

Can someone help me with the Bash commands to uninstall the DB and start all over?

I have already tried to uninstall Ubuntu (which I downloaded from the Windows store) and reinstall it, but that did not fix the issue.

Any other advice to get it up and running again on my Win 10 Pro box would be helpful. Thanks.

**UPDATE - I navigated to "C:\Users\Christopher Bradley\AppData\Local\Packages\CanonicalGroupLimited.UbuntuonWindows_79rhkp1fndgsc\LocalState\rootfs\home\chrisb", and appended the folder names, "gekko", ".node-gyp", and ".npm" with ".old", then ran through the entire installation process from start to finish.

The installation seems to be functioning properly again.

New **UPDATE - The problem keeps recurring after functioning well for a few minutes. Any help would actually be appreciated after all.

I am running a Windows 10 Pro machine with Bash enabled and have Ubuntu installed from the Microsoft store. I am attempting to run Gekko following the instructions for Win 10 with Bash. Everything seems to function fine for awhile and then I get the error, attached. Does anyone know what might be happening to corrupt the DB. My feeling is that I am running something incompatible. IDK. Thanks!

[attachment=327]


RE: SQLITE_CORRUPT error - Remo - 01-08-2019

Simply install it on ubuntu in virtualbox and you can avoid a lot of problems.On windows it is a pain to operate it.


RE: SQLITE_CORRUPT error - chrisb647100 - 01-08-2019

Thanks for the wake up call! I keep dreaming of that day when Microsoft gets it right. Deep down inside, I know that they never will...