ByEzel Hello, even though I've been waiting for hours, it says Loading and stays. I can't install mariadb. System:Ubuntu 20.04.6 LTS x86_64(Py3.7.9)
ByEzel I uninstalled and reinstalled mariadb. now i am getting the following error while trying to stop mariadb 2023-07-21 15:36:51 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control' 2023-07-21 15:36:51 0 [ERROR] Plugin 'Aria' init function returned error. 2023-07-21 15:36:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2023-07-21 15:36:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-07-21 15:36:51 0 [Note] InnoDB: Number of transaction pools: 1 2023-07-21 15:36:51 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-07-21 15:36:51 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2023-07-21 15:36:51 0 [Note] InnoDB: Completed initialization of buffer pool 2023-07-21 15:36:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42401,42401 2023-07-21 15:36:51 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42401 between the checkpoint 42401 and the end 42513. 2023-07-21 15:36:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-07-21 15:36:51 0 [Note] InnoDB: Starting shutdown... 2023-07-21 15:36:51 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-07-21 15:36:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-07-21 15:36:51 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-07-21 15:36:51 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded 2023-07-21 15:36:51 0 [ERROR] Failed to initialize plugins. 2023-07-21 15:36:51 0 [ERROR] Aborting 230721 15:36:51 mysqld_safe mysqld from pid file /www/server/data/teknowater.co.pid ended
aaPanel_Kern Hello, it is recommended to use mysql, mariaDB has compatibility issues, if the installation is not successful, it cannot be used. ByEzel
ByEzel aaPanel_Kern I have installed mysql 8.0. I also get this error when restarting. 2023-07-22T09:13:00.658278Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2023-07-22T09:13:00.658372Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2023-07-22T09:13:00.658494Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 86001 2023-07-22T09:13:00.692107Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-22T09:13:00.928399Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-07-22T09:13:01.041530Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock 2023-07-22T09:13:01.099400Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-07-22T09:13:01.099604Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-07-22T09:13:01.100947Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use 2023-07-22T09:13:01.101112Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ? 2023-07-22T09:13:01.101486Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-22T09:13:02.075837Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.
ByEzel aaPanel_Kern dude i need to solve this problem quickly, can you please tell me what should i do for solution 🙂
aaPanel_Kern Hello, the log shows that the mysql port is used, please check whether your port is used repeatedly netstat -tulnp|grep 3306 ByEzel
ByEzel this is root@teknowater:~# netstat -tulnp|grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 26654/mariadbd tcp6 0 0 :::3306 :::* LISTEN 26654/mariadbd aaPanel_Kern
aaPanel_Kern Hello, it is caused by the built-in mariaDB in your system, it is recommended to restart mysql after deleting ByEzel
omarsleem I have faced a lot of problem to just install mariadb. the best solution i see is to install mariadb manually and add it as remote db in aaPanel (use 127.0.0.1 not localhost) and it works perfectly.
