Hi all,
We're using sequoia 2.10 RAIDB 0-1 architecture and get the following
error on starting the controller (Raidb-0)
15:39:30,179 INFO controller.core.Controller Sequoia controller (2.10)
15:39:30,354 INFO controller.core.Controller Loading configuration
file: ../config/controller/tubis_controller_0.xml
15:39:30,634 INFO controller.core.Controller JMX is enabled
15:39:30,701 INFO controller.core.Controller Starting JMX server on
host: 130.149.238.135
15:39:31,650 INFO backup.backupers.OctopusBackuper OctopusBackuper
backup compression is set to true
15:39:31,651 INFO controller.backup.BackupManager Registering backuper
Octopus to handle format Octopus v3.4.1 database neutral dump compressed
15:39:31,735 INFO backend.DatabaseBackend.testNode1 Adding connection
manager for virtual user "apuser"
15:39:31,901 INFO controller.RequestManager.tubis_vDBtest_0 Request
manager will parse requests with the following granularity: TABLE
15:39:31,911 WARN controller.virtualdatabase.tubis_vDBtest_0 No
recovery log has been configured, enabling backend without checkpoint.
15:39:32,472 INFO backend.DatabaseBackend.testNode1 Detected backend
as: Sequoia,PostgreSQL
15:39:37,102 ERROR controller.loadbalancer.RAIDb1 write request 0 failed:
Backend tubis_vDBtest_1 - BackendWorkerThread for backend 'testNode2'
with RAIDb level:1 failed (ERROR: syntax error at or near "values")
15:39:37,108 WARN controller.virtualdatabase.tubis_vDBtest_1 Request
'0' failed (write request 0 failed:
Backend tubis_vDBtest_1 - BackendWorkerThread for backend 'testNode2'
with RAIDb level:1 failed (ERROR: syntax error at or near "values")
)
15:39:37,110 WARN
virtualdatabase.VirtualDatabaseWorkerThread.tubis_vDBtest_1 Error during
command execution (write request 0 failed:
Backend tubis_vDBtest_1 - BackendWorkerThread for backend 'testNode2'
with RAIDb level:1 failed (ERROR: syntax error at or near "values")
)
15:39:37,148 ERROR backend.DatabaseBackend.testNode1 Test statement
values 1 is invalid (values 1)
15:39:37,156 WARN controller.virtualdatabase.tubis_vDBtest_0 Error
while initalizing database backend testNode1 (java.sql.SQLException:
Driver org.continuent.sequoia.driver.Driver is not Sequoia compliant)
java.sql.SQLException: Driver org.continuent.sequoia.driver.Driver is
not Sequoia compliant
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:608)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend(VirtualDatabase.java:2052)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend(VirtualDatabase.java:1864)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends(VirtualDatabase.java:1748)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackendsFromCheckpoint(VirtualDatabase.java:1768)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(Controller.java:296)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:699)
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:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:223)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:553)
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:128)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:178)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:207)
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)
15:39:37,165 WARN controller.core.Controller Failed to automatically
enable backends, manual resynchronization is probably needed
Is the connectionTestStatement="values 1" correct or do we replace the
value with select now()?
The other thing is that the sequoia driver does not seem to be
compatible. Why is this so, how and where do we get a 'compatible'
driver. We're currently using the postgresql-8.1-407.jdbc2.jar and the
sequoia-driver.jar but cannot get past the problem.
Please help
Reegards
Asif
--
---------------------
Cand. Dipl.-Inform. Asif Khan
PRZ - TU Berlin , MA 524, Sekr. MA 073
Strasse des 17. Juni 136
10623, Berlin, Germany
Tel: + 49 (0)30 314 79496 , Fax : + 49 30 314 21114
http://www.prz.tu-berlin.de/~asif
# He who has never learned to obey cannot be a good commander - Aristotle
---------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
