[Pgpool-general] syntax error at or near "send" at character 1

[Łukasz Jagiełło]

2009/4/3 Tatsuo Ishii <ishii at sraoss.co.jp>:
> I couldn't reproduce the problem. Any hint to reproduce it?

Today got same problem, over hour was load at pgpool box around ~4-5
(normal got 0.2) and after that time got error at one node:

#v+
WARNING:  nonstandard use of \\ in a string literal at character 220
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
STATEMENT:  SELECT * FROM "Layout" ORDER BY id ASC LIMIT 1
ERROR:  prepared statement "pdo_pgsql_stmt_803e14a4" does not exist
STATEMENT:  DEALLOCATE pdo_pgsql_stmt_803e14a4
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
ERROR:  syntax error at or near "send" at character 1
STATEMENT:  send invalid query from pgpool to abort transaction
#v-

After node disconnect everything goes back to normal (beside node disconnect)

postgresql-server-8.3.7-1.fc10.x86_64
postgresql-pgpool-II-2.2.2-1.fc10.i386

-- 
Łukasz Jagiełło
System Administrator
G-Forces Web Management Polska sp. z o.o. (www.gforces.pl)

Ul. Kruczkowskiego 12, 80-288 Gdańsk
Spółka wpisana do KRS pod nr 246596 decyzją Sądu Rejonowego Gdańsk-Północ