Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-11177

SQL error happens when processing recovery event

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.2.0rc1
    • Fix Version/s: 3.2.0rc2
    • Component/s: Server (S)
    • Labels:

      Description

      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)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: