assembled-prejudice1822

Hi, another full crash Shutdown by "appdata backup" addon Any solution to avoid this please ? Thank you ! 2024-09-23T03:01:06.395201Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 9.0.1). 2024-09-23T03:01:07.211793Z 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2024-09-23T03:01:07.211992Z 0 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2024-09-23T03:01:07.212074Z 0 [ERROR] [MY-012646] [InnoDB] File ./#innodb_redo/#ib_redo9: 'rename' returned OS error 71. 2024-09-23T03:01:07.212099Z 0 [ERROR] [MY-013905] [InnoDB] Failed to mark redo log file ./#innodb_redo/#ib_redo9 as unused (by renaming to ./#innodb_redo/#ib_redo9_tmp). 2024-09-23T03:01:07.778349Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.1) MySQL Community Server - GPL. 2024-09-23T03:01:07.778449Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2024-09-23T03:01:12.200040Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-09-23T03:01:12.405024Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.1) starting as process 1 2024-09-23T03:01:12.407165Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root 2024-09-23T03:01:12.408890Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1723ed64-7958-11ef-857c-0242ac110007. 2024-09-23T03:01:12.419828Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-09-23T03:01:13.070397Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-09-23T03:01:13.265804Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 1, name 'sys/sys_config', file './sys/sys_config.ibd' is missing! mysqld: File './binlog.000001' not found (OS errno 2 - No such file or directory) 2024-09-23T03:01:13.536061Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 2024-09-23T03:01:14.466988Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-09-23T03:01:14.467031Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-09-23T03:01:14.734596Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-09-23T03:01:14.769901Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2024-09-23T03:01:14.770099Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.0.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL. 2024-09-24T03:01:06.198187Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 9.0.1). 2024-09-24T03:01:07.660186Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.1) MySQL Community Server - GPL. 2024-09-24T03:01:07.660242Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2024-09-24T03:01:13.185240Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2024-09-24T03:01:13.186906Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 41 2024-09-24T03:01:13.188804Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2024-09-24T03:01:13.188838Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it. 2024-09-24T03:01:13.188908Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-09-24T03:01:13.189399Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

2024-09-22T15:38:54.375857Z 0 [ERROR] [MY-013901] [InnoDB] Failed to resize unused redo log file ./#innodb_redo/#ib_redo17_tmp to 3 MB (Failed to find the file). 2024-09-22T15:38:54.406680Z 0 [ERROR] [MY-012891] [InnoDB] Failed to create redo log file ./#innodb_redo/#ib_redo17 (error: 1504) for start LSN 55678976 2024-09-22T15:38:54.406786Z 0 [ERROR] [MY-013864] [InnoDB] [FATAL] Error 1504 encountered when writing to the redo log file: ./#innodb_redo/#ib_redo16. 2024-09-22T15:38:54.406818Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: log0write.cc:2110:ib::fatal triggered thread 22772013979200 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/9.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2024-09-22T15:38:54Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=28011a04ecffb589c6a1d0499f9e5eae6c552217 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 = 0 thread_stack 0x100000 #0 0xc5625e <unknown> #1 0x16840ed <unknown> #2 0x18393fc <unknown> #3 0x1851854 <unknown> #4 0x177ed14 <unknown> #5 0x1789129 <unknown> #6 0x178a467 <unknown> #7 0x17790e8 <unknown> #8 0x14b61b0dbad3 <unknown> #9 0x14b61ac89c11 <unknown> #10 0x14b61ad0df53 <unknown> #11 0xffffffffffffffff <unknown> The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2024-09-22T15:38:58.650451Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2024-09-22T15:38:58.652105Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 41 2024-09-22T15:38:58.653975Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2024-09-22T15:38:58.654009Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it. 2024-09-22T15:38:58.654197Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-09-22T15:38:58.654611Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. 2024-09-22T15:38:59.702866Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2024-09-22T15:38:59.704693Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 41 2024-09-22T15:38:59.706570Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2024-09-22T15:38:59.706604Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it. 2024-09-22T15:38:59.706718Z 0 [ERROR] [MY-010119] [Server] Aborting Hello everyone, my MySQL Docker container just crashed after several poorly formatted INSERT INTO queries. I can't restart it anymore, the console and logs open and close instantly. I saw errors in the logs. Of course, I didn't have time to make a backup... Then I made a mistake, I restarted the setup of this addon, which erased all the files, so I really lost everything. I saw that the memory was limited to 2GB during installation, could it be due to that? Thank you !

Hi, Sorry, I was tired last night 😴 I updated my variables in Grafana docker and now it works. Sincerely.

Hello, How to setup Grafana (docker in Unraid) after I have installed this docker ? Thank you ! Franck