#Auto install v3.2.0 fails on database migration - Help

1 messages · Page 1 of 1 (latest)

mild flint
#

Was prompted by auto message to install v3.2.0 this morning. It installed and started database migration, and failed (Win desktop). Uninstalled, downloaded current install file, still failing in database migration step.

SQL logic error (query: insert into "content_fts" ("rowid", "id", "data", "noteId") select "rowid", "id", IIF(locked == 1, '', data) as "data", "noteId" from "content" where ("noteId" is not null and "data" is not null and "deleted" is not 1))

SqliteError: SQL logic error (query: insert into "content_fts" ("rowid", "id", "data", "noteId") select "rowid", "id", IIF(locked == 1, '', data) as "data", "noteId" from "content" where ("noteId" is not null and "data" is not null and "deleted" is not 1))
at N.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-BZWvAuu0.js:1:1482)
at Generator.next (<anonymous>)
at u (https://app.notesnook.com/assets/sqlite.worker.desktop-BZWvAuu0.js:1:151)

jade galleon
#

I just installed the latest 3.2 stable and it worked fine. Try downloading from the lates GitHub release and install it, it should work. But thanks for the bug report!

kindred aurora
#

Is this something like this?

mild flint
mild flint
jade galleon
#

This is really weird. Lets wait until @mellow granite can take a look at this

mild flint
#

blobyes thanks

mellow granite
#

This looks like an issue while reindexing the notes database. @mild flint can you try logging in on the web and see if that works?

mild flint
#

Fails trying to open in Brave with message ....

#

SQL logic error (error exec query: insert into "content_fts" ("rowid", "id", "data", "noteId") select "rowid", "id", IIF(locked == 1, '', data) as "data", "noteId" from "content" where ("noteId" is not null and "data" is not null and "deleted" is not 1))
Error: SQL logic error
at G (https://app.notesnook.com/assets/sqlite.worker-CQux6cAo.js:1:11833)
at Object.step (https://app.notesnook.com/assets/sqlite.worker-CQux6cAo.js:1:9495)
at async Bs.exec (https://app.notesnook.com/assets/sqlite.worker-CQux6cAo.js:5:8131)
at async Bs.run (https://app.notesnook.com/assets/sqlite.worker-CQux6cAo.js:5:8725)
at async MessagePort.<anonymous> (https://app.notesnook.com/assets/sqlite.worker-CQux6cAo.js:5:6445)

mellow granite
#

Yup, its definitely a reindexing issue. But strange that you are having it. Perhaps because you have a lot more notes?

mild flint
#

I have just over 30k notes.

#

Still have access to my Notesnook account from phone ... 30080 notes currently.

mellow granite
#

I'll give it a try with 30k notes. You can downgrade to v3.1.1 in the meantime.

mild flint
#

ok, thanks.

jade galleon
#

Thanks for the awesome work @mellow granite

mellow granite
#

I'll have to find a way to reproduce it somehow. Should be fixable once its reproduced.

mild flint
#

Got desktop downgraded to v3.1.1, but webapp is running v3.2.0 and it is working!?! 🤯

#

The notebooks hierarchy is missing in webapp (which is running 3.2.0). Desktop is running 3.1.1 and shows hierarchy correctly.

mellow granite
mellow granite
#

@mild flint haven't been able to reproduce it with 30k notes

mellow granite
mild flint
mild flint
mild flint
#

First, I exited v3.1.1 (which works fine), and I restarted the desktop app which did the "auto upgrade" to v3.2.0. It started the migration phase and crashed with message:@mellow granite@jade galleon
SQL logic error (query: insert into "content_fts" ("rowid", "id", "data", "noteId") select "rowid", "id", IIF(locked == 1, '', data) as "data", "noteId" from "content" where ("noteId" is not null and "data" is not null and "deleted" is not 1))
SqliteError: SQL logic error (query: insert into "content_fts" ("rowid", "id", "data", "noteId") select "rowid", "id", IIF(locked == 1, '', data) as "data", "noteId" from "content" where ("noteId" is not null and "data" is not null and "deleted" is not 1))
at N.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-BZWvAuu0.js:1:1482)
at Generator.next (<anonymous>)
at u (https://app.notesnook.com/assets/sqlite.worker.desktop-BZWvAuu0.js:1:151)

Next, uninstalled 3.2.0 (auto upgraded); reboot; install v3.2.0 from github.
Logged in and it began the migration phase ... didn't crash, but the sync failed. See screenshot:

#

This shows the red circle of failed sync, and flat list of notebooks (no hierarchy), notes count is not shown.

Opened the web app in Brave (doesn't crash), and webapp begins the sync then fails (red circle). Webapp shows total notes count of 30,079 and it lists the notes, but no hierarchy of notebooks, and notebooks all have 0 notes count. Screen shot of webapp follows ...

mild flint
#

Now, going back to v3.1.1

astral salmon
mellow granite
#

I haven't been able to reproduce this.

astral salmon
#

I don't have 30K notes, thankfully I took a backup of my notes because it looks like Importer was discontinued in favour of direct-app import, but 3.1.1. doesn't seem to have that option, so a restore saved me after I cleared out my entire account to try and troubleshoot

mild flint
mellow granite
mellow granite
#

My guess is that the our new tokenizer for search is failing to tokenize a specific note. Unfortunately, without an exact reproduction, fixing the error would be near-to impossible.

#

Another thing to note is that this is mostly happening to people with imported notes. I haven't tested with imported notes. I'll try that now.

mild flint
mild flint
#

My secondary account is having the same issue ... what's our next step?

mellow granite
mild flint
#

As I battle the issue encountered with 3.2.0 upgrade (reindexing issue), I had to uninstall/reinstall many times which requires re-sync every time. On my desktop, these syncs didn't take very long. On my android phone, it just took ~20 hrs to sync, for a downgrade to v3.1.1. (just throwing this out for consideration, cuz I've seen a number of posts raising issues with sync).

mellow granite
mild flint
#

Excellent!

mellow granite
#

This issue has been fixed. Will be released in v3.2.3

astral salmon
#

How long is sync expected to take? Any note that I've created post-upgrade to 3.2.3 takes upwards of 30 mins to appear in other clients (very small note). Even then, the sync is superficial because the "source" client will have an indefinitely spinning sync symbol in the bottom left corner, and the destination clients will load the new note preview for approximately 5 seconds before showing blank note text

Edit: A cache clear in the browser and an uninstall / reinstall of the client apps fixed it after a while

astral salmon
#

Still receiving SQL logic error on my Android. Each device is on the same newest version

mellow granite
astral salmon
#

Appears to be. Issue seems to be Android specific

astral salmon
#

Android 3.2.4 appears to have solved it. Will continue to test. The speed of your release cycles continue to amaze me 🎉

mellow granite