Questions tagged with MariaDB

Content language: English

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

Errors Launching MariaDB on Lightsale

Hello, I recently launched a new Lightsale instance and the first thing I wanted to do is launch MariaDB. I ran the below command, which I found in AWS help docs: sudo /opt/bitnami/mariadb/bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --init-file=/tmp/mysql-init 2> /dev/null & But the process dies almost immediately. Here is the associated errors from mysqld.log: 220914 16:02:15 mysqld_safe Starting mariadbd daemon with databases from /opt/bitnami/mariadb/data 2022-09-14 16:02:15 0 [Note] /opt/bitnami/mariadb/sbin/mariadbd (server 10.6.7-MariaDB) starting as process 17091 ... 2022-09-14 16:02:15 0 [ERROR] mariadbd: Can't lock aria control file '/opt/bitna mi/mariadb/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2022-09-14 16:02:45 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 '/opt/bitnami/mariadb/data/aria_log_control' 2022-09-14 16:02:45 0 [ERROR] Plugin 'Aria' init function returned error. 2022-09-14 16:02:45 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2022-09-14 16:02:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-09-14 16:02:45 0 [Note] InnoDB: Number of pools: 1 2022-09-14 16:02:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-09-14 16:02:45 0 [Note] InnoDB: Using Linux native AIO 2022-09-14 16:02:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16777216, chunk size = 16777216 2022-09-14 16:02:45 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-14 16:02:45 0 [Note] InnoDB: 128 rollback segments are active. 2022-09-14 16:02:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-14 16:02:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-14 16:02:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-14 16:02:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-14 16:02:45 0 [Note] InnoDB: 10.6.7 started; log sequence number 42437; transaction id 14 2022-09-14 16:02:45 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-09-14 16:02:45 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded 2022-09-14 16:02:45 0 [ERROR] Failed to initialize plugins. 2022-09-14 16:02:45 0 [ERROR] Aborting 220914 16:02:45 mysqld_safe mysqld from pid file /opt/bitnami/mariadb/tmp/mysqld.pid ended The my.cnf is pretty basic: [mysqladmin] user= [mysqld] skip_name_resolve explicit_defaults_for_timestamp basedir=/opt/bitnami/mariadb port=3306 tmpdir=/opt/bitnami/mariadb/tmp socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid max_allowed_packet=16M bind_address=127.0.0.1 log_error=/opt/bitnami/mariadb/logs/mysqld.log slow_query_log=0 slow_query_log_file=/opt/bitnami/mariadb/logs/mysqld.log long_query_time=10.0 character_set_server=utf8 collation_server=utf8_general_ci plugin_dir=/opt/bitnami/mariadb/lib/plugin [client] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid !include /opt/bitnami/mariadb/conf/bitnami/my_custom.cnf !include /opt/bitnami/mariadb/conf/bitnami/memory.conf I have made no changes to anything, other than creating /tmp/mysql.init as described on another AWS kb article, but all that does is change the root password for MariaDB. Can anyone help me figure this out?
1
answers
0
votes
41
views
Gary
asked 3 months ago
1
answers
0
votes
40
views
profile picture
RNHurt
asked 4 months ago