Skip to content

streaming mode gives harmless database errors #536

Open

Description

@gijzelaerr

TraP gives an error in streaming mode, see below. Oddly enough Trap just continues running and everything works fine. Still we should find out what is causing this. The errors always come from the same threads/processes, one is the sync manager for multiprocessing and the other looks like is a process that uses astropy (using threads). This probably can be solved my making sure no threading is happening before forking (multiprocessing). This is related to issue #519, although now TraP is not crashing anymore.

16:35:34 ERROR sqlalchemy.engine.default: exception raised: <class 'psycopg2.OperationalError'>, SSL SYSCALL error: EOF detected

16:35:34 ERROR sqlalchemy.pool.NullPool: Exception during reset or similar
Traceback (most recent call last):
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 636, in _finalize_fairy
    fairy._reset(pool)
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 776, in _reset
    pool._dialect.do_rollback(self)
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 424, in do_rollback
    dbapi_connection.rollback()
OperationalError: SSL SYSCALL error: EOF detected
16:35:34 ERROR sqlalchemy.pool.NullPool: Exception during reset or similar
Traceback (most recent call last):
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 636, in _finalize_fairy
    fairy._reset(pool)
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 776, in _reset
    pool._dialect.do_rollback(self)
  File "/home/gijs/Work/tkp/.virtualenv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 424, in do_rollback
    dbapi_connection.rollback()
OperationalError: SSL error: decryption failed or bad record mac

Activity

  1. added this to the 4.0 milestone on Aug 23, 2016
  2. self-assigned this
    on Aug 23, 2016
  3. modified the milestones: 4.0, 4.1 on Oct 11, 2016
  4. removed their assignment
    on Feb 6, 2017
  5. modified the milestones: 4.1, Medium-term on Jul 15, 2020
  6. AntoniaR commented on Aug 20, 2024

    @AntoniaR
    Contributor

    Unclear if this is still an issue so would be good to test with the latest version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions