Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

streaming mode gives harmless database errors #536

Open
gijzelaerr opened this issue Aug 23, 2016 · 1 comment
Open

streaming mode gives harmless database errors #536

gijzelaerr opened this issue Aug 23, 2016 · 1 comment

Comments

@gijzelaerr
Copy link
Collaborator

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
@gijzelaerr gijzelaerr added the bug label Aug 23, 2016
@gijzelaerr gijzelaerr added this to the 4.0 milestone Aug 23, 2016
@gijzelaerr gijzelaerr self-assigned this Aug 23, 2016
@gijzelaerr gijzelaerr modified the milestones: 4.0, 4.1 Oct 11, 2016
@gijzelaerr gijzelaerr removed their assignment Feb 6, 2017
@AntoniaR AntoniaR modified the milestones: 4.1, Medium-term Jul 15, 2020
@AntoniaR
Copy link
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
Labels
Projects
None yet
Development

No branches or pull requests

2 participants