X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7B5063A5354 for ; Mon, 22 Nov 2004 19:43:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46112-10 for ; Mon, 22 Nov 2004 19:43:04 +0000 (GMT) Received: from ecintweb.eldocomp.com (ecintweb.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 4C0AA3A534F for ; Mon, 22 Nov 2004 19:43:04 +0000 (GMT) Received: by ecintweb.eldocomp.com with XWall v3.29f ; Mon, 22 Nov 2004 12:43:03 -0700 From: Naomi Walker To: Chris Hoover Cc: "pgsql-admin@postgresql.org" Subject: Re: URGENT - HELP WITH 7.3.4 Strangeness Date: Mon, 22 Nov 2004 12:42:58 -0700 X-Assembled-By: XWall v3.29f Message-ID: <41A24142.5000406@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=EXCUSE_16, LINES_OF_YELLING X-Spam-Level: X-Archive-Number: 200411/164 X-Sequence-Number: 15548 Chris, I feel your pain. Even though it is odd because all servers seem alike=20 in their problems, it smells like a memory problem. Was anything=20 changed just prior to your problems? Has everything been running fine=20 on this version of OS and postgres before this happened? Another idea is that you are moving corrupted data, and once it gets=20 used some, it is messing things up, so the problems follow the data. Did=20 you see any strangeness when moving the data? Naomi >=20 > In synopsis: >=20 > System runs fine after reboot, but appears to start having index=20 > issues. We are able to query the db and see the data if we force a seq=20 > scan, but an index scan returns random results. Nothing has changed=20 > application or db wise. >=20 > All server Dell Poweredge 2650's > RedHat ES 2.1 > Postgres 7.3.4 (with perl) > DB's on Dell PowerVaults using raid5 >=20 > I really need some help solving this. I have never seen anything like=20 > this before. Does anyone have any ideas? > Thanks, >=20 > Chris >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) --=20 ------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ------------------------------------------------------------------------- Courage is the power to let go the familiar. -Raymond Lindquist ------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to wh= om it is addressed, and may contain information that is privileged, confiden= tial and exempt from disclosure under applicable law. If you are not the int= ended addressee, nor authorized to receive for the intended addressee, you a= re hereby notified that you may not use, copy, disclose or distribute to any= one the message or any information contained in the message. If you have rec= eived this message in error, please immediately advise the sender by reply e= mail, and delete the message. Thank you.