[Bucardo-general] Failed on make test on Bucardo 3.1.0 and a question about timeofday() usage

yan farmawan 100.persen.linux at gmail.com
Wed Feb 11 02:29:20 UTC 2009

First of all, I would like to thanks Mr. Greg Salbino for creating and
releasing Bucardo,
as it is just what I need.

I'm testing bucardo git version 3.1.0. with postgresql 8.3.3 and perl 5.10.0

Unfortunately I failed on 'make test'. Mostly on these lines:
(note: xxxx is the name of all test script)

Subroutine main::like redefined at t/xxxx line 14
Subroutine main::pass redefined at t/xxxx line 14y
Subroutine main::isa_ok redefined at t/xxxx line 14
Subroutine main::ok redefined at t/xxx line 14
Subroutine main::is_deeply redefined at t/xxx line 14

Anyway I move on.. and have succeeded to sync with pushdelta on a table.
But ..... with some changes on Bucardo.pm, because I got these errors
with the original Bucardo.pm :

(3277) [1234274461] CTL Warning! Controller for "goodguy_syn" was
killed at line 2660: DBD::Pg::db do failed: ERROR:  invalid input
syntax for type timestamp: "Tue Feb 10 21:01:01.724052 2009 WIT" at
/opt/perl/lib/site_perl/5.10.0/Bucardo.pm line 2660.

At last, Bucardo managed to sync after all occurences of:
timeofday()::timestamp is changed to current_timestamp
timeofday()::timestamptz is changed to current_timestamp::timestamptz

Why using timeofday() ?  As per-postgresql doc, timeofday() returns
text. Why not use now(), or current_timestamp, or
statement_timestamp() since all these funcs already returns timestamp
or timestamptz ?

Note: I'm using lc_time = 'en_US.UTF-8'  ... if it is matter.

I would like to test latest bucardo with as similar as to your
environments (postgresql version, perl version, postgresql.conf) . How
could I do that ?

Best regards and thank you.

More information about the Bucardo-general mailing list