Hi Stephane, Stephane GIRON wrote: > Thank you for your answer. > First, I think that you should add in your script after the "shutdown > virtualdatabase" is done a "shutdown" command for the controller, before > killing it.
OK. I improved that but error still happens. New stop procedure is as follows:
stop
=====
${SEQUOIA_HOME}/bin/console.sh -e -p $JMXPORT -f $stopscript -l
cat stopscript:
admin @DB_NAME@
@SEQ_ADMIN_USER@
@SEQ_ADMIN_PASS@
disable @VDB_BACKEND1@
quit
shutdown virtualdatabase @DB_NAME@ 2
@SEQ_ADMIN_USER@
@SEQ_ADMIN_PASS@
--> shutdown <-- (new!)
quit
[ some wait for the stopscript finishing stuff ]
(the kill stuff is just here to be sure. if shutdown works the process is
already stopped here)
PID=`cat ${SEQUOIA_PID} 2>/dev/null`
[ -n "$PID" ] && kill $PID 2>/dev/null
> But anyway, what you describes should not happen. So if you can provide
> a log which shows the problem, it would be very nice... ;-)
I attached full_cluster.log of both machines during reboot and a dump of
recovery log and checkpoint table.
> Could you also tell me which recovery log you are using with sequoia?
HSQL DB with this settings (should be similar to the 3.0 EmbeddedRecoveryLog):
<RecoveryLog driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:file:/var/lib/recoveryDB;shutdown=true"
login="sa" password="">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
BTW: my wait policy:
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
my appia.xml on first node:
<channel name="TCP SEQ Channel" template="tcp_sequencer" initialized="yes">
<memorymanagement size="40000000" up_threshold="15000000"
down_threshold="7000000" />
<chsession name="hederalayer">
<parameter
name="base_view">10.2.39.11:21080,10.2.39.12:21080</parameter>
<parameter
name="base_endpoints">node000C29474EB6,node000C290272CF</parameter>
<parameter name="initial_endpoints">node000C29474EB6</parameter>
<parameter name="local_address">10.2.39.11:21080</parameter>
<parameter name="local_endpoint">node000C29474EB6</parameter>
<!--<parameter name="gossip_address">224.1.1.5</parameter>-->
</chsession>
</channel>
My Testcase: I start a process that writes 100 entries (with autocommit off).
Each write takes 500ms in average. In the deb2 recovery are as expected 300
entries. (begin,insert,commit)
Hope this helps!
Thanx for reply (and sorry for the delay),
)ngo
botdb(admin) > show checkpoints +----+--------------------------------------------------------------------------------------------------------------------+ | id | name | +----+--------------------------------------------------------------------------------------------------------------------+ | 0 | Initial_empty_recovery_log | | 2 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) joined group botdb-10.2.39.11:25322-20070118153836201+0100 | | 60 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) joined group botdb-10.2.39.11:25322-20070118170128553+0100 | | 60 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) joined group botdb-10.2.39.11:25322-20070118170232278+0100 | | 60 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) joined group botdb-10.2.39.11:25322-20070118171154958+0100 | | 60 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) quit group botdb-10.2.39.11:25322-20070118170215667+0100 | | 60 | Member(address=/10.2.39.12:21080, uid=10.2.39.12:21080) quit group botdb-10.2.39.11:25322-20070118171109175+0100 | | 2 | backup init_sync_20070118153911-10.2.39.11:25322-20070118153916638+0100 | | 2 | disable all backends-10.2.39.11:25322-20070118151834210+0100 | | 2 | disable all backends-10.2.39.11:25322-20070118153701620+0100 | | 57 | disable all backends-10.2.39.11:25322-20070118165851420+0100 | | 2 | disable botdb1_000C290272CF-10.2.39.12:25322-20070118153926151+0100 | | 2 | disable botdb1_000C29474EB6-10.2.39.11:25322-20070118151830027+0100 | | 2 | disable botdb1_000C29474EB6-10.2.39.11:25322-20070118153659762+0100 | | 54 | disable botdb1_000C29474EB6-10.2.39.11:25322-20070118165850362+0100 | | 2 | now-10.2.39.11:25322-20070118153844381+0100 | | 2 | now-10.2.39.11:25322-20070118153924522+0100 | | 2 | shutdown-10.2.39.11:25322-20070118153701726+0100 | | 60 | shutdown-10.2.39.11:25322-20070118165852440+0100 | | 2 | shutdown10.2.39.11:25322 | +----+--------------------------------------------------------------------------------------------------------------------+
2007-01-18 16:58:50,449 INFO controller.RequestManager.botdb All activity is suspended for botdb
2007-01-18 16:58:50,779 INFO controller.virtualdatabase.botdb Checkpoint disable botdb1_000C29474EB6-10.2.39.11:25322-20070118165850362+0100
was stored
2007-01-18 16:58:50,785 INFO controller.virtualdatabase.botdb Disabling backend botdb1_000C29474EB6, waiting for current transaction to complete on this backend
2007-01-18 16:58:50,790 INFO controller.RequestManager.botdb Setting new virtual database schema.
2007-01-18 16:58:50,795 INFO sequoia.controller.connection 1 connections freed on "jdbc:postgresql://localhost000C29474EB6:54310/botdb"
2007-01-18 16:58:51,054 INFO controller.virtualdatabase.botdb Backend botdb1_000C29474EB6 is now disabled
2007-01-18 16:58:51,055 INFO controller.virtualdatabase.botdb Backend botdb1_000C29474EB6 disabled on controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)
2007-01-18 16:58:51,256 INFO controller.virtualdatabase.botdb Shutting down virtual database botdb in safe mode : waiting for all current transactions to complete
2007-01-18 16:58:51,258 INFO controller.virtualdatabase.botdb Waiting for virtual database botdb shutdown
2007-01-18 16:58:52,347 INFO controller.RequestManager.botdb All activity is suspended for botdb
2007-01-18 16:58:52,364 INFO controller.virtualdatabase.botdb Checkpoint disable all backends-10.2.39.11:25322-20070118165851420+0100 was stored
2007-01-18 16:58:52,364 INFO controller.virtualdatabase.botdb Backend botdb1_000C29474EB6 disabled on controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)
2007-01-18 16:58:53,564 INFO controller.RequestManager.botdb All activity is suspended for botdb
2007-01-18 16:58:53,871 INFO controller.virtualdatabase.botdb Checkpoint shutdown-10.2.39.11:25322-20070118165852440+0100 was stored
2007-01-18 16:58:54,307 INFO sequoia.controller.shutdown Waiting for 0 virtual database worker threads to terminate.
2007-01-18 16:58:54,308 INFO sequoia.controller.shutdown Shutting down group communication
2007-01-18 16:58:55,009 WARN controller.RequestManager.botdb SQLException while executing distributed write request VDB is shutting down... can't start a new transaction
org.continuent.sequoia.common.exceptions.VDBisShuttingDownException: VDB is shutting down... can't start a new transaction
at org.continuent.sequoia.controller.scheduler.AbstractScheduler.begin(AbstractScheduler.java:969)
at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.lazyTransactionStart(DistributedRequestManager.java:1107)
at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1461)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:357)
at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
2007-01-18 16:58:55,013 WARN controller.virtualdatabase.botdb Distributed request insert into x509_cert_table(bot_cert_id,... did not remove
itself from the total order queue
2007-01-18 16:58:55,143 ERROR controller.RequestManager.botdb Request insert into x509_cert_table(bot_cert_id,... failed on all local backends but succeeded on other controllers. Disabling all local backends.
2007-01-18 16:58:55,477 INFO sequoia.controller.recoverylog Log shutdown method has been invoked
2007-01-18 16:58:55,477 INFO sequoia.controller.recoverylog Executed log shutdown event
2007-01-18 16:58:55,478 INFO sequoia.controller.recoverylog Logger thread ending: LoggerThread
2007-01-18 16:58:55,479 INFO controller.virtualdatabase.botdb The virtual database botdb has been successfully shut down
2007-01-18 16:59:04,667 INFO controller.core.Controller Shutting down controller 10.2.39.11:25322
2007-01-18 16:59:04,669 INFO controller.core.Controller Waiting for controller shutdown
2007-01-18 16:59:04,672 INFO sequoia.controller.shutdown Starting controller shutdown
2007-01-18 16:59:12,203 INFO sequoia.controller.shutdown A report has been generated /usr/share/sequoia/log/sequoia.report
2007-01-18 16:59:12,203 INFO sequoia.controller.shutdown Shutting down Jmx Agent
2007-01-18 16:59:12,224 INFO controller.core.Controller ControllerServerThread terminating
2007-01-18 16:59:12,225 INFO sequoia.controller.shutdown Waiting for controller thread termination.
2007-01-18 16:59:12,226 INFO sequoia.controller.shutdown Controller shutdown completed
2007-01-18 16:59:12,227 INFO controller.core.Controller Shutdown of controller 10.2.39.11:25322 completed
2007-01-18 17:01:06,286 INFO controller.core.Controller Sequoia controller (2.10.4)
2007-01-18 17:01:06,850 INFO controller.core.Controller Loading configuration file: /usr/share/sequoia/config/controller/controller.xml
2007-01-18 17:01:07,340 INFO controller.core.Controller JMX is enabled
2007-01-18 17:01:07,454 INFO controller.core.Controller Starting JMX server on host: 10.2.39.11
2007-01-18 17:01:08,531 INFO controller.core.Controller Waiting for connections on 0.0.0.0:25322
2007-01-18 17:01:08,594 INFO controller.core.Controller Controller started on 2007.01.18 03 at 05:01:08 PM CET
2007-01-18 17:01:08,595 INFO controller.core.Controller Controller 10.2.39.11:25322 ready, listening to requests ...
2007-01-18 17:01:15,763 INFO controller.backup.BackupManager Registering backuper PostgresBinary to handle format PostgreSQL Binary Dump
2007-01-18 17:01:15,776 INFO backup.backupers.OctopusBackuper OctopusBackuper backup compression is set to true
2007-01-18 17:01:15,776 INFO controller.backup.BackupManager Registering backuper Octopus to handle format Octopus v3.4.1 database neutral dump compressed
2007-01-18 17:01:15,837 INFO backend.DatabaseBackend.botdb1_000C29474EB6 Adding connection manager for virtual user "botdbuser"
2007-01-18 17:01:18,868 INFO controller.RequestManager.botdb Request manager will parse requests with the following granularity: TABLE
2007-01-18 17:01:18,933 INFO controller.virtualdatabase.botdb Using Hedera properties file: /hedera_appia.properties
2007-01-18 17:01:19,927 INFO appia.xml.AppiaXML Loading XML configuration from file: /usr/share/sequoia/config/appia.xml
2007-01-18 17:01:25,603 INFO continuent.hedera.appia AppiaThread: Starting Appia.
2007-01-18 17:01:28,075 INFO controller.virtualdatabase.botdb Group botdb connected to Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)
2007-01-18 17:01:28,076 INFO controller.virtualdatabase.botdb First controller in group botdb
2007-01-18 17:01:28,087 INFO sequoia.controller.recoverylog Checking recovery log consistency
2007-01-18 17:01:28,097 INFO controller.core.Controller Adding VirtualDatabase botdb
2007-01-18 17:01:28,205 INFO controller.virtualdatabase.botdb Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) see members:[Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)] and has mapping:{Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)=10.2.39.11:21090}
2007-01-18 17:01:29,057 INFO backend.DatabaseBackend.botdb1_000C29474EB6 Detected backend as: PostgreSQL
2007-01-18 17:01:33,719 INFO controller.RequestManager.botdb Setting new virtual database schema.
2007-01-18 17:01:33,836 INFO controller.recoverylog.RecoverThread Starting recovery
2007-01-18 17:01:37,149 INFO controller.RequestManager.botdb All activity is suspended for botdb
2007-01-18 17:01:37,511 INFO controller.recoverylog.RecoverThread Recovery completed
2007-01-18 17:01:37,682 INFO controller.recoverylog.RecoverThread Database backend botdb1_000C29474EB6 is now enabled
2007-01-18 17:01:37,690 WARN controller.virtualdatabase.botdb No response while getting static metadata from remote controller
export SEQUOIA_HOME=/usr/share/sequoia; $SEQUOIA_HOME/bin/console.sh -p 21090
botdb(admin) > dump recoverylog
| 1 | botdbuser | insert into x509_cert_table(bot_cert_id,bot_cert_type_id,bot_cert_issuer_id,x509cert_issuer_dn,x509cert_serialnr,bot_cert_subj_id,x509cert_subj_dn,x509cert_emails,x509cert_al_emails,x509cert_crt_time,x509cert_exp_time,x509cert_version,x509cert_salg_name,x509cert_pem) values ('1b2a732479b99e0fbef16cbe4296213276b21ecb',2,'41c5148762b7e9fcba71c48fb958b68be5875f4a','CN=UTN-USERFirst-Client Authentication and Email, OU=http://www.usertrust.com, O=The USERTRUST Network, L=Salt Lake City, ST=UT, C=US','46918445236574851327188612624440853618','271ec940fde573e69921592dce5c44d25d9a5f5e','[EMAIL PROTECTED], CN=Zertificon Solutions GmbH, OU=(c)2003 Comodo Limited, OU=Terms and Conditions of use: http://www.comodo.net/repository, OU=Comodo Trust Network - PERSONA NOT VALIDATED',' [EMAIL PROTECTED] ',' [EMAIL PROTECTED] ',1167868800000,1199491199000,3,'SHA1WithRSAEncryption','-----BEGIN CERTIFICATE-----
MIIF3DCCBMSgAwIBAgIQI0wp8uTpq0JuLm5OvI+EcjANBgkqhkiG9w0BAQUFADCB
rjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExha2Ug
Q2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExho
dHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3Qt
Q2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbDAeFw0wNzAxMDQwMDAwMDBa
Fw0wODAxMDQyMzU5NTlaMIHuMTUwMwYDVQQLEyxDb21vZG8gVHJ1c3QgTmV0d29y
ayAtIFBFUlNPTkEgTk9UIFZBTElEQVRFRDFGMEQGA1UECxM9VGVybXMgYW5kIENv
bmRpdGlvbnMgb2YgdXNlOiBodHRwOi8vd3d3LmNvbW9kby5uZXQvcmVwb3NpdG9y
eTEfMB0GA1UECxMWKGMpMjAwMyBDb21vZG8gTGltaXRlZDEiMCAGA1UEAxMZWmVy
dGlmaWNvbiBTb2x1dGlvbnMgR21iSDEoMCYGCSqGSIb3DQEJARYZc2VjdXJlbWFp
bEB6ZXJ0aWZpY29uLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAyZyP
YxE1IAZxLVFVuKXBjqplmgwufkyvhVWWCjkZXZ69SQKqSedBqbXgD23BvqvCHXOD
F94ImCRjJmjCdP6Tyi49vSuwG3G4MoD8bCJatRU25/oLtEHiXueSP72mIlOVgOaz
QbH/ZdBIJJ9CugWdmrqS/V0V6rVV/+9cH0RhB88CAwEAAaOCAjYwggIyMB8GA1Ud
IwQYMBaAFImCZ33EnSZwAEu0UEh83j2uBG59MB0GA1UdDgQWBBQCRkMGeFXhPhMn
Niy+16Bd6d+ZSjAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUE
GTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYG
A1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8v
c2VjdXJlLmNvbW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6
Ly9jcmwuY29tb2RvY2EuY29tL1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGlj
YXRpb25hbmRFbWFpbC5jcmwwSqBIoEaGRGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9V
VE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMIGG
BggrBgEFBQcBAQR6MHgwOwYIKwYBBQUHMAKGL2h0dHA6Ly9jcnQuY29tb2RvY2Eu
Y29tL1VUTkFkZFRydXN0Q2xpZW50Q0EuY3J0MDkGCCsGAQUFBzAChi1odHRwOi8v
Y3J0LmNvbW9kby5uZXQvVVROQWRkVHJ1c3RDbGllbnRDQS5jcnQwJAYDVR0RBB0w
G4EZc2VjdXJlbWFpbEB6ZXJ0aWZpY29uLmNvbTANBgkqhkiG9w0BAQUFAAOCAQEA
N7jlOMOqiW6qOIJM6hFFf8eiVKpLuIM4N/fWw9W2sXNBROSplnp1IlIGjJ7OTqr7
1Uxj0az0ieFwdq33tW5n2xR4pOWgHuG8Cx3qyJ+b39+Yp7kdt+mb7eZEbNinNKFh
UaIWKzi841D/xRkHaZE5BWtayqyT0g6T/LWGJnAWydspyqbaCKdAkqd/INm5TD7n
JfRHQoeb8bFd5zAED9QsA36zIh6zSZcZhEwCmWS2SOmv1fu3RtgGJ1l/WKGsh0+/
KhbzIf9RZ8W8OTT4GnXvhQZHVdtU24XdJ1Jwi6LtRtd8lUyAManu5oiUOKdtTwyd
OrnP3nhXqE9jwZrYI57h1A==
-----END CERTIFICATE-----')
| | T | 0 | 46 | S | 161 | 1 |
| 2 | botdbuser | commit
[ --snip --]
id 3 - id 57 with
always begin, write, commit
[ --snap --]
| null | T | 562949953421331 | 0 | S | 1 | -1 |
| 58 | botdbuser | begin
| null | T | 562949953421332 | 0 | S | 0 | -1 |
| 59 | botdbuser | insert into x509_cert_table(bot_cert_id,bot_cert_type_id,bot_cert_issuer_id,x509cert_issuer_dn,x509cert_serialnr,bot_cert_subj_id,x509cert_subj_dn,x509cert_emails,x509cert_al_emails,x509cert_crt_time,x509cert_exp_time,x509cert_version,x509cert_salg_name,x509cert_pem) values ('7b925da8d66109c50454f9b9670539a7ce161a62',3,'258c0ea124e115642a4a6911be94dce635f09c3c','CN=MailPass CA, OU=T-TeleSec Trust Center, O=Deutsche Telekom AG, C=DE','2432','a54aeeb6530bbd1cac8733f5deeceed53de5503a','[EMAIL PROTECTED], CN=Peter user, OU=LEde.xxxxxxxxxxxxxxxxx.de, OU=xxxxxxxxxxxxxxxxx.de, O=xxxxxxxxxxxxxxxxx GmbH und Co. KG, C=DE',' [EMAIL PROTECTED] ',' [EMAIL PROTECTED] ',1109151759000,1140739140000,3,'SHA1WithRSAEncryption','-----BEGIN CERTIFICATE-----
MIIE9jCCBF+gAwIBAgICCYAwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCREUx
HDAaBgNVBAoTE0RldXRzY2hlIFRlbGVrb20gQUcxHzAdBgNVBAsTFlQtVGVsZVNl
YyBUcnVzdCBDZW50ZXIxF000oinecoicwncoewciYXNzIENBMB4XDTA1MDIyMzA5
NDIzOVoXDTA2MDIyMzIzNTkwMFowgckxCzAJBgNVBAYTAkRFMSowKAYDVQQKEyFC
aXNjaG9mIHVuZCBLbGVpbiBHbWJIIHVuZCBDby4gS0cxHTAbBgNVBAsTFGJpc2No
b2YtdW5kLWtsZWluLmRlMSIwIAYDVQQLExlMRWRlLmJpc2Nob2YtdW5kLWtsZWlu
LmRlMRcwFQYDVQQDEw5QZXRlciBEb25vdGhlazEyMDAGCSqGSIb3DQEJARYjcGV0
ZXIuZG9ub3RoZWtAYmlzY2hvZi11bmQta2xlaW4uZGUwgZ8wDQYJKoZIhvcNAQEB
BQADgY0AMIGJAoGBANluQ/gq5d4/vyg1pNl4DkTbHrVEy6psfOp0vzgqdZ/FwdPR
I3EMnKRhNyw+0i4/5780flDtz83JZ1RbSKocvxDFzzqrvs+CxDoRwrpE6wQuqqNW
83s2crS4CR3uFa8HKMRBaZh8UzgCy4snoueStsZupICHy6exeZhR4xbphvHJAgMB
AAGjggJRMIICTTAfBgNVHSMEGDAWgBRXRJLaB3NDUbRMuuGnni/lW3NEFDAOBgNV
HQ8BAf8EBAMCBaAwHQYDVR0OBBYEFLesNMWFvHmoYVEHn18BW0okwd6OMGUGA1Ud
IAReMFwwWgYJKwYBBAG9Rw0LME0wSwYIKwYBBQUHAgEWP2h0dHA6Ly93d3djYS50
ZWxlc2VjLmRlL2Nhc2VydmljZS9NYWlsUGFzcy9Eb2t1bWVudGUvaW5kZXguaHRt
bDAuBgNVHREEJzAlgSNwZXRlci5kb25XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
ZTCB9wYDVR0fBIHvMIHsMIGKoIGHoIGEhoGBbGRhcDovL2xkYXAudC1tYWlscGFz
cy5kZS9jbj1NYWlsUGFzcyUyMENBLG91PVQtVGVsZVNlYyUyMFRydXN0JTIwQ2Vu
dGVyLG89RGV1dHNjaGUlMjBUZWxla29tJTIwQUcsYz1ERT9DZXJ0aWZpY2F0ZVJl
dm9jYXRpb25MaXN0MF2gW6BZhldodHRwOi8vd3d3Y2EudGVsZXNlYy5kZS9jZ2kt
YmluL2Nhc2VydmljZS9NYWlsUGFzcy9hZl9Eb3dubG9hZENSTC5jcmw/LWNybF9m
b3JtYXQ9eF81MDkwXwYIKwYBBQUHAQEEUzBRME8GCCsGAQUFBzABhkNodHRwOi8v
d3d3Y2EudGVsZXNlYy5kZS9jZ2ktYmluL2Nhc2VydmljZS9NYWlsUGFzcy9vY3Nw
X3JlcXVlc3QuY2dpMAkGA1UdEwQCMAAwDQYJKoZIhvcNAQEFBQADgYEAodxLZ97T
o4vNO9Vrh678dWNlu/FAAKa/+zc60pEjDwV87Fd02787epqMTq3LZz4TIrhAlJNG
ipqrYTf1ay33P/aCSw1R/XVcNQFlTO/Jhj+Oxu6cNK5UCyMvODxRxdDgV7siLqAh
4CX9RM5xmoOyd4Iqdd6e+umFHiydpf17RA4=
-----END CERTIFICATE-----')
| | T | 562949953421332 | 562949953421959 | S | 0 | 1 |
| 60 | botdbuser | commit
| null | T | 562949953421332 | 0 | S | 1 | -1 |
+--------+-----------+-----------------------------------------------------------------------------------------------------------------------
botdb(admin) > show checkpoints +-----+--------------------------------------------------------------------------------------------------------------------+ | id | name | +-----+--------------------------------------------------------------------------------------------------------------------+ | 303 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) joined group botdb-10.2.39.12:25322-20070118170128529+0100 | | 303 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) joined group botdb-10.2.39.12:25322-20070118170232230+0100 | | 303 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) joined group botdb-10.2.39.12:25322-20070118171121648+0100 | | 63 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) quit group botdb-10.2.39.12:25322-20070118165857163+0100 | | 303 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) quit group botdb-10.2.39.12:25322-20070118170230095+0100 | | 303 | Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) quit group botdb-10.2.39.12:25322-20070118171106611+0100 | | 2 | backup init_sync_20070118153911-10.2.39.11:25322-20070118153916638+0100 | | 57 | disable all backends-10.2.39.11:25322-20070118165851420+0100 | | 2 | disable botdb1_000C290272CF-10.2.39.12:25322-20070118153926151+0100 | | 54 | disable botdb1_000C29474EB6-10.2.39.11:25322-20070118165850362+0100 | | 2 | now-10.2.39.11:25322-20070118153924522+0100 | | 60 | shutdown-10.2.39.11:25322-20070118165852440+0100 | +-----+--------------------------------------------------------------------------------------------------------------------+
2007-01-18 16:58:52,250 INFO controller.virtualdatabase.botdb Checkpoint disable botdb1_000C29474EB6-10.2.39.11:25322-20070118165850362+0100 was stored 2007-01-18 16:58:52,281 INFO controller.virtualdatabase.botdb Backend botdb1_000C29474EB6 disabled on controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) 2007-01-18 16:58:53,964 INFO controller.virtualdatabase.botdb Checkpoint disable all backends-10.2.39.11:25322-20070118165851420+0100 was stored 2007-01-18 16:58:53,964 INFO controller.virtualdatabase.botdb Backend botdb1_000C29474EB6 disabled on controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) 2007-01-18 16:58:55,419 INFO controller.virtualdatabase.botdb Checkpoint shutdown-10.2.39.11:25322-20070118165852440+0100 was stored 2007-01-18 16:58:56,673 WARN controller.RequestManager.botdb Request 562949953421969 failed on controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) (org.continuent.sequoia.common.exceptions.VDBisShuttingDownException: VDB is shutting down... can't start a new transaction) 2007-01-18 16:58:57,355 WARN controller.virtualdatabase.botdb Controller Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) has left the cluster. 2007-01-18 16:58:57,357 INFO controller.virtualdatabase.botdb 1 requests were waiting responses from Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) 2007-01-18 16:58:57,363 WARN controller.RequestManager.botdb 1 controller(s) died during execution of request 0 2007-01-18 16:58:57,632 INFO controller.requestmanager.cleanup Waiting 60000ms for client of controller 0 to failover 2007-01-18 16:59:57,767 INFO controller.requestmanager.cleanup Cleanup for controller 0 failure is completed. 2007-01-18 17:02:30,093 INFO continuent.hedera.gms Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) failed in Group(gid=botdb) 2007-01-18 17:02:30,097 INFO controller.virtualdatabase.botdb 0 requests were waiting responses from Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) 2007-01-18 17:11:06,604 INFO continuent.hedera.gms Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080) failed in Group(gid=botdb) 2007-01-18 17:11:06,612 INFO controller.virtualdatabase.botdb 0 requests were waiting responses from Member(address=/10.2.39.11:21080, uid=10.2.39.11:21080)
similar to deb1 always 3 logentries with begin INSERT commit but see the last entry here (id=300!) +--------+-----------+--------+-----------+----------------+-----------------+------------+-------------+-----------+--------------+ | LOG_ID | VLOGIN | SQL | SQL_PARAM | AUTO_CONN_TRAN | TRANSACTION_ID | REQUEST_ID | EXEC_STATUS | EXEC_TIME | UPDATE_COUNT | +--------+-----------+--------+-----------+----------------+-----------------+------------+-------------+-----------+--------------+ | 300 | botdbuser | commit | null | T | 562949953421413 | 0 | S | 0 | 0 | +--------+-----------+--------+-----------+----------------+-----------------+------------+-------------+-----------+--------------+
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
