[
https://issues.apache.org/jira/browse/DERBY-7075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vamsavardhana Reddy updated DERBY-7075:
---------------------------------------
Attachment: javaheapdump-oom-derby-v10833.zip
javaheapdump-oom-derby-101420.zip
> OutOfMemory Exceptions in derby server process
> ----------------------------------------------
>
> Key: DERBY-7075
> URL: https://issues.apache.org/jira/browse/DERBY-7075
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.8.3.0, 10.14.2.0
> Reporter: Vamsavardhana Reddy
> Priority: Major
> Attachments: javaheapdump-oom-derby-101420.zip,
> javaheapdump-oom-derby-v10833.zip
>
>
> We have two runtime environments v7.5.4 and v7.5.3 similar in terms of OS
> memory, java version and java launch command settings for the derby and other
> java processes required for our application in which similar
> projects/workloads are running. But in one of the environments we are seeing
> out of memory (OOM) exceptions in the derby server java process. In this
> environment where OOM is occurring, we even refreshed Apache derby to the
> latest version available for Java 8 and still encountered OOM exceptions.
> Please help resolve this OOM issue. :*v7.5.4*
> OS: RHELv8 with 4GB RAM
> Java: IBM Java SDK v8.0.6.0
> Apache Derby v10.8.3.3, Apache Derby v10.14.2.0[bceglc385/Standalone ~]#
> /usr/java/default/jre/bin/java -version
> java version "1.8.0_231"
> Java(TM) SE Runtime Environment (build 8.0.6.0 - pxa6480sr6-20191107_01(SR6))
> IBM J9 VM (build 2.9, JRE 1.8.0 Linux amd64-64-Bit Compressed References
> 20191106_432135 (JIT enabled, AOT enabled)
> OpenJ9 - f0b6be7
> OMR - 18d8f94
> IBM - 233dfb5)
> JCL - 20191016_01 based on Oracle jdk8u231-b10/usr/java/default/bin/java
> -server -Xdump:heap+system+snap:none
> -Xdump:heap:events=user,file=/var/log/javaheapdump-user-derby.ph
> -Xdump:heap:events=systhrow,filter=java/lang/OutOfMemoryError,file=/var/log/javaheapdump-oom-derby.phd,range=1..1
>
> -Xdump!https://emoji.slack-edge.com/T27SFGS2W/java/c0a6f7d2f3faab62.png!defaults:file=/var/log/javacore-derby.txt
> -Xmx512m -Xms512m -Xmn192m -agentlib:CastIron
> -Xbootclasspath/p:/usr/ironhide/maestro/bundles/com.approuter.management.jmxremote-1.0.0.jar:
> -Xgcpolicy:gencon -Xverbosegclog:/var/log/derbyserver_gc.log,10,1000
> -XX:+HeapManagementMXBeanCompatibility
> -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger
> -Dderby.system.home=/usr/ironhide/var/db/staging
> -Dcom.sun.management.jmxremote
> -Dcom.approuter.management.jmxremote.connectorserver.port=31997
> -Djmx.remote.protocol.provider.pkgs=com.approuter.management.jmxremote
> -Dcom.sun.management.jmxremote.port=1997
> -Dcom.sun.management.jmxremote.local.only=false
> -Dcom.sun.management.jmxremote.ssl=false
> -Dcom.sun.management.jmxremote.authenticate=true
> -Dcom.sun.management.jmxremote.password.file=/usr/ironhide/maestro/management/jmxremote.password
>
> -Dcom.sun.management.jmxremote.access.file=/usr/ironhide/maestro/management/jmxremote.access
> -Dcom.approuter.logging.filename=derbyserver.log
> -Djava.rmi.server.hostname=9.121.242.177
> -[Djava.net|https://slack-redir.net/link?url=http%3A%2F%2FDjava.net].preferIPv4Stack=true
> -Dcom.approuter.sysconf.appliance=true
> -Dcom.mchange.v2.log.MLog=com.mchange.v2.log.jdk14logging.Jdk14MLog
> -Dcom.mchange.v2.resourcepool.experimental.useScatteredAcquireTask=true
> -Dc3p0.checkoutTimeout=30000 -Dc3p0.maxIdleTimeExcessConnections=30
> -Dc3p0.maxStatementsPerConnection=100 -Dc3p0.testConnectionOnCheckin=true
> -Dc3p0.testConnectionOnCheckout=true -Dc3p0.numHelperThreads=10
> -Dosgi.clean=true
> -Dosgi.configuration.area=/usr/ironhide/maestro/bundles/derbyserver
> -Dorg.osgi.framework.bootdelegation=* -Declipse.application.noDefault=true
> -Declipse.consoleLog=true
> -Dcom.approuter.orcmon.purger.compressionmode=sequential
> -DIH_ROOT=/usr/ironhide
> -Djava.util.logging.config.file=/usr/ironhide/maestro/etc/logging.properties
> -jar
> /usr/ironhide/maestro/bundles/org.eclipse.osgi_3.10.1.v20140909-1633.jar[bceglc390/Standalone
> ~]# cat /proc/meminfo
> MemTotal: 4057920 kB
> MemFree: 152896 kB
> Buffers: 342624 kB
> Cached: 729112 kB
> SwapCached: 3428 kB
> Active: 2644068 kB
> Inactive: 1066404 kB
> Active(anon): 1951704 kB
> Inactive(anon): 712696 kB
> Active(file): 692364 kB
> Inactive(file): 353708 kB
> Unevictable: 20 kB
> Mlocked: 20 kB
> SwapTotal: 3999736 kB
> SwapFree: 3988760 kB
> Dirty: 720 kB
> Writeback: 0 kB
> AnonPages: 2636560 kB
> Mapped: 38508 kB
> Shmem: 25648 kB
> Slab: 129600 kB
> SReclaimable: 48320 kB
> SUnreclaim: 81280 kB
> KernelStack: 6568 kB
> PageTables: 11116 kB
> NFS_Unstable: 0 kB
> Bounce: 0 kB
> WritebackTmp: 0 kB
> CommitLimit: 6028696 kB
> Committed_AS: 1658244 kB
> VmallocTotal: 34359738367 kB
> VmallocUsed: 152396 kB
> VmallocChunk: 34359582800 kB
> AnonHugePages: 2433024 kB
> HugePages_Total: 0
> HugePages_Free: 0
> HugePages_Rsvd: 0
> HugePages_Surp: 0
> Hugepagesize: 2048 kB
> DirectMap4k: 4096 kB
> DirectMap2M: 4190208 kB----------
> *v7.5.3*
> OS: Bedrock v5 which is custom OS based on RHELv7 with 4GB RAM
> Java: IBM Java SDK v8.0.6.0
> Apache Derby v10.8.3.3[bceglc390/Standalone ~]#
> /usr/java/default/jre/bin/java -version
> java version "1.8.0_231"
> Java(TM) SE Runtime Environment (build 8.0.6.0 - pxa6480sr6-20191107_01(SR6))
> IBM J9 VM (build 2.9, JRE 1.8.0 Linux amd64-64-Bit Compressed References
> 20191106_432135 (JIT enabled, AOT enabled)
> OpenJ9 - f0b6be7
> OMR - 18d8f94
> IBM - 233dfb5)
> JCL - 20191016_01 based on Oracle jdk8u231-b10/usr/java/default/bin/java
> -server -Xdump:heap+system+snap:none
> -Xdump:heap:events=user,file=/var/log/javaheapdump-user-derby.phd
> -Xdump:heap:events=systhrow,filter=java/lang/OutOfMemoryError,file=/var/log/javaheapdump-oom-derby.phd,range=1..1
>
> -Xdump!https://emoji.slack-edge.com/T27SFGS2W/java/c0a6f7d2f3faab62.png!defaults:file=/var/log/javacore-derby.txt
> -Xmx512m -Xms512m -Xmn192m -agentlib:CastIron
> -Xbootclasspath/p:/usr/ironhide/maestro/bundles/com.approuter.management.jmxremote-1.0.0.jar:
> -Xgcpolicy:gencon -Xverbosegclog:/var/log/derbyserver_gc.log,10,1000
> -XX:+HeapManagementMXBeanCompatibility
> -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger
> -Dderby.system.home=/usr/ironhide/var/db/staging
> -Dcom.sun.management.jmxremote
> -Dcom.approuter.management.jmxremote.connectorserver.port=31997
> -Djmx.remote.protocol.provider.pkgs=com.approuter.management.jmxremote
> -Dcom.sun.management.jmxremote.port=1997
> -Dcom.sun.management.jmxremote.local.only=false
> -Dcom.sun.management.jmxremote.ssl=false
> -Dcom.sun.management.jmxremote.authenticate=true
> -Dcom.sun.management.jmxremote.password.file=/usr/ironhide/maestro/management/jmxremote.password
>
> -Dcom.sun.management.jmxremote.access.file=/usr/ironhide/maestro/management/jmxremote.access
> -Dcom.approuter.logging.filename=derbyserver.log
> -Djava.rmi.server.hostname=9.124.112.240
> -[Djava.net|https://slack-redir.net/link?url=http%3A%2F%2FDjava.net].preferIPv4Stack=true
> -Dcom.approuter.sysconf.appliance=true
> -Dcom.mchange.v2.log.MLog=com.mchange.v2.log.jdk14logging.Jdk14MLog
> -Dcom.mchange.v2.resourcepool.experimental.useScatteredAcquireTask=true
> -Dc3p0.checkoutTimeout=30000 -Dc3p0.maxIdleTimeExcessConnections=30
> -Dc3p0.maxStatementsPerConnection=100 -Dc3p0.testConnectionOnCheckin=true
> -Dc3p0.testConnectionOnCheckout=true -Dc3p0.numHelperThreads=10
> -Dosgi.clean=true
> -Dosgi.configuration.area=/usr/ironhide/maestro/bundles/derbyserver
> -Dorg.osgi.framework.bootdelegation=* -Declipse.application.noDefault=true
> -Declipse.consoleLog=true
> -Dcom.approuter.orcmon.purger.compressionmode=sequential
> -DIH_ROOT=/usr/ironhide
> -Djava.util.logging.config.file=/usr/ironhide/maestro/etc/logging.properties
> -jar
> /usr/ironhide/maestro/bundles/org.eclipse.osgi_3.10.1.v20140909-1633.jar[cldegdh9/Standalone
> log]# cat /proc/meminfo
> MemTotal: 3872868 kB
> MemFree: 343700 kB
> MemAvailable: 374676 kB
> Buffers: 33100 kB
> Cached: 170624 kB
> SwapCached: 3848 kB
> Active: 2540784 kB
> Inactive: 710092 kB
> Active(anon): 2429812 kB
> Inactive(anon): 621324 kB
> Active(file): 110972 kB
> Inactive(file): 88768 kB
> Unevictable: 20 kB
> Mlocked: 20 kB
> SwapTotal: 5345272 kB
> SwapFree: 5280760 kB
> Dirty: 1880 kB
> Writeback: 0 kB
> AnonPages: 3044312 kB
> Mapped: 33676 kB
> Shmem: 3984 kB
> Slab: 119980 kB
> SReclaimable: 71120 kB
> SUnreclaim: 48860 kB
> KernelStack: 15116 kB
> PageTables: 13936 kB
> NFS_Unstable: 0 kB
> Bounce: 0 kB
> WritebackTmp: 0 kB
> CommitLimit: 7281704 kB
> Committed_AS: 1755044 kB
> VmallocTotal: 34359738367 kB
> VmallocUsed: 0 kB
> VmallocChunk: 0 kB
> HardwareCorrupted: 0 kB
> AnonHugePages: 2885632 kB
> ShmemHugePages: 0 kB
> ShmemPmdMapped: 0 kB
> HugePages_Total: 0
> HugePages_Free: 0
> HugePages_Rsvd: 0
> HugePages_Surp: 0
> Hugepagesize: 2048 kB
> Hugetlb: 0 kB
> DirectMap4k: 126912 kB
> DirectMap2M: 4067328 kB
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
