hello list,
i am using 3.1.7 with SQL based setup using Postgres 8.1.4 as the
RDBMS. postgresql server log is full of deadlock detected message
ERROR: deadlock detected
DETAIL: Process 18045 waits for ShareLock on transaction 2438579;
blocked by process 18049.
Process 18049 waits for ShareLock on transaction 2438686;
blocked by process 18033.
Process 18033 waits for ShareLock on transaction 2438575;
blocked by process 18045.
ERROR: deadlock detected
DETAIL: Process 18033 waits for ShareLock on transaction 2438579;
blocked by process 18049.
Process 18049 waits for ShareLock on transaction 2438686;
blocked by process 18033.
CONTEXT: SQL statement "UPDATE bayes_token SET spam_count =
greatest_int(spam_count + $1 , 0), ham_count = greatest_int(ham_count
+ $2 , 0), atime = greatest_int(atime, $3 ) WHERE id = $4 AND
token = $5 "
PL/pgSQL function "put_tokens" line 9 at SQL statement
above errors are just samples, the log is full of these messages. is
there some bug is PGSQL implementaion
Sandeep
