PHP Warning: Undefined array key "host and "scheme" in canonical.php

SYSTEM INFORMATION
OS type and version Ubuntu Linux 22.04.2
Virtualmin version 7.5

Hello

After installing Wordpress on a Virtual Server (for which I have chosen to flag for the time being the option discourage search engines from indexing this site while I am testing the chosen theme), MariaDB Database Server crashed. I then restarted it from the Dashboard.

Under the PHP Error Log I found:

PHP Warning:  Undefined array key "host" in /home/mywebsite/public_html/wp-includes/canonical.php on line 689
PHP Warning:  Undefined array key "host" in /home/mywebsite/public_html/wp-includes/canonical.php on line 698
PHP Warning:  Undefined array key "host" in /home/mywebsite/public_html/wp-includes/canonical.php on line 701
PHP Warning:  Undefined array key "scheme" in /home/mywebsite/public_html/wp-includes/canonical.php on line 722

Here the lines involved:

[689] $original_host_low = strtolower( $original['host'] );
[698] $redirect['host'] = $original['host'];
[701] $compare_original = array( $original['host'], $original['path'] );
[722] $redirect_url = $redirect['scheme'] . '://' . $redirect['host'];

Do you think there is some relationship between the PHP Error messages and the Maria’s shutdown?
How can I fix those warings?
How can I check MariaDB’s Error log?

Thank you in advance.

Were the warnings during the time the DB was down?

Logs? My goto command when I’m not sure where to look.

grep -ir mariadb /var/log

It does show some hits so that’s where I’d start.

That php code looks like it is building a url and can not find an array if it’s a plugin it may be for a differnt version of wp or badly coded. Nothing to do with maria failure

1 Like

Hope it may help for the diagnosis (1/2):

grep -ir mariadb /var/log

/var/log/alternatives.log.1:update-alternatives 2023-02-23 06:09:39: run with --install /etc/mysql/my.cnf my.cnf /etc/mysql/mariadb.cnf 200
/var/log/syslog.1:Mar 20 15:26:28 mail mariadbd[937966]: 2023-03-20 15:26:28 29267 [Warning] Access denied for user ''@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 15:30:43 mail mariadbd[937966]: 2023-03-20 15:30:43 29291 [Warning] Access denied for user ''@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 16:09:46 mail kernel: [1316343.807627] [ 937966]   114 937966   272119    62504   708608        0             0 mariadbd
/var/log/syslog.1:Mar 20 16:09:46 mail kernel: [1316343.807854] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=937966,uid=114
/var/log/syslog.1:Mar 20 16:09:46 mail kernel: [1316343.807969] Out of memory: Killed process 937966 (mariadbd) total-vm:1088476kB, anon-rss:247932kB, file-rss:2084kB, shmem-rss:0kB, UID:114 pgtables:692kB oom_score_adj:0
/var/log/syslog.1:Mar 20 16:09:48 mail systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
/var/log/syslog.1:Mar 20 16:09:48 mail systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
/var/log/syslog.1:Mar 20 16:09:48 mail systemd[1]: mariadb.service: Failed with result 'oom-kill'.
/var/log/syslog.1:Mar 20 16:09:48 mail systemd[1]: mariadb.service: Consumed 16min 10.060s CPU time.
/var/log/syslog.1:Mar 20 16:11:02 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 1191715
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] mariadbd: Aria engine: starting recovery
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: recovered pages: 0% 14% 35% 49% 69% 84% 100% (0.0 seconds); tables to flush: 2 1 0
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]:  (0.0 seconds);
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] mariadbd: Aria engine: recovery done
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Using transactional memory
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog.1:Mar 20 16:11:03 mail mariadbd[1191715]: 2023-03-20 16:11:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3112732581,3112732581
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Starting final batch to recover 279 pages from redo log.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: 10.6.12 started; log sequence number 3113362619; transaction id 3662799
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 0 [Note] InnoDB: Buffer pool(s) load completed at 230320 16:11:04
/var/log/syslog.1:Mar 20 16:11:04 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 16:11:04 mail /etc/mysql/debian-start[1191734]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog.1:Mar 20 16:11:04 mail /etc/mysql/debian-start[1191734]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog.1:Mar 20 16:11:04 mail mariadbd[1191715]: 2023-03-20 16:11:04 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 16:13:47 mail mariadbd[1191715]: 2023-03-20 16:13:47 25 [Warning] Access denied for user ''@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 16:33:41 mail mariadbd[1191715]: 2023-03-20 16:33:41 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
/var/log/syslog.1:Mar 20 16:33:41 mail mariadbd[1191715]: 2023-03-20 16:33:41 0 [Note] InnoDB: FTS optimize thread exiting.
/var/log/syslog.1:Mar 20 16:33:41 mail systemd[1]: Stopping MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 20 16:33:41 mail mariadbd[1191715]: 2023-03-20 16:33:41 0 [Note] InnoDB: Starting shutdown...
/var/log/syslog.1:Mar 20 16:33:41 mail mariadbd[1191715]: 2023-03-20 16:33:41 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 20 16:33:41 mail mariadbd[1191715]: 2023-03-20 16:33:41 0 [Note] InnoDB: Buffer pool(s) dump completed at 230320 16:33:41
/var/log/syslog.1:Mar 20 16:34:05 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 20 16:34:06 mail mariadbd[653]: 2023-03-20 16:34:06 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 653
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Using transactional memory
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog.1:Mar 20 16:34:07 mail mariadbd[653]: 2023-03-20 16:34:07 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] InnoDB: 10.6.12 started; log sequence number 3113887361; transaction id 3663246
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog.1:Mar 20 16:34:08 mail mariadbd[653]: 2023-03-20 16:34:08 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog.1:Mar 20 16:34:09 mail mariadbd[653]: 2023-03-20 16:34:09 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog.1:Mar 20 16:34:09 mail mariadbd[653]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog.1:Mar 20 16:34:10 mail mariadbd[653]: 2023-03-20 16:34:10 0 [Note] InnoDB: Buffer pool(s) load completed at 230320 16:34:10
/var/log/syslog.1:Mar 20 16:34:10 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog.1:Mar 20 16:34:10 mail mariadbd[653]: 2023-03-20 16:34:10 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 16:34:10 mail /etc/mysql/debian-start[870]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog.1:Mar 20 16:34:10 mail /etc/mysql/debian-start[870]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog.1:Mar 20 16:34:10 mail mariadbd[653]: 2023-03-20 16:34:10 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 19:16:28 mail kernel: [ 9757.306073] [    653]   114   653   272955    63261   720896        0             0 mariadbd
/var/log/syslog.1:Mar 20 19:16:28 mail kernel: [ 9757.306350] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=653,uid=114
/var/log/syslog.1:Mar 20 19:16:28 mail kernel: [ 9757.306433] Out of memory: Killed process 653 (mariadbd) total-vm:1091820kB, anon-rss:252532kB, file-rss:512kB, shmem-rss:0kB, UID:114 pgtables:704kB oom_score_adj:0
/var/log/syslog.1:Mar 20 19:16:29 mail systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
/var/log/syslog.1:Mar 20 19:16:29 mail systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
/var/log/syslog.1:Mar 20 19:16:29 mail systemd[1]: mariadb.service: Failed with result 'oom-kill'.
/var/log/syslog.1:Mar 20 19:16:29 mail systemd[1]: mariadb.service: Consumed 2min 36.611s CPU time.
/var/log/syslog.1:Mar 20 19:17:32 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 65219
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] mariadbd: Aria engine: starting recovery
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: recovered pages: 0% 10% 20% 30% 40% 50% 63% 75% 87% 98% 100% (0.0 seconds); tables to flush: 3 2 1 0
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]:  (0.0 seconds);
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] mariadbd: Aria engine: recovery done
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Using transactional memory
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog.1:Mar 20 19:17:33 mail mariadbd[65219]: 2023-03-20 19:17:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3398371976,3399119588
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Starting final batch to recover 1495 pages from redo log.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: 10.6.12 started; log sequence number 3432962086; transaction id 3998399
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog.1:Mar 20 19:17:35 mail mariadbd[65219]: 2023-03-20 19:17:35 0 [Note] InnoDB: Buffer pool(s) load completed at 230320 19:17:35
/var/log/syslog.1:Mar 20 19:17:36 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog.1:Mar 20 19:17:36 mail mariadbd[65219]: 2023-03-20 19:17:36 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 20 19:17:36 mail /etc/mysql/debian-start[65249]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog.1:Mar 20 19:17:36 mail /etc/mysql/debian-start[65249]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog.1:Mar 20 19:17:36 mail mariadbd[65219]: 2023-03-20 19:17:36 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 21 08:35:30 mail kernel: [57697.429907] [  65219]   114 65219   270572    46716   569344        0             0 mariadbd
/var/log/syslog.1:Mar 23 09:54:21 mail mariadbd[65219]: 2023-03-23  9:54:21 18775 [Warning] Aborted connection 18775 to db: ' website4_wordpress' user: ' website4' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 09:54:21 mail mariadbd[65219]: 2023-03-23  9:54:21 18774 [Warning] Aborted connection 18774 to db: 'website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 09:54:21 mail mariadbd[65219]: 2023-03-23  9:54:21 18776 [Warning] Aborted connection 18776 to db: ' website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 13:01:43 mail kernel: [246464.110328] [  65219]   114 65219   272343    66541   745472        0             0 mariadbd
/var/log/syslog.1:Mar 23 13:01:43 mail kernel: [246464.110531] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=65219,uid=114
/var/log/syslog.1:Mar 23 13:01:43 mail kernel: [246464.110639] Out of memory: Killed process 65219 (mariadbd) total-vm:1089372kB, anon-rss:266164kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:728kB oom_score_adj:0
/var/log/syslog.1:Mar 23 13:01:43 mail systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
/var/log/syslog.1:Mar 23 13:01:43 mail systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
/var/log/syslog.1:Mar 23 13:01:43 mail systemd[1]: mariadb.service: Failed with result 'oom-kill'.
/var/log/syslog.1:Mar 23 13:01:43 mail systemd[1]: mariadb.service: Consumed 12min 41.933s CPU time.
/var/log/syslog.1:Mar 23 13:02:33 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 341212
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] mariadbd: Aria engine: starting recovery
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: tables to flush: 2 1 0
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]:  (0.0 seconds);
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] mariadbd: Aria engine: recovery done
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Using transactional memory
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog.1:Mar 23 13:02:37 mail mariadbd[341212]: 2023-03-23 13:02:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3753958639,3753996379
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Starting final batch to recover 1470 pages from redo log.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: 10.6.12 started; log sequence number 3779107571; transaction id 4397997
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 0 [Note] InnoDB: Buffer pool(s) load completed at 230323 13:02:38
/var/log/syslog.1:Mar 23 13:02:38 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 23 13:02:38 mail /etc/mysql/debian-start[341232]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog.1:Mar 23 13:02:38 mail /etc/mysql/debian-start[341232]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog.1:Mar 23 13:02:38 mail mariadbd[341212]: 2023-03-23 13:02:38 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 23 13:02:51 mail kernel: [246531.895676] [ 341212]   114 341212   266909    24467   417792        0             0 mariadbd
/var/log/syslog.1:Mar 23 13:02:57 mail mariadbd[341212]: 2023-03-23 13:02:57 9 [Warning] Aborted connection 9 to db: ' website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:04 mail kernel: [281344.165418] [ 341212]   114 341212   267434    32636   466944        0             0 mariadbd
/var/log/syslog.1:Mar 23 22:43:04 mail mariadbd[341212]: 2023-03-23 22:43:04 5788 [Warning] Aborted connection 5788 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:04 mail mariadbd[341212]: 2023-03-23 22:43:04 5787 [Warning] Aborted connection 5787 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:05 mail mariadbd[341212]: 2023-03-23 22:43:05 5786 [Warning] Aborted connection 5786 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:05 mail mariadbd[341212]: 2023-03-23 22:43:05 5785 [Warning] Aborted connection 5785 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:05 mail mariadbd[341212]: 2023-03-23 22:43:05 5784 [Warning] Aborted connection 5784 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 23 22:43:05 mail mariadbd[341212]: 2023-03-23 22:43:05 5783 [Warning] Aborted connection 5783 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog.1:Mar 25 08:59:43 mail kernel: [404738.912156] [ 341212]   114 341212   269761    57062   655360        0             0 mariadbd
/var/log/syslog.1:Mar 25 08:59:43 mail kernel: [404738.912339] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=341212,uid=114
/var/log/syslog.1:Mar 25 08:59:43 mail kernel: [404738.912433] Out of memory: Killed process 341212 (mariadbd) total-vm:1079044kB, anon-rss:228248kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:640kB oom_score_adj:0
/var/log/syslog.1:Mar 25 08:59:44 mail systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
/var/log/syslog.1:Mar 25 08:59:44 mail systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
/var/log/syslog.1:Mar 25 08:59:44 mail systemd[1]: mariadb.service: Failed with result 'oom-kill'.
/var/log/syslog.1:Mar 25 08:59:44 mail systemd[1]: mariadb.service: Consumed 9min 39.704s CPU time.
/var/log/syslog.1:Mar 25 09:00:21 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 506904
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] mariadbd: Aria engine: starting recovery
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: recovered pages: 0% 33% 49% 69% 100% (0.0 seconds); tables to flush: 2 1 0
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]:  (0.0 seconds);
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] mariadbd: Aria engine: recovery done
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] InnoDB: Using transactional memory
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog.1:Mar 25 09:00:21 mail mariadbd[506904]: 2023-03-25  9:00:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog.1:Mar 25 09:00:22 mail mariadbd[506904]: 2023-03-25  9:00:22 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog.1:Mar 25 09:00:22 mail mariadbd[506904]: 2023-03-25  9:00:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3916421227,3916421484
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: Starting final batch to recover 1757 pages from redo log.
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: 10.6.12 started; log sequence number 3981524141; transaction id 4564858
/var/log/syslog.1:Mar 25 09:00:24 mail mariadbd[506904]: 2023-03-25  9:00:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: 2023-03-25  9:00:25 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: 2023-03-25  9:00:25 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: 2023-03-25  9:00:25 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: 2023-03-25  9:00:25 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog.1:Mar 25 09:00:25 mail mariadbd[506904]: 2023-03-25  9:00:25 0 [Note] InnoDB: Buffer pool(s) load completed at 230325  9:00:25
/var/log/syslog.1:Mar 25 09:00:27 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog.1:Mar 25 09:00:27 mail mariadbd[506904]: 2023-03-25  9:00:27 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 25 09:00:27 mail /etc/mysql/debian-start[506945]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog.1:Mar 25 09:00:27 mail /etc/mysql/debian-start[506945]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog.1:Mar 25 09:00:27 mail mariadbd[506904]: 2023-03-25  9:00:27 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog.1:Mar 25 09:01:45 mail kernel: [404860.376309] [ 506904]   114 506904   267133    27662   442368        0             0 mariadbd
/var/log/syslog.1:Mar 25 09:02:06 mail kernel: [404881.365444] [ 506904]   114 506904   267133    27838   442368        0             0 mariadbd
/var/log/syslog.1:Mar 25 09:02:08 mail mariadbd[506904]: 2023-03-25  9:02:08 11 [Warning] Aborted connection 11 to db: ' website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)

(2/2)

grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-00000000002b323f-0005f74511baec59.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-000000000030e702-0005f7affd62bb23.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-000000000026d887-0005f6ff28c628dc.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-0000000000229992-0005f6a64a3f2ef1.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-00000000002f7057-0005f791c1e7e747.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-00000000002e02b9-0005f771a7700aef.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-00000000002c9a8c-0005f75a18adc927.journal: binary file matches
grep: /var/log/journal/dbfc930133144c318d9a5281fb4ed652/system@87906e24ac6d443a8cb7b06a7c303046-00000000001f9a0d-0005f6718e313046.journal: binary file matches
/var/log/kern.log.1:Mar 20 16:09:46 mail kernel: [1316343.807627] [ 937966]   114 937966   272119    62504   708608        0             0 mariadbd
/var/log/kern.log.1:Mar 20 16:09:46 mail kernel: [1316343.807854] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=937966,uid=114
/var/log/kern.log.1:Mar 20 16:09:46 mail kernel: [1316343.807969] Out of memory: Killed process 937966 (mariadbd) total-vm:1088476kB, anon-rss:247932kB, file-rss:2084kB, shmem-rss:0kB, UID:114 pgtables:692kB oom_score_adj:0
/var/log/kern.log.1:Mar 20 19:16:28 mail kernel: [ 9757.306073] [    653]   114   653   272955    63261   720896        0             0 mariadbd
/var/log/kern.log.1:Mar 20 19:16:28 mail kernel: [ 9757.306350] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=653,uid=114
/var/log/kern.log.1:Mar 20 19:16:28 mail kernel: [ 9757.306433] Out of memory: Killed process 653 (mariadbd) total-vm:1091820kB, anon-rss:252532kB, file-rss:512kB, shmem-rss:0kB, UID:114 pgtables:704kB oom_score_adj:0
/var/log/kern.log.1:Mar 21 08:35:30 mail kernel: [57697.429907] [  65219]   114 65219   270572    46716   569344        0             0 mariadbd
/var/log/kern.log.1:Mar 23 13:01:43 mail kernel: [246464.110328] [  65219]   114 65219   272343    66541   745472        0             0 mariadbd
/var/log/kern.log.1:Mar 23 13:01:43 mail kernel: [246464.110531] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=65219,uid=114
/var/log/kern.log.1:Mar 23 13:01:43 mail kernel: [246464.110639] Out of memory: Killed process 65219 (mariadbd) total-vm:1089372kB, anon-rss:266164kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:728kB oom_score_adj:0
/var/log/kern.log.1:Mar 23 13:02:51 mail kernel: [246531.895676] [ 341212]   114 341212   266909    24467   417792        0             0 mariadbd
/var/log/kern.log.1:Mar 23 22:43:04 mail kernel: [281344.165418] [ 341212]   114 341212   267434    32636   466944        0             0 mariadbd
/var/log/kern.log.1:Mar 25 08:59:43 mail kernel: [404738.912156] [ 341212]   114 341212   269761    57062   655360        0             0 mariadbd
/var/log/kern.log.1:Mar 25 08:59:43 mail kernel: [404738.912339] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=341212,uid=114
/var/log/kern.log.1:Mar 25 08:59:43 mail kernel: [404738.912433] Out of memory: Killed process 341212 (mariadbd) total-vm:1079044kB, anon-rss:228248kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:640kB oom_score_adj:0
/var/log/kern.log.1:Mar 25 09:01:45 mail kernel: [404860.376309] [ 506904]   114 506904   267133    27662   442368        0             0 mariadbd
/var/log/kern.log.1:Mar 25 09:02:06 mail kernel: [404881.365444] [ 506904]   114 506904   267133    27838   442368        0             0 mariadbd
/var/log/dpkg.log.1:2023-02-23 06:09:39 upgrade mariadb-common:all 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-configured mariadb-common:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-common:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-installed mariadb-common:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status triggers-pending mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-common:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 upgrade mariadb-server-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-configured mariadb-server-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-server-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-installed mariadb-server-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-server-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 configure mariadb-common:all 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-common:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-configured mariadb-common:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status installed mariadb-common:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 configure mariadb-server-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:39 status unpacked mariadb-server-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-configured mariadb-server-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 status installed mariadb-server-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:39 trigproc mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:39 status half-configured mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:41 status installed mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 upgrade mariadb-client-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status half-configured mariadb-client-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status unpacked mariadb-client-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status half-installed mariadb-client-core-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status unpacked mariadb-client-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 configure mariadb-client-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:47 status unpacked mariadb-client-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status half-configured mariadb-client-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:47 status installed mariadb-client-core-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:52 upgrade mariadb-client-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:52 status half-configured mariadb-client-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:52 status unpacked mariadb-client-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:52 status half-installed mariadb-client-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:52 status triggers-pending mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status unpacked mariadb-client-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 upgrade mariadb-client:all 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status half-configured mariadb-client:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status unpacked mariadb-client:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status half-installed mariadb-client:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status unpacked mariadb-client:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 configure mariadb-client-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:53 status unpacked mariadb-client-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status half-configured mariadb-client-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status installed mariadb-client-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 configure mariadb-client:all 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:53 status unpacked mariadb-client:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status half-configured mariadb-client:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 status installed mariadb-client:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:53 trigproc mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:09:53 status half-configured mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:09:54 status installed mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:00 upgrade mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:00 status half-configured mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:01 status unpacked mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:01 status half-installed mariadb-server-10.6:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 status unpacked mariadb-server-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 upgrade mariadb-server:all 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 status half-configured mariadb-server:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 status unpacked mariadb-server:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 status half-installed mariadb-server:all 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:03 status unpacked mariadb-server:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:04 configure mariadb-server-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:10:04 status unpacked mariadb-server-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:04 status half-configured mariadb-server-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:07 status installed mariadb-server-10.6:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:07 configure mariadb-server:all 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:10:07 status unpacked mariadb-server:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:07 status half-configured mariadb-server:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:07 status installed mariadb-server:all 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 upgrade libmariadb3:amd64 1:10.6.11-0ubuntu0.22.04.1 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status half-configured libmariadb3:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status unpacked libmariadb3:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status half-installed libmariadb3:amd64 1:10.6.11-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status unpacked libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 configure libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1 <none>
/var/log/dpkg.log.1:2023-02-23 06:10:12 status unpacked libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status half-configured libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/dpkg.log.1:2023-02-23 06:10:12 status installed libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1
/var/log/unattended-upgrades/unattended-upgrades-dpkg.log:NEEDRESTART-SVC: mariadb.service
/var/log/unattended-upgrades/unattended-upgrades-dpkg.log:NEEDRESTART-SVC: mariadb.service
/var/log/unattended-upgrades/unattended-upgrades-dpkg.log:NEEDRESTART-SVC: mariadb.service
/var/log/unattended-upgrades/unattended-upgrades-dpkg.log:NEEDRESTART-SVC: mariadb.service
/var/log/kern.log:Mar 26 07:45:21 mail kernel: [483073.478732] [ 506904]   114 506904   267309    61586   696320        0             0 mariadbd
/var/log/kern.log:Mar 26 07:45:21 mail kernel: [483073.478918] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=506904,uid=114
/var/log/kern.log:Mar 26 07:45:21 mail kernel: [483073.479028] Out of memory: Killed process 506904 (mariadbd) total-vm:1069236kB, anon-rss:246344kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:680kB oom_score_adj:0
/var/log/syslog:Mar 26 07:45:21 mail kernel: [483073.478732] [ 506904]   114 506904   267309    61586   696320        0             0 mariadbd
/var/log/syslog:Mar 26 07:45:21 mail kernel: [483073.478918] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=506904,uid=114
/var/log/syslog:Mar 26 07:45:21 mail kernel: [483073.479028] Out of memory: Killed process 506904 (mariadbd) total-vm:1069236kB, anon-rss:246344kB, file-rss:0kB, shmem-rss:0kB, UID:114 pgtables:680kB oom_score_adj:0
/var/log/syslog:Mar 26 07:45:21 mail systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
/var/log/syslog:Mar 26 07:45:21 mail systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
/var/log/syslog:Mar 26 07:45:21 mail systemd[1]: mariadb.service: Failed with result 'oom-kill'.
/var/log/syslog:Mar 26 07:45:21 mail systemd[1]: mariadb.service: Consumed 3min 35.273s CPU time.
/var/log/syslog:Mar 26 08:09:20 mail systemd[1]: Starting MariaDB 10.6.12 database server...
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision  as process 584454
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Using transactional memory
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Number of pools: 1
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Completed initialization of buffer pool
/var/log/syslog:Mar 26 08:09:23 mail mariadbd[584454]: 2023-03-26  8:09:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4058830604,4059418066
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Starting final batch to recover 2233 pages from redo log.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: 128 rollback segments are active.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: 10.6.12 started; log sequence number 4103554492; transaction id 4723381
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] Plugin 'FEEDBACK' is disabled.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] Server socket created on IP: '127.0.0.1'.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] /usr/sbin/mariadbd: ready for connections.
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: Version: '10.6.12-MariaDB-0ubuntu0.22.04.1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 22.04
/var/log/syslog:Mar 26 08:09:25 mail mariadbd[584454]: 2023-03-26  8:09:25 0 [Note] InnoDB: Buffer pool(s) load completed at 230326  8:09:25
/var/log/syslog:Mar 26 08:09:26 mail systemd[1]: Started MariaDB 10.6.12 database server.
/var/log/syslog:Mar 26 08:09:26 mail mariadbd[584454]: 2023-03-26  8:09:26 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog:Mar 26 08:09:26 mail /etc/mysql/debian-start[584481]: Looking for 'mariadb' as: /usr/bin/mariadb
/var/log/syslog:Mar 26 08:09:26 mail /etc/mysql/debian-start[584481]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
/var/log/syslog:Mar 26 08:09:26 mail mariadbd[584454]: 2023-03-26  8:09:26 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
/var/log/syslog:Mar 26 08:10:33 mail mariadbd[584454]: 2023-03-26  8:10:33 11 [Warning] Aborted connection 11 to db: ' website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog:Mar 26 08:10:33 mail mariadbd[584454]: 2023-03-26  8:10:33 12 [Warning] Aborted connection 12 to db: ' website2_wordpress' user: ' website2' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog:Mar 26 16:24:21 mail mariadbd[584454]: 2023-03-26 16:24:21 5193 [Warning] Aborted connection 5193 to db: ' website3_wordpress' user: 'website3' host: 'localhost' (Got an error reading communication packets)
/var/log/syslog:Mar 26 16:24:21 mail mariadbd[584454]: 2023-03-26 16:24:21 5192 [Warning] Aborted connection 5192 to db: 'website1_wordpress' user: 'website1' host: 'localhost' (Got an error reading communication packets)

I think the log is pretty clear. Why is another matter.

var/log/syslog.1:Mar 20 16:09:46 mail kernel: [1316343.807969] Out of memory: Killed process 937966 (mariadbd) total-vm:1088476kB, anon-rss:247932kB, file-rss:2084kB, shmem-rss:0kB, UID:114 pgtables:692kB oom_score_adj:0

1 Like

Thank you for showing me the way @ID10T

Could this be a memory resource issue?

Do you think it is useful (or a good start) to kill duplicate processes (like the ones that have the red rectangle on their right in the picture)?

[EDIT]

Is there a way to prevent the processes replication?

Thank you once again.

Regrettably, a little while ago also PHP-FPM 8.1.17 Server has stopped as well.

Under the file

/etc/php/8.1/fpm/pool.d/www.conf

I may see:

pm = dynamic
pm.max_children = 5
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 3
;pm.max_spawn_rate = 32
;pm.process_idle_timeout = 10s;
;pm.max_requests = 500

If I want to reduce child processes for PHP-FPM, how may I amend the above configuration?

Moreover, may you please confirm that I can manage the file

/etc/mysql/mariadb.conf.d/50-server-cnf

[server]
[mysqld]
pid-file                = /run/mysqld/mysqld.pid
basedir                 = /usr
bind-address            = 127.0.0.1
expire_logs_days        = 10
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
innodb_file_per_table = 1
max_allowed_packet = 64M
[embedded]
[mariadb]
[mariadb-10.6]

through Webmin → Servers → MariaDB Database Server → MariaDB Server Configuration

Thank you in advance.

There is another thread about postfix which is similar. I’ve posted a link there about the oom killer. It has a ranking system of it’s own to kill processes so the one killed might actually not be the offender. PHP-FPM comes up in this one too.

1 Like

Do you think this resource may be useful?

Do you think is it good switching to “on demand” and uncomment/set the “process idle timeout” variable?

Not yet sure on how to calculate the correct number of children. I run a total of 5 websites on a 4GB RAM machine.

May you please assist?

Thank you in advance.

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