[Sequoia] Error when RecoveryLog is enabled in VirtualDatabase configuration

Fri, 13 Apr 2007 06:16:44 -0700 


Hi all,
I'm configuring Sequoia-2.10.6 following the guide, but when execute ./controller.sh appear this message: 

14:18:09,385 INFO  controller.core.Controller Sequoia  controller (2.10.6)

14:18:09,495 INFO  controller.core.Controller Loading configuration 
file: 
/home/barrioso/apps/sequoia-2.10.6-bin/config/controller/controller.xml

14:18:09,624 INFO  controller.core.Controller JMX is enabled

14:18:09,660 INFO  controller.core.Controller Starting JMX server on 
host: 129.183.101.73
14:18:10,100 INFO  backend.DatabaseBackend.localhost Adding connection 
manager for virtual user "user"
14:18:10,111 INFO  backend.DatabaseBackend.localhost2 Adding connection 
manager for virtual user "user"
14:18:11,804 INFO  sequoia.controller.recoverylog Creating recovery log 
table: RECOVERY
14:18:11,824 ERROR controller.xml.DatabasesParser Failed to check JDBC 
Recovery log tables.
*java.lang.RuntimeException: Unable to initialize the database: 
java.sql.SQLException: Unable to create table RECOVERY (ORA-00906: 
parenthèse de gauche absente

)*

       at 
org.continuent.sequoia.controller.recoverylog.RecoveryLog.checkRecoveryLogTables(RecoveryLog.java:2933)
       at 
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:1047)

       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.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.DatabasesParser.readXML(DatabasesParser.java:287)
       at 
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
       at 
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:222)
       at 
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:552)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:446)
       at 
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:645)
       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:277)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:353)
       at 
org.continuent.sequoia.controller.core.Controller.main(Controller.java:742)
14:18:11,847 WARN  controller.core.Controller Loading of virtual 
databases configuration file failed (because of Failed to check JDBC 
Recovery log tables.).

org.xml.sax.SAXException: Failed to check JDBC Recovery log tables.

       at 
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:1054)

       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.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.DatabasesParser.readXML(DatabasesParser.java:287)
       at 
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
       at 
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:222)
       at 
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:552)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:446)
       at 
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:645)
       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:277)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:353)
       at 
org.continuent.sequoia.controller.core.Controller.main(Controller.java:742)
14:18:11,901 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 Failed to check 
JDBC Recovery log tables.).
org.continuent.sequoia.common.exceptions.ControllerException: Loading of 
virtual databases configuration file failed (because of Failed to check 
JDBC Recovery log tables.).
       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:229)
       at 
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:552)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:446)
       at 
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:645)
       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:277)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:353)
       at 
org.continuent.sequoia.controller.core.Controller.main(Controller.java:742)
14:18:11,903 ERROR controller.core.Controller Could not load config 
file: 
/home/barrioso/apps/sequoia-2.10.6-bin/config/virtualdatabase/jonas.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 Failed to check 
JDBC Recovery log tables.)..
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 Failed to check 
JDBC Recovery log tables.).
       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:558)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:446)
       at 
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:645)
       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:277)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:327)
       at 
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:353)
       at 
org.continuent.sequoia.controller.core.Controller.main(Controller.java:742)
14:18:11,913 INFO  controller.core.Controller Waiting for connections on 
0.0.0.0:25322
14:18:12,002 INFO  controller.core.Controller Controller started on 
2007.04.13 15 at 02:18:12 PM CEST
14:18:12,002 INFO  controller.core.Controller Controller 
129.183.101.73:25322 ready, listening to requests ...


My virtualdatabase file is this:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.6//EN" 
"http://sequoia.continuent.org/dtds/sequoia-2.10.6.dtd";>


<SEQUOIA>

 <VirtualDatabase name="myDB">

   <AuthenticationManager>
     <Admin>
          <User username="admin" password=""/>
     </Admin>
     <VirtualUsers>
       <VirtualLogin vLogin="user" vPassword=""/>
     </VirtualUsers>
   </AuthenticationManager>

   <DatabaseBackend name="localhost" driver="oracle.jdbc.OracleDriver"
     url="jdbc:oracle:thin:@-----------:----:------"
     connectionTestStatement="select * from dual">
     <ConnectionManager vLogin="user" rLogin="----" rPassword="----">
       <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
         maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
     </ConnectionManager>
   </DatabaseBackend>

   <DatabaseBackend name="localhost2" driver="oracle.jdbc.OracleDriver"
     url="jdbc:oracle:thin:@---------------------:----:----"
     connectionTestStatement="select * from dual">
     <ConnectionManager vLogin="user" rLogin="----" rPassword="----">
       <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="oracle.jdbc.OracleDriver" 
driverPath="/home/barrioso/apps/sequoia-2.10.6-bin/drivers/ojdbc14-oracle-10.2.jar" 
url="jdbc:oracle:thin:@----------------:----:---" login="-----" 
password="----">
       <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 don't understand the error, it's a problem of driver 
ojdbc14-oracle-10.2.jar ? In RecoveryLog tag is necessary write an user 
with permissions for create a table? The error is strange... "missing 
left parenthesis!", where is created this sql query?

If someone can I help me...

Thanks,
   Oscar Barrios


_______________________________________________
Sequoia mailing list
[EMAIL PROTECTED]
https://forge.continuent.org/mailman/listinfo/sequoia






















					Reply via email to