Hi Joe, thanks for being interested in and using MonetDB. To be able to analize your problem, we'd require some more detailed information from you: - Which version of MonetDB / MonetDB/SQL are you using? Did you install a binayr distribution or compile from source? - Which operating system are you running MonetDB/SQL on? - How much physical (RAM) and virtual (swap) memory does your machine have? - How much free space is on your disk (in particular the partition/"drive" where MonetDB's "dbfarm" is stored, both before loading and after loading (i.e., after the crash)? - Can you specify "several" million records a bit more? Is it 1-9 million or rather 90-99 million? How wide are your records? How do(es) your table(s) look like? - How do you load via odbc, in bulk (e.g., copy into) or row-by-row (insert)? - Is there any error message when the server crashes? - Is there any error message when restaring the server fails after the JDBC crash? Kind regards, Stefan On Mon, Oct 09, 2006 at 12:37:26AM -0400, Joseph.Baird@cox.com wrote:
After loading several million records via odbc, the server is suddenly unresponsive but can be restarted. When using jdbc, the server crashes, again after several million records, but cannot be restarted. Performance and usability are impressive with a million records or so but I cannot seem to load more than that without consistent problems.
Is there any way to make the server - and ideally the database - usable again?
Thank you in advance,
Joe Baird
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | 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 |