FTP Mysql Server.
- Thread starter
- Thread Author
- #1
Oct 09 18:15:15 nixos systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:15:15
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:15:15 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:15:15 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:17:09 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 57310
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:15:15
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:15:15 nixos mysql-start[56226]: 2024-10-09 18:15:15 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:15:15 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:15:15 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:17:09 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 57310
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0
WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] WSREP: Node addr:
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Using liburing
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: End of log at LSN=88255
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: 128 rollback segments are active.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: log sequence number 88255; transaction id 120
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Buffer pool(s) load completed at 240119 18:17:09
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Server socket created on IP: '::'.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 18:17:09 nixos mysql-start[57310]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 18:17:09 nixos mysql-post-start[57432]: ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
Oct 09 18:17:09 nixos systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:17:09
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:17:10 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:17:10 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:27:29 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 60225
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] WSREP: Node addr:
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Using liburing
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: End of log at LSN=88255
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: 128 rollback segments are active.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: log sequence number 88255; transaction id 120
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Buffer pool(s) load completed at 240119 18:17:09
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] Server socket created on IP: '::'.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 18:17:09 nixos mysql-start[57310]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 18:17:09 nixos mysql-post-start[57432]: ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
Oct 09 18:17:09 nixos systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:17:09 nixos mysql-start[57310]: 2024-10-09 18:17:09 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:17:09
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:17:10 nixos mysql-start[57310]: 2024-10-09 18:17:10 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:17:10 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:17:10 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:27:29 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 60225
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0
WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] WSREP: Node addr:
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Using liburing
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: End of log at LSN=88255
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: 128 rollback segments are active.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: log sequence number 88255; transaction id 120
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Buffer pool(s) load completed at 240119 18:27:29
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Server socket created on IP: '::'.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 18:27:29 nixos mysql-start[60225]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 18:27:29 nixos mysql-post-start[60343]: ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
Oct 09 18:27:29 nixos mysql-post-start[60343]: pdns
Oct 09 18:27:29 nixos systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:27:29
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:27:30 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:27:30 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:29:35 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:29:35 nixos mysql-pre-start[61325]: chown: changing ownership of '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool': Read-only file system
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Couldn't set an owner to '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool'.
Oct 09 18:29:35 nixos mysql-pre-start[61266]: It must be root, the PAM authentication plugin doesn't work otherwise..
Oct 09 18:29:35 nixos mysql-pre-start[61327]: chown: changing ownership of '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir': Read-only file system
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Cannot change ownership of the '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir' directory
Oct 09 18:29:35 nixos mysql-pre-start[61266]: to the 'mysql' user. Check that you have the necessary permissions and try again.
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] WSREP: Node addr:
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Using liburing
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: End of log at LSN=88255
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: 128 rollback segments are active.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: log sequence number 88255; transaction id 120
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Buffer pool(s) load completed at 240119 18:27:29
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] Server socket created on IP: '::'.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 18:27:29 nixos mysql-start[60225]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 18:27:29 nixos mysql-post-start[60343]: ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
Oct 09 18:27:29 nixos mysql-post-start[60343]: pdns
Oct 09 18:27:29 nixos systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld (initiated by: unknown): Normal shutdown
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: FTS optimize thread exiting.
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Starting shutdown...
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Oct 09 18:27:29 nixos mysql-start[60225]: 2024-10-09 18:27:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 240119 18:27:29
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] InnoDB: Shutdown completed; log sequence number 88255; transaction id 121
Oct 09 18:27:30 nixos mysql-start[60225]: 2024-10-09 18:27:30 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: Shutdown complete
Oct 09 18:27:30 nixos systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 09 18:27:30 nixos systemd[1]: Failed to start MySQL Server.
Oct 09 18:29:35 nixos systemd[1]: Starting MySQL Server...
Oct 09 18:29:35 nixos mysql-pre-start[61325]: chown: changing ownership of '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool': Read-only file system
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Couldn't set an owner to '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool'.
Oct 09 18:29:35 nixos mysql-pre-start[61266]: It must be root, the PAM authentication plugin doesn't work otherwise..
Oct 09 18:29:35 nixos mysql-pre-start[61327]: chown: changing ownership of '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir': Read-only file system
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Cannot change ownership of the '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/lib/mysql/plugin/auth_pam_tool_dir' directory
Oct 09 18:29:35 nixos mysql-pre-start[61266]: to the 'mysql' user. Check that you have the necessary permissions and try again.
Oct 09 18:29:35 nixos mysql-pre-start[61266]: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
Oct 09 18:29:35 nixos mysql-pre-start[61335]: 2024-10-09 18:29:35 0
WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: OK
Oct 09 18:29:37 nixos mysql-pre-start[61266]: To start mariadbd at boot time you have to copy
Oct 09 18:29:37 nixos mysql-pre-start[61266]: support-files/mariadb.service to the right place for your system
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Two all-privilege accounts were created.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: One is root@localhost, it has no password, but you need to
Oct 09 18:29:37 nixos mysql-pre-start[61266]: be system 'root' user to connect. Use, for example, sudo mysql
Oct 09 18:29:37 nixos mysql-pre-start[61266]: The second is mysql@localhost, it has no password either, but
Oct 09 18:29:37 nixos mysql-pre-start[61266]: you need to be the system 'mysql' user to connect.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: After connecting you can set the password, if you would need to be
Oct 09 18:29:37 nixos mysql-pre-start[61266]: able to connect as any of these users with a password and without sudo
Oct 09 18:29:37 nixos mysql-pre-start[61266]: See the MariaDB Knowledgebase at You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You can start the MariaDB daemon with:
Oct 09 18:29:37 nixos mysql-pre-start[61266]: cd '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6' ; /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mariadb-safe --datadir='/var/lib/mysql'
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You can test the MariaDB daemon with mysql-test-run.pl
Oct 09 18:29:37 nixos mysql-pre-start[61266]: cd '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/OFF' ; perl mariadb-test-run.pl
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Please report any problems at You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: The latest information about MariaDB is available at You must be logged in to see this link..
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Consider joining MariaDB's strong and vibrant community:
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 61433
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
Oct 09 18:29:37 nixos mysql-pre-start[61266]: OK
Oct 09 18:29:37 nixos mysql-pre-start[61266]: To start mariadbd at boot time you have to copy
Oct 09 18:29:37 nixos mysql-pre-start[61266]: support-files/mariadb.service to the right place for your system
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Two all-privilege accounts were created.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: One is root@localhost, it has no password, but you need to
Oct 09 18:29:37 nixos mysql-pre-start[61266]: be system 'root' user to connect. Use, for example, sudo mysql
Oct 09 18:29:37 nixos mysql-pre-start[61266]: The second is mysql@localhost, it has no password either, but
Oct 09 18:29:37 nixos mysql-pre-start[61266]: you need to be the system 'mysql' user to connect.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: After connecting you can set the password, if you would need to be
Oct 09 18:29:37 nixos mysql-pre-start[61266]: able to connect as any of these users with a password and without sudo
Oct 09 18:29:37 nixos mysql-pre-start[61266]: See the MariaDB Knowledgebase at You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You can start the MariaDB daemon with:
Oct 09 18:29:37 nixos mysql-pre-start[61266]: cd '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6' ; /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mariadb-safe --datadir='/var/lib/mysql'
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You can test the MariaDB daemon with mysql-test-run.pl
Oct 09 18:29:37 nixos mysql-pre-start[61266]: cd '/nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/OFF' ; perl mariadb-test-run.pl
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Please report any problems at You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-pre-start[61266]: The latest information about MariaDB is available at You must be logged in to see this link..
Oct 09 18:29:37 nixos mysql-pre-start[61266]: Consider joining MariaDB's strong and vibrant community:
Oct 09 18:29:37 nixos mysql-pre-start[61266]: You must be logged in to see this link.
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 61433
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0
WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] WSREP: Node addr:
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Using liburing
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] Server socket created on IP: '::'.
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 19:12:53 nixos mysql-start[67369]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 19:12:53 nixos mysql-post-start[67381]: Creating initial database: pdns
Oct 09 19:12:53 nixos systemd[1]: Started
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] WSREP: Node addr:
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Compressed tables use zlib 1.3
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Number of transaction pools: 1
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Using liburing
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Oct 09 18:29:37 nixos mysql-start[61433]: 2024-10-09 18:29:37 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] Server socket created on IP: '0.0.0.0'.
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] Server socket created on IP: '::'.
Oct 09 19:12:53 nixos mysql-start[67369]: 2024-10-09 19:12:53 0 [Note] /nix/store/92i38gv0fl2ri98ih9avy4pynspk7r33-mariadb-server-10.11.6/bin/mysqld: ready for connections.
Oct 09 19:12:53 nixos mysql-start[67369]: Version: '10.11.6-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Oct 09 19:12:53 nixos mysql-post-start[67381]: Creating initial database: pdns
Oct 09 19:12:53 nixos systemd[1]: Started