1681228:20240130:151242.911 Starting Zabbix Server. Zabbix 7.0.0beta1 (revision 9bc845eca94).
1681228:20240130:151242.913 ****** Enabled features ******
1681228:20240130:151242.914 SNMP monitoring:           YES
1681228:20240130:151242.916 IPMI monitoring:           YES
1681228:20240130:151242.916 Web monitoring:            YES
1681228:20240130:151242.916 VMware monitoring:         YES
1681228:20240130:151242.916 SMTP authentication:       YES
1681228:20240130:151242.917 ODBC:                      YES
1681228:20240130:151242.917 SSH support:               YES
1681228:20240130:151242.917 IPv6 support:              YES
1681228:20240130:151242.917 TLS support:               YES
1681228:20240130:151242.917 ******************************
1681228:20240130:151242.918 using configuration file: /etc/zabbix/zabbix_server.conf
1681228:20240130:151242.918 In zbx_load_modules()
1681228:20240130:151242.918 End of zbx_load_modules():SUCCEED
1681228:20240130:151242.918 In zbx_ipc_service_start() service:rtc
1681228:20240130:151242.918 In zbx_ipc_socket_open()
1681228:20240130:151242.919 End of zbx_ipc_socket_open():FAIL
1681228:20240130:151242.919 End of zbx_ipc_service_start():SUCCEED
1681228:20240130:151243.292 End of zbx_http_get():SUCCEED
1681228:20240130:151243.292 In zbx_db_get_database_type()
1681228:20240130:151243.292 In zbx_db_connect() flag:0
1681228:20240130:151243.301 query [txnlev:0] [select oid from pg_type where typname='bytea']
1681228:20240130:151243.312 query without transaction detected
1681228:20240130:151243.313 query [txnlev:0] [set escape_string_warning to off]
1681228:20240130:151243.313 query without transaction detected
1681228:20240130:151243.313 query [txnlev:0] [set extra_float_digits to 3]
1681228:20240130:151243.314 query [txnlev:0] [show standard_conforming_strings]
1681228:20240130:151243.314 End of zbx_db_connect():0
1681228:20240130:151243.314 query [txnlev:0] [select userid from users limit 1]
1681228:20240130:151243.316 there is at least 1 record in "users" table
1681228:20240130:151243.317 End of zbx_db_get_database_type():ZBX_DB_SERVER
1681228:20240130:151243.317 In zbx_init_database_cache()
1681228:20240130:151243.317 In zbx_shmem_create() param:'HistoryCacheSize' size:134217728
1681228:20240130:151243.318 valid user addresses: [0x7fc4b0000170, 0x7fc4b7fffff0] total size: 134217344
1681228:20240130:151243.318 End of zbx_shmem_create()
1681228:20240130:151243.318 In zbx_shmem_create() param:'HistoryIndexCacheSize' size:33554432
1681228:20240130:151243.318 valid user addresses: [0x7fc4bc0d2180, 0x7fc4be0d1ff0] total size: 33554032
1681228:20240130:151243.319 End of zbx_shmem_create()
1681228:20240130:151243.319 In init_trend_cache()
1681228:20240130:151243.319 In zbx_shmem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
1681228:20240130:151243.319 End of zbx_shmem_required_size() size:422
1681228:20240130:151243.320 In zbx_shmem_create() param:'TrendCacheSize' size:4194304
1681228:20240130:151243.320 valid user addresses: [0x7fc4afc00170, 0x7fc4affffff0] total size: 4193920
1681228:20240130:151243.320 End of zbx_shmem_create()
1681228:20240130:151243.320 End of init_trend_cache()
1681228:20240130:151243.321 End of zbx_init_database_cache()
1681228:20240130:151243.321 In zbx_db_connect() flag:0
1681228:20240130:151243.328 query [txnlev:0] [select oid from pg_type where typname='bytea']
1681228:20240130:151243.338 query without transaction detected
1681228:20240130:151243.339 query [txnlev:0] [set escape_string_warning to off]
1681228:20240130:151243.339 query without transaction detected
1681228:20240130:151243.339 query [txnlev:0] [set extra_float_digits to 3]
1681228:20240130:151243.340 query [txnlev:0] [show standard_conforming_strings]
1681228:20240130:151243.340 End of zbx_db_connect():0
1681228:20240130:151243.340 query [txnlev:0] [select pg_encoding_to_char(encoding) from pg_database where datname='zabbix']
1681228:20240130:151243.341 query [txnlev:0] [select oid from pg_namespace where nspname='public']
1681228:20240130:151243.342 query [txnlev:0] [select count(*) from pg_attribute as a left join pg_class as c on c.relfilenode=a.attrelid left join pg_collation as l on l.oid=a.attcollation where atttypid in (25,1043) and c.relnamespace=2200 and c.relam=0 and l.collname<>'default']
1681228:20240130:151243.347 query [txnlev:0] [show client_encoding]
1681228:20240130:151243.347 query [txnlev:0] [show server_encoding]
1681228:20240130:151243.349 In zbx_db_connect() flag:0
1681228:20240130:151243.357 query [txnlev:0] [select oid from pg_type where typname='bytea']
1681228:20240130:151243.368 query without transaction detected
1681228:20240130:151243.369 query [txnlev:0] [set escape_string_warning to off]
1681228:20240130:151243.369 query without transaction detected
1681228:20240130:151243.370 query [txnlev:0] [set extra_float_digits to 3]
1681228:20240130:151243.370 query [txnlev:0] [show standard_conforming_strings]
1681228:20240130:151243.371 End of zbx_db_connect():0
1681228:20240130:151243.371 In zbx_dbms_version_info_extract()
1681228:20240130:151243.371 End of zbx_dbms_version_info_extract() version:150004
1681228:20240130:151243.372 In zbx_db_check_extension()
1681228:20240130:151243.372 In zbx_db_connect() flag:0
1681228:20240130:151243.380 query [txnlev:0] [select oid from pg_type where typname='bytea']
1681228:20240130:151243.391 query without transaction detected
1681228:20240130:151243.392 query [txnlev:0] [set escape_string_warning to off]
1681228:20240130:151243.392 query without transaction detected
1681228:20240130:151243.392 query [txnlev:0] [set extra_float_digits to 3]
1681228:20240130:151243.393 query [txnlev:0] [show standard_conforming_strings]
1681228:20240130:151243.393 query without transaction detected
1681228:20240130:151243.394 query [txnlev:0] [set bytea_output=escape]
1681228:20240130:151243.394 End of zbx_db_connect():0
1681228:20240130:151243.394 query [txnlev:0] [select 1 from information_schema.columns where table_name='config' and column_name='db_extension' and table_schema='public']
1681228:20240130:151243.406 query [txnlev:0] [select db_extension from config]
1681228:20240130:151243.408 query [txnlev:0] [select extversion from pg_extension where extname = 'timescaledb']
1681228:20240130:151243.409 TimescaleDB version: [21100]
1681228:20240130:151243.409 query [txnlev:0] [show timescaledb.license]
1681228:20240130:151243.410 query [txnlev:0] [select null from timescaledb_information.chunks where hypertable_name in ('history_uint','history_log','history_str','history_text','history') and is_compressed='t']
1681228:20240130:151243.421 query [txnlev:0] [select null from timescaledb_information.chunks where hypertable_name in ('trends','trends_uint') and is_compressed='t']
1681228:20240130:151243.426 TimescaleDB license: [timescale]
1681228:20240130:151243.426 TimescaleDB Community Edition was detected. TimescaleDB compression is supported.
1681228:20240130:151243.427 End of zbx_db_check_extension():SUCCEED
1681228:20240130:151243.427 In zbx_db_check_version_and_upgrade()
1681228:20240130:151243.427 In zbx_db_connect() flag:0
1681228:20240130:151243.436 query [txnlev:0] [select oid from pg_type where typname='bytea']
1681228:20240130:151243.447 query without transaction detected
1681228:20240130:151243.448 query [txnlev:0] [set escape_string_warning to off]
1681228:20240130:151243.448 query without transaction detected
1681228:20240130:151243.449 query [txnlev:0] [set extra_float_digits to 3]
1681228:20240130:151243.449 query [txnlev:0] [show standard_conforming_strings]
1681228:20240130:151243.450 query without transaction detected
1681228:20240130:151243.450 query [txnlev:0] [set bytea_output=escape]
1681228:20240130:151243.451 End of zbx_db_connect():0
1681228:20240130:151243.451 query [txnlev:0] [select 1 from information_schema.tables where table_name='dbversion' and table_schema='public']
1681228:20240130:151243.456 query [txnlev:0] [select mandatory,optional from dbversion]
1681228:20240130:151243.457 current database version (mandatory/optional): 06050200/06050200
1681228:20240130:151243.457 required mandatory version: 06050209
1681228:20240130:151243.458 mandatory patches were found
1681228:20240130:151243.459 query [txnlev:0] [select 1 from information_schema.tables where table_name='ha_node' and table_schema='public']
1681228:20240130:151243.460 query [txnlev:1] [begin;]
1681228:20240130:151243.460 query [txnlev:1] [select cast(extract(epoch from now()) as int),ha_failover_delay from config]
1681228:20240130:151243.463 query [txnlev:1] [select lastaccess,name from ha_node where status not in (1,2) order by ha_nodeid for update]
1681228:20240130:151243.464 query [txnlev:1] [commit;]
1681228:20240130:151243.465 starting automatic database upgrade
1681228:20240130:151243.465 query [txnlev:1] [begin;]
1681228:20240130:151243.466 query [txnlev:1] [select optional,mandatory from dbversion for update]
1681228:20240130:151243.466 query [txnlev:1] [select hostid from hosts where flags<>2]
1681228:20240130:151243.469 query [txnlev:1] [select groupid from hosts_groups where hostid=27 order by groupid]
1681228:20240130:151243.471 query [txnlev:1] [select groupid from hosts_groups where hostid=28 order by groupid]
1681228:20240130:151243.471 query [txnlev:1] [select groupid from hosts_groups where hostid=36 order by groupid]
1681228:20240130:151243.472 query [txnlev:1] [select groupid from hosts_groups where hostid=62 order by groupid]
1681228:20240130:151243.472 query [txnlev:1] [select groupid from hosts_groups where hostid=110 order by groupid]
1681228:20240130:151243.473 query [txnlev:1] [select groupid from hosts_groups where hostid=140 order by groupid]
1681228:20240130:151243.473 query [txnlev:1] [select groupid from hosts_groups where hostid=149 order by groupid]
1681228:20240130:151243.474 query [txnlev:1] [select groupid from hosts_groups where hostid=172 order by groupid]
1681228:20240130:151243.474 query [txnlev:1] [select groupid from hosts_groups where hostid=173 order by groupid]
1681228:20240130:151243.475 query [txnlev:1] [select groupid from hosts_groups where hostid=175 order by groupid]
1681228:20240130:151243.475 query [txnlev:1] [select groupid from hosts_groups where hostid=176 order by groupid]
1681228:20240130:151243.476 query [txnlev:1] [select groupid from hosts_groups where hostid=178 order by groupid]
1681228:20240130:151243.476 query [txnlev:1] [select groupid from hosts_groups where hostid=179 order by groupid]
1681228:20240130:151243.477 query [txnlev:1] [select groupid from hosts_groups where hostid=180 order by groupid]
1681228:20240130:151243.477 query [txnlev:1] [select groupid from hosts_groups where hostid=181 order by groupid]
1681228:20240130:151243.478 query [txnlev:1] [select groupid from hosts_groups where hostid=182 order by groupid]
1681228:20240130:151243.478 query [txnlev:1] [select groupid from hosts_groups where hostid=183 order by groupid]
1681228:20240130:151243.479 query [txnlev:1] [select groupid from hosts_groups where hostid=184 order by groupid]
1681228:20240130:151243.479 query [txnlev:1] [select groupid from hosts_groups where hostid=185 order by groupid]
1681228:20240130:151243.479 query [txnlev:1] [select groupid from hosts_groups where hostid=186 order by groupid]
1681228:20240130:151243.480 query [txnlev:1] [select groupid from hosts_groups where hostid=187 order by groupid]
1681228:20240130:151243.480 query [txnlev:1] [select groupid from hosts_groups where hostid=188 order by groupid]
1681228:20240130:151243.481 query [txnlev:1] [select groupid from hosts_groups where hostid=189 order by groupid]
1681228:20240130:151243.481 query [txnlev:1] [select groupid from hosts_groups where hostid=190 order by groupid]
1681228:20240130:151243.482 query [txnlev:1] [select groupid from hosts_groups where hostid=191 order by groupid]
1681228:20240130:151243.482 query [txnlev:1] [select groupid from hosts_groups where hostid=193 order by groupid]
1681228:20240130:151243.483 query [txnlev:1] [select groupid from hosts_groups where hostid=194 order by groupid]
1681228:20240130:151243.483 query [txnlev:1] [select groupid from hosts_groups where hostid=195 order by groupid]
1681228:20240130:151243.484 query [txnlev:1] [select groupid from hosts_groups where hostid=196 order by groupid]
1681228:20240130:151243.484 query [txnlev:1] [select groupid from hosts_groups where hostid=197 order by groupid]
1681228:20240130:151243.485 query [txnlev:1] [select groupid from hosts_groups where hostid=199 order by groupid]
1681228:20240130:151243.485 query [txnlev:1] [select groupid from hosts_groups where hostid=200 order by groupid]
1681228:20240130:151243.486 query [txnlev:1] [select groupid from hosts_groups where hostid=201 order by groupid]
1681228:20240130:151243.486 query [txnlev:1] [select groupid from hosts_groups where hostid=202 order by groupid]
1681228:20240130:151243.486 query [txnlev:1] [select groupid from hosts_groups where hostid=203 order by groupid]
1681228:20240130:151243.487 query [txnlev:1] [select groupid from hosts_groups where hostid=204 order by groupid]
1681228:20240130:151243.487 query [txnlev:1] [select groupid from hosts_groups where hostid=205 order by groupid]
1681228:20240130:151243.488 query [txnlev:1] [select groupid from hosts_groups where hostid=206 order by groupid]
1681228:20240130:151243.488 query [txnlev:1] [select groupid from hosts_groups where hostid=207 order by groupid]
1681228:20240130:151243.489 query [txnlev:1] [select groupid from hosts_groups where hostid=208 order by groupid]
1681228:20240130:151243.489 query [txnlev:1] [select groupid from hosts_groups where hostid=209 order by groupid]
1681228:20240130:151243.490 query [txnlev:1] [select groupid from hosts_groups where hostid=210 order by groupid]
1681228:20240130:151243.491 query [txnlev:1] [select groupid from hosts_groups where hostid=211 order by groupid]
1681228:20240130:151243.491 query [txnlev:1] [select groupid from hosts_groups where hostid=212 order by groupid]
1681228:20240130:151243.492 query [txnlev:1] [select groupid from hosts_groups where hostid=213 order by groupid]
1681228:20240130:151243.492 query [txnlev:1] [select groupid from hosts_groups where hostid=214 order by groupid]
1681228:20240130:151243.493 query [txnlev:1] [select groupid from hosts_groups where hostid=215 order by groupid]
1681228:20240130:151243.493 query [txnlev:1] [select groupid from hosts_groups where hostid=216 order by groupid]
1681228:20240130:151243.494 query [txnlev:1] [select groupid from hosts_groups where hostid=217 order by groupid]
1681228:20240130:151243.494 query [txnlev:1] [select groupid from hosts_groups where hostid=219 order by groupid]
1681228:20240130:151243.495 query [txnlev:1] [select groupid from hosts_groups where hostid=220 order by groupid]
1681228:20240130:151243.495 query [txnlev:1] [select groupid from hosts_groups where hostid=221 order by groupid]
1681228:20240130:151243.496 query [txnlev:1] [select groupid from hosts_groups where hostid=222 order by groupid]
1681228:20240130:151243.496 query [txnlev:1] [select groupid from hosts_groups where hostid=224 order by groupid]
1681228:20240130:151243.497 query [txnlev:1] [select groupid from hosts_groups where hostid=225 order by groupid]
1681228:20240130:151243.497 query [txnlev:1] [select groupid from hosts_groups where hostid=226 order by groupid]
1681228:20240130:151243.498 query [txnlev:1] [select groupid from hosts_groups where hostid=228 order by groupid]
1681228:20240130:151243.498 query [txnlev:1] [select groupid from hosts_groups where hostid=229 order by groupid]
1681228:20240130:151243.498 query [txnlev:1] [select groupid from hosts_groups where hostid=230 order by groupid]
1681228:20240130:151243.499 query [txnlev:1] [select groupid from hosts_groups where hostid=232 order by groupid]
1681228:20240130:151243.500 query [txnlev:1] [select groupid from hosts_groups where hostid=233 order by groupid]
1681228:20240130:151243.500 query [txnlev:1] [select groupid from hosts_groups where hostid=234 order by groupid]
1681228:20240130:151243.501 query [txnlev:1] [select groupid from hosts_groups where hostid=235 order by groupid]
1681228:20240130:151243.501 query [txnlev:1] [select groupid from hosts_groups where hostid=237 order by groupid]
1681228:20240130:151243.502 query [txnlev:1] [select groupid from hosts_groups where hostid=238 order by groupid]
1681228:20240130:151243.502 query [txnlev:1] [select groupid from hosts_groups where hostid=262 order by groupid]
1681228:20240130:151243.503 query [txnlev:1] [select groupid from hosts_groups where hostid=266 order by groupid]
1681228:20240130:151243.503 query [txnlev:1] [select groupid from hosts_groups where hostid=271 order by groupid]
1681228:20240130:151243.504 query [txnlev:1] [select groupid from hosts_groups where hostid=279 order by groupid]
1681228:20240130:151243.504 query [txnlev:1] [select groupid from hosts_groups where hostid=282 order by groupid]
1681228:20240130:151243.505 query [txnlev:1] [select groupid from hosts_groups where hostid=299 order by groupid]
1681228:20240130:151243.505 query [txnlev:1] [select groupid from hosts_groups where hostid=305 order by groupid]
1681228:20240130:151243.506 query [txnlev:1] [select groupid from hosts_groups where hostid=308 order by groupid]
1681228:20240130:151243.506 query [txnlev:1] [select groupid from hosts_groups where hostid=314 order by groupid]
1681228:20240130:151243.506 query [txnlev:1] [select groupid from hosts_groups where hostid=321 order by groupid]
1681228:20240130:151243.507 query [txnlev:1] [select groupid from hosts_groups where hostid=322 order by groupid]
1681228:20240130:151243.507 query [txnlev:1] [select groupid from hosts_groups where hostid=324 order by groupid]
1681228:20240130:151243.508 query [txnlev:1] [select groupid from hosts_groups where hostid=341 order by groupid]
1681228:20240130:151243.508 query [txnlev:1] [select groupid from hosts_groups where hostid=342 order by groupid]
1681228:20240130:151243.509 query [txnlev:1] [select groupid from hosts_groups where hostid=345 order by groupid]
1681228:20240130:151243.509 query [txnlev:1] [select groupid from hosts_groups where hostid=346 order by groupid]
1681228:20240130:151243.510 query [txnlev:1] [select groupid from hosts_groups where hostid=347 order by groupid]
1681228:20240130:151243.510 query [txnlev:1] [select groupid from hosts_groups where hostid=348 order by groupid]
1681228:20240130:151243.510 query [txnlev:1] [select groupid from hosts_groups where hostid=349 order by groupid]
1681228:20240130:151243.511 query [txnlev:1] [select groupid from hosts_groups where hostid=350 order by groupid]
1681228:20240130:151243.511 query [txnlev:1] [select groupid from hosts_groups where hostid=351 order by groupid]
1681228:20240130:151243.512 query [txnlev:1] [select groupid from hosts_groups where hostid=357 order by groupid]
1681228:20240130:151243.512 query [txnlev:1] [select groupid from hosts_groups where hostid=364 order by groupid]
1681228:20240130:151243.512 query [txnlev:1] [select groupid from hosts_groups where hostid=366 order by groupid]
1681228:20240130:151243.513 query [txnlev:1] [select groupid from hosts_groups where hostid=374 order by groupid]
1681228:20240130:151243.513 query [txnlev:1] [select groupid from hosts_groups where hostid=421 order by groupid]
1681228:20240130:151243.514 query [txnlev:1] [select groupid from hosts_groups where hostid=572 order by groupid]
1681228:20240130:151243.514 query [txnlev:1] [select groupid from hosts_groups where hostid=575 order by groupid]
1681228:20240130:151243.515 query [txnlev:1] [select groupid from hosts_groups where hostid=576 order by groupid]
1681228:20240130:151243.515 query [txnlev:1] [select groupid from hosts_groups where hostid=577 order by groupid]
1681228:20240130:151243.515 query [txnlev:1] [select groupid from hosts_groups where hostid=578 order by groupid]
1681228:20240130:151243.516 query [txnlev:1] [select groupid from hosts_groups where hostid=580 order by groupid]
1681228:20240130:151243.516 query [txnlev:1] [select groupid from hosts_groups where hostid=584 order by groupid]
1681228:20240130:151243.517 query [txnlev:1] [select groupid from hosts_groups where hostid=587 order by groupid]
1681228:20240130:151243.517 query [txnlev:1] [select groupid from hosts_groups where hostid=588 order by groupid]
1681228:20240130:151243.518 query [txnlev:1] [select groupid from hosts_groups where hostid=590 order by groupid]
1681228:20240130:151243.518 query [txnlev:1] [select groupid from hosts_groups where hostid=592 order by groupid]
1681228:20240130:151243.519 query [txnlev:1] [select groupid from hosts_groups where hostid=598 order by groupid]
1681228:20240130:151243.519 query [txnlev:1] [select groupid from hosts_groups where hostid=599 order by groupid]
1681228:20240130:151243.520 query [txnlev:1] [select groupid from hosts_groups where hostid=601 order by groupid]
1681228:20240130:151243.520 query [txnlev:1] [select groupid from hosts_groups where hostid=602 order by groupid]
1681228:20240130:151243.520 query [txnlev:1] [select groupid from hosts_groups where hostid=603 order by groupid]
1681228:20240130:151243.521 query [txnlev:1] [select groupid from hosts_groups where hostid=611 order by groupid]
1681228:20240130:151243.522 query [txnlev:1] [rollback;]
1681228:20240130:151243.522 database upgrade failed on patch 06050201, exiting in 10 seconds