Session overflow on heavy API access

XMLWordPrintable

    • High
    • 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.

      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
            Axel Becher
            Stephan Bergmann, Sylvia Schumacher
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: