My Site suddenly shows Database connection error

aaP_hello9

My site was suddenlyu showing Error Establishing a Database Connection” and then when i restart the serve rfrom panel everythiung start working fine. I had the same issue in last week,. What could be the issue?? I am using aapanel 6.8.36

aaP_hello9

2024-09-19T16:09:28.779963Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-09-19T16:09:28.792863Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-09-19T16:09:28.817698Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-09-19T16:09:29.077499Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 131022393357 2024-09-19T16:09:29.185400Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 131024427785 2024-09-19T16:09:29.185456Z 0 [Note] InnoDB: Database was not shutdown normally! 2024-09-19T16:09:29.185460Z 0 [Note] InnoDB: Starting crash recovery. 2024-09-20T12:42:21.944968Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-09-20T12:42:21.945476Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-09-20T12:42:21.945480Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2024-09-20T12:42:21.945493Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2024-09-20T12:42:21.945551Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.40-log) starting as process 1787 ... 2024-09-20T12:42:22.072404Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-09-20T12:42:22.072451Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-09-20T12:42:22.072455Z 0 [Note] InnoDB: Uses event mutexes 2024-09-20T12:42:22.072458Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-09-20T12:42:22.072461Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2024-09-20T12:42:22.077108Z 0 [Note] InnoDB: Number of pools: 1 2024-09-20T12:42:22.082003Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-09-20T12:42:22.094388Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2024-09-20T12:42:22.381926Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-09-20T12:42:22.508638Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-09-20T12:42:22.549515Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-09-20T12:42:22.570762Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 131022393357 2024-09-20T12:42:22.666494Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 131024427785 2024-09-20T12:42:22.666548Z 0 [Note] InnoDB: Database was not shutdown normally! 2024-09-20T12:42:22.666552Z 0 [Note] InnoDB: Starting crash recovery. 2024-09-20T12:42:22.850315Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2024-09-20T12:42:23.363437Z 0 [Note] InnoDB: Apply batch completed 2024-09-20T12:42:23.363473Z 0 [Note] InnoDB: Last MySQL binlog file position 0 1855, file name mysql-bin.001466 2024-09-20T12:42:23.690766Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-09-20T12:42:23.690784Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-09-20T12:42:23.690812Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-09-20T12:42:23.809125Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB. 2024-09-20T12:42:23.809855Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-09-20T12:42:23.809866Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-09-20T12:42:23.810851Z 0 [Note] InnoDB: Waiting for purge to start 2024-09-20T12:42:23.861010Z 0 [Note] InnoDB: 5.7.40 started; log sequence number 131024427785 2024-09-20T12:42:23.861512Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool 2024-09-20T12:42:23.862789Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-09-20T12:42:23.867515Z 0 [Note] Recovering after a crash using mysql-bin 2024-09-20T12:42:23.867526Z 0 [Note] Starting crash recovery... 2024-09-20T12:42:23.867560Z 0 [Note] Crash recovery finished. 2024-09-20T12:42:23.877258Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-09-20T12:42:23.877265Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-09-20T12:42:23.877268Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-09-20T12:42:23.877270Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-09-20T12:42:23.878041Z 0 [Warning] CA certificate ca.pem is self signed. 2024-09-20T12:42:23.878059Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-09-20T12:42:23.878479Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2024-09-20T12:42:23.878685Z 0 [Note] IPv6 is available. 2024-09-20T12:42:23.878691Z 0 [Note] - '::' resolves to '::'; 2024-09-20T12:42:23.878703Z 0 [Note] Server socket created on IP: '::'. 2024-09-20T12:42:23.890789Z 0 [Note] Failed to start slave threads for channel '' 2024-09-20T12:42:23.914115Z 0 [Note] Event Scheduler: Loaded 0 events 2024-09-20T12:42:23.914290Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections. Version: '5.7.40-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2024-09-20T12:42:34.913647Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240920 18:42:34 2024-09-20T12:42:57.016352Z 125 [Warning] IP address '85.202.160.48' has been resolved to the host name 'myipaddress.ambyrenodes.net', which resembles IPv4-address itself.
This is my last 24+hrs mysqldatabase error log from aapanel. Whats the issue

Its really annoying,
should i Configure MySQL to restart automatically if it crashes

aaPanel_Kern

Hello, I suggest you check whether it has been shut down by the system.

dmesg|grep -iE "kill|httpd|apache|http|mysql|oom"
grep -i 'killed' /var/log/messages
journalctl | grep -i 'killed'

aaP_hello9

aaP_thefreedrivemovie

Hey its me from another account can access my previous account from where i posted, no idea why the pass not workinbg. the point is today i also get the same error and restarted the sql serve rand everything fine

Sep 19 22:09:30 server mysqld[992]: /www/server/mysql/bin/mysqld_safe: line 198: 495097 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 08:37:45 server kernel: Out of memory: Killed process 1787 (mysqld) total-vm:5206456kB, anon-rss:1264732kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:4364kB oom_score_adj:0 Sep 21 08:37:45 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 1787 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 Sep 21 16:16:18 server kernel: Out of memory: Killed process 17651 (mysqld) total-vm:5206008kB, anon-rss:1205452kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:4224kB oom_score_adj:0 Sep 21 16:16:18 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 17651 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 16:16:38 server kernel: Out of memory: Killed process 26721 (mysqld) total-vm:5205576kB, anon-rss:875400kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:2416kB oom_score_adj:0 Sep 21 16:16:38 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 26721 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 16:16:53 server kernel: Out of memory: Killed process 33077 (mysqld) total-vm:5202184kB, anon-rss:836372kB, file-rss:5088kB, shmem-rss:0kB, UID:1001 pgtables:2248kB oom_score_adj:0 Sep 21 16:16:53 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 33077 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 16:16:59 server kernel: Out of memory: Killed process 1810 (BT-Panel) total-vm:325428kB, anon-rss:0kB, file-rss:2324kB, shmem-rss:0kB, UID:0 pgtables:404kB oom_score_adj:0 Sep 21 16:16:59 server kernel: Out of memory: Killed process 6092 (php-fpm) total-vm:548372kB, anon-rss:22728kB, file-rss:2560kB, shmem-rss:32kB, UID:1000 pgtables:376kB oom_score_adj:0 Sep 21 16:16:59 server kernel: Out of memory: Killed process 1087 (php-fpm) total-vm:171656kB, anon-rss:12344kB, file-rss:2432kB, shmem-rss:0kB, UID:1000 pgtables:332kB oom_score_adj:0 Sep 21 16:16:59 server kernel: Out of memory: Killed process 6087 (php-fpm) total-vm:170496kB, anon-rss:21148kB, file-rss:2432kB, shmem-rss:0kB, UID:1000 pgtables:328kB oom_score_adj:0 Sep 21 16:16:59 server kernel: Out of memory: Killed process 22019 (httpd) total-vm:3719056kB, anon-rss:20076kB, file-rss:148kB, shmem-rss:40kB, UID:1000 pgtables:588kB oom_score_adj:0 Sep 21 16:17:08 server kernel: Out of memory: Killed process 1075 (php-fpm) total-vm:169384kB, anon-rss:24072kB, file-rss:2396kB, shmem-rss:0kB, UID:1000 pgtables:320kB oom_score_adj:0 Sep 21 16:17:28 server kernel: Out of memory: Killed process 36478 (mysqld) total-vm:5203456kB, anon-rss:849820kB, file-rss:500kB, shmem-rss:0kB, UID:1001 pgtables:2244kB oom_score_adj:0 Sep 21 16:17:28 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 36478 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 16:17:30 server kernel: Out of memory: Killed process 36798 (mysqld) total-vm:3142064kB, anon-rss:294648kB, file-rss:2044kB, shmem-rss:0kB, UID:1001 pgtables:904kB oom_score_adj:0 Sep 21 16:17:30 server mysqld[820]: /www/server/mysql/bin/mysqld_safe: line 198: 36798 Killed nohup /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=server.err --open-files-limit=65535 --pid-file=/www/server/data/server.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 Sep 21 16:17:31 server kernel: Out of memory: Killed process 1077 (php-fpm) total-vm:177456kB, anon-rss:58396kB, file-rss:836kB, shmem-rss:0kB, UID:1000 pgtables:340kB oom_score_adj:0 Sep 21 16:17:36 server kernel: Out of memory: Killed process 1078 (php-fpm) total-vm:171980kB, anon-rss:55380kB, file-rss:1368kB, shmem-rss:0kB, UID:1000 pgtables:328kB oom_score_adj:0 Sep 21 16:17:36 server kernel: Out of memory: Killed process 17255 (httpd) total-vm:3718952kB, anon-rss:21364kB, file-rss:0kB, shmem-rss:36kB, UID:1000 pgtables:568kB oom_score_adj:0 Sep 21 16:17:38 server kernel: Out of memory: Killed process 22439 (httpd) total-vm:3719104kB, anon-rss:18152kB, file-rss:0kB, shmem-rss:36kB, UID:1000 pgtables:580kB oom_score_adj:0 Sep 21 16:17:38 server kernel: Out of memory: Killed process 21048 (httpd) total-vm:3719348kB, anon-rss:32896kB, file-rss:0kB, shmem-rss:4kB, UID:1000 pgtables:584kB oom_score_adj:0 Sep 21 16:17:38 server kernel: Out of memory: Killed process 22577 (httpd) total-vm:3718992kB, anon-rss:24832kB, file-rss:0kB, shmem-rss:4kB, UID:1000 pgtables:572kB oom_score_adj:0 Sep 21 16:17:38 server kernel: Out of memory: Killed process 21913 (httpd) total-vm:3718928kB, anon-rss:20296kB, file-rss:0kB, shmem-rss:40kB, UID:1000 pgtables:576kB oom_score_adj:0 after running ur code this is what i get

aaPanel_Kern

Hello, you can see from the log that it was shut down by the system.

aaP_thefreedrivemovie