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)
Message-ID: <4A5AF7CA.1010904@sun.com>
Date: Mon, 13 Jul 2009 10:00:58 +0100
From: Alan Burlison <Alan.Burlison@sun.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090608)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Derby replication seems to be mostly useless
References: <4A522D68.50401@sun.com> <x68wj0523i.fsf@Sun.COM>
 <4A532B59.2010800@sun.com> <wjo8ab3girtn.fsf@sun.com>
 <4A535E2B.2080903@sun.com> <x1oxab3ggda7.fsf@sun.com>
 <4A54A71C.6050205@sun.com> <x1oxd48btem0.fsf@sun.com>
 <4A54C304.7010802@sun.com> <4A54D3C0.3070602@sun.com>
 <x1oxab3cfqva.fsf@sun.com>
In-Reply-To: <x1oxab3cfqva.fsf@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dag H. Wanvik wrote:

> I suspect that when you use the programmatic approach, the databases
> are not shut down cleanly. If the servers are started from the command
> line, I think the booted databases are shut down cleanly.
> 
> Cf these lines in NotworkServerControlImpl.java:
>         :
> 	// if the server is started from the command line, it should shutdown the
> 	// databases it has booted.
> 	private boolean shutdownDatabasesOnShutdown = false;
> 
> This means that when the server is started via the API, each database
> needs to be shut down individually to get a clean shutdown (with
> checkpoint).

Unfortunately I don't think that's workable in practice.  Because Derby 
auto-starts databases on connection, there is no way of stopping clients 
opening the database again whilst the copy and child start is happening. 
  There needs to be some way to ensure the database is locked and then 
to flush the log entries.  Would a SYSCS_UTIL.SYSCS_FREEZE_DATABASE 
followed by a SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE do the trick?

-- 
Alan Burlison
--