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@xxxxxxxxxxxxxx Subject: Re: Insert Assertion Failed in strcoll_l.c:112 Michael Arnold <myk321@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
