[
https://issues.apache.org/jira/browse/DERBY-3746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13214170#comment-13214170
]
Matthew Cooper commented on DERBY-3746:
---------------------------------------
Problem is not fixed in 10.8.1.2.
Exact same stack trace as I last listed, occurred this morning and 2 days ago.
Restart of service fixed the issue both times. Regarding location of database,
it is on local filesystem on a virtual machine.
To answer Kristian's questions (sorry, I didn't receive mail notifications for
comments):
* are you running embedded only?
** Embedded but running network server on localhost for other processes to
access
* do you have multiple threads accessing the database, specifically shutting
down and booting/connecting "at the same time"?
** There are multiple threads accessing the database, but the database is
'booted' before these threads start.
* when you hit the problem, did it persist consistently (i.e. it happened on
every subsequent connection attempt)?
** Yes, until the process is restarted.
To repeat, this is the stack trace we are getting.
23-Feb-2012 04:36:07.788 WARN 2031264-17
com.eventzero.occurrence.service.rule.RuleService | Unexpected exception in
rule service
java.lang.RuntimeException: Could not create connection for
[ConnectionPool@2fd09539 driverClassName=org.apache.derby.jdbc.EmbeddedDriver
username=CORLOG]
at
com.eventzero.util.jdbc.ConnectionPool.createConnection(ConnectionPool.java:205)
[common-e7817d5958e473be2275283ab647b8ca.jar:v3.6.6_29]
at com.eventzero.util.jdbc.ConnectionPool.take(ConnectionPool.java:125)
[common-e7817d5958e473be2275283ab647b8ca.jar:v3.6.6_29]
at
com.eventzero.occurrence.jdbc.AbstractDao.getConnection(AbstractDao.java:169)
[corlog-core-64e317f6de56715c87e74d9a225d7c20.jar:v3.6.6_29]
at com.eventzero.summary.dao.SummaryDAO.query(SummaryDAO.java:359)
[occurrence-summary-engine-efdda245967ddcae7aa0b6c8902c36c5.jar:v3.6.6_29]
at com.eventzero.summary.query.Query.getEvents(Query.java:60)
[occurrence-summary-engine-efdda245967ddcae7aa0b6c8902c36c5.jar:v3.6.6_29]
at com.eventzero.summary.Rule.query(Rule.java:394)
[occurrence-summary-engine-efdda245967ddcae7aa0b6c8902c36c5.jar:v3.6.6_29]
at com.eventzero.summary.RuleManager.query(RuleManager.java:170)
[occurrence-summary-engine-efdda245967ddcae7aa0b6c8902c36c5.jar:v3.6.6_29]
at com.eventzero.summary.SummaryEngine.query(SummaryEngine.java:306)
[occurrence-summary-engine-efdda245967ddcae7aa0b6c8902c36c5.jar:v3.6.6_29]
at
com.eventzero.occurrence.service.rule.RuleService$SummaryEngineQueryRuleController.start(RuleService.java:577)
[corlog-7b41983585314582e052f288c5a31a6f.jar:v3.6.6_29]
at
com.eventzero.occurrence.service.rule.RuleService$Rule$1.run(RuleService.java:851)
[corlog-7b41983585314582e052f288c5a31a6f.jar:v3.6.6_29]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[na:1.6.0_17]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[na:1.6.0_17]
at java.lang.Thread.run(Thread.java:619) [na:1.6.0_17]
Caused by: java.sql.SQLException: Java exception: ':
java.lang.NullPointerException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
[derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
[derby-10.8.1.2.jar:na]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
[derby-10.8.1.2.jar:na]
at java.sql.DriverManager.getConnection(DriverManager.java:582)
[na:1.6.0_17]
at java.sql.DriverManager.getConnection(DriverManager.java:185)
[na:1.6.0_17]
at
com.eventzero.util.jdbc.ConnectionPool.createConnection(ConnectionPool.java:201)
[common-e7817d5958e473be2275283ab647b8ca.jar:v3.6.6_29]
... 12 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Java exception: ':
java.lang.NullPointerException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
[derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) [derby-10.8.1.2.jar:na]
... 27 common frames omitted
Caused by: java.lang.NullPointerException: null
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)
[derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndexMinion(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndex(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.locateSchemaRow(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.initDefaultSchemaDescriptor(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.initialize(Unknown
Source) [derby-10.8.1.2.jar:na]
at org.apache.derby.impl.db.BasicDatabase.setupConnection(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.startTransaction(Unknown
Source) [derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.EmbedConnection.checkUserIsNotARole(Unknown Source)
[derby-10.8.1.2.jar:na]
at
org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown Source)
[derby-10.8.1.2.jar:na]
... 21 common frames omitted
> java.sql.SQLException: The exception 'java.lang.NullPointerException' was
> thrown while evaluating an expression.
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3746
> URL: https://issues.apache.org/jira/browse/DERBY-3746
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.3.1.4
> Environment: SUSE LINUX 10, Embedded Derby
> Reporter: vibhuti gupta
> Labels: derby_triage10_5_2, derby_triage10_9
> Attachments: derby.log, derby_mailsdb_XSDG9.log, mailjdbc_patch.diff,
> mailjdbc_patch022410.diff, mailsdb_derby.log
>
>
> Hi
>
> Following exception occurs while running our application with embedded derby
> database. The application uses multithreading. This exception occurs while
> insert query is executed. The insert query is run using JDBC:
>
> insert into sign (sign, month, day, offset, digest) values (?,?,?,?,?).
>
> The table for which insert query is fired is:
>
> create table sign(ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY
> KEY, sign varchar(32), month char(6) not null, day char(2) not null, offset
> bigint not null, digest varchar(32) for bit data not null)
>
> There are multiple threads inserting data in database. I tried to search a
> lot on net but could not find any solution. We're using derby 10.3.1.4. Not
> sure about the root cause. It will be great if anybody provides some solution
> because it is creating lot of problems in our application.
>
> -------------------------------------------------------------------------------------------------------------
>
> Caused by: java.sql.SQLException: The exception
> 'java.lang.NullPointerException' was thrown while evaluating an expression.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
> at src.app.database.derby.Derby.insertData(Derby.java:132)
> ... 17 more
> Caused by: java.sql.SQLException: The exception
> 'java.lang.NullPointerException' was thrown while evaluating an expression.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 30 more
> Caused by: java.sql.SQLException: Java exception: ':
> java.lang.NullPointerException'.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> ... 27 more
> Caused by: java.lang.NullPointerException
> at
> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown
> Source)
> at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSetAutoincrementValue(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
> Source)
> at
> org.apache.derby.exe.acd89d8024x0119xf710x52e1x000002ea2ea00.e0(Unknown
> Source)
> at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown Source)
> at
> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
> Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> ... 23 more
> ----------------------------------------------------------------------------------
>
> Also please find the output of sysinfo:
>
> ------------------ Java Information ------------------
> Java Version: 1.6.0_01
> Java Vendor: Sun Microsystems Inc.
> Java home: C:\Java\jdk1.6.0_01\jre
> Java classpath: .\config;.\lib\activation.jar;.\lib\aperture-1.0.1-beta.jar;
> .\lib\bcmail-jdk14-132.jar;.\lib\bcprov-jdk14-132.jar;.\lib\castor-0.9.3.21-xml.jar;
> .\lib\checkstyle-all-4.2.jar;.\lib\cjkanalyzer.jar;.\lib\commons-beanutils.jar;
> .\lib\commons-collections-3.0.jar;.\lib\commons-dbcp-1.2.1.jar;
> .\lib\commons-digester.jar;.\lib\commons-fileupload.jar;.\lib\commons-lang-2.0.jar;
> .\lib\commons-logging.jar;.\lib\commons-net-1.4.1.jar;.\lib\commons-pool-1.2.jar;
> .\lib\commons-validator.jar;.\lib\app.jar;.\lib\app_13.jar;.\lib\appsync.jar;
> .\lib\derby.jar;.\lib\derbyclient.jar;.\lib\derbynet.jar;.\lib\derbytools.jar;
> .\lib\displaytag-1.0-rc1.jar;.\lib\FontBox-0.1.0-dev.jar;
> .\lib\jakarta-regexp-1.2.jar;.\lib\javaee.jar;.\lib\jcharset.jar;
> .\lib\jcifs-1.2.17.jar;.\lib\jcommon-0.9.6.jar;.\lib\jfreechart-0.9.21.jar;
> .\lib\jtnef.jar;.\lib\junit.jar;.\lib\ldap.jar;.\lib\log4j-1.2.8.jar;
> .\lib\lucene-core-2.2.0.jar;.\lib\lucene-highlighter.jar;.\lib\mail.jar;
> .\lib\mysql-connector-java-3.0.9-stable-bin.jar;
> .\lib\openrdf-rdf2go-2.0.0-beta6.jar;.\lib\openrdf-sesame-2.0-beta6-onejar.jar;
> .\lib\org.semweb4j.rdf2go.api_4.4.7.jar;
> .\lib\org.semweb4j.rdf2go.impl.base_4.4.6.jar;.\lib\pd4ml.jar;
> .\lib\PDFBox-0.7.3.jar;.\lib\poi-3.0.1-FINAL-20070705.jar;.\lib\quartz-1.5.2.jar;
> .\lib\slf4j-api-1.3.0.jar;.\lib\slf4j-simple-1.3.0.jar;.\lib\SNMP4J.jar;
> .\lib\ss_css2.jar;.\lib\struts.jar;.\lib\textmining_v1.jar;
> .\lib\tm-extractors-0.4.jar;.\lib\truezip-6.jar;.\lib\xerces-2_6_2.jar;
> .\lib\windows\FPLibrary.jar
> OS name: Windows XP
> OS architecture: x86
> OS version: 5.1
> Java user name: vibhuti
> Java user home: C:\Documents and Settings\vibhuti
> Java user dir: D:\projects\src\app\dist\app
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.6
> --------- Derby Information --------
> JRE - JDBC: Java SE 6 - JDBC 4.0
> [D:\projects\src\app\dist\app\lib\derby.jar] 10.3.1.4 - (561794)
> [D:\projects\src\app\dist\app\lib\derbytools.jar] 10.3.1.4 - (5617
> 94)
> [D:\projects\src\app\dist\app\lib\derbynet.jar] 10.3.1.4 - (561794
> )
> [D:\projects\src\app\dist\app\lib\derbyclient.jar] 10.3.1.4 - (561
> 794)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
