From derby-user-return-12733-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon May 10 23:33:55 2010 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 50247 invoked from network); 10 May 2010 23:33:54 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 10 May 2010 23:33:54 -0000 Received: (qmail 82687 invoked by uid 500); 10 May 2010 23:33:53 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 82653 invoked by uid 500); 10 May 2010 23:33:53 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 82627 invoked by uid 99); 10 May 2010 23:33:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 May 2010 23:33:53 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=AWL,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com designates 209.85.221.181 as permitted sender) Received: from [209.85.221.181] (HELO mail-qy0-f181.google.com) (209.85.221.181) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 May 2010 23:33:48 +0000 Received: by qyk11 with SMTP id 11so6369644qyk.13 for ; Mon, 10 May 2010 16:33:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:content-type; bh=LwruOiVlgsoKr8dodD5JG70bK2SjGGafGDfkfzHJdlY=; b=wtHr36tFdPctm+AKlB2W8xGk2y9OOU1os/VHCfFhG4L4rCTXOxOIEETvrXjLcFOX+w ilS9kxPS+3f8LXCYIxaQbeU2mvhE5IOT3BeglnOLby/yTsNZsefff953CXIS4luEzgsS f3grtQM96Fppq09fQ16kY9WDkn5KbiwNh3IWM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type; b=iVvv28lPN6KOhd2km8S2qvRnk8Tq2WWSuU0sIpJcMRzSJNK0tmuwwowN6WAAKNUDID X+H5wu/sFK6KLZBROhZ0doz0sWtWsTLG9qC8yc7kLf78Q3tL/M20Taqm7C04mPw1axoX 5oH0iDbxOKzBI1VxvTjpL/pF3ORAztlJN2Bu8= Received: by 10.224.96.78 with SMTP id g14mr3229742qan.117.1273534407186; Mon, 10 May 2010 16:33:27 -0700 (PDT) MIME-Version: 1.0 Sender: david.vancouvering@gmail.com Received: by 10.229.231.138 with HTTP; Mon, 10 May 2010 16:33:07 -0700 (PDT) In-Reply-To: References: From: David Van Couvering Date: Mon, 10 May 2010 16:33:07 -0700 X-Google-Sender-Auth: dbpUw2InWco4EJG5D5c5x_mnenI Message-ID: Subject: Re: derby.log not truncating on reboot To: Derby Discussion Content-Type: multipart/alternative; boundary=00c09f89973ff31d11048645d55e --00c09f89973ff31d11048645d55e Content-Type: text/plain; charset=ISO-8859-1 That looks interesting, but this appears to only be for error messages. Do *all* derby.log messages get written to this stream, and when they are, are they not written to derby.log? If you don't know off-hand, that's fine, it's easy enough for me to test... Thanks! David On Mon, May 10, 2010 at 4:22 PM, Dag H. Wanvik wrote: > David Van Couvering writes: > > > I have a service that shuts down the Derby database after it is done > using > > it. This is because on Linux I was getting errors "too many open files" > > unless I did this - I use a lot of databases, and when all of them are > > booted it starts using up too many resources. > > > > But now my problem is that every time I shut down a DB, and every time I > > boot a DB, it adds a message to the derby.log file, and over time the log > > file grows and grows. Is there any way to silence these messages? > > I don't know any switch for it, but I perhaps you could leverage > derby.stream.error.method to filter away the output you don't want, by > building your own stream impl. > > http://db.apache.org/derby/docs/10.5/ref/rrefproper35028.html > > Dag > > > > > Here is an example: > > > > ---------------------------------------------------------------- > > 2010-05-10 20:35:55.703 GMT: > > Booting Derby version The Apache Software Foundation - Apache Derby - > > 10.5.3.0 - (802917): instance a816c00e-0128-83ee-5a69-00002248f366 > > on database directory > > C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_11 > > > > Database Class Loader started - derby.database.classpath='' > > > > 2010-05-10 20:35:56.172 GMT: > > Shutting down instance a816c00e-0128-83ee-5a69-00002248f366 > > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > > 2010-05-10 20:35:56.188 GMT: > > Booting Derby version The Apache Software Foundation - Apache Derby - > > 10.5.3.0 - (802917): instance 6839c016-0128-83ee-5a69-00002248f366 > > on database directory > > C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_12 > > > > Database Class Loader started - derby.database.classpath='' > > > > 2010-05-10 20:35:56.235 GMT: > > Shutting down instance 6839c016-0128-83ee-5a69-00002248f366 > > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > > 2010-05-10 20:35:56.235 GMT: > > Booting Derby version The Apache Software Foundation - Apache Derby - > > 10.5.3.0 - (802917): instance 286cc01e-0128-83ee-5a69-00002248f366 > > on database directory > > C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_11 > > > > Database Class Loader started - derby.database.classpath='' > > > > 2010-05-10 20:35:56.282 GMT: > > Shutting down instance 286cc01e-0128-83ee-5a69-00002248f366 > > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > > 2010-05-10 20:35:56.297 GMT: > > Booting Derby version The Apache Software Foundation - Apache Derby - > > 10.5.3.0 - (802917): instance e8afc026-0128-83ee-5a69-00002248f366 > > on database directory > > C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_12 > > > > Database Class Loader started - derby.database.classpath='' > > > > 2010-05-10 20:35:56.344 GMT: > > Shutting down instance e8afc026-0128-83ee-5a69-00002248f366 > > ---------------------------------------------------------------- > > > > -- > > David W. Van Couvering > > > > http://www.linkedin.com/in/davidvc > > http://davidvancouvering.blogspot.com > > http://twitter.com/dcouvering > > -- > Dag H. Wanvik, staff engineer > Sun Microsystems, Java Core and Desktop - Java DB/Derby > Haakon VII gt. 7b, N-7485 Trondheim, Norway > Tel: x43496/+47 73842196, Fax: +47 73842101 > Sun IM: dw136674, Yahoo IM: dag_h_wanvik > -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering --00c09f89973ff31d11048645d55e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable That looks interesting, but this appears to only be for error messages. =A0= Do *all* derby.log messages get written to this stream, and when they are, = are they not written to derby.log?

If you don't know= off-hand, that's fine, it's easy enough for me to test...

Thanks!

David

On Mon, May 10, 2010 at 4:22 PM, Dag H. Wanvik <Dag.Wanvik@sun.com&g= t; wrote:
David Van Couvering <<= a href=3D"mailto:david@vancouvering.com">david@vancouvering.com> wri= tes:

> I have a service that shuts down the Derby database after it is done u= sing
> it. =A0This is because on Linux I was getting errors "too many op= en files"
> unless I did this - I use a lot of databases, and when all of them are=
> booted it starts using up too many resources.
>
> But now my problem is that every time I shut down a DB, and every time= I
> boot a DB, it adds a message to the derby.log file, and over time the = log
> file grows and grows. =A0Is there any way to silence these messages?
I don't know any switch for it, but I perhaps you could leverage<= br> derby.stream.error.method to filter away the output you don't want, by<= br> building your own stream impl.

http://db.apache.org/derby/docs/10.5/ref/rrefproper35028.h= tml

Dag

>
> Here is an example:
>
> ----------------------------------------------------------------
> 2010-05-10 20:35:55.703 GMT:
> =A0Booting Derby version The Apache Software Foundation - Apache Derby= -
> 10.5.3.0 - (802917): instance a816c00e-0128-83ee-5a69-00002248f366
> on database directory
> C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_11
>
> Database Class Loader started - derby.database.classpath=3D''<= br> >
> 2010-05-10 20:35:56.172 GMT:
> Shutting down instance a816c00e-0128-83ee-5a69-00002248f366
> ----------------------------------------------------------------
> ----------------------------------------------------------------
> 2010-05-10 20:35:56.188 GMT:
> =A0Booting Derby version The Apache Software Foundation - Apache Derby= -
> 10.5.3.0 - (802917): instance 6839c016-0128-83ee-5a69-00002248f366
> on database directory
> C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_12
>
> Database Class Loader started - derby.database.classpath=3D''<= br> >
> 2010-05-10 20:35:56.235 GMT:
> Shutting down instance 6839c016-0128-83ee-5a69-00002248f366
> ----------------------------------------------------------------
> ----------------------------------------------------------------
> 2010-05-10 20:35:56.235 GMT:
> =A0Booting Derby version The Apache Software Foundation - Apache Derby= -
> 10.5.3.0 - (802917): instance 286cc01e-0128-83ee-5a69-00002248f366
> on database directory
> C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_11
>
> Database Class Loader started - derby.database.classpath=3D''<= br> >
> 2010-05-10 20:35:56.282 GMT:
> Shutting down instance 286cc01e-0128-83ee-5a69-00002248f366
> ----------------------------------------------------------------
> ----------------------------------------------------------------
> 2010-05-10 20:35:56.297 GMT:
> =A0Booting Derby version The Apache Software Foundation - Apache Derby= -
> 10.5.3.0 - (802917): instance e8afc026-0128-83ee-5a69-00002248f366
> on database directory
> C:\Vontu\Protect\scan\incremental_index\MONITOR_TARGET_12
>
> Database Class Loader started - derby.database.classpath=3D''<= br> >
> 2010-05-10 20:35:56.344 GMT:
> Shutting down instance e8afc026-0128-83ee-5a69-00002248f366
> ----------------------------------------------------------------
>
> --
> David W. Van Couvering
>
> http:= //www.linkedin.com/in/davidvc
> ht= tp://davidvancouvering.blogspot.com
> http://twi= tter.com/dcouvering

--
Dag H. Wanvik, staff engineer
Sun Microsystems, Java Core and Desktop - Java DB/Derby
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax: =A0+47 73842101
Sun IM: dw136674, Yahoo IM: dag_h_wanvik



--
David W. Van Cou= vering

http://www.lin= kedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering=
--00c09f89973ff31d11048645d55e--