[pgpool-general: 1791] Select AddGeometryColumn failing on one backend - urgent help needed

[Deval Chauhan]

I am really stuck with this issue, where Pgpool oftens errors out with "Connection is Broken" message with logs which states "geom" column does not exist on one Postgresql server. I did verified this that this holds true on one postgresql server that it did not have geom and geom_low columns.





Here is my set-up.
Two postgresql boxes on separate boxes
One Pgpool box pointing to above mentioned postgresql boxes.

I am attaching my logs for your references--

Here is the sequence of queries that gets fired :

SET CLIENT_ENCODING TO UTF8;SET STANDARD_CONFORMING_STRINGS TO ON;BEGIN; create table public._1ebac66315f34b00a9fcfd0b19bfad69 ( gid serial PRIMARY KEY, SRA  varchar(3),INCORP  varchar(1),HAZ_CODE  int,HAZ_CLASS  varchar(25),VH_REC  varchar(25),Shape_Leng  double precision,Shape_Area  double precision ) ;


SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom','3857','MULTIPOLYGON',2);  

SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom_low','3857','MULTIPOLYGON',2);


insert into _1ebac66315f34b00a9fcfd0b19bfad69  ( SRA,HAZ_CODE,HAZ_CLASS,Shape_Leng,Shape_Area,geom) values  ( 'FRA',2,'High',3.63920547962e+003,1.47780526502e+005, ST_GeomFromWKB(st_multi(decode('AQMAAAABAAAAHwAAAKWSCbtw62jB4EhufEg7TkGVAj2cXOtowcWr/AFHO05BLlKxzVvraMFzC4X0RjtOQaEpMD9662jB1UPX3QM6TkEDlBzQoutowX55VodcOE5BxK3ftKLraME/tVvzazhOQVn3UPyh62jBff7ZcdQ4TkG27El5putowTKMIfLUOE5BPyhnWabraMHmf0oA5zhOQc0rYdaq62jBvTuOgOc4TkEreJ2WqutowRhv6pwLOU5B5YmZE6/raMEdjSodDDlOQVyd19Ou62jBcFiUOTA5TkEJy85ExetowfydmroyOU5BfaUWBcXraMGIoRPXVjlOQW0MF4LJ62jBEmw8V1c5TkFYPXp9yetowXzUgfRZOU5Bv6yoVsnraMHMCgL1bzlOQdrjsPqM62jBoRGC6G45TkHX8ixRjOtowR6SZpMCOk5BHNWuTYzraMFVkPrjAzpOQT++MEqM62jBRaGKNAU6TkE9afhsietowTS2m+IEOk5ByktnzYjraME2nJsqXzpOQX/JkVqL62jBOh+hc186TkGMLuHPiutowSA6Cq+TOk5BmxXnl23raME/sqL7kTpOQSpg4WRt62jBho7wdNI6TkGBi+n6bOtowROfMokSO05B7ldWGnHraMFYnjqaEjtOQaWSCbtw62jB4EhufEg7TkEAAAAA','base64')),3857));


Any help will be greatly appreciated....

Thank you in advance,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130528/a5dcf709/attachment-0001.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool2.log
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130528/a5dcf709/attachment-0001.ksh>