Re: Win XP SP2 SMP locking (8.1.4) - Mailing list pgsql-hackers

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@sai.msu.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@postgresql.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83