[pgpool-general: 8880] Re: Prepared statements over pgpool ?

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jul 10 08:55:53 JST 2023


>> Here are the logs (limited to id 29, to avoid cluttering, however all
>> the 29 logs are here)
> [snip]
> 
> Thanks. I will look into this.

I found an interesting log line:

Jul  5 12:19:38 bigjaja pgpool[29]: [89-3] #011PREPARE
mark_rels_by_way(int8) AS  SELECT id FROM "planet_osm_rels" WHERE
parts && ARRAY[$1]      AND parts[way_off+1:rel_off] && ARRAY[$1];
Jul  5 12:19:38 bigjaja pgpool[29]: [89-4] #011"

What's this? It looks like different from other log lines.  Is it
possible that pgpool did not recognize this as a query? If so,
prepared statement mark_rels_by_way was not recognized by pgpool and
it is reasonable that pgpool complains this:

Jul  5 12:19:38 bigjaja pgpool[29]: [95-2] 2023-07-05 12:19:38.966:
osm2pgsql pid 29: DETAIL:  cannot get parse message "mark_rels_by_way"

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp



More information about the pgpool-general mailing list