Hi everyone,
I'm trying to install sequoia.
First step is to add sequoia layer in our architecture.
I started a controller on one Oracle database, but I can't enable backend :
I have message "Cannot enable backend adm30 from a known state. Resynchronize
this backend by restoring a dump." on controller start.
I try to enable backend in console :
myDB(admin) > initialize adm30
Virtual Database myDB has been successfully initialized from backend adm30
myDB(admin) > enable adm30
Enabling backend adm30 from its last known checkpoint
but never terminate...
Somebody knows why ?
Thanks in advance
Pierre
Here is more information, may help...
myDB(admin) > show backend adm30
+--------------------------+-----------------------------------+
| Backend Name | adm30 |
| Driver | oracle.jdbc.driver.OracleDriver |
| URL | jdbc:oracle:thin:@xxxx:1521:xxxx |
| Active transactions | 0 |
| Pending Requests | 0 |
| Read Enabled | false |
| Write Enabled | false |
| Is Initialized | false |
| Static Schema | false |
| Connection Managers | 1 |
| Total Active Connections | 50 |
| Persistent Connections | 0 |
| Total Requests | 0 |
| Total Transactions | 0 |
| Last known checkpoint | <unknown> |
+--------------------------+-----------------------------------+
#### Here i'm surprised by Total active connections
myDB(admin) > initialize adm30
Virtual Database myDB has been successfully initialized from backend adm30
myDB(admin) > show backend adm30
+--------------------------+-----------------------------------+
| Backend Name | adm30 |
| Driver | oracle.jdbc.driver.OracleDriver |
| URL | jdbc:oracle:thin:@xxxx:1521:xxxx |
| Active transactions | 0 |
| Pending Requests | 0 |
| Read Enabled | false |
| Write Enabled | false |
| Is Initialized | false |
| Static Schema | false |
| Connection Managers | 1 |
| Total Active Connections | 50 |
| Persistent Connections | 0 |
| Total Requests | 0 |
| Total Transactions | 0 |
| Last known checkpoint | Initial_empty_recovery_log |
+--------------------------+-----------------------------------+
#### Here i'm surprised by Is Initialized
myDB(admin) > enable adm30
Enabling backend adm30 from its last known checkpoint
and nothing append, controller display this after command enable adm30
10:37:26,046 INFO backend.DatabaseBackend.adm30 Detected backend as: Oracle
10:37:26,093 WARN backend.DatabaseBackend.adm30 Statement.setCursorName not
supported.
10:37:26,093 WARN backend.DatabaseBackend.adm30 Statement.getGeneratedKeys not
supported.
Here is a part of my virtualdatabase.xml :
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="adm30" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@XXXX:1521:XXXX"
connectionTestStatement="select * from dual">
<ConnectionManager vLogin="user" rLogin="XXXX" rPassword="XXXX">
<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>
....
</RequestManager>
The error may be caused by RequestSheduler/ Loadbalancer setting: Raidb1 and we
have a unique backend .... but SingleDb does not work.
This e-mail is intended only for the above addressee. It may contain privileged
information.
If you are not the addressee you must not copy, distribute, disclose or use any
of the information in it.
If you have received it in error please delete it and immediately notify the
sender.
Security Notice: all e-mail, sent to or from this address, may be accessed by
someone other than the recipient, for system management and security reasons.
This access is controlled under Regulation of security reasons.
This access is controlled under Regulation of Investigatory Powers Act 2000,
Lawful Business Practises.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
