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

[Charly Koza]

I have no idea what that is, I thought it was added by pgpool :D

 From osm2pgsql source 
https://github.com/openstreetmap/osm2pgsql/blob/60e3e5c1b05b31c66e725c2737b3adc69d869ba5/src/middle-pgsql.cpp#L1423

Both mark_rels_by_node and mark_rels_by_way prepared statements are in 
the same string, so probably sent as a single query.

Le 10/07/2023 à 01:55, Tatsuo Ishii a écrit :
>>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general