Good day all,
I'm trying to get Zabbix 4.2 deployed on a Galera DB witn InnoDB, running on Ubuntu 18.04. ProxySQL is on the app server (just 1 app server until I can get this going) and all is good on the zabbix user being able to authenticate throughout the system. The issue I'm running up against deals with the dbversion table. This table did not get created upon importing the .sql files. I couldn't get the create.sql.gz to import, either from the app server or the DB servers. However, I could load schema.sql, images.sql and data.sql, but the dbversion table wasn't created.
Is there a way to create this manually to get past this? This appears to be the only bump to making this work.
10315:20190724:140223.516 Starting Zabbix Server. Zabbix 4.2.4 (revision 059af02c82).
10315:20190724:140223.516 ****** Enabled features ******
10315:20190724:140223.516 SNMP monitoring: YES
10315:20190724:140223.517 IPMI monitoring: YES
10315:20190724:140223.517 Web monitoring: YES
10315:20190724:140223.517 VMware monitoring: YES
10315:20190724:140223.517 SMTP authentication: YES
10315:20190724:140223.517 Jabber notifications: NO
10315:20190724:140223.517 Ez Texting notifications: YES
10315:20190724:140223.517 ODBC: YES
10315:20190724:140223.517 SSH2 support: YES
10315:20190724:140223.517 IPv6 support: YES
10315:20190724:140223.517 TLS support: YES
10315:20190724:140223.517 ******************************
10315:20190724:140223.517 using configuration file: /etc/zabbix/zabbix_server.conf
10315:20190724:140223.517 In zbx_load_modules()
10315:20190724:140223.517 End of zbx_load_modules():SUCCEED
10315:20190724:140223.517 In init_database_cache()
10315:20190724:140223.517 In zbx_mem_create() param:'HistoryCacheSize' size:16777216
10315:20190724:140223.517 valid user addresses: [0x7f9e28830168, 0x7f9e2982fff0] total size: 16776840
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 In zbx_mem_create() param:'HistoryIndexCacheSize' size:4194304
10315:20190724:140223.518 valid user addresses: [0x7f9e28430178, 0x7f9e2882fff0] total size: 4193912
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 In init_trend_cache()
10315:20190724:140223.518 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
10315:20190724:140223.518 End of zbx_mem_required_size() size:414
10315:20190724:140223.518 In zbx_mem_create() param:'TrendCacheSize' size:4194304
10315:20190724:140223.518 valid user addresses: [0x7f9e28030168, 0x7f9e2842fff0] total size: 4193928
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of init_trend_cache()
10315:20190724:140223.518 End of init_database_cache()
10315:20190724:140223.518 In init_configuration_cache() size:8388608
10315:20190724:140223.518 In zbx_mem_create() param:'CacheSize' size:8388608
10315:20190724:140223.518 valid user addresses: [0x7f9e27830168, 0x7f9e2802fff0] total size: 8388232
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of init_configuration_cache()
10315:20190724:140223.518 In init_selfmon_collector()
10315:20190724:140223.518 init_selfmon_collector() size:11216
10315:20190724:140223.518 End of init_selfmon_collector() collector:0x7f9e35706000
10315:20190724:140223.518 In zbx_vc_init()
10315:20190724:140223.518 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
10315:20190724:140223.518 End of zbx_mem_required_size() size:419
10315:20190724:140223.518 In zbx_mem_create() param:'ValueCacheSize' size:8388608
10315:20190724:140223.518 valid user addresses: [0x7f9e27030168, 0x7f9e2782fff0] total size: 8388232
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of zbx_vc_init()
10315:20190724:140223.518 In zbx_db_get_database_type()
10315:20190724:140223.518 In DBconnect() flag:0
10315:20190724:140223.519 End of DBconnect():0
10315:20190724:140223.519 query [txnlev:0] [select userid from users limit 1]
10315:20190724:140223.520 there is at least 1 record in "users" table
10315:20190724:140223.520 End of zbx_db_get_database_type():ZBX_DB_SERVER
10315:20190724:140223.520 In DBcheck_version()
10315:20190724:140223.520 In DBconnect() flag:0
10315:20190724:140223.521 End of DBconnect():0
10315:20190724:140223.521 query [txnlev:0] [show tables like 'dbversion']
10315:20190724:140223.522 DBcheck_version() "dbversion" does not exist
10315:20190724:140223.522 query [txnlev:0] [show columns from config like 'server_check_interval']
10315:20190724:140223.523 query [txnlev:1] [begin;]
10315:20190724:140223.523 query [txnlev:1] [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb]
10315:20190724:140223.526 [Z3005] query failed: [1173] This table type requires a primary key [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb]
10315:20190724:140223.526 query [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb] failed, setting transaction as failed
10315:20190724:140223.526 query [txnlev:1] [rollback;]
10315:20190724:140223.526 End of DBcheck_version():FAIL
I'm trying to get Zabbix 4.2 deployed on a Galera DB witn InnoDB, running on Ubuntu 18.04. ProxySQL is on the app server (just 1 app server until I can get this going) and all is good on the zabbix user being able to authenticate throughout the system. The issue I'm running up against deals with the dbversion table. This table did not get created upon importing the .sql files. I couldn't get the create.sql.gz to import, either from the app server or the DB servers. However, I could load schema.sql, images.sql and data.sql, but the dbversion table wasn't created.
Is there a way to create this manually to get past this? This appears to be the only bump to making this work.
10315:20190724:140223.516 Starting Zabbix Server. Zabbix 4.2.4 (revision 059af02c82).
10315:20190724:140223.516 ****** Enabled features ******
10315:20190724:140223.516 SNMP monitoring: YES
10315:20190724:140223.517 IPMI monitoring: YES
10315:20190724:140223.517 Web monitoring: YES
10315:20190724:140223.517 VMware monitoring: YES
10315:20190724:140223.517 SMTP authentication: YES
10315:20190724:140223.517 Jabber notifications: NO
10315:20190724:140223.517 Ez Texting notifications: YES
10315:20190724:140223.517 ODBC: YES
10315:20190724:140223.517 SSH2 support: YES
10315:20190724:140223.517 IPv6 support: YES
10315:20190724:140223.517 TLS support: YES
10315:20190724:140223.517 ******************************
10315:20190724:140223.517 using configuration file: /etc/zabbix/zabbix_server.conf
10315:20190724:140223.517 In zbx_load_modules()
10315:20190724:140223.517 End of zbx_load_modules():SUCCEED
10315:20190724:140223.517 In init_database_cache()
10315:20190724:140223.517 In zbx_mem_create() param:'HistoryCacheSize' size:16777216
10315:20190724:140223.517 valid user addresses: [0x7f9e28830168, 0x7f9e2982fff0] total size: 16776840
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 In zbx_mem_create() param:'HistoryIndexCacheSize' size:4194304
10315:20190724:140223.518 valid user addresses: [0x7f9e28430178, 0x7f9e2882fff0] total size: 4193912
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 In init_trend_cache()
10315:20190724:140223.518 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
10315:20190724:140223.518 End of zbx_mem_required_size() size:414
10315:20190724:140223.518 In zbx_mem_create() param:'TrendCacheSize' size:4194304
10315:20190724:140223.518 valid user addresses: [0x7f9e28030168, 0x7f9e2842fff0] total size: 4193928
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of init_trend_cache()
10315:20190724:140223.518 End of init_database_cache()
10315:20190724:140223.518 In init_configuration_cache() size:8388608
10315:20190724:140223.518 In zbx_mem_create() param:'CacheSize' size:8388608
10315:20190724:140223.518 valid user addresses: [0x7f9e27830168, 0x7f9e2802fff0] total size: 8388232
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of init_configuration_cache()
10315:20190724:140223.518 In init_selfmon_collector()
10315:20190724:140223.518 init_selfmon_collector() size:11216
10315:20190724:140223.518 End of init_selfmon_collector() collector:0x7f9e35706000
10315:20190724:140223.518 In zbx_vc_init()
10315:20190724:140223.518 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
10315:20190724:140223.518 End of zbx_mem_required_size() size:419
10315:20190724:140223.518 In zbx_mem_create() param:'ValueCacheSize' size:8388608
10315:20190724:140223.518 valid user addresses: [0x7f9e27030168, 0x7f9e2782fff0] total size: 8388232
10315:20190724:140223.518 End of zbx_mem_create()
10315:20190724:140223.518 End of zbx_vc_init()
10315:20190724:140223.518 In zbx_db_get_database_type()
10315:20190724:140223.518 In DBconnect() flag:0
10315:20190724:140223.519 End of DBconnect():0
10315:20190724:140223.519 query [txnlev:0] [select userid from users limit 1]
10315:20190724:140223.520 there is at least 1 record in "users" table
10315:20190724:140223.520 End of zbx_db_get_database_type():ZBX_DB_SERVER
10315:20190724:140223.520 In DBcheck_version()
10315:20190724:140223.520 In DBconnect() flag:0
10315:20190724:140223.521 End of DBconnect():0
10315:20190724:140223.521 query [txnlev:0] [show tables like 'dbversion']
10315:20190724:140223.522 DBcheck_version() "dbversion" does not exist
10315:20190724:140223.522 query [txnlev:0] [show columns from config like 'server_check_interval']
10315:20190724:140223.523 query [txnlev:1] [begin;]
10315:20190724:140223.523 query [txnlev:1] [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb]
10315:20190724:140223.526 [Z3005] query failed: [1173] This table type requires a primary key [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb]
10315:20190724:140223.526 query [create table dbversion (
`mandatory` integer default '0' not null,
`optional` integer default '0' not null
) engine=innodb] failed, setting transaction as failed
10315:20190724:140223.526 query [txnlev:1] [rollback;]
10315:20190724:140223.526 End of DBcheck_version():FAIL