Hi,

once in a while we get a deadlock executing the statement "Select * from
SP_SWAP_MD(Someparameters)".
SP_Swap_MD is a stored procedure which only contains a select-statement
joining 3 tables.

Details:
- The exception is: java.sql.SQLException: GDS Exception. 335544336.
deadlock
- All transactions do have the isolation-level READ_COMMITTED (Jaybird)

Although, there might be an update performed to one of these tables at
the time this stored proc is executed, we kind of thought there is no
deadlock with select-queries. Is this wrong?

If it is wrong, under which circumstances a deadlock can occure during a
select-statement (read).

Thank you for your help,
Josef Gschwendtner



PS:
How can one perform a coredump (Linux)?