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

Problems when saving multiple errors in a short interval of time #164

Open
hyperionel opened this issue Jun 23, 2016 · 0 comments
Open

Problems when saving multiple errors in a short interval of time #164

hyperionel opened this issue Jun 23, 2016 · 0 comments
Labels

Comments

@hyperionel
Copy link
Contributor

There are some problems when we send multiple errors at once probably caused by the limited number of connections to the db.

2016-06-23T12:42:37.627449+00:00 app[sidekiq.1]: 3 TID-owjgz5hac WARN: ActiveRecord::ConnectionTimeoutError: could not obtain a database connection within 5.000 seconds (waited 5.004 seconds)

Every error it tries to add after that will throw something like this:

2016-06-23T12:06:30.119582+00:00 app[sidekiq.1]: 3 TID-owj4c1gh0 WARN: {"class":"ErrorStore::Error::ErrorWorker","args":["issue:5:1aa8ec938bce626487c886bc1a436336"],"retry":3,"queue":"default","jid":"9606836e14bc9e5afb160274","created_at":1466683583.2348309,"enqueued_at":1466683583.234889,"error_message":"PG::TRSerializationFailure: ERROR: could not serialize access due to read/write dependencies among transactions\nDETAIL: Reason code: Canceled on identification as a pivot, during commit attempt.\nHINT: The transaction might succeed if retried.\n:

@hyperionel hyperionel added the bug label Jun 24, 2016
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

1 participant