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 after that showed in the logs I saw a kind mismatch over and over until I pulled node 1 out.
pgpool server: nast=# set statement_timeout TO 100; SET nast=# SELECT count(*) from instance group by id order by id ; ERROR: canceling statement due to statement timeout node 0: 2009-03-23 00:12:03 UTC 949 0ERROR: canceling statement due to statement timeout 2009-03-23 00:12:03 UTC 949 0STATEMENT: SELECT count(*) from instance group by id order by id ; node 1: 2009-03-23 00:12:03 UTC 9075 0ERROR: syntax error at or near "send" at character 1 2009-03-23 00:12:03 UTC 9075 0STATEMENT: send invalid query from pgpool to abort transaction Thank you, Marcelo PostgreSQL DBA Linux/Solaris System Administrator _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
