Re: Problem on AIX with current

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Problem on AIX with current
Дата
Msg-id 20011002004242H.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Problem on AIX with current  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Ответы Re: Problem on AIX with current  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Следующее
От: Lee Kindness
Дата:
Сообщение: Re: Bulkloading using COPY - ignore duplicates?