[Bug] 服务器突然断电后重启,出现Page Unavailable

image

如图所示,家里突然停电,重启后再访问seatable,出现Page Unavailable,尝试了多种恢复方法均未奏效。不知道是不是停电造成了数据库损坏?请求救援。
docker-compose日志如下:

root@xxx:/opt/seatable# docker-compose logs
seatable-mysql | 2023-09-25 07:12:59+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.22+mariaubu2004 started.
seatable-mysql | 2023-09-25 07:12:59+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
seatable-redis | 1:C 25 Sep 2023 07:12:59.287 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
seatable-redis | 1:C 25 Sep 2023 07:12:59.287 # Redis version=5.0.7, bits=64, commit=00000000, modified=0, pid=1, just started
seatable | *** Running /etc/my_init.d/01_init.sh...
seatable | *** Booting runit daemon...
seatable | *** Runit started as PID 16
seatable-mysql | 2023-09-25 07:12:59+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.22+mariaubu2004 started.
seatable-mysql | 2023-09-25 07:12:59+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
seatable-mysql | 2023-09-25 7:12:59 0 [Note] Starting MariaDB 10.5.22-MariaDB-1:10.5.22+mariaubu2004 source revision 7e650253dc488debcb0898ebe6d385bf6dfa3656 as process 1
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Uses event mutexes
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Number of pools: 1
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
seatable-mysql | 2023-09-25 7:12:59 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Using Linux native AIO
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Completed initialization of buffer pool
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: 128 rollback segments are active.
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: 10.5.22 started; log sequence number 135021134; transaction id 141376
seatable | *** Running /templates/enterpoint.sh...
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
seatable-mysql | 2023-09-25 7:12:59 0 [Note] Plugin 'FEEDBACK' is disabled.
seatable-mysql | 2023-09-25 7:12:59 0 [Note] Server socket created on IP: '::'.
seatable-mysql | 2023-09-25 7:12:59 0 [Note] Reading of all Master_info entries succeeded
seatable-mysql | 2023-09-25 7:12:59 0 [Note] Added new Master_info '' to hash table
seatable-mysql | 2023-09-25 7:12:59 0 [Note] mysqld: ready for connections.
seatable-mysql | Version: '10.5.22-MariaDB-1:10.5.22+mariaubu2004' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
seatable-mysql | 2023-09-25 7:12:59 0 [Note] InnoDB: Buffer pool(s) load completed at 230925 7:12:59
seatable-mysql | 2023-09-25 7:13:04 3 [Warning] Aborted connection 3 to db: 'seafile_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable-redis | 1:C 25 Sep 2023 07:12:59.287 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
seatable-redis | 1:M 25 Sep 2023 07:12:59.289 * Running mode=standalone, port=6379.
seatable-redis | 1:M 25 Sep 2023 07:12:59.289 # Server initialized
seatable-redis | 1:M 25 Sep 2023 07:12:59.289 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
seatable-mysql | 2023-09-25 7:13:08 5 [Warning] Aborted connection 5 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable-mysql | 2023-09-25 7:13:09 6 [Warning] Aborted connection 6 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable | 2023-09-25 15:12:59 Conf exists
seatable | 2023-09-25 15:12:59 Nginx ready
seatable | nginx: [warn] could not build optimal proxy_headers_hash, you should increase either proxy_headers_hash_max_size: 512 or proxy_headers_hash_bucket_size: 64; ignoring proxy_headers_hash_bucket_size
seatable | 2023-09-25 15:12:59 This is an idle script (infinite loop) to keep container running.
seatable | *** Shutting down /templates/enterpoint.sh (PID 17)...
seatable | *** Shutting down runit daemon (PID 16)...
seatable | *** Running /etc/my_init.post_shutdown.d/10_syslog-ng.shutdown...
seatable | *** Init system aborted.
seatable | *** Killing all processes...
seatable | *** Running /etc/my_init.d/01_init.sh...
seatable | *** Booting runit daemon...
seatable-redis | 1:M 25 Sep 2023 07:12:59.289 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
seatable-redis | 1:M 25 Sep 2023 07:12:59.289 * Ready to accept connections
seatable-mysql | 2023-09-25 7:13:43 22 [Warning] Aborted connection 22 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable-mysql | 2023-09-25 7:13:43 23 [Warning] Aborted connection 23 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable-mysql | 2023-09-25 7:14:13 24 [Warning] Aborted connection 24 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)
seatable-mysql | 2023-09-25 7:14:17 25 [Warning] Aborted connection 25 to db: 'dtable_db' user: 'root' host: '172.24.0.5' (Got an error reading communication packets)

补充浏览器Conlose错误提示:

您这个报错是seatable链接不到mysql数据,您排查一下mysql的报错信息,您这个有肯能是mysql数据库数据损坏导致mysql没有启动,您排查一下

排查了下基本上确定为数据库损坏,这种情况有什么修复方案吗?现在可以进入web界面了,但是点击任一表格,还是会出现Page Unavailable页面