[Pgpool-general] pgpool behing cursors?

[Mike Axiak]

I was only through my application.
And in the python shell it seems to be triggered when I use SET:

$ python
>>> import psycopg
>>> connection = psycopg.connect("user=xxxxx dbname=*******
password='************' host=localhost port=5433")
>>> c = connection.cursor()
>>> c.execute("SET TIME ZONE 'America/New_York'")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg.ProgrammingError: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

SET TIME ZONE 'America/New_York'

Cheers,
Mike

On Mon, Nov 3, 2008 at 4:25 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Can you provide me a reproducable example? I could not reproduce your
> problem here.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
> > Hello,
> >
> > I've been trying to make pgpool-II working with master_slave_mode = true.
> It
> > works if I use psql with no cursor.
> > However, with the application I'm trying to run this on, I get the
> > following:
> >     server closed the connection unexpectedly
> >     This probably means the server terminated abnormally
> >     before or while processing the request.
> >
> > Whenever I try to perform any query with a cursor. It seems to be calling
> > read_kind_from_backend and I get this at the end of a query:
> > ....
> > 2008-11-03 03:48:24 DEBUG: pid 31882: read_kind_from_backend: read kind
> from
> > 1 th backend Z NUM_BACKENDS: 2
> > 2008-11-03 03:48:24 DEBUG: pid 31882: pool_process_query: kind from
> backend:
> > Z
> > 2008-11-03 03:48:24 DEBUG: pid 31882: pool_read_message_length: slot: 0
> > length: 5
> > 2008-11-03 03:48:24 DEBUG: pid 31882: pool_read_message_length: slot: 1
> > length: 5
> > 2008-11-03 03:48:24 DEBUG: pid 31882: ReadyForQuery: message length: 5
> > --> 2008-11-03 03:48:24 ERROR: pid 31882: pool_read_kind: kind does not
> > match between master(84) slot[1] (73) <--
> >
> > Could you help me figure out what's wrong? My /etc/pgpool.conf is
> attached
> > below.
> >
> > What I'm trying to do is this:
> >
> >              +------------+
> > App -->   | PGPool |   --- Read query--> | localhost |
> >              +------------+    +-Write query -->| master pg server |
> >
> > The servers trust all connections, and I can connect/query using psql
> fine.
> > It's only when I use my application that uses cursors that it seems to be
> > failing.
> >
> > Thanks for your help in the matter!
> >
> > Cheers,
> > Mike
> >
> > /etc/pgpool.conf
> > ========================================
> > # pgpool-II configuration file
> >
> > listen_addresses = 'localhost'
> > port = 5433
> >
> > pcp_port = 9898
> > socket_dir = '/var/run/postgresql'
> > pcp_socket_dir = '/var/run/postgresql'
> > pcp_timeout = 10
> > num_init_children = 32
> > max_pool = 4
> > child_life_time = 300
> > connection_life_time = 0
> > child_max_connections = 0
> >
> > authentication_timeout = 60
> > logdir = '/var/run/postgresql'
> >
> > replication_mode = false
> > replication_strict = false
> > replication_timeout = 5000
> > load_balance_mode = true
> > replication_stop_on_mismatch = false
> > replicate_select = false
> >
> > # Semicolon separated list of queries to be issued at the end of a
> session
> > reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> > print_timestamp = true
> > master_slave_mode = true
> >
> > connection_cache = true
> > health_check_timeout = 20
> > health_check_period = 0
> > health_check_user = 'nobody'
> >
> > insert_lock = false
> >
> > ignore_leading_white_space = false
> > log_statement = false
> > log_connections = false
> > log_hostname = false
> > parallel_mode = false
> > enable_query_cache = false
> >
> > #set pgpool2 hostname
> > pgpool2_hostname = ''
> >
> > # system DB info
> > system_db_hostname = 'localhost'
> > system_db_port = 5432
> > system_db_dbname = 'pgpool'
> > system_db_schema = 'pgpool_catalog'
> > system_db_user = 'pgpool'
> > system_db_password = ''
> >
> > # backend_hostname, backend_port, backend_weight
> > backend_hostname0 = 'xxxxxx'
> > backend_port0 = 5432
> > backend_weight0 = 0
> > backend_hostname1 = 'localhost'
> > backend_port1 = 5432
> > backend_weight1 = 1
> >
> > enable_pool_hba = true
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081103/76c24cf2/attachment.html