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)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----_=_NextPart_001_01CA6F6B.92ECA6A4"
Subject: AW: AW: AW: OOM with millions of weakly-referenced Derby objects
Date: Fri, 27 Nov 2009 15:11:54 +0100
Message-ID: 
 <0773A3CE9DAC7B42B8F564C52805678D02647E72@EVS01.INTERN.INTERPAY.NL>
In-Reply-To: <x1oxr5rkzuon.fsf@sun.com>
Thread-Topic: AW: AW: OOM with millions of weakly-referenced Derby objects
Thread-Index: Acpu92urvEOUoRrfR9ing8rVJu/UDgAcQgLA
References: <5268113955D1B54ABB357F639594DAB235DF4F@bcdc.boxicom.lan>
 <a10a823c0911171059q356f0034lef1ed44c5aedff31@mail.gmail.com>
 <4B03A73D.7010201@Sun.COM>
 <5268113955D1B54ABB357F639594DAB235E074@bcdc.boxicom.lan>
 <0773A3CE9DAC7B42B8F564C52805678D0264783D@EVS01.INTERN.INTERPAY.NL>
 <0773A3CE9DAC7B42B8F564C52805678D0264792C@EVS01.INTERN.INTERPAY.NL>
 <x1oxws1l3u4k.fsf@sun.com>
 <0773A3CE9DAC7B42B8F564C52805678D02647A00@EVS01.INTERN.INTERPAY.NL>
 <x1oxr5rkzuon.fsf@sun.com>
From: <Malte.Kempff@de.equens.com>
To: <derby-user@db.apache.org>

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA6F6B.92ECA6A4
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Dag,
The problem in my case is, that I don't have access to any AIX-Computer, =
and that is really a pity, because I cannot reconstruct the scenario on =
my own and watch it with my own eyes.
That all happened on a production system and the provider denies trying =
it out again.
But attached you can find the SQL-script without being UTF8.
So that Problem should occur in the same way used on AIX (5.3)
BTW: is there a way to be kind of independent of the input format?

Malte

-----Urspr=FCngliche Nachricht-----
Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM]=20
Gesendet: Freitag, 27. November 2009 01:19
An: Derby Discussion
Betreff: Re: AW: AW: OOM with millions of weakly-referenced Derby =
objects

Malte.Kempff@de.equens.com writes:

> Yes this is the API I am reffering to.  Well actually it says that,
> but in my case it did not do it.  It needed a long time, several
> minutes. Reason as it turned later out, after getting the output in
> a file a lot of IOExcceptions. I never got those on windows nor on
> Solaris. Thr original logic of the routine calling the runScript
> Method was asking for the return code but either it never hit this
> if statement and crashed somewhere within ij without giving the
> Exception to the caller or ij gave something like 0 so the output
> never was given to the logger.  So there is something phony with
> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
> but declaring in the parameters as UTF8. Of course that is a fault
> by my own, but it should tel me about it.

I looked at the implementation for runScript in
org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
to catch exceptions, count them and return them. Are you able to
provide a repro script showing that 0 or -1 is returned from runScript
for the failing scenario?=20

Thanks,
Dag

>
>
>
> -----Urspr=FCngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM]=20
> Gesendet: Freitag, 20. November 2009 19:54
> An: Derby Discussion
> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
>
> Malte.Kempff@de.equens.com writes:
>
>> In other words I would count that situation as not nice behaviour of =
ij, since the return code should have been given as I would suppose it =
looking at the method signature.
>
> Is this the API signature you are referring to?
>
> =
http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/=
tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20jav=
a.lang.String,%20java.io.OutputStream,%20java.lang.String)
>
> It says:
>
> Returns:
>     Number of SQLExceptions thrown during the execution, -1 if not
>     known.=20
>
> If so, are you seeing 0 or -1 returned here?
>
> Dag
>

--=20
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

------_=_NextPart_001_01CA6F6B.92ECA6A4
Content-Type: application/octet-stream;
	name="schemadef_no_utf8.sql"
Content-Transfer-Encoding: base64
Content-Description: schemadef_no_utf8.sql
Content-Disposition: attachment;
	filename="schemadef_no_utf8.sql"

LS0gPT09PT09PT09PT09PT09PT09PT09PT09PT09PQoKLS0gRGllc2UgRGF0ZWkgd3VyZGUgbWl0
IGRlbSBEZXJieS1EaWVuc3Rwcm9ncmFtbSBkYmxvb2sgZXJzdGVsbHQuCi0tIFplaXRtYXJrZTog
MjAwOS0wOC0yOCAxODowMzo0Ny45MzUKLS0gUXVlbGxlbmRhdGVuYmFuazogYzovVGVtcC90dXRv
cmlhbHNEQgotLSBWZXJiaW5kdW5ncy1VUkw6IGpkYmM6ZGVyYnk6YzovVGVtcC90dXRvcmlhbHNE
QgotLSBhcHBlbmRMb2dzOiBmYWxzZQoKLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLQotLSBEREwtQW53ZWlzdW5nZW4gZvxyIFNjaGVtYXRhCi0tIC0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KCi0tIC0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KLS0gRERMLUFud2Vpc3VuZ2VuIGb8
ciBUYWJlbGxlbgotLSAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tCgpDUkVBVEUgVEFCTEUgIkFQUCIuIk1FTU9fUkVDT1JEUyIgKAogICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAiUkVDT1JEX0lEIiAgIFZBUkNIQVIoNTEyKSBOT1QgTlVMTAog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICwiVE1QU1RfSU4iICAgIFRJTUVTVEFN
UCBOT1QgTlVMTCBERUZBVUxUIENVUlJFTlRfVElNRVNUQU1QCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgLCJUTVBTVF9VU0VEIiAgVElNRVNUQU1QCiAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgLCJTVEFURSIgICAgICAgQ0hBUigxKSBOT1QgTlVMTCBERUZBVUxU
ICdJJwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgKTsKCkNSRUFURSBUQUJMRSAi
QVBQIi4iTUVNT19GSUVMRFMiICgKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAi
UkVDT1JEX0lEIiAgIFZBUkNIQVIoNTEyKSAgTk9UIE5VTEwKICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICwiRklFTERfSUQiICAgIFZBUkNIQVIoNTEyKSAgTk9UIE5VTEwKICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICwiRklFTERfVkFMVUUiIFZBUkNIQVIoMTAyNCkg
Tk9UIE5VTEwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICwiRklFTERfQVRUUiIg
IFZBUkNIQVIoMTAyNCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgKTsKCgoKLS0g
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQotLSBEREwtQW53
ZWlzdW5nZW4gZvxyIEluZGl6ZXMKLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLQoKQ1JFQVRFIElOREVYICJBUFAiLiJJTkRfTUVNT19SRUNPUkRTX1RNUFNU
IiBPTiAiQVBQIi4iTUVNT19SRUNPUkRTIiAoIlRNUFNUX0lOIiBERVNDKTsKCi0tIC0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KLS0gRERMLUFud2Vpc3VuZ2Vu
IGb8ciBTY2hs/HNzZWwKLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQoKLS0gcHJpbeRyL2VpbmRldXRpZwotLUFMVEVSIFRBQkxFICJBUFAiLiJNRU1PX0ZJ
RUxEUyIgQUREIENPTlNUUkFJTlQgIlBLX0ZJRUxEIiBQUklNQVJZIEtFWSAoIlJFQ09SRF9JRCIs
ICJGSUVMRF9JRCIpOwoKQUxURVIgVEFCTEUgIkFQUCIuIk1FTU9fUkVDT1JEUyIgQUREIENPTlNU
UkFJTlQgIlBLX1JFQ09SRCIgUFJJTUFSWSBLRVkgKCJSRUNPUkRfSUQiKTsKCi0tIGZyZW1kCkFM
VEVSIFRBQkxFICJBUFAiLiJNRU1PX0ZJRUxEUyIgQUREIENPTlNUUkFJTlQgIkZLX0ZJRUxEIiBG
T1JFSUdOIEtFWSAoIlJFQ09SRF9JRCIpIFJFRkVSRU5DRVMgIkFQUCIuIk1FTU9fUkVDT1JEUyIg
KCJSRUNPUkRfSUQiKSBPTiBERUxFVEUgQ0FTQ0FERSBPTiBVUERBVEUgUkVTVFJJQ1Q7CgotLSAt
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCi0tIERETC1Bbndl
aXN1bmdlbiBm/HIg3GJlcnBy/GZ1bmdlbgotLSAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tCgpBTFRFUiBUQUJMRSAiQVBQIi4iTUVNT19SRUNPUkRTIiBBREQg
Q09OU1RSQUlOVCAiU1RBVEVfQ09OU1RSQUlOVCIgQ0hFQ0sgKFNUQVRFIElOICgnSScsICdVJykp
OwoK

------_=_NextPart_001_01CA6F6B.92ECA6A4--