[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
h2 no disk space available but partition has space left?  XML
Forum Index -> General
Author Message
terracha

journeyman

Joined: 09/14/2012 09:12:06
Messages: 32
Offline

Hi,

Seeing the following error in the Terracotta server-log:

Caused by: org.h2.jdbc.JdbcSQLException: No disk space available [90100-67]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1349)
at org.h2.engine.User.checkRight(User.java:73)
at org.h2.command.dml.Insert.update(Insert.java:64)
at org.h2.command.CommandContainer.update(CommandContainer.java:68)
at org.h2.command.Command.executeUpdate(Command.java:171)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:127)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:116)
at com.tc.statistics.jdbc.JdbcHelper.executeUpdate(JdbcHelper.java:68)
at com.tc.statistics.store.h2.H2StatisticsStoreImpl.storeStatistic(H2StatisticsStoreImpl.java:301)

My partition where terracotta is running on has space left so I'm not sure I understand how that error is happening.

Any suggestions are appreciated!

Thanks,
Charles
terracha

journeyman

Joined: 09/14/2012 09:12:06
Messages: 32
Offline

I believe I know what the problem is now but I'm not sure how to stop it. It looks like the cluster statistics recorder is on but I can't turn it off in the recorder console as I get the error trying to go to that screen that there's no disk space available (which there is).
twu

journeyman

Joined: 10/18/2011 12:48:09
Messages: 21
Offline

There're a few different paths that the server uses, of which statistics is one. For example:

Code:
     <server host="%i" name="Server1">
       <dso-port>9510</dso-port>
       <jmx-port>9520</jmx-port>
       <data>/tmp/server-1/server-data</data>
       <logs>/tmp/server-1/server-logs</logs>
       <statistics>/tmp/server-1/server-statistics</statistics>
       <dso>
          <persistence>
             <mode>temporary-swap-only</mode>
             <offheap>
                <enabled>true</enabled>
                <maxDataSize>2g</maxDataSize>
             </offheap>
          </persistence>
       </dso>
     </server>
 


Is it possible that your statistics path is not set, causing the server to write to somewhere you don't expect?
terracha

journeyman

Joined: 09/14/2012 09:12:06
Messages: 32
Offline

I believe you are correct in that my statistics path is not set. This is set in the tc-config.xml is it?

I believe i know where statistics are written since i have 2 huge files, terracotta/config/statistics/statistics-store.data.db is 30 GBs and terracotta/config/statistics/statistics-store.index.db is 50 GBs. I'd like to limit those and even delete them if I can. I inherited this setup and I don't know enough about Terracotta to feel comfortable delete any files yet.

Thanks,
Charles
mmoore01

neo

Joined: 12/19/2011 15:22:05
Messages: 2
Location: USA
Offline

That is correct, the configuration snippet shown above is from tc-config.xml.
terracha

journeyman

Joined: 09/14/2012 09:12:06
Messages: 32
Offline

Actually for my problem above, might not have been the best way to go about this but I got it resolved by running tc-stats stopCapturing and tcstats reinitialize.

Thanks!

Charles
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.7 © JForum Team