Re: 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