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&gt; 1* [pgpool] =3D&gt; 2* [Postgre]<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 1* [pgpool] =3D&gt; 2* [Postgre]=
<br><br></div><div>If I make a simple &quot;insert into account (1, 1, 0.0,=
 &quot;FRESH ACCOUNT&quot;);&quot; 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: &quot;insert into account (1, 1, 0.0, &quot;FRESH ACCOUNT&quot;);=
&quot; 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, &quot;FRE=
SH ACCOUNT&quot;); message: syntax error at or near &quot;1&quot;<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, &quot;FRESH ACCOUNT&quot;); message: syntax error=
 at or near &quot;1&quot;<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