From derby-user-return-14546-apmail-db-derby-user-archive=db.apache.org@db.apache.org Fri Aug 17 13:01:22 2012 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id ABFBDDB27 for ; Fri, 17 Aug 2012 13:01:22 +0000 (UTC) Received: (qmail 15186 invoked by uid 500); 17 Aug 2012 13:01:22 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 15079 invoked by uid 500); 17 Aug 2012 13:01:22 -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 15071 invoked by uid 99); 17 Aug 2012 13:01:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Aug 2012 13:01:21 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of elstefanito@gmail.com designates 209.85.214.44 as permitted sender) Received: from [209.85.214.44] (HELO mail-bk0-f44.google.com) (209.85.214.44) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Aug 2012 13:01:12 +0000 Received: by bkty7 with SMTP id y7so1535380bkt.31 for ; Fri, 17 Aug 2012 06:00:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:x-mailer:thread-index:content-language; bh=cA5bQiGveIh8P/3MBnFLmNLAX7k0mdvCT7nnlL6CCIs=; b=LkGGGD5VLonZO4SmD7D1KfV6/gI8Ftn3OGIKr/WXLyK4FR/X5yJgAld1wr2YTvd/AY 3dETTS+A4N8PiKe/oTxU4OK0jHL7rPVdzoU0VdNOrbagnEDYqlhYgBtMlRVqkiFaZr+c IbssOu6BoGT8ipA0CoD3wBjg2WkfDFmPKZB82sl6KdjprrH4v59RxNYY/5jC6PZrQS1J 7ImQQCjbUajqvpxquKqv68LWMWp5kAzZwS90v8fQ5j8GoixsgGCdU4JPih/1d9yXS6zM PdlfD4UoUxeFFZVHkSw5UpfDFvVfVC5NVhkXT4HkIksw38DJ4ginqoR87dFSXOUUh645 9lnA== Received: by 10.205.118.5 with SMTP id fo5mr1868792bkc.124.1345208451715; Fri, 17 Aug 2012 06:00:51 -0700 (PDT) Received: from wallbreaker (p579D3A1C.dip.t-dialin.net. [87.157.58.28]) by mx.google.com with ESMTPS id n5sm3603888bkv.14.2012.08.17.06.00.49 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 17 Aug 2012 06:00:50 -0700 (PDT) From: "Stefan R." To: "'Derby Discussion'" References: <001201cd7c68$3263d9a0$972b8ce0$@gmail.com> <-871283162954399361@unknownmsgid> In-Reply-To: <-871283162954399361@unknownmsgid> Subject: AW: Problems with Online Backup SYSCS_BACKUP_DATABASE Date: Fri, 17 Aug 2012 15:00:47 +0200 Message-ID: <005601cd7c78$53157f90$f9407eb0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0057_01CD7C89.169FAF20" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQHO+vmR/FYO3sM4awWe9/8w3S+fNgI+nLlZl0kEdzA= Content-Language: de This is a multipart message in MIME format. ------=_NextPart_000_0057_01CD7C89.169FAF20 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi, Thanks for your answer. =20 We have 18G available at the backup destination. The size of the = database directory is: 17G. The strange thing is that it works one day, the other = it doesn't. =20 Stefan =20 =20 Von: Peter Ondru=9Aka [mailto:peter.ondruska@kaibo.eu]=20 Gesendet: Freitag, 17. August 2012 14:44 An: Derby Discussion Betreff: Re: Problems with Online Backup SYSCS_BACKUP_DATABASE =20 hi, there should be in the backup destination as much disk space = available as your database size without logs. Peter On 17. 8. 2012, at 13:06, "Stefan R." wrote: Hi, We're using Derby DB (Version 10.8.2.2) in a larger project. Our = database size is now around 12GB. It is running as network service and is used as = the data backend for several Java web projects, that are connecting to the database using the network jdbc client. One of the projects is = triggering nightly backups using the command: =20 CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?) =20 Randomly (every 2 or 3 days) the backup cannot complete because of the following exception: =20 Aug 13 00:03:14 srv- test-001 jsvc.exec[5953]: a:662)#012Caused by: org.apache.derby.client.am.SqlException: Cannot backup the database, got = an I/O Exception while writing to the backup container file /mnt/backup/2012-08-13-00-00-00/bd/seg0/c9b1.dat.#012#011at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)#012#011at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown= Source)#012#011at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)#012#011at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)#012#011at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)#012#011at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)#012#011at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)#012#011at org.apache.derby.client.am.PreparedStatement.executeX(Unknown Source)#012#011... 21 more#012Caused by: org.apache.derby.client.am.SqlException: Java exception: 'No space left = on device: java.io.IOException'.#012#011... 29 more =20 The available space on the target device is more than sufficient. We = already started the derby process with the Java Option "-Djava.io.tmpdir" to = point to a directory residing on a partition with more space. This did not = help. =20 Do you have any suggestions? Which directories are used for running the backup and how much space needs to be availabe? =20 Thank you, Stefan =20 ------=_NextPart_000_0057_01CD7C89.169FAF20 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Hi,

Thanks for = your answer.

 

We have 18G = available at the backup destination. The size of the database directory = is: 17G. The strange thing is that it works one day, the other it = doesn't.

 

Stefan

 

 

Von: Peter Ondru=9Aka [mailto:peter.ondruska@kaibo.eu] =
Gesendet: Freitag, 17. August 2012 14:44
An: Derby = Discussion
Betreff: Re: Problems with Online Backup = SYSCS_BACKUP_DATABASE

 

hi, there should be in the backup = destination as much disk space available as your database size without = logs.

Peter


On 17. 8. 2012, at = 13:06, "Stefan R." <elstefanito@gmail.com> = wrote:

Hi,

We're using Derby DB (Version = 10.8.2.2) in a larger project. Our database size is now around 12GB. It = is running as network service and is used as the data backend for = several Java web projects, that are connecting to the database using the = network jdbc client. One of the projects is triggering nightly backups = using the command:

 

CALL = SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)

 

Randomly (every 2 or 3 days) the = backup cannot complete because of the following = exception:

 

Aug 13 00:03:14 srv- test-001 = jsvc.exec[5953]: a:662)#012Caused by: = org.apache.derby.client.am.SqlException: Cannot backup the database, got = an I/O Exception while writing to the backup container file = /mnt/backup/2012-08-13-00-00-00/bd/seg0/c9b1.dat.#012#011at = org.apache.derby.client.am.Statement.completeExecute(Unknown = Source)#012#011at = org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown= Source)#012#011at = org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown = Source)#012#011at = org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown = Source)#012#011at = org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown = Source)#012#011at = org.apache.derby.client.am.Statement.readExecuteCall(Unknown = Source)#012#011at = org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown = Source)#012#011at = org.apache.derby.client.am.PreparedStatement.executeX(Unknown = Source)#012#011... 21 more#012Caused by: = org.apache.derby.client.am.SqlException: Java exception: 'No space left = on device: java.io.IOException'.#012#011... 29 = more

 

The available space on the target = device is more than sufficient. We already started the derby process = with the Java Option "-Djava.io.tmpdir" to point to a = directory residing on a partition with more space. This did not = help.

 

Do you have any suggestions? Which directories are used for = running the backup and how much space needs to be = availabe?

 

Thank you,

Stefan

 

= ------=_NextPart_000_0057_01CD7C89.169FAF20--