Hi,
We are facing one database crash issue because of stored procedures.
When the stored procedure with a set of values is executed the first time, it works fine.
If the same stored procedure is executed with same set of values once more, the database crashes with the error
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
This is what we have in the stored procedure:
SELECT * FROM TEST(1, 1)
Two values are being passed to the stored procedure.
First one is just a number and second value is an ID which has foreign key constraint.
Because of the foreign key constraint, the foreign key violation error is expected. But why should the server crash because of this violation?
Please let me know what we are missing.
Thanks and Regards
Jayashankar
Larsen & Toubro Limited
www.larsentoubro.com
This Email may contain confidential or privileged information for the intended recipient (s). If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.