On Thursday, November 03, 2011 1:25:58 am hubert depesz lubaczewski wrote: > Hi > We have pretty weird situation, which seems to be impossible, but perhaps > you'll notice something that will let me fix the problem. > > System: SunOS 5.11 snv_130 > Pg: PostgreSQL 8.4.7 on i386-pc-solaris2.11, compiled by cc: Sun C 5.10 > SunOS_i386 2009/06/03, 64-bit > > > I also verified that there are no concurrent updates that would set > xobject_id to -1, so it's not a problem of isolation. > > During the night I repeated the procedure and the rows that got duplicated > seem to be the same - at the very least - the same magic_id. > > Does above seem sensible for anyone? Any suggestions on what could be > broken? Do the xobject_id values have other negative numbers or is -1 just a special case? The only thing I can think of is a corrupted index on xobject_id. > > Best regards, > > depesz -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
