Dear Sequoia Team, I am experiencing problems with recovering backend after database failure. Version of Sequoia: 3.0 beta 2 Database: MS SQL Server 2005 Express Edition OS: Windows XP SP2 JVM version: 1.6
As I can see from mail-archive similar issue was in version 2.8.2: http://www.arcknowledge.com/gmane.comp.db.sequoia.general/2006-06/msg00153.html Scenario: 1. execute controller.bat 2. create a dump. 4. stop MS SQL Server service 5. use console.bat to execute SQL-statements 6. start MS SQL Server service 8. start the sequoia admin console 9. restore the dump 10. enable backend (doesn't works, admin console hangs). Here are the messages from controller's console: Creating Backup: 2007-01-24 13:48:02,765 INFO controller.RequestManager.VirtualDatabase All activity is suspended for VirtualDatabase 2007-01-24 13:48:02,781 INFO controller.virtualdatabase.VirtualDatabaseCheckpoint backup dump2-mainPCController-20070124134802765+0200 was stored 2007-01-24 13:48:02,781 INFO controller.virtualdatabase.VirtualDatabaseDisabling backend mainPCDB, waiting for current transaction to complete on this backend 2007-01-24 13:48:02,796 INFO controller.RequestManager.VirtualDatabaseSetting new virtual database schema. 2007-01-24 13:48:02,796 INFO sequoia.controller.connection 5 connections freed on "jdbc:jtds:sqlserver://localhost/VirtualDatabase" 2007-01-24 13:48:02,906 INFO controller.virtualdatabase.VirtualDatabaseBackend mainPCDB is now disabled 2007-01-24 13:48:02,906 INFO controller.virtualdatabase.VirtualDatabaseBackend mainPCDB disabled on controller Member(address=/192.168.0.2:1258, uid=192.168.0.2:1258) 2007-01-24 13:48:02,921 INFO controller.RequestManager.VirtualDatabaseBackend mainPCDB is now disabled 2007-01-24 13:48:02,937 INFO controller.RequestManager.VirtualDatabaseStarting backup of backend mainPCDB 2007-01-24 13:48:03,265 INFO controller.RequestManager.VirtualDatabaseBackup has completed. 2007-01-24 13:48:03,359 INFO controller.recoverylog.RecoverThread Starting recovery 2007-01-24 13:48:03,515 INFO controller.RequestManager.VirtualDatabase All activity is suspended for VirtualDatabase 2007-01-24 13:48:03,531 INFO controller.recoverylog.RecoverThread Recovery completed 2007-01-24 13:48:03,625 INFO controller.recoverylog.RecoverThread Database backend mainPCDB is now enabled Executing SQL statements from console: 2007-01-24 13:54:24,312 ERROR sequoia.controller.recoverylog Failed to log create table Table_1 (ID bigint,NAME varchar(50), EMAIL varchar(50),TEXT1 varchar(50),TEXT2 varchar(50),TEXT3 varchar(50),TEXT4 varchar(50),TEXT5 varchar(50)) java.sql.SQLException: I/O Error: Connection reset by peer: socket write error at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049) at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1175) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL( ConnectionJDBC2.java:646) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate( JtdsPreparedStatement.java:420) ......... Restoring dump: 2007-01-24 13:55:43,062 INFO controller.RequestManager.VirtualDatabaseRecovery of backend mainPCDB done. Enabling backend: 2007-01-24 13:56:12,937 ERROR backend.DatabaseBackend.mainPCDB Unable to get a connection to gather database schema. 2007-01-24 13:56:12,937 WARN backend.DatabaseBackend.mainPCDB Unable to gather schema from database meta data: java.sql.SQLException: Failed to get information about database schema: java.sql.SQLException: Unable to get a connection to gather database schema. 2007-01-24 13:56:12,937 ERROR backend.DatabaseBackend.mainPCDB Unable to get a connection to gather database schema. 2007-01-24 13:56:12,937 WARN backend.DatabaseBackend.mainPCDB Unable to gather schema from database meta data: java.sql.SQLException: Failed to get information about database schema: java.sql.SQLException: Unable to get a connection to gather database schema. 2007-01-24 13:56:12,937 WARN controller.virtualdatabase.VirtualDatabaseBackend mainPCDB has no defined schema. -- Best regards, Denis Garyachy. -- Best regards, Denis Garyachy.
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
