On 2/2/07, Guillaume Smet <[EMAIL PROTECTED]> wrote:
João,
It's a configuration problem.
This query is done to get metadata information about the tables
(executed by isAutoIncrement()).
You should add the following configuration:
<RequestCache>
<MetadataCache/>
<ParsingCache/>
</RequestCache>
just after the RequestScheduler element in your virtualdatabase
configuration file. This will allow Sequoia to cache metadata and
parsing information. It will improve the general performances and will
prevent Sequoia from fetching metadata each time.
Hello Guillaume,
with the modifications on the configuration that you suggested the queries
searching for nextval% started to happen just once, on the first query
issued to the table, being cached for the next queries like expected. I
guess that this problem is then solved, thanks.
There is also another problem that was happening before and continues to
happen: Sequoia is sending the SELECT queries to both backends, not doing
the load balancing that it used to do on previous versions.
I've read the DTD and revised the virtual database configuration but
couldn't find any reason for the behavior that Sequoia is exhibiting. The
current virtual database configuration is attached. There are no relevant
messages from the controller or from the database log (just the SELECT
queries being repeated on each backend).
Thanks for your attention.
--
João Eduardo
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta3//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta3.dtd";>
<SEQUOIA>
<VirtualDatabase name="sentinela">
<Distribution hederaPropertiesFile="/hedera_appia_sentinela.properties">
<MessageTimeouts/>
</Distribution>
<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="postgresql"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<AdminUser username="admin" password="">
</AdminUser>
<VirtualUser vLogin="user" vPassword="">
</VirtualUser>
</AuthenticationManager>
<DatabaseBackend name="pga1" driver="org.postgresql.Driver"
url="jdbc:postgresql://10.15.117.11/sentinela"
connectionTestStatement="select 1 + 1">
<ConnectionManager vLogin="user" rLogin="sa_sentinela" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="pga2" driver="org.postgresql.Driver"
url="jdbc:postgresql://10.15.117.12/sentinela"
connectionTestStatement="select 1 + 1">
<ConnectionManager vLogin="user" rLogin="sa_sentinela" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema useStoredProcedures="true" gatherSystemTables="false" useViews="false" />
<Semantic>
<DefaultStoredProcedureSemantic>
<SemanticBehavior altersDatabaseSchema="false" />
</DefaultStoredProcedureSemantic>
<StoredProcedureSemantic procedureName="nextval" parameterCount="1">
<SemanticBehavior altersDatabaseSchema="false" />
</StoredProcedureSemantic>
<StoredProcedureSemantic procedureName="pg_catalog.nextval" parameterCount="1">
<SemanticBehavior altersDatabaseSchema="false" />
</StoredProcedureSemantic>
</Semantic>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<!-- to solve nextval gathering problem -->
<RequestCache>
<MetadataCache/>
<ParsingCache/>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<MacroHandling>
<RandomMacro macroName="rand()"/>
<DateMacro macroName="now()" dateFormat="timestamp"/>
<DateMacro macroName="current_date" dateFormat="date"/>
<DateMacro macroName="timeofday()" dateFormat="time"/>
<DateMacro macroName="current_timestamp" dateFormat="timestamp"/>
<DateMacro macroName="current_time" dateFormat="time"/>
</MacroHandling>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<EmbeddedRecoveryLog dataPath="/opt/continuent/sequoia-3.0-beta3-bin/recoverylog/sentinela/db"/>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
