[pgpool-general: 1075] Re: Statement Parse

[Khapare Joshi]

hello all,

I been struggling with this issue whole day today but I do  not know if
this is bug in 3.2 version or not however, I downloaded from the
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE

recompiled and installed - this looks working now. It would be good people
share if they were having similar issue.

KH

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

> 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/a6269400/attachment-0001.html>