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 |