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

deadlocks in ORA-00060 in new zabbix 2.0.5 with Oracle g11r2 RAC

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 2.0.5
    • Server (S)
    • RHEL + 2 node Oracle g11R2 RAC

      After upgrading to new 2.0.5 version we have:
      6700:20130222:031443.782 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      6218:20130222:031448.614 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      6918:20130222:031451.613 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      6122:20130222:031455.817 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      6671:20130222:031531.993 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      7423:20130222:031535.581 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource

      which causes to grow usage of cache write buffer and eventually to crash zabbix_server after a while (1-4h).
      I made many tests and it remains the same. When I run environment with zabbix_server 2.0.4 it is OK, but with 2.0.5 - it dies.

      Fix
      ZBX-5920 added prefetching of 2 MB of data for Oracle SQL selects
      seems to work, but I think in this fix is modification which causes above errors.

        1. oracle_deadlock.log
          112 kB
        2. trace.tkprof
          297 kB
        3. zabbix_ora_32204.trc
          695 kB
        4. Zabbix-ORA-00060.log
          3 kB

            Unassigned Unassigned
            olgierdw Olgierd Wolodkiewicz
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: