Hi, Controllers can not share backends. In your virtual database you have just 2 different backends (localhost1, localhost2) and you declare 4. You have to declare only local backend on each controller. vm1: localhost1 vm2: localhost2
Regards, Pierre -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de [EMAIL PROTECTED] Envoyé : 29 May 2008 21:19 À : [email protected] Objet : [Sequoia] Configuring backends for controllers Hello So now that my controllers seems to run, I would like to clarify some questions.. My scenario looks like: vm1: ip: 192.168.64.131 backend(s): localhost1 which points to 192.168.64.131 localhost2 which points to 192.168.64.132 vm2: ip: 192.168.64.132 backend(s): localhost2 which points to 192.168.64.132 localhost1 which points to 192.168.64.131 Starting controller on vm2, all is fine: [EMAIL PROTECTED] bin]# ./controller.sh 20:09:55,539 INFO controller.core.Controller Sequoia controller (2.10.10) 20:09:55,630 INFO controller.core.Controller Loading configuration file: /usr/lib/sequoia-2.10.10-bin/config/controller/controller.xml 20:09:55,701 INFO controller.core.Controller JMX is enabled 20:09:55,782 INFO controller.core.Controller Starting JMX server on host: 192.168.64.132 20:09:55,784 WARN controller.core.Controller Could not parse RMI Server Port 'null 20:09:56,165 INFO controller.backup.BackupManager Registering backuper PostgreSQL to handle format PostgreSQL Plain Text Dump 20:09:56,189 INFO DatabaseBackend.myDB.localhost2 Adding connection manager for virtual user "user" 20:09:56,207 INFO DatabaseBackend.myDB.localhost1 Adding connection manager for virtual user "user" 20:09:56,492 WARN sequoia.controller.recoverylog Backend table BACKEND does not match database table name case (backend) 20:09:56,493 WARN sequoia.controller.recoverylog Checkpoint table CHECKPOINT does not match database table name case (checkpoint) 20:09:56,493 WARN sequoia.controller.recoverylog Dump table BACKEND does not match database table name case (dump) 20:09:56,494 WARN sequoia.controller.recoverylog Log table RECOVERY does not match database table name case (recovery) 20:09:56,560 INFO controller.RequestManager.myDB Request manager will parse requests with the following granularity: TABLE 20:09:56,576 INFO controller.virtualdatabase.myDB Recovery log size: 0 20:09:56,577 INFO controller.virtualdatabase.myDB Using Hedera properties file: /hedera_jgroups.properties 20:09:57,047 WARN jgroups.protocols.UDP bind_to_all_interfaces has been deprecated; use receive_on_all_interfaces instead ------------------------------------------------------- GMS: address is 192.168.64.132:1033 ------------------------------------------------------- 20:09:59,575 INFO controller.virtualdatabase.myDB Waiting 2000 ms for group membership to be stable 20:10:01,667 INFO controller.virtualdatabase.myDB Group myDB connected to Member(address=/192.168.64.132:1033, uid=myDB) 20:10:01,669 INFO controller.virtualdatabase.myDB First controller in group myDB 20:10:01,745 INFO sequoia.controller.recoverylog Checking recovery log consistency 20:10:01,814 WARN controller.virtualdatabase.myDB Cannot enable backend localhost2 from a known state. Resynchronize this backend by restoring a dump. 20:10:01,816 WARN controller.virtualdatabase.myDB Cannot enable backend localhost1 from a known state. Resynchronize this backend by restoring a dump. 20:10:01,816 INFO controller.core.Controller Adding VirtualDatabase myDB 20:10:01,822 INFO controller.core.Controller Loading backend interceptor classes 20:10:01,823 INFO controller.core.Controller Loading frontend interceptor classes 20:10:01,823 INFO controller.core.Controller Interceptors initialized 20:10:01,829 INFO controller.core.Controller Waiting for connections on 0.0.0.0:25322 20:10:01,832 INFO controller.core.Controller Controller started on 2008.05.29 22 at 08:10:01 PM SAST 20:10:01,833 INFO controller.core.Controller Controller 192.168.64.132:25322 ready, listening to requests ... 20:10:01,836 INFO controller.core.PingResponder Ping responder started #----------------------------------------------------------------------------------------------------------------------- #----------------------------------------------------------------------------------------------------------------------- And I can see all the backends on vm2: [EMAIL PROTECTED] sequoia-2.10.10-bin]# bin/console.sh Launching the Sequoia controller console Initializing Controller module... Initializing VirtualDatabase Administration module... Initializing SQL Console module... Sequoia driver (Sequoia core v2.10.10) successfully loaded. May 29, 2008 8:10:43 PM java.util.prefs.FileSystemPreferences$7 run WARNING: Prefs file removed in background /root/.java/.userPrefs/_!'8!cg"n!#4!}w"v!'4!d!"p!'4!d@"l!'4!d!!u!(:!~@"x!(`!bw"p!'%!.g"j!'8!bg"z!'8!b!"l!#4!d!"l!(g!d!!u!%:!bw"u!(:!bw"s!'`=/prefs.xml localhost:1090 > admin myDB Virtual database Administrator Login > admin Virtual database Administrator Password > Ready to administrate virtual database myDB myDB(admin) > show backends localhost2 localhost1 #----------------------------------------------------------------------------------------------------------------------- #----------------------------------------------------------------------------------------------------------------------- However, when starting the controller on vm1, all hell breaks lose: [EMAIL PROTECTED] bin]# ./controller.sh 15:25:42,515 INFO controller.core.Controller Sequoia controller (2.10.10) 15:25:42,837 INFO controller.core.Controller Loading configuration file: /usr/lib/sequoia-2.10.10-bin/config/controller/controller.xml 15:25:43,081 INFO controller.core.Controller JMX is enabled 15:25:43,171 INFO controller.core.Controller Starting JMX server on host: 192.168.64.131 15:25:43,174 WARN controller.core.Controller Could not parse RMI Server Port 'null 15:25:44,027 INFO controller.backup.BackupManager Registering backuper PostgreSQL to handle format PostgreSQL Plain Text Dump 15:25:44,105 INFO DatabaseBackend.myDB.localhost1 Adding connection manager for virtual user "user" 15:25:44,136 INFO DatabaseBackend.myDB.localhost2 Adding connection manager for virtual user "user" 15:25:44,772 WARN sequoia.controller.recoverylog Backend table BACKEND does not match database table name case (backend) 15:25:44,775 WARN sequoia.controller.recoverylog Checkpoint table CHECKPOINT does not match database table name case (checkpoint) 15:25:44,777 WARN sequoia.controller.recoverylog Dump table BACKEND does not match database table name case (dump) 15:25:44,778 WARN sequoia.controller.recoverylog Log table RECOVERY does not match database table name case (recovery) 15:25:44,965 INFO controller.RequestManager.myDB Request manager will parse requests with the following granularity: TABLE 15:25:45,019 INFO controller.virtualdatabase.myDB Recovery log size: 0 15:25:45,023 INFO controller.virtualdatabase.myDB Using Hedera properties file: /hedera_jgroups.properties 15:25:46,231 WARN jgroups.protocols.UDP bind_to_all_interfaces has been deprecated; use receive_on_all_interfaces instead ------------------------------------------------------- GMS: address is 192.168.64.131:1045 ------------------------------------------------------- 15:25:49,463 INFO controller.virtualdatabase.myDB Waiting 2000 ms for group membership to be stable 15:25:49,570 WARN sequoia.controller.recoverylog Checkpoint Member(address=/192.168.64.132:1033, uid=myDB) joined group myDB-192.168.64.131:25322-20080529152549479+0200 was stored 15:25:51,466 INFO controller.virtualdatabase.myDB Group myDB connected to Member(address=/192.168.64.131:1045, uid=myDB) 15:25:51,467 INFO controller.virtualdatabase.myDB Group now contains 2 controllers. 15:25:51,467 INFO controller.virtualdatabase.myDB Checking virtual database configuration with remote controllers. 15:25:51,832 ERROR controller.virtualdatabase.myDB Virtual database configuration is not compatible with other controller settings. 15:25:52,225 ERROR controller.jmx.MBeanServer Register mbean of type sequoia:VirtualDataBase=myDB,type=VirtualDataBase.RequestManager.ParsingCache failed with error sequoia:type=VirtualDataBase.RequestManager.ParsingCache,VirtualDataBase=myDB ({2}) 15:25:52,235 ERROR controller.xml.DatabasesParser The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.)) java.lang.Exception: Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.joinGroup(DistributedVirtualDatabase.java:794) at org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:728) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:295) at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:344) at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:227) at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458) at org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649) at org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275) at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325) at org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351) at org.continuent.sequoia.controller.core.Controller.main(Controller.java:751) Caused by: org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings. at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Throwable.java:196) at java.lang.Exception.<init>(Exception.java:41) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.joinGroup(DistributedVirtualDatabase.java:734) ... 29 more 15:25:52,249 WARN controller.core.Controller Loading of virtual databases configuration file failed (because of The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.))). org.xml.sax.SAXException: The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.)) at org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:761) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:295) at org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:344) at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:227) at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458) at org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649) at org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275) at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325) at org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351) at org.continuent.sequoia.controller.core.Controller.main(Controller.java:751) 15:25:52,254 ERROR controller.core.Controller Failed to send file to Sequoia controller: org.continuent.sequoia.common.exceptions.ControllerException: Loading of virtual databases configuration file failed (because of The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.))). org.continuent.sequoia.common.exceptions.ControllerException: Loading of virtual databases configuration file failed (because of The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.))). at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Throwable.java:196) at java.lang.Exception.<init>(Exception.java:41) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51) at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:234) at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458) at org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649) at org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275) at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325) at org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351) at org.continuent.sequoia.controller.core.Controller.main(Controller.java:751) 15:25:52,259 ERROR controller.core.Controller Could not load config file: /usr/lib/sequoia-2.10.10-bin/config/virtualdatabase/mydb1-distribution-1.xml. Error is: Failed to send file to Sequoia controller: org.continuent.sequoia.common.exceptions.ControllerException: Loading of virtual databases configuration file failed (because of The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.))).. org.continuent.sequoia.common.exceptions.ControllerException: Failed to send file to Sequoia controller: org.continuent.sequoia.common.exceptions.ControllerException: Loading of virtual databases configuration file failed (because of The virtual database myDB could not be added to the controller (because of Error while joining group myDB (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.))). at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Throwable.java:196) at java.lang.Exception.<init>(Exception.java:41) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51) at org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:567) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458) at org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649) at org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.content(Parser2.java:1779) at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177) at org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206) at org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275) at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325) at org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351) at org.continuent.sequoia.controller.core.Controller.main(Controller.java:751) 15:25:52,286 INFO controller.core.Controller Loading backend interceptor classes 15:25:52,288 INFO controller.core.Controller Loading frontend interceptor classes 15:25:52,292 INFO controller.core.Controller Interceptors initialized 15:25:52,315 INFO controller.core.Controller Waiting for connections on 192.168.64.131:25322 15:25:52,327 INFO controller.core.Controller Controller started on 2008.05.29 22 at 03:25:52 PM SAST 15:25:52,330 INFO controller.core.Controller Controller 192.168.64.131:25322 ready, listening to requests ... 15:25:52,574 INFO controller.core.PingResponder Ping responder started #----------------------------------------------------------------------------------------------------------------------- #----------------------------------------------------------------------------------------------------------------------- vm1: config/virtualdatabases/db.xml: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";> <SEQUOIA> <VirtualDatabase name="myDB"> <Distribution> <MessageTimeouts/> </Distribution> <Backup> <Backuper backuperName="PostgreSQL" className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper" options="zip=true"/> </Backup> <AuthenticationManager> <Admin> <User username="admin" password="admin"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword="user"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="localhost1" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.131:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <DatabaseBackend name="localhost2" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.132:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <RecoveryLog driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.131:5432/reclog" login="user" password="user"> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL" vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" extraStatementDefinition=",PRIMARY KEY (log_id)"/> <CheckpointTable tableName="CHECKPOINT" checkpointNameColumnType="VARCHAR NOT NULL"/> <BackendTable tableName="BACKEND" databaseNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL"/> <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" dumpDateColumnType="TIMESTAMP" dumpPathColumnType="VARCHAR NOT NULL" dumpFormatColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" tablesColumnType="VARCHAR NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> #----------------------------------------------------------------------------------------------------------------------- #----------------------------------------------------------------------------------------------------------------------- vm2: config/virtualdatabases/db.xml: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";> <SEQUOIA> <VirtualDatabase name="myDB"> <Distribution> <MessageTimeouts/> </Distribution> <Backup> <Backuper backuperName="PostgreSQL" className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper" options="zip=true"/> </Backup> <AuthenticationManager> <Admin> <User username="admin" password="admin"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword="user"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="localhost2" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.132:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <DatabaseBackend name="localhost1" driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.131:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <RecoveryLog driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.64.132:5432/reclog" login="user" password="user"> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL" vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" extraStatementDefinition=",PRIMARY KEY (log_id)"/> <CheckpointTable tableName="CHECKPOINT" checkpointNameColumnType="VARCHAR NOT NULL"/> <BackendTable tableName="BACKEND" databaseNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL"/> <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" dumpDateColumnType="TIMESTAMP" dumpPathColumnType="VARCHAR NOT NULL" dumpFormatColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" tablesColumnType="VARCHAR NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> #----------------------------------------------------------------------------------------------------------------------- #----------------------------------------------------------------------------------------------------------------------- I must be configuring the backends wrong in my configs. Any ideas ? Regards Willie ------------------------------------------- South Africas premier free email service - www.webmail.co.za ------------------------------------------------------------------ For super low premiums, click here http://www.webmail.co.za/dd.pwm _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. The information in this e-mail is confidential. The contents may not be disclosed or used by anyone other then the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, please notify Airbus immediately and delete this e-mail. Airbus cannot accept any responsibility for the accuracy or completeness of this e-mail as it has been sent over public networks. If you have any concerns over the content of this message or its Accuracy or Integrity, please contact Airbus immediately. All outgoing e-mails from Airbus are checked using regularly updated virus scanning software but you should take whatever measures you deem to be appropriate to ensure that this message and any attachments are virus free. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
