[Sequoia] Re: Cannot enable backend from a known state (Robert Hodges)

Eivar Eder Armero Mon, 28 Jan 2008 10:29:19 -0800

On Mon, 28 Jan 2008, [EMAIL PROTECTED] wrote:

Hi Eivar,


Did you follow the procedure to initialize one of your backends and then
transfer its state to the other backend?  The messages in your log indicate
this has not been done.  Check the manuals for more information.

Thanks, Robert

Hi, tks for your answer, I'm tryin g to initilaize the first backent, anthen enable it, but some problem occurs because after that i put theinitialize command, I try the enable the backend but it never happen, ileave the consolo for approximately 60 minutes and never enables thebackend, and when i try shutdown de VDB the controller says that i have towait for the VDB complete operations.


this are the outpus of the console and the controller:

Virtual Database myDB has been successfully initialized from backendlocalhost1

myDB(admin) > enable localhost1
Enabling backend localhost1 from its last known checkpoint

2008-01-28 12:45:11,562 INFO controller.virtualdatabase.myDB Shuttingdown virtual database myDB in safe mode : waiting for all currenttransactions to complete2008-01-28 12:45:11,562 INFO controller.virtualdatabase.myDB Waiting forcommand'[EMAIL PROTECTED]'to complete


Tks for help me.


On 1/28/08 3:24 AM, "Eivar Armero Luna" <[EMAIL PROTECTED]> wrote:

Hello,
I'm Eivar armero, I'm running sequoia 2.10.9 as part of my degree project,
with a sigle controller and two Mysql backends, but when I start the
controller the following Warnings appear and the when i try to do a simple
INSERT operation in the databases other warning is throw, and the INSERT does
not commit,

Please can somebody help me???

I'm very grateful by any help. Tks.

this is the log of the sequoia.  full_cluster.log

2008-01-27 18:48:33,109 INFO  controller.core.Controller Sequoia controller
(2.10.9)
2008-01-27 18:48:33,187 INFO  controller.core.Controller Loading configuration
file: /C:/sequoia2/config/controller/controller.xml
2008-01-27 18:48:33,296 INFO  controller.core.Controller JMX is enabled
2008-01-27 18:48:33,328 INFO  controller.core.Controller Starting JMX server
on host: 127.0.0.1
2008-01-27 18:48:34,187 INFO  controller.backup.BackupManager Registering
backuper mysql to handle format MySQL raw dump
2008-01-27 18:48:34,234 INFO  DatabaseBackend.myDB.localhost1 Adding
connection manager for virtual user "user"
2008-01-27 18:48:34,250 INFO  DatabaseBackend.myDB.remote1 Adding connection
manager for virtual user "user"
2008-01-27 18:48:34,687 INFO  sequoia.controller.recoverylog Creating recovery
log table: RECOVERY
2008-01-27 18:48:34,734 INFO  sequoia.controller.recoverylog Creating
checkpoint table: CHECKPOINT
2008-01-27 18:48:34,781 INFO  sequoia.controller.recoverylog Creating backend
table: BACKEND
2008-01-27 18:48:34,796 INFO  sequoia.controller.recoverylog Creating dump
table: DUMP
2008-01-27 18:48:34,906 INFO  controller.RequestManager.myDB Request manager
will parse requests with the following granularity: TABLE
2008-01-27 18:48:34,906 INFO  controller.virtualdatabase.myDB Recovery log
size: 0
2008-01-27 18:48:34,921 INFO  controller.virtualdatabase.myDB Using Hedera
properties file: /hedera_jgroups.properties
2008-01-27 18:48:40,000 INFO  controller.virtualdatabase.myDB Group myDB
connected to Member(address=/192.168.79.1:1137, uid=myDB)
2008-01-27 18:48:40,000 INFO  controller.virtualdatabase.myDB First controller
in group myDB
2008-01-27 18:48:40,015 INFO  sequoia.controller.recoverylog Checking recovery
log consistency
2008-01-27 18:48:40,031 WARN  controller.virtualdatabase.myDB Cannot enable
backend localhost1 from a known state. Resynchronize this backend by restoring
a dump.
2008-01-27 18:48:40,031 WARN  controller.virtualdatabase.myDB Cannot enable
backend remote1 from a known state. Resynchronize this backend by restoring a
dump.
2008-01-27 18:48:40,031 INFO  controller.core.Controller Adding
VirtualDatabase myDB
2008-01-27 18:48:40,093 INFO  controller.core.Controller Waiting for
connections on 127.0.0.1:25322
2008-01-27 18:48:40,125 INFO  controller.core.Controller Controller started on
2008.01.27 04 at 06:48:40 PM COT
2008-01-27 18:48:40,125 INFO  controller.core.Controller Controller
127.0.0.1:25322 ready, listening to requests ...
2008-01-27 18:49:11,921 WARN  controller.RequestManager.myDB Request 'INSERT
INTO datos ( id, nombre) VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all
controllers
2008-01-27 18:49:11,921 WARN  controller.RequestManager.myDB Request INSERT
INTO datos ( id, nombre) VALUES (... failed (Request 'INSERT INTO datos ( id,
nombre) VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers)
2008-01-27 18:49:11,921 WARN  controller.virtualdatabase.myDB Request '1'
failed (Request 'INSERT INTO datos ( id, nombre) VALUES (?,
?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers)
2008-01-27 18:49:11,921 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB
Error during command execution (Request 'INSERT INTO datos ( id, nombre)
VALUES (?, ?)/<!%I|0|!%><!%S|eivar|!%>' failed on all controllers)




and this is my VDB config file.

<?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";
<http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd> >

<SEQUOIA>

  <VirtualDatabase name="myDB">

    <Distribution>
    <MessageTimeouts/>
    </Distribution>

    <Backup>
     <Backuper backuperName="mysql"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/>
    </Backup>

   <AuthenticationManager>
      <Admin>
          <User username="admin" password=""/>
      </Admin>
      <VirtualUsers>
        <VirtualLogin vLogin="user" vPassword="tesis"/>
      </VirtualUsers>
    </AuthenticationManager>


<DatabaseBackend name="localhost1" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/tesis"
driverPath="C:\sequoia2\drivers\mysql-connector-java-3.0.15-ga-bin.jar"
connectionTestStatement="select 1">
      <ConnectionManager vLogin="user" rLogin="user" rPassword="tesis">
        <VariablePoolConnectionManager initPoolSize="40"/>
      </ConnectionManager>
    </DatabaseBackend>



     <DatabaseBackend name="remote1" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/tesis2"
driverPath="C:\sequoia2\drivers\mysql-connector-java-3.0.15-ga-bin.jar"
connectionTestStatement="select 1">
      <ConnectionManager vLogin="user" rLogin="user2" rPassword="tesis2">
        <VariablePoolConnectionManager initPoolSize="40"/>
      </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="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/log" login="log" password="loger">
         <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT
NULL"
         vloginColumnType="TEXT NOT NULL"
         sqlColumnName="sql2"
         sqlColumnType="TEXT NOT NULL"
         sqlParamColumnType="TEXT NOT NULL"
         transactionIdColumnType="BIGINT NOT NULL"
         extraStatementDefinition=",PRIMARY KEY (log_id)"/>
       <CheckpointTable tableName="CHECKPOINT"
         checkpointNameColumnType="VARCHAR(32) NOT NULL"/>
       <BackendTable tableName="BACKEND"
         databaseNameColumnType="TEXT NOT NULL"
         backendNameColumnType="TEXT NOT NULL"
         checkpointNameColumnType="TEXT NOT NULL"/>
       <DumpTable tableName="DUMP" dumpNameColumnType="TEXT NOT NULL"
         dumpDateColumnType="TIMESTAMP"
         dumpPathColumnType="TEXT NOT NULL"
         dumpFormatColumnType="TEXT NOT NULL"
         checkpointNameColumnType="TEXT NOT NULL"
         backendNameColumnType="TEXT NOT NULL"
         tablesColumnType="TEXT NOT NULL"/>

      </RecoveryLog>
    </RequestManager>

  </VirtualDatabase>

</SEQUOIA>


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia


--
__________________
Eivar Armero Luna
Estudiante Ing. Eletronica y Telecomunicaciones.
Monitor Área Servidores y Servicios de Internet
Red de Datos.
Universidad del Cauca.

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

[Sequoia] Re: Cannot enable backend from a known state (Robert Hodges)

Reply via email to