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 …
Tag: MariaDB
Feb 10 2020
Vicidial error: 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 …
Feb 02 2020
FlexiSip installation and configuration on Debian 9
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 …
Feb 02 2020
Flexisip error Failed to find shared library for backend mysql
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
|
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:
|
1 2 3 4 5 6 |
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 |
Apr 17 2019
Asterisk crashes on res_odbc.so load
While loading res_odbc.so Asterisk crashes with “invalid pointer” error like in the backtrace below: Loading res_odbc.so.
Apr 03 2019
How to reset MySQL/MariaDB root password
Start session ssh (using root if possible). Edit my.cnf file using. sudo vi /etc/my.cnf Add line to [mysqld] block:
Jan 23 2018
Error Duplicate entry for key on query
On checking MySQL/MariaDB slave status we can see the following error:
|
1 2 3 4 |
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.
Jan 23 2018
Could not find target log during relay log initialization
While a setting up MariaDB slave I ran in the following issue: 180118 14:14:11 [ERROR] Failed to open the relay log ‘./-relay-bin’ (relay_log_pos 7654336) 071118 16:44:10 [ERROR] Could not find target log during relay log initialization 071118 16:44:10 [ERROR] Failed to initialize the master info structure
Jun 21 2016
MySQL show connections with MyTOP
MyTOP is an utility for tracking performance and connections to MySQL/MariDB servers. The interface is very similar to top utility. Further examples is performed in CentOS 6 x64 operating system. First of all we need to plug Epel repository:
|
1 2 |
wget http://mirror.omnilance.com/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh epel-release-6-8.noarch.rpm |
May 05 2016
MariaDB(MySQL) Master-Master Replication
I’m going to develop my cluster further and create MariaDB(MySQL) geo-cluster by enabling MariaDB(MySQL) Master-Master Replication. I’ve already deployed MariaDB cluster in the second datacenter (nodes 4, 5 and 6) and now I need to configure Master-Master replication between two MariaDB clusters. The replication will take place between node 1 (first datacenter, we will name …
- 1
- 2
Stay tuned! :)
Donate some Bitcoin to keep the website running Donate some Monero to keep the website running
Bitcoin
Monero
Donate to keep the website running
Donate to keep the website running
