Agent2 Oracle plugin leaves many open Oracle sessions / ORA-12516

ExportXMLWordPrintable

    • Type: Problem report
    • Resolution: Duplicate
    • Priority: Minor
    • None
    • Affects Version/s: 7.0.18
    • Component/s: Agent2 plugin (G)
    • None
    • S26-W38/39
    • 6
    • 1

      After upgrading zabbix_agent2 from 7.0.15 -> 7.0.18, the Oracle plugin opens many sessions that remain active/idle on the DB; DB reports ORA-12516 and ORA-01013. Reverting to 7.0.15 removes the issue. 

      7.0.15 -> 7.0.18 changes introduced connection-handling and query fixes (KeepAlive exists, other commits changed ResolveTNS/TNS handling). Maybe session lifecycle is not being closed or pooling semantics changed?

            Assignee:
            Artjoms Elons Tatsu
            Reporter:
            Maksym Buz
            Team B
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 48h Original Estimate - 48h
                48h
                Remaining:
                Time Spent - 36h Remaining Estimate - 18h
                18h
                Logged:
                Time Spent - 36h Remaining Estimate - 18h
                36h