On 2/2/07, Guillaume Smet <[EMAIL PROTECTED]> wrote:
Can you reproduce it with Sequoia's SQL console? Use ./console.sh -q
to launch it. I'd like to be sure it's not a SquirrelSQL behaviour.
I don't have this behaviour at all here so I wonder if it's not used
by SquirrelSQL to format the data returned (queries fetching metadata
are executed after the real query).
Sure. I tested with Sequoia's SQL console with the same queries showed
on the previous execution log and the behavior was exactly the same. I
don't think it's a SquirrelSQL issue because the error also occurs
with the web applications we use on the tests. That was the main
reason that prompted me to ask the list about this abnormal behavior.
If you can reproduce it with the console, could you please provide
your controller/vdb configuration and the CREATE TABLE statements used
to create the two tables you are testing?
Sure. The table creation statements are the following:
CREATE TABLE auditoriacontrole (
codsistema integer NOT NULL,
codauditoria serial NOT NULL,
codusuario integer,
datahoraoperacao timestamp without time zone,
ativacao boolean
);
ALTER TABLE ONLY auditoriacontrole
ADD CONSTRAINT pk_auditoriacontrole PRIMARY KEY (codsistema, codauditoria);
ALTER TABLE ONLY auditoriacontrole
ADD CONSTRAINT fk_sistema_auditoriacontrole FOREIGN KEY
(codsistema) REFERENCES sistema(codsistema);
ALTER TABLE ONLY auditoriacontrole
ADD CONSTRAINT fk_usuario_auditoriacontrole FOREIGN KEY
(codusuario) REFERENCES usuario(codusuario);
CREATE TABLE enderecoservidor (
codsistema integer NOT NULL,
codservidor serial NOT NULL,
urlservidor character varying(255)
);
ALTER TABLE ONLY enderecoservidor
ADD CONSTRAINT pk_enderecoservidor PRIMARY KEY (codsistema, codservidor);
ALTER TABLE ONLY enderecoservidor
ADD CONSTRAINT fk_sistema_enderecoservidor FOREIGN KEY
(codsistema) REFERENCES sistema(codsistema);
The controller/vdb configurations are attached.
Thanks for your attention,
João Eduardo
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 3.0-beta3//EN" "http://sequoia.continuent.org/dtds/sequoia-controller-3.0-beta3.dtd";>
<SEQUOIA-CONTROLLER>
<Controller name="xxx.xxx.xxx.xxx">
<JmxSettings/>
<Report/>
</Controller>
</SEQUOIA-CONTROLLER>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 3.0-beta2//EN" "http://sequoia.continuent.org/dtds/sequoia-3.0-beta2.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="">
<!-- <AccessControl defaultPolicy="acsentinelatAll" /> -->
</AdminUser>
<VirtualUser vLogin="user" vPassword="">
<!-- <AccessControl defaultPolicy="acsentinelatAll" /> -->
</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" />
<!-- Pelo dtd, vem certo por padrão.
<Semantic>
<DefaultStoredProcedureSemantic>
<SemanticBehavior />
</DefaultStoredProcedureSemantic>
</Semantic>
-->
<Semantic>
<DefaultStoredProcedureSemantic>
<SemanticBehavior altersDatabaseSchema="false" />
</DefaultStoredProcedureSemantic>
<StoredProcedureSemantic procedureName="sa_dut.proximo_parametro" parameterCount="1">
<SemanticBehavior altersDatabaseSchema="false" />
</StoredProcedureSemantic>
<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>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<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>
<!--
<RecoveryLog driver="org.hsqldb.jdbcDriver" login="SA" password=""
url="jdbc:hsqldb:file:/opt/continuent/sequoia-3.0-alpha-bin/recovery/seq/recoveryLog;shutdown=true">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
-->
<!-- <EmbeddedRecoveryLog dataPath="../recoverylog/seqDB/seqdb/recoverylog"/> -->
<EmbeddedRecoveryLog dataPath="/opt/continuent/sequoia-3.0-beta3/recoverylog/sentinela/db"/>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE appia PUBLIC "-//DTDName//DTD//EN"
"appiaxml.dtd">
<!--
"http://appia.di.fc.ul.pt/appiaxml.dtd";>
NOTE:
This configuration file contains 6 different configurations, 6 Channel
templates and their respective Channel instanciations. These are the
combinations of 2 total order implementations (sequencer and token) with
different transports: TCP, UDP and UDP multicast.
The Appia TOP protocol that provides the interface between the Appia channel
and does not support several channels at the same time, so only one
configuration must be set. Initialization of several channels at the same
time was NOT tested.
To set one configuration, go to the "channel" tag and put initialized="yes".
The Gossip service is provided by a multicast IP in all configurations.
If your network does not support multicast, start an Appia gossip service
and change the channel configuration to use the IP where the gossip is running.
-->
<appia>
<template name="tcp_token">
<session name="TcpComplete" sharing="private">
<protocol>org.continuent.appia.protocols.tcpcomplete.TcpCompleteLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.token.TotalTokenLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<template name="tcp_sequencer">
<session name="TcpComplete" sharing="private">
<protocol>org.continuent.appia.protocols.tcpcomplete.TcpCompleteLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.sequencer.TotalSequencerLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<template name="udp_p2p_token">
<session name="UdpSimpleSession" sharing="private">
<protocol>org.continuent.appia.protocols.udpsimple.UdpSimpleLayer</protocol>
</session>
<session name="nakfifo" sharing="private">
<protocol>org.continuent.appia.protocols.nakfifo.NakFifoLayer</protocol>
</session>
<session name="frag" sharing="private">
<protocol>org.continuent.appia.protocols.frag.FragLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.token.TotalTokenLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<template name="udp_p2p_sequencer">
<session name="UdpSimpleSession" sharing="private">
<protocol>org.continuent.appia.protocols.udpsimple.UdpSimpleLayer</protocol>
</session>
<session name="nakfifo" sharing="private">
<protocol>org.continuent.appia.protocols.nakfifo.NakFifoLayer</protocol>
</session>
<session name="frag" sharing="private">
<protocol>org.continuent.appia.protocols.frag.FragLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.sequencer.TotalSequencerLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<template name="udp_multicast_token">
<session name="UdpSimpleSession" sharing="private">
<protocol>org.continuent.appia.protocols.udpsimple.UdpSimpleLayer</protocol>
</session>
<session name="nakfifo" sharing="private">
<protocol>org.continuent.appia.protocols.nakfifo.multicast.NakFifoMulticastLayer</protocol>
</session>
<session name="frag" sharing="private">
<protocol>org.continuent.appia.protocols.frag.FragLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.token.TotalTokenLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<template name="udp_multicast_sequencer">
<session name="UdpSimpleSession" sharing="private">
<protocol>org.continuent.appia.protocols.udpsimple.UdpSimpleLayer</protocol>
</session>
<session name="nakfifo" sharing="private">
<protocol>org.continuent.appia.protocols.nakfifo.multicast.NakFifoMulticastLayer</protocol>
</session>
<session name="frag" sharing="private">
<protocol>org.continuent.appia.protocols.frag.FragLayer</protocol>
</session>
<session name="gbl" sharing="private">
<protocol>org.continuent.appia.protocols.group.bottom.GroupBottomLayer</protocol>
</session>
<session name="gol" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.GossipOutLayer</protocol>
</session>
<session name="suspectl" sharing="private">
<protocol>org.continuent.appia.protocols.group.suspect.SuspectLayer</protocol>
</session>
<session name="intral" sharing="private">
<protocol>org.continuent.appia.protocols.group.intra.IntraLayer</protocol>
</session>
<session name="interl" sharing="private">
<protocol>org.continuent.appia.protocols.group.inter.InterLayer</protocol>
</session>
<session name="hl" sharing="private">
<protocol>org.continuent.appia.protocols.group.heal.HealLayer</protocol>
</session>
<session name="stablel" sharing="private">
<protocol>org.continuent.appia.protocols.group.stable.StableLayer</protocol>
</session>
<session name="ll" sharing="private">
<protocol>org.continuent.appia.protocols.group.leave.LeaveLayer</protocol>
</session>
<session name="vsl" sharing="private">
<protocol>org.continuent.appia.protocols.group.sync.VSyncLayer</protocol>
</session>
<session name="total" sharing="private">
<protocol>org.continuent.appia.protocols.total.sequencer.TotalSequencerLayer</protocol>
</session>
<session name="hederalayer" sharing="private">
<protocol>org.continuent.hedera.appia.HederaSupportLayer</protocol>
</session>
</template>
<channel name="TCP SEQ Channel" template="tcp_sequencer" initialized="yes">
<memorymanagement size="40000000" up_threshold="15000000" down_threshold="7000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.7</parameter>
</chsession>
</channel>
<channel name="TCP TOKEN Channel" template="tcp_token" initialized="no">
<memorymanagement size="250000000" up_threshold="200000000" down_threshold="100000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.5</parameter>
</chsession>
<chsession name="total">
<parameter name="num_messages_per_token">10</parameter>
</chsession>
</channel>
<channel name="UDP p2p SEQ Channel" template="udp_p2p_sequencer" initialized="no">
<memorymanagement size="40000000" up_threshold="15000000" down_threshold="7000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.5</parameter>
</chsession>
<chsession name="UdpSimpleSession">
<parameter name="max_udp_message_size">32000</parameter>
</chsession>
</channel>
<channel name="UDP p2p TOKEN Channel" template="udp_p2p_token" initialized="no">
<memorymanagement size="40000000" up_threshold="15000000" down_threshold="7000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.5</parameter>
</chsession>
<chsession name="total">
<parameter name="num_messages_per_token">10</parameter>
</chsession>
<chsession name="UdpSimpleSession">
<parameter name="max_udp_message_size">32000</parameter>
</chsession>
</channel>
<channel name="UDP multicast SEQ Channel" template="udp_multicast_sequencer" initialized="no">
<memorymanagement size="40000000" up_threshold="15000000" down_threshold="7000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.5</parameter>
<parameter name="multicast">224.2.2.5:11000</parameter>
</chsession>
<chsession name="UdpSimpleSession">
<parameter name="max_udp_message_size">32000</parameter>
</chsession>
</channel>
<channel name="UDP multicast TOKEN Channel" template="udp_multicast_token" initialized="no">
<memorymanagement size="40000000" up_threshold="15000000" down_threshold="7000000" />
<chsession name="hederalayer">
<parameter name="gossip_address">224.1.1.5</parameter>
<parameter name="multicast">224.2.2.5:11000</parameter>
</chsession>
<chsession name="total">
<parameter name="num_messages_per_token">10</parameter>
</chsession>
<chsession name="UdpSimpleSession">
<parameter name="max_udp_message_size">32000</parameter>
</chsession>
</channel>
</appia>
# Hedera properties file
# Using Appia
hedera.factory=org.continuent.hedera.factory.AppiaGroupCommunicationFactory
hedera.channel.appia.config=/appia-sentinela.xml
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
