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

If the Server can connect to the DB engine but can not use it, DB sessions are not properly cleaned up, and will exhaust the DB engine's maximum sessions.

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Minor
    • Resolution: Cannot Reproduce
    • 3.4.6
    • 4.0 (plan)
    • Proxy (P), Server (S)
    • None
    • Team A
    • Sprint 27
    • 1

    Description

      It seems that Zabbix Server does not clean-up database sessions after establishing a successful connection where the DB is not usable for some reason (permission issues, schema issues, etc.).
      The number of sessions will increase indefinitely until the maximum number of sessions is reached on the DB server.

      Steps to reproduce:

      On a working environment, revoke the 'public' permissions to schema 'public' on the zabbix database:

      Result:
      1. Check the server log for this error:
      21381:20180204:160045.582 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: relation "users" does not exist
      LINE 1: select userid from users limit 1
      ^sessions
      [select userid from users limit 1]
      21381:20180204:160045.582 cannot use database "zabbix": database is not a Zabbix database

      2. The number of postgress TCP sessions (on the Zabbix Server's side) and postgres sessions (on the DB server's side) will increase slowly until the PostgreSQL max_connections limit is hit.

      3. There is no visible change in the number (nor PIDs) of Zabbix Server processes.

      Attachments

        Activity

          People

            Unassigned Unassigned
            praposo Pedro Costa Raposo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: