BUG #6425: Bus error in slot_deform_tuple

From: postgres(at)dunquino(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6425: Bus error in slot_deform_tuple
Date: 2012-02-01 14:28:30
Message-ID: E1RsbAk-00007G-LC@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-bugspgsql-hackers

The following bug has been logged on the website:

Bug reference: 6425
Logged by: orval
Email address: postgres(at)dunquino(dot)com
PostgreSQL version: 9.0.6
Operating system: Solaris 10 u9

This is intermittent and hard to reproduce but crashes consistently in the
same place. That place is backend/access/common/heaptuple.c line 1104:

values[attnum] = fetchatt(thisatt, tp + off);

off is always 0, tp is an unaligned address (not divisible by 4 -- this is
Sparc BTW.) I've seen tup->t_hoff set to 0x62 and 0x82 in different core

This system is using streaming replication, and the problem always occurrs
on the secondary. The system is under heavy load, both in terms of queries
and DML on the primary. There are usually quite a lot of deadlocks going

The query in question each time is a join between a table called preferences
and one called preference_fields. The tuple is in preference_fields. I have
not confirmed this is a cause, but the following statement does appear in
one of the scripts in action:

DELETE FROM preference_fields WHERE preference_field_id NOT IN (SELECT
DISTINCT preference_field_id FROM preferences);

There is also this kind of nasty stuff going on:

ALTER TABLE preferences RENAME TO preferences_old;
ALTER TABLE preferences_1326144465 RENAME TO preferences;

Where preferences_1326144465 is a copy of preferences that is used during a
data import process.

At the moment I have asserts in the places where t_hoff is set, looking for
(address % 4 != 0) but it's been going for a couple of days and it hasn't
happened yet. Any advice on where better to put some debugging would be
gratefully received.


Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2012-02-01 15:38:05 Re: Progress on fast path sorting, btree index creation time
Previous Message Marko Kreen 2012-02-01 14:19:42 Re: Speed dblink using alternate libpq tuple storage

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2012-02-01 15:38:40 Re: BUG #6200: standby bad memory allocations on SELECT
Previous Message o.bousche 2012-02-01 14:15:02 BUG #6424: Possible error in time to seconds conversion