Re: Problem on AIX with current - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Problem on AIX with current
Date
Msg-id 20011002004242H.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Problem on AIX with current  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Responses Re: Problem on AIX with current
List pgsql-hackers
> > Per Tom's request(1000 concurrent backends), I tried current on IBM
> > AIX 5L and found that make check hungs:
> > 
> > parallel group (13 tests): float4 oid varchar
> > 
> > pgbench hungs too if more than 4 or so concurrent backends are
> > involved.
> 
> I once had hangs during make check on AIX 4, but after make distclean
> and 
> rebuild was never able to reproduce.

I thing I did make distclean.

> Can you read the man page for cs(3), AIX 4 sais it is not recommended
> suggests to use compare_and_swap, maybe AIX 5 has more to say ?
   Note: The cs subroutine is only provided to support binary   compatibility with AIX Version 3 applications.
Whenwriting new   applications, it is not recommended to use this subroutine; it may cause   reduced performance in the
future.Applications should use the   compare_and_swap (compare_and_swap Subroutine) subroutine, unless they   need
touse unaligned memory locations.
 

Seems same as AIX 4?

> > Unfortunately gdb does not work well on AIX, so I'm stucked.
> > Maybe a new locking code?
> 
> Use dbx (and ddd) ?

Here is a stack trace using dbx.

semop(??, ??, ??) at 0xd02be73c
IpcSemaphoreLock(??, ??, ??), line 425 in "ipc.c"
LWLockAcquire(??, ??), line 270 in "lwlock.c"
LockAcquire(??, ??, ??, ??, ??), line 482 in "lock.c"
LockRelation(??, ??), line 153 in "lmgr.c"
heap_openr(??, ??), line 512 in "heapam.c"
scan_pg_rel_ind(??, ??), line 380 in "relcache.c"
ScanPgRelation(??, ??), line 307 in "relcache.c"
IndexedAccessMethodInitialize(??, ??, ??), line 994 in "relcache.c"
RelationNameGetRelation(??), line 1484 in "relcache.c"
heap_openr(??, ??), line 502 in "heapam.c"
setTargetTable(??, ??, ??, ??), line 136 in "parse_clause.c"
transformUpdateStmt(??, ??), line 2416 in "analyze.c"
transformStmt(??, ??), line 228 in "analyze.c"
parse_analyze(??, ??), line 92 in "analyze.c"
pg_analyze_and_rewrite(??), line 428 in "postgres.c"
unnamed block $b1877, line 740 in "postgres.c"
unnamed block $b1876, line 740 in "postgres.c"
unnamed block $b1872, line 740 in "postgres.c"
pg_exec_query_string(??, ??, ??), line 740 in "postgres.c"
PostgresMain(??, ??, ??, ??, ??), line 1943 in "postgres.c"
DoBackend(??), line 2104 in "postmaster.c"
BackendStartup(??), line 1837 in "postmaster.c"
unnamed block $b1665, line 917 in "postmaster.c"
ServerLoop(), line 917 in "postmaster.c"
PostmasterMain(??, ??), line 712 in "postmaster.c"
main(argc = 0, argv = (nil)), line 178 in "main.c"


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Next
From: Lee Kindness
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?