Hi Everyone,
this is the point, where the startup a this long pause:
10:18:44,081 INFO controller.core.Controller Sequoia controller (2.10.6)
10:18:44,237 INFO controller.core.Controller Loading configuration
file: ../con
fig/controller/loga_controller.xml
10:18:44,343 INFO controller.core.Controller JMX is enabled
10:18:44,366 INFO controller.core.Controller Starting JMX server on
host: 130.1
49.238.181
10:18:44,850 INFO backend.DatabaseBackend.logaNode Adding connection
manager fo
r virtual user "apuser"
10:18:44,898 INFO controller.RequestManager.loga_vDB Request manager
will parse
requests with the following granularity: NO_PARSING
10:18:44,906 WARN controller.virtualdatabase.loga_vDB No recovery log
has been
configured, enabling backend without checkpoint.
10:18:45,451 INFO backend.DatabaseBackend.logaNode Detected backend as:
Oracle
10:18:45,465 WARN backend.DatabaseBackend.logaNode
Statement.setCursorName not
supported.
10:18:45,465 WARN backend.DatabaseBackend.logaNode
Statement.getGeneratedKeys n
ot supported.
Hope this helps to understand our problem.
Greetings
Sebastian Zickau
Sebastian Zickau wrote:
Hi Everyone,
as I mentioned earlier, we use Sequoia with an Oracle-DB as a
single-db-backend.
Our controller needs over 30min to start. What could be the reason? Is
this normal?
We have a second DB (Informix) where it starts much faster, same config.
Please see xml-Config below.
Please can You answer if you know anything, we want to use our
configuration in real life.
Thanx in Advance.
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.3//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.3.dtd";>
<SEQUOIA>
<VirtualDatabase name="loga_vDB" maxNbOfConnections="100"
poolThreads="true" minNbOfThreads="0" maxNbOfThreads="100"
maxThreadIdleTime="60" sqlDumpLength="40">
<AuthenticationManager>
<Admin>
<User username="aduser" password="xyz"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="apuser" vPassword="xyz"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="logaNode"
driver="oracle.jdbc.driver.OracleDriver" url="xyz"
connectionTestStatement="SELECT * FROM dual">
<DatabaseSchema dynamicPrecision="all"
gatherSystemTables="false"/>
<ConnectionManager vLogin="apuser" rLogin="xyz" rPassword="xyz">
<SimpleConnectionManager/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false" beginTimeout="60"
commitTimeout="60" rollbackTimeout="60">
<RequestScheduler>
<SingleDBScheduler level="pessimisticTransaction"/>
</RequestScheduler>
<RequestCache>
<MetadataCache maxNbOfMetadata="1000" maxNbOfField="100"/>
<ParsingCache backgroundParsing="false" maxNbOfEntries="500"/>
</RequestCache>
<LoadBalancer transactionIsolation="databaseDefault">
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Greetings
Sebastian Zickau
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
