[MonetDB-users] Crashing server
Greetings!
Having some problems with the MonetDB server crashing.
- Start a server
- Have a client perform a lot of operations (_lots_ of BATs creation, bun
insertions, etc).
- Every 10,000 or so operations, perform a
Hi Ed,
just a short question:
How much diskspace do you have left on the partition where your dbfarm is located?
It would be great to know the free diskspace both just before the
Greetings!
Having some problems with the MonetDB server crashing.
- Start a server
- Have a client perform a lot of operations (_lots_ of BATs creation, bun insertions, etc).
- Every 10,000 or so operations, perform a
on the client. Total operations: approximately 7500 BATs, 17,000,000 BUNs. - Do an
on the server to confirm all tables are clean. - Now perform an
on the server with every table clean. MonetDB>abort(); #GDKmmap(6553600) fail => BBPtrim(enter) usage[mem=736705664,vm=2137835808] # !mallinfo.arena = 35753984 !mallinfo.ordblks = 4454 !mallinfo.smblks = 0 !mallinfo.hblkhd = 122863616 !mallinfo.hblks = 33 !mallinfo.usmblks = 0 !mallinfo.fsmblks = 0 !mallinfo.uordblks = 15990816 !mallinfo.fordblks = 19763168 #GDKmmap(6553600) fail => BBPtrim(ready) usage[mem=736705664,vm=2137835808] # !mallinfo.arena = 35753984 ... (and so on)
Doing a
shows: core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 14336 virtual memory (kbytes, -v) unlimited Anybody have any ideas on why the server died? If I do it with less (_much_ less) operations, it at least succeeds (even though there is a lot of I/O occurring).
Regards! Ed
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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 |
Hi Stefan!
df /dev/md0 1153734004 227233032 867894664 21% /mnt/raid
The disk is 1.1TB in size, the particular directory is using only about 8.2GB of disk. Regards! Ed On Mon, 18 Apr 2005, Stefan Manegold wrote:
Hi Ed,
just a short question:
How much diskspace do you have left on the partition where your dbfarm is located?
It would be great to know the free diskspace both just before the
and just after the server crashes. Thanks in advance,
Stefan
Greetings!
Having some problems with the MonetDB server crashing.
- Start a server
- Have a client perform a lot of operations (_lots_ of BATs creation, bun insertions, etc).
- Every 10,000 or so operations, perform a
on the client. Total operations: approximately 7500 BATs, 17,000,000 BUNs. - Do an
on the server to confirm all tables are clean. - Now perform an
on the server with every table clean. MonetDB>abort(); #GDKmmap(6553600) fail => BBPtrim(enter) usage[mem=736705664,vm=2137835808] # !mallinfo.arena = 35753984 !mallinfo.ordblks = 4454 !mallinfo.smblks = 0 !mallinfo.hblkhd = 122863616 !mallinfo.hblks = 33 !mallinfo.usmblks = 0 !mallinfo.fsmblks = 0 !mallinfo.uordblks = 15990816 !mallinfo.fordblks = 19763168 #GDKmmap(6553600) fail => BBPtrim(ready) usage[mem=736705664,vm=2137835808] # !mallinfo.arena = 35753984 ... (and so on)
Doing a
shows: core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 14336 virtual memory (kbytes, -v) unlimited Anybody have any ideas on why the server died? If I do it with less (_much_ less) operations, it at least succeeds (even though there is a lot of I/O occurring).
Regards! Ed
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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)
-
Edmund Dengler
-
Stefan.Manegold@cwi.nl