Hi Atsushi. Of course i can let you all the information that you need. I was executing with debug mode to show all messages that sends or receibes the db. I'll put the config files and logs in a few days. I hope that it can help to all the pgcluster comunity. Regards
----- Mensaje original ----- De: "Atsushi Mitani" <[email protected]> Para: [email protected] Enviados: Martes, 7 de Julio 2009 18:13:17 GMT +01:00 Amsterdam / Berlín / Berna / Roma / Estocolmo / Viena Asunto: Re: [Pgcluster-general] PGcluster recovery error with -R option Hi Pedro, Would you let us know contents of your configuration files, hosts files, and debug logs. You can get debug logs when you start pgcluster with -lv option. Regards, ------------ At.Mitani Pedro Delgado <[email protected]> wrote: Hi again. I tryed the configuration that you told me in the previous response and doesn't work, I have worst result than the configuration done before. The situation it's 3 db servers, with load balancer and replication server. I start all of them and do some insert and select to test the configuration, all it's works fine, all db are syncronized and have the same data. Then i poweroff one server and start it with -R option to have a dynamic recovery while i'm putting more data, but the results are so strage. The master db have all the insert, about 150, the second db was blocked and have no inserts!! the db that was recovering have 145 rows, lost five rows in the process. I think that it's a bug, because all it works fine until do the recovery with -R, if someone have this scheme working with dynamic recovery and without fail, please tell me how i have to configure that. If no one have this scheme i'll like to open a bug for this situation to improve this option because a partial recovery it's very bad recovery, worse than no recovery anithing. Greetings ----- Mensaje original ----- De: [email protected] Para: [email protected] Enviados: Viernes, 3 de Julio 2009 3:18:39 GMT +01:00 Amsterdam / Berl将ソn / Berna / Roma / Estocolmo / Viena Asunto: Re: [Pgcluster-general] PGcluster recovery error with -R option Hi Pedro, First of all, at least three cluster db and load balancer are required in order to finish recovery with -R option successfully. The recovery follows the following actions, 1. All db data were copied to the target DB from the master DB as 1st rsync. 2. Sessions were brocked to the master DB and the target DB at load balancer. 3. All db data were copied to target DB from master DB as 2nd rsync. During 2nd rsync, these DB servers have to keep rsync only. During 2nd rsync, all sessions are executed at the 3rd cluster DB, and the data write queries (like INSERT, UPDATE) are put into queue files in the replication server. 4. Send stored queries to the master db and the target db from the replication server. Got it? Regards, -------------------- At.Mitani -- original message -- From: Pedro Delgado To: PGCluster Sent: Thu, 2 Jul 2009 10:17:24 +0200 (CEST) Subject: [Pgcluster-general] PGcluster recovery error with -R option >Hi, I configured pgcluster with 2 data base servers. >All it works fine, but when I start a database in recovery mode con -R option >and I make a lot of insert/update in the other database, I lost some rows in >the process. >This problem it's so stragne because a big number of rows are correctly >replicated when the data base it's in recovery mode, but a few number no. >I tryed tu insert 100 rows in the started database when one data base it's >recoveryng with -R. When the process ended i checked the content of two >databases. The first (active) have the 100 rows, the second (recover) have 96 >rows, it lost four rows. >This fail it's critical because the database cluster it's inconsistent. >Some one know about this problem? it's that a problem o a configuration error? >In my configuration all the features works fine (cluster, load balancer, >replication server) and i think that it's a bug of pgcluster, but I'm not >sure. >If some one can help me I'll be very agreed. >Greetings. >_______________________________________________ >Pgcluster-general mailing list >[email protected] >http://pgfoundry.org/mailman/listinfo/pgcluster-general > _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general Power up the Internet with Yahoo! Toolbar. _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
