<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Thanks Tatsua for your immediate response. </span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">AddGeometryColumn adds geometry column to the table and also registers this column in geography_columns table of postgis(extension of postgresql). </div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york',
times, serif; background-color: transparent; font-style: normal;">Is there a way I can tell Pgpool that Select AddGeometryColumn is a writing function? </div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">The thing that I would also like to know why would restarting postgresql service on broken node(where it was not creating 'geom' and 'geom_low' columns) would make everything fine even Select AddGeometryColumn is now working fine, not sure when it will break again. The error does shows up frequently though.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style:
normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">Your reply will be again appreciated...</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"> </div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font
size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Tatsuo Ishii <ishii@postgresql.org><br> <b><span style="font-weight: bold;">To:</span></b> deval_chauhan@yahoo.com <br><b><span style="font-weight: bold;">Cc:</span></b> pgpool-general@pgpool.net <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, May 28, 2013 6:11 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 1792] Select AddGeometryColumn query failing
on one backend - urgent help needed<br> </font> </div> <div class="y_msg_container"><br>What does AddGeometryColumn do? My guess is it issues ALTER TABLE<br>inside. If so, what happens here would be:<br><br>1) SELECT AddGeometryColumn only gets executed on one of the<br> PostgreSQL servers, because you did not tell pgpool-II that it is a<br> writing function.<br><br>2) Subsequent INSERT gets executed on both of PostgreSQL servers<br> because pgpool-II realized it needs to be executed on both<br> PostgreSQL.<br><br>3) PostgreSQL A has newly added column by #1, while B does not. So<br> pgpool-II gets an error from PostgreSQL.<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>Japanese: <a href="http://www.sraoss.co.jp/" target="_blank">http://www.sraoss.co.jp</a><br><br>> Update - After I restarted
Postgresql service on broken node, things were fine. So not sure, if it is related to postgresql or pgpool ? But if I use postgresql directly for inserts there is never such problem.<br>> <br>> <br>> <br>> 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.<br>> <br>> Here is my set-up.<br>> <br>> Two postgresql boxes on separate boxes<br>> One Pgpool box pointing to above mentioned postgresql boxes.<br>> <br>> I am attaching my logs for your references--<br>> <br>> Here is the sequence of queries that gets fired :<br>> <br>> 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 ) ;<br>> <br>> <br>> SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom','3857','MULTIPOLYGON',2); <br>> <br>> SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom_low','3857','MULTIPOLYGON',2);<br>> <br>> <br>> 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));<br>> <br>> <br>> Any help will be greatly appreciated....<br>> <br>> Thank you in advance,<br>> <br>> <br>> pgpool.log file:<br>> <br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: 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 ) ;<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG:
pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: S<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: S<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: S<br>>
2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: S<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: S from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: parameter name: client_encoding value: UTF8<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: S from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: parameter name: client_encoding value: UTF8<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: S from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: parameter name: standard_conforming_strings value: on<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: S from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: parameter name: standard_conforming_strings value: on<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28
12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: N from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: N from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: N<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C
NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: N from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: N from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: N<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
read_kind_from_backend: kind: N from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: N from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend N NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: N<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from
backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 1 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG:
pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: unlisten *<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction
state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28
DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for
backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 1 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend
Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: select 1<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: T from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
read_kind_from_backend: kind: D from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: D<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG:
pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom','3857','MULTIPOLYGON',2);<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: function_call_walker: function name: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pattern_compare:
black_function_list (^nextval$) not matched: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pattern_compare: black_function_list (^setval$) not matched: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: T from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: D from 0 th
backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: D<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0
length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: unlisten *<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>>
2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>>
2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 1 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414:
pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: select 1<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: T from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid
2414: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: D from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: D<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28
DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: SELECT AddGeometryColumn('public','_1ebac66315f34b00a9fcfd0b19bfad69','geom_low','3857','MULTIPOLYGON',2);<br>> 2013-05-28
12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: function_call_walker: function name: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pattern_compare: black_function_list (^nextval$) not matched: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pattern_compare: black_function_list (^setval$) not matched: addgeometrycolumn<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: T from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from
0 th backend T NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: D from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: D<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read
kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: statement2: unlisten *<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28
12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28
12:52:28 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: C from 1 th backend<br>> 2013-05-28 12:52:28
DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 1 th backend<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28
12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: Query: COMMIT<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: len:b000000<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_read_message_length: slot: 1 length: 5<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ReadyForQuery: transaction state:T<br>> 2013-05-28 12:52:28 DEBUG:
pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:28 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: statement2: select 1<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:30
DEBUG: pid 2414: detect_error: kind: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: T from 0 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: D from 0 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: C<br>> 2013-05-28 12:52:30
DEBUG: pid 2414: pool_set_command_success: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: Z from 0 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessBackendResponse: kind from backend: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_read_message_length: slot: 0 length: 5<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ReadyForQuery: transaction state:I<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_query_in_progress: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessBackendResponse: Ready For Query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: ProcessFrontendResponse: kind from frontend Q(51)<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_doing_extended_query_message: done<br>> 2013-05-28
12:52:30 DEBUG: pid 2414: statement2: 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));<br>> 2013-05-28
12:52:30 DEBUG: pid 2414: pool_set_query_in_progress: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: Query: BEGIN<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command:
kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: len:a000000<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: pool_unset_writing_transaction: done<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: get_insert_command_table_name: extracted table name: "_1ebac66315f34b00a9fcfd0b19bfad69"<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: extended:0 query:SELECT count(*) FROM pg_catalog.pg_attrdef AS d, pg_catalog.pg_class AS c WHERE d.adrelid = c.oid AND d.adsrc ~ 'nextval' AND c.relname = '_1ebac66315f34b00a9fcfd0b19bfad69'<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: row description received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: num_fileds: 1<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30
DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: Command complete received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: Ready for query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: get_insert_command_table_name: extracted table name: "_1ebac66315f34b00a9fcfd0b19bfad69"<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: Query: LOCK TABLE "_1ebac66315f34b00a9fcfd0b19bfad69" IN SHARE ROW EXCLUSIVE MODE<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: len:f000000<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind:
Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: Query: LOCK TABLE "_1ebac66315f34b00a9fcfd0b19bfad69" IN SHARE ROW EXCLUSIVE MODE<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: len:f000000<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: kind: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_command: transaction state: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: extended:0 query:SELECT attname, d.adsrc, coalesce((d.adsrc LIKE '%now()%' OR d.adsrc LIKE '%''now''::text%') AND (a.atttypid = 'timestamp'::regtype::oid OR a.atttypid = 'timestamp with time zone'::regtype::oid OR a.atttypid = 'date'::regtype::oid
OR a.atttypid = 'time'::regtype::oid OR a.atttypid = 'time with time zone'::regtype::oid) , false) FROM pg_catalog.pg_class c, pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_attrdef d ON (a.attrelid = d.adrelid AND a.attnum = d.adnum) WHERE c.oid = a.attrelid AND a.attnum >= 1 AND a.attisdropped = 'f' AND c.relname = '_1ebac66315f34b00a9fcfd0b19bfad69' ORDER BY a.attnum<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: T<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: row description received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: num_fileds: 3<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414:
do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: D<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: data
row received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: Command complete received<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: kind: Z<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: do_query: Ready for query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname gid adsrc nextval('_1ebac66315f34b00a9fcfd0b19bfad69_gid_seq'::regclass) use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname sra adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname incorp adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname haz_code adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname haz_class adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname vh_rec adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname shape_leng adsrc NULL
use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname shape_area adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname geom adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: attrname geom_low adsrc NULL use_timestamp = 0<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 0 completing the query<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: detect_error: kind: C<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: wait_for_query_response: waiting for backend 1 completing the query<br>> 2013-05-28 12:52:30 LOG: pid 2414: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 14036 statement: insert into
_1ebac66315f34b00a9fcfd0b19bfad69 ( SRA,HAZ_CODE,HAZ_CLASS,Shape_Leng,Shape_Area,geom) values ( 'FRA',2,'High',3.63920547962e+003,1.47780526502e+005,<br>> ST_GeomFromWKB(st_multi(decode('AQMAAAABAAAAHwAAAKWSCbtw62jB4EhufEg7TkGVAj2cXOtowcWr/AFHO05BLlKxzVvraMFzC4X0RjtOQaEpMD9662jB1UPX3QM6TkEDlBzQoutowX55VodcOE5BxK3ftKLraME/tVvzazhOQVn3UPyh62jBff7ZcdQ4TkG27El5putowTKMIfLUOE5BPyhnWabraMHmf0oA5zhOQc0rYdaq62jBvTuOgOc4TkEreJ2WqutowRhv6pwLOU5B5YmZE6/raMEdjSodDDlOQVyd19Ou62jBcFiUOTA5TkEJy85ExetowfydmroyOU5BfaUWBcXraMGIoRPXVjlOQW0MF4LJ62jBEmw8V1c5TkFYPXp9yetowXzUgfRZOU5Bv6yoVsnraMHMCgL1bzlOQdrjsPqM62jBoRGC6G45TkHX8ixRjOtowR6SZpMCOk5BHNWuTYzraMFVkPrjAzpOQT++MEqM62jBRaGKNAU6TkE9afhsietowTS2m+IEOk5ByktnzYjraME2nJsqXzpOQX/JkVqL62jBOh+hc186TkGMLuHPiutowSA6Cq+TOk5BmxXnl23raME/sqL7kTpOQSpg4WRt62jBho7wdNI6TkGBi+n6bOtowROfMokSO05B7ldWGnHraMFYnjqaEjtOQaWSCbtw62jB4EhufEg7TkEAAAAA','base64')),3857)); message: column "geom" of relation
"_1ebac66315f34b00a9fcfd0b19bfad69" does not exist<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: C from 0 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: kind: E from 1 th backend<br>> 2013-05-28 12:52:30 DEBUG: pid 2414: read_kind_from_backend: read kind from 1 th backend E NUM_BACKENDS: 2<br>> 2013-05-28 12:52:30 ERROR: pid 2414: read_kind_from_backend: 1 th kind E does not match with master or majority connection kind C<br>> 2013-05-28 12:52:30 ERROR: pid 2414: kind mismatch among backends. Possible last query was: "insert into _1ebac66315f34b00a9fcfd0b19bfad69 ( SRA,HAZ_CODE,HAZ_CLASS,Shape_Leng,Shape_Area,geom) values ( 'FRA',2,'High',3.63920547962e+003,1.47780526502e+005,<br>>
ST_GeomFromWKB(st_multi(decode('AQMAAAABAAAAHwAAAKWSCbtw62jB4EhufEg7TkGVAj2cXOtowcWr/AFHO05BLlKxzVvraMFzC4X0RjtOQaEpMD9662jB1UPX3QM6TkEDlBzQoutowX55VodcOE5BxK3ftKLraME/tVvzazhOQVn3UPyh62jBff7ZcdQ4TkG27El5putowTKMIfLUOE5BPyhnWabraMHmf0oA5zhOQc0rYdaq62jBvTuOgOc4TkEreJ2WqutowRhv6pwLOU5B5YmZE6/raMEdjSodDDlOQVyd19Ou62jBcFiUOTA5TkEJy85ExetowfydmroyOU5BfaUWBcXraMGIoRPXVjlOQW0MF4LJ62jBEmw8V1c5TkFYPXp9yetowXzUgfRZOU5Bv6yoVsnraMHMCgL1bzlOQdrjsPqM62jBoRGC6G45TkHX8ixRjOtowR6SZpMCOk5BHNWuTYzraMFVkPrjAzpOQT++MEqM62jBRaGKNAU6TkE9afhsietowTS2m+IEOk5ByktnzYjraME2nJsqXzpOQX/JkVqL62jBOh+hc186TkGMLuHPiutowSA6Cq+TOk5BmxXnl23raME/sqL7kTpOQSpg4WRt62jBho7wdNI6TkGBi+n6bOtowROfMokSO05B7ldWGnHraMFYnjqaEjtOQaWSCbtw62jB4EhufEg7TkEAAAAA','base64')),3857));" kind details are: 0[C] 1[E: column "geom" of relation "_1ebac66315f34b00a9fcfd0b19bfad69" does not exist]<br>> 2013-05-28 12:52:30 LOG: pid 2414: do_child: exits with status 1 due to error<br>> 2013-05-28 12:52:30
DEBUG: pid 2398: reap_handler called<br>> 2013-05-28 12:52:30 DEBUG: pid 2398: reap_handler: call wait3<br>> 2013-05-28 12:52:30 DEBUG: pid 2398: child 2414 exits with status 256<br>> 2013-05-28 12:52:30 DEBUG: pid 2398: fork a new child pid 25761<br>> 2013-05-28 12:52:30 DEBUG: pid 2398: reap_handler: normally exited<br>> 2013-05-28 12:52:30 DEBUG: pid 25761: I am 25761<br>> 2013-05-28 12:52:30 DEBUG: pid 25761: pool_initialize_private_backend_status: initialize backend status<br>> 2013-05-28 12:52:30 DEBUG: pid 9649: I am 9649 accept fd 6<br>> 2013-05-28 12:52:30 DEBUG: pid 9649: Protocol Major: 3 Minor: 0 database: postgis_central user: postgres<br>> 2013-05-28 12:52:30 DEBUG: pid 9649: do_child: connection exists but startup packet length is not identical<br>> 2013-05-28 12:52:30 DEBUG: pid 9649: new_connection: connecting 0 backend<br><br></div> </div> </div> </div></body></html>