Re: Win XP SP2 SMP locking (8.1.4)

On Thu, 5 Oct 2006, Joshua D. Drake wrote:

>>
>> It's interesting, that there is no problem with 8.2beta1 in all
>> combinations ! Any idea what changes from 8.1.4 to 8.2beta1 could
>> affect the problem ?
>
> What do you mean locking? Do you mean the postgresql process locks up?
> E.g; can you still connect to PostgreSQL from another connection? If not
> is there an error?

It looks like application is waiting something from postgresql, but
postgresql thinks it did the job. vacuum analyze gets things moving.
I could connect to PostgreSQL from another connection, for example
pgAdmin still works with this database.

>
> Joshua D. Drake
>
>
>>
>>
>> postgres.exe:
>>
>> (gdb) bt
>> #0 0x7c901231 in ntdll!DbgUiConnectToDbg () from
>> C:\WINDOWS\system32\ntdll.dll
>> #1 0x7c9507a8 in ntdll!KiIntSystemCall () from
>> C:\WINDOWS\system32\ntdll.dll
>> #2 0x00000005 in ?? ()
>> #3 0x00000004 in ?? ()
>> #4 0x00000001 in ?? ()
>> #5 0x019effd0 in ?? ()
>> #6 0xf784e548 in ?? ()
>> #7 0xffffffff in ?? ()
>> #8 0x7c90ee18 in strchr () from C:\WINDOWS\system32\ntdll.dll
>> #9 0x7c9507c8 in ntdll!KiIntSystemCall () from
>> C:\WINDOWS\system32\ntdll.dll
>> #10 0x00000000 in ?? () from #11 0x00000000 in ?? () from #12 0x00000000 in
>> ?? () from #13 0x00000000 in ?? () from (gdb) Cannot access memory at
>> address 0x19f0000
>>
>>
>> application:
>> (gdb) bt
>> #0 0x7c901231 in ntdll!DbgUiConnectToDbg () from
>> C:\WINDOWS\system32\ntdll.dll
>> #1 0x7c9507a8 in ntdll!KiIntSystemCall () from
>> C:\WINDOWS\system32\ntdll.dll
>> #2 0x00000005 in ?? ()
>> #3 0x00000004 in ?? ()
>> #4 0x00000001 in ?? ()
>> #5 0x0196ffd0 in ?? ()
>> #6 0x7c97c0d8 in ntdll!NtAccessCheckByTypeResultListAndAuditAlarm ()
>> #7 0xffffffff in ?? ()
>> #8 0x7c90ee18 in strchr () from C:\WINDOWS\system32\ntdll.dll
>> #9 0x7c9507c8 in ntdll!KiIntSystemCall () from
>> C:\WINDOWS\system32\ntdll.dll
>> #10 0x00000000 in ?? () from
>> #11 0x00000000 in ?? () from
>> #12 0x00000000 in ?? () from
>> #13 0x00000000 in ?? () from
>> (gdb) Cannot access memory at address 0x1970000
>>
>>
>> Regards,
>> Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
>> phone: +007(495)939-16-83, +007(495)939-23-83
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83