'Re: [Hsqldb-user] [SPAM] NPE on Shutdown Compact with 2.0.0-rc8'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] [SPAM] NPE on Shutdown Compact with 2.0.0-rc8
From:       "Fred Toussi" <fredt () users ! sourceforge ! net>
Date:       2010-03-16 21:59:56
Message-ID: 1268776796.23849.1365179431 () webmail ! messagingengine ! com
[Download RAW message or body]

This is a multi-part message in MIME format.

--_----------=_1268776796238492
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"
Date: Tue, 16 Mar 2010 17:59:56 -0400
X-Mailer: MessagingEngine.com Webmail Interface

RC8 is quite old. Have you tried with the snapshot jar fromt he
support page?

Shutdown compact does reopen the database, but it should work
without a hitch.

Fred
On Tue, 16 Mar 2010 21:30 +0000, gould@inductiveautomation.com
wrote:

  Any idea what might cause this NPE that we're seeing in our
  logs when we issue a SHUTDOWN  COMPACT statement? It appears
  to be trying to re-open the database after it closes it, not
  sure why...

  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,432]: DataFileCache.close(true) : start
  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,432]: DataFileCache.close() : save data
  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,432]: DataFileCache.close() : flags
  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,432]: DataFileCache.close() : seek end
  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,448]: DataFileCache.close() : close
  INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ]
  [14:20:49,464]: Database closed
  INFO | jvm 1 | 2010/03/16 13:20:49 | FATAL [Logger ]
  [14:20:49,589]: could not reopen database
  INFO | jvm 1 | 2010/03/16 13:20:49 | org.hsqldb.HsqlException:
  java.lang.NullPointerException
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.error.Error.error(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.result.Result.newErrorResult(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.StatementSchema.execute(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.StatementSchemaDefinition.getResult(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.StatementSchemaDefinition.execute(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.persist.LobManager.createSchema(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.Database.reopen(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.Database.close(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.StatementCommand.getResult(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.StatementCommand.execute(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.Session.executeCompiledStatement(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.Session.executeDirectStatement(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.Session.execute(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.commons.dbcp.DelegatingStatement.execute(Delegating
  Statement.java:264)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.localdb.LocalDBManage
  rImpl.shutdown(LocalDBManagerImpl.java:425)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.localdb.LocalDBManage
  rImpl.shutdown(LocalDBManagerImpl.java:415)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.SRContext.shutdownInt
  ernal(SRContext.java:831)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.cluster.ClusterManage
  rImpl.shutdown(ClusterManagerImpl.java:450)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.SRContext.shutdown(SR
  Context.java:1089)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.SRContext.onDestroy(S
  RContext.java:1080)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.wicket.Application.internalDestroy(Application.java
  :956)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.wicket.protocol.http.WebApplication.internalDestroy
  (WebApplication.java:529)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.wicket.protocol.http.WicketFilter.destroy(WicketFil
  ter.java:179)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.bootstrap.SRFilter.de
  stroy(SRFilter.java:107)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.catalina.core.ApplicationFilterConfig.release(Appli
  cationFilterConfig.java:332)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.catalina.core.StandardContext.filterStop(StandardCo
  ntext.java:3744)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.catalina.core.StandardContext.stop(StandardContext.
  java:4513)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.apache.catalina.core.StandardContext.reload(StandardContex
  t.java:3093)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.bootstrap.ReloadServl
  et.reload(ReloadServlet.java:53)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  com.inductiveautomation.ignition.gateway.SRContext$9.run(SRCon
  text.java:990)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.Executors$RunnableAdapter.call(Unknown
  Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.FutureTask.run(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutu
  reTask.access$301(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutu
  reTask.run(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
  Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
  Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  java.lang.Thread.run(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | Caused by:
  java.lang.NullPointerException
  INFO | jvm 1 | 2010/03/16 13:20:49 | at
  org.hsqldb.persist.Logger.writeToLog(Unknown Source)
  INFO | jvm 1 | 2010/03/16 13:20:49 | ... 38 more

  Thanks,
  Carl Gould
  Inductive Automation
  1.800.266.7798
-------------------------------------------------------------------------
-----
Download Intel=AE Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--_----------=_1268776796238492
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset="ISO-8859-1"
Date: Tue, 16 Mar 2010 17:59:56 -0400
X-Mailer: MessagingEngine.com Webmail Interface

<!--/*SC*/DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" \
"http://www.w3.org/TR/html4/loose.dtd"/*EC*/--> <html><head><title></title><style \
type="text/css"><!--body{padding:1ex;margin:0px;font-family:sans-serif;font-size:small;}a[href]{color:-moz-hyperlinktext \
!important;text-decoration:-moz-anchor-decoration;}blockquote{margin:0;border-left:2px \
solid #144fae;padding-left:1em;}blockquote \
blockquote{border-color:#006312;}blockquote blockquote \
blockquote{border-color:#540000;}--></style></head><body><div style="font-family: \
Arial; font-size: medium;" dir="ltr"><div class="defangedMessage"> <div id="me00012">
<div>RC8 is quite old. Have you tried with the snapshot jar fromt he support \
page?</div> <div>&nbsp;</div>
<div>Shutdown compact does reopen the database, but it should work without a \
hitch.</div> <div>&nbsp;</div>
<div>Fred</div>
<div>On Tue, 16 Mar 2010 21:30 +0000, gould@inductiveautomation.com wrote:</div>
<blockquote type="cite" class="me00012QuoteMessage"><!--/*SC*/defang_html/*EC*/-->   \
<!--/*SC*/defang_head/*EC*/-->        <!--/*SC*//defang_head/*EC*/-->   \
<!--/*SC*/defang_body/*EC*/--> <p style="margin-top: 0pt;">Any idea what might cause \
this NPE that we're seeing in our logs when we        issue a SHUTDOWN&nbsp; COMPACT \
statement? It appears to be trying to re-open        the database after it closes it, \
not sure why...<br> &nbsp;</p>
INFO | jvm 1 | 2010/03/16 13:20:49 | INFO [Logger ] [14:20:49,432]:      \
DataFileCache.close(true) : start<br> INFO | jvm 1 | 2010/03/16 13:20:49 |      INFO \
[Logger ] [14:20:49,432]: DataFileCache.close() : save data<br> INFO |      jvm 1 | \
2010/03/16 13:20:49 | INFO [Logger ] [14:20:49,432]:      DataFileCache.close() : \
flags<br> INFO | jvm 1 | 2010/03/16 13:20:49 | INFO      [Logger ] [14:20:49,432]: \
DataFileCache.close() : seek end<br> INFO | jvm 1      | 2010/03/16 13:20:49 | INFO \
[Logger ] [14:20:49,448]:      DataFileCache.close() : close<br> INFO | jvm 1 | \
2010/03/16 13:20:49 | INFO      [Logger ] [14:20:49,464]: Database closed<br> INFO | \
jvm 1 | 2010/03/16      13:20:49 | FATAL [Logger ] [14:20:49,589]: could not reopen \
database<br> INFO      | jvm 1 | 2010/03/16 13:20:49 | org.hsqldb.HsqlException:      \
java.lang.NullPointerException<br> INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
org.hsqldb.error.Error.error(Unknown Source)<br> INFO | jvm 1 | 2010/03/16      \
13:20:49 | at org.hsqldb.result.Result.newErrorResult(Unknown Source)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | at      org.hsqldb.StatementSchema.execute(Unknown \
Source)<br> INFO | jvm 1 |      2010/03/16 13:20:49 | at      \
org.hsqldb.StatementSchemaDefinition.getResult(Unknown Source)<br> INFO |      jvm 1 \
| 2010/03/16 13:20:49 | at      org.hsqldb.StatementSchemaDefinition.execute(Unknown \
Source)<br> INFO | jvm      1 | 2010/03/16 13:20:49 | at      \
org.hsqldb.persist.LobManager.createSchema(Unknown Source)<br> INFO | jvm 1      | \
2010/03/16 13:20:49 | at org.hsqldb.Database.reopen(Unknown Source)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | at org.hsqldb.Database.close(Unknown      Source)<br> \
INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
org.hsqldb.StatementCommand.getResult(Unknown Source)<br> INFO | jvm 1 |      \
2010/03/16 13:20:49 | at org.hsqldb.StatementCommand.execute(Unknown      Source)<br> \
INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
org.hsqldb.Session.executeCompiledStatement(Unknown Source)<br> INFO | jvm      1 | \
2010/03/16 13:20:49 | at      org.hsqldb.Session.executeDirectStatement(Unknown \
Source)<br> INFO | jvm 1      | 2010/03/16 13:20:49 | at \
org.hsqldb.Session.execute(Unknown Source)<br> INFO      | jvm 1 | 2010/03/16 \
13:20:49 | at      org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)<br> INFO \
| jvm 1      | 2010/03/16 13:20:49 | at org.hsqldb.jdbc.JDBCStatement.execute(Unknown \
Source)<br> INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<br> \
INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.shutdown(LocalDBManagerImpl.java:425)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.shutdown(LocalDBManagerImpl.java:415)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.SRContext.shutdownInternal(SRContext.java:831)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.cluster.ClusterManagerImpl.shutdown(ClusterManagerImpl.java:450)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.SRContext.shutdown(SRContext.java:1089)<br> \
INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.SRContext.onDestroy(SRContext.java:1080)<br> \
INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.wicket.Application.internalDestroy(Application.java:956)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.wicket.protocol.http.WebApplication.internalDestroy(WebApplication.java:529)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.wicket.protocol.http.WicketFilter.destroy(WicketFilter.java:179)<br> INFO  \
| jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.bootstrap.SRFilter.destroy(SRFilter.java:107)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.catalina.core.ApplicationFilterConfig.release(ApplicationFilterConfig.java:332)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.catalina.core.StandardContext.filterStop(StandardContext.java:3744)<br> \
INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.catalina.core.StandardContext.stop(StandardContext.java:4513)<br> INFO     \
| jvm 1 | 2010/03/16 13:20:49 | at      \
org.apache.catalina.core.StandardContext.reload(StandardContext.java:3093)<br> INFO   \
| jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.bootstrap.ReloadServlet.reload(ReloadServlet.java:53)<br>
 INFO      | jvm 1 | 2010/03/16 13:20:49 | at      \
com.inductiveautomation.ignition.gateway.SRContext$9.run(SRContext.java:990)<br> INFO \
| jvm 1 | 2010/03/16 13:20:49 | at      \
java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | at      \
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)<br> INFO |      jvm 1 | \
2010/03/16 13:20:49 | at      java.util.concurrent.FutureTask.run(Unknown Source)<br> \
INFO | jvm 1 |      2010/03/16 13:20:49 | at      \
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown \
Source)<br> INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown      \
Source)<br> INFO | jvm 1 | 2010/03/16 13:20:49 | at      \
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)<br> INFO      \
| jvm 1 | 2010/03/16 13:20:49 | at      \
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | at java.lang.Thread.run(Unknown Source)<br> INFO      | \
jvm 1 | 2010/03/16 13:20:49 | Caused by: java.lang.NullPointerException<br> INFO      \
| jvm 1 | 2010/03/16 13:20:49 | at      org.hsqldb.persist.Logger.writeToLog(Unknown \
Source)<br> INFO | jvm 1 |      2010/03/16 13:20:49 | ... 38 more
<p style="margin-top: 0pt;"><br>
Thanks,<br>
Carl Gould<br>
Inductive Automation<br>
1.800.266.7798</p>
<!--/*SC*//defang_body/*EC*/--> <!--/*SC*//defang_html/*EC*/-->
<pre>
------------------------------------------------------------------------------
Download Intel&reg; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
</pre>
<pre>
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

</pre>
</blockquote></div>
</div></div></body></html>
--_----------=_1268776796238492--



------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic