[Bucardo-general] [Bucardo-announce] Bucardo version 5.4.0 released

[Paul Theodoropoulos]

I've just built and installed Bucardo 5.4.0, upgrading from 5.3.1. This 
is on Debian Squeeze 32 bit, perl 5.10.1, postgresql 9.1.

On attempting to start the new Bucardo it threw this error:

root at mia-tm-tru-main-primary-dev: ~ # bucardo start
DBD::Pg::st execute failed: ERROR:  relation "bucardo.clone" does not exist
LINE 4:       FROM bucardo.clone
                    ^ at /usr/local/bin/bucardo.pl line 9681.


So I tried running 'bucardo upgrade' and it threw this error:

root at mia-tm-tru-main-primary-dev: ~ # bucardo upgrade
 From line 8162, action CREATE TABLE bucardo.clone (
   id        INTEGER     NOT NULL DEFAULT nextval('clone_id_seq'),
               CONSTRAINT clone_id_pk PRIMARY KEY (id),
   sync      TEXT            NULL,
     CONSTRAINT clone_sync_fk FOREIGN KEY (sync) REFERENCES 
bucardo.sync(name) ON UPDATE CASCADE ON DELETE CASCADE,
   dbgroup   TEXT            NULL,
     CONSTRAINT clone_dbgroup_fk FOREIGN KEY (dbgroup) REFERENCES 
bucardo.dbgroup(name) ON UPDATE CASCADE ON DELETE CASCADE,
   relgroup  TEXT            NULL,
     CONSTRAINT clone_relgroup_fk FOREIGN KEY (relgroup) REFERENCES 
bucardo.herd(name) ON UPDATE CASCADE ON DELETE CASCADE,
   options   TEXT            NULL,
   status    TEXT            NULL,
   started   TIMESTAMPTZ     NULL,
   ended     TIMESTAMPTZ     NULL,
   summary   TEXT            NULL,
   cdate     TIMESTAMPTZ NOT NULL DEFAULT now()
);

DBD::Pg::db do failed: ERROR:  relation "clone_id_seq" does not exist at 
/usr/local/bin/bucardo.pl line 8530, <$fh> line 2821.

Did I overlook something in the install? I didn't see anything about 
this bucardo.clone table.


On 8/12/15 10:05 AM, Greg Sabino Mullane wrote:
> Version 5.4.0 of Bucardo has been released. This fixes a number
> of bugs and introduces a few minor behavior changes, but nothing
> too major.
>
> Download here:
>
> http://bucardo.org/wiki/Bucardo
>
> Checksums for this tarball:
>
> d29ab7f200c7ea568dfdc0ed3781087b  Bucardo-5.4.0.tar.gz
> d08e86d1b6624e0cb6bd210b9613217aac415a10  Bucardo-5.4.0.tar.gz
>
>  From the Changes file:
>
> Bucardo version 5.4.0, released August 6, 2015 (git commit a0eff9f6558cc2c6b19e4e675604250ad00ce420)
>
>    - Allow dashes in valid schema and table names
>      [David Christensen]
>
>    - New command "bucardo delta [syncname...]" to show number of pending
>      delta rows on source databases.
>      [Greg Sabino Mullane]
>
>    - Fix incorrect usage of the 'dbconn' parameter in the bucardo.db table
>      [Greg Sabino Mullane, reported by Alexandre Busquets]
>
>    - Fix case where VAC sometimes skipped databases used in multiple syncs.
>      [Greg Sabino Mullane, reported by Andrey Solovjov]
>
>    - Adjustments for new version of ExtUtils::MakeMaker
>      [Mathieu Arnold]
>
>    - When doing target deletes, use the quoted version of the primary key column names.
>      [Greg Sabino Mullane]
>
>    - Make sure we do not signal other syncs during makedelta runs if the other
>      syncs are inactive or have autokick off.
>      [Greg Sabino Mullane]
>
>    - Allow code with 'array_agg' to work on Postgres <= 8.2,
>      along with many other minor changes to support older versions.
>      [Greg Sabino Mullane]
>
>    - Add new internal function bucardo_purge_delta_oid which helps the
>      VAC process work better on older versions of Postgres (<= 8.2)
>      [Greg Sabino Mullane]
>
>    - Add new function bucardo_purge_sync_track which removes all track
>      and delta entries for a given sync. Use with care.
>      [Greg Sabino Mullane]
>
>    - Allow 'bucardo validate' to drop the autokick triggers if they are no longer needed.
>      [Greg Sabino Mullane]
>
>    - Add 'PRAGMA defer_foreign_keys' for sqlite targets
>      [Greg Sabino Mullane]
>
>    - Do not try to apply 'READ WRITE' when doing the initial SET TRANSACTION for MySQL and MariaDB,
>      as that option is not supported across all versions.
>      [Greg Sabino Mullane]
>
>    - Remove default value from sync.isolation_level, so we can default to
>      the global one when needed.
>      [Greg Sabino Mullane]
>
>    - Improve workings of the 'pkonly' argument to "bucardo add tables"
>      [Greg Sabino Mullane]
>
>    - Make 'bucardo list relgroup foo' show the tables in priority order.
>      [Greg Sabino Mullane]
>
>    - Make 'bucardo list all' a little less verbose for some not-so-common items
>      [Greg Sabino Mullane]
>
>    - Fix up the "add relgroup" call to allow it to work for capitalized relations,
>      and remove a prepare_cached error that could occur.
>      [Greg Sabino Mullane]
>
>    - Allow validate_sync to check the contents of functions for upgrade,
>      not just their existence.
>      [Greg Sabino Mullane]
>
>    - Do not 'RESET search_path' inside some of the internal functions.
>      [Greg Sabino Mullane]
>
>    - Sleep longer between stop and start when doing 'bucardo restart'
>      [Greg Sabino Mullane]
>
>
>
>
> _______________________________________________
> Bucardo-announce mailing list
> Bucardo-announce at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-announce

-- 
Paul Theodoropoulos
www.anastrophe.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150812/6f90aaf4/attachment.html>