Hi,
I trying Sequoia with Oracle, but I have some problems, I have raidb1 like
example.
First, when I started the controller I get the next log,
C:\Program Files\sequoia-2.10.9-bin\demo>demo-test
******************************************************
******************************************************
** **
** Please press a key when hsqldb servers are ready **
** **
******************************************************
******************************************************
Starting Controller with Raidb1 Configuration (press a key when ready)
Presione una tecla para continuar . . . 22:05:30,540 INFO
controller.core.Contr
oller Sequoia controller (2.10.9)
22:05:30,602 INFO controller.core.Controller Loading configuration file:
..\con
fig\controller\controller-test.xml
22:05:30,696 INFO controller.core.Controller JMX is enabled
22:05:30,728 INFO controller.core.Controller Starting JMX server on host:
10.10
0.2.159
22:05:31,103 INFO backup.backupers.OctopusBackuper OctopusBackuper backup
compr
ession is set to true
22:05:31,103 INFO controller.backup.BackupManager Registering backuper
Octopus
to handle format Octopus v3.4.1 database neutral dump compressed
22:05:31,134 INFO DatabaseBackend.myDataBase.localhost1 Adding connection
manag
er for virtual user "user"
22:05:31,134 INFO DatabaseBackend.myDataBase.localhost2 Adding connection
manag
er for virtual user "user"
22:05:32,713 INFO controller.RequestManager.myDataBase Request manager will
par
se requests with the following granularity: TABLE
22:05:32,713 INFO controller.core.Controller Adding VirtualDatabase
myDataBase
22:05:32,728 INFO controller.core.Controller Waiting for connections on
0.0.0.0
:25322
22:05:32,744 INFO controller.core.Controller Controller started on
2007.08.22 3
4 at 10:05:32 PM GMT
22:05:32,744 INFO controller.core.Controller Controller 10.100.2.159:25322read
y, listening to requests ...
I think everything is right.
After using the console I active the backends, the screen of the console is
the next
C:\Program Files\sequoia-2.10.9-bin\bin>console
Launching the Sequoia controller console
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v2.10.9) successfully loaded.
localhost:1090 > admin myDataBase
Virtual database Administrator Login > admin
Virtual database Administrator Password >
Ready to administrate virtual database myDataBase
myDataBase(admin) > expert on
myDataBase(admin) > enable localhost1
Enabling backend localhost1 from its last known checkpoint
Cannot enable backend localhost1 from a known state. Resynchronize this
backend
by restoring a dump.
myDataBase(admin) > force enable localhost1
Enabling backend localhost1 with no checkpoint
myDataBase(admin) > enable localhost1
Enabling backend localhost1 from its last known checkpoint
Cannot enable backend localhost1 from a known state. Resynchronize this
backend
by restoring a dump.
myDataBase(admin) > force enable localhost1
Enabling backend localhost1 with no checkpoint
Backend localhost1 is already enabled
myDataBase(admin) > force enable localhost2
Enabling backend localhost2 with no checkpoint
myDataBase(admin) >
The problem is because in the controller log, appears some warnings
23:25:35,963 INFO DatabaseBackend.myDataBase.localhost1 Detected backend
as: Or
acle
23:25:35,979 WARN DatabaseBackend.myDataBase.localhost1
Statement.setCursorName
not supported.
23:25:35,979 WARN DatabaseBackend.myDataBase.localhost1
Statement.getGeneratedK
eys not supported.
23:25:40,023 INFO controller.RequestManager.myDataBase Setting new virtual
data
base schema.
23:25:40,085 INFO controller.RequestManager.myDataBase Database backend
localho
st1 is now enabled
23:25:56,595 INFO DatabaseBackend.myDataBase.localhost2 Detected backend
as: Or
acle
23:25:56,611 WARN DatabaseBackend.myDataBase.localhost2
Statement.setCursorName
not supported.
23:25:56,611 WARN DatabaseBackend.myDataBase.localhost2
Statement.getGeneratedK
eys not supported.
23:26:00,485 INFO controller.RequestManager.myDataBase Virtual database
schema
merged with new schema.
23:26:00,532 INFO controller.RequestManager.myDataBase Database backend
localho
st2 is now enabled
After this, I try to access with Squirrel client and when I start my
connection y receive the next message on the log
23:31:52,492 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDataBaseError
while calling databaseMetaDataGetSuperTables
java.sql.SQLException: Funci¾n no soportada
at oracle.jdbc.driver.DatabaseError.throwSqlException(
DatabaseError.java
:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(
DatabaseError.java
:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(
DatabaseError.java
:227)
at
oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(
DatabaseError.java:537)
at oracle.jdbc.OracleDatabaseMetaData.getSuperTables
(OracleDatabaseMetaD
ata.java:3896)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseDyna
micMetaData.doGetSuperTables(VirtualDatabaseDynamicMetaData.java:1533)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseDyna
micMetaData.getSuperTables(VirtualDatabaseDynamicMetaData.java:1498)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork
erThread.databaseMetaDataGetSuperTables(VirtualDatabaseWorkerThread.java
:1473)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork
erThread.run(VirtualDatabaseWorkerThread.java:565)
After this I can view the tables, do queries in backend localhost1, but in
localhost2 I receive simmilar message when I try to view the tables with
Squirrel I receive the next message
23:36:09,228 WARN controller.RequestManager.myDataBase Failed to execute
reques
t select * from bitacora_mensaje_iso because of (Request select * from
bitacora_
mensaje_iso failed on backend localhost1 (ORA-00942: table or view does not
exis
t
))
23:36:09,228 WARN controller.virtualdatabase.myDataBase Request '1' failed
(Req
uest select * from bitacora_mensaje_iso failed on backend localhost1
(ORA-00942:
table or view does not exist
))
23:36:09,228 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDataBaseError
during command execution (Request select * from bitacora_mensaje_iso failed
on b
ackend localhost1 (ORA-00942: table or view does not exist
))
My files for configuration are:
demo-test.bat
@echo off
title Sequoia RAIDb-1 demo
echo ******************************************************
echo ******************************************************
echo ** **
echo ** Please press a key when hsqldb servers are ready **
echo ** **
echo ******************************************************
echo ******************************************************
SET SEQUOIA_HOME="C:\Program Files\sequoia-2.10.9-bin"
SET JAVA_HOME="C:\Archivos de programa\Java\jdk1.5.0_08"
SET CLASSPATH_XTRA="C:/Program Files/sequoia-2.10.9-bin/drivers/ojdbc14.jar"
:begin
cd "%SEQUOIA_HOME%\bin"
echo Starting Controller with Raidb1 Configuration (press a key when ready)
start /B controller.bat -f ..\config\controller\controller-test.xml
pause
echo Initializing controller
start console.bat -p 1090 -f ..\demo\init_controller_test.script
:end
controller-test.xml
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
2.10.9//EN" "
http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<Report/>
<JmxSettings>
<RmiJmxAdaptor/>
</JmxSettings>
<VirtualDatabase configFile="oracle-test.xml"
virtualDatabaseName="myDataBase" autoEnableBackends="false"
checkpointName="Initial_empty_recovery_log"/>
</Controller>
</SEQUOIA-CONTROLLER>
oracle-test.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN" "
http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDataBase">
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select" caseSensitive="false"
applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="Octopus"
className="
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="user"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="localhost1" driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@10.100.144.4:1521:dwbuild"
connectionTestStatement="select * from dual">
<DatabaseSchema dynamicPrecision="table" gatherSystemTables="false"/>
<ConnectionManager vLogin="user" rLogin="liqval_user3"
rPassword="liqval_user3">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="localhost2" driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@10.100.144.4:1521:dwbuild"
connectionTestStatement="select * from dual">
<DatabaseSchema dynamicPrecision="table" gatherSystemTables="false"/>
<ConnectionManager vLogin="user" rLogin="liqval_user"
rPassword="liqval_user">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<!-- <ResultCache granularity="table"/> -->
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@10.100.144.6:1521:PINDEVAL" login="ADMINWLES"
password="ADMINWLES">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="NUMBER NOT
NULL"
vloginColumnType="VARCHAR(255) NOT NULL"
sqlColumnType="VARCHAR(255) NOT NULL"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255)"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(255) NOT
NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(255) NOT NULL"
dumpFormatColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
tablesColumnType="VARCHAR(255) NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Someone have some idea how to make this
Thanks in advance
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
