[pgpool-general: 1074] Re: Statement Parse

[Khapare Joshi]

Follow up:

When I connect with pgadmin I get following in the pgpool log

Oct  4 14:02:35 pgpool pgpool[15454]: connection received:
host=myservertest port=57997
Oct  4 14:02:35 pgpool pgpool[15454]: statement: SELECT version();
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: SELECT version();
Oct  4 14:02:35 pgpool pgpool[15454]: statement: SET DateStyle=ISO;#012SET
bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS
encoding, datlastsysoid#012  FROM pg_database WHERE datname='test1'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: BEGIN
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: BEGIN
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012  FROM
pg_database WHERE datname='test1'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012  FROM
pg_database WHERE datname='test1'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: COMMIT
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: COMMIT
Oct  4 14:02:35 pgpool pgpool[15454]: statement: set client_encoding to
'UNICODE'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: BEGIN
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: BEGIN
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: set client_encoding to 'UNICODE'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: set client_encoding to 'UNICODE'
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452
statement: COMMIT
Oct  4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949
statement: COMMIT


so when I am connecting via php or datastudio - why it does not set the
proper parameter for the data encoding ?

Am I missing something, can someone point me into right direction ?

KH


On Thu, Oct 4, 2012 at 12:35 PM, Khapare Joshi <khapare77 at gmail.com> wrote:

> Hello all,
>
> I can connect via pgamin3 to pgpool and run the query/insert statement.
> All seem work. Our development is based in php so when we connect via php
> and try query I get following error in pgpool.log
>
> Oct  4 12:23:20 pgpool pgpool[7845]: DB node id: 0 backend pid: 24441
> statement: Parse: �#017�#001
> Oct  4 12:23:20 pgpool pgpool[7845]: DB node id: 1 backend pid: 3008
> statement: Parse: �#017�#001
> Oct  4 12:23:20 pgpool pgpool[7845]: Bind: cannot get parse message
> "pdo_stmt_00000001"
> Oct  4 12:23:20 pgpool pgpool[7845]: do_child: exits with status 1 due to
> error
>
>
> So, it seem to me php pdo is not sending the right info to the pgpool.
> Does anybody know how to resolve this issue ?
>
> my pgpool version is :
> 3.2
>
> postgres backend are : 9.2
>
> Thanks in advance
>
> KH
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121004/e4c0e23b/attachment.html>