Thread: Duplicate Data/RAID-1/postgres 6.4.2

Duplicate Data/RAID-1/postgres 6.4.2

From
Dustin Tenney
Date:
I am in the process of porting some of my postgres databases over to a new
box.  This box is linux 2.2.0 and is using RAID-1, disk mirroring.  I am
having lots of problems with postgres.  When you do a select you get the
same row twice.  When you create a table you get it twice.  Now at first
glance it would appear something with disk-mirroring, possibly the OS is
causing this.  But I have lots of other things running on this box and
none our experiencing any troubles.  Here is an example of the problem:

createdb test

psql test
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: test

test=> create table huh(test int);
CREATE
test=> \dt

Database    = test
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | postgres         | huh                              | table    |
 | atrix            | huh                              | table    |
 +------------------+----------------------------------+----------+



I created the table with the user postgres.  Atrix is another user that
owns another database.  Is there anybody that has any experience with
postgres on a mirrored partition?  Or has ever seen anything like this
before?  I am pretty sure my raid is working, here is what /proc/mdstat
looks like:

Personalities : [3 raid1]
read_ahead 128 sectors
md0 : active raid1 sda5 sdb5 1542144 blocks [2/2] [UU]
md1 : active raid1 sda6 sdb6 1124416 blocks [2/2] [UU]
md2 : active raid1 sda7 sdb7 1028032 blocks [2/2] [UU]
md3 : active raid1 sda8 sdb8 128384 blocks [2/2] [UU]


/dev/md1 is mounted as /usr where postgres is installed.  Any help with
these matters would be greatly appreciated.  Thank you.

Dustin Tenney
tenney@icebox.org


[ADMIN] Duplicate Data/RAID-1/postgres 6.4.2

From
Mateus Cordeiro Inssa
Date:
Dustin Tenney writes:
 > I am in the process of porting some of my postgres databases over to a new
 > box.  This box is linux 2.2.0 and is using RAID-1, disk mirroring.  I am
 > having lots of problems with postgres.  When you do a select you get the
 > same row twice.  When you create a table you get it twice.  Now at first
 > glance it would appear something with disk-mirroring, possibly the OS is
 > causing this.  But I have lots of other things running on this box and
 > none our experiencing any troubles.  Here is an example of the problem:


  Hi,

  I don't know if RAID-1 is the problem, but upgrade to kernel 2.2.1
ASAP. Kernel 2.2.0 has some fatal bugs.

Mateus Cordeiro Inssa
---------------------
FutureNet
---------------------
Linux User: 76186  Kernel: 2.2.1
ICQ (Licq): 15243895
---------------------
mateus@cwb.fnn.net
mateus@einstein.cwb.fnn.net

sex jan 29 14:49:55 EDT 1999