4:20220601:094456.813 Starting Zabbix Server. Zabbix 6.2.0beta3 (revision {ZABBIX_REVISION}).
2195604:20220601:094456.813 ****** Enabled features ******
2195604:20220601:094456.813 SNMP monitoring:           YES
2195604:20220601:094456.813 IPMI monitoring:            NO
2195604:20220601:094456.813 Web monitoring:            YES
2195604:20220601:094456.813 VMware monitoring:         YES
2195604:20220601:094456.813 SMTP authentication:       YES
2195604:20220601:094456.813 ODBC:                       NO
2195604:20220601:094456.813 SSH support:                NO
2195604:20220601:094456.813 IPv6 support:              YES
2195604:20220601:094456.813 TLS support:               YES
2195604:20220601:094456.813 ******************************
2195604:20220601:094456.813 using configuration file: /home/sergejs/workspace/ZBXNEXT-2592-6.1/etc/zabbix_server.conf
2195604:20220601:094456.814 In zbx_load_modules()
2195604:20220601:094456.814 End of zbx_load_modules():SUCCEED
2195604:20220601:094456.814 In zbx_ipc_service_start() service:rtc
2195604:20220601:094456.814 In zbx_ipc_socket_open()
2195604:20220601:094456.814 End of zbx_ipc_socket_open():FAIL
2195604:20220601:094456.814 End of zbx_ipc_service_start():SUCCEED
2195604:20220601:094456.814 In zbx_db_get_database_type()
2195604:20220601:094456.814 In DBconnect() flag:0
2195604:20220601:094456.878 query without transaction detected
2195604:20220601:094456.878 query [txnlev:0] [alter session set nls_numeric_characters='. ']
2195604:20220601:094456.879 End of DBconnect():0
2195604:20220601:094456.879 query [txnlev:0] [select * from (select userid from users) where rownum<=1]
2195604:20220601:094456.883 there is at least 1 record in "users" table
2195604:20220601:094456.884 End of zbx_db_get_database_type():ZBX_DB_SERVER
2195604:20220601:094456.884 In init_database_cache()
2195604:20220601:094456.884 In zbx_shmem_create() param:'HistoryCacheSize' size:16777216
2195604:20220601:094456.884 valid user addresses: [0x7fa75fbf8170, 0x7fa760bf7ff0] total size: 16776832
2195604:20220601:094456.884 End of zbx_shmem_create()
2195604:20220601:094456.884 In zbx_shmem_create() param:'HistoryIndexCacheSize' size:4194304
2195604:20220601:094456.884 valid user addresses: [0x7fa75f7f8180, 0x7fa75fbf7ff0] total size: 4193904
2195604:20220601:094456.884 End of zbx_shmem_create()
2195604:20220601:094456.885 In init_trend_cache()
2195604:20220601:094456.885 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
2195604:20220601:094456.885 End of zbx_shmem_required_size() size:422
2195604:20220601:094456.885 In zbx_shmem_create() param:'TrendCacheSize' size:4194304
2195604:20220601:094456.885 valid user addresses: [0x7fa75f3f8170, 0x7fa75f7f7ff0] total size: 4193920
2195604:20220601:094456.885 End of zbx_shmem_create()
2195604:20220601:094456.885 End of init_trend_cache()
2195604:20220601:094456.885 End of init_database_cache()
2195604:20220601:094456.885 In DBconnect() flag:0
2195604:20220601:094456.967 query without transaction detected
2195604:20220601:094456.967 query [txnlev:0] [alter session set nls_numeric_characters='. ']
2195604:20220601:094456.968 End of DBconnect():0
2195604:20220601:094456.968 query [txnlev:0] [select parameter,value from NLS_DATABASE_PARAMETERS where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET')]
2195604:20220601:094456.971 In DBconnect() flag:0
2195604:20220601:094457.106 query without transaction detected
2195604:20220601:094457.106 query [txnlev:0] [alter session set nls_numeric_characters='. ']
2195604:20220601:094457.106 End of DBconnect():0
2195604:20220601:094457.107 In zbx_dbms_version_info_extract()
2195604:20220601:094457.107 OracleDB version retrieved unparsed: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
2195604:20220601:094457.107 End of zbx_dbms_version_info_extract() version:1903000000
2195604:20220601:094457.108 In DBcheck_version()
2195604:20220601:094457.108 In DBconnect() flag:0
2195604:20220601:094457.144 query without transaction detected
2195604:20220601:094457.144 query [txnlev:0] [alter session set nls_numeric_characters='. ']
2195604:20220601:094457.146 End of DBconnect():0
2195604:20220601:094457.146 query [txnlev:0] [select 1 from tab where tabtype='TABLE' and lower(tname)='dbversion']
2195604:20220601:094457.180 query [txnlev:0] [select mandatory,optional from dbversion]
2195604:20220601:094457.184 current database version (mandatory/optional): 06000000/06000002
2195604:20220601:094457.184 required mandatory version: 06010034
2195604:20220601:094457.184 starting automatic database upgrade
2195604:20220601:094457.184 query [txnlev:1] [update users set passwd='' where length(passwd)=32]
2195604:20220601:094457.191 query [txnlev:1] [update dbversion set mandatory=6010000,optional=6010000]
2195604:20220601:094457.197 completed 2% of database upgrade
2195604:20220601:094457.197 query [txnlev:1] [alter table config add vault_provider number(10) default '0' not null]
2195604:20220601:094457.277 query [txnlev:1] [update dbversion set mandatory=6010001,optional=6010001]
2195604:20220601:094457.283 completed 5% of database upgrade
2195604:20220601:094457.283 query [txnlev:1] [select triggerid,description from triggers where length(description)>255]
2195604:20220601:094457.292 query [txnlev:1] [update dbversion set mandatory=6010002,optional=6010002]
2195604:20220601:094457.297 completed 8% of database upgrade
2195604:20220601:094457.297 query [txnlev:1] [alter table triggers modify description nvarchar2(255)]
2195604:20220601:094457.333 query [txnlev:1] [update dbversion set mandatory=6010003,optional=6010003]
2195604:20220601:094457.338 completed 11% of database upgrade
2195604:20220601:094457.338 query [txnlev:1] [alter table hosts_templates add link_type number(10) default '0' not null]
2195604:20220601:094457.358 query [txnlev:1] [update dbversion set mandatory=6010004,optional=6010004]
2195604:20220601:094457.368 completed 14% of database upgrade
2195604:20220601:094457.368 query [txnlev:1] [select ht.hosttemplateid from hosts_templates ht, hosts h where ht.hostid=h.hostid and h.flags=4]
2195604:20220601:094457.405 query [txnlev:1] [update dbversion set mandatory=6010005,optional=6010005]
2195604:20220601:094457.412 completed 17% of database upgrade
2195604:20220601:094457.412 query [txnlev:1] [create table userdirectory (
userdirectoryid number(20) not null,
name nvarchar2(128) default '',
description nvarchar2(2048) default '',
host nvarchar2(255) default '',
port number(10) default '389' not null,
base_dn nvarchar2(255) default '',
bind_dn nvarchar2(255) default '',
bind_password nvarchar2(128) default '',
search_attribute nvarchar2(128) default '',
start_tls number(10) default '0' not null,
search_filter nvarchar2(255) default '',
primary key (userdirectoryid)
)]
2195604:20220601:094457.445 query [txnlev:1] [update dbversion set mandatory=6010006,optional=6010006]
2195604:20220601:094457.451 completed 20% of database upgrade
2195604:20220601:094457.451 query [txnlev:1] [alter table config add ldap_userdirectoryid number(20)]
2195604:20220601:094457.467 query [txnlev:1] [update dbversion set mandatory=6010007,optional=6010007]
2195604:20220601:094457.473 completed 23% of database upgrade
2195604:20220601:094457.473 query [txnlev:1] [alter table config add constraint c_config_3 foreign key (ldap_userdirectoryid) references userdirectory (userdirectoryid)]
2195604:20220601:094457.489 query [txnlev:1] [update dbversion set mandatory=6010008,optional=6010008]
2195604:20220601:094457.494 completed 26% of database upgrade
2195604:20220601:094457.495 query [txnlev:1] [create index config_3 on config (ldap_userdirectoryid)]
2195604:20220601:094457.507 query [txnlev:1] [update dbversion set mandatory=6010009,optional=6010009]
2195604:20220601:094457.512 completed 29% of database upgrade
2195604:20220601:094457.512 query [txnlev:1] [alter table usrgrp add userdirectoryid number(20)]
2195604:20220601:094457.527 query [txnlev:1] [update dbversion set mandatory=6010010,optional=6010010]
2195604:20220601:094457.532 completed 32% of database upgrade
2195604:20220601:094457.533 query [txnlev:1] [alter table usrgrp add constraint c_usrgrp_2 foreign key (userdirectoryid) references userdirectory (userdirectoryid)]
2195604:20220601:094457.549 query [txnlev:1] [update dbversion set mandatory=6010011,optional=6010011]
2195604:20220601:094457.554 completed 35% of database upgrade
2195604:20220601:094457.554 query [txnlev:1] [create index usrgrp_2 on usrgrp (userdirectoryid)]
2195604:20220601:094457.567 query [txnlev:1] [update dbversion set mandatory=6010012,optional=6010012]
2195604:20220601:094457.573 completed 38% of database upgrade
2195604:20220601:094457.573 query [txnlev:1] [select ldap_host,ldap_port,ldap_base_dn,ldap_bind_dn,ldap_bind_password,ldap_search_attribute from config where ldap_configured=1]
2195604:20220601:094457.576 query [txnlev:1] [update dbversion set mandatory=6010013,optional=6010013]
2195604:20220601:094457.581 completed 41% of database upgrade
2195604:20220601:094457.581 query [txnlev:1] [update config set ldap_userdirectoryid=1 where ldap_configured=1]
2195604:20220601:094457.583 query [txnlev:1] [update dbversion set mandatory=6010014,optional=6010014]
2195604:20220601:094457.588 completed 44% of database upgrade
2195604:20220601:094457.588 query [txnlev:1] [alter table config drop column ldap_host]
2195604:20220601:094457.777 query [txnlev:1] [update dbversion set mandatory=6010015,optional=6010015]
2195604:20220601:094457.782 completed 47% of database upgrade
2195604:20220601:094457.782 query [txnlev:1] [alter table config drop column ldap_port]
2195604:20220601:094457.824 query [txnlev:1] [update dbversion set mandatory=6010016,optional=6010016]
2195604:20220601:094457.834 completed 50% of database upgrade
2195604:20220601:094457.835 query [txnlev:1] [alter table config drop column ldap_base_dn]
2195604:20220601:094457.896 query [txnlev:1] [update dbversion set mandatory=6010017,optional=6010017]
2195604:20220601:094457.903 completed 52% of database upgrade
2195604:20220601:094457.903 query [txnlev:1] [alter table config drop column ldap_bind_dn]
2195604:20220601:094457.956 query [txnlev:1] [update dbversion set mandatory=6010018,optional=6010018]
2195604:20220601:094457.961 completed 55% of database upgrade
2195604:20220601:094457.961 query [txnlev:1] [alter table config drop column ldap_bind_password]
2195604:20220601:094458.001 query [txnlev:1] [update dbversion set mandatory=6010019,optional=6010019]
2195604:20220601:094458.006 completed 58% of database upgrade
2195604:20220601:094458.007 query [txnlev:1] [alter table config drop column ldap_search_attribute]
2195604:20220601:094458.057 query [txnlev:1] [update dbversion set mandatory=6010020,optional=6010020]
2195604:20220601:094458.063 completed 61% of database upgrade
2195604:20220601:094458.063 query [txnlev:1] [create table host_rtdata (
hostid number(20) not null,
active_available number(10) default '0' not null,
primary key (hostid)
)]
2195604:20220601:094458.076 query [txnlev:1] [update dbversion set mandatory=6010021,optional=6010021]
2195604:20220601:094458.082 completed 64% of database upgrade
2195604:20220601:094458.082 query [txnlev:1] [alter table host_rtdata add constraint c_host_rtdata_1 foreign key (hostid) references hosts (hostid) on delete cascade]
2195604:20220601:094458.096 query [txnlev:1] [update dbversion set mandatory=6010022,optional=6010022]
2195604:20220601:094458.100 completed 67% of database upgrade
2195604:20220601:094458.101 query [txnlev:1] [select hostid from hosts where flags!=2 and status in (0,1)]
2195604:20220601:094458.103 query [txnlev:1] [insert into host_rtdata (hostid,active_available) values (:1,:2)]
2195604:20220601:094458.104 insert [txnlev:1] [10084,0]
2195604:20220601:094458.104 insert [txnlev:1] [10524,0]
2195604:20220601:094458.104 insert [txnlev:1] [10525,0]
2195604:20220601:094458.104 insert [txnlev:1] [10526,0]
2195604:20220601:094458.104 insert [txnlev:1] [10530,0]
2195604:20220601:094458.104 insert [txnlev:1] [10531,0]
2195604:20220601:094458.104 insert [txnlev:1] [10537,0]
2195604:20220601:094458.104 insert [txnlev:1] [10538,0]
2195604:20220601:094458.104 insert [txnlev:1] [10539,0]
2195604:20220601:094458.113 zbx_db_statement_execute():9
2195604:20220601:094458.113 query [txnlev:1] [update dbversion set mandatory=6010023,optional=6010023]
2195604:20220601:094458.118 completed 70% of database upgrade
2195604:20220601:094458.118 query [txnlev:1] [select hi.itemid,hi.type,ht.name from httptestitem hi,httptest ht where hi.httptestid=ht.httptestid]
2195604:20220601:094458.127 query [txnlev:1] [update dbversion set mandatory=6010024,optional=6010024]
2195604:20220601:094458.132 completed 73% of database upgrade
2195604:20220601:094458.133 query [txnlev:1] [select hi.itemid,hi.type,hs.name,ht.name from httpstepitem hi,httpstep hs,httptest ht where hi.httpstepid=hs.httpstepid and hs.httptestid=ht.httptestid]
2195604:20220601:094458.148 query [txnlev:1] [update dbversion set mandatory=6010025,optional=6010025]
2195604:20220601:094458.153 completed 76% of database upgrade
2195604:20220601:094458.154 query [txnlev:1] [delete from profiles where idx='web.auditlog.filter.action' and value_int=-1]
2195604:20220601:094458.160 query [txnlev:1] [update dbversion set mandatory=6010026,optional=6010026]
2195604:20220601:094458.164 completed 79% of database upgrade
2195604:20220601:094458.164 query [txnlev:1] [delete from role_rule where value_str='trigger.adddependencies' or value_str='trigger.deletedependencies']
2195604:20220601:094458.170 query [txnlev:1] [update dbversion set mandatory=6010028,optional=6010028]
2195604:20220601:094458.175 completed 82% of database upgrade
2195604:20220601:094458.175 query [txnlev:1] [alter table hstgrp drop column internal]
2195604:20220601:094458.197 query [txnlev:1] [update dbversion set mandatory=6010029,optional=6010029]
2195604:20220601:094458.203 completed 85% of database upgrade
2195604:20220601:094458.203 query [txnlev:1] [alter table hstgrp add type number(10) default '0' not null]
2195604:20220601:094458.216 query [txnlev:1] [update dbversion set mandatory=6010030,optional=6010030]
2195604:20220601:094458.222 completed 88% of database upgrade
2195604:20220601:094458.222 query [txnlev:1] [drop index hstgrp_1]
2195604:20220601:094458.367 query [txnlev:1] [update dbversion set mandatory=6010031,optional=6010031]
2195604:20220601:094458.373 completed 91% of database upgrade
2195604:20220601:094458.373 query [txnlev:1] [create unique index hstgrp_1 on hstgrp (type,name)]
2195604:20220601:094458.389 query [txnlev:1] [update dbversion set mandatory=6010032,optional=6010032]
2195604:20220601:094458.395 completed 94% of database upgrade
2195604:20220601:094458.395 query [txnlev:1] [select groupid,name,uuid from hstgrp order by length(name)]
2195604:20220601:094458.400 query [txnlev:1] [select distinct g.groupid from hstgrp g,hosts_groups hg,hosts h where g.groupid=hg.groupid and hg.hostid=h.hostid and h.status<>3]
2195604:20220601:094458.406 query [txnlev:1] [select distinct groupid from group_prototype where groupid is not null]
2195604:20220601:094458.409 query [txnlev:1] [select distinct discovery_groupid from config where discovery_groupid is not null]
2195604:20220601:094458.412 query [txnlev:1] [select distinct groupid from corr_condition_group where groupid is not null]
2195604:20220601:094458.415 query [txnlev:1] [select distinct groupid from group_discovery where groupid is not null]
2195604:20220601:094458.417 query [txnlev:1] [select distinct groupid from maintenances_groups where groupid is not null]
2195604:20220601:094458.419 query [txnlev:1] [select distinct groupid from opcommand_grp where groupid is not null]
2195604:20220601:094458.423 query [txnlev:1] [select distinct groupid from opgroup where groupid is not null]
2195604:20220601:094458.427 query [txnlev:1] [select distinct groupid from scripts where groupid is not null]
2195604:20220601:094458.431 query [txnlev:1] [select distinct g.groupid from hstgrp g,hosts_groups hg,hosts h where g.groupid=hg.groupid and hg.hostid=h.hostid and h.status=3]
2195604:20220601:094458.443 query [txnlev:1] [update hstgrp set type=0 where groupid=26]
2195604:20220601:094458.445 query [txnlev:1] [update hstgrp set type=0 where groupid=25]
2195604:20220601:094458.447 query [txnlev:1] [update hstgrp set type=0 where groupid=2]
2195604:20220601:094458.448 query [txnlev:1] [update hstgrp set type=1 where groupid=16]
2195604:20220601:094458.451 query [txnlev:1] [update hstgrp set type=0 where groupid=4]
2195604:20220601:094458.452 query [txnlev:1] [update hstgrp set type=1 where groupid=18]
2195604:20220601:094458.453 query [txnlev:1] [update hstgrp set type=0 where groupid=5]
2195604:20220601:094458.454 query [txnlev:1] [update hstgrp set type=1 where groupid=8]
2195604:20220601:094458.456 query [txnlev:1] [update hstgrp set type=1 where groupid=15]
2195604:20220601:094458.458 query [txnlev:1] [update hstgrp set type=0 where groupid=21]
2195604:20220601:094458.460 query [txnlev:1] [update hstgrp set type=1 where groupid=22]
2195604:20220601:094458.461 query [txnlev:1] [update hstgrp set type=1 where groupid=11]
2195604:20220601:094458.463 query [txnlev:1] [update hstgrp set type=1 where groupid=9]
2195604:20220601:094458.464 query [txnlev:1] [update hstgrp set type=1 where groupid=10]
2195604:20220601:094458.466 query [txnlev:1] [update hstgrp set type=1 where groupid=17]
2195604:20220601:094458.467 query [txnlev:1] [update hstgrp set type=0 where groupid=1]
2195604:20220601:094458.469 query [txnlev:1] [update hstgrp set type=0 where groupid=7]
2195604:20220601:094458.471 query [txnlev:1] [update hstgrp set type=0 where groupid=6]
2195604:20220601:094458.472 query [txnlev:1] [update hstgrp set type=0 where groupid=14]
2195604:20220601:094458.473 In DBget_nextid() tablename:'hstgrp'
2195604:20220601:094458.473 query [txnlev:1] [select nextid from ids where table_name='hstgrp' and field_name='groupid']
2195604:20220601:094458.475 query [txnlev:1] [update ids set nextid=nextid+7 where table_name='hstgrp' and field_name='groupid']
2195604:20220601:094458.476 query [txnlev:1] [select nextid from ids where table_name='hstgrp' and field_name='groupid']
2195604:20220601:094458.476 End of DBget_nextid():27 table:'hstgrp' recid:'groupid'
2195604:20220601:094458.476 query [txnlev:1] [insert into hstgrp (groupid,name,type,uuid) values (:1,:2,:3,:4)]
2195604:20220601:094458.476 insert [txnlev:1] [27,'Templates',1,'7df96b18c230490a9a0a9e2307226338']
2195604:20220601:094458.476 insert [txnlev:1] [28,'Templates/Databases',1,'748ad4d098d447d492bb935c907f652f']
2195604:20220601:094458.476 insert [txnlev:1] [29,'dependency_host_group',1,'8cf68d6b92a040059fe5870294b29b58']
2195604:20220601:094458.476 insert [txnlev:1] [30,'Templates/Applications',1,'a571c0d144b14fd4a87a9d9b2aa9fcd6']
2195604:20220601:094458.476 insert [txnlev:1] [31,'aaa_for_discovered_host',1,'ecbde4c80ef94d3e9ab433153fde82d6']
2195604:20220601:094458.476 insert [txnlev:1] [32,'aaa_for_template_for_host_prototype',1,'7c501e9e918f4736a52ec5c92d3fa106']
2195604:20220601:094458.476 insert [txnlev:1] [33,'AAA_host_group_connect_to_temp_and_host',1,'7bba7087908545c5b4e6c5813aef9841']
2195604:20220601:094458.479 zbx_db_statement_execute():7
2195604:20220601:094458.479 query [txnlev:1] [select groupid,permission from rights where id=1]
2195604:20220601:094458.484 query [txnlev:1] [ hosts_groups set groupid=27 where groupid=1 and hostid in (select hostid from hosts where status=3)]
2195604:20220601:094458.489 [Z3008] query failed due to primary key constraint: [-1] ORA-00900: invalid SQL statement
2195604:20220601:094458.489 query [ hosts_groups set groupid=27 where groupid=1 and hostid in (select hostid from hosts where status=3)] failed, setting transaction as failed
2195604:20220601:094458.494 database upgrade failed
2195604:20220601:094458.495 End of DBcheck_version():FAIL
2195604:20220601:094458.495 In DBconnect() flag:0
2195604:20220601:094458.536 query without transaction detected
2195604:20220601:094458.536 query [txnlev:0] [alter session set nls_numeric_characters='. ']
2195604:20220601:094458.536 End of DBconnect():0
2195604:20220601:094458.536 query [txnlev:0] [select 1 from col where lower(tname)='config' and lower(cname)='dbversion_status']
2195604:20220601:094458.553 query [txnlev:0] [select 1 from user_constraints where constraint_type='P' and table_name='HISTORY']
2195604:20220601:094458.812 In DBflush_version_requirements()
2195604:20220601:094458.812 query without transaction detected
2195604:20220601:094458.812 query [txnlev:0] [update config set dbversion_status='[{"database":"Oracle","current_version":"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0","min_version":"Database 12c Release 12.01.00.02.x","max_version":"Database 21c Release 21.x.x","history_pk":1,"min_supported_version":"Database 19c Release 19.x.x","flag":0}]']
2195604:20220601:094458.821 End of DBflush_version_requirements()