Do you use *all* the same connection parameters as in the bucardorc file when
doing your test? If not, do so as 9/10 it tells you the answer.
Michelle Sullivan
http://www.mhix.org/
You’re very neat about the feet.
> On 1 Apr 2022, at 09:55, Ryan J Conrad via Bucardo-general
>
are building) etc...
Regards,
Michelle Sullivan
http://www.mhix.org/
You’re very neat about the feet.
> On 22 Jan 2022, at 10:13, Wayne Taylor wrote:
>
> Hi Everyone,
>
> I am new to the community and love the tooling and had some questions
> regarding some issues we've
work even after adding the
required table.
Michelle Sullivan
http://www.mhix.org/
Truth is the beginning of the Path.
> On 12 Nov 2021, at 05:50, Victor Nunes wrote:
>
> Hey guys ! I'm trying to use bucardo and I'd like to communicate you guys
> about something.
>
> After runni
As part of the process of replication 5he triggers are disabled.. otherwise
you’d have a replication loop as the replication is trigger based.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 9 Sep 2021, at 19:25, ManuParra wrote:
>
> Hi, I hav
Try not using batch and adding the DB host when prompted. Ensure you don’t
have the name for the DB host in the /etc/hosts file pointing elsewhere.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 27 Aug 2021, at 09:32, Computerisms Corporation
>
for the root user.. if
you used the defaults you may still need to depending on the version and who
you were when you used the bucardo setup utility.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 18 Aug 2021, at 11:40, Computerisms Corporation
> wrote:
>
Just so you know I have to reset the column in the sync table as well... been
doing it for years, it’s not a problem to do it as far as I can see.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 22 Jul 2021, at 02:03, Videanu Adrian wrote:
>
&g
wrote the
software :)
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 13 Apr 2021, at 09:40, Joshua Tolley wrote:
>
>> On Tue, Apr 13, 2021 at 08:30:29AM +1000, Michelle Sullivan wrote:
>> The hard way is fix the software... don’t
generation unless you can ensure they are globally unique... easy if you wrote
the software yourself, not so easy if it’s someone else’s.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 13 Apr 2021, at 05:48, Rodrigo Rodovalho
> wrote:
>
> Hi,
If anything I’m a bucardo hacker rather than developer... I also use it a fair
bit in a major project so I’ll add my own $0.02... (in-line)
> On 22 Oct 2020, at 16:04, Jon Jensen wrote:
>
> Bucardo developers,
>
> I have been working on adding large object support for Bucardo, and along the
Have you tried turning on log queries on the postgresql servers (all of them)
and looking for the error queries in the logs?
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
> On 09 Oct 2020, at 03:06, mistercopter wrote:
>
> Good day.
>
> I have a problem:
>
&g
shutdown bucardo
whilst the move happens unless you have other DBs that are also replicated (I
did so didn’t shut it down) because it will keep shutting down and restarting
if it’s a master.
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
> On 31 Jul 2020, at 07:16, David Christen
ation via my
nagios plugin and saw the various datasets were staying 'lagged'...
root@boomerang:~ # bucardo --version
bucardo version 5.4.1
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-gener
how to
fix it, but it would likely be the wrong thing to do as I have no idea about
your data or use. When is your DBA returning? Did your DBA turn off bucardo?
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
> On 06 Apr 2019, at 00:48, Shubham Jhandei wrote:
>
> I have a
be running into cross db
deadlocks which the deadlock resolver won’t usually get.
Lastly you might want todo like me... split into multiple syncs. Check your
referral integrity to see if you can split the db into smaller syncs.. they’ll
be faster in general.
Michelle Sullivan
http://www.mhix.org
Needs todo it on the delta and track tables as I have seen table bloat slow the
delta join slow to ridiculously long queries... the full will remove the bloat
that a normal vacuum won’t.
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
> On 05 Nov 2018, at 02:29, David Christen
Check the delta table size...
psql -U
Db=# SET SCHEMA bucardo;
Db=# SELECT COUNT(1) FROM bucardo.bucardo__delta;
... repeat for all in the sync, see how many changes there are...
If a low number try VACUUM VERBOSE FULL ANALYZE
bucardo.bucardo__delta; for each table.
Michelle Sullivan
http
= bucardo.stop
syslog_facility = log_local1
tcp_keepalives_count = 0
tcp_keepalives_idle = 0
tcp_keepalives_interval = 0
vac_run = 120
vac_sleep = 180
warning_file = /sorbs/bucardo/warning.log
Thoughts?
p (cascade) the bucardo schema and reinstall... That would
be the quickest and simplest - otherwise if this is a working env with
this one problem you'll need to manually go through the bucardo tables
and remove the errant references (psql -U bucardo bucardo to see them)
Regards,
Michelle
--
Michell
concurrent
inserts into both DBs you probably should go with the offset sequences
or do as I did add a 'server ID' to the pks and not worry about
replicating the sequences.
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general
violation is very very very rarely the
correct way to go (so rare that I can't think of a valid reason.)
Regards,
--
Michelle Sullivan
http://www.mhix.org/
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
pg_putcopyend failed: ERROR: duplicate key value violates unique
constraint mo_uniq_path_index
The obvious question would be, 'why?' if you have these violations then
your table is most obviously out of sync.
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org
me, bucardo ignoring uniq index violation is very very very rarely the
correct way to go (so rare that I can't think of a valid reason.)
Regards,
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
an increment of 10 and have every server a base number which
is uniq in 0-9 ... giving upto 10 servers.
Regards,
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman
://www.postgresql.org/docs/9.1/static/sql-altersequence.html
eg:
server1 ALTER SEQUENCE myseq INCREMENT BY 3 START WITH 1;
server2 ALTER SEQUENCE myseq INCREMENT BY 3 START WITH 2;
server3 ALTER SEQUENCE myseq INCREMENT BY 3 START WITH 3;
Then *DO NOT* replicate myseq in bucardo.
--
Michelle Sullivan
http
Seeing lots of these since upgrading to 5.1.1.. should I consider this a
problem?
Michelle
--
Michelle Sullivan
http://www.mhix.org/
---BeginMessage---
(28671) [Wed Aug 20 11:59:29 2014] KID (sorbsmm) Delta count for
sorbs_corkscrew.public.timestamps : 1
(24062) [Wed Aug 20 11:59:29 2014
the sync down completely.
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
I am continually seeing my Bucardo hanging up... when it does it looks
like this:
5487 ?S 0:00 Bucardo Kid. Sync rt4db
5488 ?Ss 0:01 postgres: bucardo bucardo [local] notify
interrupt
16485 ?Ss 0:00 postgres: pgsql bucardo [local] idle
19100 pts/0S+
.
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
I would be happy for it - though 'remove' with an optional switch of
'--purge' would be good...
Michelle
--
Michelle Sullivan
http://www.mhix.org
,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Michelle Sullivan wrote:
Most of the changes are due to row deletes.
The last thing I see which might be the biggest thing...
After waiting for one of the hosts to get the changes (thinking it was
the host lagging) I see another host getting the same changes - this
sequential delete
with it and it would be considerably more difficult to setup
(and is in my opinion not as good as Bucardo - even with this limitation.)
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https
it comes back
online... apparently it works quite well - I never got it working
correctly and wouldn't (personally) trust it...)
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https
Michelle Sullivan wrote:
After updating to the git version to do the make_delta test I get the
following:
michelle@corkscrew:~$ bucardo add sync sorbsqs relgroup=queues
dbs=sorbsmasters status=active conflict_strategy=bucardo_latest
autokick=true checktime=00:00:05 priority=1 track_rates
Greg Sabino Mullane wrote:
On Tue, Dec 03, 2013 at 02:09:44PM +0100, Michelle Sullivan wrote:
Could not find proxy_checkq inside the public schema on database
sorbs_gauntlet! at line 30. at /usr/bin/bucardo line 3878.
Re-upgraded to the git repo after creating the missing tables
Greg Sabino Mullane wrote:
On Sun, Dec 01, 2013 at 05:23:55AM +0100, Michelle Sullivan wrote:
I''ll test it shortly... however just a point.. shouldn't it be:
Sync ABCD A = B = C = D (e.g. A:source,B:source,C:source,D:source)
Sync AE A - E (e.g. A:source,E:target)
Sorry, typo
Greg Sabino Mullane wrote:
On Tue, Nov 19, 2013 at 09:26:17AM +0100, Michelle Sullivan wrote:
...
sorbsmm (the multimaster) with master-at1:source, master-at2:source,
master-sc1:source, master-sc2:source
sorbsdns (the slaves) with master-at2:source, slave-se:target,
slave-de:target
only)
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
missed in how
to configure bucardo.)
Thanks,
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
^ at line 993. at
/usr/bin/bucardo line 1054.
Looks like this is caused by having a sync that is only sequences
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general
Greg Sabino Mullane wrote:
On Tue, Oct 15, 2013 at 11:40:52PM +0200, Michelle Sullivan wrote:
...
(15164) [Mon Oct 14 11:46:18 2013] MCP Table public.networks is
referenced by public.dns, which is not part of this sync!
Is that what is stopping it?
No - that's informational only
16 08:52:21 2013] KID (sessions) Totals: deletes=6
inserts=6 conflicts=0
(18951) [Wed Oct 16 08:52:25 2013] KID (sessions) Delta count for
sessions_corkscrew.public.sessions : 2
Where 'sorbsmm' and 'sessions' are the sync names.
Michelle
--
Michelle Sullivan
http://www.mhix.org
2013] KID Expected one row from
end_syncrun, but got 4
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
new kid 1284 for sync
sorbsmm
Clue on the cause?
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
What causes the:
Error was DBD::Pg::db pg_result failed: No asynchronous query is running
at /usr/lib/perl5/site_perl/5.8.8/Bucardo.pm line 8589.
Is a good question...
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing
this would be very bad not to run...
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Further testing - this problem does not occur if the second table with
the same name is added through 'bucardo add all tables'
Michelle
Michelle Sullivan wrote:
Consider the following setup script...
bucardo add database sorbs_corkscrew dbhost=corkscrew.sorbs.net
dbuser= dbpass
suggest I
bow out and leave this to Greg as he is without doubt the expert ;-)
Regards,
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
/bucardo-general
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
an associated problem.
Michelle
-- Alex
On 09/02/2013 04:53 AM, Michelle Sullivan wrote:
Alex Balashov wrote:
That's really odd. Are Perl strings not 8-bit clean by default? I
wouldn't have thought...
I would suggest this is more likely to be an issue with PostgreSQL
rather than perl (though I am
Christian Ritter wrote:
On 2013-09-02 11:49, Michelle Sullivan wrote:
Christian Ritter wrote:
I have switched the query log on, and it looks like bucardo has
problems with reading the data from the source database.
my insert into database testa:
2013-09-02 11:08:28 CEST LOG: statement
);
On the target (should be no rows)?
Then what do you get when you do:
SELECT id::text AS id FROM public.testtable WHERE (id) IN (1);
on the source?
Also what OS and PostgreSQL version are you using?
Michelle
--
Michelle Sullivan
http://www.mhix.org
...
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
On 27 Aug 2013, at 23:03, Markova, Nina nina.mark...@nrcan-rncan.gc.ca
wrote:
Thanks. I’ll try it.
Nina
From: Michelle Sullivan [mailto:miche...@sorbs.net]
Sent: August-27-13 16:22
To: Markova, Nina
Cc: bucardo-general
Markova, Nina wrote:
Thanks. I’ll try it.
Nina
*From:* Michelle Sullivan [mailto:miche...@sorbs.net]
*Sent:* August-27-13 16:22
*To:* Markova, Nina
*Cc:* bucardo-general@bucardo.org; Markova, Nina
*Subject:* Re: [Bucardo-general] how to dump all base tables and not
bucardo
whenever there are updates to the tables, if you then wait without any
table changes for the 10 minutes, the status will be updated to 'No
records found')
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo
]
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general
hub
Solutions? Multiple bucardo processes for different syncs? (wouldn't
this require separate bucardo configs for each of the sync processes?)
Thanks in advance..
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo
/site_perl/5.10.1/Bucardo.pm line 3266.
Thanks
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Greg Sabino Mullane wrote:
On Tue, Apr 30, 2013 at 07:49:11PM +0200, Michelle Sullivan wrote:
...
I'm having trouble here... without bucardo (4.x) I get a 10x speed
improvement...
Please suggestions on queries and expectations...
With the triggers enabled, during the 10s delay
Michelle Sullivan wrote:
Greg Sabino Mullane wrote:
On Tue, Apr 30, 2013 at 07:49:11PM +0200, Michelle Sullivan wrote:
...
I'm having trouble here... without bucardo (4.x) I get a 10x speed
improvement...
Please suggestions on queries and expectations
...
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
for any leaf/delta
target nodes automatically to prevent someone writing to a slave in a tree.
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo
of an issue that way for me, however I do have a cluster of 4
masters (2 east coast, 2 west cost) that should a master fail it should
be placed in read-only on startup whilst the DB is synced with
outstanding changes. Greg, would this be possible to look at?
Regards,
--
Michelle Sullivan
http
FYI this is the same problem I have (I did report it earlier - but
hadn't looked really closely at the PG tables to know it was disabled in
the DB)
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
___
Bucardo-general mailing list
Bucardo
64 matches
Mail list logo