Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Workspace » KWS 1.0.1 build 1752: backup and update problem
  •  
ThorstenV

Messages: 20
Karma: 2
Send a private message to this user


Hi,

we have KWS 1.0.1 build 1752 (..with a lot of content!), System Windows 2003 Server, 32 Bit.

It is not possible to backup with KWS, also updates no more working!?

Our Server log:
[10/Mar/2012 16:07:48] {com.kerio.workspace} INFO: Backup started manually
[10/Mar/2012 16:07:48] {com.kerio.workspace} INFO: Backup task (COPY) started
[10/Mar/2012 16:07:48] {org.hibernate.util.JDBCExceptionReporter} WARN: SQL Error: 45000, SQLState: XSDBB
[10/Mar/2012 16:07:48] {org.hibernate.util.JDBCExceptionReporter} ERROR: Unknown page format at page Page(4,Container(0, 1232)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................



00007fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................

[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] Another error has occurred [ java.sql.SQLNonTransientConnectionException: No current connection. ] which will not be reported to listeners!
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack (Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProx yConnection.java:855)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAu toCommit(JDBCTransaction.java:213)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:192)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:364)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 16 more
[10/Mar/2012 16:07:48] {org.hibernate.transaction.JDBCTransaction} ERROR: JDBC rollback failed
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack (Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProx yConnection.java:855)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAu toCommit(JDBCTransaction.java:213)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:192)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:364)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 16 more
[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] Another error has occurred [ java.sql.SQLNonTransientConnectionException: No current connection. ] which will not be reported to listeners!
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.getWarnings(Unkno wn Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewP roxyConnection.java:907)
at org.hibernate.util.JDBCExceptionReporter.handleAndClearWarni ngs(JDBCExceptionReporter.java:63)
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings (JDBCExceptionReporter.java:49)
at org.hibernate.jdbc.ConnectionManager.closeConnection(Connect ionManager.java:472)
at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(Conne ctionManager.java:429)
at org.hibernate.jdbc.ConnectionManager.afterTransaction(Connec tionManager.java:316)
at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JD BCContext.java:269)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:204)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:364)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 20 more
[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[10/Mar/2012 16:07:48] {com.mchange.v2.c3p0.impl.NewPooledConnection} WARN: [c3p0] Another error has occurred [ java.sql.SQLNonTransientConnectionException: No current connection. ] which will not be reported to listeners!
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.clearWarnings(Unk nown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.clearWarnings(Ne wProxyConnection.java:933)
at org.hibernate.util.JDBCExceptionReporter.handleAndClearWarni ngs(JDBCExceptionReporter.java:71)
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings (JDBCExceptionReporter.java:49)
at org.hibernate.jdbc.ConnectionManager.closeConnection(Connect ionManager.java:472)
at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(Conne ctionManager.java:429)
at org.hibernate.jdbc.ConnectionManager.afterTransaction(Connec tionManager.java:316)
at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JD BCContext.java:269)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:204)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:364)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 20 more
[10/Mar/2012 16:07:48] {com.kerio.workspace} ERROR: Backup database transaction rollback failed
org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:200)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:364)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack (Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProx yConnection.java:855)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAu toCommit(JDBCTransaction.java:213)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTrans action.java:192)
... 6 more
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 16 more
[10/Mar/2012 16:07:48] {com.kerio.workspace} ERROR: Backup task (COPY) failed:
org.hibernate.exception.GenericJDBCException: error executing work
at org.hibernate.exception.SQLStateConverter.handledNonSpecific Exception(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateCo nverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExce ptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExce ptionHelper.java:52)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.hibernate.context.ThreadLocalSessionContext$TransactionP rotectionWrapper.invoke(ThreadLocalSessionContext.java:344)
at $Proxy12.doWork(Unknown Source)
at com.kerio.workspace.backup.BackupService.backupDB(BackupServ ice.java:344)
at com.kerio.workspace.backup.BackupService.doBackup(BackupServ ice.java:196)
at com.kerio.workspace.backup.BackupService.access$200(BackupSe rvice.java:42)
at com.kerio.workspace.backup.BackupService$3.execute(BackupSer vice.java:290)
at it.sauronsoftware.cron4j.TaskExecutor$Runner.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Unknown page format at page Page(4,Container(0, 1232)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
....

00007fa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExc eption(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(U nknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(U nknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(U nknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeSta tement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement.executeSta tement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Un known Source)
at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(N ewProxyCallableStatement.java:3044)
at com.kerio.workspace.backup.BackupService$4.execute(BackupSer vice.java:327)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)
... 12 more
Caused by: java.sql.SQLException: Unknown page format at page Page(4,Container(0, 1232)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................

00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................

at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 25 more
Caused by: ERROR XSDBB: Unknown page format at page Page(4,Container(0, 1232)), page dump follows: Hex dump:
00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................


00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00007ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................

at org.apache.derby.iapi.error.StandardException.newException(U nknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.changeInstan ceTo(Unknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity( Unknown Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Un known Source)
at org.apache.derby.impl.store.raw.data.FileContainer.getLatche dPage(Unknown Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.privBackup Container(Unknown Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknow n Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.backupCont ainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseContainerHandle.bac kupContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bac kupDataFiles(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.backup(U nknown Source)
at org.apache.derby.impl.db.BasicDatabase.backup(Unknown Source)
at org.apache.derby.catalog.SystemProcedures.SYSCS_BACKUP_DATAB ASE(Unknown Source)
at org.apache.derby.exe.ac645c405fx0135xfd20x0bd8xffffd7cced731 .g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke( Unknown Source)
at org.apache.derby.impl.sql.execute.CallStatementResultSet.ope n(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeSt mt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(U nknown Source)
... 19 more





Thank you for your advise and kind regards

thorsten

[Updated on: Sat, 10 March 2012 17:07]

  •  
Jarda Snajdr (Kerio)

Messages: 221
Karma: 12
Send a private message to this user
Hello Thorsten,

there errors suggest that your database files are corrupted. Does this happen only during backups? When not performing a backup, can you access Workspace and work with the content?

Jarda Snajdr
Workspace Team Leader
  •  
ThorstenV

Messages: 20
Karma: 2
Send a private message to this user
Hi Jarda,

yes, that's right! Only during backups and after update KWS no more working! KWS ist broken!!
  •  
Tomas Laubr (Kerio)

Messages: 34
Karma: 2
Send a private message to this user
Hello.
Do you remember what was the first version of Workspace you started with? You probably encounter a bug in Derby database library, which causes data corruption. But current library version should not be affected. So I would like to find out, which older versions of the library you were using. I can determine it from versions of your Workspace.
What do you mean by the "updates no more working"? You cannot perform KWS update with a new version? And does your KWS work or not at all?

Tomas
  •  
ThorstenV

Messages: 20
Karma: 2
Send a private message to this user
Hi Tomas,

>Do you remember what was the first version of Workspace you started with?<
I think it was KWS 1.0.0 or 1.0.1.

>You cannot perform KWS update with a new version?< Yes

>And does your KWS work or not at all?< Yes, KWS 1.0.1 build 1752 is still working, but it is impossible to make an update anymore!!

>You probably encounter a bug in Derby database library, which causes data corruption< is this possible to repair??

thorsten
  •  
Tomas Laubr (Kerio)

Messages: 34
Karma: 2
Send a private message to this user
> Yes, KWS 1.0.1 build 1752 is still working, but it is impossible to make an update anymore!!

So the server works, only backup doesn't work. And you cannot upgrade, yes?
And how does it look like, when you are trying to update? What error messages?

> is this possible to repair??

I don't know yet. It depends, where the error is. If it is in index or in data. If you want, send us the database (the "db" folder) zipped. (don't forget to stop workspace before copying the database)

T.
  •  
ThorstenV

Messages: 20
Karma: 2
Send a private message to this user
>If you want, send us the database (the "db" folder) zipped. (don't forget to stop workspace before copying the database)<

Yes, i like to send the database, if it is secure in your hands!?

I can send it to an mail adress, via download link. Can you give me your mail adress!!

thorsten
  •  
Tomas Laubr (Kerio)

Messages: 34
Karma: 2
Send a private message to this user
tlaubr<_at_>kerio.com
Previous Topic: Kerio Workspace Beta / Store
Next Topic: 1.0.1 build 1752 updating to 1.1
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Fri Nov 24 17:54:07 CET 2017

Total time taken to generate the page: 0.00419 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.