Database Crashed

Hi,

When I tried to open my Nextcloud in a web browser suddenly did not work and when i tried to log in to MySQL it is throwing errors and when I am checking occ status it is also throwing an error I cant find where the issues are?

Steps to replicate it:

  1. I cannot open MySQL login.
  2. I cannot able to check the occ status
  3. i cannot able to login Nextcloud browser login page

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

<?php
$CONFIG = array (
  'instanceid' => 'ocitl9os08sf',
  'passwordsalt' => 'UZPv1lhRIMN75Lym/jR/Yy/1pW3Kxs',
  'secret' => 'fJ29LfhV4ascraUjatb/pQ9OZo7k9/V7Yor/4XQ2tVyR5L3t',
  'trusted_domains' =>
  array (
    0 => '192.168.1.12',
  ),
  'datadirectory' => '/var/www/html/owncloud/data',
  'overwrite.cli.url' => 'https://XXXX',
  'dbtype' => 'mysql',
  'version' => '22.2.5.1',
  'dbname' => 'XXXX',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'XXXX',
  'dbpassword' => 'XXXX',
  'logtimezone' => 'IST',
  'apps_paths' =>
  array (
    0 =>
    array (
      'path' => '/var/www/html/owncloud/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 =>
    array (
      'path' => '/var/www/html/owncloud/apps-external',
      'url' => '/apps-external',
      'writable' => true,
    ),
  ),
  'installed' => true,
  'loglevel' => 0,
 'maintenance' => false,
  'app_install_overwrite' =>
  array (
    0 => 'documents',
    1 => 'updatenotification',
    2 => 'configreport',
    3 => 'systemtags_management',
    4 => 'customgroups',
    5 => 'encryption',
    6 => 'files_classifier',
    7 => 'enterprise_key',
    8 => 'market',
    9 => 'files_mediaviewer',
    10 => 'announcementcenter',
  ),
  'ldapIgnoreNamingRules' => false,
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
  'mail_from_address' => 'XXXXX',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'refex.co.in',
  'mail_smtpsecure' => 'ssl',
  'mail_smtphost' => 'smtp.gmail.com',
  'mail_smtpport' => '465',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'XXXXXX',
  'mail_smtppassword' => 'XXXXXX',
);

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


Jun 18 13:09:07 nextcloud systemd[1]: Started MySQL Community Server.

Jun 18 13:09:08 nextcloud kernel: [10196.323989] audit: type=1400 audit(1655537948.988:6792): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15107/task/15199/mem" pid=15107 comm="ib_srv_wkr-1" requested_mask="r" denied_mask="r" fsuid=111 ouid=111

Jun 18 13:09:09 nextcloud systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT

Jun 18 13:09:09 nextcloud systemd[1]: mysql.service: Failed with result 'exit-code'.

Jun 18 13:09:09 nextcloud systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

Jun 18 13:09:09 nextcloud systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3383.

Jun 18 13:09:09 nextcloud systemd[1]: Stopped MySQL Community Server.

Jun 18 13:09:09 nextcloud systemd[1]: Starting MySQL Community Server...

Jun 18 13:09:09 nextcloud kernel: [10196.633689] audit: type=1400 audit(1655537949.296:6793): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=15267 comm="apparmor_parser"

Jun 18 13:09:10 nextcloud systemd[1]: Started MySQL Community Server.

Jun 18 13:09:11 nextcloud kernel: [10199.302433] audit: type=1400 audit(1655537951.964:6794): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15268/task/15315/mem" pid=15268 comm="ib_srv_wkr-1" requested_mask="r" denied_mask="r" fsuid=111 ouid=111

Jun 18 13:09:12 nextcloud systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT

Jun 18 13:09:12 nextcloud systemd[1]: mysql.service: Failed with result 'exit-code'.

Jun 18 13:09:12 nextcloud systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

Jun 18 13:09:12 nextcloud systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3384.

Jun 18 13:09:12 nextcloud systemd[1]: Stopped MySQL Community Server.

Jun 18 13:09:12 nextcloud systemd[1]: Starting MySQL Community Server...

Jun 18 13:09:12 nextcloud kernel: [10199.634802] audit: type=1400 audit(1655537952.296:6795): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=15436 comm="apparmor_parser"

Jun 18 13:09:13 nextcloud systemd[1]: Started MySQL Community Server.

Jun 18 13:09:14 nextcloud kernel: [10202.304417] audit: type=1400 audit(1655537954.968:6796): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15437/task/15487/mem" pid=15437 comm="ib_srv_wkr-2" requested_mask="r" denied_mask="r" fsuid=111 ouid=111

Jun 18 13:09:15 nextcloud systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT

Jun 18 13:09:15 nextcloud systemd[1]: mysql.service: Failed with result 'exit-code'.

Jun 18 13:09:15 nextcloud systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

Jun 18 13:09:15 nextcloud systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3385.

Jun 18 13:09:15 nextcloud systemd[1]: Stopped MySQL Community Server.

Jun 18 13:09:15 nextcloud systemd[1]: Starting MySQL Community Server...

Jun 18 13:09:15 nextcloud kernel: [10202.633952] audit: type=1400 audit(1655537955.296:6797): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=15558 comm="apparmor_parser"

Jun 18 13:09:16 nextcloud systemd[1]: Started MySQL Community Server.

Jun 18 13:09:17 nextcloud kernel: [10205.307882] audit: type=1400 audit(1655537957.972:6798): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/15559/task/15663/mem" pid=15559 comm="ib_srv_wkr-1" requested_mask="r" denied_mask="r" fsuid=111 ouid=111

Jun 18 13:09:18 nextcloud systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT

Jun 18 13:09:18 nextcloud systemd[1]: mysql.service: Failed with result 'exit-code'.

Jun 18 13:09:18 nextcloud systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

Jun 18 13:09:18 nextcloud systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3386.

Jun 18 13:09:18 nextcloud systemd[1]: Stopped MySQL Community Server.

Jun 18 13:09:18 nextcloud systemd[1]: Starting MySQL Community Server...

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

{“reqId”:“HNkv689MrQ2OteyBW0ex”,“level”:3,“time”:“2022-06-16T16:34:43+02:00”,“remoteAddr”:“106.193.13.12”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/ocs/v2.php/cloud/capabilities",“message”:“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“userAgent”:“Mozilla/5.0 (Android) Nextcloud-Talk v13.0.0”,“version”:“22.2.5.1”,“exception”:{“Exception”:“OC\DB\Exceptions\DbalException”,“Message”:“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:2006,“Trace”:[{“file”:"/var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:335,“function”:“wrap”,“class”:“OC\DB\Exceptions\DbalException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Exception\ConnectionLost”}]},{“file”:"/var/www/html/owncloud/lib/public/AppFramework/Db/QBMapper.php",“line”:221,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php",“line”:208,“function”:“update”,“class”:“OCP\AppFramework\Db\QBMapper”,“type”:"->",“args”:["*** sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/Manager.php",“line”:101,“function”:“updateToken”,“class”:“OC\Authentication\Token\PublicKeyTokenProvider”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:771,“function”:“updateToken”,“class”:“OC\Authentication\Token\Manager”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:804,“function”:“checkTokenCredentials”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameter replaced "," sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:363,“function”:“validateToken”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:461,“function”:“login”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:584,“function”:“logClientIn”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/base.php",“line”:1059,“function”:“tryBasicAuthLogin”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameter replaced "," sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/ocs/v1.php",“line”:59,“function”:“handleLogin”,“class”:“OC”,“type”:"::",“args”:[" sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/ocs/v2.php",“line”:23,“args”:["/var/www/html/owncloud/ocs/v1.php"],“function”:“require_once”}],“File”:"/var/www/html/owncloud/lib/private/DB/Exceptions/DbalException.php",“Line”:71,“Previous”:{“Exception”:“Doctrine\DBAL\Exception\ConnectionLost”,“Message”:“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:2006,“Trace”:[{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1780,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”,“type”:"->",“args”:[{“class”:“Doctrine\DBAL\Driver\PDO\Exception”},{“class”:“Doctrine\DBAL\Query”}]},{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1719,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[{“class”:“Doctrine\DBAL\Driver\PDO\Exception”},{“class”:“Doctrine\DBAL\Query”}]},{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1173,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[{“class”:“Doctrine\DBAL\Driver\PDO\Exception”},“UPDATE oc_authtoken SET last_check = ? WHERE id = ?”,[1655390082,94526],[1,1]]},{“file”:"/var/www/html/owncloud/lib/private/DB/Connection.php",“line”:267,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“UPDATE oc_authtoken SET last_check = ? WHERE id = ?”,[1655390082,94526],[1,1]]},{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:354,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“UPDATE oc_authtoken SET last_check = :dcValue1 WHERE id = :dcValue2”,{“dcValue1”:1655390082,“dcValue2”:94526},{“dcValue1”:1,“dcValue2”:1}]},{“file”:"/var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:333,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/public/AppFramework/Db/QBMapper.php",“line”:221,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php",“line”:208,“function”:“update”,“class”:“OCP\AppFramework\Db\QBMapper”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/Manager.php",“line”:101,“function”:“updateToken”,“class”:“OC\Authentication\Token\PublicKeyTokenProvider”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:771,“function”:“updateToken”,“class”:“OC\Authentication\Token\Manager”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:804,“function”:“checkTokenCredentials”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameter replaced "," sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:363,“function”:“validateToken”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:461,“function”:“login”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:584,“function”:“logClientIn”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/base.php",“line”:1059,“function”:“tryBasicAuthLogin”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameter replaced "," sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/ocs/v1.php",“line”:59,“function”:“handleLogin”,“class”:“OC”,“type”:"::",“args”:[" sensitive parameter replaced "]},{“file”:"/var/www/html/owncloud/ocs/v2.php",“line”:23,“args”:["/var/www/html/owncloud/ocs/v1.php"],“function”:“require_once”}],“File”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",“Line”:101,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:2006,“Trace”:[{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:94,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:"::",“args”:[{“errorInfo”:[“HY000”,2006,“MySQL server has gone away”],“class”:“PDOException”}]},{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1163,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/private/DB/Connection.php",“line”:267,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“UPDATE oc_authtoken SET last_check = ? WHERE id = ?”,[1655390082,94526],[1,1]]},{“file”:"/var/www/html/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:354,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“UPDATE oc_authtoken SET last_check = :dcValue1 WHERE id = :dcValue2”,{“dcValue1”:1655390082,“dcValue2”:94526},{“dcValue1”:1,“dcValue2”:1}]},{“file”:"/var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:333,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/public/AppFramework/Db/QBMapper.php",“line”:221,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php",“line”:208,“function”:“update”,“class”:“OCP\AppFramework\Db\QBMapper”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/Authentication/Token/Manager.php",“line”:101,“function”:“updateToken”,“class”:“OC\Authentication\Token\PublicKeyTokenProvider”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:771,“function”:“updateToken”,“class”:“OC\Authentication\Token\Manager”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/owncloud/lib/private/User/Session.php",“line”:804,“function”:“checkTokenCredentials”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameter replaced "," sensitive parameter replaced ***"]},{“file”:"/var/www/html/owncloud

MYSQL.log
The manual page at MySQL :: MySQL 8.0 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing contains

information that should help you find out what is causing the crash.

2022-06-18T07:10:02.058080Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-06-18T07:10:02.058104Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28) starting as process 173830

2022-06-18T07:10:02.065262Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-06-18T07:10:02.940288Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-06-18T07:10:03.075378Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we’re sending the information to the error-log instead: MY-001287 - ‘validate password plugin’ is deprecated and will be removed in a future release. Please use validate_password component instead

2022-06-18T07:10:03.093827Z 0 [System] [MY-010229] [Server] Starting XA crash recovery…

2022-06-18T07:10:03.102816Z 0 [System] [MY-010232] [Server] XA crash recovery finished.

2022-06-18T07:10:03.189244Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2022-06-18T07:10:03.189296Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2022-06-18T07:10:03.212023Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘::’ port: 33060, socket: /var/run/mysqld/mysqlx.sock

2022-06-18T07:10:03.212092Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.28’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 33060

6 MySQL Community Server - GPL.

2022-06-18T07:10:01.442540Z 0 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table owncloud.oc_file_locks index lock_ttl_index, father ptr page no 103016, child page no 102987

PHYSICAL RECORD: n_fields 2; compact format; info bits 0

0: len 4; hex e2aae8f5; asc ;;

1: len 8; hex 00000000d644ba0f; asc D ;;

PHYSICAL RECORD: n_fields 3; compact format; info bits 0

0: len 4; hex e2aae8e7; asc ;;

1: len 8; hex 00000000d644c80d; asc D ;;

2: len 4; hex 00019268; asc h;;

2022-06-18T07:10:01.442763Z 0 [ERROR] [MY-011854] [InnoDB] [FATAL] You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery for information about forcing recovery. Then dump + drop + reimport.

2022-06-18T07:10:01.442773Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0btr.cc:707:ib::fatal triggered thread 139786480248576

InnoDB: We intentionally generate a memory trap.

InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

InnoDB: If you get repeated assertion failures or crashes, even

InnoDB: immediately after the mysqld startup, there may be

InnoDB: corruption in the InnoDB tablespace. Please refer to

InnoDB: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery

InnoDB: about forcing recovery.

07:10:01 UTC - mysqld got signal 6 ;

Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Thread pointer: 0x7f227c000b20

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong…

stack_bottom = 7f22937fdc60 thread_stack 0x100000

/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x55cabbbddc8d]

/usr/sbin/mysqld(print_fatal_signal(int)+0x303) [0x55cabac5cb83]

/usr/sbin/mysqld(my_server_abort()+0x6e) [0x55cabac5cc9e]

/usr/sbin/mysqld(my_abort()+0xa) [0x55cabbbd7e1a]

/usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x326) [0x55cabbeaf3c6]

/usr/sbin/mysqld(ib::fatal::~fatal()+0xda) [0x55cabbeb1bfa]

/usr/sbin/mysqld(+0x242990d) [0x55cabbee390d]

/usr/sbin/mysqld(btr_compress(btr_cur_t*, unsigned long, mtr_t*)+0x14c) [0x55cabbee3dac]

/usr/sbin/mysqld(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*)+0x112) [0x55cabbef1a02]

/usr/sbin/mysqld(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned int, bool, unsigned long, unsigned long, unsigned long, mtr_t*, btr_pcur_t*, purge_node_t*)+0x1bf) [0x55cabbef1ecf]

/usr/sbin/mysqld(+0x2351ab7) [0x55cabbe0bab7]

/usr/sbin/mysqld(+0x2353f32) [0x55cabbe0df32]

/usr/sbin/mysqld(row_purge_step(que_thr_t*)+0xfe7) [0x55cabbe0f447]

/usr/sbin/mysqld(que_run_threads(que_thr_t*)+0xd38) [0x55cabbdc5e48]

/usr/sbin/mysqld(srv_worker_thread()+0x4e5) [0x55cabbe47535]

/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)()> > >::_M_run()+0xbc) [0x55cabbd66cac]

/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xbd6df) [0x7f22fed0a6df]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f23001d46db]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f22fe3c761f]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0): is an invalid pointer

Connection ID (thread ID): 0

Status: NOT_KILLED

While Running OCC:

Next Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101

Stack trace:

#0 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))

#1 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))

#2 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1067): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT id, `n…’, Array, Array)

#3 /var/www/html/owncloud/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery(‘SELECT id, `n…’, Array, Array, NULL)

#4 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery(‘SELECT id, `n…’, Array, Array)

#5 /var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()

#6 /var/www/html/owncloud/lib/private/Files/Cache/StorageGlobal.php(78): OC\DB\QueryBuilder\QueryBuilder->execute()

#7 /var/www/html/owncloud/lib/private/Files/Cache/Storage.php(98): OC\Files\Cache\StorageGlobal->getStorageInfo(‘local::/var/www…’)

#8 /var/www/html/owncloud/lib/private/Files/Cache/Storage.php(76): OC\Files\Cache\Storage::getStorageById(‘local::/var/www…’)

#9 /var/www/html/owncloud/lib/private/Files/Cache/Cache.php(120): OC\Files\Cache\Storage->__construct(Object(OCA\Files_Trashbin\Storage))

#10 /var/www/html/owncloud/lib/private/Files/Storage/Common.php(339): OC\Files\Cache\Cache->__construct(Object(OCA\Files_Trashbin\Storage))

#11 /var/www/html/owncloud/lib/private/Files/Storage/Wrapper/Wrapper.php(395): OC\Files\Storage\Common->getCache(‘appdata_ocitl9o…’, Object(OCA\Files_Trashbin\Storage))

#12 /var/www/html/owncloud/lib/private/Files/View.php(1337): OC\Files\Storage\Wrapper\Wrapper->getCache(‘appdata_ocitl9o…’)

#13 /var/www/html/owncloud/lib/private/Files/View.php(1393): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), ‘appdata_ocitl9o…’, ‘/appdata_ocitl9…’)

#14 /var/www/html/owncloud/lib/private/Files/Node/Root.php(200): OC\Files\View->getFileInfo(’/appdata_ocitl9…’)

#15 [internal function]: OC\Files\Node\Root->get(’/appdata_ocitl9…’)

#16 /var/www/html/owncloud/lib/private/Files/Node/LazyFolder.php(65): call_user_func_array(Array, Array)

#17 /var/www/html/owncloud/lib/private/Files/Node/LazyFolder.php(142): OC\Files\Node\LazyFolder->__call(‘get’, Array)

#18 /var/www/html/owncloud/lib/private/Files/AppData/AppData.php(141): OC\Files\Node\LazyFolder->get(‘appdata_ocitl9o…’)

#19 /var/www/html/owncloud/apps-external/richdocuments/lib/TemplateManager.php(146): OC\Files\AppData\AppData->getFolder(‘templates’)

#20 /var/www/html/owncloud/apps-external/richdocuments/lib/TemplateManager.php(134): OCA\Richdocuments\TemplateManager->createAppDataFolders()

#21 [internal function]: OCA\Richdocuments\TemplateManager->__construct(‘richdocuments’, NULL, Object(OC\AllConfig), Object(OC\Files\AppData\AppData), Object(OC\URLGenerator), Object(OC\Files\Node\LazyRoot), Object(OC\L10N\LazyL10N))

#22 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(106): ReflectionClass->newInstanceArgs(Array)

#23 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))

#24 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(131): OC\AppFramework\Utility\SimpleContainer->resolve(‘OCA\Richdocumen…’)

#25 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(460): OC\AppFramework\Utility\SimpleContainer->query(‘OCA\Richdocumen…’)

#26 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(432): OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback(‘OCA\Richdocumen…’)

#27 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(87): OC\AppFramework\DependencyInjection\DIContainer->query(‘OCA\Richdocumen…’, true)

#28 [internal function]: OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(ReflectionParameter))

#29 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(106): array_map(Object(Closure), Array)

#30 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))

#31 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(131): OC\AppFramework\Utility\SimpleContainer->resolve(‘OCA\Richdocumen…’)

#32 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(460): OC\AppFramework\Utility\SimpleContainer->query(‘OCA\Richdocumen…’)

#33 /var/www/html/owncloud/lib/private/ServerContainer.php(145): OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback(‘OCA\Richdocumen…’)

#34 /var/www/html/owncloud/lib/private/Console/Application.php(215): OC\ServerContainer->query(‘OCA\Richdocumen…’)

#35 /var/www/html/owncloud/lib/private/Console/Application.php(128): OC\Console\Application->loadCommandsFromInfoXml(Array)

#36 /var/www/html/owncloud/console.php(98): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

#37 /var/www/html/owncloud/occ(11): require_once(’/var/www/html/o…’)

While Running OCC:

Next Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101

Stack trace:

#0 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))

#1 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))

#2 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Connection.php(1067): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT id, `n…’, Array, Array)

#3 /var/www/html/owncloud/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery(‘SELECT id, `n…’, Array, Array, NULL)

#4 /var/www/html/owncloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery(‘SELECT id, `n…’, Array, Array)

#5 /var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()

#6 /var/www/html/owncloud/lib/private/Files/Cache/StorageGlobal.php(78): OC\DB\QueryBuilder\QueryBuilder->execute()

#7 /var/www/html/owncloud/lib/private/Files/Cache/Storage.php(98): OC\Files\Cache\StorageGlobal->getStorageInfo(‘local::/var/www…’)

#8 /var/www/html/owncloud/lib/private/Files/Cache/Storage.php(76): OC\Files\Cache\Storage::getStorageById(‘local::/var/www…’)

#9 /var/www/html/owncloud/lib/private/Files/Cache/Cache.php(120): OC\Files\Cache\Storage->__construct(Object(OCA\Files_Trashbin\Storage))

#10 /var/www/html/owncloud/lib/private/Files/Storage/Common.php(339): OC\Files\Cache\Cache->__construct(Object(OCA\Files_Trashbin\Storage))

#11 /var/www/html/owncloud/lib/private/Files/Storage/Wrapper/Wrapper.php(395): OC\Files\Storage\Common->getCache(‘appdata_ocitl9o…’, Object(OCA\Files_Trashbin\Storage))

#12 /var/www/html/owncloud/lib/private/Files/View.php(1337): OC\Files\Storage\Wrapper\Wrapper->getCache(‘appdata_ocitl9o…’)

#13 /var/www/html/owncloud/lib/private/Files/View.php(1393): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), ‘appdata_ocitl9o…’, ‘/appdata_ocitl9…’)

#14 /var/www/html/owncloud/lib/private/Files/Node/Root.php(200): OC\Files\View->getFileInfo(’/appdata_ocitl9…’)

#15 [internal function]: OC\Files\Node\Root->get(’/appdata_ocitl9…’)

#16 /var/www/html/owncloud/lib/private/Files/Node/LazyFolder.php(65): call_user_func_array(Array, Array)

#17 /var/www/html/owncloud/lib/private/Files/Node/LazyFolder.php(142): OC\Files\Node\LazyFolder->__call(‘get’, Array)

#18 /var/www/html/owncloud/lib/private/Files/AppData/AppData.php(141): OC\Files\Node\LazyFolder->get(‘appdata_ocitl9o…’)

#19 /var/www/html/owncloud/apps-external/richdocuments/lib/TemplateManager.php(146): OC\Files\AppData\AppData->getFolder(‘templates’)

#20 /var/www/html/owncloud/apps-external/richdocuments/lib/TemplateManager.php(134): OCA\Richdocuments\TemplateManager->createAppDataFolders()

#21 [internal function]: OCA\Richdocuments\TemplateManager->__construct(‘richdocuments’, NULL, Object(OC\AllConfig), Object(OC\Files\AppData\AppData), Object(OC\URLGenerator), Object(OC\Files\Node\LazyRoot), Object(OC\L10N\LazyL10N))

#22 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(106): ReflectionClass->newInstanceArgs(Array)

#23 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))

#24 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(131): OC\AppFramework\Utility\SimpleContainer->resolve(‘OCA\Richdocumen…’)

#25 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(460): OC\AppFramework\Utility\SimpleContainer->query(‘OCA\Richdocumen…’)

#26 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(432): OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback(‘OCA\Richdocumen…’)

#27 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(87): OC\AppFramework\DependencyInjection\DIContainer->query(‘OCA\Richdocumen…’, true)

#28 [internal function]: OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(ReflectionParameter))

#29 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(106): array_map(Object(Closure), Array)

#30 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))

#31 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(131): OC\AppFramework\Utility\SimpleContainer->resolve(‘OCA\Richdocumen…’)

#32 /var/www/html/owncloud/lib/private/AppFramework/DependencyInjection/DIContainer.php(460): OC\AppFramework\Utility\SimpleContainer->query(‘OCA\Richdocumen…’)

#33 /var/www/html/owncloud/lib/private/ServerContainer.php(145): OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback(‘OCA\Richdocumen…’)

#34 /var/www/html/owncloud/lib/private/Console/Application.php(215): OC\ServerContainer->query(‘OCA\Richdocumen…’)

#35 /var/www/html/owncloud/lib/private/Console/Application.php(128): OC\Console\Application->loadCommandsFromInfoXml(Array)

#36 /var/www/html/owncloud/console.php(98): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

#37 /var/www/html/owncloud/occ(11): require_once(’/var/www/html/o…’)

MYSQL ERROR.LOG

The manual page at MySQL :: MySQL 8.0 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing contains

information that should help you find out what is causing the crash.

2022-06-18T07:10:02.058080Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-06-18T07:10:02.058104Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28) starting as process 173830

2022-06-18T07:10:02.065262Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-06-18T07:10:02.940288Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-06-18T07:10:03.075378Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we’re sending the information to the error-log instead: MY-001287 - ‘validate password plugin’ is deprecated and will be removed in a future release. Please use validate_password component instead

2022-06-18T07:10:03.093827Z 0 [System] [MY-010229] [Server] Starting XA crash recovery…

2022-06-18T07:10:03.102816Z 0 [System] [MY-010232] [Server] XA crash recovery finished.

2022-06-18T07:10:03.189244Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2022-06-18T07:10:03.189296Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2022-06-18T07:10:03.212023Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘::’ port: 33060, socket: /var/run/mysqld/mysqlx.sock

2022-06-18T07:10:03.212092Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.28’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 33060

6 MySQL Community Server - GPL.

2022-06-18T07:10:01.442540Z 0 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table owncloud.oc_file_locks index lock_ttl_index, father ptr page no 103016, child page no 102987

PHYSICAL RECORD: n_fields 2; compact format; info bits 0

0: len 4; hex e2aae8f5; asc ;;

1: len 8; hex 00000000d644ba0f; asc D ;;

PHYSICAL RECORD: n_fields 3; compact format; info bits 0

0: len 4; hex e2aae8e7; asc ;;

1: len 8; hex 00000000d644c80d; asc D ;;

2: len 4; hex 00019268; asc h;;

2022-06-18T07:10:01.442763Z 0 [ERROR] [MY-011854] [InnoDB] [FATAL] You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery for information about forcing recovery. Then dump + drop + reimport.

2022-06-18T07:10:01.442773Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0btr.cc:707:ib::fatal triggered thread 139786480248576

InnoDB: We intentionally generate a memory trap.

InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

InnoDB: If you get repeated assertion failures or crashes, even

InnoDB: immediately after the mysqld startup, there may be

InnoDB: corruption in the InnoDB tablespace. Please refer to

InnoDB: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery

InnoDB: about forcing recovery.

07:10:01 UTC - mysqld got signal 6 ;

Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Thread pointer: 0x7f227c000b20

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong…

stack_bottom = 7f22937fdc60 thread_stack 0x100000

/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x55cabbbddc8d]

/usr/sbin/mysqld(print_fatal_signal(int)+0x303) [0x55cabac5cb83]

/usr/sbin/mysqld(my_server_abort()+0x6e) [0x55cabac5cc9e]

/usr/sbin/mysqld(my_abort()+0xa) [0x55cabbbd7e1a]

/usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x326) [0x55cabbeaf3c6]

/usr/sbin/mysqld(ib::fatal::~fatal()+0xda) [0x55cabbeb1bfa]

/usr/sbin/mysqld(+0x242990d) [0x55cabbee390d]

/usr/sbin/mysqld(btr_compress(btr_cur_t*, unsigned long, mtr_t*)+0x14c) [0x55cabbee3dac]

/usr/sbin/mysqld(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*)+0x112) [0x55cabbef1a02]

/usr/sbin/mysqld(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned int, bool, unsigned long, unsigned long, unsigned long, mtr_t*, btr_pcur_t*, purge_node_t*)+0x1bf) [0x55cabbef1ecf]

/usr/sbin/mysqld(+0x2351ab7) [0x55cabbe0bab7]

/usr/sbin/mysqld(+0x2353f32) [0x55cabbe0df32]

/usr/sbin/mysqld(row_purge_step(que_thr_t*)+0xfe7) [0x55cabbe0f447]

/usr/sbin/mysqld(que_run_threads(que_thr_t*)+0xd38) [0x55cabbdc5e48]

/usr/sbin/mysqld(srv_worker_thread()+0x4e5) [0x55cabbe47535]

/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)()> > >::_M_run()+0xbc) [0x55cabbd66cac]

/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xbd6df) [0x7f22fed0a6df]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f23001d46db]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f22fe3c761f]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0): is an invalid pointer

Connection ID (thread ID): 0

Status: NOT_KILLED

Did you try to repair the tables? The oc_file_locks can be emptied, that is just for locking files during they are changed. If everything runs through your database instead of a dedicated cache, it can create an important load and lead to locked files:

Could be that it is too much for your database and a redis cache could solve your problem.

for me this error

sounds like a root cause. If the DB can’t access required files no wonder it crashes… take look here:

1 Like

This is resolved after dropping the oc_filecache table but I’m unable to view the files which I have in nextcloud.

I have decrypted all files but still i cant able to open any of miles showing file is damaged or corrupted or unsupported format

Also when I download those files it shows an Internal server error.

Log file:

{“reqId”:“yeVcH6APNGyeAoX1ivqw”,“level”:0,“time”:“2022-06-21T07:37:41+02:00”,“remoteAddr”:“192.168.14.165”,“user”:“sarath.k@refex.co.in”,“app”:“scss_cacher”,“method”:“GET”,“url”:"/remote.php/webdav/Bhilai%20Project/Bhilai%20PV%20Plant%20CCTV/index.php/csrftoken",“message”:“SCSSCacher::process ordinary check follows”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36”,“version”:“22.2.5.1”}
{“reqId”:“yeVcH6APNGyeAoX1ivqw”,“level”:0,“time”:“2022-06-21T07:37:41+02:00”,“remoteAddr”:“192.168.14.165”,“user”:“sarath.k@refex.co.in”,“app”:“scss_cacher”,“method”:“GET”,“url”:"/remote.php/webdav/Bhilai%20Project/Bhilai%20PV%20Plant%20CCTV/index.php/csrftoken",“message”:“SCSSCacher::isCached a5ad-9eee-css-variables.css isCachedCache is expired or unset”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36”,“version”:“22.2.5.1”}
{“reqId”:“yeVcH6APNGyeAoX1ivqw”,“level”:0,“time”:“2022-06-21T07:37:41+02:00”,“remoteAddr”:“192.168.14.165”,“user”:“sarath.k@refex.co.in”,“app”:“scss_cacher”,“method”:“GET”,“url”:"/remote.php/webdav/Bhilai%20Project/Bhilai%20PV%20Plant%20CCTV/index.php/csrftoken",“message”:“SCSSCacher::isCached a5ad-9eee-css-variables.css dependencies successfully cached for 5 minutes”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36”,“version”:“22.2.5.1”}

You shouldn’t do that. Especially with encryption since the files are signed with information from this table.

You can restore single files with password and the keyfile only. There were some topics about this here in the forum or on github.
With a current backup, it’s perhaps the easiest, to restore the backup and just pick and restore single files that were changed since the backup. Then all the client sync and apps are working.

Sorry for the information which i have given wrongly i have dropped the table of oc_filelocks.

As I am having the master keys for private and public and each individual user key for files i have tried with occ encryption:decrypt --all username but still the issue is not resolved.

The error inidicated database server detected corruption of specific database table on startup… but there might be more which are not detected now… your tries on the application side don address the underlying issue… most likely the apparmor caused database corruption and you need to recover… I would recommend you to restore last known good backup and try again.

Should you still have the whole data folder and the config file then you could try to decrypt the files outside of Nextcloud with the following standalone script: https://github.com/syseleven/nextcloud-tools/blob/master/rescue/decrypt-all-files.php

@yahesh

No i have the backup of the whole data folder & Config files & Database so that i have revoked my server for running Nextcloud