Re: [GENERAL] Corrupted Data ?

2016-08-13 Thread Francisco Olarte
Hi Adrian: On Fri, Aug 12, 2016 at 9:01 PM, Adrian Klaver wrote: > "Specially if this happens, you may have some slightly bad disks/ram/ > leading to this kind of problems." > > Trying to reconcile that with all the physical machine 1 VMs sharing the > same RAM and

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Adrian Klaver
On 08/12/2016 11:51 AM, Ioana Danes wrote: On Fri, Aug 12, 2016 at 2:50 PM, Adrian Klaver > wrote: On 08/12/2016 08:30 AM, Ioana Danes wrote: The db3 database is on a different machine from all the other

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 2:50 PM, Adrian Klaver wrote: > On 08/12/2016 08:30 AM, Ioana Danes wrote: > >> >> >> > >> >> The db3 database is on a different machine from all the other >> databases you set up, correct? >> >> Yes, they are all different vms first 3

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Adrian Klaver
On 08/12/2016 08:30 AM, Ioana Danes wrote: The db3 database is on a different machine from all the other databases you set up, correct? Yes, they are all different vms first 3 dbs are on the same cluster but drdb is a remote machine, This rattled around in my head and got less

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 12:22 PM, Adrian Klaver wrote: > On 08/12/2016 08:49 AM, Ioana Danes wrote: > >> >> >> On Fri, Aug 12, 2016 at 11:44 AM, Ioana Danes > > wrote: >> >> >> > kvm >> >> Sorry I should add more

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Adrian Klaver
On 08/12/2016 08:49 AM, Ioana Danes wrote: On Fri, Aug 12, 2016 at 11:44 AM, Ioana Danes > wrote: kvm Sorry I should add more info kernel 4.7 and the filesystem is xfs vs ext3/ext4 Not following the above. Do you mean the physical

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 11:44 AM, Ioana Danes wrote: > > > On Fri, Aug 12, 2016 at 11:34 AM, Adrian Klaver > wrote: > >> On 08/12/2016 08:30 AM, Ioana Danes wrote: >> >>> >>> >>> On Fri, Aug 12, 2016 at 11:26 AM, Adrian Klaver >>>

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 11:34 AM, Adrian Klaver wrote: > On 08/12/2016 08:30 AM, Ioana Danes wrote: > >> >> >> On Fri, Aug 12, 2016 at 11:26 AM, Adrian Klaver >> > wrote: >> >> On 08/12/2016 08:10 AM,

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Adrian Klaver
On 08/12/2016 08:30 AM, Ioana Danes wrote: On Fri, Aug 12, 2016 at 11:26 AM, Adrian Klaver > wrote: On 08/12/2016 08:10 AM, Ioana Danes wrote: On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 11:26 AM, Adrian Klaver wrote: > On 08/12/2016 08:10 AM, Ioana Danes wrote: > >> >> >> On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte >> > wrote: >> >> CCing to the list... >> >>

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Adrian Klaver
On 08/12/2016 08:10 AM, Ioana Danes wrote: On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte > wrote: CCing to the list... Thanks On Fri, Aug 12, 2016 at 4:10 PM, Ioana Danes

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte wrote: > CCing to the list... > > Thanks > On Fri, Aug 12, 2016 at 4:10 PM, Ioana Danes wrote: > >> given 318220 and 318216 are just a bit away ( 4db08/4db0c ), and it > >> repeats sporadically,

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Francisco Olarte
CCing to the list... On Fri, Aug 12, 2016 at 4:10 PM, Ioana Danes wrote: >> given 318220 and 318216 are just a bit away ( 4db08/4db0c ), and it >> repeats sporadically, have you ruled out ( by having page checksums or >> other mechanism ) a potential disk read/write error ?

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
Hi Melvin, On Fri, Aug 12, 2016 at 9:36 AM, Melvin Davidson wrote: > > > On Fri, Aug 12, 2016 at 9:09 AM, Ioana Danes wrote: > >> Hello Everyone, >> >> I have new information on this case. I also open a post for Bucardo >> because I am still not

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Francisco Olarte
On Fri, Aug 12, 2016 at 3:09 PM, Ioana Danes wrote: > drawid | 318220 ... > drawid | 318216 > Here are the facts I know: > > August 10 @ 11:10 > - The record was created on db1 and replicated to db2 and db3 > August 11 @ 2:30 >

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Melvin Davidson
On Fri, Aug 12, 2016 at 9:09 AM, Ioana Danes wrote: > Hello Everyone, > > I have new information on this case. I also open a post for Bucardo > because I am still not sure what triggers this problem. > > The problem happened again on the same table but on another field.

Re: [GENERAL] Corrupted Data ?

2016-08-12 Thread Ioana Danes
Hello Everyone, I have new information on this case. I also open a post for Bucardo because I am still not sure what triggers this problem. The problem happened again on the same table but on another field. Few days ago I started a fourth database called drdb that is a PITR slave from db3.

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Adrian Klaver
On 08/08/2016 10:06 AM, Ioana Danes wrote: On Mon, Aug 8, 2016 at 12:55 PM, Adrian Klaver> 75315811??? Corrupted index on db3? yes Might want to look in the db3 logs to see if anything pops out. I checked the logs, no traces of errors or corruption. I just do not

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Ioana Danes
On Mon, Aug 8, 2016 at 12:55 PM, Adrian Klaver wrote: > On 08/08/2016 09:47 AM, Ioana Danes wrote: > >> >> >> On Mon, Aug 8, 2016 at 12:37 PM, Adrian Klaver >> > wrote: >> >> On 08/08/2016 09:28 AM, Ioana

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Adrian Klaver
On 08/08/2016 09:47 AM, Ioana Danes wrote: On Mon, Aug 8, 2016 at 12:37 PM, Adrian Klaver > wrote: On 08/08/2016 09:28 AM, Ioana Danes wrote: On Mon, Aug 8, 2016 at 12:19 PM, Adrian Klaver

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Melvin Davidson
On Mon, Aug 8, 2016 at 12:47 PM, Ioana Danes wrote: > > > On Mon, Aug 8, 2016 at 12:37 PM, Adrian Klaver > wrote: > >> On 08/08/2016 09:28 AM, Ioana Danes wrote: >> >>> >>> >>> On Mon, Aug 8, 2016 at 12:19 PM, Adrian Klaver >>>

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Ioana Danes
On Mon, Aug 8, 2016 at 12:37 PM, Adrian Klaver wrote: > On 08/08/2016 09:28 AM, Ioana Danes wrote: > >> >> >> On Mon, Aug 8, 2016 at 12:19 PM, Adrian Klaver >> > wrote: >> >> On 08/08/2016 09:11 AM, Ioana

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Adrian Klaver
On 08/08/2016 09:28 AM, Ioana Danes wrote: On Mon, Aug 8, 2016 at 12:19 PM, Adrian Klaver > wrote: On 08/08/2016 09:11 AM, Ioana Danes wrote: Hi, I suspect I am having a case of data corruption. Here are the

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Ioana Danes
On Mon, Aug 8, 2016 at 12:19 PM, Adrian Klaver wrote: > On 08/08/2016 09:11 AM, Ioana Danes wrote: > >> Hi, >> >> I suspect I am having a case of data corruption. Here are the details: >> >> I am running postgres 9.4.8: >> >> postgresql94-9.4.8-1PGDG.rhel7.x86_64 >>

Re: [GENERAL] Corrupted Data ?

2016-08-08 Thread Adrian Klaver
On 08/08/2016 09:11 AM, Ioana Danes wrote: Hi, I suspect I am having a case of data corruption. Here are the details: I am running postgres 9.4.8: postgresql94-9.4.8-1PGDG.rhel7.x86_64 postgresql94-contrib-9.4.8-1PGDG.rhel7.x86_64 postgresql94-libs-9.4.8-1PGDG.rhel7.x86_64

[GENERAL] Corrupted Data ?

2016-08-08 Thread Ioana Danes
Hi, I suspect I am having a case of data corruption. Here are the details: I am running postgres 9.4.8: postgresql94-9.4.8-1PGDG.rhel7.x86_64 postgresql94-contrib-9.4.8-1PGDG.rhel7.x86_64 postgresql94-libs-9.4.8-1PGDG.rhel7.x86_64 postgresql94-server-9.4.8-1PGDG.rhel7.x86_64 on CentOS Linux

Re: [GENERAL] Corrupted Data?

2004-09-14 Thread Alvaro Herrera
On Tue, Sep 14, 2004 at 08:13:24AM -0400, Matthew T. O'Connor wrote: On Tue, 2004-09-14 at 00:46, Chester Kustarz wrote: On Mon, 13 Sep 2004, Matthew T. O'Connor wrote: I backed up the entire data directory, and did a pg_resetxlog, but that didn't help. I found the specific row that