Bugs item #902043, was opened at 2004-02-22 08:36
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=902043&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core
Group: (zombie: SQL)
>Status: Closed
Resolution: Fixed
Priority: 3
Private: No
Submitted By: Martin Kersten (mlkersten)
Assigned to: Niels Nes (nielsnes)
Summary: Log manager
Initial Comment:
Currently the log with changes to the BATs are retained
forever, i.e. until the database owner explicitly
removes the files.
At least a warning should be issued at server restart
to checkpoint the database and cleanup. Likewise,
redoing the log file may take several minutes, about
which the user should be warned with a message.
To guard against a full disk, a separate thread or
process (Mguardian?) should initiate checkpoints where
appropriate and/or compress the log file.
In the meantime, sql_server module should provide the
following operations:
sqlLogStatus() - summarizes available logs and disk space
sqlCheckpoint("backup location")- to safe DB
sqlCompact() - to remove all log records without
persistent bat
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-02-02 08:29
Message:
Logged In: YES
user_id=43556
Originator: NO
A test for a log running out of diskspace may cause other problems (the OS
may have problems with this),
so stable output will be hard. Therefor we don't add a test!.
----------------------------------------------------------------------
Comment By: Martin Kersten (mlkersten)
Date: 2006-12-04 17:51
Message:
Logged In: YES
user_id=490798
Originator: YES
Original submitter accepts the resolution.
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2006-11-29 09:06
Message:
Logged In: YES
user_id=572415
Originator: NO
over-ruling "sf-robot":
re-set to "Pending" since adding a proper test has neither been done nor
finally been discarded, yet.
User (submitter) & developer (assignee),
please check, again.
----------------------------------------------------------------------
Comment By: SourceForge Robot (sf-robot)
Date: 2006-11-22 03:20
Message:
Logged In: YES
user_id=1312539
Originator: NO
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 365 days (the time period specified by
the administrator of this Tracker).
----------------------------------------------------------------------
Comment By: SourceForge Robot (sf-robot)
Date: 2005-11-21 03:20
Message:
Logged In: YES
user_id=1312539
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2005-11-06 09:44
Message:
Logged In: YES
user_id=572415
BugDay_2005-10-06: "left-overs" are now maked as "pending"
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2005-10-06 09:29
Message:
Logged In: YES
user_id=43607
BugDay_2005-10-06: CLAIMED BY sjoerd
BugDay_2005-10-06: NO TEST / POSTPONED
- testing what happens in case of a fulll disk is hard to do
automatically in Mtest
- general check for left-over BATs should be added to Mtest
itself
- set priority to 9 to keep us reminded
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2004-05-07 21:00
Message:
Logged In: YES
user_id=43556
a log manager thread is now added. This thread check every
minute if there were changes, if so the bats are made persistent
and a commit is done, after which the log files are
discarded (removed)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=902043&group_id=56967
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
