[
https://issues.apache.org/jira/browse/DERBY-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12601382#action_12601382
]
Semih ARAL commented on DERBY-3698:
-----------------------------------
I commited periodically, the first cleanup action provoked the OutOfMemoryError
again.
derby.log
2008-05-31 12:35:33.576 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PG Finances (FR)' :End
prepared statement
2008-05-31 12:35:33.592 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PG Finances (FR)' :End prepared
statement
2008-05-31 12:35:33.592 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Executing prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PG Finances (FR)' :End prepared
statement
2008-05-31 12:35:33.623 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
INSERT INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ,
LEAD) VALUES (8282, 100, 5, 691, 0) :End prepared statement
2008-05-31 12:35:34.780 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: INSERT
INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD)
VALUES (8282, 100, 5, 691, 0) :End prepared statement
2008-05-31 12:35:34.780 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Executing prepared statement: INSERT
INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD)
VALUES (8282, 100, 5, 691, 0) :End prepared statement
2008-05-31 12:35:34.780 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296419),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Committing
2008-05-31 12:35:34.811 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PRIVATA' :End prepared
statement
2008-05-31 12:35:34.826 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PRIVATA' :End prepared statement
2008-05-31 12:35:34.842 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Executing prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='PRIVATA' :End prepared statement
2008-05-31 12:35:34.858 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
INSERT INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ,
LEAD) VALUES (8283, 100, 5, 692, 0) :End prepared statement
2008-05-31 12:35:34.858 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: INSERT
INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD)
VALUES (8283, 100, 5, 692, 0) :End prepared statement
2008-05-31 12:35:34.873 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Executing prepared statement: INSERT
INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD)
VALUES (8283, 100, 5, 692, 0) :End prepared statement
2008-05-31 12:35:34.873 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296422),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Committing
2008-05-31 12:35:34.905 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='SEQUA Foundation for
Economic Development and Vocational Training (DE)' :End prepared statement
2008-05-31 12:35:34.936 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='SEQUA Foundation for Economic
Development and Vocational Training (DE)' :End prepared statement
2008-05-31 12:35:34.936 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Executing prepared statement: SELECT
PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='SEQUA Foundation for Economic
Development and Vocational Training (DE)' :End prepared statement
2008-05-31 12:35:34.951 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Begin compiling prepared statement:
INSERT INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ,
LEAD) VALUES (8284, 100, 5, 693, 0) :End prepared statement
2008-05-31 12:35:34.967 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), End compiling prepared statement: INSERT
INTO EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD)
VALUES (8284, 100, 5, 693, 0) :End prepared statement
2008-05-31 12:35:37.389 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Cleanup action starting
2008-05-31 12:35:37.389 GMT Thread[DRDAConnThread_3,5,main] (XID = 3296425),
(SESSIONID = 1), (DATABASE = euProj02), (DRDAID =
NF000001.GCA7-4470102892905539235{2}), Failed Statement is: INSERT INTO
EUPROJ.SHORTLIST (PK_SEQ, FK_LOT_SEQ, CONSORTIUM_NO, FK_FIRM_SEQ, LEAD) VALUES
(8284, 100, 5, 693, 0)
java.lang.OutOfMemoryError
Cleanup action completed
2008-05-31 12:36:02.967 GMT Thread[DRDAConnThread_4,5,main] (XID = 3293757),
(SESSIONID = 3), (DATABASE = euProj02), (DRDAID =
NF000001.GCA9-4469539942952112219{4}), Rolling back
2008-05-31 12:36:02.967 GMT Thread[DRDAConnThread_4,5,main] (XID = 3293757),
(SESSIONID = 3), (DATABASE = euProj02), (DRDAID =
NF000001.GCA9-4469539942952112219{4}), Rolling back
2008-05-31 12:36:02.967 GMT Thread[DRDAConnThread_2,5,main] (XID = 3267370),
(SESSIONID = 2), (DATABASE = euProj02), (DRDAID =
NF000001.GCA8-4469821417928824563{3}), Rolling back
2008-05-31 12:36:02.967 GMT Thread[DRDAConnThread_2,5,main] (XID = 3267370),
(SESSIONID = 2), (DATABASE = euProj02), (DRDAID =
NF000001.GCA8-4469821417928824563{3}), Rolling back
> Bulk SQL INSERT, SELECT, UPDATE operations creates OutOfMemoryError after
> first Cleanup action on serverside
> ------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3698
> URL: https://issues.apache.org/jira/browse/DERBY-3698
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.4.1.3
> Environment: Windows XP, JDK 1.4
> Reporter: Semih ARAL
>
> In the migration of an DB,
> By using JDBC (connection is open one time in the begining)
> after many INSERT, SELECT,UPDATE statement executions (more than 3500)
> I got the following Exception on the client side:
> SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION
> University OF LONDON'
> com.javaDevHome.ladyBeetle.exception.MicroJDBCException:
> java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001,
> SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
> at
> com.javaDevHome.ladyBeetle.MicroJDBCConnection.executeQuery(MicroJDBCConnection.java:251)
> at
> com.javaDevHome.ladyBeetle.MicroJDBCDBase.selectRowSilent(MicroJDBCDBase.java:133)
> at euProj.transfer.Transfer.procFirmNew(Transfer.java:259)
> at euProj.transfer.Transfer.procshortListNew(Transfer.java:200)
> at euProj.transfer.Transfer.readConsortiums(Transfer.java:524)
> at euProj.transfer.Transfer.procContract(Transfer.java:107)
> at euProj.transfer.Transfer.readLine(Transfer.java:554)
> at euProj.transfer.Transfer.main(Transfer.java:594)
> Caused by: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE:
> XJ001, SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
> at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
> at
> com.javaDevHome.ladyBeetle.MicroJDBCConnection.executeQuery(MicroJDBCConnection.java:247)
> ... 7 more
> Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE:
> -1, SQLSTATE: XJ001, SQLERRMC: java.lang.OutOfMemoryErrorXJ001.U
> at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
> at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
> at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
> at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
> at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
> at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
> ... 9 more
> in derby.log on the server side :
> 2008-05-29 20:33:04.578 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959),
> (SESSIONID = 4), (DATABASE = euProj03), (DRDAID =
> NF000001.H1CF-4339779978832484505{5}), Begin compiling prepared statement:
> SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION
> University OF LONDON' :End prepared statement
> 2008-05-29 20:33:04.609 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959),
> (SESSIONID = 4), (DATABASE = euProj03), (DRDAID =
> NF000001.H1CF-4339779978832484505{5}), End compiling prepared statement:
> SELECT PK_SEQ, NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION
> University OF LONDON' :End prepared statement
> 2008-05-29 20:33:07.499 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959),
> (SESSIONID = 4), (DATABASE = euProj03), (DRDAID =
> NF000001.H1CF-4339779978832484505{5}), Cleanup action starting
> 2008-05-29 20:33:07.499 GMT Thread[DRDAConnThread_5,5,main] (XID = 171959),
> (SESSIONID = 4), (DATABASE = euProj03), (DRDAID =
> NF000001.H1CF-4339779978832484505{5}), Failed Statement is: SELECT PK_SEQ,
> NAME, URL FROM EUPROJ.FIRM WHERE NAME ='INSTITUTE OF EDUCATION University OF
> LONDON'
> java.lang.OutOfMemoryError
> Cleanup action completed
> 2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_6,5,main] (XID = 169430),
> (SESSIONID = 6), (DATABASE = euProj03), (DRDAID =
> NF000001.H1D1-4255618960795994455{7}), Rolling back
> 2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_6,5,main] (XID = 169430),
> (SESSIONID = 6), (DATABASE = euProj03), (DRDAID =
> NF000001.H1D1-4255618960795994455{7}), Rolling back
> 2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_4,5,main] (XID = 143043),
> (SESSIONID = 5), (DATABASE = euProj03), (DRDAID =
> NF000001.H1D0-4255900435772705908{6}), Rolling back
> 2008-05-29 20:33:37.359 GMT Thread[DRDAConnThread_4,5,main] (XID = 143043),
> (SESSIONID = 5), (DATABASE = euProj03), (DRDAID =
> NF000001.H1D0-4255900435772705908{6}), Rolling back
> in the derby.log there is no other Cleanup action, this is the first and the
> only one.
> I have started the server by default heap memory options:
> java -Dderby.system.home=C:\derby -jar %DERBY_HOME%\lib\derbyrun.jar server
> start
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
