[Sequoia] Hibernate + Sequoia

[Manuel Ángel Rubio Jiménez]

Hi,

i've a doubt about this combination, i had worked with Java and Hibernate 
since six months, but when i've tried to include Sequoia between this 
components, i've this messages from Hibernate:

08-mar-2007 21:41:30 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Message of cause: read request 573 failed:
Backend atp - BackendWorkerThread for backend 'test' with RAIDb level:1 failed 
(Backend test is no more reachable.)

This happends when i launch three times my software, only to do three logins 
(about 20 queries) the system crash! I've two backend servers, and this 
servers show this messages:

atp(admin) > show backend localhost
+--------------------------+----------------------------+
| Backend Name             | localhost                  |
| Driver                   | com.mysql.jdbc.Driver      |
| URL                      | jdbc:mysql://localhost/atp |
| Active transactions      | 38                         |
| Pending Requests         | 0                          |
| Read Enabled             | false                      |
| Write Enabled            | false                      |
| Is Initialized           | false                      |
| Static Schema            | false                      |
| Connection Managers      | 1                          |
| Total Active Connections | 36                         |
| Persistent Connections   | 0                          |
| Total Requests           | 489                        |
| Total Transactions       | 209                        |
| Last known checkpoint    | <unknown>                  |
+--------------------------+----------------------------+

atp(admin) > show backend test
+--------------------------+-----------------------+
| Backend Name             | test                  |
| Driver                   | com.mysql.jdbc.Driver |
| URL                      | jdbc:mysql://test/atp |
| Active transactions      | 50                    |
| 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           | 573                   |
| Total Transactions       | 233                   |
| Last known checkpoint    | <unknown>             |
+--------------------------+-----------------------+

I've configurated my system as follow:

controller.xml

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 
@VERSION@//EN"  "http://sequoia.continuent.org/dtds/[EMAIL PROTECTED]@.dtd">
<SEQUOIA-CONTROLLER>
  <Controller>
    <JmxSettings/>
    <VirtualDatabaseAutoLoad configFile="atp-raidb1.xml" 
virtualDatabaseName="atp" autoEnableBackends="true"/>
    <Report/>
  </Controller>
</SEQUOIA-CONTROLLER>

atp-raidb1.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 
@VERSION@//EN" "http://sequoia.continuent.org/dtds/[EMAIL PROTECTED]@.dtd">

<SEQUOIA>

  <VirtualDatabase name="atp">

    <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"/>
      <Backuper backuperName="MySQL" 
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper" />
    </Backup>

    <AuthenticationManager>
      <AdminUser username="admin" password=""/>
      <VirtualUser vLogin="user" vPassword=""/>
    </AuthenticationManager>

    <DatabaseBackend name="localhost" driver="com.mysql.jdbc.Driver"
      url="jdbc:mysql://localhost/atp"
      connectionTestStatement="select 1">
      <ConnectionManager vLogin="user" rLogin="root" rPassword="">
        <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
          maxPoolSize="50" idleTimeout="10" waitTimeout="5"/>
      </ConnectionManager>
    </DatabaseBackend>

    <DatabaseBackend name="test" driver="com.mysql.jdbc.Driver"
      url="jdbc:mysql://test/atp"
      connectionTestStatement="select 1">
      <ConnectionManager vLogin="user" rLogin="root" rPassword="">
        <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
          maxPoolSize="50" idleTimeout="10" waitTimeout="5"/>
      </ConnectionManager>
    </DatabaseBackend>

    <DatabaseSchema />

    <RequestManager>
      <RequestScheduler>
         <RAIDb-1Scheduler level="passThrough"/>
      </RequestScheduler>

      <RequestCache>
         <MetadataCache/>
         <ParsingCache/>
      </RequestCache>

      <LoadBalancer>
         <RAIDb-1>
            <WaitForCompletion policy="all" />
            <RAIDb-1-RoundRobin />
         </RAIDb-1>
      </LoadBalancer>

      <EmbeddedRecoveryLog />

     </RequestManager>
  </VirtualDatabase>

</SEQUOIA>

I think it's possible that 50 connections couldn't be enough, but i'm afraid 
about this situation, because my test load is under real load still. Any 
idea?

Thanks.

-- 
Manuel A. Rubio "Bombadil"
Usuario de GNU/Linux #323628 acorde a http://counter.li.org/
GPG ID 1C84979D ftp://bosqueviejo.net/pub/bombadil.asc
Técnico en Admin. Sistemas Informáticos

_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia