I have a very strange bug with postgres 7.4.3. I have a table with about
15 million rows and recently, duplicate rows have started appearing.
For simplicity, let's say my table is as follows:
files
---
fileid integer -- Primary key generated by a sequence
userid integer -- id of use
On Fri, 13 Aug 2004, Tom Lane wrote:
> It would be interesting to see the ctid, xmin, cmin, and xmax fields
> as well.
ctid |xmin|cmin|xmax| oid| fileid | userid
--++++--+-+-
(53101,
x27;(53101,30)';
UPDATE 0
#
-Zeki
On Fri, 13 Aug 2004, Tom Lane wrote:
> Zeki Mokhtarzada <[EMAIL PROTECTED]> writes:
> > The system is running on a Dell PowerEdge 2650 running RedHat 8. We had a
> > kernel halt about two weeks ago that was caused by one of our disk mirrors
Very interesting... We recently changed the location of the data files
using a symbolic link. Although all of the files had the correct ownership,
the new parent directory was not owned by postgres. The strange thing
is that we have been running like this for over a week, and even now,
only t
