restarting mysql fails horribly, propagates error output/warning to file

[hansbogert]

So I was doing a apt-get full-upgrade on my owncloud server, apparently my client was updating a fairly large src repo of some university project.

More than 20 files were corrupted by similar text like the following:

tests/error/Duplicate.spt:<b>can not connect to database, using mysql. (SQLSTATE[HY000] [2002]     Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2))</center>

Waiting long enough, this of course syncs back to the server, worst thing is, that history wasn't available.

These kind of things just keep bugging ownCloud making it a non-viable option. servers can crash, mysql can crash, that's not a reason for file sync to go berserk, in fact, it should be heavily tested with this in mind.

[DeepDiver1975]

which version are you using?

[hansbogert]

4.5.0, just updated to 4.5.2
Is this a known bug for this version?

Clients were on latest:
aptitude show owncloud-client
Package: owncloud-client
State: installed
Automatically installed: no
Version: 1.1.2-3

[tanghus]

Isn't this fixed by ccdaec6 ? /cc @DeepDiver1975

[DeepDiver1975]

ccdaec6 is unrelated

[bartv2]

OC5 doesn't have this problem anymore, because of d58cee2. Found a problem with the webui because of testing this. Fixed that with #1865.

[BernhardPosselt]

Can you retest this with current master @hansbogert ?

The fix from bartv is merged now.

[MorrisJobke]

@hansbogert please reopen if the current version doesn't fix this for you

[sebastiaanluca]

Running 5.0.5. Don't know what happened exactly, but when I woke my Mac from sleep, all my files were gone… So awesome!

Log continuously spams:
"SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

—
Follow-up:

isWebDAVWorking: NO - Reason: exception 'Sabre_DAV_Exception' with message '[CURL] Error while making request: Maximum (5) redirects followed (error code: 47)' in /var/www/owncloud/3rdparty/Sabre/DAV/Client.php:410 Stack trace: #0 /var/www/owncloud/3rdparty/Sabre/DAV/Client.php(179): Sabre_DAV_Client->request('PROPFIND', '', '<?xml version="...', Array) #1 /var/www/owncloud/lib/util.php(593): Sabre_DAV_Client->propFind('', Array) #2 /var/www/owncloud/settings/admin.php(34): OC_Util::isWebDAVWorking() #3 /var/www/owncloud/lib/route.php(113) : runtime-created function(1): require_once('/var/www/ownclo...') #4 [internal function]: __lambda_func(Array) #5 /var/www/owncloud/lib/router.php(127): call_user_func('?lambda_131', Array) #6 /var/www/owncloud/lib/base.php(608): OC_Router->match('/settings/admin') #7 /var/www/owncloud/index.php(28): OC::handleRequest() #8 {main}

[VicDeo]

@quagh Sorry for that, but for now I see only that MySQL server was probably down. It's not clear what needs to be addressed here.
Please update your report according to the issue template. https://raw.github.com/owncloud/core/master/issue_template.md

[jancborchardt]

I’m closing this issue because it has been inactive for a few months. This probably means it’s not reproducible or it has been fixed in a newer version.

Please reopen if the error still persists with the latest stable version (currently ownCloud 5.0.9) and then please use the issue template. You an also contribute directly by providing a patch – see the developer manual. :)

Thank you!

[enoch85]

#4395