[MDEV-32187] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch Created: 2023-09-16  Updated: 2023-11-04

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 11.1.2
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Olivier LEVILLAIN Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: bug
Environment:

Oracle Cloud Infra, VM.Standard.E2.1.Micro with Oracle Linux 8, MariaDB running in Docker compose with:
db:
container_name: wordpress.db
env_file: .env
image: mariadb
volumes:

  • ./data/databases:/var/lib/mysql
  • ./data/cnf.d:/etc/mysql/cnf.d
  • ./data/log/mysql:/var/log/mysql
  • ./data/backup:/backup
    restart: unless-stopped

Issue Links:
Relates
relates to MDEV-29660 [ERROR] [FATAL] InnoDB: innodb_fatal_... Closed

 Description   

I get this crash every once in a while (~4 to 5 days). I can't find find the core dump in my folder.
Looks very similar to #MDEV-29660 but with 11.1.2

Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-09-12 5:45:33 0 [ERROR] [FATAL] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch. Please refer to https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/
230912 6:05:04 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision: 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=140
max_threads=153
thread_count=114
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468041 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
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 = 0x0 thread_stack 0x49000
mariadbd(my_print_stacktrace+0x32)[0x55b02f35c7c2]
Printing to addr2line failed
mariadbd(handle_fatal_signal+0x488)[0x55b02ee35cf8]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f8640fcf520]
/lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x12c)[0x7f8641023a7c]
/lib/x86_64-linux-gnu/libc.so.6(raise+0x16)[0x7f8640fcf476]
/lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f8640fb57f3]
mariadbd(+0x6b1a21)[0x55b02ea41a21]
mariadbd(+0x6a7eea)[0x55b02ea37eea]
mariadbd(_ZN5tpool19thread_pool_generic13timer_generic7executeEPv+0x40)[0x55b02f2f1d20]
mariadbd(_ZN5tpool4task7executeEv+0x3a)[0x55b02f2f27da]
mariadbd(_ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE+0x57)[0x55b02f2f0867]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xdc253)[0x7f8641378253]
/lib/x86_64-linux-gnu/libc.so.6(+0x94b43)[0x7f8641021b43]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7f86410b2bb4]
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /var/lib/mysql
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size unlimited unlimited bytes
Max resident set unlimited unlimited bytes
Max processes unlimited unlimited processes
Max open files 1048576 1048576 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 3385 3385 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e

Kernel version: Linux version 5.15.0-103.114.4.el8uek.x86_64 (mockbuild@host-100-100-224-28) (gcc (GCC) 11.2.1 20220127 (Red Hat 11.2.1-9.1.0.3), GNU ld version 2.36.1-2.0.1.el8) #2 SMP Mon Jun 26 10:13:01
PDT 2023

 Comments   
Comment by Marko Mäkelä [ 2023-09-16 ]

Can you please provide stack traces for all threads, following the instructions that the fatal error message linked to? You can see an example of that in MDEV-32049, which this bug report might be a duplicate of.

Comment by Olivier LEVILLAIN [ 2023-09-16 ]

Ok @marko
I restarted my instance with the image linked in #MDEV-32049 and will let you know when I get a trace.
Thank you.

Comment by Olivier LEVILLAIN [ 2023-09-21 ]

Since I changed the image for the debug one, I have had no crash but the instance started correctly and for 3 days everything went fine but after 3 days it began restarting again and again (every minute or so) with each time almost the same sequence:

2023-09-21 09:03:58+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.2+maria~ubu2204 started.
2023-09-21 09:03:58+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-09-21 09:03:58+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.2+maria~ubu2204 started.
2023-09-21 09:03:59+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-09-21 9:03:59 0 [Note] Starting MariaDB 11.2.2-MariaDB-1:11.2.2+maria~ubu2204 source revision eece7f135f1d87c66faa8a51090401c09adc1edc as process 1
2023-09-21 9:03:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-21 9:03:59 0 [Note] InnoDB: Number of transaction pools: 1
2023-09-21 9:03:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-09-21 9:03:59 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-09-21 9:03:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-09-21 9:03:59 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-21 9:03:59 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-09-21 9:03:59 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-09-21 9:03:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7108602931
2023-09-21 9:03:59 0 [Note] InnoDB: End of log at LSN=7109293669
2023-09-21 9:03:59 0 [Note] InnoDB: To recover: 40 pages
2023-09-21 9:03:59 0 [Note] InnoDB: Last binlog file '/config/log/mysql/mariadb-bin.000206', position 6115687
2023-09-21 9:03:59 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-09-21 9:03:59 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-09-21 9:03:59 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-09-21 9:03:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-09-21 9:03:59 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-09-21 9:03:59 0 [Note] InnoDB: log sequence number 7109293669; transaction id 3574255
2023-09-21 9:03:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-09-21 9:03:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-21 9:03:59 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-09-21 9:03:59 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-09-21 9:03:59 0 [Note] Server socket created on IP: '::'.
2023-09-21 9:03:59 0 [Warning] 'user' entry '@971247c310d9' ignored in --skip-name-resolve mode.
2023-09-21 9:03:59 0 [Warning] 'proxies_priv' entry '@% root@971247c310d9' ignored in --skip-name-resolve mode.
2023-09-21 9:03:59 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-09-21 9:03:59 0 [Note] mariadbd: ready for connections.
Version: '11.2.2-MariaDB-1:11.2.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-09-21 9:03:59 0 [Note] InnoDB: Buffer pool(s) load completed at 230921 9:03:59

I don't find any dump in the image although I changed the settings.

Comment by Marko Mäkelä [ 2023-09-21 ]

danblack, can you please assist leolivier to provide stack traces from the hang? Based on the messages from the subsequent start-up, the server was not particularly busy when it hung: less than a megabyte of redo log written since the latest checkpoint, and only 40 pages had to be recovered.

Comment by Daniel Black [ 2023-09-22 ]

First:

sysctl kernel.core_pattern=core

This should make the current running kernel save a core file, maybe in a datadir volume.

try running compose file like:

  db:
 
    container_name: wordpress.db
 
    env_file: .env
 
    image: quay.io/mariadb-foundation/mariadb-debug:11.2
 
    command: gdb -ex r  -ex 'thread apply all bt -frame-arguments all full'  --args mariadbd
 
    user: mysql
 
    volumes:
 
      - ./data/databases:/var/lib/mysql
 
      - ./data/cnf.d:/etc/mysql/cnf.d
 
      - ./data/log/mysql:/var/log/mysql
 
      - ./data/backup:/backup
 
    restart: unless-stopped

I'm not sure why you aren't seeing a shutdown. My usual thoughts with lack of output are OOM.

Comment by Olivier LEVILLAIN [ 2023-09-23 ]

My DB was totally crashed so I restarted with a backup I had and with the normal mariadb image and it worked (I didn't wait enoigh to see if I experimented a new crash as it may take several days)
Then I changed things as suggested by Daniel but now, mariadb does not start, I get the following log:

GNU gdb (Ubuntu 12.1-0ubuntu1~22.04) 12.1
 
Copyright (C) 2022 Free Software Foundation, Inc.
 
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
 
This is free software: you are free to change and redistribute it.
 
There is NO WARRANTY, to the extent permitted by law.
 
Type "show copying" and "show warranty" for details.
 
This GDB was configured as "x86_64-linux-gnu".
 
Type "show configuration" for configuration details.
 
For bug reporting instructions, please see:
 
<https://www.gnu.org/software/gdb/bugs/>.
 
Find the GDB manual and other documentation resources online at:
 
    <http://www.gnu.org/software/gdb/documentation/>.
 
 
 
For help, type "help".
 
Type "apropos word" to search for commands related to "word"...
 
Reading symbols from mariadbd...
 
Reading symbols from /usr/lib/debug/.build-id/39/0eb523dc2fcfd3e99dc3b01aa6f5a87776224f.debug...
 
Starting program: /usr/sbin/mariadbd
 
warning: Error disabling address space randomization: Operation not permitted
 
[Thread debugging using libthread_db enabled]
 
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
 
/usr/sbin/mariadbd: Please consult the Knowledge Base to find out how to run mysqld as root!
 
2023-09-23 10:41:45 0 [ERROR] Aborting
 
[Inferior 1 (process 10) exited with code 01]
 
(gdb) quit
 
GNU gdb (Ubuntu 12.1-0ubuntu1~22.04) 12.1
 
Copyright (C) 2022 Free Software Foundation, Inc.
 
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
 
This is free software: you are free to change and redistribute it.
 
There is NO WARRANTY, to the extent permitted by law.
 
Type "show copying" and "show warranty" for details.
 
This GDB was configured as "x86_64-linux-gnu".
 
Type "show configuration" for configuration details.
 
For bug reporting instructions, please see:
 
<https://www.gnu.org/software/gdb/bugs/>.
 
Find the GDB manual and other documentation resources online at:
 
    <http://www.gnu.org/software/gdb/documentation/>.
 
 
 
For help, type "help".
 
Type "apropos word" to search for commands related to "word"...
 
Reading symbols from mariadbd...
 
Reading symbols from /usr/lib/debug/.build-id/39/0eb523dc2fcfd3e99dc3b01aa6f5a87776224f.debug...
 
Starting program: /usr/sbin/mariadbd
 
warning: Error disabling address space randomization: Operation not permitted
 
[Thread debugging using libthread_db enabled]
 
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
 
/usr/sbin/mariadbd: Please consult the Knowledge Base to find out how to run mysqld as root!
 
2023-09-23 10:42:02 0 [ERROR] Aborting
 
[Inferior 1 (process 10) exited with code 01]
 
(gdb) quit

In the database folder I have these files:

$ docker exec wordpress.db ls -l /var/lib/mysql
 
total 211880
 
-rw-r-----. 1 mysql mysql   4644864 Sep 23 10:39 aria_log.00000001
 
-rw-r-----. 1 mysql mysql     65536 Sep 17 00:00 aria_log.00000001.backup.20210517
 
-rw-r-----. 1 mysql mysql        52 Sep 23 10:39 aria_log_control
 
-rw-r-----. 1 mysql mysql        52 Sep 17 00:00 aria_log_control.backup.20210517
 
-rw-r-----. 1 mysql mysql       285 Sep 17 00:00 backup-my.cnf
 
-rw-rw----. 1 mysql mysql         0 Sep 23 10:38 ddl.log
 
drwx------. 2 mysql mysql      4096 Sep 17 00:00 eklectikDB
 
-rw-rw----. 1 mysql mysql      2231 Sep 23 10:39 ib_buffer_pool
 
-rw-rw----. 1 mysql mysql 100663296 Sep 23 10:39 ib_logfile0
 
-rw-r-----. 1 mysql mysql  79691776 Sep 23 10:39 ibdata1
 
-rw-r-----. 1 mysql mysql        83 Sep 17 00:00 mariadb_backup_checkpoints
 
-rw-r-----. 1 mysql mysql       470 Sep 17 00:00 mariadb_backup_info
 
-rw-r-----. 1 mysql mysql        15 Sep 21 14:50 mariadb_upgrade_info
 
-rw-rw----. 1 mysql mysql         0 Sep 21 14:50 multi-master.info
 
drwx------. 2 mysql mysql      4096 Sep 21 14:50 mysql
 
drwx------. 2 mysql mysql        20 Sep 21 14:50 performance_schema
 
drwx------. 2 mysql mysql      8192 Sep 21 14:50 sys
 
-rw-r--r--. 1 mysql mysql    387888 Sep 21 14:50 system_mysql_backup_unknown_version.sql.zst
 
-rw-r-----. 1 mysql mysql  10485760 Sep 23 10:39 undo001
 
-rw-r-----. 1 mysql mysql  10485760 Sep 23 10:35 undo002
 
-rw-r-----. 1 mysql mysql  10485760 Sep 23 10:35 undo003

So, only the file aria_log.00000001 has been changed today... I still don't find any dump (or are they stored somewhere else?).

EDIT: I just noticed I didn't use the user: mysql line in the compose file, does it change something?
EDIT2: I added the user:mysql in the compose file and now it starts. So I'll tell you if starts crashing again and provide the core dump

Comment by Olivier LEVILLAIN [ 2023-09-30 ]

So my database worked well for several days and then on the 27th, it started again to crash.
I see the debug is on in the logs (lots of thread traces) but still I don't see any core dump in the datadir directory (which is mounted in a volume):

aria_log.00000001 backup-my.cnf eklectikDB ibtmp1 multi-master.info system_mysql_backup_unknown_version.sql.zst
aria_log.00000001.backup.20210517 ddl.log ib_buffer_pool mariadb_backup_checkpoints mysql undo001
aria_log_control ddl_recovery-backup.log ibdata1 mariadb_backup_info performance_schema undo002
aria_log_control.backup.20210517 ddl_recovery.log ib_logfile0 mariadb_upgrade_info sys undo003

and as the container keeps restarting again and again, I can't connect to it and try to see if there are core files in other folders... I'm a bit desperate :/

In the logs, I can see a lot of lines like this:

New Thread 0x7f75ed7fe640 (LWP 97778)]
[New Thread 0x7f75edfff640 (LWP 97779)]
[Thread 0x7f75ecffd640 (LWP 97543) exited]
[Thread 0x7f75edfff640 (LWP 97779) exited]
[New Thread 0x7f75edfff640 (LWP 97843)]
[Thread 0x7f75ed7fe640 (LWP 97778) exited]
[New Thread 0x7f75ed7fe640 (LWP 97880)]
[Thread 0x7f75edfff640 (LWP 97843) exited]
[New Thread 0x7f75edfff640 (LWP 97917)]
[Thread 0x7f75edfff640 (LWP 97917) exited]
[New Thread 0x7f75edfff640 (LWP 97936)]
[New Thread 0x7f75ecffd640 (LWP 97955)]
[Thread 0x7f75edfff640 (LWP 97936) exited]
[Thread 0x7f75ed7fe640 (LWP 97880) exited]
[New Thread 0x7f75ed7fe640 (LWP 97975)]
[Thread 0x7f75d77fe640 (LWP 97745) exited]
[New Thread 0x7f75d77fe640 (LWP 98043)]
[Thread 0x7f75ed7fe640 (LWP 97975) exited]
[New Thread 0x7f75ed7fe640 (LWP 98069)]
[Thread 0x7f75ecffd640 (LWP 97955) exited]
[New Thread 0x7f75ecffd640 (LWP 98136)]
[Thread 0x7f75ed7fe640 (LWP 98069) exited]
[New Thread 0x7f75ed7fe640 (LWP 98188)]
[Thread 0x7f75d77fe640 (LWP 98043) exited]
[New Thread 0x7f75d77fe640 (LWP 98231)]
[Thread 0x7f75ecffd640 (LWP 98136) exited]

then at some point, new thraeds are created, but they never exits:
[New Thread 0x7f75d6283640 (LWP 99975)]
[New Thread 0x7f75d6238640 (LWP 99976)]
[New Thread 0x7f75d61ed640 (LWP 99977)]
[New Thread 0x7f75d61a2640 (LWP 99978)]
[New Thread 0x7f75d6157640 (LWP 99979)]
[New Thread 0x7f75d610c640 (LWP 99980)]
[New Thread 0x7f75d60c1640 (LWP 99981)]
[New Thread 0x7f75d6076640 (LWP 99982)]
[New Thread 0x7f75d602b640 (LWP 99983)]
[New Thread 0x7f75d5fe0640 (LWP 99984)]
[New Thread 0x7f75d5f95640 (LWP 99985)]
[New Thread 0x7f75d5f4a640 (LWP 99986)]
[New Thread 0x7f75d5eff640 (LWP 99987)]
[New Thread 0x7f75d5eb4640 (LWP 99988)]
[New Thread 0x7f75d5e69640 (LWP 99989)]
[New Thread 0x7f75d5e1e640 (LWP 99990)]
[New Thread 0x7f75d5dd3640 (LWP 99991)]
[New Thread 0x7f75d5d88640 (LWP 99992)]
[New Thread 0x7f75d5d3d640 (LWP 99993)]
[New Thread 0x7f75d5cf2640 (LWP 99994)]
[New Thread 0x7f75d5ca7640 (LWP 99995)]
[New Thread 0x7f75d5c5c640 (LWP 99996)]
[New Thread 0x7f75d5c11640 (LWP 99997)]
[New Thread 0x7f75d5bc6640 (LWP 99998)]
[New Thread 0x7f75d5b7b640 (LWP 99999)]

and finally

2023-09-27 2:48:47 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-09-27 2:48:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-09-27 2:48:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-09-27 2:48:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-09-27 2:48:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-09-27 2:48:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)

and finally, these messages disappears and I get:

[Thread 0x7f75d77fe640 (LWP 99849) exited]
[Thread 0x7f75edfff640 (LWP 99879) exited]
[Thread 0x7f75ed7fe640 (LWP 99733) exited]
[New Thread 0x7f75edfff640 (LWP 100028)]
[New Thread 0x7f75ed7fe640 (LWP 100029)]
GNU gdb (Ubuntu 12.1-0ubuntu1~22.04) 12.1
Copyright (C) 2022 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
GNU gdb (Ubuntu 12.1-0ubuntu1~22.04) 12.1
Copyright (C) 2022 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...

and after that it loops restarting with the gdb startup message

I really don't know what to do.
Is there a way to direct for sure the core dump to the datadir?

Comment by Olivier LEVILLAIN [ 2023-10-06 ]

I again reused my backup and ran the "normal" image without debug and experienced again some issues after a few days but the traces in the logs are different:
I forced a restart of the container on 2023-09-30 10:02:19+00:00 and I get this trace: the database starts properly but after 2', I get some communication errors then nothing then almost 1 day later (22hrs!) the database shutdowns itself and restart, then again 8hrs later, too many connections errors (as above, probably again threads are not exiting) and the 1.5hr later the database restarts, and keep restarting again and again until I kill it.

2023-09-30 10:02:19+00:00 [Note] [Entrypoint]: Temporary server stopped
2023-09-30 10:02:19 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-09-30 10:02:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-30 10:02:20 0 [Note] InnoDB: Number of transaction pools: 1
2023-09-30 10:02:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-09-30 10:02:20 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-09-30 10:02:20 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-09-30 10:02:20 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-30 10:02:20 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-09-30 10:02:21 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-09-30 10:02:21 0 [Note] InnoDB: End of log at LSN=7090582973
2023-09-30 10:02:22 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-09-30 10:02:22 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-09-30 10:02:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-09-30 10:02:22 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-09-30 10:02:22 0 [Note] InnoDB: log sequence number 7090582973; transaction id 3569941
2023-09-30 10:02:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-09-30 10:02:22 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2023-09-30 10:02:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-30 10:02:22 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-09-30 10:02:22 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-09-30 10:02:22 0 [Note] Server socket created on IP: '::'.
2023-09-30 10:02:22 0 [Warning] 'user' entry '@971247c310d9' ignored in --skip-name-resolve mode.
2023-09-30 10:02:22 0 [Warning] 'proxies_priv' entry '@% root@971247c310d9' ignored in --skip-name-resolve mode.
2023-09-30 10:02:22 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-09-30 10:02:22 0 [Note] mariadbd: ready for connections.
Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-09-30 10:04:41 46 [Warning] Aborted connection 46 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 48 [Warning] Aborted connection 48 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 12 [Warning] Aborted connection 12 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 16 [Warning] Aborted connection 16 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 20 [Warning] Aborted connection 20 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 18 [Warning] Aborted connection 18 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 21 [Warning] Aborted connection 21 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 19 [Warning] Aborted connection 19 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 13 [Warning] Aborted connection 13 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 27 [Warning] Aborted connection 27 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 17 [Warning] Aborted connection 17 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 14 [Warning] Aborted connection 14 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 7 [Warning] Aborted connection 7 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 4 [Warning] Aborted connection 4 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 3 [Warning] Aborted connection 3 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 8 [Warning] Aborted connection 8 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 50 [Warning] Aborted connection 50 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:42 51 [Warning] Aborted connection 51 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 15 [Warning] Aborted connection 15 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 25 [Warning] Aborted connection 25 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 6 [Warning] Aborted connection 6 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 5 [Warning] Aborted connection 5 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 49 [Warning] Aborted connection 49 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 47 [Warning] Aborted connection 47 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 9 [Warning] Aborted connection 9 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 23 [Warning] Aborted connection 23 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-09-30 10:04:43 11 [Warning] Aborted connection 11 to db: 'eklectikDB' user: 'eklectik' host: '172.22.0.3' (Got an error reading communication packets)
2023-10-01 7:57:39 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2023-10-01 7:57:39 0 [Note] InnoDB: FTS optimize thread exiting.
2023-10-01 7:57:40 0 [Note] InnoDB: Starting shutdown...
2023-10-01 7:57:40 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-10-01 7:57:40 0 [Note] InnoDB: Buffer pool(s) dump completed at 231001 7:57:40
2023-10-01 7:57:41 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-10-01 7:57:41 0 [Note] InnoDB: Shutdown completed; log sequence number 7096979636; transaction id 3573072
2023-10-01 7:57:41 0 [Note] mariadbd: Shutdown complete

2023-10-01 07:57:44+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-01 07:57:44+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-01 7:57:45 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-10-01 7:57:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-01 7:57:45 0 [Note] InnoDB: Number of transaction pools: 1
2023-10-01 7:57:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-10-01 7:57:45 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-10-01 7:57:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-10-01 7:57:45 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-01 7:57:45 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-10-01 7:57:45 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-10-01 7:57:45 0 [Note] InnoDB: End of log at LSN=7096979636
2023-10-01 7:57:45 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-10-01 7:57:45 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-10-01 7:57:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-10-01 7:57:45 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-10-01 7:57:45 0 [Note] InnoDB: log sequence number 7096979636; transaction id 3573073
2023-10-01 7:57:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-10-01 7:57:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-01 7:57:45 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-10-01 7:57:45 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-10-01 7:57:45 0 [Note] Server socket created on IP: '::'.
2023-10-01 7:57:45 0 [Warning] 'user' entry '@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-01 7:57:45 0 [Warning] 'proxies_priv' entry '@% root@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-01 7:57:45 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-10-01 7:57:45 0 [Note] mariadbd: ready for connections.
Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-10-01 7:57:45 0 [Note] InnoDB: Buffer pool(s) load completed at 231001 7:57:45
2023-10-04 14:31:48 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 14:31:55 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 14:32:06 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:47:27 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:47 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:54 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:54 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:56 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:57 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:57 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:57 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:57 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:48:59 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:00 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:01 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:02 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:02 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:02 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:02 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:04 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:07 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:07 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:07 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:08 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:08 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:09 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:09 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:09 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:10 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:11 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:11 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:11 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:11 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:12 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:13 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:13 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:13 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:13 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 18:49:14 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
2023-10-04 20:21:34+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:22:07+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:22:26+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:22:33+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:22:33 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-10-04 20:22:33 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
2023-10-04 20:22:33 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
2023-10-04 20:22:33 0 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
2023-10-04 20:22:33 0 [Note] WSREP: Node addr:
2023-10-04 20:22:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-04 20:22:34 0 [Note] InnoDB: Number of transaction pools: 1
2023-10-04 20:22:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-10-04 20:22:34 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-10-04 20:22:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-10-04 20:22:34 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-04 20:22:41+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:22:41+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:22:44+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:22:44+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:23:02+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:23:10+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:23:10 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-10-04 20:23:10 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
2023-10-04 20:23:10 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
2023-10-04 20:23:10 0 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
2023-10-04 20:23:10 0 [Note] WSREP: Node addr:
2023-10-04 20:23:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-04 20:23:10 0 [Note] InnoDB: Number of transaction pools: 1
2023-10-04 20:23:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-10-04 20:23:10 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-10-04 20:23:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-10-04 20:23:10 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-04 20:23:10 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-10-04 20:23:16+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:23:16+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:23:31+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:23:51+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:24:07+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:24:27+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:25:40+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:26:44+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:26:44+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:26:44 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-10-04 20:26:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-04 20:26:44 0 [Note] InnoDB: Number of transaction pools: 1
2023-10-04 20:26:44 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-10-04 20:26:44 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-10-04 20:26:44 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-10-04 20:26:44 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-04 20:26:44 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-10-04 20:26:44 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-10-04 20:26:44 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7096979620
2023-10-04 20:26:45 0 [Note] InnoDB: End of log at LSN=7127432743
2023-10-04 20:26:45 0 [Note] InnoDB: To recover: 481 pages
2023-10-04 20:26:45 0 [Note] InnoDB: Last binlog file '/config/log/mysql/mariadb-bin.000206', position 6115687
2023-10-04 20:26:45 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-10-04 20:26:45 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-10-04 20:26:45 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-10-04 20:26:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-10-04 20:26:45 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-10-04 20:26:45 0 [Note] InnoDB: log sequence number 7127432743; transaction id 3586997
2023-10-04 20:26:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-04 20:26:45 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-10-04 20:26:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-10-04 20:26:45 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-10-04 20:26:45 0 [Note] Server socket created on IP: '::'.
2023-10-04 20:26:45 0 [Warning] 'user' entry '@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-04 20:26:45 0 [Warning] 'proxies_priv' entry '@% root@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-04 20:26:45 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-10-04 20:26:45 0 [Note] mariadbd: ready for connections.
Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-10-04 20:26:45 0 [Note] InnoDB: Buffer pool(s) load completed at 231004 20:26:45
2023-10-04 20:27:48+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-10-04 20:27:48+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-10-04 20:27:48 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-10-04 20:27:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-04 20:27:48 0 [Note] InnoDB: Number of transaction pools: 1
2023-10-04 20:27:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-10-04 20:27:48 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-10-04 20:27:48 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-10-04 20:27:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-04 20:27:48 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-10-04 20:27:48 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-10-04 20:27:48 0 [Note] InnoDB: End of log at LSN=7127433995
2023-10-04 20:27:48 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-10-04 20:27:48 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-10-04 20:27:48 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-10-04 20:27:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-10-04 20:27:48 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-10-04 20:27:48 0 [Note] InnoDB: log sequence number 7127433995; transaction id 3586997
2023-10-04 20:27:48 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-10-04 20:27:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-04 20:27:48 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-10-04 20:27:48 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-10-04 20:27:48 0 [Note] Server socket created on IP: '::'.
2023-10-04 20:27:48 0 [Warning] 'user' entry '@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-04 20:27:48 0 [Warning] 'proxies_priv' entry '@% root@971247c310d9' ignored in --skip-name-resolve mode.
2023-10-04 20:27:48 0 [Note] mariadbd: Event Scheduler: Loaded 0 events

==>

Comment by Olivier LEVILLAIN [ 2023-11-04 ]

Fyi, as I was totally unable to get the database working properly and I didn't find anyway to provide you with a log file, I gave up on the free OCI account and went back to my original install on a simple raspberry pi 4 (on which everything works very fine with exactly the same database files so this is platform related, not to the database content itself)

Generated at Thu Feb 08 10:29:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.