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

On bigger loads there is problem with queries on postgres table #116

Open
AdamSaleh opened this issue Jan 26, 2021 · 0 comments
Open

On bigger loads there is problem with queries on postgres table #116

AdamSaleh opened this issue Jan 26, 2021 · 0 comments

Comments

@AdamSaleh
Copy link

The error in the response was

    This probably means the server terminated abnormally
    before or while processing the request.
 'SELECT count(*) AS count_1 
  FROM (SELECT 
                  messages.id AS messages_id, 
                  messages.msg_id AS messages_msg_id, 
                  messages.i AS messages_i, 
                  messages.topic AS messages_topic, 
                  messages.timestamp AS messages_timestamp,
                  messages.certificate AS messages_certificate,
                  messages.signature AS messages_signature, 
                  messages.category AS messages_category, 
                  messages.username AS messages_username, 
                  messages.crypto AS messages_crypto, 
                  messages.source_name AS messages_source_name,
                  messages.source_version AS messages_source_version,
                  messages._msg AS messages__msg, 
                  messages._headers AS messages__headers
               FROM messages
               WHERE messages.timestamp BETWEEN %(timestamp_1)s AND %(timestamp_2)s 
                     AND messages.topic = %(topic_1)s) AS anon_1' {'timestamp_2': datetime.datetime(2021, 1, 22, 11, 13, 3), 'topic_1': u'org.fedoraproject.prod.bodhi.update.status.testing.koji-build-group.build.complete', 'timestamp_1': datetime.datetime(2021, 1, 22, 10, 56, 2)}

and

 Can't reconnect until invalid transaction is rolled back (original cause: InvalidRequestError: Can't reconnect until invalid transaction is rolled back) u'
SELECT count(*) AS count_1 
FROM (SELECT messages.id AS messages_id, messages.msg_id AS messages_msg_id, messages.i AS messages_i, messages.topic AS messages_topic, messages.timestamp AS messages_timestamp, messages.certificate AS messages_certificate, messages.signature AS messages_signature, messages.category AS messages_category, messages.username AS messages_username, messages.crypto AS messages_crypto, messages.source_name AS messages_source_name, messages.source_version AS messages_source_version, messages._msg AS messages__msg, messages._headers AS messages__headers 
FROM messages \nWHERE messages.timestamp BETWEEN %(timestamp_1)s AND %(timestamp_2)s AND messages.topic = %(topic_1)s) AS anon_1' [immutabledict({})]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant