"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
>> Of course the working source is 3rd October.
> Tom, do you have an idea what you might have fixed to that effect ?
No idea. I've been fixing some portability issues in dynahash.c,
but AFAIK they only affected the pgstats collector proce
>
> > > I am quite sure that all AIX Versions accept the CLOBBER method,
> > > thus I ask you to apply the following patch, to make it work.
> >
> > CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> > PSTAT and PS_STRINGS can not be used since AIX5L does not have
> > appropreat
> > > BTW, still I'm getting the stucking backends. New info: a snapshot
> > > dated on 10/3 works fine.
> >
> > I allways have trouble with those different date formats. Do you
> > mean, that the problem is fixed as of 3. October, or that an old
> > snapshot from 10. March still worked ?
>
> O
> > BTW, still I'm getting the stucking backends. New info: a snapshot
> > dated on 10/3 works fine.
>
> I allways have trouble with those different date formats. Do you
> mean, that the problem is fixed as of 3. October, or that an old
> snapshot from 10. March still worked ?
Of course the work
> BTW, still I'm getting the stucking backends. New info: a snapshot
> dated on 10/3 works fine.
I allways have trouble with those different date formats. Do you
mean, that the problem is fixed as of 3. October, or that an old
snapshot from 10. March still worked ?
Snapshot of 1. Oct 2001 does
> > > I am quite sure that all AIX Versions accept the CLOBBER method,
> > > thus I ask you to apply the following patch, to make it work.
> >
> > CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> > PSTAT and PS_STRINGS can not be used since AIX5L does not have
> > appropreate h
> > I am quite sure that all AIX Versions accept the CLOBBER method,
> > thus I ask you to apply the following patch, to make it work.
>
> CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> PSTAT and PS_STRINGS can not be used since AIX5L does not have
> appropreate header files
Patch rejected, please resubmit:
CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
PSTAT and PS_STRINGS can not be used since AIX5L does not have
appropreate header files).
--
Tatsuo Ishii
>
> > > Only problem on AIX is, that the argv[0] stuff does not work anymore
> > > (I thi
> > > Only problem on AIX is, that the argv[0] stuff does not work anymore
> > > (I think since we don't exec() anymore), which is rather annoying.
> >
> > Hmm, perhaps we are selecting the wrong PS_STRINGS method for AIX?
> > Please look at src/backend/utils/misc/ps_status.c and see if one of
>
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
>
> > > Only problem on AIX is, that the argv[0] stuff does not work anymore
> > > (I think since we don't exec() anymore),
> > Only problem on AIX is, that the argv[0] stuff does not work anymore
> > (I think since we don't exec() anymore), which is rather annoying.
>
> Hmm, perhaps we are selecting the wrong PS_STRINGS method for AIX?
> Please look at src/backend/utils/misc/ps_status.c and see if one of
> the other
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> Only problem on AIX is, that the argv[0] stuff does not work anymore
> (I think since we don't exec() anymore), which is rather annoying.
Hmm, perhaps we are selecting the wrong PS_STRINGS method for AIX?
Please look at src/backend/utils/m
> Andreas, have you tried CVS tip lately on AIX? What's your results?
All 77 ok, no hangs, with make check on single CPU AIX 4.3.2.
Only problem on AIX is, that the argv[0] stuff does not work anymore
(I think since we don't exec() anymore), which is rather annoying.
Andreas
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> When I recompiled with LOCK_DEBUG and trace_lwlocks = true, it *works*
> (and saw lots of lock debugging messages, of course). However if I
> turn trace_lwlocks to off, the backend stucks again.
Ugh ... ye classic Heisenbug ...
> Is there anything I can
> If you have no better way of determining what's going on, it might help
> to recompile with LOCK_DEBUG defined, then enable trace_lwlocks in
> postgresql.conf (better turn on debug_print_query, log_timestamp, and
> log_pid too). This will generate rather voluminous log output, perhaps
> enough
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Strange enough, there's no other backend (of course except stats
> collectors) here. I make sure this with ps and pg_stat_activity view.
If you have no better way of determining what's going on, it might help
to recompile with LOCK_DEBUG defined, then en
> > 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"
>
> This process is waiting to acquire the LockMgr lock. Y
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> 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
... cs(3)
> > Seems same as AIX 4?
Yes, identical.
>
> Hmm, does anyone want to produce new s_lock code for AIX that uses
> compare_and_swap? But I'm not sure that's the problem here.
I did once, but performance was worse, so I discarded it.
Since AIX 5 still has it, I see no reason to change
> > 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 o
> 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 afte
21 matches
Mail list logo
