[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 <commit();> on the client. Total operations: approximately 7500 BATs, 17,000,000 BUNs.
- Do an <ls();> on the server to confirm all tables are clean.
- Now perform an <abort();> 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 <ulimit -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
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 <abort();> 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 <commit();> on the client.
Total operations: approximately 7500 BATs, 17,000,000 BUNs.
Do an <ls();> on the server to confirm all tables are clean.
Now perform an <abort();> 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 <ulimit -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
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 <abort();> 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 <commit();> on the client.
Total operations: approximately 7500 BATs, 17,000,000 BUNs.
Do an <ls();> on the server to confirm all tables are clean.
Now perform an <abort();> 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 <ulimit -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