-
Problem report
-
Resolution: Won't fix
-
Major
-
None
-
4.0.11
-
None
we got some problems with mysql so we traslate the zabbix database to postgresql 9.2, we find some problems with the database structure and zabbix was reporting error on auto-registration.
errors like :
30319:20190920:031507.420 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: null value in column "description" violates not-null constraint DETAIL: Failing row contains (10651, null, 423c2349-7861-46f5-b954-2ba10cea4cdc, 0, 0, , 0, 0, 0, -1, 2, , , 0, 0, 0, 0, null, 0, 0, 0, 0, 0, , , 0, 0, 0, , kubeqa01, 4, null, null, 1, 1, , , , , , 1). [insert into hosts (hostid,host,name,proxy_hostid,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,status,flags,tls_connect,tls_accept,tls_is suer,tls_subject,tls_psk_identity,tls_psk) values (10651,'423c2349-7861-46f5-b954-2ba10cea4cdc','kubeqa01',null,-1,2,'','',0,4,1,1,'','','',''),(10652 ,'564de375-f739-9142-1076-ccca1343ee31','vt-lab-master',null,-1,2,'','',0,4,1,1,'','','',''),(10653,'564d4233-5ebb-dae2-d1b5-77f454786b2b','vt-lab-wor ker01',null,-1,2,'','',0,4,1,1,'','','',''),(10654,'564ddb7f-636a-69d1-a4f9-cf8f0b6e1176','vt-lab-worker02',null,-1,2,'','',0,4,1,1,'','','',''); ]
so we execute
zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN location DROP NOT NULL; ALTER TABLE zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN notes DROP NOT NULL; ALTER TABLE zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN host_networks DROP NOT NULL; ALTER TABLE zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN site_notes DROP NOT NULL; ALTER TABLE zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN poc_1_notes DROP NOT NULL; ALTER TABLE zabbix=# ALTER TABLE zabbix.host_inventory ALTER COLUMN poc_2_notes DROP NOT NULL;
to allow the item self registration
after that zabbix-server crashes with
30224:20190920:043219.732 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ... 30224:20190920:043219.732 ====== Fatal information: ====== 30224:20190920:043219.732 Program counter: 0x7f16431cba81 30224:20190920:043219.732 === Registers: === 30224:20190920:043219.732 r8 = 0 = 0 = 0 30224:20190920:043219.732 r9 = 0 = 0 = 0 30224:20190920:043219.732 r10 = 1 = 1 = 1 30224:20190920:043219.732 r11 = 0 = 0 = 0 30224:20190920:043219.732 r12 = 5557eace2157 = 93836089893207 = 93836089893207 30224:20190920:043219.732 r13 = 1 = 1 = 1 30224:20190920:043219.732 r14 = 0 = 0 = 0 30224:20190920:043219.732 r15 = 0 = 0 = 0 30224:20190920:043219.732 rdi = 0 = 0 = 0 30224:20190920:043219.732 rsi = fffffffffffffffc = 18446744073709551612 = -4 30224:20190920:043219.732 rbp = 7ffc09f30270 = 140720475406960 = 140720475406960 30224:20190920:043219.732 rbx = 3c = 60 = 60 30224:20190920:043219.732 rdx = fffffffffffffffc = 18446744073709551612 = -4 30224:20190920:043219.732 rax = 0 = 0 = 0 30224:20190920:043219.733 rcx = 0 = 0 = 0 30224:20190920:043219.733 rsp = 7ffc09f30258 = 140720475406936 = 140720475406936 30224:20190920:043219.733 rip = 7f16431cba81 = 139733591964289 = 139733591964289 30224:20190920:043219.733 efl = 10283 = 66179 = 66179 30224:20190920:043219.733 csgsfs = 33 = 51 = 51 30224:20190920:043219.733 err = 4 = 4 = 4 30224:20190920:043219.733 trapno = e = 14 = 14 30224:20190920:043219.733 oldmask = 0 = 0 = 0 30224:20190920:043219.733 cr2 = 0 = 0 = 0 30224:20190920:043219.733 === Backtrace: ===
Windows Terminal2553:20190920:044138.136 7f38c2b7a000-7f38c2b7b000 rw-p 00000000 00:00 0 2553:20190920:044138.136 7f38c2b7b000-7f38c2b7c000 rw-s 00000000 00:04 22315010 /SYSV00000000 (deleted) 2553:20190920:044138.136 7f38c2b7c000-7f38c2b7d000 rw-p 00000000 00:00 0 2553:20190920:044138.136 7f38c2b7d000-7f38c2b7e000 rw-p 00000000 00:00 0 2553:20190920:044138.136 7f38c2b7e000-7f38c2b7f000 r--p 00021000 fd:00 33816 /usr/lib64/ld-2.17.so 2553:20190920:044138.136 7f38c2b7f000-7f38c2b80000 rw-p 00022000 fd:00 33816 /usr/lib64/ld-2.17.so 2553:20190920:044138.136 7f38c2b80000-7f38c2b81000 rw-p 00000000 00:00 0 2553:20190920:044138.136 7fff5e9b4000-7fff5e9d5000 rw-p 00000000 00:00 0 [stack] 2553:20190920:044138.136 7fff5e9dd000-7fff5e9df000 r-xp 00000000 00:00 0 [vdso] 2553:20190920:044138.136 ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] 2553:20190920:044138.136 ================================ 2553:20190920:044138.136 Please consider attaching a disassembly listing to your bug report. 2553:20190920:044138.136 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
we really need your help to solve the problem, zabbix is down and we cant start the zabbix-server again.