The client hangs in a "pending" state. Some problems with server configuration

Server
1

Steps to reproduce

  1. I find it difficult to answer this question

Expected behaviour

The server should work without errors. The client should not “hang” in a “pending” state.

Actual behaviour

Multiple server errors:
owncloud.log:

  1. “message”:“token xxx does not exist”
  2. “message”:“Abandoning paged search - last cookie: ‘’, cookies: <>”
  3. “message”:“Cookie for cn=sia57 1,ou=sia57,ou=YYY,ou=ZZZ,dc=DDD,dc=CCC at 0-500 is ‘’”
    crash.log:
  4. “message”: “Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2006] MySQL server has gone away”
  5. “message”: “Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1040] Too many connections”

The problem lies in the fact that the client, for unknown reasons, stops synchronizing files and hangs in the “pending” state.


The statistics are such that 20-30 clients out of 400 “freeze” per day.
And they require manual intervention.

Server configuration

Operating system:
Ubuntu 20.04.1 LTS
Linux drive 5.4.0-64-generic #72-Ubuntu SMP Fri Jan 15 10:27:54 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

Web server:
nginx/1.19.6

Database:
10.3.25-MariaDB-0ubuntu0.20.04.1

PHP version:
PHP 7.4.3

ownCloud version: (see ownCloud admin page)
10.5.0.10

Updated from an older ownCloud or fresh install:
Updated from 10.0.6 after problems with clients of versions 2.7.x

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):
No errors have been found.

The content of config/config.php:
“config”: {
“updatechecker”: false,
“instanceid”: “oc04ujnl5w5l”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“drive.domain.name”,
“cloud.domain.name”
],
“datadirectory”: “/storage”,
“overwrite.cli.url”: “https://drive.domain.name/owncloud”,
“dbtype”: “mysql”,
“version”: “10.5.0.10”,
“dbname”: “owncloud”,
“dbhost”: “localhost”,
“dbtableprefix”: “oc_”,
“dbuser”: “REMOVED SENSITIVE VALUE”,
“dbpassword”: “REMOVED SENSITIVE VALUE”,
“logtimezone”: “UTC”,
“installed”: true,
“ldapIgnoreNamingRules”: false,
“loglevel”: 0,
“maintenance”: false,
“appstore.experimental.enabled”: true,
“memcache.distributed”: “\OC\Memcache\Redis”,
“memcache.locking”: “\OC\Memcache\Redis”,
“memcache.local”: “\OC\Memcache\APCu”,
“redis”: {
“host”: “/var/run/redis/redis.sock”,
“port”: 0
},
“trashbin_retention_obligation”: “1, 3”,
“versions_retention_obligation”: “1, 3”
},

List of activated apps:
Enabled:

  • comments: 0.3.0
  • configreport: 0.2.0
  • dav: 0.6.0
  • federatedfilesharing: 0.5.0
  • federation: 0.1.0
  • files: 1.5.2
  • files_external: 0.7.1
  • files_sharing: 0.13.0
  • files_texteditor: 2.3.0
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • firstrunwizard: 1.2.0
  • gallery: 16.1.1
  • market: 0.6.0
  • notifications: 0.5.2
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • templateeditor: 0.4.0
  • updatenotification: 0.2.1
  • user_ldap: 0.15.2
    Disabled:
  • activity
  • audioplayer
  • calendar
  • documents
  • encryption
  • external
  • files_antivirus
  • files_mediaviewer
  • files_pdfviewer
  • user_external
  • xmas

Are you using external storage, if yes which one: local/smb/sftp/…

Are you using encryption: yes/no
no

Are you using an external user-backend, if yes which one:
LDAP

LDAP configuration (delete this part if not used)

±------------------------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Configuration | s01 |
±------------------------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hasMemberOfFilterSupport | 1 |
| hasPagedResultSupport | |
| homeFolderNamingRule | attr:sAMAccountName |
| lastJpegPhotoLookup | 0 |
| ldapAgentName | CN=Cloud,OU=Admins,DC=domain,DC=name |
| ldapAgentPassword | *** |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | |
| ldapBackupHost | |
| ldapBackupPort | |
| ldapBase | DC=domain,DC=name |
| ldapBaseGroups | DC=domain,DC=name |
| ldapBaseUsers | DC=domain,DC=name |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | 1 |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | |
| ldapExpertUUIDUserAttr | objectguid |
| ldapExpertUsernameAttr | |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | (&(|(objectclass=group))(|(cn=Marketyng)(cn=Domain Admins)(cn=Domain Users))) |
| ldapGroupFilterGroups | Marketyng;Domain Admins;Domain Users |
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | group |
| ldapGroupMemberAssocAttr | member |
| ldapHost | domain.name |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | (&(&(|(objectclass=person))(|(|(memberof=CN=Domain Admins,CN=Users,DC=domain,DC=name)(primaryGroupID=512))(|(memberof=CN=Domain Users,CN=Users,DC=domain,DC=name)(primaryGroupID=513))))(|(samaccountname=%uid)(|(mailPrimaryAddress=%uid)(mail=%uid))(|(cn=%uid)(userPrincipalName=%uid)))) |
| ldapLoginFilterAttributes | cn;userPrincipalName |
| ldapLoginFilterEmail | 1 |
| ldapLoginFilterMode | 0 |
| ldapLoginFilterUsername | 1 |
| ldapNestedGroups | 0 |
| ldapNetworkTimeout | 2 |
| ldapOverrideMainServer | |
| ldapPagingSize | 500 |
| ldapPort | 3268 |
| ldapQuotaAttribute | |
| ldapQuotaDefault | |
| ldapTLS | 0 |
| ldapUserDisplayName | displayName |
| ldapUserDisplayName2 | |
| ldapUserFilter | (&(|(objectclass=person))(|(|(memberof=CN=Domain Admins,CN=Users,DC=domain,DC=name)(primaryGroupID=512))(|(memberof=CN=Domain Users,CN=Users,DC=domain,DC=name)(primaryGroupID=513)))) |
| ldapUserFilterGroups | Domain Admins;Domain Users |
| ldapUserFilterMode | 0 |
| ldapUserFilterObjectclass | person |
| ldapUserName | samaccountname |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| turnOffCertCheck | 0 |
| useMemberOfToDetectMembership | 1 |
±------------------------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Client configuration

Browser:

Operating system:
Win 7 x64 Pro

Logs

Web server error log

2021/02/09 13:30:11 [error] 825#825: *117783 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /var/www/owncloud/lib/private/DB/Connection.php:62

2021/02/09 12:00:11 [error] 825#825: *1292 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1040] Too many connections in /var/www/owncloud/lib/private/DB/Connection.php:62

ownCloud log (data/owncloud.log)

{“reqId”:“25adb674-2f7e-4dc2-95cb-0539ff31777e”,“level”:0,“time”:“2021-02-09T11:18:57+00:00”,“remoteAddr”:“xxx.xxx.xxx.xxx”,“user”:“3D275483-8D61-45A7-A2EC-22AC641F7966”,“app”:“user_ldap”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/3D275483-8D61-45A7-A2EC-22AC641F7966/",“message”:“Abandoning paged search - last cookie: ‘’, cookies: <>”}

{“reqId”:“25adb674-2f7e-4dc2-95cb-0539ff31777e”,“level”:0,“time”:“2021-02-09T11:18:57+00:00”,“remoteAddr”:“xxx.xxx.xxx.xxx”,“user”:“3D275483-8D61-45A7-A2EC-22AC641F7966”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/3D275483-8D61-45A7-A2EC-22AC641F7966/",“message”:“token eb07214213771d11b5ad483781e5626060ba0373ab975aebd3a13a18fd3e46f0851d974dbb04903b84e31982929f927fe84643881ee774292e8baabedbf7ddf6 does not exist”}

Browser log

there are no problems in the browser

2

I reported additional information in bugs:

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.