Rafal,<div><br></div><div>I'm using PostgreSQL 8.4.12, and am able to send the command directly to the backend server without problem.</div><div><br></div><div>-Nick</div><div><br></div><div><br><div class="gmail_quote">
On Mon, Aug 20, 2012 at 9:45 AM, Kuczynski, Rafal (LNG-POL) <span dir="ltr"><<a href="mailto:Rafal.Kuczynski@lexisnexis.pl" target="_blank">Rafal.Kuczynski@lexisnexis.pl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<u></u>
<u></u>
<div lang="PL" link="blue" vlink="blue">
<div>
<div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;line-height:120%;font-family:Arial;color:navy">What is your version of postgresql? <u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;line-height:120%;font-family:Arial;color:navy">Did you try to send the statement directly
to postgresql backend? This could tell us that the problem is with pgpool or
just the statement.<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><span><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%"><u></u> <u></u></span></font></span></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><span><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%">Regards,<u></u><u></u></span></font></span></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><span><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%">Rafal</span></font></span><font color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;line-height:120%;font-family:Arial;color:navy"><u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="2" width="100%" align="center">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> Nick Maludy
[mailto:<a href="mailto:nmaludy@gmail.com" target="_blank">nmaludy@gmail.com</a>] <br>
<b><span style="font-weight:bold">Sent:</span></b> Monday, August 20, 2012 2:57
PM<br>
<b><span style="font-weight:bold">To:</span></b> Kuczynski, Rafal (LNG-POL)<br>
<b><span style="font-weight:bold">Cc:</span></b> <u></u><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><u></u><br>
<b><span style="font-weight:bold">Subject:</span></b> Re: [pgpool-general: 906]
Re: Problem executing COPY WITH CSV in load balancing mode</span></font><u></u><u></u></p>
</div><div><div class="h5">
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Rafal,<u></u><u></u></span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I tried using the same table but changing my data input to:<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">0,0,"Boston"<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">1,1,"Detroit"<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I still received an error from psql "connection to server was
lost" and the following appeared in pgpool.log:<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 LOG: pid 23536: DB node id: 1 backend pid:
2233 statement: BEGIN<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: do_command: Query: BEGIN<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: wait_for_query_response: waiting
for backend 1 completing the query<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: detect_error: kind: C<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: do_command: kind: C<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: do_command: kind: Z<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: do_command: transaction state: T<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: pool_unset_writing_transaction:
done<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 LOG: pid 23536: DB node id: 0 backend pid:
2861 statement: COPY base_time_table FROM STDIN WITH CSV;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: wait_for_query_response: waiting
for backend 0 completing the query<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 LOG: pid 23536: DB node id: 1 backend pid:
2233 statement: COPY base_time_table FROM STDIN WITH CSV;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: wait_for_query_response: waiting
for backend 1 completing the query<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: read_kind_from_backend: kind: G
from 0 th backend<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: read_kind_from_backend: read kind
from 0 th backend G NUM_BACKENDS: 2<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: read_kind_from_backend: kind: G
from 1 th backend<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: read_kind_from_backend: read kind
from 1 th backend G NUM_BACKENDS: 2<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:46 DEBUG: pid 23536: ProcessBackendResponse: kind from
backend: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:54 DEBUG: pid 23536: parse_copy_data: divide key value
is 1,1,"Boston"<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:54 ERROR: pid 23536: PQexecPrepared failed: ERROR:
invalid input syntax for integer: "1,1,"Boston""<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:54 DEBUG: pid 23536: CopyDataRow: copying id: -1<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-20 08:48:54 ERROR: pid 23536: pool_is_node_to_be_sent: invalid
node id:-1<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">If i login to the pgpool database and delete my entry from
pgpool_catalog.dist_def for my base_time_table then restart pgpool i can use
the same command "COPY base_time_table FROM STDIN WITH CSV" and the
same data 0,0,"Boston" things work just fine.<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">-Nick<u></u><u></u></span></font></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">On Mon, Aug 20, 2012 at 5:27 AM, Kuczynski, Rafal (LNG-POL) <<a href="mailto:Rafal.Kuczynski@lexisnexis.pl" target="_blank">Rafal.Kuczynski@lexisnexis.pl</a>>
wrote:<u></u><u></u></span></font></p>
<div link="blue" vlink="purple">
<div>
<div>
<div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" color="navy" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%;color:navy">String values must be quoted, afaik the default quote for csv
mode is double-quote (“”). It means that your input values must be
like</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%">0,0,”<u></u><u></u>Boston<u></u><u></u>”</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%"> </span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%">You can also specify your
own quote character (with csv quote as ‘yourquote’)</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" color="navy" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%;color:navy"> </span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" color="navy" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%;color:navy">Regards,</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" color="navy" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt;line-height:120%;color:navy">Rafal</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;line-height:120%;color:navy"> </span></font><u></u><u></u></p>
</div>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="2" width="100%" align="center">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a>]
<b><span style="font-weight:bold">On Behalf Of </span></b>Nick Maludy<br>
<b><span style="font-weight:bold">Sent:</span></b> Friday, August 17, 2012
10:16 PM<br>
<b><span style="font-weight:bold">To:</span></b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b><span style="font-weight:bold">Subject:</span></b> [pgpool-general: 900]
Problem executing COPY WITH CSV in load balancing mode</span></font><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Hello,<u></u><u></u></span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I'm current
running pgpool-II version 3.2.0 (namameboshi). I'm currently running in
load_balance_mode=on, parallel_mode=on, replicaton_mode=off. The following
command fails when i execute it:<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">COPY
base_time_table FROM STDIN WITH CSV<u></u><u></u></span></font></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br>
<b><span style="font-weight:bold">The data i'm trying to pass in on STDIN is
formatted like:</span></b><u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">0,0,Boston<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">1,1,Detroit<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">etc...<u></u><u></u></span></font></p>
</div>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">The
error i am getting in /tmp/pgpool.log is:</span></font></b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 LOG: pid 9333: DB node id: 0 backend pid: 22780 statement: COPY
base_time_table FROM STDIN WITH CSV;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: wait_for_query_response: waiting for backend 0
completing the query<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: detect_error: kind: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 LOG: pid 9333: DB node id: 1 backend pid: 23689 statement: COPY
base_time_table FROM STDIN WITH CSV;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: wait_for_query_response: waiting for backend 1
completing the query<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: read_kind_from_backend: kind: G from 0 th backend<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: read_kind_from_backend: read kind from 0 th backend G
NUM_BACKENDS: 2<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: read_kind_from_backend: kind: G from 1 th backend<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: read_kind_from_backend: read kind from 1 th backend G
NUM_BACKENDS: 2<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:20 DEBUG: pid 9333: ProcessBackendResponse: kind from backend: G<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 9333: <b><span style="font-weight:bold">parse_copy_data:
divide key value is 0,0,Boston</span></b><u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 ERROR: pid 9333: <b><span style="font-weight:bold">PQexecPrepared
failed: ERROR: invalid input syntax for integer: "0,0,Boston"</span></b><u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 9333: CopyDataRow: copying id: -1<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 ERROR: pid 9333: pool_is_node_to_be_sent: invalid node id:-1<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 8774: reap_handler called<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 8774: reap_handler: call wait3<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 8774: child 9333 exits with status 256<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 8774: fork a new child pid 9345<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">2012-08-17
16:08:44 DEBUG: pid 8774: reap_handler: normally exited<u></u><u></u></span></font></p>
</div>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">My
table has the following structure:</span></font></b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">test# \d
base_time_table;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> Table
"public.base_time_table"<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
Column | Type | Modifiers <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">-------------+--------+-----------<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> base_time
| bigint | <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> base_id
| bigint | <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> base_source
| text | <u></u><u></u></span></font></p>
</div>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">My
pgpool_catalog.dist_def entry is:</span></font></b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">pgpool=# select *
from pgpool_catalog.dist_def;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> dbname |
schema_name | table_name | col_name |
col_list |
type_lis<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">t
| dist_def_func <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">--------+-------------+-----------------+-----------+---------------------------------+--------------<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">--------+--------------------<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> rr
| public | base_time_table | base_time |
{base_time,base_id,base_source} | {bigint,bigin<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">t,text} |
dist_def_base_time<u></u><u></u></span></font></p>
</div>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">My
dist_def_base_time function is:</span></font></b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">CREATE OR REPLACE
FUNCTION dist_def_base_time(anyelement)<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">RETURNS integer AS
$$<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
SELECT CASE WHEN $1 > 5000 THEN 0<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
ELSE 0<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> END;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">$$ LANGUAGE sql;<u></u><u></u></span></font></p>
</div>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I noticed that if
i change the command to:<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">COPY
base_time_table FROM STDIN;<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">And use the
PostgreSQL Text Format for COPY things work just fine.<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Also, if i remove
my entry from pgpool_catalog.dist_def for base_time_table and restart pgpool
the COPY WITH CSV works fine also (except it sends the data to all nodes).<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Any help would be
greatly appreciated,<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Nick<u></u><u></u></span></font></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><u></u><u></u></span></font></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>