It is currently Thu Jul 24, 2014 12:01 pm




Post new topic Reply to topic  [ 8 posts ] 
 Can't write to any tags! Project is Read/Write 
Author Message
Trooper
Trooper

Joined: Tue Sep 21, 2010 8:46 am
Posts: 14
Post Can't write to any tags! Project is Read/Write
Started having errors today, with all Tags not writing. The console is full of the following:

Time Logger Message 10:34:45 AM com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl Cannot create autobackup for internal database "settings".
java.sql.SQLException: java.lang.OutOfMemoryError
at org.hsqldb.jdbc.Util.sqlException(Util.java:392)
at org.hsqldb.jdbc.Util.sqlException(Util.java:227)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1830)
at org.hsqldb.jdbc.JDBCStatement.executeUpdate(JDBCStatement.java:207)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at com.inductiveautomation.ignition.gateway.localdb.hsql.HSQLDBManager$AutoBackupDaemon.run(HSQLDBManager.java:619)
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hsqldb.HsqlException: java.lang.OutOfMemoryError
at org.hsqldb.error.Error.error(Error.java:111)
at org.hsqldb.result.Result.newErrorResult(Result.java:1057)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:208)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1339)
at org.hsqldb.Session.executeDirectStatement(Session.java:1216)
at org.hsqldb.Session.execute(Session.java:1002)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1822)
... 13 more
Caused by: java.lang.OutOfMemoryError
at java.util.zip.Deflater.deflateBytes(Native Method)
at java.util.zip.Deflater.deflate(Unknown Source)
at java.util.zip.DeflaterOutputStream.deflate(Unknown Source)
at java.util.zip.DeflaterOutputStream.write(Unknown Source)
at java.util.zip.GZIPOutputStream.write(Unknown Source)
at org.hsqldb.lib.tar.TarFileOutputStream.write(TarFileOutputStream.java:199)
at org.hsqldb.lib.tar.TarFileOutputStream.writeBlock(TarFileOutputStream.java:225)
at org.hsqldb.lib.tar.TarGenerator$TarEntrySupplicant.write(TarGenerator.java:632)
at org.hsqldb.lib.tar.TarGenerator.write(TarGenerator.java:232)
at org.hsqldb.lib.tar.DbBackup.write(DbBackup.java:299)
at org.hsqldb.persist.Logger.backup(Logger.java:1884)
at org.hsqldb.StatementCommand.getResult(StatementCommand.java:279)
at org.hsqldb.StatementCommand.execute(StatementCommand.java:206)
... 17 more
(I) 10:34:44 AM hsqldb.db.HSQLDB2AF197DF72.ENGINE Initiating backup of instance 'settings' (I) 10:34:44 AM hsqldb.db.HSQLDB2AF197DF72.ENGINE dataFileCache commit start (I) 10:34:44 AM com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl Creating auto-backup of internal database "settings"... 10:32:44 AM com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl Cannot create autobackup for internal database "settings".

Any ideas?

_________________
Mike Thornton


Tue May 01, 2012 9:10 am
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1980
Location: Folsom, CA
Post Re: Can't write to any tags! Project is Read/Write
You're out of memory! Further investigation to figure out why will be necessary... Can you attach or email us your logs?

_________________
Kevin Herron
Software Developer
Inductive Automation


Tue May 01, 2012 10:09 am
Profile WWW
Trooper
Trooper

Joined: Tue Sep 21, 2010 8:46 am
Posts: 14
Post Re: Can't write to any tags! Project is Read/Write
Here is the export of the logs:


Attachments:
File comment: exported log file
logs.bin.gz [485.97 KiB]
Downloaded 43 times

_________________
Mike Thornton
Tue May 01, 2012 10:24 am
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1980
Location: Folsom, CA
Post Re: Can't write to any tags! Project is Read/Write
What version of Ignition are you running? The OPC-COM module may have had a memory leak that was just recently fixed. Upgrading to the latest would probably be a good idea.

Also, I didn't see that error you posted anywhere in the logs...

_________________
Kevin Herron
Software Developer
Inductive Automation


Tue May 01, 2012 10:31 am
Profile WWW
Trooper
Trooper

Joined: Tue Sep 21, 2010 8:46 am
Posts: 14
Post Re: Can't write to any tags! Project is Read/Write
Current Version: 7.3.3 (b570)

Strange thing about the log file ... attached is a new export and a screen shot of the logs.

Also including a screen shot of the task manager showing java using 1.8 Gs of memory!


Attachments:
log shot.JPG
log shot.JPG [ 207.26 KiB | Viewed 728 times ]
logs.bin.gz [481.54 KiB]
Downloaded 38 times
task shot.jpg
task shot.jpg [ 57.25 KiB | Viewed 730 times ]

_________________
Mike Thornton
Tue May 01, 2012 11:11 am
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1980
Location: Folsom, CA
Post Re: Can't write to any tags! Project is Read/Write
Well it's not that strange to be showing 1.8GB because you ran out of memory.

Upgrade to 7.3.7 and if the leak was on the COM module you should be all set.

_________________
Kevin Herron
Software Developer
Inductive Automation


Tue May 01, 2012 12:42 pm
Profile WWW
Trooper
Trooper

Joined: Tue Sep 21, 2010 8:46 am
Posts: 14
Post Re: Can't write to any tags! Project is Read/Write
Thanks Kevin, I see version 7.4.2 is the latest. Since we have Total Care upgrade protection, we will upgrade to that level.

_________________
Mike Thornton


Tue May 01, 2012 12:55 pm
Profile
Moderator
Moderator

Joined: Mon Oct 27, 2008 4:10 pm
Posts: 1980
Location: Folsom, CA
Post Re: Can't write to any tags! Project is Read/Write
mthornton wrote:
Thanks Kevin, I see version 7.4.2 is the latest. Since we have Total Care upgrade protection, we will upgrade to that level.


Ah, I didn't realize that. Yes, upgrading to 7.4.2 is a great idea :)

_________________
Kevin Herron
Software Developer
Inductive Automation


Tue May 01, 2012 1:03 pm
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: