Ad Widget

Collapse

Mysql server crashing

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • galavichid
    Member
    • Mar 2021
    • 43
    #1

    Mysql server crashing

    Hi,

    I have 2x environments with Zabbix 7.4 + MySQL running on Ubuntu 24.04.
    Since the installation I have an issue on both of the server which causing the MySQL server to not reload.
    It seems to happen every end of the month, so I have looked for some jobs which might causing the issue, and try to investigate a lot and change different settings but it still happens.
    I am wondering if someone have better idea which I couldn't think of or any AI chatbot.

    Thank you
    Gal
    Tags: None
    • Jaceqp
      Junior Member
      • Mar 2026
      • 14
      #2
      I think it'd be much easier if posted some mysql/system logs while crash occurs. What was the instalation procedure? By the book or some custom tweaks on the way...

        Comment

        • hrrapozo
          Junior Member
          • Nov 2025
          • 10
          #3
          Just wondering is Zabbix the only application using MySQL on your systems?

            Comment

            • galavichid
              Member
              • Mar 2021
              • 43
              #4
              Here is some info:

              ● zabbix-server.service - Zabbix Server
              Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; preset: enabled)
              Active: deactivating (stop-sigterm) since Wed 2026-01-28 06:01:57 UTC; 2 months 7 days ago
              Process: 959154 ExecStop=/bin/sh -c [ -n "$1" ] && kill -s TERM "$1" -- $MAINPID (code=exited, status=0/SUCCESS)
              Main PID: 909470 (zabbix_server)
              Tasks: 167 (limit: 9207)
              Memory: 349.9M (peak: 395.8M)
              CPU: 1h 11min 25.768s
              CGroup: /system.slice/zabbix-server.service
              ├─909470 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
              ├─909471 "/usr/sbin/zabbix_server: ha manager"
              ├─909472 "/usr/sbin/zabbix_server: service manager #1 [processed 0 events, updated 0 event tags, deleted 0 problems, synced 0 service updates, idle 5.042051 sec during 5.042094 sec]"
              ├─909473 "/usr/sbin/zabbix_server: configuration syncer #1 [terminated]"
              ├─909487 "/usr/sbin/zabbix_server: alert manager #1 [terminated]"
              ├─909488 "/usr/sbin/zabbix_server: alerter #1 started"
              ├─909490 "/usr/sbin/zabbix_server: alerter #2 started"
              ├─909491 "/usr/sbin/zabbix_server: alerter #3 started"
              ├─909494 "/usr/sbin/zabbix_server: lld manager #1 [terminated]"
              ├─909498 "/usr/sbin/zabbix_server: lld worker #1 [processed 17 LLD rules, idle 340.103836 sec during 340.360403 sec]"
              ├─909499 "/usr/sbin/zabbix_server: lld worker #2 [processed 1 LLD rules, idle 1028.004559 sec during 1028.029082 sec]"
              ├─909500 "/usr/sbin/zabbix_server: housekeeper #1 [terminated]"
              ├─909501 "/usr/sbin/zabbix_server: timer #1 [terminated]"
              ├─909503 "/usr/sbin/zabbix_server: http poller #1 [terminated]"
              ├─909504 "/usr/sbin/zabbix_server: browser poller #1 [terminated]"
              ├─909506 "/usr/sbin/zabbix_server: history syncer #1 [processed 2 values, 1+0 triggers in 0.002337 (0.002,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909507 "/usr/sbin/zabbix_server: history syncer #2 [processed 0 values, 0+0 triggers in 0.000013 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909514 "/usr/sbin/zabbix_server: history syncer #3 [processed 0 values, 0+0 triggers in 0.000016 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909515 "/usr/sbin/zabbix_server: history syncer #4 [processed 0 values, 0+0 triggers in 0.000009 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909516 "/usr/sbin/zabbix_server: escalator #1 [terminated]"
              ├─909517 "/usr/sbin/zabbix_server: proxy poller #1 [terminated]"
              ├─909518 "/usr/sbin/zabbix_server: self-monitoring #1 [terminated]"
              ├─909522 "/usr/sbin/zabbix_server: vmware collector #1 [terminated]"
              ├─909523 "/usr/sbin/zabbix_server: vmware collector #2 [terminated]"
              ├─909524 "/usr/sbin/zabbix_server: vmware collector #3 [terminated]"
              ├─909525 "/usr/sbin/zabbix_server: vmware collector #4 [terminated]"
              ├─909527 "/usr/sbin/zabbix_server: vmware collector #5 [terminated]"
              ├─909528 "/usr/sbin/zabbix_server: vmware collector #6 [terminated]"
              ├─909529 "/usr/sbin/zabbix_server: vmware collector #7 [terminated]"
              ├─909530 "/usr/sbin/zabbix_server: vmware collector #8 [terminated]"
              ├─909531 "/usr/sbin/zabbix_server: vmware collector #9 [terminated]"
              ├─909532 "/usr/sbin/zabbix_server: vmware collector #10 [terminated]"
              ├─909558 "/usr/sbin/zabbix_server: task manager #1 [terminated]"
              ├─909559 "/usr/sbin/zabbix_server: poller #1 [terminated]"
              ├─909560 "/usr/sbin/zabbix_server: poller #2 [terminated]"
              ├─909561 "/usr/sbin/zabbix_server: poller #3 [terminated]"
              ├─909563 "/usr/sbin/zabbix_server: poller #4 [terminated]"
              ├─909564 "/usr/sbin/zabbix_server: poller #5 [terminated]"
              ├─909565 "/usr/sbin/zabbix_server: poller #6 [terminated]"
              ├─909566 "/usr/sbin/zabbix_server: poller #7 [terminated]"
              ├─909567 "/usr/sbin/zabbix_server: poller #8 [terminated]"
              ├─909568 "/usr/sbin/zabbix_server: poller #9 [terminated]"
              ├─909569 "/usr/sbin/zabbix_server: poller #10 [terminated]"
              ├─909570 "/usr/sbin/zabbix_server: poller #11 [terminated]"
              ├─909571 "/usr/sbin/zabbix_server: poller #12 [terminated]"
              ├─909572 "/usr/sbin/zabbix_server: poller #13 [terminated]"
              ├─909573 "/usr/sbin/zabbix_server: poller #14 [terminated]"
              ├─909574 "/usr/sbin/zabbix_server: poller #15 [terminated]"
              ├─909575 "/usr/sbin/zabbix_server: poller #16 [terminated]"
              ├─909576 "/usr/sbin/zabbix_server: poller #17 [terminated]"
              ├─909577 "/usr/sbin/zabbix_server: poller #18 [terminated]"
              ├─909578 "/usr/sbin/zabbix_server: poller #19 [terminated]"
              ├─909579 "/usr/sbin/zabbix_server: poller #20 [terminated]"
              ├─909580 "/usr/sbin/zabbix_server: poller #21 [terminated]"
              ├─909581 "/usr/sbin/zabbix_server: poller #22 [terminated]"
              ├─909582 "/usr/sbin/zabbix_server: poller #23 [terminated]"
              ├─909584 "/usr/sbin/zabbix_server: poller #24 [terminated]"
              ├─909585 "/usr/sbin/zabbix_server: poller #25 [terminated]"
              ├─909586 "/usr/sbin/zabbix_server: unreachable poller #1 [terminated]"
              ├─909587 "/usr/sbin/zabbix_server: unreachable poller #2 [terminated]"
              ├─909589 "/usr/sbin/zabbix_server: unreachable poller #3 [terminated]"
              ├─909590 "/usr/sbin/zabbix_server: unreachable poller #4 [terminated]"
              ├─909591 "/usr/sbin/zabbix_server: unreachable poller #5 [terminated]"
              ├─909592 "/usr/sbin/zabbix_server: unreachable poller #6 [terminated]"
              ├─909593 "/usr/sbin/zabbix_server: unreachable poller #7 [terminated]"
              ├─909594 "/usr/sbin/zabbix_server: unreachable poller #8 [terminated]"
              ├─909595 "/usr/sbin/zabbix_server: unreachable poller #9 [terminated]"
              ├─909596 "/usr/sbin/zabbix_server: unreachable poller #10 [terminated]"
              ├─909597 "/usr/sbin/zabbix_server: unreachable poller #11 [terminated]"
              ├─909598 "/usr/sbin/zabbix_server: unreachable poller #12 [terminated]"
              ├─909599 "/usr/sbin/zabbix_server: unreachable poller #13 [terminated]"
              ├─909600 "/usr/sbin/zabbix_server: unreachable poller #14 [terminated]"
              ├─909601 "/usr/sbin/zabbix_server: unreachable poller #15 [terminated]"
              ├─909602 "/usr/sbin/zabbix_server: unreachable poller #16 [terminated]"
              ├─909603 "/usr/sbin/zabbix_server: unreachable poller #17 [terminated]"
              ├─909604 "/usr/sbin/zabbix_server: unreachable poller #18 [terminated]"
              ├─909605 "/usr/sbin/zabbix_server: unreachable poller #19 [terminated]"
              ├─909606 "/usr/sbin/zabbix_server: unreachable poller #20 [terminated]"
              ├─909607 "/usr/sbin/zabbix_server: unreachable poller #21 [terminated]"
              ├─909608 "/usr/sbin/zabbix_server: unreachable poller #22 [terminated]"
              ├─909609 "/usr/sbin/zabbix_server: unreachable poller #23 [terminated]"
              ├─909610 "/usr/sbin/zabbix_server: unreachable poller #24 [terminated]"
              ├─909611 "/usr/sbin/zabbix_server: unreachable poller #25 [terminated]"
              ├─909612 "/usr/sbin/zabbix_server: trapper #1 [terminated]"
              ├─909613 "/usr/sbin/zabbix_server: trapper #2 [terminated]"
              ├─909614 "/usr/sbin/zabbix_server: trapper #3 [terminated]"
              ├─909616 "/usr/sbin/zabbix_server: trapper #4 [terminated]"
              ├─909618 "/usr/sbin/zabbix_server: trapper #5 [terminated]"
              ├─909619 "/usr/sbin/zabbix_server: icmp pinger #1 [terminated]"
              ├─909620 "/usr/sbin/zabbix_server: icmp pinger #2 [terminated]"
              ├─909624 "/usr/sbin/zabbix_server: icmp pinger #3 [terminated]"
              ├─909625 "/usr/sbin/zabbix_server: icmp pinger #4 [terminated]"
              ├─909626 "/usr/sbin/zabbix_server: icmp pinger #5 [terminated]"
              ├─909627 "/usr/sbin/zabbix_server: icmp pinger #6 [terminated]"
              ├─909628 "/usr/sbin/zabbix_server: icmp pinger #7 [terminated]"
              ├─909629 "/usr/sbin/zabbix_server: icmp pinger #8 [terminated]"
              ├─909630 "/usr/sbin/zabbix_server: icmp pinger #9 [terminated]"
              ├─909631 "/usr/sbin/zabbix_server: icmp pinger #10 [terminated]"
              ├─909632 "/usr/sbin/zabbix_server: icmp pinger #11 [terminated]"
              ├─909633 "/usr/sbin/zabbix_server: icmp pinger #12 [terminated]"
              ├─909634 "/usr/sbin/zabbix_server: icmp pinger #13 [terminated]"
              ├─909635 "/usr/sbin/zabbix_server: icmp pinger #14 [terminated]"
              ├─909636 "/usr/sbin/zabbix_server: icmp pinger #15 [terminated]"
              ├─909637 "/usr/sbin/zabbix_server: icmp pinger #16 [terminated]"
              ├─909638 "/usr/sbin/zabbix_server: icmp pinger #17 [terminated]"
              ├─909639 "/usr/sbin/zabbix_server: icmp pinger #18 [terminated]"
              ├─909640 "/usr/sbin/zabbix_server: icmp pinger #19 [terminated]"
              ├─909641 "/usr/sbin/zabbix_server: icmp pinger #20 [terminated]"
              ├─909642 "/usr/sbin/zabbix_server: icmp pinger #21 [terminated]"
              ├─909643 "/usr/sbin/zabbix_server: icmp pinger #22 [terminated]"
              ├─909644 "/usr/sbin/zabbix_server: icmp pinger #23 [terminated]"
              ├─909645 "/usr/sbin/zabbix_server: icmp pinger #24 [terminated]"
              ├─909646 "/usr/sbin/zabbix_server: icmp pinger #25 [terminated]"
              ├─909647 "/usr/sbin/zabbix_server: icmp pinger #26 [terminated]"
              ├─909648 "/usr/sbin/zabbix_server: icmp pinger #27 [terminated]"
              ├─909649 "/usr/sbin/zabbix_server: icmp pinger #28 [terminated]"
              ├─909650 "/usr/sbin/zabbix_server: icmp pinger #29 [terminated]"
              ├─909651 "/usr/sbin/zabbix_server: icmp pinger #30 [terminated]"
              ├─909652 "/usr/sbin/zabbix_server: icmp pinger #31 [terminated]"
              ├─909653 "/usr/sbin/zabbix_server: icmp pinger #32 [terminated]"
              ├─909654 "/usr/sbin/zabbix_server: icmp pinger #33 [terminated]"
              ├─909655 "/usr/sbin/zabbix_server: icmp pinger #34 [terminated]"
              ├─909656 "/usr/sbin/zabbix_server: icmp pinger #35 [terminated]"
              ├─909657 "/usr/sbin/zabbix_server: icmp pinger #36 [terminated]"
              ├─909658 "/usr/sbin/zabbix_server: icmp pinger #37 [terminated]"
              ├─909659 "/usr/sbin/zabbix_server: icmp pinger #38 [terminated]"
              ├─909660 "/usr/sbin/zabbix_server: icmp pinger #39 [terminated]"
              ├─909661 "/usr/sbin/zabbix_server: icmp pinger #40 [terminated]"
              ├─909662 "/usr/sbin/zabbix_server: icmp pinger #41 [terminated]"
              ├─909663 "/usr/sbin/zabbix_server: icmp pinger #42 [terminated]"
              ├─909664 "/usr/sbin/zabbix_server: icmp pinger #43 [terminated]"
              ├─909665 "/usr/sbin/zabbix_server: icmp pinger #44 [terminated]"
              ├─909666 "/usr/sbin/zabbix_server: icmp pinger #45 [terminated]"
              ├─909667 "/usr/sbin/zabbix_server: icmp pinger #46 [terminated]"
              ├─909668 "/usr/sbin/zabbix_server: icmp pinger #47 [terminated]"
              ├─909669 "/usr/sbin/zabbix_server: icmp pinger #48 [terminated]"
              ├─909670 "/usr/sbin/zabbix_server: icmp pinger #49 [terminated]"
              ├─909671 "/usr/sbin/zabbix_server: icmp pinger #50 [terminated]"
              ├─909672 "/usr/sbin/zabbix_server: alert syncer [queued 0 alerts(s), flushed 0 result(s) in 0.000000 sec, idle 1 sec]"
              ├─909673 "/usr/sbin/zabbix_server: history poller #1 [terminated]"
              ├─909674 "/usr/sbin/zabbix_server: history poller #2 [terminated]"
              ├─909678 "/usr/sbin/zabbix_server: history poller #3 [terminated]"
              ├─909679 "/usr/sbin/zabbix_server: history poller #4 [terminated]"
              ├─909681 "/usr/sbin/zabbix_server: history poller #5 [terminated]"
              ├─909683 "/usr/sbin/zabbix_server: trigger housekeeper #1 [terminated]"
              ├─909684 "/usr/sbin/zabbix_server: odbc poller #1 [terminated]"
              ├─909689 "/usr/sbin/zabbix_server: odbc poller #2 [terminated]"
              ├─909690 "/usr/sbin/zabbix_server: odbc poller #3 [terminated]"
              ├─909691 "/usr/sbin/zabbix_server: odbc poller #4 [terminated]"
              ├─909692 "/usr/sbin/zabbix_server: odbc poller #5 [terminated]"
              ├─909693 "/usr/sbin/zabbix_server: odbc poller #6 [terminated]"
              ├─909694 "/usr/sbin/zabbix_server: odbc poller #7 [terminated]"
              ├─909695 "/usr/sbin/zabbix_server: odbc poller #8 [terminated]"
              ├─909696 "/usr/sbin/zabbix_server: odbc poller #9 [terminated]"
              ├─909697 "/usr/sbin/zabbix_server: odbc poller #10 [terminated]"
              ├─909698 "/usr/sbin/zabbix_server: odbc poller #11 [terminated]"
              ├─909699 "/usr/sbin/zabbix_server: odbc poller #12 [terminated]"
              ├─909700 "/usr/sbin/zabbix_server: odbc poller #13 [terminated]"
              ├─909701 "/usr/sbin/zabbix_server: odbc poller #14 [terminated]"
              ├─909702 "/usr/sbin/zabbix_server: odbc poller #15 [terminated]"
              ├─909703 "/usr/sbin/zabbix_server: http agent poller #1 [terminated]"
              ├─909704 "/usr/sbin/zabbix_server: agent poller #1 [terminated]"
              ├─909705 "/usr/sbin/zabbix_server: snmp poller #1 [terminated]"
              ├─909706 "/usr/sbin/zabbix_server: configuration syncer worker [synced 0, updated 0 item names in 0.000338 sec, idle]"
              ├─909711 "/usr/sbin/zabbix_server: internal poller #1 [terminated]"
              └─909712 "/usr/sbin/zabbix_server: proxy group manager #1 [terminated]"

              Jan 23 06:19:44 hosty systemd[1]: Starting zabbix-server.service - Zabbix Server...
              Jan 23 06:19:44 hosty systemd[1]: Started zabbix-server.service - Zabbix Server.
              Jan 28 06:01:57 hosty systemd[1]: Stopping zabbix-server.service - Zabbix Server...
              Unit zabbix-proxy.service could not be found.
              ○ mysql.service - MySQL Community Server
              Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: enabled)
              Active: inactive (dead) since Wed 2026-01-28 06:02:00 UTC; 2 months 7 days ago
              Duration: 3month 3h 28min 23.373s
              Process: 808 ExecStart=/usr/sbin/mysqld (code=exited, status=0/SUCCESS)
              Main PID: 808 (code=exited, status=0/SUCCESS)
              Status: "Server shutdown complete"
              CPU: 17h 42min 37.387s

              Oct 28 19:03:32 hosty systemd[1]: Starting mysql.service - MySQL Community Server...
              Oct 28 19:03:34 hosty systemd[1]: Started mysql.service - MySQL Community Server.
              Jan 28 06:02:00 hosty systemd[1]: mysql.service: Deactivated successfully.
              Jan 28 06:02:00 hosty systemd[1]: Stopped mysql.service - MySQL Community Server.
              Jan 28 06:02:00 hosty systemd[1]: mysql.service: Consumed 17h 42min 37.387s CPU time, 5.6G memory peak, 0B memory swap peak.
              Unit mariadb.service could not be found.
              root@hosty:/home/rooty# systemctl status zabbix-server
              ● zabbix-server.service - Zabbix Server
              Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; preset: enabled)
              Active: deactivating (stop-sigterm) since Wed 2026-01-28 06:01:57 UTC; 2 months 7 days ago
              Process: 959154 ExecStop=/bin/sh -c [ -n "$1" ] && kill -s TERM "$1" -- $MAINPID (code=exited, status=0/SUCCESS)
              Main PID: 909470 (zabbix_server)
              Tasks: 167 (limit: 9207)
              Memory: 349.9M (peak: 395.8M)
              CPU: 1h 11min 25.850s
              CGroup: /system.slice/zabbix-server.service
              ├─909470 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
              ├─909471 "/usr/sbin/zabbix_server: ha manager"
              ├─909472 "/usr/sbin/zabbix_server: service manager #1 [processed 0 events, updated 0 event tags, deleted 0 problems, synced 0 service updates, idle 5.042051 sec during 5.042094 sec]"
              ├─909473 "/usr/sbin/zabbix_server: configuration syncer #1 [terminated]"
              ├─909487 "/usr/sbin/zabbix_server: alert manager #1 [terminated]"
              ├─909488 "/usr/sbin/zabbix_server: alerter #1 started"
              ├─909490 "/usr/sbin/zabbix_server: alerter #2 started"
              ├─909491 "/usr/sbin/zabbix_server: alerter #3 started"
              ├─909494 "/usr/sbin/zabbix_server: lld manager #1 [terminated]"
              ├─909498 "/usr/sbin/zabbix_server: lld worker #1 [processed 17 LLD rules, idle 340.103836 sec during 340.360403 sec]"
              ├─909499 "/usr/sbin/zabbix_server: lld worker #2 [processed 1 LLD rules, idle 1028.004559 sec during 1028.029082 sec]"
              ├─909500 "/usr/sbin/zabbix_server: housekeeper #1 [terminated]"
              ├─909501 "/usr/sbin/zabbix_server: timer #1 [terminated]"
              ├─909503 "/usr/sbin/zabbix_server: http poller #1 [terminated]"
              ├─909504 "/usr/sbin/zabbix_server: browser poller #1 [terminated]"
              ├─909506 "/usr/sbin/zabbix_server: history syncer #1 [processed 2 values, 1+0 triggers in 0.002337 (0.002,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909507 "/usr/sbin/zabbix_server: history syncer #2 [processed 0 values, 0+0 triggers in 0.000013 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909514 "/usr/sbin/zabbix_server: history syncer #3 [processed 0 values, 0+0 triggers in 0.000016 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909515 "/usr/sbin/zabbix_server: history syncer #4 [processed 0 values, 0+0 triggers in 0.000009 (0.000,0.000,0.000,0.000,0.000) sec, idle 1 sec]"
              ├─909516 "/usr/sbin/zabbix_server: escalator #1 [terminated]"
              ├─909517 "/usr/sbin/zabbix_server: proxy poller #1 [terminated]"
              ├─909518 "/usr/sbin/zabbix_server: self-monitoring #1 [terminated]"
              ├─909522 "/usr/sbin/zabbix_server: vmware collector #1 [terminated]"
              ├─909523 "/usr/sbin/zabbix_server: vmware collector #2 [terminated]"
              ├─909524 "/usr/sbin/zabbix_server: vmware collector #3 [terminated]"
              ├─909525 "/usr/sbin/zabbix_server: vmware collector #4 [terminated]"
              ├─909527 "/usr/sbin/zabbix_server: vmware collector #5 [terminated]"
              ├─909528 "/usr/sbin/zabbix_server: vmware collector #6 [terminated]"
              ├─909529 "/usr/sbin/zabbix_server: vmware collector #7 [terminated]"
              ├─909530 "/usr/sbin/zabbix_server: vmware collector #8 [terminated]"
              ├─909531 "/usr/sbin/zabbix_server: vmware collector #9 [terminated]"
              ├─909532 "/usr/sbin/zabbix_server: vmware collector #10 [terminated]"
              ├─909558 "/usr/sbin/zabbix_server: task manager #1 [terminated]"
              ├─909559 "/usr/sbin/zabbix_server: poller #1 [terminated]"
              ├─909560 "/usr/sbin/zabbix_server: poller #2 [terminated]"
              ├─909561 "/usr/sbin/zabbix_server: poller #3 [terminated]"
              ├─909563 "/usr/sbin/zabbix_server: poller #4 [terminated]"
              ├─909564 "/usr/sbin/zabbix_server: poller #5 [terminated]"
              ├─909565 "/usr/sbin/zabbix_server: poller #6 [terminated]"
              ├─909566 "/usr/sbin/zabbix_server: poller #7 [terminated]"
              ├─909567 "/usr/sbin/zabbix_server: poller #8 [terminated]"
              ├─909568 "/usr/sbin/zabbix_server: poller #9 [terminated]"
              ├─909569 "/usr/sbin/zabbix_server: poller #10 [terminated]"
              ├─909570 "/usr/sbin/zabbix_server: poller #11 [terminated]"
              ├─909571 "/usr/sbin/zabbix_server: poller #12 [terminated]"
              ├─909572 "/usr/sbin/zabbix_server: poller #13 [terminated]"
              ├─909573 "/usr/sbin/zabbix_server: poller #14 [terminated]"
              ├─909574 "/usr/sbin/zabbix_server: poller #15 [terminated]"
              ├─909575 "/usr/sbin/zabbix_server: poller #16 [terminated]"
              ├─909576 "/usr/sbin/zabbix_server: poller #17 [terminated]"
              ├─909577 "/usr/sbin/zabbix_server: poller #18 [terminated]"
              ├─909578 "/usr/sbin/zabbix_server: poller #19 [terminated]"
              ├─909579 "/usr/sbin/zabbix_server: poller #20 [terminated]"
              ├─909580 "/usr/sbin/zabbix_server: poller #21 [terminated]"
              ├─909581 "/usr/sbin/zabbix_server: poller #22 [terminated]"
              ├─909582 "/usr/sbin/zabbix_server: poller #23 [terminated]"
              ├─909584 "/usr/sbin/zabbix_server: poller #24 [terminated]"
              ├─909585 "/usr/sbin/zabbix_server: poller #25 [terminated]"
              ├─909586 "/usr/sbin/zabbix_server: unreachable poller #1 [terminated]"
              ├─909587 "/usr/sbin/zabbix_server: unreachable poller #2 [terminated]"

              root@hosty:/home/rooty# systemctl status mysql
              ○ mysql.service - MySQL Community Server
              Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: enabled)
              Active: inactive (dead) since Wed 2026-01-28 06:02:00 UTC; 2 months 7 days ago
              Duration: 3month 3h 28min 23.373s
              Process: 808 ExecStart=/usr/sbin/mysqld (code=exited, status=0/SUCCESS)
              Main PID: 808 (code=exited, status=0/SUCCESS)
              Status: "Server shutdown complete"
              CPU: 17h 42min 37.387s

              Oct 28 19:03:32 hosty systemd[1]: Starting mysql.service - MySQL Community Server...
              Oct 28 19:03:34 hosty systemd[1]: Started mysql.service - MySQL Community Server.
              Jan 28 06:02:00 hosty systemd[1]: mysql.service: Deactivated successfully.
              Jan 28 06:02:00 hosty systemd[1]: Stopped mysql.service - MySQL Community Server.
              Jan 28 06:02:00 hosty systemd[1]: mysql.service: Consumed 17h 42min 37.387s CPU time, 5.6G memory peak, 0B memory swap peak.
              root@hosty:/home/rooty# systemctl stop zabbix-server
              ^C
              root@hosty:/home/rooty# journalctl -u mysql -u mariadb --since "24 hours ago" --no-pager
              journalctl -u zabbix-server --since "24 hours ago" --no-pager
              -- No entries --
              -- No entries --
              root@hosty:/home/rooty# grep -R "log_error" /etc/mysql /etc/my.cnf /etc/my.cnf.d /etc/mysql/mariadb.conf.d 2>/dev/null
              /etc/mysql/mysql.conf.d/mysqld.cnf:log_error = /var/log/mysql/error.log
              root@hosty:/home/rooty# tail -n 300 /var/log/mysql/error.log 2>/dev/null
              tail -n 300 /var/log/mysqld.log 2>/dev/null
              tail -n 300 /var/lib/mysql/*.err 2>/dev/null
              root@hosty:/home/rooty# tail -n 300 /var/log/zabbix/zabbix_server.log 2>/dev/null
              tail -n 300 /var/log/zabbix/zabbix_proxy.log 2>/dev/null
              grep -nE "Z3001|Z3005|housekeeper|history syncer|database is down|server has gone away|lost connection" \
              /var/log/zabbix/zabbix_server.log /var/log/zabbix/zabbix_proxy.log 2>/dev/null | tail -n 100
              909506:20260406:205556.040 database is down: reconnecting in 10 seconds
              909472:20260406:205559.263 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
              909472:20260406:205559.263 database is down: reconnecting in 10 seconds
              909471:20260406:205559.960 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
              909471:20260406:205604.962 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
              909672:20260406:205606.026 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

              /var/log/zabbix/zabbix_server.log:129671:909506:20260406:210206.04 7 database is down: reconnecting in 10 seconds
              /var/log/zabbix/zabbix_server.log:129672:909472:20260406:210209.27 0 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
              /var/log/zabbix/zabbix_server.log:129673:909472:20260406:210209.27 0 database is down: reconnecting in 10 seconds
              /var/log/zabbix/zabbix_server.log:129674:909471:20260406:210210.31 8 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
              root@hosty:/home/rooty# systemctl restart mysql

                Comment

                Previous template Next
                Working...