epam / epam/Indigo

Certain concurrent queries crash Bingo

Open
#113 4 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.