db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brett Bergquist (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5387) Memory leak or unbounded consumption problem when running a utility to copy one database to another using SYSCS_EXPORT_TABLE and SYSCS_IMPORT_TABLE
Date Wed, 17 Aug 2011 19:45:27 GMT
Memory leak or unbounded consumption problem when running a utility to copy one database to
another using SYSCS_EXPORT_TABLE and SYSCS_IMPORT_TABLE
---------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-5387
                 URL: https://issues.apache.org/jira/browse/DERBY-5387
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.8.1.2
         Environment: Solaris 10/9, Oracle Java 1.6.0_22, 1Gb heap space (also ran with 8Gb
heap space with no difference other than how long it takes to run out of memory).
            Reporter: Brett Bergquist
            Priority: Critical


I have a utility that copies one database to another by using 'dblook" to export the schema
from the first which is then uses to create the copy's schema.  The tables are exported from
the first database using the SYSCS_EXPORT_TABLE and imported into the second database using
SYSCS_IMPORT_TABLE, processing each table before moving on to the next.  The the constraints
and indexes present in the schema generated by 'dblook' are applied to the second database.
 The utility runs out of memory regardless of the amount of memory given when run on a very
large database (one table has 75 million rows in it and the total database size is 110Gb of
disk storage).  The utility does complete on a smaller database.

I will attach the source code for the utility.  Also added the -XX:+HeapDumpOnOutOfMemory
flag and ran with -Xmx1024m heap.  I will attach the suspected leaks report generated by the
Eclipse MemoryAnalyzer tool.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message