Tag: mysql

Feb 08 2024

MariaDB fails to start: Aria engine is not enabled or did not start

Filed under Fixes, Simple about IT

After low space condition once happened on a server MariaDB failed to start with :

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
[ERROR] Aborting
...
mariadb.service: main process exited, code=exited, status=1/FAILURE
Failed to start MariaDB 10.3.32 database server.

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[ERROR] Aborting

...

mariadb.service: main process exited, code=exited, status=1/FAILURE

Failed to start MariaDB 10.3.32 database server.

In /var/log/messages:

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ;

[ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'"

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[Note] mysqld: Aria engine: starting recovery

recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ;

[ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'"

error, MariaDB, mysql
Leave comment

Feb 02 2024

Clean and reduce size of Zabbix database

Filed under Fixes, Simple about IT

After some time you may find that you Zabbix database become enormously big and consumes significant amount of disk space. Among really usefull data there is data that may be cleaned up and optimized in Zabbix database in order to reduce size of Zabbix database.

MariaDB, mysql, Zabbix
Leave comment

Aug 31 2022

mysqldump directly to another server, mysqldump redirect to scp

Filed under Linux

It’s not a big deal to perform mysqldump command, get your database as a file and transfer MySQL database to another server by moving the file to another server and import it, But what if there is no enough space on a disk to store the dump file? In this case it would be great …

Feb 07 2022

mysql_secure_installation: command not found

Filed under Fixes, Linux

You have just installed MariaDB and as usual want to perform initial configuration by running mysql_secure_installation script but the error is: mariadb_secure_installation: command not found For MariaDB set ups you should use the following:

Jul 05 2021

How to Enable the Slow Query Log in MySQL/MariaDB

Filed under Simple about IT

Enabling the Slow Query Log for MySQL or MariaDB can be a useful tool to diagnose performance and efficiency issues affecting your server such as MySQL high CPU load. By identifying queries that are particularly slow in their execution, you can address them by restructuring the application that triggers your queries. You can also rebuild …

Feb 10 2020

Vicidial backup and restore guide

Filed under Fixes, Linux, Simple about IT, VoIP

Suppose you need to migrate or duplicate Vicidial data (campaigns, leads, phones and so on) from one Vicibox server to another. In case two Vicidial boxes of the same versions the process will be simpler. In case the source server has older Vicibox version than the destination one you will have to perform additional steps …

Asterisk, backup, error, mysql, mysqldump, Vicibox, Vicidial
Leave comment

Feb 02 2020

Flexisip error Failed to find shared library for backend mysql

Filed under Fixes, Linux, VoIP

I installed Flexisip using official documentation , installed additional components like MariaDB (MySQL) and Redis, performed initial setup of configuration files, created database and DB user. I started flexisip services with

systemctl start flexisip-proxy flexisip-presence flexisip-conference

1	systemctl start flexisip-proxy flexisip-presence flexisip-conference

and by looking in /var/opt/belledonne-communications/log/flexisip/flexisip-conference.log I noticed the following error:

2020-02-02 03:12:30:790 liblinphone-message-Linphone core [0x56197d8a7d60] notified [global_state_changed]
2020-02-02 03:12:30:790 liblinphone-message-No charset defined forcing utf8 4 bytes specially for conference subjet storage
2020-02-02 03:12:30:790 liblinphone-message-Opening linphone database db=xxx user=xxx password='xxx' host=127.0.0.1 charset=utf8mb4 with backend Mysql
2020-02-02 03:12:30:791 liblinphone-warning-Unable to build db session with uri: Failed to find shared library for backend mysql
2020-02-02 03:12:30:791 liblinphone-error-Unable to open linphone database with uri db=xxx user=xxx password='xxx!' host=127.0.0.1 charset=utf8mb4 and backend Mysql
2020-02-02 03:12:30:791 bctbx-error-Linphone Core couldn't start because the connection to the database has failed

2020-02-02 03:12:30:790 liblinphone-message-Linphone core [0x56197d8a7d60] notified [global_state_changed]

2020-02-02 03:12:30:790 liblinphone-message-No charset defined forcing utf8 4 bytes specially for conference subjet storage

2020-02-02 03:12:30:790 liblinphone-message-Opening linphone database db=xxx user=xxx password='xxx' host=127.0.0.1 charset=utf8mb4 with backend Mysql

2020-02-02 03:12:30:791 liblinphone-warning-Unable to build db session with uri: Failed to find shared library for backend mysql

2020-02-02 03:12:30:791 liblinphone-error-Unable to open linphone database with uri db=xxx user=xxx password='xxx!' host=127.0.0.1 charset=utf8mb4 and backend Mysql

2020-02-02 03:12:30:791 bctbx-error-Linphone Core couldn't start because the connection to the database has failed

error, fix, Flexisip, MariaDB, mysql, Redis
Leave comment

Apr 17 2019

Asterisk crashes on res_odbc.so load

Filed under Asterisk, Fixes

While loading res_odbc.so Asterisk crashes with “invalid pointer” error like in the backtrace below: Loading res_odbc.so.

Asterisk, driver, error, MariaDB, mysql
Leave comment

Apr 03 2019

How to reset MySQL/MariaDB root password

Filed under Simple about IT

Start session ssh (using root if possible). Edit my.cnf file using. sudo vi /etc/my.cnf Add line to [mysqld] block:

MariaDB, mysql, password, reset, root
Leave comment

Jan 23 2018

Error Duplicate entry for key on query

Filed under Fixes

On checking MySQL/MariaDB slave status we can see the following error:

mysql> SHOW SLAVE STATUS\G
...
Last_SQL_Errno: 1062
Last_SQL_Error: Error 'Duplicate entry '146474' for key 'PRIMARY'' on query. Default database: 'db'. Query: 'INSERT INTO `options` (`name`, `value, autoload`) VALUES ('enable', 'true', 'true')'

mysql> SHOW SLAVE STATUS\G

...

Last_SQL_Errno: 1062

Last_SQL_Error: Error 'Duplicate entry '146474' for key 'PRIMARY'' on query. Default database: 'db'. Query: 'INSERT INTO `options` (`name`, `value, autoload`) VALUES ('enable', 'true', 'true')'

There are a few ways how to treat such kind of errors.

error, MariaDB, mysql
Leave comment