Hi Emmanuel, yes, i had a database schema with more 600 tables and more 400 views !!! But the time to load isn't a problem.
If you never seen this problem, I suggest you to wait and see my next step ! I'm sure to be back quickly ! Thank a lot Emmanuel. Christian -----Message d'origine----- De : Emmanuel Cecchet [mailto:[EMAIL PROTECTED] Envoyé : mardi 3 avril 2007 16:51 À : PICARD Christian Cc : [EMAIL PROTECTED]; Sequoia general mailing list Objet : Re: [Community] problem with recoverylog Hi Christian, > 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: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. > As the message says, the nodes are in an unknown state because the cluster was not initialized yet. Therefore no backend is enabled, so this is fast since nothing happens ! It should take more time once you enable the backends. > 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: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 > Here the backend enabling takes approximatively 1 minute per backend (you probably have a large schema or a lot of stored procedures defined). You should see the same time spend when enabling the backends with the recovery log enabled. 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
