Ad Widget

Collapse

Проблема с переносом базы с mysql в mariadb

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Isvet
    Junior Member
    • Aug 2023
    • 2

    #1

    Проблема с переносом базы с mysql в mariadb

    Из-за проблем с местом хотел перенести базу на новый сервер.
    сделал dump стандартными средствами mysql и так же восстановил базу на новом сервере стандартными средствами.
    Но сервер не запускается... Вот лог файл. Поиск нечего не помог. Даже незнаю куда смотреть.
    новый сервер 10.11.5-MariaDB-1:10.11.5+maria~ubu2204
    Code:
     cat zabbix_server.log
    
    187256:20230831:111027.148 Zabbix agent item "service.info["LSM",state]" on host "sklad snizu" failed: first network error, wait for 15 seconds
    187228:20230831:111027.471 Got signal [signal:15(SIGTERM),sender_pid:187705,sender_uid:0,reason:0]. Exiting ...
    187230:20230831:111027.472 HA manager has been paused
    187248:20230831:111027.473 syncing history data in progress...
    187239:20230831:111027.473 [2] thread stopped [preprocessing worker #2]
    187239:20230831:111027.479 [3] thread stopped [preprocessing worker #3]
    187239:20230831:111027.480 [1] thread stopped [preprocessing worker #1]
    187249:20230831:111027.490 syncing history data... 100.000000%
    187249:20230831:111027.490 syncing history data done
    187230:20230831:111028.517 HA manager has been stopped
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187228:20230831:111028.534 syncing trend data...
    187228:20230831:111028.845 syncing trend data done
    187228:20230831:111028.854 Zabbix Server stopped. Zabbix 6.4.6 (revision 52b7e2cb506).
    187729:20230831:111028.867 Starting Zabbix Server. Zabbix 6.4.6 (revision 52b7e2cb506).
    187729:20230831:111028.867 ****** Enabled features ******
    187729:20230831:111028.867 SNMP monitoring:           YES
    187729:20230831:111028.867 IPMI monitoring:           YES
    187729:20230831:111028.867 Web monitoring:            YES
    187729:20230831:111028.867 VMware monitoring:         YES
    187729:20230831:111028.867 SMTP authentication:       YES
    187729:20230831:111028.867 ODBC:                      YES
    187729:20230831:111028.867 SSH support:               YES
    187729:20230831:111028.867 IPv6 support:              YES
    187729:20230831:111028.867 TLS support:               YES
    187729:20230831:111028.867 ******************************
    187729:20230831:111028.867 using configuration file: /etc/zabbix/zabbix_server.conf
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187729:20230831:111028.874 current database version (mandatory/optional): 06040000/06040001
    187729:20230831:111028.874 required mandatory version: 06040000
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187729:20230831:111028.875 database could be upgraded to use primary keys in history tables
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187730:20230831:111028.878 starting HA manager
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187730:20230831:111028.880 HA manager started in active mode
    187729:20230831:111028.881 server #0 started [main process]
    187731:20230831:111028.881 server #1 started [service manager #1]
    187732:20230831:111028.881 server #2 started [configuration syncer #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187751:20230831:111029.767 server #3 started [alert manager #1]
    187752:20230831:111029.767 server #4 started [alerter #1]
    187753:20230831:111029.767 server #5 started [alerter #2]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187754:20230831:111029.767 server #6 started [alerter #3]
    187755:20230831:111029.767 server #7 started [preprocessing manager #1]
    187757:20230831:111029.768 server #9 started [lld worker #1]
    187758:20230831:111029.768 server #10 started [lld worker #2]
    187759:20230831:111029.768 server #11 started [housekeeper #1]
    187761:20230831:111029.768 server #13 started [http poller #1]
    187756:20230831:111029.769 server #8 started [lld manager #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187760:20230831:111029.769 server #12 started [timer #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187766:20230831:111029.769 server #18 started [history syncer #4]
    187755:20230831:111029.770 [1] thread started [preprocessing worker #1]
    187771:20230831:111029.770 server #20 started [proxy poller #1]
    187755:20230831:111029.770 [2] thread started [preprocessing worker #2]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187755:20230831:111029.770 [3] thread started [preprocessing worker #3]
    187768:20230831:111029.770 server #19 started [escalator #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187772:20230831:111029.770 server #21 started [self-monitoring #1]
    187773:20230831:111029.770 server #22 started [task manager #1]
    187762:20230831:111029.770 server #14 started [discoverer #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187763:20230831:111029.771 server #15 started [history syncer #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187779:20230831:111029.771 server #27 started [poller #5]
    187777:20230831:111029.772 server #25 started [poller #3]
    187780:20230831:111029.772 server #28 started [unreachable poller #1]
    187781:20230831:111029.772 server #29 started [trapper #1]
    187785:20230831:111029.773 server #33 started [trapper #5]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187786:20230831:111029.773 server #34 started [icmp pinger #1]
    187789:20230831:111029.773 server #37 started [history poller #2]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187792:20230831:111029.774 server #40 started [history poller #5]
    187793:20230831:111029.774 server #41 started [availability manager #1]
    187791:20230831:111029.774 server #39 started [history poller #4]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187776:20230831:111029.774 server #24 started [poller #2]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187775:20230831:111029.775 server #23 started [poller #1]
    187764:20230831:111029.775 server #16 started [history syncer #2]
    187765:20230831:111029.775 server #17 started [history syncer #3]
    187784:20230831:111029.775 server #32 started [trapper #4]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187778:20230831:111029.775 server #26 started [poller #4]
    187787:20230831:111029.775 server #35 started [alert syncer #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187788:20230831:111029.775 server #36 started [history poller #1]
    187782:20230831:111029.775 server #30 started [trapper #2]
    187790:20230831:111029.776 server #38 started [history poller #3]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187783:20230831:111029.776 server #31 started [trapper #3]
    187794:20230831:111029.776 server #42 started [trigger housekeeper #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187795:20230831:111029.776 server #43 started [odbc poller #1]
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187780:20230831:111046.797 resuming Zabbix agent checks on host "sklad snizu": connection restored
    WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
    187783:20230831:111134.505 cannot send list of active checks to "172.17.1.54": host [MASTER-BIRJA] not found
    ​
    Last edited by Isvet; 31-08-2023, 10:57.
  • Hamardaban
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • May 2019
    • 2713

    #2
    Судя по приведенному логу сервер запускается... или это не весь лог?
    Об ошибках в логе можно почитать тут https://support.zabbix.com/browse/ZBX-23145 и тут https://dev.mysql.com/doc/c-api/8.0/...reconnect.html

    Comment

    Working...