No subject
Sat Nov 16 19:48:32 JST 2013
some error on both second level pgpool servers. If I query any second level
pgpool server directly there are no errors.
Is there any specific reason for this failure or how do I go about finding
out what causes this error?
--001a11c30600a741da04f02889c5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div><div>I have a simple set up where first level pgpool =
server receives queries from clients, forwards to second level pgpool serve=
rs, which in turn forwards to Postgres servers.<br><br></div>1* [pgpool] =
=3D> 1* [pgpool] =3D> 2* [Postgre]<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 1* [pgpool] =3D> 2* [Postgre]=
<br><br></div><div>If I make a simple "insert into account (1, 1, 0.0,=
"FRESH ACCOUNT");" query to the first level pgpool server, =
then I get this error in the second level Pg-Pool servers:<br>
<br>2014-01-17 12:35:25 LOG:=A0=A0 pid 3252: SimpleQuery: Unable to parse t=
he query: "insert into account (1, 1, 0.0, "FRESH ACCOUNT");=
" from client 10.1.12.30(50410)<br>2014-01-17 12:35:25 LOG:=A0=A0 pid =
3252: pool_send_and_wait: Error or notice message from backend: : DB node i=
d: 0 backend pid: 9301 statement: insert into account (1, 1, 0.0, "FRE=
SH ACCOUNT"); message: syntax error at or near "1"<br>
2014-01-17 12:35:25 LOG:=A0=A0 pid 3252: pool_send_and_wait: Error or notic=
e message from backend: : DB node id: 1 backend pid: 9161 statement: insert=
into account (1, 1, 0.0, "FRESH ACCOUNT"); message: syntax error=
at or near "1"<br>
2014-01-17 12:35:32 ERROR: pid 2644: Child process 3252 was terminated by s=
egmentation fault<br><br>From the order of the messages it seems to me the =
SimpleQuery runs into some error on both second level pgpool servers. If I =
query any second level pgpool server directly there are no errors.<br>
<br></div><div>Is there any specific reason for this failure or how do I go=
about finding out what causes this error?<br></div></div>
--001a11c30600a741da04f02889c5--
More information about the pgpool-general
mailing list