search

grassrootseconomics / CIC-Docs

GNU General Public License v3.0
19 stars 6 forks source link

Query stalls db #82

Open nolash opened 4 years ago

nolash commented 4 years ago

Did you read all the READMEs and are system requirements fulfilled?

yes

What did you try to do?

Nothing, system went down

What did you expect should have happened?

Preferably not that

What happened instead?

...

What were the exact steps you took?

We looked in RDS, a query seems to consume too much resources, see below

{"DetailType":"FULL_SQL_QUERY","Text":"SELECT credit_transfer.id AS credit_transfer_id, credit_transfer.authorising_user_id AS credit_transfer_authorising_user_id, credit_transfer.created AS credit_transfer_created, credit_transfer.updated AS credit_transfer_updated, credit_transfer.blockchain_task_uuid AS credit_transfer_blockchain_task_uuid, credit_transfer.is_public AS credit_transfer_is_public, credit_transfer.uuid AS credit_transfer_uuid, credit_transfer.resolved_date AS credit_transfer_resolved_date, credit_transfer._transfer_amount_wei AS credit_transfer__transfer_amount_wei, credit_transfer.transfer_type AS credit_transfer_transfer_type, credit_transfer.transfer_subtype AS credit_transfer_transfer_subtype, credit_transfer.transfer_status AS credit_transfer_transfer_status, credit_transfer.transfer_mode AS credit_transfer_transfer_mode, credit_transfer.transfer_use AS credit_transfer_transfer_use, credit_transfer.transfer_metadata AS credit_transfer_transfer_metadata, credit_transfer.exclude_from_limit_calcs AS credit_transfer_exclude_from_limit_calcs, credit_transfer.resolution_message AS credit_transfer_resolution_message, credit_transfer.token_id AS credit_transfer_token_id, credit_transfer.sender_transfer_account_id AS credit_transfer_sender_transfer_account_id, credit_transfer.recipient_transfer_account_id AS credit_transfer_recipient_transfer_account_id, credit_transfer.sender_blockchain_address_id AS credit_transfer_sender_blockchain_address_id, credit_transfer.recipient_blockchain_address_id AS credit_transfer_recipient_blockchain_address_id, credit_transfer.sender_user_id AS credit_transfer_sender_user_id, credit_transfer.recipient_user_id AS credit_transfer_recipient_user_id \nFROM credit_transfer \nWHERE (EXISTS (SELECT 1 \nFROM organisation_association_table, organisation \nWHERE credit_transfer.id = organisation_association_table.credit_transfer_id AND organisation.id = organisation_association_table.organisation_id AND organisation.id IN (2))) OR credit_transfer.is_public = true ORDER BY credit_transfer.created DESC \n LIMIT 50 OFFSET 0"}