mariadb error

farihkhoirulhuda

why mariadb often quit alone? instead using ordinary mysql it runs smoothly. can you fix it?

aaPanel_Kern

farihkhoirulhuda
Hi, is it fixed? mariadb must be run as a normal user

farihkhoirulhuda

logs :
220327 01:35:37 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-03-27 1:35:37 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-03-27 1:35:37 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 182217 ...
2022-03-27 1:35:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-27 1:35:37 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-27 1:35:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-27 1:35:37 0 [Note] InnoDB: Using Linux native AIO
2022-03-27 1:35:37 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-03-27 1:35:37 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-27 1:35:37 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-27 1:35:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-27 1:35:37 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-27 1:35:37 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-03-27 1:35:37 0 [Note] InnoDB: 10.7.3 started; log sequence number 41367; transaction id 14
2022-03-27 1:35:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-27 1:35:37 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-03-27 1:35:37 0 [Note] InnoDB: Buffer pool(s) load completed at 220327 1:35:37
2022-03-27 1:35:37 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-03-27 1:35:37 0 [Note] Server socket created on IP: '::'.
2022-03-27 1:35:37 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2022-03-27 1:35:49 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2022-03-27 1:35:49 0 [Note] InnoDB: FTS optimize thread exiting.
2022-03-27 1:35:49 0 [Note] InnoDB: Starting shutdown...
2022-03-27 1:35:49 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2022-03-27 1:35:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 220327 1:35:49
2022-03-27 1:35:49 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2022-03-27 1:35:49 0 [Note] InnoDB: Shutdown completed; log sequence number 42341; transaction id 15
2022-03-27 1:35:49 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

220327 01:35:49 mysqld_safe mysqld from pid file /www/server/data/farih.pid ended
220327 01:35:51 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-03-27 1:35:51 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-03-27 1:35:51 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 182990 ...
2022-03-27 1:35:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-27 1:35:51 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-27 1:35:51 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-27 1:35:51 0 [Note] InnoDB: Using Linux native AIO
2022-03-27 1:35:51 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-03-27 1:35:51 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-27 1:35:51 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-27 1:35:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-27 1:35:51 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-27 1:35:51 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-03-27 1:35:51 0 [Note] InnoDB: 10.7.3 started; log sequence number 42341; transaction id 14
2022-03-27 1:35:51 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-03-27 1:35:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-27 1:35:51 0 [Note] InnoDB: Buffer pool(s) load completed at 220327 1:35:51
2022-03-27 1:35:51 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-03-27 1:35:51 0 [Note] Server socket created on IP: '::'.
2022-03-27 1:35:51 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
220327 01:35:59 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-03-27 1:35:59 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-03-27 1:35:59 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 183483 ...
2022-03-27 1:35:59 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
220327 01:36:01 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-03-27 1:36:01 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-03-27 1:36:01 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 183997 ...
2022-03-27 1:36:02 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-03-27 1:36:29 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'
2022-03-27 1:36:29 0 [ERROR] Plugin 'Aria' init function returned error.
2022-03-27 1:36:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-03-27 1:36:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-27 1:36:29 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-27 1:36:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-27 1:36:29 0 [Note] InnoDB: Using Linux native AIO
2022-03-27 1:36:29 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-03-27 1:36:29 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-27 1:36:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42341,42341
2022-03-27 1:36:29 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-27 1:36:29 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2022-03-27 1:36:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-27 1:36:29 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-27 1:36:29 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-03-27 1:36:29 0 [Note] InnoDB: 10.7.3 started; log sequence number 42353; transaction id 14
2022-03-27 1:36:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-27 1:36:29 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-03-27 1:36:29 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2022-03-27 1:36:29 0 [ERROR] Failed to initialize plugins.
2022-03-27 1:36:29 0 [ERROR] Aborting
2022-03-27 1:36:32 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'
2022-03-27 1:36:32 0 [ERROR] Plugin 'Aria' init function returned error.
2022-03-27 1:36:32 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-03-27 1:36:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-27 1:36:32 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-27 1:36:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-27 1:36:32 0 [Note] InnoDB: Using Linux native AIO
2022-03-27 1:36:32 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-03-27 1:36:32 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-27 1:36:32 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-27 1:36:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-27 1:36:32 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-27 1:36:32 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-03-27 1:36:32 0 [Note] InnoDB: 10.7.3 started; log sequence number 42365; transaction id 14
2022-03-27 1:36:32 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-03-27 1:36:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-27 1:36:32 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2022-03-27 1:36:32 0 [ERROR] Failed to initialize plugins.
2022-03-27 1:36:32 0 [ERROR] Aborting
220327 01:36:32 mysqld_safe mysqld from pid file /www/server/data/farih.pid ended
2022-03-27 2:29:22 11 [Warning] Access denied for user 'farih_db'@'localhost'
2022-03-27 2:31:29 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-03-27 2:31:29 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-03-27 2:31:29 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-03-27 2:33:03 57 [Warning] Access denied for user 'farih_db'@'localhost' (using password: YES)

farihkhoirulhuda

I know how to fix it is to uninstall it. but the database is very important. I tried to backup can't because of mysql error.

I tried to change mysql via switch also can't.

please help.

idflorin

farihkhoirulhuda I think is from Aria engine.
Try this:

download
delete the 2 files aria ....
restart maria db

farihkhoirulhuda

I have deleted the two files. but still not able to run.

aaPanel_Kern

farihkhoirulhuda
Hi, can you paste your configuration file.

farihkhoirulhuda

aaPanel_Kern i'm very difficult and i'm also new to aapanel. can you send me an email and i send my aapanel account? and you configure.

aaPanel_Kern

farihkhoirulhuda
Hello, my email is: kern@aapanel.com.

farihkhoirulhuda

aaPanel_Kern OK, I've sent an email.

please check your email. if not, please check the spam folder.

farihkhoirulhuda

aaPanel_Kern hello, good news my mysql is up and running. I tried uninstalling manually.

aaPanel_Kern

farihkhoirulhuda
Hello, yes I saw your message and said okay.