Deadlock detected
От | Brian J. France |
---|---|
Тема | Deadlock detected |
Дата | |
Msg-id | 5.1.0.12.0.20010409084944.00a26d50@mail.firehawk.org обсуждение исходный текст |
Ответы |
Re: Deadlock detected
|
Список | pgsql-general |
Hello, I am getting a few of these errors in my web logs and didn't know what I could do to stop it. NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause. Error in query "UPDATE <table> SET <field> = <value> WHERE <field2> = <value2>" : ERROR: WaitOnLock: error on wakeup - Abortingthis transaction Is this due to the hash index on field2 or due to the has index in general? I read in the mailing archive back in '98 (referringto v6.5) that hash index were bad, is this still the case and should I switch to btree? I have tried to wrap theupdate statement with BEGIN; <statement>; END; and get the same results. System: Linux: 2.2.18 PostgreSQL: 7.0.3 gcc: 2.95.2 libc-2.1.3 Thanks, Brian BTW, on a different table I get this warning ever time I vacuum the database. It doesn't seem to cause a problem, but didn'tknow how to get rid of it. NOTICE: Index <indexname>: NUMBER OF INDEX' TUPLES (214) IS NOT THE SAME AS HEAP' (215). Recreate the index.
В списке pgsql-general по дате отправления: