Hi, In case someone is interested i had to remove options "-ur" from rsync. Only them i was able to fully recover the dettached node.
I haven't investigated further to find the cause. --- Fernando Marcelo www.consultorpc.com [email protected] Em 10/01/2010, às 18:45, Fernando Morgenstern escreveu: > Hello, > > I have pgpool with the following recovery script http://pastebin.ca/1745584 > for 1st and 2nd stage command. > > I had a node that was dettached for a long time and was trying to recover it > during this weekend. While the recovery was run, i also had the following > script being run: > > #!/bin/bash > COUNT=50000 > TOTAL=15000 > > while [ $COUNT != $TOTAL ]; > do > psql -h 192.168.100.50 test -c "INSERT INTO test VALUES ( $COUNT , > $COUNT );" -U postgres > COUNT=`expr $COUNT + 1` > done > > The first time that i tried to recover the node, it worked perfectly. I > verified test table and it had the same number of rows on all nodes. > > But, when i tried to recover it again, i got the following error: > > ERROR: kind mismatch among backends. Possible last query was: "INSERT INTO > test VALUES ( 54600 , 54600 );" kind details are: 0[C] 1[C] 2[E: could not > open relation with OID 326264] > HINT: check data consistency among db nodes > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > connection to server was lost > > Could someone tell me what causes this error and what is the correct way to > fix and avoid having it in the future? > > I am not sure how can i should proceed. I just dettached node 2 ( the one > that was being recovered ) and have left pgpool running with the other 2 > nodes. I verified that i can't use table test on node 2 anymore. > > Best Regards, > --- > > Fernando Marcelo > www.consultorpc.com > [email protected] > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
