This is an intermediate report for AIX 5L port.

o gmake check sometimes hungs up

o pgbench almost always hungs up

In summary current on AIX 5L is quite unstable(7.1 worked very well).
FYI, here are the back trace info while pgbench hungs up.  This
includes backtraces for 3 processes. I will continue to investigate as
long as the hardware is available for me.

[ps indicates UPDATE]
semop(??, ??, ??) at 0xd02be73c
IpcSemaphoreLock() at 0x100091d0
LWLockAcquire() at 0x10019df4
LockRelease() at 0x10052540
UnlockRelation() at 0x10051950
index_endscan() at 0x10051104
ExecCloseR() at 0x100a0584
ExecEndIndexScan() at 0x100a3a30
ExecEndNode() at 0x1009e960
EndPlan() at 0x1009d700
ExecutorEnd() at 0x1009e434
ProcessQuery() at 0x100b60e8
pg_exec_query_string() at 0x1001c5b4
PostgresMain() at 0x1001c0a8
DoBackend() at 0x10003380
BackendStartup() at 0x1000287c
ServerLoop() at 0x10002be8
PostmasterMain() at 0x10004934
main() at 0x100004ec
(dbx) 


[ps indicates UPDATE]
semop(??, ??, ??) at 0xd02be73c
IpcSemaphoreLock() at 0x100091d0
LWLockAcquire() at 0x10019df4
LockRelease() at 0x10052540
UnlockRelation() at 0x10051950
relation_close() at 0x10014f1c
SearchCatCache() at 0x100103f8
SearchSysCache() at 0x1000daac
IndexSupportInitialize() at 0x100ae150
RelationInitIndexAccessInfo() at 0x100332a4
RelationBuildDesc() at 0x10030a20
RelationNameGetRelation() at 0x100337b0
relation_openr() at 0x10014f84
index_openr() at 0x100513dc
SearchCatCache() at 0x1001022c
SearchSysCache() at 0x1000daac
pg_aclcheck() at 0x1008d844
ExecCheckRTEPerms() at 0x1009c838
ExecCheckRTPerms() at 0x1009c94c
ExecCheckQueryPerms() at 0x1009cb28
InitPlan() at 0x1009da10
ExecutorStart() at 0x1009e6f4
ProcessQuery() at 0x100b6028
pg_exec_query_string() at 0x1001c5b4
PostgresMain() at 0x1001c0a8
DoBackend() at 0x10003380
BackendStartup() at 0x1000287c
ServerLoop() at 0x10002be8
PostmasterMain() at 0x10004934
main() at 0x100004ec
(dbx) 

[ps indicates UPDATE waiting]
semop(??, ??, ??) at 0xd02be73c
IpcSemaphoreLock() at 0x100091d0
ProcSleep() at 0x1001d680
WaitOnLock() at 0x10051e70
LockAcquire() at 0x10052d00
XactLockTableWait() at 0x10051580
heap_update() at 0x100133d0
ExecReplace() at 0x1009ce28
ExecutePlan() at 0x1009d678
ExecutorRun() at 0x1009e564
ProcessQuery() at 0x100b60c4
pg_exec_query_string() at 0x1001c5b4
PostgresMain() at 0x1001c0a8
DoBackend() at 0x10003380
BackendStartup() at 0x1000287c
ServerLoop() at 0x10002be8
PostmasterMain() at 0x10004934
main() at 0x100004ec

Wed, 05 Dec 2001 17:41:04 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Intermediate report for AIX 5L port
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> In summary current on AIX 5L is quite unstable(7.1 worked very well).

This looks like a problem with the new LWLock logic.  I guess I have
to answer for that ;-).  I am willing to dig into it if you can get
me access to the machine.

BTW, is this a single-CPU or multi-CPU machine?

			regards, tom lane

Thu, 06 Dec 2001 15:01:35 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Intermediate report for AIX 5L port 
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > In summary current on AIX 5L is quite unstable(7.1 worked very well).
> 
> This looks like a problem with the new LWLock logic.  I guess I have
> to answer for that ;-).  I am willing to dig into it if you can get
> me access to the machine.

Thanks. Since the machine is behind a firewall, I have to negotiate
with the network admin. Once I succeed it, I will let you know.

> BTW, is this a single-CPU or multi-CPU machine?

It's a 4-way machine.
--
Tatsuo Ishii

Fri, 07 Dec 2001 09:13:34 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: Intermediate report for AIX 5L port 