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

server can not survive some oracle-down conditions

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Critical Critical
    • None
    • 1.8.9
    • Server (S)
    • oracle 11.203

      while zabbix server tries to survive database down conditions, sometimes it does die with signal 6 (sigabrt)

      19119:20120210:104009.143 server #681 started history syncer #30
      19119:20120210:113143.724 [Z3005] query failed: [-1] ORA-04031: unable to allocate 3912 bytes of shared memory
      18410:20120210:113143.760 One child process died (PID:19119,exitcode/signal:6). Exiting ...

      for the record, there seemed to be other message occurrences like that, which didn't seem to result in immediate process death (although it might be just a question of time)

      19150:20120210:113143.691 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4120 bytes of shared memory
      19119:20120210:113143.724 [Z3005] query failed: [-1] ORA-04031: unable to allocate 3912 bytes of shared memory
      19114:20120210:113143.725 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4104 bytes of shared memory
      19141:20120210:113143.782 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4104 bytes of shared memory
      19104:20120210:113143.849 [Z3005] query failed: [-1] ORA-04031: unable to allocate 1560 bytes of shared memory
      18410:20120210:113239.779 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      18410:20120210:113241.236 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      18410:20120210:113251.252 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
      18410:20120210:113301.254 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
      18410:20120210:113311.256 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
      18410:20120210:113321.258 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12528: TNS:listener: all appropriate instances are blocking new connections
      18410:20120210:113331.280 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-01033: ORACLE initialization or shutdown in progress

            Unassigned Unassigned
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: