Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
From: Andrew Lawrenson <andrew.lawrenson@coppereye.com>
To: Derby Discussion <derby-user@db.apache.org>
Date: Wed, 22 Oct 2008 07:04:53 -0400
Subject: RE: replication - master log overflow
Thread-Topic: replication - master log overflow
Thread-Index: Ack0HsieJGfE98lkS/Ss0qGfWH3/bAAFtecg
Message-ID: 
 <882C3355DFF9D3468379DD1E8C115FC7148BACCB58@EVS-RED.coloflorida.com>
References: <48FA8EDA.6090901@lucentradius.com> <48FC2D6C.6080101@sun.com>
 <48FE5506.7060500@alcatel-lucent.com>
In-Reply-To: <48FE5506.7060500@alcatel-lucent.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

I would also welcome a programatic way to determine the status of the maste=
r and/or slave.

I'm currently planning (but haven't got there yet) to regularly try & conne=
ct to the slave, and make sure we get a failure with a sqlstate indicating =
it's won't accept connections due to being a slave - but this is about the =
only programatic check I've come up with so far.

Andrew Lawrenson

-----Original Message-----
From: Glenn McGregor [mailto:gm44@alcatel-lucent.com]
Sent: 21 October 2008 23:18
To: Derby Discussion
Subject: Re: replication - master log overflow

J=F8rgen L=F8land wrote:
> Glenn McGregor wrote:
>> How is one supposed to tell if a database in 'master'
>> mode has exceeded its log buffer limit after its become isolated from
>> the 'slave'?
>
> You'll have to look in the derby.log file on the master to learn this.
> You'll find something like this (from memory - the actual text may
> differ slightly):

Sorry, I was not specific enough in my question.  Is there a way to determi=
ne this condition programmatically?
I am attempting to automate the various steps of the sync-up and failover, =
and I need more information about what state a database is in, both on the =
master and slave servers.

Thanks

Glenn