Re: problems on Solaris

On Mon, May 25, 2015 at 1:07 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> On 2015-05-24 19:44:37 -0400, Andrew Dunstan wrote:
>>
>> Buildfarm members casteroides and protosciurus have been having some
>> problems that seem puzzling. These animals both run on the same machine, but
>> with different compilers.
>>
>> casteroides runs with the Sun Studio 12 compiler, and has twice in the last
>> 3 days demonstrated this error:
>>
>> [5561ce0c.51b7:25] LOG: starting background worker process "test_shm_mq"
>> [5561ce1e.5287:9] PANIC: stuck spinlock (100cb77f4) detected at atomics.c:30
>> [5561ce1e.5287:10] STATEMENT: SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,270000)), 200, 3);
>> [5561ce0c.51b7:26] LOG: server process (PID 21127) was terminated by signal 6
>> [5561ce0c.51b7:27] DETAIL: Failed process was running: SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,270000)), 200, 3);
>> [5561ce0c.51b7:28] LOG: terminating any other active server processes
>>
>> It's not constant - between the two failures was a success.
>
> That's indeed rather odd. For one the relevant code does nothing but
> lock/unlock a spinlock. For another, there's been no recent change to
> this and casteroides has been running happily for a long time.
>
>> protociurus runs with gcc 3.4.3 and gets this error:
>>
>> gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -I/usr/local/include -m64 -I. -I../../../src/interfaces/libpq -I./../regress -I../../../src/include -c -o specparse.o specparse.c
>> In file included from /usr/include/sys/vnode.h:47,
>> from /usr/include/sys/stream.h:22,
>> from /usr/include/netinet/in.h:66,
>> from /usr/include/netdb.h:98,
>> from ../../../src/include/port.h:17,
>> from ../../../src/include/c.h:1114,
>> from ../../../src/include/postgres_fe.h:25,
>> from specparse.y:13:
>> /usr/include/sys/kstat.h:439: error: syntax error before numeric constant
>> /usr/include/sys/kstat.h:463: error: syntax error before '}' token
>> /usr/include/sys/kstat.h:464: error: syntax error before '}' token
>> In file included from /usr/include/sys/stream.h:22,
>> from /usr/include/netinet/in.h:66,
>> from /usr/include/netdb.h:98,
>> from ../../../src/include/port.h:17,
>> from ../../../src/include/c.h:1114,
>> from ../../../src/include/postgres_fe.h:25,
>> from specparse.y:13:
>> /usr/include/sys/vnode.h:105: error: syntax error before "kstat_named_t"
>
> I'd noticed this one as well. This sounds like a installation problem,
> not really ours. Dave, any chance you could look into this, or give
> somebody an account to test what's up?

I'm not going to be able to look at this, at least this week. I can
give someone on the EDB team access - Robert; can one of your guys
take a look?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company