main trouble that in old mysql/mariadb versions (ie mariadb 5.x),
db was broken long ago..
On older versions, we have not checked the correctness of the database update for a long time.
Than why now we notice about minimum required versions.
Anyway, if you use rolling train of observium, please update to latest revision
and make db schema export as:
cd /opt/observium
svn up
./test_db.php -e > db.json
and send me file db.json (here only db structure, no any data).
I will check how we can fix your db.
P.S. If after update you not found test_db.php file - than you used stable branch and need switch to rolling:
https://docs.observium.org/updating/#switch-between-rolling-and-stable-trains
Edvinas Kairys via observium wrote on 08.01.2021 00:57:
thanks anyway,also, coul you advice what could be 'wrong' if im still after MariaDB update getting these:[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3' AND (`remote_device_id` IS NULL OR `remote_device_id` != '348')
[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3'
[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3' AND (`remote_device_id` IS NULL OR `remote_device_id` != '348')?ThanksOn Thu, Jan 7, 2021 at 11:36 PM Adam Armstrong via observium <observium@observium.org> wrote:_______________________________________________In this case I have no idea. :)Adam.Sent from BlueMailOn 7 Jan 2021, at 21:06, Edvinas Kairys via observium <observium@observium.org> wrote:thanks,I see that just two tables are on MyISAM. And that ones are Wifi related which i think is not important, because the main devices is not associated with wifiinfra [root@observ001i tmp]# mysqlshow --status observium -p | grep -v InnoDB
Enter password:
Database: observium
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+
| wifi_accesspoints | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 | | utf8_unicode_ci | | | | 1125899906841600 | N |
| wifi_sessions | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 | utf8_unicode_ci | | | | 1125899906841600 | N |
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+On Thu, Jan 7, 2021 at 7:01 PM Adam Armstrong via observium <observium@observium.org> wrote:_______________________________________________If you have any myisam tables, switch them to innodb.
I had this happen on a non-observium database at some point during an upgrade.
Adam.
From: observium <observium-bounces@observium.org> On Behalf Of Edvinas Kairys via observium
Sent: 07 January 2021 15:13
To: Observium <observium@observium.org>
Cc: Edvinas Kairys <edvinas.email@gmail.com>
Subject: [Observium] mysql poller times increased 2x after Maria DB upgrade from 5.x to 10.3
hello,
Mysql poller times increased 2x after Maria DB upgrade from 5.x to 10.3
I dont know if this is supposed to be or not ? dunno if i 'feel' any slowness, but i want to ask for your info.
Thanks for any input
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium