[Fixed] Fail to fix indexes missing of mariadb database

ℹ️ Support
1
Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 22.2.5
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): nginx 1.21.6
PHP version (eg, 7.4): 7.4
Maridb server: 10.6.7

The issue you are facing:
After upgrade from 22.2.2 to 22.2.5, I got error from “Security & setup warnings”. It said

There are some warnings regarding your setup.

  • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
    • Missing index “properties_pathonly_index” in table “oc_properties”.
    • Missing index “job_lastcheck_reserved” in table “oc_jobs”.

I had to try to fix it with “occ db:add-missing-indices”. But I got

Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Check indices of the schedulingobjects table.
Check indices of the oc_properties table.
Adding properties_pathonly_index index to the oc_properties table, this can take some time…

In ExceptionConverter.php line 114:

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767
bytes

In Exception.php line 26:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

In Connection.php line 82:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

db:add-missing-indices

And, I try to fix with " Enabling MySQL 4-byte support". After this, and try to fix missing indexes with “db:add-missing-indices”, but I got the same errors.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. upgrade nexdcloud from 22.2.2 to 22.2.5
  2. check "Security && setup warnings ", found missing some indexes
  3. repair with “occ db:add-missing-indices”, got error

In ExceptionConverter.php line 114:

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767
bytes

In Exception.php line 26:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

In Connection.php line 82:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

  1. fix database with “Enabling MySQL 4-byte support”
  2. return to fix indexes missing with “occ db:add-missing-indices”, but got the same error form step 3

The output of your Nextcloud log in Admin > Logging:

{"reqId":"MrZBfRg1WNBNcA91Fqit","level":0,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"scss_cacher","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"SCSSCacher::resetCache Locking removed","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::info: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::info: Repair info: SCSS cache cleared","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::info: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::info: Repair info: JS cache cleared","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Clear every generated avatar on major updates","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Add preview background cleanup job","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Queue a one-time job to cleanup old backups of the updater","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Cleanup invalid photocache files for carddav","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Add background job to cleanup login flow v2 tokens","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Remove potentially over exposing share links","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::info: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::info: Repair info: No need to remove link shares.","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Clear access cache of projects","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Reset generated avatar flag","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Keep legacy encryption enabled","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Check encryption key format","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Remove old dashboard app config data","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Add job to cleanup the bruteforce entries","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Queue a one-time job to check for user uploaded certificates","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Repair DAV shares","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"Deprecated event type for \\OC\\Repair::step: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Repair::step: Repair step: Add background job to set the lookup server share state for users","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:57+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Updater::startCheckCodeIntegrity: Starting code integrity check...","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:59+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Updater::finishedCheckCodeIntegrity: Finished code integrity check","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.3.0"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:59+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Updater::updateEnd: Update successful","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.5.1"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:59+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Updater::maintenanceDisabled: Turned off maintenance mode","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.5.1"}
{"reqId":"MrZBfRg1WNBNcA91Fqit","level":1,"time":"2022-02-17T17:29:59+00:00","remoteAddr":"192.168.2.1","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=OdZfikWNRJsbdi%2BeYHyuT9F534C02DaCYcB5pAQt%2FEA%3D%3ATect3XbGcul4IEvZNxjfe4YPnfrnnUawCfIbyn5rqHc%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.5.1"}
{"reqId":"Ctxr4IzJqRW0me2rP9vi","level":2,"time":"2022-02-18T08:22:08+00:00","remoteAddr":"192.168.2.1","user":"zhfreal","app":"core","method":"POST","url":"/login/confirm","message":"Login failed: 'zhfreal' (Remote IP: '192.168.2.1')","userAgent":"Mozilla/5.0 (Linux; Android 11; KB2000) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.101 Mobile Safari/537.36","version":"22.2.5.1"}

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'id',
  'passwordsalt' => 'salt',
  'secret' => 'secret',
  'datadirectory' => '/nextcloud',
  'dbtype' => 'mysql',
  'version' => '22.2.5.1',
  'overwrite.cli.url' => 'http://url',
  'forcessl' => true,
  'overwriteprotocol' => 'https',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'user',
  'dbpassword' => 'password',
  'installed' => true,
  'loglevel' => 2,
  'log_type' => 'file',
  'logfile' => '/nextcloud.log',
  'log.condition' =>
  array (
    'apps' =>
    array (
      0 => 'admin_audit',
    ),
  ),
  'log_rotate_size' => 10485760,
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'maintenance' => false,
  'default_phone_region' => 'US',
  'theme' => '',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => '/redis.sock',
    'port' => 0,
  ),
  'mysql.utf8mb4' => true,
  'app_install_overwrite' =>
  array (
    0 => 'files_reader',
  ),
  'trusted_domains' =>
  array (
    `some domains`
  ),
  'updater.secret' => 'a secret',
);

The output of your Apache/nginx/system log in /var/log/____:

nothing about web container

Any ideas?

Update:

I fixed it:

  1. login mariadb, set " ROW_FORMAT" to “DYNAMIC” for table “oc_properties”;
  2. excute “occ db:add-missing-indices” again, it’s working
1 Like
2

Helped me out! Thank you very much!

3

Hello ,
Can you explain for newbie how to do that ?
I know how to log in mariadb, but which command for changing ROW_FORMAT to DYNAMIC ?

MariaDB [(none)]> SHOW TABLE STATUS FROM nextcloud WHERE Name='oc_properties';
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation   | Checksum | Create_options        | Comment | Max_index_length | Temporary |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| oc_properties | InnoDB |      10 | Compact    |    0 |              0 |       16384 |               0 |        32768 |         0 |              1 | 2020-08-19 17:27:15 | NULL        | NULL       | utf8mb4_bin |     NULL | row_format=COMPRESSED |         |                0 | N         |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+

Thanks

4

Hi, I’m glade to hear that

1 Like
5

Hi, just

use nextcloud;
ALTER TABLE oc_properties ROW_FORMAT=DYNAMIC;

1 Like