[Bucardo-general] VAC Warning! VAC was killed at line 6507: DBD::Pg::st pg_result failed: ERROR: relation "bucardo.delta_17032" does not exist

[Frank NJ.]

Because of this bucardo has stopped for several hours, no restart without
manual intervention:

$ tail -f /var/log/bucardo/log.bucardo
PL/pgSQL function "bucardo_purge_delta" line 12 at SQL statement at
/usr/local/share/perl5/Bucardo.pm line 6507.
(3377) [Fri Nov  9 09:50:51 2012] MCP Warning: Killed (line 5038):
DBD::Pg::st execute failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request. at
/usr/local/share/perl5/Bucardo.pm line 5038.
DBD::Pg::db rollback failed: no connection to the server at
/usr/local/share/perl5/Bucardo.pm line 2175.
(3654) [Fri Nov  9 09:50:52 2012] CTL Controller for "londonhouse" was
killed at line 1250: MCP request
(3377) [Fri Nov  9 09:50:52 2012] MCP Process 25858 did not respond to a
kill 0
(3377) [Fri Nov  9 09:50:52 2012] MCP PID from
bucardo.kid.sync.londonhouse.pid is gone, removing file
(3377) [Fri Nov  9 09:50:52 2012] MCP End of cleanup_mcp. Sys time: Fri Nov
 9 09:50:52 2012. Database time: 2012-11-09 09:50:52.866363+01
(3654) [Fri Nov  9 09:50:53 2012] CTL Controller 3654 exiting at
cleanup_controller. Reason: MCP request



On 8 November 2012 16:35, Frank NJ. <njiaga at gmail.com> wrote:

> SQL statement "SELECT bucardo.bucardo_purge_delta( $1 ,  $2 )"
> PL/pgSQL function "bucardo_purge_delta" line 12 at SQL statement at
> /usr/local/share/perl5/Bucardo.pm line 6507.
> (3377) [Thu Nov  8 17:27:11 2012] MCP Created VAC 3745
> (3745) [Thu Nov  8 17:27:11 2012] VAC New VAC daemon. PID=3745
> (3745) [Thu Nov  8 17:27:11 2012] VAC Connected to database "shop_db_cm"
> with backend PID of 3747
> (3745) [Thu Nov  8 17:27:14 2012] VAC Connected to database "shop_db_uk"
> with backend PID of 23742
> NOTICE:  Rows deleted from "delta_sales_SalesPerson": 0 Rows deleted from
> "track_sales_SalesPerson": 0
> NOTICE:  Rows deleted from "delta_person_BusinessEntity": 0 Rows deleted
> from "track_person_BusinessEntity": 0
> (3745) [Thu Nov  8 17:27:17 2012] VAC Warning! VAC was killed at line
> 6507: DBD::Pg::st pg_result failed: ERROR:  relation "bucardo.delta_17032"
> does not exist
> LINE 1: DELETE FROM bucardo."delta_17032" USING (SELECT txntime AS t...
>                     ^
> QUERY:  DELETE FROM bucardo."delta_17032" USING (SELECT txntime AS tt FROM
> bucardo."track_17032" GROUP BY 1 HAVING COUNT(*) = 1) AS foo WHERE txntime
> = tt AND txntime < now() - interval '45 seconds'
> CONTEXT:  PL/pgSQL function "bucardo_purge_delta" line 44 at EXECUTE
> statement
> SQL statement "SELECT bucardo.bucardo_purge_delta( $1 ,  $2 )"
> PL/pgSQL function "bucardo_purge_delta" line 12 at SQL statement at
> /usr/local/share/perl5/Bucardo.pm line 6507.
> (3377) [Thu Nov  8 17:28:11 2012] MCP Created VAC 3767
> (3767) [Thu Nov  8 17:28:11 2012] VAC New VAC daemon. PID=3767
> (3767) [Thu Nov  8 17:28:11 2012] VAC Connected to database "shop_db_cm"
> with backend PID of 3769
> (3767) [Thu Nov  8 17:28:16 2012] VAC Connected to database "shop_db_uk"
> with backend PID of 26100
> NOTICE:  Rows deleted from "delta_sales_SalesPerson": 0 Rows deleted from
> "track_sales_SalesPerson": 0
> NOTICE:  Rows deleted from "delta_person_BusinessEntity": 0 Rows deleted
> from "track_person_BusinessEntity": 0
> (3767) [Thu Nov  8 17:28:17 2012] *VAC Warning! VAC was killed at line
> 6507: DBD::Pg::st pg_result failed: ERROR:  relation "bucardo.delta_17032"
> does not exist*
> LINE 1: DELETE FROM bucardo."delta_17032" USING (SELECT txntime AS t...
>                     ^
> QUERY:  DELETE FROM bucardo."delta_17032" USING (SELECT txntime AS tt FROM
> bucardo."track_17032" GROUP BY 1 HAVING COUNT(*) = 1) AS foo WHERE txntime
> = tt AND txntime < now() - interval '45 seconds'
> CONTEXT:  PL/pgSQL function "bucardo_purge_delta" line 44 at EXECUTE
> statement
> SQL statement "SELECT bucardo.bucardo_purge_delta( $1 ,  $2 )"
> PL/pgSQL function "bucardo_purge_delta" line 12 at SQL statement at
> /usr/local/share/perl5/Bucardo.pm line 6507.
> (3377) [Thu Nov  8 17:29:11 2012] MCP Created VAC 3789
> (3789) [Thu Nov  8 17:29:11 2012] VAC New VAC daemon. PID=3789
> (3789) [Thu Nov  8 17:29:11 2012] VAC Connected to database "shop_db_cm"
> with backend PID of 3791
> (3789) [Thu Nov  8 17:29:15 2012] VAC Connected to database "shop_db_uk"
> with backend PID of 28502
> NOTICE:  Rows deleted from "delta_sales_SalesPerson": 0 Rows deleted from
> "track_sales_SalesPerson": 0
> NOTICE:  Rows deleted from "delta_person_BusinessEntity": 0 Rows deleted
> from "track_person_BusinessEntity": 0
> (3789) [Thu Nov  8 17:29:33 2012] VAC Warning! VAC was killed at line
> 6507: DBD::Pg::st pg_result failed: ERROR:  relation "bucardo.delta_17032"
> does not exist
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121109/93b6d137/attachment-0001.html>