Certain concurrent queries crash Bingo
- Dominant language
- C++
- Stars
- 406
- Forks
- 134
- Avg merge
- 2d 11h
- Merged PRs (30d)
- 24
Description
I'm using a version built from source on the 16th November 2017 against PostgreSQL 9.6.
When doing concurrent queries against a Bingo index a minority of queries cause Bingo to crash (running the same queries sequentially seems to work). As an example an exact search for 'CCCCCCCN' usually elicited the issue but not a substructure search or a similarity search for this compound. An exact search for 'CCCCCCC' also works.
Unfortunately I can't reproduce the issue on a database of a few thousand chemicals only on the one with millions. If you have any suggestions of what I could do to assist in debugging let me know as I doubt the postgres log is especially helpful.
2017-12-18 19:41:23 GMT LOG: server process (PID 8196) was terminated by exception 0xC0000005
2017-12-18 19:41:23 GMT DETAIL: Failed process was running: select * from bingo.chemdata where smiles @ ('CCCCCCCN','')::bingo.exact
2017-12-18 19:41:23 GMT HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2017-12-18 19:41:23 GMT LOG: terminating any other active server processes
2017-12-18 19:41:23 GMT WARNING: terminating connection because of crash of another server process
2017-12-18 19:41:23 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-12-18 19:41:23 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-12-18 19:41:23 GMT WARNING: terminating connection because of crash of another server process
2017-12-18 19:41:23 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-12-18 19:41:23 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-12-18 19:41:23 GMT WARNING: terminating connection because of crash of another server process
2017-12-18 19:41:23 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-12-18 19:41:23 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-12-18 19:41:23 GMT WARNING: terminating connection because of crash of another server process
2017-12-18 19:41:23 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-12-18 19:41:23 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-12-18 19:41:23 GMT LOG: all server processes terminated; reinitializing
2017-12-18 19:41:23 GMT LOG: database system was interrupted; last known up at 2017-12-18 19:41:11 GMT
2017-12-18 19:41:24 GMT FATAL: the database system is in recovery mode
2017-12-18 19:41:24 GMT FATAL: the database system is in recovery mode
2017-12-18 19:41:24 GMT LOG: database system was not properly shut down; automatic recovery in progress
2017-12-18 19:41:24 GMT LOG: invalid record length at 49C/88E0F148: wanted 24, got 0
[after this point the server recovers]
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.