[Help] High load on database, oc_cards table

HattabbI4 · October 29, 2018, 6:12am

Hello!
I have the following problem:
Every second there is an error in the logs
for security, I have cut or replaced my personal data

Error

{"reqId":"4L2QtzgYypeFwAgZIhNX","level":3,"time":"2018-10-26T10:15:14+00:00","remoteAddr":"10.101.86.29","user":"user.login","app":"no app in context","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)' with params [\"BEGIN:VCARD
VERSION:3.0
PRODID:-\\\/\\\/Sabre\\\/\\\/Sabre VObject 4.1.2\\\/\\\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\\\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
\", 1540548863, 9819, \"3752ad77983894e2625ce8a3e4a76e17\", \"LDAP:user.login.vcf\", \"2\"]:\n\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":0,"Trace":[{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":128,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)' with params [\"BEGIN:VCARD
VERSION:3.0
PRODID:-\\\/\\\/Sabre\\\/\\\/Sabre VObject 4.1.2\\\/\\\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\\\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
\", 1540548863, 9819, \"3752ad77983894e2625ce8a3e4a76e17\", \"LDAP:user.login.vcf\", \"2\"]:\n\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",{"errorInfo":["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1015,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)",{"1":"BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
","2":1540548863,"3":9819,"4":"3752ad77983894e2625ce8a3e4a76e17","5":"LDAP:user.login.vcf","6":"2"}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)",["BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
",1540548863,9819,"3752ad77983894e2625ce8a3e4a76e17","LDAP:user.login.vcf","2"],[3,2,2,2,2,2]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_cards` SET `carddata` = :dcValue1, `lastmodified` = :dcValue2, `size` = :dcValue3, `etag` = :dcValue4 WHERE (`uri` = :dcValue5) AND (`addressbookid` = :dcValue6)",{"dcValue1":"BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
","dcValue2":1540548863,"dcValue3":9819,"dcValue4":"3752ad77983894e2625ce8a3e4a76e17","dcValue5":"LDAP:user.login.vcf","dcValue6":"2"},{"dcValue1":3,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/CardDAV\/CardDavBackend.php","line":673,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/CardDAV\/SyncService.php","line":284,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["2","LDAP:user.login.vcf","BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/HookManager.php","line":142,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/legacy\/hook.php","line":106,"function":"changeUser","class":"OCA\\DAV\\HookManager","type":"->","args":[{"run":true,"user":"*** sensitive parameter replaced ***","feature":"*** sensitive parameter replaced ***","value":"*** sensitive parameter replaced ***","old_value":"*** sensitive parameter replaced ***"}]},{"file":"\/var\/www\/html\/lib\/private\/Server.php","line":421,"function":"emit","class":"OC_Hook","type":"::","args":["OC_User","changeUser",{"run":true,"user":"*** sensitive parameter replaced ***","feature":"*** sensitive parameter replaced ***","value":"*** sensitive parameter replaced ***","old_value":"*** sensitive parameter replaced ***"}]},{"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/EmitterTrait.php","line":99,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/PublicEmitter.php","line":36,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->","args":["\\OC\\User","changeUser",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/User.php","line":455,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->","args":["\\OC\\User","changeUser",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Avatar.php","line":191,"function":"triggerChange","class":"OC\\User\\User","type":"->","args":["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":598,"function":"set","class":"OC\\Avatar","type":"->","args":[null]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":573,"function":"setOwnCloudAvatar","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":553,"function":"updateAvatar","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/legacy\/hook.php","line":106,"function":"updateAvatarPostLogin","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[{"run":true,"uid":"*** sensitive parameter replaced ***","password":"*** sensitive parameter replaced ***"}]},{"file":"\/var\/www\/html\/lib\/private\/Server.php","line":410,"function":"emit","class":"OC_Hook","type":"::","args":["OC_User","post_login",{"run":true,"uid":"*** sensitive parameter replaced ***","password":"*** sensitive parameter replaced ***"}]},{"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/EmitterTrait.php","line":99,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/PublicEmitter.php","line":36,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->","args":["\\OC\\User","postLogin",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":370,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->","args":["\\OC\\User","postLogin",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":566,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":337,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":413,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":130,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Backend\/AbstractBasic.php","line":105,"function":"validateUserPass","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":252,"function":"check","class":"Sabre\\DAV\\Auth\\Backend\\AbstractBasic","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":155,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php","line":201,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php","line":150,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"autoRequireLogin":true,"__class__":"Sabre\\DAV\\Auth\\Plugin"},"beforeMethod"],[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":466,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["beforeMethod",[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/var\/www\/html\/remote.php","line":163,"args":["\/var\/www\/html\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":115,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)",["BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
",1540548863,9819,"3752ad77983894e2625ce8a3e4a76e17","LDAP:user.login.vcf","2"],[3,2,2,2,2,2]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_cards` SET `carddata` = :dcValue1, `lastmodified` = :dcValue2, `size` = :dcValue3, `etag` = :dcValue4 WHERE (`uri` = :dcValue5) AND (`addressbookid` = :dcValue6)",{"dcValue1":"BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
","dcValue2":1540548863,"dcValue3":9819,"dcValue4":"3752ad77983894e2625ce8a3e4a76e17","dcValue5":"LDAP:user.login.vcf","dcValue6":"2"},{"dcValue1":3,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/CardDAV\/CardDavBackend.php","line":673,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/CardDAV\/SyncService.php","line":284,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["2","LDAP:user.login.vcf","BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/HookManager.php","line":142,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/legacy\/hook.php","line":106,"function":"changeUser","class":"OCA\\DAV\\HookManager","type":"->","args":[{"run":true,"user":"*** sensitive parameter replaced ***","feature":"*** sensitive parameter replaced ***","value":"*** sensitive parameter replaced ***","old_value":"*** sensitive parameter replaced ***"}]},{"file":"\/var\/www\/html\/lib\/private\/Server.php","line":421,"function":"emit","class":"OC_Hook","type":"::","args":["OC_User","changeUser",{"run":true,"user":"*** sensitive parameter replaced ***","feature":"*** sensitive parameter replaced ***","value":"*** sensitive parameter replaced ***","old_value":"*** sensitive parameter replaced ***"}]},{"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/EmitterTrait.php","line":99,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/PublicEmitter.php","line":36,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->","args":["\\OC\\User","changeUser",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/User.php","line":455,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->","args":["\\OC\\User","changeUser",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Avatar.php","line":191,"function":"triggerChange","class":"OC\\User\\User","type":"->","args":["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":598,"function":"set","class":"OC\\Avatar","type":"->","args":[null]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":573,"function":"setOwnCloudAvatar","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[]},{"file":"\/var\/www\/html\/apps\/user_ldap\/lib\/User\/User.php","line":553,"function":"updateAvatar","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/legacy\/hook.php","line":106,"function":"updateAvatarPostLogin","class":"OCA\\User_LDAP\\User\\User","type":"->","args":[{"run":true,"uid":"*** sensitive parameter replaced ***","password":"*** sensitive parameter replaced ***"}]},{"file":"\/var\/www\/html\/lib\/private\/Server.php","line":410,"function":"emit","class":"OC_Hook","type":"::","args":["OC_User","post_login",{"run":true,"uid":"*** sensitive parameter replaced ***","password":"*** sensitive parameter replaced ***"}]},{"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/EmitterTrait.php","line":99,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/Hooks\/PublicEmitter.php","line":36,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->","args":["\\OC\\User","postLogin",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":370,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->","args":["\\OC\\User","postLogin",["*** sensitive parameter replaced ***","*** sensitive parameter replaced ***"]]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":566,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":337,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/lib\/private\/User\/Session.php","line":413,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":130,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Backend\/AbstractBasic.php","line":105,"function":"validateUserPass","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":252,"function":"check","class":"Sabre\\DAV\\Auth\\Backend\\AbstractBasic","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php","line":155,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php","line":201,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php","line":150,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"autoRequireLogin":true,"__class__":"Sabre\\DAV\\Auth\\Plugin"},"beforeMethod"],[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":466,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["beforeMethod",[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/var\/www\/html\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/cloud.domain.com\/remote.php\/webdav\/","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/var\/www\/html\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/var\/www\/html\/remote.php","line":163,"args":["\/var\/www\/html\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":107,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":105,"function":"execute","class":"PDOStatement","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_cards` SET `carddata` = ?, `lastmodified` = ?, `size` = ?, `etag` = ? WHERE (`uri` = ?) AND (`addressbookid` = ?)",["BEGIN:VCARD
VERSION:3.0
PRODID:-\/\/Sabre\/\/Sabre VObject 4.1.2\/\/EN
UID:user.login
FN:<<cut username>>
N:<<cut username>>
EMAIL;TYPE=OTHER:user@domain.com
PHOTO;ENCODING=b;TYPE=image\/jpeg:<<cut jpeg code>>
CLOUD:user@cloud.domain.com
END:VCARD
",1540548863,9819,"3752ad77983894e2625ce8a3e4a76e17","LDAP:user.login.vcf","2"],[3,2,2,2,2,2]]},

<<this part is cut out due to the restriction of 35k characters, the full version of the logs below>>

full logs: https://drive.google.com/file/d/1gvJkucipJWMp_49XglgNbz0bpdNqPBrH/view?usp=sharing

while there is a high load on the database container

mytop

Help me please

Host OS: CentOS 7.3.1611 (Core)
App container OS: Debian GNU/Linux 9 (stretch)
DB container OS: Debian GNU/Linux 8 (jessie)
mysql  Ver 15.1 Distrib 10.2.12-MariaDB
Nextcloud 14.0.0.19

Ready to provide any data for monitoring

skjnldsv · October 29, 2018, 2:34pm

Hello!

What kind of server are you running this on?
A desktop? A dedicated server? Cloud? Raspberry pi?

Cheers,
John

HattabbI4 · October 30, 2018, 4:53am

Hi!
This is virtual machine running ESXi 6.0 based on the HP ProLiant BL460c G7
Intel Xeon E5620

HattabbI4 · October 30, 2018, 8:04am

New info:
This error generate by users which running the desktop client and having a photo in Active Directory. The desktop client with this error can’t connect to the server.
If I remove the photo from Active Directory, then error does not appear and the client successfully connects to server.

skjnldsv · October 30, 2018, 8:20am

So we can assume this is not a resource/power issue

Is it doing it for every cards saved?
Can you repair your indexes with occ ?
https://docs.nextcloud.com/server/14/admin_manual/configuration_server/occ_command.html?highlight=occ#add-missing-indices

-------- Message d’origine --------
On 30 oct. 2018 à 06:03, Roman Ivanov < noreply@nextcloud.com > a écrit :

HattabbI4 · October 30, 2018, 9:53am

Maybe

No, only desktop client users with a photo added to AD. Comment above ^

I did, no changes followed, the command worked in 1-2 seconds.

Check indices of the share table.
Done.

Sorry for translation

skjnldsv · October 30, 2018, 12:57pm

I missed your second message, sorry
When you say having a photo, you mean an image on their storagespace ?

HattabbI4 · October 30, 2018, 6:47pm

No, user-picture (avatar) in Active Directory.

skjnldsv · October 30, 2018, 7:38pm

Hum. This is nowhere related to the contacts app then. Could you open an issue on github.com/nextcloud/server

Thanks a lot!

HattabbI4 · October 31, 2018, 10:58am

Now this error is not only the users of the desktop client. Please help.
Users with avatar have slow login web application (1-2 min)
DB size 2 gb

database logs

2018-10-30 22:30:21 140246257780480 [Warning] Aborted connection 2857 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got an error writing communication packets)
2018-10-31  7:10:43 140246252930816 [Warning] Aborted connection 59189 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got timeout reading communication packets)
2018-10-31 10:18:30 140245990786816 [Warning] Aborted connection 106389 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-10-31 10:27:21 140246254446336 [Warning] Aborted connection 109014 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got timeout reading communication packets)
2018-10-31 10:30:22 140246255355648 [Warning] Aborted connection 112066 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got an error writing communication packets)
2018-10-31 10:46:38 140245983815424 [Warning] Aborted connection 113721 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got timeout reading communication packets)
2018-10-31 11:09:24 140245984421632 [Warning] Aborted connection 120386 to db: 'nextclouds' user: 'cloud_user' host: '172.18.0.3' (Got timeout reading communication packets)

HattabbI4 · November 1, 2018, 9:48am

In russian telegram chat dedicated mysql advised to make these settings:
in mariaDB use command set global innodb_buffer_pool_size=2*1024*1024*1024;
set in my.cnf: innodb_buffer_pool_size=2G

after a few minutes the errors ceased and the load decreased.
I understand that this is not a solution, but now the cloud is working.