db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew Cooper (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-3746) java.sql.SQLException: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
Date Thu, 23 Feb 2012 01:29:49 GMT

    [ 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

        

Mime
View raw message