Client won't start with sqlite prepare error

help

#1

Hi guys,
I'm new to the forum but not to owncloud in general. I have a problem with the sync client. It simply won't start. The logfile says the following (last few lines):

09-20 22:46:32:808 0x162f460 void OCC::SyncJournalDb::commitInternal(const QString&, bool) Transaction commit  "checkConnect" and starting new transaction 
09-20 22:46:32:808 0x162f460 Columns in the current journal:  ("phash", "pathlen", "path", "inode", "uid", "gid", "mode", "modtime", "type", "md5", "fileid", "remotePerm", "filesize", "ignoredChildrenRemote", "contentChecksum", "contentChecksumTypeId") 
09-20 22:46:32:808 0x162f460 void OCC::SyncJournalDb::commitInternal(const QString&, bool) Transaction commit  "update database structure: add inode index" and starting new transaction 
09-20 22:46:32:808 0x162f460 void OCC::SyncJournalDb::commitInternal(const QString&, bool) Transaction commit  "update database structure: add path index" and starting new transaction 
09-20 22:46:32:808 0x162f460 Columns in the current journal:  ("path", "lastTryEtag", "lastTryModtime", "retrycount", "errorstring", "lastTryTime", "ignoreDuration", "renameTarget") 
09-20 22:46:32:809 0x162f460 void OCC::SyncJournalDb::commitInternal(const QString&, bool) Transaction commit  "checkConnect End"  
09-20 22:46:32:811 0x162f460 Sqlite prepare statement error: "unable to open database file" in "PRAGMA quick_check;" 
09-20 22:46:32:811 0x162f460 ASSERT: "!"SQLITE Prepare error"" in file /usr/src/packages/BUILD/src/libsync/ownsql.cpp, line 215

Steps to reproduce
1. Start the client

Expected behaviour
Client comes up and begins to sync or show the configuration screen

Actual behaviour
Nothing happens.

Client configuration
Client version: 2.2.3
Client operating system: Xubuntu 14.04 LTS 64 Bit

Server configuration
Operating system: Ubuntu 16.04 LTS 64 Bit
Web server: Apache2
Database: MySQL
PHP version: 7.0.8-0ubuntu0.16.04.2
ownCloud version (see ownCloud admin page): 9.1.0
Updated from an older ownCloud or fresh install: Fresh install

Thanks in advance for any help!
Regards,
siegmund


#2

@dragotin @guruz can you help?


#3

The log say "unable to open database file"

Whch means maybe the database file is corrupted.
The database file is named .csync_journal.db in your sync folder. (it's an hidden file.)
I don't exactly what is corrupted, or how.

Moving this file away will cause a full resync and will probably solve your problem if you look for a quick fix. But this might cause some downloads and some conflict files.


#4

Thanks @ogoffart for the hint!
I checked my synced folders and moved the database files while I noticed that my file system somehow was broken. There where two files ( ".csync_journal.db-shm", ".csync_journal.db-wal" ) that seemed to be broken (Ubuntu gave me an Input/Output-Error on these).
After executing chkdsk on windows (it was a ntfs partition) everything is fine now.
So I guess this wasn't directly related to/the fault of owncloud, was it?