Re: [PERFORM] Hanging queries on dual CPU windows

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: [PERFORM] Hanging queries on dual CPU windows
Дата
Msg-id 4417FA71.5070606@archonet.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Hanging queries on dual CPU windows  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-hackers
Magnus Hagander wrote:
>> On Monday 13 March 2006 12:27, Magnus Hagander wrote:
>>> Great. That'll certainly help - now you don't have to wait for 
>>> binaries from me.
>>>
>>> What I'd be interested in seeing is new stackdumps from a version 
>>> where
>>> you:
>>> 1) Do *not* have the patch for mutexes applied
>>> 2) Have removed "static" from all the function devlarations in 
>>> signal.c and socket.c, bnoth in src/backend/port/win32.
>> I did that, and the interesting thing is that: 
>> 1. It takes much longer to hang.
> 
> ?! That shouldn't be related :-)
> 
>> 2. Once it hangs, the stacktraces are the same.
> 
> Hmm. That's weird :-(
> Did you do a make clean? Sometimes needed to get the port stuff in,
> mingw messes up sometimes.
> 
>> 3 (and this is the kicker). The thing starts working again 
>> after a couple (+/-
>> 5) minutes ?????????
> 
> Interesting. And you get nothing in the logs? (pg_log / eventlog)

There's a report on -bugs ([BUGS] Random hang during commit / 
b.lin@dl.ac.uk) that might well be related to this.

--   Richard Huxton  Archonet Ltd


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: constraints and sql92 information_schema compliance
Следующее
От: "Rodrigo Hjort"
Дата:
Сообщение: Re: Restoring a Full Cluster on a Different Architecture (32 x 64)