we still have this error, only this, but it seems doesn't effect the application's performance. is it normal ?<br><div class="gmail_quote"><br>Postgresql log :<br><br>2012-07-05 23:40:16 WIT user=postgres db=epayment_report pid=28114 command=PARSE 4ff5b343.6dd2 ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
2012-07-05 23:40:16 WIT user=postgres db=epayment_report pid=28114 command=PARSE 4ff5b343.6dd2 STATEMENT: SELECT 1<div class="HOEnZb"><div class="h5"><br><br><div class="gmail_quote">On Thu, Jul 5, 2012 at 5:23 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Recently we have fixed problem with JDBC and unamed statement problem.<br>
Can you try out the lastest snapshot(to be released as 3.1.4) of<br>
pgpool-II 3.1 series? You can get it from:<br>
<a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=7015e9f16d34c4f1d28096753638ca78d3d6a7f6;sf=tgz" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=7015e9f16d34c4f1d28096753638ca78d3d6a7f6;sf=tgz</a><br>
<br>
Also debug log of pgpool (start pgpool with -d) would be helpfull.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div><div><br>
> we have a problem in implementing pgpool in testing scenario with this<br>
> environment : (Centos 6 x86_64, 2 Postgresql 8.4 nodes, Pgpool-II-3.1.3 in<br>
> replication mode, application with JDBC 4).<br>
><br>
> Here is the LOG of Pgpool :<br>
><br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: Parse: BEGIN<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: B message<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: Execute: BEGIN<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: Parse: select username from client_user , client_user_role where<br>
> client_user.username='payment1' and<br>
> client_user.password='5039b3c8ffbdb50a2102bc172ebbf755' and<br>
> (client_user_role.role_name='PAYMENT' or<br>
> client_user_role.role_name='SUPERUSER') and<br>
> client_user.role_id=client_user_role.role_id<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: B message<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: D message<br>
> 2012-07-01 00:00:27 LOG: pid 24113: DB node id: 0 backend pid: 29898<br>
> statement: Execute: select username from client_user , client_user_role<br>
> where client_user.username='payment1' and<br>
> client_user.password='5039b3c8ffbdb50a2102bc172ebbf755' and<br>
> (client_user_role.role_name='PAYMENT' or<br>
> client_user_role.role_name='SUPERUSER') and<br>
> client_user.role_id=client_user_role.role_id<br>
> 2012-07-01 00:00:27 LOG: pid 24086: DB node id: 0 backend pid: 24972<br>
> statement: Parse: select airline , flightnum from flight_plan where true<br>
> order by airline, flightnum<br>
> 2012-07-01 00:00:27 LOG: pid 24086: pool_send_and_wait: Error or notice<br>
> message from backend: : DB node id: 0 backend pid: 24972 statement: select<br>
> airline , flightnum from flight_plan where true order by airline, flightnum<br>
> message: current transaction is aborted, commands ignored until end of<br>
> transaction block<br>
> 2012-07-01 00:00:27 LOG: pid 24086: Parse: Error or notice message from<br>
> backend: : DB node id: 0 backend pid: 24972 statement: select airline ,<br>
> flightnum from flight_plan where true order by airline, flightnum message:<br>
> current transaction is aborted, commands ignored until end of transaction<br>
> block<br>
><br>
><br>
> Here is Log of Postgresql :<br>
><br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=29898 command=BEGIN 4feef1fc.74ca LOG: execute S_1: BEGIN<br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=29898 command=SELECT 4feef1fc.74ca LOG: execute <unnamed>: select<br>
> username from client_user,client_user_role where<br>
> client_user.username='payment1' and<br>
> client_user.password='5039b3c8ffbdb50a2102bc172ebbf755' and<br>
> (client_user_role.role_name='PAYMENT' or<br>
> client_user_role.role_name='SUPERUSER') and<br>
> client_user.role_id=client_user_role.role_id<br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24972 command=PARSE 4fee8f60.618c ERROR: current transaction is<br>
> aborted, commands ignored until end of transaction block<br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24972 command=PARSE 4fee8f60.618c STATEMENT: select airline , flightnum<br>
> from flight_plan where true order by airline, flightnum<br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24969 command=idle in transaction 4fee8f60.6189 LOG: statement: SELECT<br>
> count(*) FROM pg_catalog.pg_attrdef AS d, pg_catalog.pg_class AS c WHERE<br>
> d.adrelid = c.oid AND d.adsrc ~ 'nextval' AND c.oid =<br>
> pgpool_regclass('message_log')<br>
> 2012-07-01 00:00:27 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24969 command=INSERT 4fee8f60.6189 LOG: execute <unnamed>: insert into<br>
> message_log(session_id,message_type,thread_id,client_address,log_time,raw_message)<br>
> values ('7F478482136546E980B00C031AA79AC0','client message','Handler<br>
> 9','192.168.165.3','2012-07-01 00:00:27.000889','{"header":<br>
> "id":1,"address":"192.168.220.1","clientType":"MULTIPAY","messageType":"ECHO"},"body"<br>
> {"username":"payment1","password":"payment1"}}')<br>
> 2012-07-01 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=613 command=SELECT 4fef1fa0.265 LOG: execute <unnamed>: select username<br>
> from<br>
> client_user , client_user_role where client_user.username='payment1' and<br>
> client_user.password='5039b3c8ffbdb50a2102bc172ebbf755' and<br>
> client_user_role.role_name='PAYMENT' or<br>
> client_user_role.role_name='SUPERUSER') and<br>
> client_user.role_id=client_user_role.role_id<br>
> 2012-07-01 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24123 command=BEGIN 4fee7fe7.5e3b LOG: execute S_1: BEGIN 2012-07-01<br>
> 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now pid=24123<br>
> command=SELECT 4fee7fe7.5e3b LOG: execute <unnamed>: select airline ,<br>
> flightnum from flight_plan where true order by airline, flightnum<br>
> 2012-07-01 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=24121 command=SELECT 4fee7fe5.5e39 LOG: execute <unnamed>: select<br>
> count(*) as jumlah from client_username_log where client_id = 'MULTIPAY-1-'<br>
> 2012-07-01 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=656 command=PARSE 4fef1fc8.290 ERROR: current transaction is aborted,<br>
> commands ignored until end of transaction block<br>
> 2012-07-01 00:00:39 WIT user=postgres db=psc_sub_terminal_not_using_now<br>
> pid=656 command=PARSE 4fef1fc8.290 STATEMENT: update client_username_log<br>
> set client_username='payment1' where client_id<br>
><br>
> the sql command often get this ERROR: current transaction is aborted,<br>
> commands ignored until end of transaction block<br>
> this error happens to any query.<br>
> I have tried some things to repair the situation like :<br>
> set insert_lock on/off (pgpool)<br>
> set parallel_mode on/off (pgpool)<br>
> /set on_error_rollback on/off (pgsql)<br>
> /set on_error_stop on/off (pgsql)<br>
> setAutoCommit true/false (java application), etc.<br>
> but nothing seems to have an effect.<br>
> if the jdbc goes directly to postgresql, there is no problem.<br>
> and if the query goes directly to pgpool, there is no problem.<br>
> looks like the problem occurs between JDBC and Pgpool.<br>
> any idea to solve this ?<br>
> thanks for the answer.<br>
><br>
> --<br>
> Best Regards,<br>
><br>
> Soni Maula Harriz<br>
> Database Administrator<br>
> PT. Data Aksara Sangkuriang<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>
</div></div></div><br><br clear="all"><br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>