【auto restart】zabbix-server Automatic restart every 8 hours

[coffee]

zabbix-server version:zabbix_server (Zabbix) 5.0.14
mysql version：mysql Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using EditLine wrapper



*** Error in `/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values]': free(): invalid pointer: 0x000055f4060cbe9d ***
======= Backtrace: =========
/lib64/libc.so.6(+0x81329)[0x7f7030ae9329]
/usr/lib64/mysql/libmysqlclient.so.18(free_root+0x46)[0x7f7033c59c36]
/usr/lib64/mysql/libmysqlclient.so.18(free_old_query+0x25)[0x7f7033c29995]
/usr/lib64/mysql/libmysqlclient.so.18(mysql_close+0x20)[0x7f7033c2ca40]
/usr/lib64/mysql/libmysqlclient.so.18(+0x41316)[0x7f7033c2f316]
/usr/lib64/mysql/libmysqlclient.so.18(cli_advanced_command+0x118)[0x7f7033c2f518]
/usr/lib64/mysql/libmysqlclient.so.18(mysql_send_query+0x31)[0x7f7033c2cb81]
/usr/lib64/mysql/libmysqlclient.so.18(mysql_real_query+0x11)[0x7f7033c2cba1]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](zbx_db_vexecute+0x154)[0x55f40597e055]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](+0x25e7c4)[0x55f40597d7c4]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](zbx_db_begin+0x7b)[0x55f40597dd58]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](+0x232957)[0x55f405951957]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](DBbegin+0x13)[0x55f4059519d2]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](+0x64006)[0x55f405783006]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](zbx_deactivate_item_host+0x18a)[0x55f4057838d1]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](+0x6805c)[0x55f40578705c]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](poller_thread+0x201)[0x55f40578789f]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](zbx_thread_start+0x37)[0x55f4058fa685]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](MAIN_ZABBIX_ENTRY+0xafb)[0x55f405768dc9]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](daemon_start+0x305)[0x55f4058eb122]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](main+0x312)[0x55f405768284]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f7030a8a555]
/usr/sbin/zabbix_server: poller \#140 [got 2 values in 31.367283 sec, getting values](+0x482b9)[0x55f4057672b9]
======= Memory map: ========
......
83728:20221014:042221.257 One child process died (PID:84238,exitcode/signal:6). Exiting ...
zabbix_server [83728]: Error waiting for process with PID 84238: [10] No child processes
83728:20221014:042221.956 syncing history data...
83728:20221014:042222.445 syncing history data... 100.000000%
83728:20221014:042222.445 syncing history data done
83728:20221014:042222.446 syncing trend data...

[cyber]

Could we see a little bit more of that log? Before that "Backtrace"... Maybe you have there something about "out of memory"? And "please increase ... configuration parameter" ?

[coffee]

Could we see a little bit more of that log? Before that "Backtrace"... Maybe you have there something about "out of memory"? And "please increase ... configuration parameter" ?

There are no more errors. They are all irrelevant errors

[coffee]

I can't solve it now, please help me

[Markku]

How about upgrading to the latest 5.0 version?

Markku

[Markku]

Or, actually, looks like the errors are database component related.

Markku

[coffee]

Or, actually, looks like the errors are database component related.

Markku

Thank you. I can see from the error message that it is related to the database, but there is no troubleshooting idea. It is already 5.0.14

[Markku]

It is already 5.0.14

That's like 1.5 years old: https://www.zabbix.com/release_notes

Markku

[coffee]

That's like 1.5 years old: https://www.zabbix.com/release_notes

Markku

It's very difficult. My team does not allow this upgrade,