Skip site navigation (1) Skip section navigation (2)

Re: Problem on AIX with current

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: ZeugswetterA(at)spardat(dot)at
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem on AIX with current
Date: 2001-10-01 15:42:42
Message-ID: 20011002004242H.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: 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&#58; The cs subroutine is only provided to support binary
    compatibility with AIX Version 3 applications&#46; When writing new
    applications, it is not recommended to use this subroutine; it may cause
    reduced performance in the future&#46; Applications should use the
    compare_and_swap (compare_and_swap Subroutine) subroutine, unless they
    need to use unaligned memory locations&#46;

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"

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-10-01 15:44:00
Subject: Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Previous:From: Bruce MomjianDate: 2001-10-01 15:41:44
Subject: Re: Spinlock performance improvement proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group