2011/8/22 Toshihiro Kitagawa <kitag...@sraoss.co.jp>: > Hello, > > On Fri, 19 Aug 2011 18:11:52 +0200 > Olivier NOEL <noli...@gmail.com> wrote: > >> Hello, >> >> new problem : >> >> 2011-08-19 17:52:03 LOG: pid 8968: find_primary_node: >> pgpool_walrecrunning does not exist >> >> 2011-08-19 18:01:25 LOG: pid 8990: pool_send_and_wait: Error or >> notice message from backend: : DB node id: 1 backend pid: 10280 >> statement: message: cannot execute UPDATE in a read-only transaction >> >> Pgpool seems to send the DML queries to all the backends, instead of >> just the master. Is it normal ? Same config file as above. > > It seems that you failed in installation of pgpool_walrecrunning(). > pgpool_walrecrunning() is the function that is necessary to recognize > a primary node in pgpool-II 3.0.x. > You have to execute install-functions.sh again. > install-functions.sh can download from tutorial page.
I installed them afterwards, but still have these errors. I will check the database. > -- > Toshihiro Kitagawa > SRA OSS, Inc. Japan > >> I followed this tutorial : >> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html >> >> Olivier >> >> 2011/8/17 Olivier NOEL <noli...@gmail.com>: >> > 2011/8/17 Tatsuo Ishii <is...@sraoss.co.jp>: >> >> Are you able to connect to pgpool-II using psql? >> > >> > Yes I was able to connect to pgpool, but with the error and no queries >> > was sent to the servers, pgpool crashed after the error. >> > >> > I moved back to the fresh snapshot I made after installing the OS and >> > postgresql server (The servers are on VMware VMs), and I don't have >> > the error anymore, only the ssl part : SSL requested but SSL support >> > is not available. >> > >> > I am able to connect to pgpool and all queries are sent to the >> > servers, but I still don't know where the error came from. >> > >> > Olivier. >> > >> >> -- >> >> Tatsuo Ishii >> >> SRA OSS, Inc. Japan >> >> English: http://www.sraoss.co.jp/index_en.php >> >> Japanese: http://www.sraoss.co.jp >> >> >> > >> _______________________________________________ >> Pgpool-general mailing list >> Pgpool-general@pgfoundry.org >> http://pgfoundry.org/mailman/listinfo/pgpool-general >> > > _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general