[MonetDB-users] MonetDB Server logs and location on Windows
Hello. I have MonetDB installed on Windows XP. The server crashed several times for me during shredding of several files (1mill records each). I am running this Window XP instance in VM, so maybe disk space or memory was an issue. 1. Where are the logs? 2. Also, what is the physical location of the database itself? 3. What is the best strategy to prevent data loss if server crashes. Do I need to backup files or backup through Admin GUI? Thanks a lot!
On Tue, Apr 07, 2009 at 10:10:57AM -0400, Max Fedorov wrote:
Hello. I have MonetDB installed on Windows XP. The server crashed several times for me during shredding of several files (1mill records each). I am running this Window XP instance in VM, so maybe disk space or memory was an issue.
Which version of MonetDB are you using? Is your Windows XP (and MonetDB) 32- or 64-bit? (The output of `Mserver --version` or `mserver5 --version` does reveal both.) Are you using MonetDB/XQuery --- as "shredding files" (== semi-structured XML documents) suggests --- or MonetDB/SQL --- as "records" (== structures relational/SQL data) suggests? How does/did the server crash, i.e., are/were there any error messages, and if so, which?
1. Where are the logs?
On Windows by default in %APPDATA%\MonetDB5\sql_logs (MonetDB/SQL) or %APPDATA%\MonetDB4\xquery_logs (MonetDB/XQuery); however, they are not supposed to be modified "by hand" ...
2. Also, what is the physical location of the database itself?
On Windows by default %APPDATA%\MonetDB5\dbfarm (MonetDB/SQL) or %APPDATA%\MonetDB4\dbfarm (MonetDB/XQuery); however, they are not supposed to be modified "by hand" ...
3. What is the best strategy to prevent data loss if server crashes. Do I need to backup files or backup through Admin GUI?
a) The server is no supposed to crash; if it does, it is a bug that needs to be analyzed and fixed --- answering my above questions would help us to do so ... b) Even if the server crashes, no (committed) persistent data should be lost --- unless there is a bug in the code ... c) Backups of the database (and log) directories (see above) using your prefered filesystem backup tools/mechanism is always recommended to prevent data loss due to accidental deletes, mal-functioning software, hardware failures, disasters, etc. All MonetDB servers must be stopped during such backups. d) (Additional) backups though textual database dupms --- using the Admin GUI for XQuery (cf., http://monetdb.cwi.nl/XQuery/QuickTour/adminGUI/index.html#backup) or the textual mclient interface for SQL (cf., http://monetdb.cwi.nl/SQL/Documentation/Database-Dumps.html) are recommended in particular before upgrading to a new version of MonetDB, in case that changes the (binary) database format (cf., http://monetdb.cwi.nl/Development/Releases/Feb2009/index.html), or in case you need to migrate your database(s) to a different hardware platform or operating system. Stefan
Thanks a lot!
------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (2)
-
Max Fedorov -
Stefan Manegold