Fatal Error causing sync loss

Ask all your questions regarding OC 8.0 and 8.1 Please read the Support Forum Rules
Forum rules
The forums were migrated over to https://central.owncloud.org which is based on the forum software Discourse. The forums here is put into read-only mode starting from today.

More background information about this move and the reasoning behind it is available in this blogpost:

https://daniel.molkentin.net/2016/07/20 ... d-central/
balornt
Newbie
Posts: 3
Joined: Tue Mar 31, 2015 8:44 pm
ownCloud version: 8.0.2
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.5.9

Fatal Error causing sync loss

Postby balornt » Wed Apr 01, 2015 11:42 pm

I installed a new Owncloud 8.0.2 server on Ubuntu 14.04 using Apache2 and MySQL. It installed without a hitch, but about three-four times a day owncloud portion of my webserver times out and none of my clients are able to sync. I have three windows clients currently. The only way to restore syncing is to restart apache.

Apache is running correctly when this happens as my website is still reachable (thankfully). The mysql server is still running as expected.

After restarting apache I check the owncloud logs and have this sort of error message repeatedly

Code: Select all

DB Error: "An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`path_hash`,`path`,`parent`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `mimepart` = ? AND `mimetype` = ? AND `mtime` = ? AND `size` = ? AND `etag` = ? AND `storage_mtime` = ? AND `permissions` = ? AND `path_hash` = ? AND `path` = ? AND `parent` = ? AND `name` = ? AND `storage` = ? HAVING COUNT(*) = 0' with params ["1", "2", "1427859912", "-1", "551b69c83ecf6", "1427859912", "31", "3b8779ba05b8f0aed49650f3ff8beb4b", "thumbnails", "1", "thumbnails", "1", "1", "2", "1427859912", "-1", "551b69c83ecf6", "1427859912", "31", "3b8779ba05b8f0aed49650f3ff8beb4b", "thumbnails", "1", "thumbnails", "1"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-3b8779ba05b8f0aed49650f3ff8beb4b' for key 'fs_storage_path_hash'"<br />Offending command was: INSERT INTO `*PREFIX*filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`path_hash`,`path`,`parent`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,? FROM `*PREFIX*filecache` WHERE `mimepart` = ? AND `mimetype` = ? AND `mtime` = ? AND `size` = ? AND `etag` = ? AND `storage_mtime` = ? AND `permissions` = ? AND `path_hash` = ? AND `path` = ? AND `parent` = ? AND `name` = ? AND `storage` = ? HAVING COUNT(*) = 0<br />


I have noticed that numerous bugs have been reported about this over the last 2+ years. Is there still no resolution to this problem?

RealRancor
ownCloud master
Posts: 17381
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 9.0.2
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 7.0.x

Re: Fatal Error causing sync loss

Postby RealRancor » Thu Apr 02, 2015 7:38 am

Hi,

if Apache is freezing try to remove the package php5-apcu which was causing such freezes of Apache.

There should be already a test in OC 8.0.2 but maybe this is not working reliable?
*gone*

balornt
Newbie
Posts: 3
Joined: Tue Mar 31, 2015 8:44 pm
ownCloud version: 8.0.2
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.5.9

Re: Fatal Error causing sync loss

Postby balornt » Thu Apr 02, 2015 8:35 pm

RealRancor wrote:Hi,

if Apache is freezing try to remove the package php5-apcu which was causing such freezes of Apache.

There should be already a test in OC 8.0.2 but maybe this is not working reliable?


Apache itself was never completely frozen, just the homepage for owncloud. I did see warnings about an out of date APCu installation on Owncloud's admin page, but hadn't gotten around to googling what it was and whether I needed it. Since my packages are up to date and I have no intention of building php from source, I'll try uninstalling the apcu package and see if it fixes the problems.

balornt
Newbie
Posts: 3
Joined: Tue Mar 31, 2015 8:44 pm
ownCloud version: 8.0.2
Webserver: Apache
Database: MySQL
OS: Linux
PHP version: 5.5.9

Re: Fatal Error causing sync loss

Postby balornt » Fri Apr 03, 2015 10:54 pm

Sure enough, uninstalling php5-apcu did the trick. :D

RealRancor
ownCloud master
Posts: 17381
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 9.0.2
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 7.0.x

Re: Fatal Error causing sync loss

Postby RealRancor » Sat Apr 04, 2015 12:29 pm

Mhhh, strange. Normally APCu should be detected an disabled in OC 8.0.2:

https://github.com/owncloud/core/blob/v ... hp#L87-L89
*gone*


  • Similar Topics
    Replies
    Views
    Last post

Return to “ownCloud Server 8.0 and 8.1”

Who is online

Users browsing this forum: No registered users and 3 guests