search

open-reaction-database / ord-interface

Search/browse interface and APIs for the Open Reaction Database
https://open-reaction-database.org
Apache License 2.0
19 stars 9 forks source link

502 Bad Gateway error #34

Open skearnes opened 2 years ago

skearnes commented 2 years ago

I have tested the database with a simple search (smiles code: OB(O)C1=CC=CC=C1). If the search mode is exact, everything is fine, however, if I choose substructure or similar, I obtain a "502 Bad Gateway" error.

skearnes commented 2 years ago

Confirming that this reproduces on AWS but not locally; likely something to do with the Aurora Postgres configuration?

skearnes commented 2 years ago

I ran some queries directly on an EC2 instance, and now the web interface seems to be performing better. Maybe Aurora lazily creates its indices?

skearnes commented 1 year ago

Confirming that this issue still exists with the new ORM backend; we may need a polling mechanism for long-running queries.

bdeadman commented 5 months ago

@bdeadman and @skearnes to check if bug is still there.