Re: PL/R Median Busts Commit (Postgres 9.1.6 + plr 8.3.0.13 on Ubuntu 12.10 64 bit)

On 25/01/13 10:12, Mark Kirkwood wrote:
> On 25/01/13 04:14, Joe Conway wrote:
>> On 01/24/2013 05:21 AM, Mark Kirkwood wrote:
>>> I admit - it sounds unlikely. However a simple scenario (attached) gives
>>> rise to:
>>
>> This is the wrong place for the bug report on PL/R I think, but I'll
>> take a look.
>>
>> Joe
>>
>>
>
> FYI - 8.4 shows the same behaviour as 9.1, but 8.3 gets a SUGUSR1:
>
>
> Program received signal SIGUSR1, User defined signal 1.
> 0x00000000005a401f in SIInsertDataEntry (segP=0x7f3b8ea5e2a0,
> data=data(at)entry=0x4082d10) at sinvaladt.c:255
> 255 segP->buffer[segP->maxMsgNum % MAXNUMMESSAGES] = *data;
> (gdb)
>
>

Sorry - the others are getting a SIGUSR1 too (just was not so obvious).
Here's bt from 9.1:

Program received signal SIGUSR1, User defined signal 1.
0x00007f2bfe4c1707 in kill () from /lib/x86_64-linux-gnu/libc.so.6
(gdb) bt
#0 0x00007f2bfe4c1707 in kill () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x0000000000611683 in SICleanupQueue (callerHasWriteLock=1 '\001',
minFree=<optimized out>) at sinvaladt.c:672
#2 0x0000000000611768 in SIInsertDataEntries (data=0x7f2bf68b4cb0, n=0)
at sinvaladt.c:437
#3 0x00000000006cdad1 in ProcessInvalidationMessagesMulti (hdr=0x295b240,
func=0x610de0 <SendSharedInvalidMessages>) at inval.c:402
#4 0x00000000006ce780 in AtEOXact_Inval (isCommit=<optimized out>)
at inval.c:940
#5 0x00000000004826cd in CommitTransaction () at xact.c:1893
#6 0x000000000048467d in CommitTransactionCommand () at xact.c:2562
#7 0x0000000000623a17 in finish_xact_command () at postgres.c:2452
#8 finish_xact_command () at postgres.c:2441
#9 0x0000000000626b5d in exec_simple_query (query_string=0x29f7d60
"COMMIT;")
at postgres.c:1051
#10 PostgresMain (argc=<optimized out>, argv=<optimized out>,
username=<optimized out>) at postgres.c:3968
#11 0x00000000005eb429 in BackendRun (port=0x2979f00) at postmaster.c:3611
#12 BackendStartup (port=0x2979f00) at postmaster.c:3296
#13 ServerLoop () at postmaster.c:1460
#14 0x00000000005ebd3c in PostmasterMain (argc=<optimized out>,
argv=0x2955600)
at postmaster.c:1121
#15 0x0000000000453d20 in main (argc=1, argv=0x2955600) at main.c:199
(gdb)