Re: Insert Assertion Failed in strcoll_l.c:112

Thanks Tom, but no luck this time: both boxes now on Ubuntu 12.10, but
same error.

Also removed -march gcc switch, likewise with no impact on error.

Kind regards,
Michael From: Tom Lane
Sent: 24/12/2012 1:16 AM
To: Michael Arnold
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Insert Assertion Failed in strcoll_l.c:112
Michael Arnold <myk321(at)gmail(dot)com> writes:
> The following is written to /var/log/postgresql/postgresql-9.1-main.log:

> 127.0.0.1(59800) INSERT: strcoll_l.c:112: __strcoll_l: Assertion
> `((uintptr_t)
> indirect) % __alignof__ (indirect[0]) == 0' failed.

This appears to be a failure inside glibc (specifically strcoll_l()).
There is certainly noplace in Postgres proper that would print such a
message.

> Error occurring on Ubuntu 12.04 with PostgreSQL 9.1 on Dell PowerEdge R710

> Same code executes successfully on Ubuntu 12.10 with PostgreSQL 9.1 on Dell
> Precision 390.

I would take that to mean this is a glibc bug that was fixed between
Ubuntu releases 12.04 and 12.10. Update the older system and see if it
doesn't go away.

regards, tom lane