Re: [Pgpool-general] pgpool-II 2.0.1: pool_process_query: 1 th kind D does not match with master connection kind C error

so that you could see the SELECT statement which causes the problem? -- Tatsuo Ishii SRA OSS, Inc. Japan Thanks for your reply. I've added answers to yours questions below. One thing we found in the latest documentation is that SERIAL columns require a LOCK TABLE. We are not currently doing

Re: [Pgpool-general] PgPool-II installation issues

to send all queries to pgpool-II. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

[Pgpool-general] pgpool-II 2.1 beta1 testing results

' [TODO] If DISCARD ALL is specified in the reset_query_list and transaction is not closed when client disconnects, automatically issue ABORT before issue DISCARD ALL. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general

[Pgpool-general] on line recover script possible design flow

supplied recovery scripts want to execute SELECT pg_switch_xlog() or some such on the master node, the script has to know the port number on which the master node's postmaster is running on. Any thought? -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general

Re: [Pgpool-general] TCP connections are *not* closed when a backend timeout

is the patch for this. Could you please try it out? -- Tatsuo Ishii SRA OSS, Inc. Japan Index: main.c === RCS file: /cvsroot/pgpool/pgpool-II/main.c,v retrieving revision 1.37 diff -c -r1.37 main.c *** main.c 22 May 2008 14:36:38 -

Re: [Pgpool-general] TCP connections are *not* closed when a backend timeout

) to archive_command. This will not require PostgreSQL restarting. Just pg_ctl reload is enough. I'm not sure if this works for all PostgreSQL versions though. -- Tatsuo Ishii SRA OSS, Inc. Japan Thanks for all you help Maxence Le Sun, Jul 13, 2008 at 09:41:51AM +0900, Tatsuo Ishii à écrit : Hi

Re: [Pgpool-general] TCP connections are *not* closed when a backend timeout

is enough. I'm not sure if this works for all PostgreSQL versions though. But what will happend if a server fails again ? You need to set archive_command again and do pg_ctl reload. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list

Re: [Pgpool-general] Pgpool-II and Slony-I

of backend_hostname0 etc, should I change these or will it support tertiary_backend_hostname etc? master_backend_hostname is a directive name for pgpool(I). I strongly recommend to use pgpool-II. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list

Re: [Pgpool-general] Pgpool-II and Slony-I

In the master/slave mode, pgpool will throw all DMLs to master only. SELECTs will be thrown to master and slave. Does it presume that hostname0 is the master? Yes. Is there a way to make it throw SELECTS only to the slave/s. backend_weight0 = 0 should do what you want. -- Tatsuo

Re: [Pgpool-general] Pgpool-II and Slony-I

and are differ among PostgreSQL servers. Using different salt produces different encrypted password in #3. Of course if you have only 1 PostgreSQL server, then you don't have the problem of course. But with only 1 PostgreSQL you cannot make master/slave or replication system:-) -- Tatsuo Ishii SRA OSS

Re: [Pgpool-general] Raw mode instead of connection caching/pooling

of an application rewrite. We're only really interested in redirecting UPDATE/INSERT/DELETE anyway, so using raw mode doesn't hurt in our case. Can you tell more about your experience with connection caching/pooling problem? -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] Pgpool-II and Slony-I

as well by the way. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Pgpool-II and Slony-I

. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Raw mode instead of connection caching/pooling

, I'm really interested since I've never heard such reports. If it's child and you are using prepared queries (JDCB, PDO etc.), please try the latest 2.1 version. Pre 2.1 has problems (including process dying) when using prepared queries. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] Hot adding a new node under pgpool-II

need to set up the Online recovery setting (see docs for more info). Add the new node to pgpool.conf. Reload pgpool.conf. Shutdown postmaster running on the new node. Do online recovery. That's it. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general

Re: [Pgpool-general] pgpool error when conecting from pgadmin

not use queries using oids -- Tatsuo Ishii SRA OSS, Inc. Japan anyone can help me ?: I am trying a load balance with 2 postgresql machines. postgresql version 8.33 [EMAIL PROTECTED] ~]# 2008-09-05 14:57:32 DEBUG: pid 5483: read kind from frontend Q(51) 2008-09-05 14:57:32 DEBUG

Re: [Pgpool-general] md5 Authentication problem

How can we use slave servers witout authenticating them? -- Tatsuo Ishii SRA OSS, Inc. Japan Right good question, there's 2 issues that are not clear for me 1) pgpool connections to nodes Right now the postgreSQL servers (slave or master) need to trust pgpool connections

Re: [Pgpool-general] pgpool-II and online recovery process

recovery was finished, pgpool would go through its queue and send those transactions to all nodes. Is that not the case ? Cause basically it went through 1st stage and then pcp_recovery_node timed out. Perhaps you need -C option to pgbench? -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] Connection pooling and amount of connections?

to connect in as a different user will the one of the old connections be used? If not; whats the point? Only if your kernel chooses the child which has the existing connection cache. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list

Re: [Pgpool-general] Difference in updated tuples

*/ if you like. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] can't connect to pgpool

Use ' instead of . i.e. backend_hostname0 = db1 -- no good backend_hostname0 = 'db1' -- good -- Tatsuo Ishii SRA OSS, Inc. Japan Hi. I have 3 machines. 1 is the pgpool controller, the other are 2 postgres nodes. I have a postgres user named pooler on both machines, with db creation

Re: [Pgpool-general] 32 bit pgpool controller and 64 bit postgres hosts

. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] question on pool_connection_pool_timer: set close time

then postgresql connection limit can get exceeded! You really should not do that. I recommend num_init_children to be lower than max_connections of PostgreSQL. -- Tatsuo Ishii SRA OSS, Inc. Japan pgpool-II 2.1.1 num_init_children = 250

Re: [Pgpool-general] how to force pgpool to release client connections?

the problem by using shutdown(2)? -- Tatsuo Ishii SRA OSS, Inc. Japan Index: pool_stream.c === RCS file: /cvsroot/pgpool/pgpool-II/pool_stream.c,v retrieving revision 1.12 diff -c -r1.12 pool_stream.c *** pool_stream.c 4 Jul 2008

Re: [Pgpool-general] how to force pgpool to release client connections?

, what about having new switch: client_idle_limit_in_recovery BTW, do we have to kill clients immediately even if they are *not* idle in online recovery as Tiago said? I tried the patch below on the CVS head but that will take care of other connection issues I guess. Right. -- Tatsuo Ishii SRA

Re: [Pgpool-general] Question about the load balancing algorithm

for each backend will be balanced. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Question about the load balancing algorithm

term, for example, if backend A loads *heavier* than backend B, then wants to throw a query to B, no pgpool is not smart enough. Howver I think the problem here is, how you could define backend A is *heavier* than B. Number of connections, CPU load, I/O load? I'm not sure. -- Tatsuo Ishii SRA OSS

Re: [Pgpool-general] Error message when sending query that causes failover

://lists.pgfoundry.org/pipermail/pgpool-general/2008-July/001119.html -- Tatsuo Ishii SRA OSS, Inc. Japan Hello everyone! I have two instances of PostgreSQL running behind pgpool-II 2.1 with connection pooling, replication and load balancing. Online recovery is working fine with PITR. Now I have

Re: [Pgpool-general] Pgpool-II - replication problems

Can you show me the error log of PostgreSQL? Also is it possible to try the latest version of of pgpool-II (2.1)? -- Tatsuo Ishii SRA OSS, Inc. Japan Hi, I'm trying to configure pgpool-II 2.to to replication between two computers and postgresql database in each. pgpool-II is defined on dev1

Re: [Pgpool-general] Error message when sending query that causes failover

for your help, Tatsuo. You are welcome! -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] MD5 authentication in raw mode

) { pool_send_error_message(frontend, protoMajor, AUTHFAIL_ERRORCODE, Note that the definition of NUM_BACKENDS has been slightly changed in 2.1. I recommend you to try 2.1 with above changing for grab CVS Head and try again. -- Tatsuo Ishii SRA OSS, Inc. Japan Hello, I'm trying to set up a warm standy

Re: [Pgpool-general] client_ilde_limit_in_recovery

Strange. First of all, gram.y should not be processed since gram.c is in the CVS Repository. Second, the problem you are having with bison seemed to be caused by @YFLAFS@ not replaced but I don't have @YFLAGS@ at all in my environment(in my environment, bison -y -d gram.y runs). Just

Re: [Pgpool-general] [pgpool] Online Recovery

. This will prevent a client from sitting idle forever in 2nd stage. So, is there a way (through a script, for example) of knowing what stage is the online recovery process at? Currently no. The only way to know that is looking into log file. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] pool_check_fd: data is not ready error

This error should not happen. In other word, souds like bug and maybe fixed in the latest version. Please try 2.1. -- Tatsuo Ishii SRA OSS, Inc. Japan This morning I was looking at pg_stat_activity table on my master server and there was a query that was idle in transaction since 2008-12-04 03

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

will do the same failover anyway. 3) any failure inside switch does not likely cause the scenario you mentioned. Hope this helps, -- Tatsuo Ishii SRA OSS, Inc. Japan For example, consider two appservers A and B, both running an instance of pgpool. Additionally, we have a master postgres

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

Marcelo, Great. It seems your idea is similar to pgpool-HA, which is using hearbeat. I'm not familiar with ucarp. Is it better than heartbeat? -- Tatsuo Ishii SRA OSS, Inc. Japan Duco, I have tested the following design which perhaps may give you some light/ideas. Basically I had

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

way to prevent it is restarting process(Tatsuo) -- -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

Marcelo, Great. Please post! -- Tatsuo Ishii SRA OSS, Inc. Japan Tatsuo, I also have some online-recory scripts that I have been meaning to post on the list that perhaps some could use it as another example together with the ones you currently provide Marcelo PostgreSQL DBA

Re: [Pgpool-general] pgpool Online Recovery scripts example

archiving *before* doing base backup. 2) In pgpool_recovery_pitr, you do base backup again. I think this is not neccessary if you sends WAL segment files to the recovery target node generated before statge two starts and will greatly reduce the duration of state two. -- Tatsuo Ishii SRA

[Pgpool-general] automatic detection of SERIAL data type

is a long awaited feature since pgpool was born. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] automatic detection of SERIAL data type

CURRENT_TIMESTAMP case(just locking the table is enough). We need to replace the value of CURRENT_TIMESTAMP to a constant. Any idea? -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman

Re: [Pgpool-general] Understanding Error Messages

: ParameterStatus C: CommandComplete -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Understanding Error Messages

Quoting Tatsuo Ishii is...@sraoss.co.jp: BTW, next release of pgpool-II will print the statement which generates the error above. Any idea when the next version will be released? Coming January, I hope. Alternatively, is the current dev version stable enough for production use? I hope

Re: [Pgpool-general] Understanding Error Messages

data consistency among db nodes Note that normal SELECT (without FOR UPDATE) behaves different since it will be load balanced and the query will be sent to one of the DB nodes. -- Tatsuo Ishii SRA OSS, Inc. Japan Happy New Year ~~ Marcelo PostgreSQL DBA Linux/Solaris System

Re: [Pgpool-general] pcp_attach_node problem?

Thanks for the report. I think it's a bug with CVS Head. pgpool should fail over in this case. Fix was committed. Could you please try it out? -- Tatsuo Ishii SRA OSS, Inc. Japan Hello, I have pgpool configured with two backends. Below is the sequence of events to reproduce the seems

Re: [Pgpool-general] pcp_attach_node problem?

Let me look into this... -- Tatsuo Ishii SRA OSS, Inc. Japan Finally, I installed the latest CVS checkout. I uninstalled my previous pgpool-II build by doing: [root ~]# make uninstall [user ~]# make clean Then, went to the just downloaded repository for pgpool-II and did: [user

Re: [Pgpool-general] pcp_attach_node problem?

Did not reproduce here? -- Tatsuo Ishii SRA OSS, Inc. Japan Let me look into this... -- Tatsuo Ishii SRA OSS, Inc. Japan Finally, I installed the latest CVS checkout. I uninstalled my previous pgpool-II build by doing: [root ~]# make uninstall [user ~]# make clean Then, went

Re: [Pgpool-general] pcp_attach_node problem?

Hum, stiil did not reproduce here. Could you show me a debug log of pgpool? -- Tatsuo Ishii SRA OSS, Inc. Japan Well, I tested installing the latest CVS version in a clean box and this is what I get: 1. [Server A] Check the status of the nodes: [root ~]# pcp_node_info 10 localhost 9898

Re: [Pgpool-general] Pgpool help needed.

master. 3) The temp table created on the master server can be accessd as long as you are in the same session in which the temp table has been created. -- Tatsuo Ishii SRA OSS, Inc. Japan Hi, Can anybody tell if pgpool is a connection based load balancer or a query based load balancer

Re: [Pgpool-general] PgAdmin and pgpool-II

Can you run pgpool with debug option (-d) and show an output so that I could figure out what causes the problem? -- Tatsuo Ishii SRA OSS, Inc. Japan Hi everybody. We are testing pgpool-II 2.1 with postgres 8.2.11 in order to increase our database server capacity for an on-line store. Most

Re: [Pgpool-general] Failover shuts down incoming connections

. If you could reproduce the problem Daniel mentioned, please let me know. -- Tatsuo Ishii SRA OSS, Inc. Japan What patch command do you use to apply these patches ? I have tried with the -c flag for context diffs but no luck there I basically added the patch code to the pool_process_query.c file

Re: [Pgpool-general] Location of pgpool.pid

. The reason why /tmp is defaulted is just everyone has the directory which pgpool can write into. I recommend to create another directory to put pgpool.pid, for example, /var/log/pgpool. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool

Re: [Pgpool-general] Location of pgpool.pid

set it to /var/run/postgresql. If you have a good substitution for /tmp, I'm always open to your opinion. But I don't think /var/run/postgresql is appropreate for a new default since not all platform has the directory nor pgpool has a write permission on that. -- Tatsuo Ishii SRA OSS, Inc. Japan

[Pgpool-general] pgpool-II 2.2 and pgpoolAdmin 2.2 beta1 released

stack keeps on retrying for long time and the only way to prevent it is restarting process(Tatsuo) * logdir is no more used. Instead use pid_file_name(Tatsuo) -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list

Re: [Pgpool-general] Simple question about pgpool behavior

', thus the lock will be automatically canceled unless you remove ABORT from reset_query_list. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] pgpool restart

. This is nice since pgpool don't need to stop and start to reflect new config values. Please note that not all config values are changed with reload. Some of them need restarting. See the manual for more details. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool

[Pgpool-general] pgpool-II 2.2 beta2 released

an overhead to look up large number of statements (currently 70), we use bsearch() now. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

70), we use bsearch() now. Nice one :) Thanks for testing and let me know if you have any problem. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

From: Łukasz Jagiełło lukasz.jagie...@gforces.pl Subject: Re: [Pgpool-general] pgpool-II 2.2 beta2 released Date: Mon, 9 Feb 2009 10:27:08 +0100 Message-ID: de899fb00902090127l121b0557j4234fe10c7648...@mail.gmail.com 2009/2/7 Tatsuo Ishii is...@sraoss.co.jp: * pool_process_query.c: Start

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

: DROP DATABASE cannot run inside a transaction block postgres=# \q #v- Guess 'DROP DATABASE' need to be exclude also. Thanks. Will fix. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

Thanks for the report. This is was reported by Lukasz and I have fixed it on the CVS Head. Could you please apply included patches and try? -- Tatsuo Ishii SRA OSS, Inc. Japan On Sat, Feb 7, 2009 at 3:45 PM, Tatsuo Ishii is...@sraoss.co.jp wrote: pgpool-II 2.2 beta2 released. Changes from

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

a restarting all child pgpool processes. See around line 293 in pool_proto_modules.c. -- Tatsuo Ishii SRA OSS, Inc. Japan Tatsuo, I'm starting to test some postgresql commands and I just saw this, besides commenting out the T_CreatedbStmt line in the pool_process_query.c file I also commented out

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

on client connection Maybe I should change the error message looking like PostgreSQL? -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

of pgpool specific tests ? I can think of some now but just wondering. When I get some time I could perhaps put together some python scripts. I don't have a list. Could you show yours? The we could add more tests... -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

more information, Tatsuo, please let me know and I'll gladly provide it. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] pgpool-II 2.2 beta2 released

not be reporting those, would it?) :) But the particular error is forwarded to the client, i.e. pgpool does not neglect it. If pgpool neglects the client exiting abnormaly errors, users will not notice that the client applications do a wrong thing or the user's operation is not correct. -- Tatsuo Ishii

Re: [Pgpool-general] pgpool-II 2.2 RC1 released

Thanks for letting me know! Will fix. -- Tatsuo Ishii SRA OSS, Inc. Japan While performing some queries today it seems that CREATE INDEX CONCURRENTLY is also been placed inside a transaction CREATE INDEX CONCURRENTLY ath_idx ON insta (ath); ERROR: CREATE INDEX CONCURRENTLY cannot run

Re: [Pgpool-general] pgpool-II 2.2 RC1 released

Fix committed. If you want try without downloading the CVS tip, please apply included patches against RC1. -- Tatsuo Ishii SRA OSS, Inc. Japan Thanks for letting me know! Will fix. -- Tatsuo Ishii SRA OSS, Inc. Japan While performing some queries today it seems that CREATE INDEX

Re: [Pgpool-general] pgpool-II 2.2 RC1 released

. On a second note here for those that use rsync for syncing PG nodes. The latest version 3.0.5 has great speed performance improvements. My rsync of the nodes using version 3.0.5 has been around 50% faster than before. 50% is huge. I will add this comment to the docs. -- Tatsuo Ishii SRA OSS, Inc

Re: [Pgpool-general] Reloading the server while under load and recovering the degenerated node

ignores those randomly:-) sent packets thus you should be able to reload postgresql.conf anytime. Please grab the newest pool_process_query.c(1.141) or apply included patches and try it out. -- Tatsuo Ishii SRA OSS, Inc. Japan Hi Jaume, After reading the below I decided to test the reload

Re: [Pgpool-general] pgfail

That's 1333 queries per second. What kind of queries are they? Mostly SELECT? -- Tatsuo Ishii SRA OSS, Inc. Japan Error appears only when big load on pgpool, about 400k queries by 5 minuts. At this time in postgresql.log have been:unexpected EOF on client connection. Error was repeated 55

Re: [Pgpool-general] Query Cache

Anyone want to look into this? I have no time for the moment... -- Tatsuo Ishii SRA OSS, Inc. Japan From: Fil Matthews f...@internetmediapro.com Subject: Query Cache Date: Mon, 2 Mar 2009 04:40:55 + (UTC) Message-ID: 20090302044055.c2f6517ad...@pgfoundry.org Kind Sir, Regarding pgpool

Re: [Pgpool-general] Is Pgpool supported on Open Solaris system?

There should be no reason pgpool-II doesn't work on Open Solaris. Please let me know if you have any problem. -- Tatsuo Ishii SRA OSS, Inc. Japan Hi All, Is Pgpool supported on Open Solaris system?. Thanks Deepak Murthy ___ Pgpool-general

Re: [Pgpool-general] Mismatch among backends

AS '|' CSV; kind details are: 0[C] 1[E] In this case you should have an ERROR message in your slave PostgreSQL log. That would help what was happening. I bet the table TSearcherServices does not exist or the file /opt/pgpool2/TSearcherServices.csv. -- Tatsuo Ishii SRA OSS, Inc. Japan Mar 6 08:10:27

Re: [Pgpool-general] new log messages in 2.2

these after a patch to the last release candidate of version 2.2, when Tatsuo addressed the reloading-cutting-connections problem. I seems logging in 2.2 to be too aggressive. I will make the message level down to DEBUG rather than LOG for upcoming release. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] new log messages in 2.2

into both HEAD and 2.2-STABLE. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Mismatch among backends

Hi Marcelo, I did 3 days continuous stress test using pgbench before RC1 or 2 and got nothing wrong. So the possibility is, 1) I need more load average. 2) I need more complex queries other than just SELECT/UPDATE/INSERT. Thoughts? -- Tatsuo Ishii SRA OSS, Inc. Japan Hi James

Re: [Pgpool-general] Mismatch among backends

by enabling statement log in your PostgreSQL. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Transactions not working properly from ODBC

Right. That's the reason why we cannot drop version 2 protocol. -- Tatsuo Ishii SRA OSS, Inc. Japan It seems that there's no PostgreSQL ODBC driver that supports version 3 protocol, since the one I have is the latest I could find. If you know where can I find it, would be great! I'll keep

Re: [Pgpool-general] panic: index siblings mismatch

Have you turned off autovacuum on the first db node before starting online recovery? -- Tatsuo Ishii SRA OSS, Inc. Japan Hello, today I recognized an error while playing with pgpool-II 2.1 and postgresql 8.3.5 (on 64bit linux). I really don't know if the error is caused by pgpool or if it's

Re: [Pgpool-general] panic: index siblings mismatch

Hi, You need to disable only while online recovery. Afterward you can turn it on. Hint: you do not need to restart PostgreSQL. Edit postgresql.conf and pg_ctl reload is enough to turn on/off autovacumm. -- Tatsuo Ishii SRA OSS, Inc. Japan Hello Tatsuo, oh no, I didn't, shame on me

Re: [Pgpool-general] Prepared statement does not exist

. See DISCARD man pages for details. Note that DISCARD ALL might cause performance degradation because it helds exclusive lock on a system catalog. -- Tatsuo Ishii SRA OSS, Inc. Japan We dont see the below errors if we directly connect to the database. Pgpool is used for load-balancing whiel

Re: [Pgpool-general] syntax error at or near send at character 1

Thanks for the report. I will look into this. -- Tatsuo Ishii SRA OSS, Inc. Japan Hi, I'm wondering why this is caused when I run the following as a quick test. can this syntax error cause any DB mismatch and make the DB get out of sync cause on a real scenario, one time a few minutes

Re: [Pgpool-general] Error in pgpool

need to send prepare to both nodes for BEGIN statement. That's the reason why DEALLOCATE has been sent to both nodes. BTW, can you send us PostgreSQL log with statement logging enabled? It will help to investigate why you are seeing error regarding S_3. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] Error in pgpool

Thanks but I'm looking for the PostgreSQL *when* and *how* the prepared statement (in this case S_4) was created. Probably that can be found a little bit earlier in the PostgreSQL log. -- Tatsuo Ishii SRA OSS, Inc. Japan Tatsuo, Here are the db and pgpool logs at the time of failure. (Pgpool

Re: [Pgpool-general] Authentication in replication mode

protocols within a narrow enough scope that these vulnerabilities are protected? You could use SSH tunnel. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] modular pgpool.conf

host definitions from external files would make it easier to programmatically add and remove nodes from the cluster. Currently pgpool does not such a functionality. I don't think it's terribly hard to implement, but I always welcome patches:-) -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] replicating from a 64 bit server to a 32 bit server.

pgpool copies the files over directly? Yes. I guess I don't understand how pgpool does it's recovery. Does that work while the primary is running? pgpool's recovery is based on PITR, which allows this. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool

Re: [Pgpool-general] Error in pgpool

connects? Yes. Probably it should be documented somewhere though. I.e. I presume everyone connected before I reloaded issued an 'ABORT; DISCARD ALL', and anyone connecting afterwards would use 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' ? Right. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [Pgpool-general] syntax error at or near send at character 1

I couldn't reproduce the problem. Any hint to reproduce it? -- Tatsuo Ishii SRA OSS, Inc. Japan Thanks for the report. I will look into this. -- Tatsuo Ishii SRA OSS, Inc. Japan Hi, I'm wondering why this is caused when I run the following as a quick test. can this syntax error

Re: [Pgpool-general] Error in pgpool

to solve the problem. Please try. By this fix, now reset_query_list should be able to contain DISCARD ALL without any errors in PostgreSQL. -- Tatsuo Ishii SRA OSS, Inc. Japan It would appear that switching reset_query_list back from 'ABORT; DISCARD ALL' to 'ABORT; RESET ALL; SET SESSION

Re: [Pgpool-general] Error in pgpool

it or pool_proto_modules.c has other changes? The patch was against CVS HEAD. Could you try included new patch? It was generated using diff -u (previous one was diff -c) and seems to be nicely applied to 2.2-stable. -- Tatsuo Ishii SRA OSS, Inc. Japan xnagios:/usr/pgsql_src/pgpool-II-2.2# patch -p0 --verbose

Re: [Pgpool-general] pgpool-II documentation

/pgpool-II/doc/load_balance.png Also I'm going to give a talk at PGCon 2009 in Ottawa. I would like to talk about how pgpool-II tries to keep the consistency among databases. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general

Re: [Pgpool-general] setting up replication

Can you show me the PostgreSQL log? 2[N] indicates that there should be some NOTICE message from the third PostgreSQL. 0[C] 1[C] means that the first and second PostgreSQL said we completed the query without any problem. So I need to know why the third PostgreSQL complains. -- Tatsuo Ishii

Re: [Pgpool-general] pgpool-II documentation

. But of coure this will lead to performance degration and/or reader starvation. -- Tatsuo Ishii SRA OSS, Inc. Japan Thanks Ishii. I'll take a look. One of my other questions is that for example I have replication on. If for example I have a servlet that uses JDBC that talks to the pgpool, when

Re: [Pgpool-general] pgpool-II documentation

and not others? No. -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] segfault in pgpool 2.2

sunccess, so I was watching someone coming out with similar problem(it seems it's just an ordinarly update...). Can you provide self contained test case or a stack trace with -g (and without -O2) comipled binary? -- Tatsuo Ishii SRA OSS, Inc. Japan ___ Pgpool

Re: [Pgpool-general] trouble configuring pgpool-II

: PGCONFIG=/path/to/pgconfig/pg_config ./configure Should work as well. -- Tatsuo Ishii SRA OSS, Inc. Japan I'm using Postgresql 8.3.5, and pgpool-II-2.2. Here are the details of what was attempted: r...@sj-prod-db3:/tmp/pgpool-II-2.2# psql --version psql (PostgreSQL) 8.3.5 r...@sj-prod-db3

Re: [Pgpool-general] trouble configuring pgpool-II

Looks like a platform I'm not familiar with... What is the platform? -- Tatsuo Ishii SRA OSS, Inc. Japan Ishii-san, Thanks for the helpful reply. Unfortunately, I'm not sure where the pg_config command is to be found. Here's what I get when trying to locate it: # locate pg_config /usr

Re: [Pgpool-general] Inconsistent execution sequence

Which version of pgpool is this? -- Tatsuo Ishii SRA OSS, Inc. Japan Hi All, I have encountered a problem. I have two pgpool connections. Both try to execute the same statements: 1. BEGIN; 2. UPDATE table SET column1='NewValue' WHERE id=1; 3. END; Sometimes they go into dead

  1   2   3   4   5   6   >