Hi,
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-train...
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 http://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 http://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 http://ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3' AND (`remote_device_id` IS NULL OR `remote_device_id` != '348')
?
Thanks
On Thu, Jan 7, 2021 at 11:36 PM Adam Armstrong via observium <observium@observium.org mailto:observium@observium.org> wrote:
In this case I have no idea. :) Adam. Sent from BlueMail <http://www.bluemail.me/r?b=16361> On 7 Jan 2021, at 21:06, Edvinas Kairys via observium <observium@observium.org <mailto: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 wifi infra [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 <mailto: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 <mailto:observium-bounces@observium.org>> *On Behalf Of *Edvinas Kairys via observium *Sent:* 07 January 2021 15:13 *To:* Observium <observium@observium.org <mailto:observium@observium.org>> *Cc:* Edvinas Kairys <edvinas.email@gmail.com <mailto: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 <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ------------------------------------------------------------------------ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org <mailto: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