Hi all,
I am experimenting with sequoia and have reached the position where as
can be seen from the controller log below, I have no errors up to the
point where I try to connect and update the database.
The DB is empty except for a dummy table. I am then running hibernate
schemaExport which starts by dropping a lot of constraints.
I get the following output for every update:-
Recovery log was unable to update request completion status:
UPDATE logtable SET
exec_status=S,update_count=0,exec_time=1733,completion_log_id=0 WHERE
log_id=0
I am using a separate postgres db as a recovery db and the expected
tables are being created, so I assume my connection configuration for
the recovery db is correct.
Can anyone assist by suggesting what I might have done wrong. I am still
using a SingleDB configuration for this test.
Any help much appreciated.
Peter
controller output :-
19:09:27,442 INFO controller.core.Controller Sequoia controller (3.0-beta)
19:09:27,558 INFO controller.core.Controller Loading configuration file:
./config/controller/tridentController.xml
19:09:27,693 INFO controller.core.Controller JMX is enabled
19:09:27,730 INFO controller.core.Controller Starting JMX server on host:
127.0.0.1:1090
19:09:28,391 INFO backup.backupers.OctopusBackuper OctopusBackuper backup
compression is set to true
19:09:28,393 INFO controller.backup.BackupManager Registering backuper Octopus
to handle format Octopus v3.4.1 database neutral dump compressed
19:09:28,431 INFO backend.DatabaseBackend.localhost Adding connection manager for
virtual user "peter"
19:09:28,839 INFO sequoia.controller.recoverylog Creating recovery log table:
logtable
19:09:28,862 INFO sequoia.controller.recoverylog Creating checkpoint table:
checkpointtable
19:09:28,906 INFO sequoia.controller.recoverylog Creating backend table:
backendtable
19:09:28,913 INFO sequoia.controller.recoverylog Creating dump table: dumptable
19:09:28,979 INFO controller.RequestManager.trident Request manager will parse
requests with the following granularity: TABLE
19:09:28,994 INFO controller.virtualdatabase.trident Unknown last state for
backend localhost. Leaving node in disabled state.
19:09:28,995 INFO controller.core.Controller Adding VirtualDatabase trident
19:09:29,073 INFO controller.core.Controller Waiting for connections on
127.0.0.1:25323
19:09:29,097 INFO controller.core.Controller Controller started on 2006.10.24
43 at 07:09:29 PM BST
19:09:29,098 INFO controller.core.Controller Controller 127.0.0.1:25323 ready,
listening to requests ...
19:12:01,632 INFO controller.RequestManager.trident Starting backup of backend
localhost
19:12:01,646 INFO backup.backupers.OctopusBackuper Starting backup of backend
localhost with checkpoint base_dump
Default (Standard) Logger is load.
OctopusGenerator started.
GenerateSqlForAllVendors is started.
Working.... SQL Statements for Csv Vendor
CreateIncludeFiles is started. Generating sql and xml files is started.
createIncludeFiles method is started.
Working....test
done...
createIncludeFiles method is finished.
CreateIncludeFiles is finished. Generating sql and xml files is finished.
Working.... SQL Statements for PostgreSQL Vendor
CreateIncludeFiles is started. Generating sql and xml files is started.
createIncludeFiles method is started.
Working....test
done...
createIncludeFiles method is finished.
CreateIncludeFiles is finished. Generating sql and xml files is finished.
GenerateSqlForAllVendors is finished.
Duration: 0,434 seconds
OctopusGenerator finished.
Default (Standard) Logger is load.
OctopusGenerator started.
CreateIncludeFiles is started. Generating sql and xml files is started.
createIncludeFiles method is started.
Working....test
done...
createIncludeFiles method is finished.
CreateIncludeFiles is finished. Generating sql and xml files is finished.
Generating of LoaderJob.olj file is started.
loadJobWriter method is started.
loadJobWriter method is finished.
Generating of LoaderJob.olj file is finished.
Duration: 0,248 seconds
OctopusGenerator finished.
Default (Standard) Logger is load.
Application is started.
Loader loads XML file : ~/sequoia/sequoia-3.0-beta-b/base_dump/LoaderJob.olj
XML document is valid.
All rows are commited.
Application is finished.
All jobs duration: 1,665 seconds
19:12:05,143 INFO controller.RequestManager.trident Backup has completed.
19:12:17,611 INFO backend.DatabaseBackend.localhost Detected backend as:
PostgreSQL
19:12:26,011 INFO controller.RequestManager.trident Setting new virtual
database schema.
19:12:26,012 INFO sequoia.controller.cache Setting new database schema.
19:12:26,082 INFO controller.recoverylog.RecoverThread Starting recovery
19:12:26,085 INFO controller.recoverylog.RecoverThread Recovery completed
19:12:33,861 INFO controller.loadbalancer.SingleDB Enabling backend localhost
19:12:33,868 INFO controller.recoverylog.RecoverThread Database backend
localhost is now enabled
--
------------------------------
Peter Courcoux
Telephone : +44 (0)1923 661488
Mobile : 07880 605626
email : [EMAIL PROTECTED]
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
