[MonetDB-users] mserver5 crashed after 10, 000 times sql queries through JDBC interface
I'm using the latest MonetDB5: MonetDB-Nov2009-SuperBall-SP1 on Red Hat Enterprise Linux AS release 4 (Nahant Update 4) x86_64. dependencies: openssl-0.9.8l, pcre-8.00. The box has 8G physical memory, about half of them is available. building options: ./monetdb-install.sh --prefix=/opt/monetdb5 --enable-sql --enable-optimise After installation, I started the mserver5 process: /opt/monetdb5/bin/mserver5 --dbinit "include sql;", then I load one table exported from MySQL with about 1M rows and 20 columns. I noticed small memory increase when I run a simple query on the mclient console for some times. So I run this query through the JDBC interface for 10000, I can see a big memory consumption rise when the test program is running. and finally the mserver5 process crashed with segmentation fault. I can always reproduce this problem. What's wrong? Have I used some wrong build options? Help! Frank
xulizhong wrote: Dear Frank, Thank you for using MonetDb and performing a stress test.
I'm using the latest MonetDB5: MonetDB-Nov2009-SuperBall-SP1 on Red Hat Enterprise Linux AS release 4 (Nahant Update 4) x86_64. dependencies: openssl-0.9.8l, pcre-8.00. The box has 8G physical memory, about half of them is available. building options: ./monetdb-install.sh --prefix=/opt/monetdb5 --enable-sql --enable-optimise
After installation, I started the mserver5 process: /opt/monetdb5/bin/mserver5 --dbinit "include sql;", then I load one table exported from MySQL with about 1M rows and 20 columns. I noticed small memory increase when I run a simple query on the mclient console Could you provide the query and schema? for some times. So I run this query through the JDBC interface for 10000, I can see a big memory consumption rise when the test program is running. and finally the mserver5 process crashed with segmentation The latter part is not acceptable.
fault. I can always reproduce this problem. That is good news. Can you provide the smallest program that demonstrates this behavior?
What's wrong? Have I used some wrong build options? No. not evident from this report. Help!
Frank
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Martin Kersten
-
xulizhong