Hangup running cron.php #23912
Comments
|
Please run the follow SQL command: SELECT @@GLOBAL.tx_isolation, @@tx_isolation |
|
no change |
|
It's not about a change, but the out come of that query would be good to know |
|
@@GLOBAL.tx_isolation=REPEATABLE-READ@@tx_isolation=REPEATABLE-READ It's not about a change, but the out come of that query would be good to know — |
|
As per our docs, you need to change it to |
case closed |
|
This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs. |
Steps to reproduce
start cron.php by hand "sudo -u www-data php cron.php"
The System runs and do his cleanup tasks.
Actual behaviour
The script runsmore than 1 hour and stops with console output below.
Server configuration
Operating system: Debian 8.3
Web server: Apache/2.4.10 (Debian)
Database: MySql 5.5.47-0+deb8u1
PHP version: PHP 5.6.17-0+deb8u1
ownCloud version: ownCloud 9.0.0 (stable)
fresh install:
Where did you install ownCloud from: Package
https://download.owncloud.org/download/repositories/stable/owncloud/
Signing status (ownCloud 9.0 and above):
No errors have been found.
List of activated apps:
Enabled:
activity: 2.2.1
false, 'instanceid' => 'occ3ejr96j1h', 'passwordsalt' => '', 'secret' => '', 'trusted_domains' => array ( 0 => 'oc.strube-saat.net', ), 'datadirectory' => '/var/owncloud', 'overwrite.cli.url' => 'http://oc.strube-saat.net/owncloud', 'dbtype' => 'mysql', 'version' => '9.0.0.19', 'dbname' => 'owncloud', 'dbhost' => 'localhost', 'dbtableprefix' => 'oc_', 'dbuser' => 'owncloud', 'dbpassword' => 'secret', 'logtimezone' => 'UTC', 'installed' => true, 'ldapIgnoreNamingRules' => false, 'memcache.local' => '\OC\Memcache\APCu', 'mail_smtpmode' => 'smtp', 'mail_from_address' => 'owncloud', 'mail_domain' => 'strube.net', 'mail_smtphost' => '10.1.1.10', 'mail_smtpport' => '25', 'loglevel' => 1, ); Are you using external storage, if yes which one: smb Are you using encryption: no Are you using an external user-backend, if yes which one: ActiveDirectory. LDAP configuration (delete this part if not used) +-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Configuration | s01 | +-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | hasMemberOfFilterSupport | 1 | | hasPagedResultSupport | | | homeFolderNamingRule | attr:sAMAccountName | | lastJpegPhotoLookup | 0 | | ldapAgentName | LdapReader | | ldapAgentPassword | **\* | | ldapAttributesForGroupSearch | | | ldapAttributesForUserSearch | | | ldapBackupHost | x.x.x.x | | ldapBackupPort | 389 | | ldapBase | DC=strube-saat,DC=loc | | ldapBaseGroups | DC=strube-saat,DC=loc | | ldapBaseUsers | DC=strube-saat,DC=loc | | ldapCacheTTL | 600 | | ldapConfigurationActive | 1 | | ldapDynamicGroupMemberURL | | | ldapEmailAttribute | mail | | ldapExperiencedAdmin | 0 | | ldapExpertUUIDGroupAttr | | | ldapExpertUUIDUserAttr | | | ldapExpertUsernameAttr | | | ldapGroupDisplayName | cn | | ldapGroupFilter | (|(cn=Owncloud-Users)(cn=Domänen-Admins)(cn=Domänen-Benutzer)(cn=Domain Users)(cn=Domain Users)(cn=Res_Ablage)(cn=Res_Ablage)(cn=Res_Allgem)(cn=Res_Allgem)(cn=Res_Aussendienst)(cn=Res_AxTerminal)(cn=Res_BDE)(cn=Res_Berater)(cn=Res_Betriebsrat)(cn=Res_Betriebstechnik)(cn=Res_Biotechnologie)(cn=Res_Bosch)(cn=Res_Breeder)(cn=Res_CT-data)(cn=Res_CT-data)(cn=Res_Controlling)(cn=Res_Daenemark)(cn=Res_EDV)(cn=Res_EDV)(cn=Res_Esp)(cn=Res_FRSDGL)(cn=Res_FRSDGL)(cn=Res_Fibu)(cn=Res_Fibu)(cn=Res_FoerderProjects)(cn=Res_FuE-Ruebe)(cn=Res_FuE-Sonnenblume)(cn=Res_Fuhrpark)(cn=Res_GFCO)(cn=Res_Geno)(cn=Res_Geno)(cn=Res_Getreide)(cn=Res_Italien)(cn=Res_Kommunikation)(cn=Res_MIS)(cn=Res_MIS)(cn=Res_Mais)(cn=Res_Marketing)(cn=Res_Oeffentlichkeitsarbeit)(cn=Res_PM_SQL)(cn=Res_Perso_sub)(cn=Res_Personal)(cn=Res_Personal)(cn=Res_Personalentwicklung)(cn=Res_ProdRuebe)(cn=Res_Produktmarketing)(cn=Res_Public)(cn=Res_Recht)(cn=Res_Ruebe)(cn=Res_Ruebe)(cn=Res_SDGL)(cn=Res_SDGL)(cn=Res_SG)(cn=Res_SG)(cn=Res_SK)(cn=Res_SK)(cn=Res_SP)(cn=Res_SP)(cn=Res_Schichtplan_Perso)(cn=Res_Schichtplan_SK)(cn=Res_Schulung)(cn=Res_Sonnenblume)(cn=Res_VertriebInternational)(cn=Res_VertriebInternational2)(cn=Res_Verwaltung)(cn=Res_Verwaltung)(cn=Res_Waren)(cn=Res_Waren)(cn=Res_hellsped)(cn=Res_hellsped)(cn=Res_nwold)(cn=Res_nwold)(cn=Res_pmr-sq)) | | ldapGroupFilterGroups | Owncloud-Users;Domänen-Admins;Domänen-Benutzer;Domain Users;Domain Users;Res_Ablage;Res_Ablage;Res_Allgem;Res_Allgem;Res_Aussendienst;Res_AxTerminal;Res_BDE;Res_Berater;Res_Betriebsrat;Res_Betriebstechnik;Res_Biotechnologie;Res_Bosch;Res_Breeder;Res_CT-data;Res_CT-data;Res_Controlling;Res_Daenemark;Res_EDV;Res_EDV;Res_Esp;Res_FRSDGL;Res_FRSDGL;Res_Fibu;Res_Fibu;Res_FoerderProjects;Res_FuE-Ruebe;Res_FuE-Sonnenblume;Res_Fuhrpark;Res_GFCO;Res_Geno;Res_Geno;Res_Getreide;Res_Italien;Res_Kommunikation;Res_MIS;Res_MIS;Res_Mais;Res_Marketing;Res_Oeffentlichkeitsarbeit;Res_PM_SQL;Res_Perso_sub;Res_Personal;Res_Personal;Res_Personalentwicklung;Res_ProdRuebe;Res_Produktmarketing;Res_Public;Res_Recht;Res_Ruebe;Res_Ruebe;Res_SDGL;Res_SDGL;Res_SG;Res_SG;Res_SK;Res_SK;Res_SP;Res_SP;Res_Schichtplan_Perso;Res_Schichtplan_SK;Res_Schulung;Res_Sonnenblume;Res_VertriebInternational;Res_VertriebInternational2;Res_Verwaltung;Res_Verwaltung;Res_Waren;Res_Waren;Res_hellsped;Res_hellsped;Res_nwold;Res_nwold;Res_pmr-sq | | ldapGroupFilterMode | 0 | | ldapGroupFilterObjectclass | | | ldapGroupMemberAssocAttr | member | | ldapHost | 10.1.1.1 | | ldapIgnoreNamingRules | | | ldapLoginFilter | (&(&(|(objectclass=person)(objectclass=user))(|(|(memberof=CN=Domänen-Admins,CN=Users,DC=strube-saat,DC=loc)(primaryGroupID=512))(|(memberof=CN=Domänen-Benutzer,CN=Users,DC=strube-saat,DC=loc)(primaryGroupID=513))(|(memberof=CN=Domain Users,CN=Users,DC=ru,DC=strube-saat,DC=loc)(primaryGroupID=513))(|(memberof=CN=Domain Users,CN=Users,DC=ru,DC=strube-saat,DC=loc)(primaryGroupID=513))))(|(samaccountname=%uid)(|(mailPrimaryAddress=%uid)(mail=%uid)))) | | ldapLoginFilterAttributes | | | ldapLoginFilterEmail | 1 | | ldapLoginFilterMode | 0 | | ldapLoginFilterUsername | 1 | | ldapNestedGroups | 0 | | ldapOverrideMainServer | | | ldapPagingSize | 500 | | ldapPort | 3268 | | ldapQuotaAttribute | | | ldapQuotaDefault | | | ldapTLS | 0 | | ldapUserDisplayName | displayname | | ldapUserDisplayName2 | | | ldapUserFilter | (&(|(objectclass=person)(objectclass=user))(|(|(memberof=CN=Domänen-Admins,CN=Users,DC=strube-saat,DC=loc)(primaryGroupID=512))(|(memberof=CN=Domänen-Benutzer,CN=Users,DC=strube-saat,DC=loc)(primaryGroupID=513))(|(memberof=CN=Domain Users,CN=Users,DC=ru,DC=strube-saat,DC=loc)(primaryGroupID=513))(|(memberof=CN=Domain Users,CN=Users,DC=ru,DC=strube-saat,DC=loc)(primaryGroupID=513)))) | | ldapUserFilterGroups | Domänen-Admins;Domänen-Benutzer;Domain Users;Domain Users | | ldapUserFilterMode | 0 | | ldapUserFilterObjectclass | person;user | | ldapUuidGroupAttribute | auto | | ldapUuidUserAttribute | auto | | turnOffCertCheck | 1 | | useMemberOfToDetectMembership | 1 | +-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Client configuration Browser: Chrome 49.0.2623.110 m (64-bit) Operating system: Windows 10 Logs Output from Console sudo -u www-data php cron.php PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91 Stack trace: #0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array) #1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(989): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 /var/www/owncloud/lib/private/db/connection.php(205): Doctrine\DBAL\Connection->executeUpdate('UPDATE `oc_file...', Array, Array) #3 /var/www/owncloud/lib/private/lock/dblockingprovider.php(263): OC\DB\Connection->executeUpdate('UPDATE `*PREFIX...', Array) #4 [internal function]: OC\Lock\DBLockingProvider->releaseAll() #5 {main} Next exception 'Doctrine\DBAL\Driver\PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /var/www/owncloud/3rdparty/doctr in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 115comments: 0.2
dav: 0.1.5
federatedfilesharing: 0.1.0
federation: 0.0.4
files: 1.4.4
files_external: 0.5.2
files_pdfviewer: 0.8
files_sharing: 0.9.1
files_texteditor: 2.1
files_trashbin: 0.8.0
files_versions: 1.2.0
files_videoplayer: 0.9.8
firstrunwizard: 1.1
gallery: 14.5.0
notifications: 0.2.3
provisioning_api: 0.4.1
systemtags: 0.2
templateeditor: 0.1
updatenotification: 0.1.0
user_ldap: 0.8.0 Disabled:
encryption
external
user_external
The content of config/config.php:
The text was updated successfully, but these errors were encountered: