Session overflow on heavy API access

XMLWordPrintable

    • High
    • None
    • On installations with API usage (for example with t5connect) to much sessions are produced with to long lifetime leading to problems with the session table.
    • None

      problem

      Since each API request with App Token authentication creates a session with 10 days lifetime on some installations the session table is very full leading to: 

      PHP Fatal error:  Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/instances-local/instance-XXXX/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php:228
Stack trace:

      solution

      Reduce session lifetime for such sessions.

            Assignee:
            Thomas Lauria
            Reporter:
            Thomas Lauria
            None
            None
            Axel Becher
            Stephan Bergmann, Sylvia Schumacher
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:
              None
              None