Tag: MariaDB

Feb 19 2022

MariaDB error InnoDB: Upgrade after a crash is not supported

Filed under Fixes, Simple about IT

Here is a crash I experienced while upgrading MariaDB from 10.4 to 10.5

● mariadb.service - MariaDB 10.5.5 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Sun 2020-09-27 14:57:13 CEST; 12min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 194683 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.12.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [Note] InnoDB: Starting shutdown...
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' init function returned error.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Aborting
sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Failed with result 'exit-code'.
sept. 27 14:57:13 massine-pc systemd[1]: Failed to start MariaDB 10.5.5 database server.

● mariadb.service - MariaDB 10.5.5 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)

Active: failed (Result: exit-code) since Sun 2020-09-27 14:57:13 CEST; 12min ago

Docs: man:mariadbd(8)

https://mariadb.com/kb/en/library/systemd/

Main PID: 194683 (code=exited, status=1/FAILURE)

Status: "MariaDB server is down"

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.12.

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [Note] InnoDB: Starting shutdown...

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' init function returned error.

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Aborting

sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Failed with result 'exit-code'.

sept. 27 14:57:13 massine-pc systemd[1]: Failed to start MariaDB 10.5.5 database server.

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 error: Code Expects Different Schema

Filed under Fixes, Simple about IT, VoIP

Vicidial-warning-code-expects-different-schema

After database dump restoration taken from older Vicibox to the latest Vicibox 9.0.1 I got the following error in Admin -> System Settings section: WARNING: Code expects different schema: 1585 It’s not possible to change or save any setting. The reason is obvious: Vicibox 9 has new and altered tables and functions so you will …

error, MariaDB, Vicibox, Vicidial
Leave comment

Feb 02 2020

FlexiSip installation and configuration on Debian 9

Filed under Linux, VoIP

Flexisip is a complete, modular and scalable SIP server suite written in C++11, comprising proxy, presence and group chat functions. Flexisip offers an easy-to-install SIP server solution, offering all the features required to deploy your own SIP service tuned for mobile or desktop applications, “out of the box”. Flexisip can be integrated into your SIP …

Debian, Flexisip, MariaDB, Redis, VoIP
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