Hi,
we are spotting constant deadlocks when altering tables. After I
restart the db the ALTER TABLE command runs without problems, but
when I try to alter some other table later on it deadlocks again. If I
kill the process that handles ALTER TABLE the deadlock is "unlocked",
but ALTER TABLE still won't run until I restart it.
I've checked the logs, but didn't find anything useful. How can I get
some more information on what is happening when the server deadlocks?
Thanks, Sebastjan