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

server can not survive some oracle-down conditions

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Won't fix
    • Affects Version/s: 1.8.9
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      oracle 11.203

      Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: