Hi,
I am upgrading zabbix from version 3.0 to 4.2, the tables were partitioned, I removed using 'alter table remove partitioning table_name'.
I'm using mysql Ver 14.14 Distrib 5.7.17 and Red Hat Enterprise Linux Server release 6.10 (Santiago)
This is the result of the command 'tail -20 /var/log/zabbix/zabbix_server.log'
37009:20191123:155344.882 End of DBflush_trends()
37009:20191123:155344.882 In DBflush_trends() trends_num:2
37009:20191123:155344.882 query [txnlev:1] [select distinct itemid from trends_uint where clock>=1574532000 and itemid in (23662,28534)]
37009:20191123:155344.883 query [txnlev:1] [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23662,1574532000,1,0,0,0),(28534,1574532000,1,0,0 ,0);
]
37009:20191123:155344.883 End of DBflush_trends()
37009:20191123:155344.883 query [txnlev:1] [commit;]
37009:20191123:155344.894 syncing trend data done
37009:20191123:155344.894 End of DCsync_trends()
37009:20191123:155344.894 End of DCsync_all()
37009:20191123:155344.894 End of free_database_cache()
37009:20191123:155344.894 In free_configuration_cache()
37009:20191123:155344.894 End of free_configuration_cache()
37009:20191123:155344.894 In zbx_vc_destroy()
37009:20191123:155344.894 End of zbx_vc_destroy()
37009:20191123:155344.894 In free_selfmon_collector() collector:0x7fb914326000
37009:20191123:155344.894 End of free_selfmon_collector()
37009:20191123:155344.894 In zbx_unload_modules()
37009:20191123:155344.894 End of zbx_unload_modules()
37009:20191123:155344.894 Zabbix Server stopped. Zabbix 4.2.6 (revision d3bb18bbc4).
Anyone can help me ?
I am upgrading zabbix from version 3.0 to 4.2, the tables were partitioned, I removed using 'alter table remove partitioning table_name'.
I'm using mysql Ver 14.14 Distrib 5.7.17 and Red Hat Enterprise Linux Server release 6.10 (Santiago)
This is the result of the command 'tail -20 /var/log/zabbix/zabbix_server.log'
37009:20191123:155344.882 End of DBflush_trends()
37009:20191123:155344.882 In DBflush_trends() trends_num:2
37009:20191123:155344.882 query [txnlev:1] [select distinct itemid from trends_uint where clock>=1574532000 and itemid in (23662,28534)]
37009:20191123:155344.883 query [txnlev:1] [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23662,1574532000,1,0,0,0),(28534,1574532000,1,0,0 ,0);
]
37009:20191123:155344.883 End of DBflush_trends()
37009:20191123:155344.883 query [txnlev:1] [commit;]
37009:20191123:155344.894 syncing trend data done
37009:20191123:155344.894 End of DCsync_trends()
37009:20191123:155344.894 End of DCsync_all()
37009:20191123:155344.894 End of free_database_cache()
37009:20191123:155344.894 In free_configuration_cache()
37009:20191123:155344.894 End of free_configuration_cache()
37009:20191123:155344.894 In zbx_vc_destroy()
37009:20191123:155344.894 End of zbx_vc_destroy()
37009:20191123:155344.894 In free_selfmon_collector() collector:0x7fb914326000
37009:20191123:155344.894 End of free_selfmon_collector()
37009:20191123:155344.894 In zbx_unload_modules()
37009:20191123:155344.894 End of zbx_unload_modules()
37009:20191123:155344.894 Zabbix Server stopped. Zabbix 4.2.6 (revision d3bb18bbc4).
Anyone can help me ?
Comment