-
Incident report
-
Resolution: Fixed
-
Blocker
-
3.2.0rc1
Configuration of trigger:
SQL errors in log file
16907:20160909:101544.251 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: null value in column "r_eventid" violates not-null constraint DETAIL: Failing row contains (9431, null, null, null, null). [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (9431,null,null,null,null); ]
14052:20160908:100334.539 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "event_recovery" violates foreign key constraint "c_event_recovery_2" DETAIL: Key (r_eventid)=(13511027424690231) is not present in table "events". [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (9270,13511027424690231,null,null,null);
valgrind output:
==16907== Use of uninitialised value of size 8 ==16907== at 0x5AAB09B: _itoa_word (_itoa.c:179) ==16907== by 0x5AAF249: vfprintf (vfprintf.c:1641) ==16907== by 0x5AD7408: vsnprintf (vsnprintf.c:119) ==16907== by 0x495E35: __zbx_zbx_snprintf_alloc (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x416401: save_event_recovery (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41918F: flush_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4193B8: process_trigger_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4617E0: DCsync_history (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41C68F: dbsyncer_thread (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48DB24: zbx_thread_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41B6BA: MAIN_ZABBIX_ENTRY (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48C4F0: daemon_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== ==16907== Conditional jump or move depends on uninitialised value(s) ==16907== at 0x5AAF29C: vfprintf (vfprintf.c:1641) ==16907== by 0x5AD7408: vsnprintf (vsnprintf.c:119) ==16907== by 0x495E35: __zbx_zbx_snprintf_alloc (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x416401: save_event_recovery (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41918F: flush_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4193B8: process_trigger_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4617E0: DCsync_history (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41C68F: dbsyncer_thread (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48DB24: zbx_thread_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41B6BA: MAIN_ZABBIX_ENTRY (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48C4F0: daemon_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41AFAF: main (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== ==16907== Conditional jump or move depends on uninitialised value(s) ==16907== at 0x4C301E: DBsql_id_ins (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4C4245: zbx_db_insert_execute (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x416493: save_event_recovery (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41918F: flush_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4193B8: process_trigger_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4617E0: DCsync_history (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41C68F: dbsyncer_thread (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48DB24: zbx_thread_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41B6BA: MAIN_ZABBIX_ENTRY (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48C4F0: daemon_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41AFAF: main (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== ==16907== Conditional jump or move depends on uninitialised value(s) ==16907== at 0x418CE3: update_trigger_changes (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4193CA: process_trigger_events (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x4617E0: DCsync_history (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41C68F: dbsyncer_thread (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48DB24: zbx_thread_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41B6BA: MAIN_ZABBIX_ENTRY (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x48C4F0: daemon_start (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server) ==16907== by 0x41AFAF: main (in /home/sasha/zabbix-svn-r/trunk/sbin/zabbix_server)
