[Pgpool-general] syntax error at or near "send" at character 1
Marcelo Martins
pglists at zeroaccess.org
Mon Mar 23 00:15:56 UTC 2009
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
More information about the Pgpool-general
mailing list