Percona (Docker) shuts down over and over again - need help please

MySQL & MariaDB
,
1

Dear community,

I’ve set up an DEV environment using a Percona-Docker (latest) running on CentOS. Generally it’s working … the Problem is, that Percona (docker) shuts down sporadically and I have no idea why.

Please have a look at my log. Thx in advance!

{“log”:“mysqld: Out of memory (Needed 4294967200 bytes)\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.041169918Z”}

{“log”:“2024-01-12T11:22:31.041301Z 0 [Warning] Changed limits: max_open_files: 64 (requested 5000)\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.231848976Z”}

{“log”:“2024-01-12T11:22:31.228669Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.23188233Z”}

{“log”:“2024-01-12T11:22:31.229658Z 0 [Note] mysqld (mysqld 5.7.35-38) starting as process 1 …\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.231890745Z”}

{“log”:“2024-01-12T11:22:31.239501Z 0 [Warning] InnoDB: innodb_open_files should not be greater than the open_files_limit.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.239579547Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.239594955Z”}

{“log”:“2024-01-12T11:22:31.239677Z 0 [Note] InnoDB: PUNCH HOLE support available\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.239750107Z”}

{“log”:“2024-01-12T11:22:31.239794Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.239858279Z”}

{“log”:“2024-01-12T11:22:31.239883Z 0 [Note] InnoDB: Uses event mutexes\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.239911598Z”}

{“log”:“2024-01-12T11:22:31.239967Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.240006095Z”}

{“log”:“2024-01-12T11:22:31.240051Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.240089772Z”}

{“log”:“2024-01-12T11:22:31.240147Z 0 [Note] InnoDB: Using Linux native AIO\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.240193978Z”}

{“log”:“2024-01-12T11:22:31.241137Z 0 [Note] InnoDB: Number of pools: 1\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.2411936Z”}

{“log”:“2024-01-12T11:22:31.242265Z 0 [Note] InnoDB: Using CPU crc32 instructions\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.242319608Z”}

{“log”:“2024-01-12T11:22:31.244693Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.24475513Z”}

{“log”:“2024-01-12T11:22:31.250491Z 0 [Note] InnoDB: Completed initialization of buffer pool\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.250554473Z”}

{“log”:“2024-01-12T11:22:31.253081Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.253149282Z”}

{“log”:“2024-01-12T11:22:31.267913Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.267959943Z”}

{“log”:“2024-01-12T11:22:31.270478Z 0 [Note] InnoDB: Highest supported file format is Barracuda.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.270534775Z”}

{“log”:“2024-01-12T11:22:31.280789Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.280928061Z”}

{“log”:“2024-01-12T11:22:31.314927Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.314993285Z”}

{“log”:“2024-01-12T11:22:31.315076Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.315208548Z”}

{“log”:“2024-01-12T11:22:31.353633Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.353720761Z”}

{“log”:“2024-01-12T11:22:31.354285Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.354354458Z”}

{“log”:“2024-01-12T11:22:31.355804Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.355865047Z”}

{“log”:“2024-01-12T11:22:31.356281Z 0 [Note] InnoDB: Waiting for purge to start\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.35635253Z”}

{“log”:“2024-01-12T11:22:31.406972Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.35-38 started; log sequence number 14609951\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.407695895Z”}

{“log”:“2024-01-12T11:22:31.407296Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.407711735Z”}

{“log”:“2024-01-12T11:22:31.407517Z 0 [Note] Plugin ‘FEDERATED’ is disabled.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.407718407Z”}

{“log”:“2024-01-12T11:22:31.447672Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.44775185Z”}

{“log”:“2024-01-12T11:22:31.447880Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.447930625Z”}

{“log”:“2024-01-12T11:22:31.447953Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.447984856Z”}

{“log”:“2024-01-12T11:22:31.448013Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.448060749Z”}

{“log”:“2024-01-12T11:22:31.460735Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240112 11:22:31\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.46097706Z”}

{“log”:“2024-01-12T11:22:31.460858Z 0 [Warning] CA certificate ca.pem is self signed.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.460991087Z”}

{“log”:“2024-01-12T11:22:31.460886Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.460996446Z”}

{“log”:“2024-01-12T11:22:31.461690Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.462017419Z”}

{“log”:“2024-01-12T11:22:31.461733Z 0 [Note] IPv6 is available.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.462029902Z”}

{“log”:“2024-01-12T11:22:31.461740Z 0 [Note] - ‘::’ resolves to ‘::’;\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.462036154Z”}

{“log”:“2024-01-12T11:22:31.461758Z 0 [Note] Server socket created on IP: ‘::’.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.462041955Z”}

{“log”:“2024-01-12T11:22:31.529315Z 0 [Note] Event Scheduler: Loaded 0 events\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.529621491Z”}

{“log”:“2024-01-12T11:22:31.529508Z 0 [Note] mysqld: ready for connections.\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.529639955Z”}

{“log”:“Version: ‘5.7.35-38’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona Server (GPL), Release 38, Revision 3692a61\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.529646297Z”}

{“log”:“2024-01-12T11:47:59.820204Z 23 [Note] Got packets out of order\n”,“stream”:“stderr”,“time”:“2024-01-12T11:47:59.820745692Z”}

{“log”:“2024-01-12T13:37:02.196576Z 22 [Note] Aborted connection 22 to db: ‘aktiv-dia’ user: ‘root’ host: ‘XXXXXXXXXX’ (Got timeout reading communication packets)\n”,“stream”:“stderr”,“time”:“2024-01-12T13:37:02.19721931Z”}

{“log”:“2024-01-12T13:58:53.440364Z 74 [Note] Access denied for user ‘root’@‘XXXXXXXXXX’ (using password: NO)\n”,“stream”:“stderr”,“time”:“2024-01-12T13:58:53.440613145Z”}

{“log”:“2024-01-12T15:14:44.370372Z 95 [Note] Got an error reading communication packets\n”,“stream”:“stderr”,“time”:“2024-01-12T15:14:44.370656398Z”}

{“log”:“2024-01-12T15:14:54.563487Z 96 [Note] Got timeout reading communication packets\n”,“stream”:“stderr”,“time”:“2024-01-12T15:14:54.563687961Z”}

{“log”:“2024-01-12T15:14:55.500283Z 97 [Note] Access denied for user ‘’@‘XXXXXXXXXX’ (using password: NO)\n”,“stream”:“stderr”,“time”:“2024-01-12T15:14:55.500484269Z”}

{“log”:“2024-01-12T15:14:57.260145Z 98 [Note] Access denied for user ‘root’@‘XXXXXXXXXX’ (using password: YES)\n”,“stream”:“stderr”,“time”:“2024-01-12T15:14:57.260282829Z”}

{“log”:“2024-01-12T16:56:13.837659Z 110 [Note] Aborted connection 110 to db: ‘aktiv-dia’ user: ‘root’ host: ‘XXXXXXXXXX’ (Got an error reading communication packets)\n”,“stream”:“stderr”,“time”:“2024-01-12T16:56:13.837883965Z”}

{“log”:“2024-01-12T16:56:13.860129Z 109 [Note] Aborted connection 109 to db: ‘mysql’ user: ‘root’ host: ‘XXXXXXXXXX’ (Got an error reading communication packets)\n”,“stream”:“stderr”,“time”:“2024-01-12T16:56:13.860303526Z”}

{“log”:“2024-01-12T17:23:49.926565Z 151 [Note] Access denied for user ‘root’@‘XXXXXXXXXX’ (using password: NO)\n”,“stream”:“stderr”,“time”:“2024-01-12T17:23:49.926756929Z”}

{“log”:“2024-01-12T17:24:19.633304Z 153 [Note] Access denied for user ‘root’@‘XXXXXXXXXX’ (using password: NO)\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:19.633553429Z”}

{“log”:“2024-01-12T17:24:38.063360Z 0 [Note] Giving 10 client threads a chance to die gracefully\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:38.06354731Z”}

{“log”:“2024-01-12T17:24:38.063412Z 0 [Note] Shutting down slave threads\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:38.06359551Z”}

{“log”:“2024-01-12T17:24:40.063501Z 0 [Note] Forcefully disconnecting 10 remaining clients\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064759642Z”}

{“log”:“2024-01-12T17:24:40.063529Z 0 [Warning] mysqld: Forcing close of thread 148 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064794166Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064799937Z”}

{“log”:“2024-01-12T17:24:40.063622Z 0 [Warning] mysqld: Forcing close of thread 142 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064804585Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064809444Z”}

{“log”:“2024-01-12T17:24:40.063647Z 0 [Warning] mysqld: Forcing close of thread 141 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064813873Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064818612Z”}

{“log”:“2024-01-12T17:24:40.063668Z 0 [Warning] mysqld: Forcing close of thread 146 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.0648229Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064827569Z”}

{“log”:“2024-01-12T17:24:40.063688Z 0 [Warning] mysqld: Forcing close of thread 145 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064832167Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064837056Z”}

{“log”:“2024-01-12T17:24:40.063708Z 0 [Warning] mysqld: Forcing close of thread 144 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064841555Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064846233Z”}

{“log”:“2024-01-12T17:24:40.063729Z 0 [Warning] mysqld: Forcing close of thread 150 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064850652Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064855221Z”}

{“log”:“2024-01-12T17:24:40.063749Z 0 [Warning] mysqld: Forcing close of thread 149 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064859479Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064863877Z”}

{“log”:“2024-01-12T17:24:40.063769Z 0 [Warning] mysqld: Forcing close of thread 143 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064868315Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064872974Z”}

{“log”:“2024-01-12T17:24:40.063789Z 0 [Warning] mysqld: Forcing close of thread 147 user: ‘root’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064877282Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06488178Z”}

{“log”:“2024-01-12T17:24:40.063814Z 0 [Note] Event Scheduler: Purging the queue. 0 events\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064886148Z”}

{“log”:“2024-01-12T17:24:40.064299Z 0 [Note] Binlog end\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.064890897Z”}

{“log”:“2024-01-12T17:24:40.064954Z 0 [Note] Shutting down plugin ‘ngram’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065047831Z”}

{“log”:“2024-01-12T17:24:40.064965Z 0 [Note] Shutting down plugin ‘partition’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065058801Z”}

{“log”:“2024-01-12T17:24:40.064969Z 0 [Note] Shutting down plugin ‘BLACKHOLE’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065081634Z”}

{“log”:“2024-01-12T17:24:40.064973Z 0 [Note] Shutting down plugin ‘ARCHIVE’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065087605Z”}

{“log”:“2024-01-12T17:24:40.064976Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065092614Z”}

{“log”:“2024-01-12T17:24:40.064979Z 0 [Note] Shutting down plugin ‘MyISAM’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065097524Z”}

{“log”:“2024-01-12T17:24:40.065002Z 0 [Note] Shutting down plugin ‘INNODB_TABLESPACES_SCRUBBING’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065119785Z”}

{“log”:“2024-01-12T17:24:40.065021Z 0 [Note] Shutting down plugin ‘INNODB_TABLESPACES_ENCRYPTION’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065125266Z”}

{“log”:“2024-01-12T17:24:40.065036Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065139492Z”}

{“log”:“2024-01-12T17:24:40.065052Z 0 [Note] Shutting down plugin ‘INNODB_CHANGED_PAGES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065144862Z”}

{“log”:“2024-01-12T17:24:40.065083Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065149772Z”}

{“log”:“2024-01-12T17:24:40.065109Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065154701Z”}

{“log”:“2024-01-12T17:24:40.065126Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06515974Z”}

{“log”:“2024-01-12T17:24:40.065142Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065169949Z”}

{“log”:“2024-01-12T17:24:40.065157Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06517536Z”}

{“log”:“2024-01-12T17:24:40.065172Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065338796Z”}

{“log”:“2024-01-12T17:24:40.065212Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065352171Z”}

{“log”:“2024-01-12T17:24:40.065220Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065357311Z”}

{“log”:“2024-01-12T17:24:40.065223Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06536203Z”}

{“log”:“2024-01-12T17:24:40.065226Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065366879Z”}

{“log”:“2024-01-12T17:24:40.065229Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065371357Z”}

{“log”:“2024-01-12T17:24:40.065231Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065375625Z”}

{“log”:“2024-01-12T17:24:40.065234Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065380023Z”}

{“log”:“2024-01-12T17:24:40.065236Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065384882Z”}

{“log”:“2024-01-12T17:24:40.065239Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065389771Z”}

{“log”:“2024-01-12T17:24:40.065241Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065394671Z”}

{“log”:“2024-01-12T17:24:40.065243Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065399721Z”}

{“log”:“2024-01-12T17:24:40.065246Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065434345Z”}

{“log”:“2024-01-12T17:24:40.065248Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065441568Z”}

{“log”:“2024-01-12T17:24:40.065250Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065454532Z”}

{“log”:“2024-01-12T17:24:40.065253Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065459361Z”}

{“log”:“2024-01-12T17:24:40.065255Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06546386Z”}

{“log”:“2024-01-12T17:24:40.065258Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065468328Z”}

{“log”:“2024-01-12T17:24:40.065260Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065472817Z”}

{“log”:“2024-01-12T17:24:40.065263Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065477325Z”}

{“log”:“2024-01-12T17:24:40.065282Z 0 [Note] Shutting down plugin ‘INNODB_CMP’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065481844Z”}

{“log”:“2024-01-12T17:24:40.065285Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065486332Z”}

{“log”:“2024-01-12T17:24:40.065288Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06549084Z”}

{“log”:“2024-01-12T17:24:40.065291Z 0 [Note] Shutting down plugin ‘INNODB_TRX’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065495509Z”}

{“log”:“2024-01-12T17:24:40.065293Z 0 [Note] Shutting down plugin ‘XTRADB_ZIP_DICT_COLS’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065515637Z”}

{“log”:“2024-01-12T17:24:40.065296Z 0 [Note] Shutting down plugin ‘XTRADB_ZIP_DICT’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065521377Z”}

{“log”:“2024-01-12T17:24:40.065299Z 0 [Note] Shutting down plugin ‘XTRADB_RSEG’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065526558Z”}

{“log”:“2024-01-12T17:24:40.065301Z 0 [Note] Shutting down plugin ‘XTRADB_INTERNAL_HASH_TABLES’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065531837Z”}

{“log”:“2024-01-12T17:24:40.065304Z 0 [Note] Shutting down plugin ‘XTRADB_READ_VIEW’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065536977Z”}

{“log”:“2024-01-12T17:24:40.065306Z 0 [Note] Shutting down plugin ‘InnoDB’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065541806Z”}

{“log”:“2024-01-12T17:24:40.065382Z 0 [Note] InnoDB: FTS optimize thread exiting.\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.06556002Z”}

{“log”:“2024-01-12T17:24:40.065567Z 0 [Note] InnoDB: Starting shutdown…\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.065622166Z”}

{“log”:“2024-01-12T17:24:40.165716Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.166274664Z”}

{“log”:“2024-01-12T17:24:40.165997Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240112 17:24:40\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.166292507Z”}

{“log”:“2024-01-12T17:24:40.866468Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:40.866696985Z”}

{“log”:“2024-01-12T17:24:41.773103Z 0 [Note] InnoDB: Shutdown completed; log sequence number 14857603\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.773425075Z”}

{“log”:“2024-01-12T17:24:41.777784Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.777980378Z”}

{“log”:“2024-01-12T17:24:41.777821Z 0 [Note] Shutting down plugin ‘MEMORY’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.778006586Z”}

{“log”:“2024-01-12T17:24:41.777853Z 0 [Note] Shutting down plugin ‘CSV’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.778052291Z”}

{“log”:“2024-01-12T17:24:41.777863Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.778063563Z”}

{“log”:“2024-01-12T17:24:41.777920Z 0 [Note] Shutting down plugin ‘sha256_password’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.778266633Z”}

{“log”:“2024-01-12T17:24:41.777928Z 0 [Note] Shutting down plugin ‘mysql_native_password’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.77830771Z”}

{“log”:“2024-01-12T17:24:41.778230Z 0 [Note] Shutting down plugin ‘binlog’\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.778436622Z”}

{“log”:“2024-01-12T17:24:41.779061Z 0 [Note] mysqld: Shutdown complete\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.779230709Z”}

{“log”:“\n”,“stream”:“stderr”,“time”:“2024-01-12T17:24:41.779252159Z”}

2

Hi Michael,

Could you try to increase an amount of resources that allowed to be used by a docker container?

Thank you.

3

You may monitor containers resource usage statistics by command

docker stats

e.g.

Screenshot 2024-01-14 at 11.14.33
Screenshot 2024-01-14 at 11.14.33931×74 6.25 KB

4

Hello & Thx Vadim,

sure, any hints?

I mean, there’s no load o the database, max 3-5 request per hour, since it’s my dedicated playground.

Bildschirmfoto 2024-01-14 um 13.26.33
Bildschirmfoto 2024-01-14 um 13.26.331988×180 158 KB

5

maybe I should mention, that after the container shuts down, the database seems to be gone. even using an external volume …

Bildschirmfoto 2024-01-14 um 13.34.05

Bildschirmfoto 2024-01-14 um 13.34.27

6

@appfarms_dev looks like you are hitting out-of-mem killer, so DB eats the RAM.

Could you please share your compose yaml or whatever you use to deploy the container?

7

Hi,

{“log”:“mysqld: Out of memory (Needed 4294967200 bytes)\n”,“stream”:“stderr”,“time”:“2024-01-12T11:22:31.041169918Z”}

Rule of thumb: ignore all messages except the first one. You need more resources.

8

Thx @Sergey_Pronin & @Robert_Bernier ,

the docker shuts down with or without OOM warning … in 8 out of 10 shutdowns there is no OOM log, so it might be a coincidence.

Here’s what the docker.yaml looks like:

Bildschirmfoto 2024-01-16 um 08.48.33
Bildschirmfoto 2024-01-16 um 08.48.331688×2630 464 KB