1930156:20220531:114119.118 Starting Zabbix Server. Zabbix 6.2.0beta3 (revision {ZABBIX_REVISION}).
1930156:20220531:114119.118 ****** Enabled features ******
1930156:20220531:114119.118 SNMP monitoring:           YES
1930156:20220531:114119.118 IPMI monitoring:            NO
1930156:20220531:114119.118 Web monitoring:            YES
1930156:20220531:114119.118 VMware monitoring:         YES
1930156:20220531:114119.118 SMTP authentication:       YES
1930156:20220531:114119.118 ODBC:                       NO
1930156:20220531:114119.118 SSH support:                NO
1930156:20220531:114119.118 IPv6 support:              YES
1930156:20220531:114119.118 TLS support:               YES
1930156:20220531:114119.118 ******************************
1930156:20220531:114119.118 using configuration file: /home/sergejs/workspace/ZBXNEXT-2592-6.1/etc/zabbix_server.conf
1930156:20220531:114119.119 In zbx_load_modules()
1930156:20220531:114119.119 End of zbx_load_modules():SUCCEED
1930156:20220531:114119.119 In zbx_ipc_service_start() service:rtc
1930156:20220531:114119.119 In zbx_ipc_socket_open()
1930156:20220531:114119.119 End of zbx_ipc_socket_open():FAIL
1930156:20220531:114119.119 End of zbx_ipc_service_start():SUCCEED
1930156:20220531:114119.119 In zbx_db_get_database_type()
1930156:20220531:114119.119 In DBconnect() flag:0
1930156:20220531:114119.288 query without transaction detected
1930156:20220531:114119.288 query [txnlev:0] [alter session set nls_numeric_characters='. ']
1930156:20220531:114119.288 End of DBconnect():0
1930156:20220531:114119.288 query [txnlev:0] [select * from (select userid from users) where rownum<=1]
1930156:20220531:114119.292 there is at least 1 record in "users" table
1930156:20220531:114119.293 End of zbx_db_get_database_type():ZBX_DB_SERVER
1930156:20220531:114119.294 In init_database_cache()
1930156:20220531:114119.294 In zbx_shmem_create() param:'HistoryCacheSize' size:16777216
1930156:20220531:114119.294 valid user addresses: [0x7f8ff2f1c170, 0x7f8ff3f1bff0] total size: 16776832
1930156:20220531:114119.294 End of zbx_shmem_create()
1930156:20220531:114119.294 In zbx_shmem_create() param:'HistoryIndexCacheSize' size:4194304
1930156:20220531:114119.294 valid user addresses: [0x7f8ff2b1c180, 0x7f8ff2f1bff0] total size: 4193904
1930156:20220531:114119.294 End of zbx_shmem_create()
1930156:20220531:114119.294 In init_trend_cache()
1930156:20220531:114119.294 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
1930156:20220531:114119.294 End of zbx_shmem_required_size() size:422
1930156:20220531:114119.294 In zbx_shmem_create() param:'TrendCacheSize' size:4194304
1930156:20220531:114119.294 valid user addresses: [0x7f8ff271c170, 0x7f8ff2b1bff0] total size: 4193920
1930156:20220531:114119.294 End of zbx_shmem_create()
1930156:20220531:114119.294 End of init_trend_cache()
1930156:20220531:114119.294 End of init_database_cache()
1930156:20220531:114119.294 In DBconnect() flag:0
1930156:20220531:114119.325 query without transaction detected
1930156:20220531:114119.325 query [txnlev:0] [alter session set nls_numeric_characters='. ']
1930156:20220531:114119.326 End of DBconnect():0
1930156:20220531:114119.326 query [txnlev:0] [select parameter,value from NLS_DATABASE_PARAMETERS where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET')]
1930156:20220531:114119.330 In DBconnect() flag:0
1930156:20220531:114119.441 query without transaction detected
1930156:20220531:114119.441 query [txnlev:0] [alter session set nls_numeric_characters='. ']
1930156:20220531:114119.442 End of DBconnect():0
1930156:20220531:114119.442 In zbx_dbms_version_info_extract()
1930156:20220531:114119.442 OracleDB version retrieved unparsed: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
1930156:20220531:114119.442 End of zbx_dbms_version_info_extract() version:1903000000
1930156:20220531:114119.443 In DBcheck_version()
1930156:20220531:114119.443 In DBconnect() flag:0
1930156:20220531:114119.468 query without transaction detected
1930156:20220531:114119.468 query [txnlev:0] [alter session set nls_numeric_characters='. ']
1930156:20220531:114119.468 End of DBconnect():0
1930156:20220531:114119.468 query [txnlev:0] [select 1 from tab where tabtype='TABLE' and lower(tname)='dbversion']
1930156:20220531:114119.479 query [txnlev:0] [select mandatory,optional from dbversion]
1930156:20220531:114119.485 current database version (mandatory/optional): 06000000/06000002
1930156:20220531:114119.485 required mandatory version: 06010034
1930156:20220531:114119.485 starting automatic database upgrade
1930156:20220531:114119.485 query [txnlev:1] [update users set passwd='' where length(passwd)=32]
1930156:20220531:114119.491 query [txnlev:1] [update dbversion set mandatory=6010000,optional=6010000]
1930156:20220531:114119.496 completed 2% of database upgrade
1930156:20220531:114119.496 query [txnlev:1] [alter table config add vault_provider number(10) default '0' not null]
1930156:20220531:114119.573 query [txnlev:1] [update dbversion set mandatory=6010001,optional=6010001]
1930156:20220531:114119.579 completed 5% of database upgrade
1930156:20220531:114119.579 query [txnlev:1] [select triggerid,description from triggers where length(description)>255]
1930156:20220531:114119.598 query [txnlev:1] [update dbversion set mandatory=6010002,optional=6010002]
1930156:20220531:114119.606 completed 8% of database upgrade
1930156:20220531:114119.606 query [txnlev:1] [alter table triggers modify description nvarchar2(255)]
1930156:20220531:114119.643 query [txnlev:1] [update dbversion set mandatory=6010003,optional=6010003]
1930156:20220531:114119.648 completed 11% of database upgrade
1930156:20220531:114119.648 query [txnlev:1] [alter table hosts_templates add link_type number(10) default '0' not null]
1930156:20220531:114119.664 query [txnlev:1] [update dbversion set mandatory=6010004,optional=6010004]
1930156:20220531:114119.675 completed 14% of database upgrade
1930156:20220531:114119.675 query [txnlev:1] [select ht.hosttemplateid from hosts_templates ht, hosts h where ht.hostid=h.hostid and h.flags=4]
1930156:20220531:114119.705 query [txnlev:1] [update dbversion set mandatory=6010005,optional=6010005]
1930156:20220531:114119.714 completed 17% of database upgrade
1930156:20220531:114119.714 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)
)]
1930156:20220531:114119.759 query [txnlev:1] [update dbversion set mandatory=6010006,optional=6010006]
1930156:20220531:114119.766 completed 20% of database upgrade
1930156:20220531:114119.766 query [txnlev:1] [alter table config add ldap_userdirectoryid number(20)]
1930156:20220531:114119.784 query [txnlev:1] [update dbversion set mandatory=6010007,optional=6010007]
1930156:20220531:114119.789 completed 23% of database upgrade
1930156:20220531:114119.789 query [txnlev:1] [alter table config add constraint c_config_3 foreign key (ldap_userdirectoryid) references userdirectory (userdirectoryid)]
1930156:20220531:114119.804 query [txnlev:1] [update dbversion set mandatory=6010008,optional=6010008]
1930156:20220531:114119.813 completed 26% of database upgrade
1930156:20220531:114119.813 query [txnlev:1] [create index config_3 on config (ldap_userdirectoryid)]
1930156:20220531:114119.836 query [txnlev:1] [update dbversion set mandatory=6010009,optional=6010009]
1930156:20220531:114119.843 completed 29% of database upgrade
1930156:20220531:114119.843 query [txnlev:1] [alter table usrgrp add userdirectoryid number(20)]
1930156:20220531:114119.869 query [txnlev:1] [update dbversion set mandatory=6010010,optional=6010010]
1930156:20220531:114119.880 completed 32% of database upgrade
1930156:20220531:114119.880 query [txnlev:1] [alter table usrgrp add constraint c_usrgrp_2 foreign key (userdirectoryid) references userdirectory (userdirectoryid)]
1930156:20220531:114119.912 query [txnlev:1] [update dbversion set mandatory=6010011,optional=6010011]
1930156:20220531:114119.918 completed 35% of database upgrade
1930156:20220531:114119.918 query [txnlev:1] [create index usrgrp_2 on usrgrp (userdirectoryid)]
1930156:20220531:114119.932 query [txnlev:1] [update dbversion set mandatory=6010012,optional=6010012]
1930156:20220531:114119.938 completed 38% of database upgrade
1930156:20220531:114119.938 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]
1930156:20220531:114119.943 query [txnlev:1] [update dbversion set mandatory=6010013,optional=6010013]
1930156:20220531:114119.948 completed 41% of database upgrade
1930156:20220531:114119.948 query [txnlev:1] [update config set ldap_userdirectoryid=1 where ldap_configured=1]
1930156:20220531:114119.951 query [txnlev:1] [update dbversion set mandatory=6010014,optional=6010014]
1930156:20220531:114119.957 completed 44% of database upgrade
1930156:20220531:114119.957 query [txnlev:1] [alter table config drop column ldap_host]
1930156:20220531:114120.146 query [txnlev:1] [update dbversion set mandatory=6010015,optional=6010015]
1930156:20220531:114120.153 completed 47% of database upgrade
1930156:20220531:114120.153 query [txnlev:1] [alter table config drop column ldap_port]
1930156:20220531:114120.191 query [txnlev:1] [update dbversion set mandatory=6010016,optional=6010016]
1930156:20220531:114120.197 completed 50% of database upgrade
1930156:20220531:114120.197 query [txnlev:1] [alter table config drop column ldap_base_dn]
1930156:20220531:114120.235 query [txnlev:1] [update dbversion set mandatory=6010017,optional=6010017]
1930156:20220531:114120.241 completed 52% of database upgrade
1930156:20220531:114120.241 query [txnlev:1] [alter table config drop column ldap_bind_dn]
1930156:20220531:114120.283 query [txnlev:1] [update dbversion set mandatory=6010018,optional=6010018]
1930156:20220531:114120.288 completed 55% of database upgrade
1930156:20220531:114120.288 query [txnlev:1] [alter table config drop column ldap_bind_password]
1930156:20220531:114120.328 query [txnlev:1] [update dbversion set mandatory=6010019,optional=6010019]
1930156:20220531:114120.333 completed 58% of database upgrade
1930156:20220531:114120.333 query [txnlev:1] [alter table config drop column ldap_search_attribute]
1930156:20220531:114120.370 query [txnlev:1] [update dbversion set mandatory=6010020,optional=6010020]
1930156:20220531:114120.375 completed 61% of database upgrade
1930156:20220531:114120.375 query [txnlev:1] [create table host_rtdata (
hostid number(20) not null,
active_available number(10) default '0' not null,
primary key (hostid)
)]
1930156:20220531:114120.393 query [txnlev:1] [update dbversion set mandatory=6010021,optional=6010021]
1930156:20220531:114120.398 completed 64% of database upgrade
1930156:20220531:114120.398 query [txnlev:1] [alter table host_rtdata add constraint c_host_rtdata_1 foreign key (hostid) references hosts (hostid) on delete cascade]
1930156:20220531:114120.414 query [txnlev:1] [update dbversion set mandatory=6010022,optional=6010022]
1930156:20220531:114120.419 completed 67% of database upgrade
1930156:20220531:114120.420 query [txnlev:1] [select hostid from hosts where flags!=2 and status in (0,1)]
1930156:20220531:114120.422 query [txnlev:1] [insert into host_rtdata (hostid,active_available) values (:1,:2)]
1930156:20220531:114120.423 insert [txnlev:1] [10084,0]
1930156:20220531:114120.430 zbx_db_statement_execute():1
1930156:20220531:114120.430 query [txnlev:1] [update dbversion set mandatory=6010023,optional=6010023]
1930156:20220531:114120.435 completed 70% of database upgrade
1930156:20220531:114120.435 query [txnlev:1] [select hi.itemid,hi.type,ht.name from httptestitem hi,httptest ht where hi.httptestid=ht.httptestid]
1930156:20220531:114120.449 query [txnlev:1] [update dbversion set mandatory=6010024,optional=6010024]
1930156:20220531:114120.454 completed 73% of database upgrade
1930156:20220531:114120.454 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]
1930156:20220531:114120.470 query [txnlev:1] [update dbversion set mandatory=6010025,optional=6010025]
1930156:20220531:114120.476 completed 76% of database upgrade
1930156:20220531:114120.476 query [txnlev:1] [delete from profiles where idx='web.auditlog.filter.action' and value_int=-1]
1930156:20220531:114120.482 query [txnlev:1] [update dbversion set mandatory=6010026,optional=6010026]
1930156:20220531:114120.487 completed 79% of database upgrade
1930156:20220531:114120.488 query [txnlev:1] [delete from role_rule where value_str='trigger.adddependencies' or value_str='trigger.deletedependencies']
1930156:20220531:114120.490 query [txnlev:1] [update dbversion set mandatory=6010028,optional=6010028]
1930156:20220531:114120.495 completed 82% of database upgrade
1930156:20220531:114120.495 query [txnlev:1] [alter table hstgrp drop column internal]
1930156:20220531:114120.519 query [txnlev:1] [update dbversion set mandatory=6010029,optional=6010029]
1930156:20220531:114120.525 completed 85% of database upgrade
1930156:20220531:114120.525 query [txnlev:1] [alter table hstgrp add type number(10) default '0' not null]
1930156:20220531:114120.546 query [txnlev:1] [update dbversion set mandatory=6010030,optional=6010030]
1930156:20220531:114120.551 completed 88% of database upgrade
1930156:20220531:114120.551 query [txnlev:1] [drop index hstgrp_1]
1930156:20220531:114120.714 query [txnlev:1] [update dbversion set mandatory=6010031,optional=6010031]
1930156:20220531:114120.720 completed 91% of database upgrade
1930156:20220531:114120.720 query [txnlev:1] [create unique index hstgrp_1 on hstgrp (type,name)]
1930156:20220531:114120.735 query [txnlev:1] [update dbversion set mandatory=6010032,optional=6010032]
1930156:20220531:114120.740 completed 94% of database upgrade
1930156:20220531:114120.740 query [txnlev:1] [select groupid,name,uuid from hstgrp order by length(name)]
1930156:20220531:114120.749 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]
1930156:20220531:114120.757 query [txnlev:1] [select distinct groupid from group_prototype where groupid is not null]
1930156:20220531:114120.765 query [txnlev:1] [select distinct discovery_groupid from config where discovery_groupid is not null]
1930156:20220531:114120.768 query [txnlev:1] [select distinct groupid from corr_condition_group where groupid is not null]
1930156:20220531:114120.771 query [txnlev:1] [select distinct groupid from group_discovery where groupid is not null]
1930156:20220531:114120.778 query [txnlev:1] [select distinct groupid from maintenances_groups where groupid is not null]
1930156:20220531:114120.781 query [txnlev:1] [select distinct groupid from opcommand_grp where groupid is not null]
1930156:20220531:114120.783 query [txnlev:1] [select distinct groupid from opgroup where groupid is not null]
1930156:20220531:114120.786 query [txnlev:1] [select distinct groupid from scripts where groupid is not null]
1930156:20220531:114120.789 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]
1930156:20220531:114120.802 query [txnlev:1] [update hstgrp set type=1 where groupid=16]
1930156:20220531:114120.805 query [txnlev:1] [update hstgrp set type=0 where groupid=2]
1930156:20220531:114120.807 query [txnlev:1] [update hstgrp set type=0 where groupid=4]
1930156:20220531:114120.809 query [txnlev:1] [update hstgrp set type=1 where groupid=18]
1930156:20220531:114120.811 query [txnlev:1] [update hstgrp set type=0 where groupid=5]
1930156:20220531:114120.812 query [txnlev:1] [update hstgrp set type=1 where groupid=8]
1930156:20220531:114120.813 query [txnlev:1] [update hstgrp set type=1 where groupid=15]
1930156:20220531:114120.814 query [txnlev:1] [update hstgrp set type=1 where groupid=9]
1930156:20220531:114120.815 query [txnlev:1] [update hstgrp set type=1 where groupid=11]
1930156:20220531:114120.817 query [txnlev:1] [update hstgrp set type=1 where groupid=10]
1930156:20220531:114120.818 query [txnlev:1] [update hstgrp set type=1 where groupid=17]
1930156:20220531:114120.819 query [txnlev:1] [update hstgrp set type=0 where groupid=1]
1930156:20220531:114120.819 query [txnlev:1] [update hstgrp set type=0 where groupid=7]
1930156:20220531:114120.820 query [txnlev:1] [update hstgrp set type=0 where groupid=6]
1930156:20220531:114120.822 query [txnlev:1] [update hstgrp set type=0 where groupid=14]
1930156:20220531:114120.823 In DBget_nextid() tablename:'hstgrp'
1930156:20220531:114120.823 query [txnlev:1] [select nextid from ids where table_name='hstgrp' and field_name='groupid']
1930156:20220531:114120.824 query [txnlev:1] [select max(groupid) from hstgrp where groupid between 0 and 9223372036854775807]
1930156:20220531:114120.829 query [txnlev:1] [insert into ids (table_name,field_name,nextid) values ('hstgrp','groupid',18)]
1930156:20220531:114120.830 query [txnlev:1] [select nextid from ids where table_name='hstgrp' and field_name='groupid']
1930156:20220531:114120.830 query [txnlev:1] [update ids set nextid=nextid+3 where table_name='hstgrp' and field_name='groupid']
1930156:20220531:114120.832 query [txnlev:1] [select nextid from ids where table_name='hstgrp' and field_name='groupid']
1930156:20220531:114120.832 End of DBget_nextid():19 table:'hstgrp' recid:'groupid'
1930156:20220531:114120.833 query [txnlev:1] [insert into hstgrp (groupid,name,type,uuid) values (:1,:2,:3,:4)]
1930156:20220531:114120.833 insert [txnlev:1] [19,'Templates',1,'7df96b18c230490a9a0a9e2307226338']
1930156:20220531:114120.833 insert [txnlev:1] [20,'Templates/Databases',1,'748ad4d098d447d492bb935c907f652f']
1930156:20220531:114120.833 insert [txnlev:1] [21,'Templates/Applications',1,'a571c0d144b14fd4a87a9d9b2aa9fcd6']
1930156:20220531:114120.835 zbx_db_statement_execute():3
1930156:20220531:114120.835 query [txnlev:1] [select groupid,permission from rights where id=1]
1930156:20220531:114120.839 query [txnlev:1] [update hosts_groups set groupid=19 where groupid=1 and hostid in (select hostid from hosts where status=3)]
1930156:20220531:114120.846 query [txnlev:1] [select groupid,permission from rights where id=13]
1930156:20220531:114120.851 query [txnlev:1] [update hosts_groups set groupid=20 where groupid=13 and hostid in (select hostid from hosts where status=3)]
1930156:20220531:114120.860 query [txnlev:1] [select groupid,permission from rights where id=12]
1930156:20220531:114120.863 query [txnlev:1] [update hosts_groups set groupid=21 where groupid=12 and hostid in (select hostid from hosts where status=3)]
1930156:20220531:114120.877 query [txnlev:1] [begin
end;]
1930156:20220531:114120.883 [Z3008] query failed due to primary key constraint: [-1] ORA-06550: line 2, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   continue close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge pipe purge
   json_exists json_value json_query json_object json_array
1930156:20220531:114120.883 query [begin
end;] failed, setting transaction as failed
1930156:20220531:114120.903 database upgrade failed
1930156:20220531:114120.904 End of DBcheck_version():FAIL
1930156:20220531:114120.904 In DBconnect() flag:0
1930156:20220531:114120.951 query without transaction detected
1930156:20220531:114120.951 query [txnlev:0] [alter session set nls_numeric_characters='. ']
1930156:20220531:114120.951 End of DBconnect():0
1930156:20220531:114120.951 query [txnlev:0] [select 1 from col where lower(tname)='config' and lower(cname)='dbversion_status']
1930156:20220531:114120.979 query [txnlev:0] [select 1 from user_constraints where constraint_type='P' and table_name='HISTORY']
1930156:20220531:114121.943 In DBflush_version_requirements()
1930156:20220531:114121.943 query without transaction detected
1930156:20220531:114121.943 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}]']
1930156:20220531:114121.949 End of DBflush_version_requirements()