Desktop: Nextcloud client crashes after ubuntu 20.04 update

[simogeo]

After updating from ubuntu 19.10 to 20.04 version, my nextcloud-client always crashed after a while.

Expected behaviour

Should not crash

Actual behaviour

Tell us what happens instead

Steps to reproduce

1. updating from ubuntu 19.10 to 20.04
2. open nextcloud client if not lauched at start-up
3. wait. After a while, client does not support having some issues with some files .

Client configuration

Client version: 2.6.2 from ppa

Operating system: ubuntu 20.04

OS language:

Qt version used by client package (Linux only, see also Settings dialog): Qt 5.12.8 (x86_64-little_endian-lp64 shared (dynamic) release build; by GCC 9.3.0) on "xcb"

Client package (From Nextcloud or distro) (Linux only): from PPA

Installation path of client:

Server configuration

Nextcloud version:

Storage backend (external storage):

Logs

1. Client logfile - last lines only ...

[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jquery-mask-plugin/test
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  06-Ressources/_DATA/EACEI
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jquery.tablesorter
[csync_reconcile    Reconciliation for remote replica took  0.106 seconds visiting  70339  files.
[OCC::SyncEngine::slotDiscoveryJobFinished  #### Reconcile end ####################################################  800251 ms
[OCC::SyncJournalDb::setFileRecord  Updating file record for path: "04_AO & Propositions/2018/a qualifier/CC-Challans-Gois-Communaute_85_20181010W2_01.zip" inode: 27000839 modtime: 1539250514 type: 0 etag: "ea983ebba4e53ea7d2b9bf70df4e90e5" fileId: "00245384oc9b16e44659" remotePerm: "S" fileSize: 188981852 checksum: "SHA1:dc24ebba2b83b7e5cd3df59aaaf7d5c205c37969" e2eMangledName: ""
[OCC::SqlQuery::prepare     Sqlite prepare statement error: "unknown function: parent_hash()" in "INSERT OR REPLACE INTO metadata (phash, pathlen, path, inode, uid, gid, mode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentChecksum, contentChecksumTypeId, e2eMangledName) VALUES (?1 , ?2, ?3 , ?4 , ?5 , ?6 , ?7,  ?8 , ?9 , ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);"
[OCC::SqlQuery::prepare     ENFORCE: "allow_failure" in file /build/nextcloud-client-ymYnWp/nextcloud-client-2.6.4/src/common/ownsql.cpp, line 269 with message: SQLITE Prepare error

Second logfile (last lines) after removing the file causing issue previously :

[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  00-SCOP/1_Offre & Outils/Offre Donnees energetiques/concours-ministere-ecologie/code-source/app/data/energie/200071546
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Appropriation-TE-Region-Centre/03-Travaux/Phase-2/photos-lochois/atelier-1/OneDrive_2019-09-12/Photos Loches Atelier 1
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/html2canvas/tests/cases/text
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/linea21-avantMAJ/lib/js/CodeMirror/mode/haxe
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/1-extension-ProjectRev/linea21/lib/vendor/phpword-0.16.0/vendor/phpoffice/phpword/src/PhpWord/Writer/RTF/Part
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2018/PCAET-Citergie-vitre-communaute/1_Diagnostic/Vulnerabilite/rga
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jQuery-EasyTabs/test
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/linea21-avantMAJ/lib/js/jquery-mask-plugin/src
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jQuery-EasyTabs/vendor
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jquery-mask-plugin
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jquery-mask-plugin/dist
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  02-En-cours/2019/Nanterre-Linea21/deploy/linea21/lib/js/jquery-mask-plugin/test
[_csync_merge_algorithm_visitor     INSTRUCTION_UPDATE_METADATA    server dir:  06-Ressources/_DATA/EACEI
[csync_reconcile    Reconciliation for remote replica took  0.151 seconds visiting  70342  files.
[OCC::SyncEngine::slotDiscoveryJobFinished  #### Reconcile end ####################################################  1096393 ms
[OCC::SyncJournalDb::setFileRecord  Updating file record for path: "02-En-cours/2018/PCAET-Citergie-vitre-communaute/01_El\xC3\xA9ments r\xC3\xA9""dig\xC3\xA9s/Pr\xC3\xA9sentations/20181203_COPIL_Diagnostic/Vitre-com-COPIL-Diagnostic_vf.pptx" inode: 31326406 modtime: 1543613177 type: 0 etag: "4d2c8aacc0c2368bbcbbaa4462cbefa1" fileId: "00206908oc9b16e44659" remotePerm: "WDNVRS" fileSize: 17805082 checksum: "SHA1:dd30e558a1525cddc2e475ebf755583bca569bd9" e2eMangledName: ""
[OCC::SqlQuery::prepare     Sqlite prepare statement error: "unknown function: parent_hash()" in "INSERT OR REPLACE INTO metadata (phash, pathlen, path, inode, uid, gid, mode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentChecksum, contentChecksumTypeId, e2eMangledName) VALUES (?1 , ?2, ?3 , ?4 , ?5 , ?6 , ?7,  ?8 , ?9 , ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);"
[OCC::SqlQuery::prepare     ENFORCE: "allow_failure" in file /build/nextcloud-client-ymYnWp/nextcloud-client-2.6.4/src/common/ownsql.cpp, line 269 with message: SQLITE Prepare error

Hope it helps !

My workaround, at that point, was to switch to owncloud-client (which works well).

[matis-schotte]

Sorry off topic, but the owncloud-client is compatible to nextcloud? Good to know since I also have crashes.

[simogeo]

@matis-schotte : fortunately, it is !

[machinekoder]

Thanks, switched to owncloud-client as well.

[matis-schotte]

Yeah, after using the OwnCloud client for a while now I can confirm that that works quite nice, no problems.
The nextcloud client unfortunately needs _alot_ of polishing....

Am 13.06.2020 um 02:15 schrieb Alexander Rössler [e-mail]:

Thanks, switched as well.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.

[michnovka]

Same issue with Nextcloud version 2.6.5-20200713.144448.adada8b2e-1.0~bionic1 on Kubuntu 20.04

2020-07-17 20:42:10:508 [ info nextcloud.sync.database ]:       Updating file record for path: "Company/csob_vypis.pdf" inode: 2888736 modtime: 1572341215 type: 0 etag: "4ac01569f44ea00829b31152817e589d" fileId: "00047908ochoj4cc0e60" remotePerm: "WDNVRS" fileSize: 41003 checksum: "" e2eMangledName: ""
2020-07-17 20:42:10:508 [ warning nextcloud.sync.database.sql ]:        Sqlite prepare statement error: "unknown function: parent_hash()" in "INSERT OR REPLACE INTO metadata (phash, pathlen, path, inode, uid, gid, mode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentChecksum, contentChecksumTypeId, e2eMangledName) VALUES (?1 , ?2, ?3 , ?4 , ?5 , ?6 , ?7,  ?8 , ?9 , ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);"
2020-07-17 20:42:10:508 [ fatal default ]:      ENFORCE: "allow_failure" in file /build/nextcloud-desktop-j_NMw5/nextcloud-desktop-2.6.5-20200713.144448.adada8b2e/src/common/ownsql.cpp, line 269 with message: SQLITE Prepare error

[er-vin]

Well, the problem is more with mixing owncloud client and nextcloud client. They create in index depending on a parent_hash() function that they provide from within the runtime code of their client. When an insert is then done from another client in the same journal db this can only crash since sqlite won't find the function.

This is why you don't get a crash with the owncloud client, you got a journal db compatible with owncloud client only.

You can get back on your feet by stopping all clients and then removing the journal db. When you'll start the client again it will make a full sync though, depending on the situation this can take a while.