I have changed a bit the recovery log configuration, and I get another error The db schema is already created in the db, but I changed the sql types as I saw in some posts
CREATE TABLE LogTable ( log_id BIGINT NOT NULL UNIQUE, vlogin TEXT NOT NULL, ssql TEXT NOT NULL, auto_conn_tran CHAR(1) NOT NULL, transaction_id BIGINT NOT NULL, request_id BIGINT, exec_time BIGINT, update_count INT, PRIMARY KEY (log_id) ); CREATE TABLE CheckpointTable ( name TEXT NOT NULL, log_id BIGINT ); CREATE TABLE BackendTable ( database_name TEXT NOT NULL, backend_name TEXT NOT NULL, backend_state INTEGER, checkpoint_name TEXT NOT NULL ); CREATE TABLE DumpTable ( dump_name TEXT NOT NULL, dump_date TIMESTAMP, dump_path TEXT NOT NULL, dump_format TEXT NOT NULL, checkpoint_name TEXT NOT NULL, backend_name TEXT NOT NULL, tables TEXT NOT NULL ); ################################################ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";> <SEQUOIA> <VirtualDatabase name="ITECBAN_DB"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <AuthenticationManager> <!-- Administrador para la consola de adminsitracion --> <Admin> <User username="admin" password="admin"/> </Admin> <!-- Usuario virtual que usa nuestra aplicacion cliente para acceder a la bbdd virtual--> <VirtualUsers> <VirtualLogin vLogin="itecban" vPassword="itecban"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="aolias.indra.es" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/ITECBAN_DB" connectionTestStatement="select 1"> <ConnectionManager vLogin="itecban" rLogin="itecban" rPassword="itecban"> <VariablePoolConnectionManager initPoolSize="40"/> </ConnectionManager> </DatabaseBackend> <RequestManager caseSensitiveParsing="false"> <RequestScheduler> <SingleDBScheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache/> <ParsingCache/> <ResultCache granularity="table"> <DefaultResultCacheRule> <RelaxedCaching timeout="10" keepIfNotDirty="false"/> </DefaultResultCacheRule> </ResultCache> </RequestCache> <LoadBalancer> <SingleDB/> </LoadBalancer> <RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/ITECBAN_DB" login="itecban" password="itecban"> <RecoveryLogTable sqlColumnName="ssql"/> <CheckpointTable/> <BackendTable/> <DumpTable/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> ############################################### 12:02:15,836 INFO controller.core.Controller Sequoia controller (2.10.2) 12:02:15,966 INFO controller.core.Controller Loading configuration file: /usr/sequoia-2.10.1/config/controller/controller.xml 12:02:16,167 INFO controller.core.Controller JMX is enabled 12:02:16,248 INFO controller.core.Controller Starting JMX server on host: 127.0.0.1 12:02:16,540 INFO controller.core.Controller Waiting for connections on 0.0.0.0:25322 12:02:16,567 INFO controller.core.Controller Controller started on 2006.10.31 44 at 12:02:16 PM CET 12:02:16,568 INFO controller.core.Controller Controller 127.0.0.1:25322 ready, listening to requests ... 12:02:22,177 INFO aolias.indra.es Adding connection manager for virtual user "itecban" 12:02:22,931 INFO sequoia.controller.recoverylog Creating recovery log table: logtable 12:02:22,985 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 logtable (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,ssql VARCHAR NOT NULL,ssql_param VARCHAR,auto_conn_tran CHAR(1) NOT NUL' at line 1) at org.continuent.sequoia.controller.recoverylog.RecoveryLog.checkRecoveryLogTables(RecoveryLog.java:2839) 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:223) at org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:245) at org.continuent.sequoia.controller.management.Controller.addVirtualDatabases(Controller.java:83) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414) at javax.management.StandardMBean.invoke(StandardMBean.java:323) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784) at org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318) at org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:135) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1408) at javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1245) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1348) at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:782) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294) at sun.rmi.transport.Transport$1.run(Transport.java:153) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:149) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707) at java.lang.Thread.run(Thread.java:595) _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
