db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Williamson, Nick" <nick_william...@mentor.com>
Subject RE: IJ out of memory
Date Tue, 14 Aug 2007 14:23:00 GMT
Thanks Kristian,

...and apologies for the lack of information. I knew as soon as I'd
posted that I should have said more about the environment...

My config is default AFAIK, with the exception that I have the error
logging set to 0. That said, I still get the OOME if I set error logging
back to the default 40k. I'm on XP Pro, running in a DOS shell. I invoke
IJ (10.2), then I "run create_db.sql" and it's towards the end of the
process that I get the OOME, after having created the tables, at the
point where I'm trying to create a load of FK constraints. 

I don't get a great deal of info in the derby.log file. Here are the
last few entries (I think the stack trace is actually related to the
problem with the PIN_FK8 constraint rather than the OOME) :

---------------------------------------------------

ERROR 42915: Foreign  Key 'PIN_FK8' is invalid because 'the delete rule
of foreign key  must be CASCADE. (The relationship would cause the table
to be delete-connected to the same table through multiple relationships
and such relationships must have the same delete rule (NO ACTION,
RESTRICT or CASCADE).) '. 
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.generateError(Unknown
Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.checkForMultiplePathInvalid
Cases(Unknown Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.validateDeleteConnection(Un
known Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.validateDeleteConnection(Un
known Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.validateDeleteConnection(Un
known Source)
	at
org.apache.derby.iapi.sql.dictionary.DDUtils.validateReferentialActions(
Unknown Source)
	at
org.apache.derby.impl.sql.execute.CreateConstraintConstantAction.execute
ConstantAction(Unknown Source)
	at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.execGuts(Unkn
own Source)
	at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConsta
ntAction(Unknown Source)
	at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown
Source)
	at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
	at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
Source)
	at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown
Source)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown
Source)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown
Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
Cleanup action completed
2007-08-14 14:00:50.978 GMT Thread[main,5,main] (XID = 9977), (SESSIONID
= 0), (DATABASE = chs), (DRDAID = null), Cleanup action starting
2007-08-14 14:00:50.978 GMT Thread[main,5,main] (XID = 9977), (SESSIONID
= 0), (DATABASE = chs), (DRDAID = null), 
Failed Statement is: ALTER TABLE logicproperty
  ADD CONSTRAINT r_186
  FOREIGN KEY
   ( zone_id )
  REFERENCES zone
  ON DELETE CASCADE
  
java.lang.OutOfMemoryError
Cleanup action completed

2007-08-14 14:00:57.087 GMT:
Shutting down instance c013800d-0114-64a7-80cd-000000100a28

----------------------------------------------------------------

BTW, it may be pertinent that the table it is working on at the time of
the OOME (that is, LOGICPROPERTY) is a poorly-constructed thing with
nearly 50 FK constraints. Unfortunately, we're stuck with it. I'll try
creating the schema without those constraints to see if I still get the
error...

HTH
Nick


Mime
View raw message