Any experience feedback on migrating zabbix's database from Oracle to PostgreSQL ?

[OPelix]

Hello all,

We are using a Zabbix 4.0.5 (revision 90164) with an Oracle Database 12c Enterprise Edition Release 12.2.0.1.0.
We plan to migrate to PostgreSQL (v12) database using Ora2pg. We have began running some tests, however we are facing some issues.

Can anyone share any information about such database migration. I couldn't find any relevant feedback on Zabbix database migrating from oracle to postgreSQL.

Here's an extract of the latest log generated while trying to start zabbix-server when connected to the postgresql database with the data loaded from Oracle:

119259:20201016:112854.168 In substitute_simple_macros() data:'Zabbix'
119259:20201016:112854.168 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
119259:20201016:112854.168 ====== Fatal information: ======
119259:20201016:112854.168 Program counter: 0x445ab4
119259:20201016:112854.168 === Registers: ===
119259:20201016:112854.168 r8 = 7f5ec7c48060 = 140045055197280 = 140045055197280
119259:20201016:112854.168 r9 = 954083 = 9781379 = 9781379
119259:20201016:112854.168 r10 = 0 = 0 = 0
119259:20201016:112854.168 r11 = 0 = 0 = 0
119259:20201016:112854.168 r12 = 543d53 = 5520723 = 5520723
119259:20201016:112854.168 r13 = 952f30 = 9776944 = 9776944
119259:20201016:112854.168 r14 = 7ffc3fbb6e20 = 140721377734176 = 140721377734176
119259:20201016:112854.168 r15 = 7ffc3fbb6d10 = 140721377733904 = 140721377733904
119259:20201016:112854.168 rdi = 1999999999999999 = 1844674407370955161 = 1844674407370955161
119259:20201016:112854.168 rsi = 0 = 0 = 0
119259:20201016:112854.168 rbp = 953580 = 9778560 = 9778560
119259:20201016:112854.168 rbx = 0 = 0 = 0
119259:20201016:112854.168 rdx = a = 10 = 10
119259:20201016:112854.168 rax = 0 = 0 = 0
119259:20201016:112854.168 rcx = 0 = 0 = 0
119259:20201016:112854.168 rsp = 7ffc3fbb6b30 = 140721377733424 = 140721377733424
119259:20201016:112854.168 rip = 445ab4 = 4479668 = 4479668
119259:20201016:112854.168 efl = 10246 = 66118 = 66118
119259:20201016:112854.168 csgsfs = 33 = 51 = 51
119259:20201016:112854.168 err = 4 = 4 = 4
119259:20201016:112854.168 trapno = e = 14 = 14
119259:20201016:112854.168 oldmask = 0 = 0 = 0
119259:20201016:112854.168 cr2 = 0 = 0 = 0
119259:20201016:112854.168 === Backtrace: ===
119280:20201016:112854.168 PostgreSQL Server version: 120004
119280:20201016:112854.168 query without transaction detected
119280:20201016:112854.169 query [txnlev:0] [set escape_string_warning to off]
119259:20201016:112854.169 11: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](zbx_backtrace+0x2b) [0x4a0f7b]
119259:20201016:112854.169 10: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](zbx_log_fatal_info+0x155) [0x4a1195]
119259:20201016:112854.169 9: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values]() [0x4a1356]
119259:20201016:112854.169 8: /lib64/libpthread.so.0(+0xf630) [0x7f5ec95ca630]
119259:20201016:112854.169 7: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](process_httptests+0x444) [0x445ab4]
119259:20201016:112854.169 6: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](httppoller_thread+0xcc) [0x4452dc]
119259:20201016:112854.169 5: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](zbx_thread_start+0x3e) [0x4a9f9e]
119259:20201016:112854.169 4: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](MAIN_ZABBIX_ENTRY+0x7ed) [0x422d6d]
119259:20201016:112854.169 3: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](daemon_start+0x1a5) [0x4a0a95]
119259:20201016:112854.169 2: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values](main+0x374) [0x421d94]
119259:20201016:112854.169 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f5ec78a2555]
119259:20201016:112854.169 0: /usr/local/sbin/zabbix_server: http poller #8 [got 0 values in 0.000000 sec, getting values]() [0x4220fc]
119259:20201016:112854.169 === Memory map: ===

119321:20201016:112854.332 __zbx_zbx_setproctitle() title:'poller #41 [connecting to the database]'
119321:20201016:112854.332 In DBconnect() flag:0
119271:20201016:112854.332 query without transaction detected
119271:20201016:112854.333 query [txnlev:0] [set escape_string_warning to off]
119276:20201016:112854.333 query [txnlev:0] [select oid from pg_type where typname='bytea']
119289:20201016:112854.333 query without transaction detected
119289:20201016:112854.333 query [txnlev:0] [set schema 'u_2b05']
119328:20201016:112854.333 In zbx_tls_init_child()
119293:20201016:112854.333 In DBconnect() flag:0
119328:20201016:112854.333 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119328:20201016:112854.333 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119328:20201016:112854.333 End of zbx_tls_init_child()
119328:20201016:112854.333 __zbx_zbx_setproctitle() title:'poller #48 [connecting to the database]'
119328:20201016:112854.333 In DBconnect() flag:0
119261:20201016:112854.334 query without transaction detected
119261:20201016:112854.334 query [txnlev:0] [set bytea_output=escape]
119236:20201016:112854.334 One child process died (PID:119259,exitcode/signal:1). Exiting ...
119236:20201016:112854.334 zbx_on_exit() called
119247:20201016:112854.334 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119262:20201016:112854.334 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119293:20201016:112854.334 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119265:20201016:112854.334 query [txnlev:0] [select oid from pg_type where typname='bytea']
119265:20201016:112854.334 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119291:20201016:112854.335 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119343:20201016:112854.335 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119383:20201016:112854.335 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119248:20201016:112854.335 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119355:20201016:112854.336 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119298:20201016:112854.336 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119342:20201016:112854.337 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119249:20201016:112854.337 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119389:20201016:112854.337 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119304:20201016:112854.337 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119263:20201016:112854.338 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119264:20201016:112854.338 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119297:20201016:112854.338 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119325:20201016:112854.338 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119333:20201016:112854.339 In zbx_tls_init_child()
119333:20201016:112854.339 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119277:20201016:112854.339 In substitute_key_macros() data:'jmx["java.lang:type=Runtime",Uptime]'
119277:20201016:112854.339 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119315:20201016:112854.339 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119261:20201016:112854.340 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119270:20201016:112854.340 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119366:20201016:112854.340 __zbx_zbx_setproctitle() title:'icmp pinger #6 [getting values]'
119366:20201016:112854.340 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119281:20201016:112854.341 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119272:20201016:112854.341 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119347:20201016:112854.341 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119357:20201016:112854.342 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119347:20201016:112854.342 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119347:20201016:112854.342 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119273:20201016:112854.342 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119279:20201016:112854.342 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119348:20201016:112854.343 server #103 started [trapper #8]
119369:20201016:112854.343 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119282:20201016:112854.343 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119283:20201016:112854.344 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119370:20201016:112854.344 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119285:20201016:112854.345 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119372:20201016:112854.345 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119331:20201016:112854.346 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119287:20201016:112854.346 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119373:20201016:112854.346 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119332:20201016:112854.347 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119374:20201016:112854.347 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119299:20201016:112854.347 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119338:20201016:112854.348 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119375:20201016:112854.348 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119303:20201016:112854.348 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119341:20201016:112854.349 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119376:20201016:112854.349 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119313:20201016:112854.349 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119380:20201016:112854.350 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119349:20201016:112854.350 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119316:20201016:112854.351 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119382:20201016:112854.351 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119350:20201016:112854.351 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119351:20201016:112854.352 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119327:20201016:112854.352 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119384:20201016:112854.352 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119340:20201016:112854.353 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119330:20201016:112854.353 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119386:20201016:112854.353 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119286:20201016:112854.354 End of DBconnect():0
119286:20201016:112854.354 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119346:20201016:112854.354 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119274:20201016:112854.354 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119346:20201016:112854.354 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119346:20201016:112854.354 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119387:20201016:112854.354 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119308:20201016:112854.355 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119381:20201016:112854.355 server #136 started [alert manager #1]
119390:20201016:112854.355 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119317:20201016:112854.355 In DBconnect() flag:0
119317:20201016:112854.356 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119305:20201016:112854.356 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119302:20201016:112854.356 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119385:20201016:112854.357 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119271:20201016:112854.357 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119310:20201016:112854.358 query [txnlev:0] [select oid from pg_type where typname='bytea']
119260:20201016:112854.358 query [txnlev:0] [select oid from pg_type where typname='bytea']
119253:20201016:112854.358 __zbx_zbx_setproctitle() title:'http poller #2 [got 0 values in 0.000000 sec, getting values]'
119253:20201016:112854.358 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119266:20201016:112854.358 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119345:20201016:112854.359 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119290:20201016:112854.359 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119290:20201016:112854.359 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119328:20201016:112854.360 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119289:20201016:112854.360 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119307:20201016:112854.360 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119288:20201016:112854.360 End of DBconnect():0
119288:20201016:112854.360 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119329:20201016:112854.361 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119276:20201016:112854.361 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119356:20201016:112854.361 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119356:20201016:112854.362 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119356:20201016:112854.362 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119294:20201016:112854.362 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119353:20201016:112854.363 __zbx_zbx_setproctitle() title:'trapper #13 [connecting to the database]'
119353:20201016:112854.363 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119311:20201016:112854.364 query without transaction detected
119311:20201016:112854.364 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119306:20201016:112854.364 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119306:20201016:112854.364 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119306:20201016:112854.364 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119268:20201016:112854.365 End of DCconfig_get_poller_items():1
119268:20201016:112854.365 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119275:20201016:112854.365 query [txnlev:0] [show standard_conforming_strings]
119275:20201016:112854.365 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119309:20201016:112854.367 PostgreSQL Server version: 120004
119309:20201016:112854.367 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119292:20201016:112854.367 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119269:20201016:112854.367 query [txnlev:0] [select oid from pg_type where typname='bytea']
119365:20201016:112854.367 End of DCconfig_get_poller_items():0
119365:20201016:112854.367 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119339:20201016:112854.368 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119339:20201016:112854.368 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119314:20201016:112854.368 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119314:20201016:112854.369 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119314:20201016:112854.369 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119258:20201016:112854.369 End of DBconnect():0
119258:20201016:112854.370 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119377:20201016:112854.370 In get_pinger_hosts()
119323:20201016:112854.370 PostgreSQL Server version: 120004
119323:20201016:112854.370 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119324:20201016:112854.371 In zbx_tls_init_child()
119324:20201016:112854.371 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119284:20201016:112854.371 In zbx_tls_init_child()
119319:20201016:112854.372 In zbx_tls_init_child()
119319:20201016:112854.372 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119256:20201016:112854.372 __zbx_zbx_setproctitle() title:'http poller #5 [got 0 values in 0.000000 sec, getting values]'
119256:20201016:112854.372 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119322:20201016:112854.373 In DBconnect() flag:0
119322:20201016:112854.374 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119280:20201016:112854.374 query [txnlev:0] [show standard_conforming_strings]
119280:20201016:112854.374 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119252:20201016:112854.375 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
119254:20201016:112854.375 7f5ec4ff9000-7f5ec4ffc000 r-xp 00000000 fd:00 133917 /usr/lib64/libkeyutils.so.1.5
119254:20201016:112854.375 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119267:20201016:112854.375 End of DBconnect():0
119336:20201016:112854.375 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119246:20201016:112854.375 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119250:20201016:112854.376 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119257:20201016:112854.378 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119360:20201016:112854.378 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119361:20201016:112854.379 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119362:20201016:112854.379 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119367:20201016:112854.380 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119368:20201016:112854.381 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119348:20201016:112854.381 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119320:20201016:112854.382 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119295:20201016:112854.382 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119320:20201016:112854.382 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119337:20201016:112854.382 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119334:20201016:112854.382 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119344:20201016:112854.383 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119354:20201016:112854.384 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119363:20201016:112854.384 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119364:20201016:112854.385 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119378:20201016:112854.386 server #133 started [icmp pinger #18]
119296:20201016:112854.386 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119388:20201016:112854.386 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119296:20201016:112854.386 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119296:20201016:112854.386 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119381:20201016:112854.386 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119379:20201016:112854.387 __zbx_zbx_setproctitle() title:'icmp pinger #19 [got 0 values in 0.000434 sec, idle 5 sec]'
119392:20201016:112854.387 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119312:20201016:112854.388 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119300:20201016:112854.388 In zbx_tls_init_child()
119300:20201016:112854.388 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119312:20201016:112854.388 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119312:20201016:112854.388 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119278:20201016:112854.388 query without transaction detected
119278:20201016:112854.388 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119302:20201016:112854.389 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119255:20201016:112854.389 query without transaction detected
119255:20201016:112854.390 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119371:20201016:112854.391 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119391:20201016:112854.391 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119359:20201016:112854.392 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119310:20201016:112854.392 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119260:20201016:112854.392 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119345:20201016:112854.393 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119321:20201016:112854.393 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119301:20201016:112854.394 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119358:20201016:112854.395 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119358:20201016:112854.395 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119251:20201016:112854.395 End of DBconnect():0
119251:20201016:112854.396 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119269:20201016:112854.396 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119377:20201016:112854.396 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119284:20201016:112854.397 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119352:20201016:112854.397 In DBconnect() flag:0
119352:20201016:112854.397 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119335:20201016:112854.397 server #90 started [unreachable poller #5]
119335:20201016:112854.397 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119252:20201016:112854.398 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119318:20201016:112854.399 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119318:20201016:112854.399 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119267:20201016:112854.399 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119336:20201016:112854.399 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119326:20201016:112854.399 OpenSSL library (version OpenSSL 1.0.2k-fips 26 Jan 2017) initialized
119326:20201016:112854.400 zbx_tls_init_child() PSK ciphersuites: PSK-AES128-CBC-SHA
119326:20201016:112854.400 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
zabbix_server [119236]: Error waiting for process with PID 119259: [10] No child processes
119320:20201016:112854.401 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119378:20201016:112854.401 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119379:20201016:112854.402 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119292:20201016:112854.402 Got signal [signal:15(SIGTERM),sender_pid:119236,sender_uid:10 20,reason:0]. Exiting ...
119236:20201016:112854.403 In DBconnect() flag:1
119236:20201016:112854.543 query without transaction detected
119236:20201016:112854.543 query [txnlev:0] [set schema 'u_2b05']
119236:20201016:112854.544 query [txnlev:0] [select oid from pg_type where typname='bytea']
119236:20201016:112854.546 PostgreSQL Server version: 120004
119236:20201016:112854.546 query without transaction detected
119236:20201016:112854.546 query [txnlev:0] [set escape_string_warning to off]
119236:20201016:112854.546 query [txnlev:0] [show standard_conforming_strings]
119236:20201016:112854.547 query without transaction detected
119236:20201016:112854.547 query [txnlev:0] [set bytea_output=escape]
119236:20201016:112854.547 End of DBconnect():0
119236:20201016:112854.547 In free_database_cache()
119236:20201016:112854.547 In DCsync_all()
119236:20201016:112854.548 In sync_history_cache_full() history_num:0
119236:20201016:112854.549 syncing history data...
119236:20201016:112854.549 syncing history data done
119236:20201016:112854.549 End of sync_history_cache_full()
119236:20201016:112854.549 In DCsync_trends() trends_num:0
119236:20201016:112854.550 syncing trend data...
119236:20201016:112854.550 query [txnlev:1] [begin;]
119236:20201016:112854.550 query [txnlev:1] [commit;]
119236:20201016:112854.551 syncing trend data done
119236:20201016:112854.551 End of DCsync_trends()
119236:20201016:112854.551 End of DCsync_all()
119236:20201016:112854.551 End of free_database_cache()
119236:20201016:112854.551 In free_configuration_cache()
119236:20201016:112854.551 End of free_configuration_cache()
119236:20201016:112854.551 In zbx_vc_destroy()
119236:20201016:112854.551 End of zbx_vc_destroy()
119236:20201016:112854.551 In free_selfmon_collector() collector:0x7f5eca931000
119236:20201016:112854.551 End of free_selfmon_collector()
119236:20201016:112854.551 In zbx_unload_modules()
119236:20201016:112854.551 End of zbx_unload_modules()
119236:20201016:112854.551 Zabbix Server stopped. Zabbix 4.0.5 (revision 90164).

Any help would be much appreciated.

[tim.mooney]

I'm not familiar with Ora2Pg, but it looks similar to other ETL (export, transform, load) tools I've looked at for doing SQL migrations.

You don't say anything about how you actually did the migration, so I guess my main question would be if you created a fresh Zabbix database in PostgreSQL including all table and other objects and then used Ora2Pg to move just the data, or whether you instead tried to use Ora2Pg to move both the SQL structure and the data? If you moved just the data/contents and not the structure, it's most likely an issue with one of the column types not being transformed correctly. I haven't done an SQL migration for Zabbix (we've used MySQL and now MariaDB from the start with Zabbix), but I have migrated other products and applications from Oracle to MySQL/MariaDB, and I can say that certain column types (like dates and times) require special handling during the ETL. If Ora2Pg isn't doing it correctly, you could just be ending up with empty values in columns that should have a value. Even for columns where that's not possible because of a NOT NULL constraint, it could be that the result is incorrectly changed as part of the migration.

If, on the other hand, you've tried to use Ora2Pg to move both the structure and the data, I think that's a mistake. You're much better off having a fresh Zabbix database set up on PostgreSQL 12.x with all the tables etc. created, but no data in them, and then just try to move the data. You're more likely to get working results that way.

Do you have anyone that's capable of scripting a comparison between your source Oracle DB and your destination PG12 DB? Basically connect up to both databases (read-only is fine for both connections) and iterate through tables, selecting results from a source table and ensuring the destination table has the exact same values in each column? The goal is to verify that the data that got inserted is valid and complete, and nothing got incorrectly changed or erroneously not inserted as part of the migration.

[alexandra.zayceva]

Apart form Ora2pg, here I found an entire list of tools dedicated to Oracle to PG migration. (Ora2Pg included)

https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion#External_Tools