Skip site navigation (1) Skip section navigation (2)

Re: Dead Lock problem with 8.1.3

From: Kai Hessing <kai(dot)hessing(at)hobsons(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dead Lock problem with 8.1.3
Date: 2006-09-27 16:46:42
Message-ID: 4nvo7iFc5gjbU1@individual.net (view raw or flat)
Thread:
Lists: pgsql-general
Joe Conway wrote:
> Martijn van Oosterhout wrote:
>> It probably has something to with the fact that you didn't explain what
>> you meant by "deadlock". Also, you refer to a temp table, yet don't
>> indicate which table it is.

Deadlock means it hangs up and doesn't terminate through timeout.
The system goes into an endless loop. The part ('SELECT sid FROM
stud_vera WHERE veraid = 2') seems to create a temporary table again and
again and again ....

>> You'll need to be a lot more specific about your problem before we can
>> help. For example, a script to reproduce the problem, or a copy of psql
>> output demonstrating it.

There is no output. It just takes forever. We're currently working to
seperate this problem into a simple setup. If we have one, I will post it.

> Also EXPLAIN output, and information regarding the number of rows in 
> each table, and the number of rows matching veraid = 2 and veraid = 34 
> might help.

Explain produces the same problem. It just takes forever...

> While the query is running, how much CPU is the process consuming, and 
> what does vmstat show for disk and swap I/O?

~80% CPU power. Disk usage is not noticable.

Thanks and
*greets*
Kai

In response to

Responses

pgsql-general by date

Next:From: Kai HessingDate: 2006-09-27 16:49:04
Subject: Re: Dead Lock problem with 8.1.3
Previous:From: Kai HessingDate: 2006-09-27 16:42:38
Subject: Re: Dead Lock problem with 8.1.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group