CSync failed to load or create the journal file - SQlite error?

[rudo54]

Hello,

I can not sync my tablet with Windows 8.1, the following error message appears:

that means: CSync failed to load or create the journal file. Make sure you have read and write permissions in the local sync directory.

The error occurred since the update to version 1.7.1, so far everything has worked.

I have a total of four folders to sync. Two of them on the hard drive C: and two on drive D:, wich is on a SD card.

The error only occurs with the two folders on the SD card, with the folders on drive C: owncloud-sync works.

I've tried multiple what I found on the forum:

• client deleted and reinstalled,
• client and server are on the latest version,
• delete folder and recreate,
• The drive D: through C: integrated,
• The permissions newly allocated, etc.

When I create a new sync folder with ownCloud, the new folder is created on the drive and the files
.csync_journal.db
.csync_journal.db-shm
.csync_journal.db Whale
.owncloudsync.log
are stored there. I think, missing r/w permissions can not cause this issue.

There may be a connection with the problem discussed here:
#2547

My log file:

https://gist.github.com/0f9f84a34c415a2a6ea9.git

The issue was discussed here (in german):
http://forum.owncloud.org/viewtopic.php?f=21&t=25545

I hope, there is some help,
sorry for my bad english,

Regards, Lothar

[ogoffart]

It looks like the database is corrupted

12-30 13:01:48:322 0x8e21664 csync_statedb_query: sqlite3_compile error: disk I/O error - on query PRAGMA quick_check;
12-30 13:01:48:322 0x8e21664 csync_statedb_load: ERR: sqlite3 integrity check failed - bail out: disk I/O error.

Now the question is how and why did that happen?

[ogoffart]

It appears that the local database is corrupted.
I have made a commit so 1.8 will explixitly say that the database is corrupted.

Maybe we should have some mechanisms to automatically recover from corrupted journal?

[craigpg]

What is the workaround when the database gets corrupted?

[guruz]

@craigp I don't think it is corrupted. I think the problem is #2701

[dragotin]

lets close this one as a duplicate of #2701 This one is about SD-Card which probably also uses FAT file system.

[guruz]

@rudo54 Could you find out the exact file system on the SD?

[rudo54]

Hi,
the filesystem was exFAT.
I bought a new card and formatted it with NTFS. Now my owncloud is
working again.

But I don't understand, why the old card worked for 2 years.

------ Originalnachricht ------
Von: "Markus Goetz" notifications@github.com
An: "owncloud/client" client@noreply.github.com
Cc: "rudo54" lo.franke@posteo.de
Gesendet: 20.01.2015 12:46:59
Betreff: Re: [client] CSync failed to load or create the journal file -
SQlite error? (#2673)

@rudo54 Could you find out the exact file system on the SD?

—
Reply to this email directly or view it on GitHub.