Hi Emmanuel, thanks for your help.
find the dump of the console when i try to use RecoveryLog (It has started in 3 seconds) : C:\APPLI\Sequoia\SEQUOI~1.6-B\bin>controller.bat -f ..\config\controller\controller-eurica1.xml 10:53:09,842 INFO controller.core.Controller Sequoia controller (2.10.6) 10:53:09,999 INFO controller.core.Controller Loading configuration file: ..\config\controller\controller-euri ca1.xml 10:53:10,217 INFO controller.core.Controller JMX is enabled 10:53:10,296 INFO controller.core.Controller Starting JMX server on host: 127.0.0.1 10:53:11,264 INFO backup.backupers.OctopusBackuper OctopusBackuper backup compression is set to true 10:53:11,264 INFO controller.backup.BackupManager Registering backuper Octopus to handle format Octopus v3.4. 1 database neutral dump compressed 10:53:11,342 INFO backend.DatabaseBackend.sequoia_pgsql_1 Adding connection manager for virtual user "user" 10:53:11,358 INFO backend.DatabaseBackend.sequoia_pgsql_2 Adding connection manager for virtual user "user" 10:53:12,389 INFO controller.RequestManager.sequoia_pgsql Request manager will parse requests with the follow ing granularity: TABLE 10:53:12,421 INFO controller.virtualdatabase.sequoia_pgsql Unknown last state for backend sequoia_pgsql_1. Le aving node in disabled state. 10:53:12,436 INFO controller.virtualdatabase.sequoia_pgsql Unknown last state for backend sequoia_pgsql_2. Le aving node in disabled state. 10:53:12,436 INFO controller.core.Controller Adding VirtualDatabase sequoia_pgsql 10:53:12,452 INFO controller.core.Controller Waiting for connections on 127.0.0.1:25322 10:53:12,452 INFO controller.core.Controller Controller started on 2007.04.03 14 at 10:53:12 AM CEST 10:53:12,467 INFO controller.core.Controller Controller 127.0.0.1:25322 ready, listening to requests ... and the same without the RecoveryLog section (it has started in 2 minutes): C:\APPLI\Sequoia\SEQUOI~1.6-B\bin>controller.bat -f ..\config\controller\controller-eurica1.xml 10:54:23,920 INFO controller.core.Controller Sequoia controller (2.10.6) 10:54:24,076 INFO controller.core.Controller Loading configuration file: ..\config\controller\controller-euri ca1.xml 10:54:24,310 INFO controller.core.Controller JMX is enabled 10:54:24,373 INFO controller.core.Controller Starting JMX server on host: 127.0.0.1 10:54:25,326 INFO backup.backupers.OctopusBackuper OctopusBackuper backup compression is set to true 10:54:25,326 INFO controller.backup.BackupManager Registering backuper Octopus to handle format Octopus v3.4. 1 database neutral dump compressed 10:54:25,388 INFO backend.DatabaseBackend.sequoia_pgsql_1 Adding connection manager for virtual user "user" 10:54:25,404 INFO backend.DatabaseBackend.sequoia_pgsql_2 Adding connection manager for virtual user "user" 10:54:25,701 INFO controller.RequestManager.sequoia_pgsql Request manager will parse requests with the follow ing granularity: TABLE 10:54:25,732 WARN controller.virtualdatabase.sequoia_pgsql No recovery log has been configured, enabling back end without checkpoint. 10:54:26,670 INFO backend.DatabaseBackend.sequoia_pgsql_1 Detected backend as: PostgreSQL 10:55:19,872 INFO controller.RequestManager.sequoia_pgsql Setting new virtual database schema. 10:55:19,872 INFO sequoia.controller.cache Setting new database schema. 10:55:20,200 INFO controller.RequestManager.sequoia_pgsql Database backend sequoia_pgsql_1 is now enabled 10:55:20,669 INFO backend.DatabaseBackend.sequoia_pgsql_2 Detected backend as: PostgreSQL 10:56:16,293 INFO controller.RequestManager.sequoia_pgsql Virtual database schema merged with new schema. 10:56:16,293 INFO sequoia.controller.cache Merging new database schema 10:56:17,434 INFO controller.RequestManager.sequoia_pgsql Database backend sequoia_pgsql_2 is now enabled 10:56:17,449 INFO controller.core.Controller Adding VirtualDatabase sequoia_pgsql 10:56:17,481 INFO controller.core.Controller Waiting for connections on 127.0.0.1:25322 10:56:17,481 INFO controller.core.Controller Controller started on 2007.04.03 14 at 10:56:17 AM CEST 10:56:17,481 INFO controller.core.Controller Controller 127.0.0.1:25322 ready, listening to requests ... This last work fine. I can connect to the virtual database since Squirrel. I don't receive any messages about the jdbc compliant. For the moment, isn't necessary. Now, i try to use the virtual database with my Jonas application. I continue to explore Sequoia. Thanks for your help. Christian -----Message d'origine----- De : Emmanuel Cecchet [mailto:[EMAIL PROTECTED] Envoyé : lundi 2 avril 2007 15:46 À : PICARD Christian Cc : [EMAIL PROTECTED]; Sequoia general mailing list Objet : Re: [Community] problem with recoverylog Hi Christian, > controller : 2.10.6 on windows 2000 pro > postgres : 8.2.3 on debian server > java : 1.5.0_07 > > i use 2 same databases (with different names) on the same postgres > server (a debian distribution). I have a controller with 1 > virtualdatabase déclared. In the virtualdatabase configuration file, I > had disabled the recoverylog section in the first time. This > configuration works on windows 2000. After, I enabled the recoverylog > section and i configured the database on a different server. But when > i launch the controller and i try to connect on the virtualdatabase > (with squirrel), i can't connect to the controller and i receive a > message that say the jdbc drivers is not compliant !!! You should get at least a warning in the log telling you which operation couldn't be performed on the driver. Main causes for a driver to be reported as non-compliant are: - impossible to get a JDBC connection: invalid driver class name or driver not found in classpath, invalid JDBC url, invalid username/password, database misconfiguration (user not created, connection not authorized from controller node IP address, ...), ... - invalid connection test statement: in your case you are using connectionTestStatement="select now();" and you should remove the trailing semicolon. Hope this helps, Emmanuel -- Emmanuel Cecchet Chief Scientific Officer, Continuent Blog: http://emanux.blogspot.com/ Open source: http://www.continuent.org Corporate: http://www.continuent.com Skype: emmanuel_cecchet Cell: +33 687 342 685 _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
