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
