April 2006 - users-list

[MonetDB-users] RHEL 3 RPMs
by Henk van Lingen 28 Apr '06

28 Apr '06

Hi, Is there a special reason there are no i686 RPM's anymore like there were until 4.6.0_rc2? I think it's a bit weird there are RPM's for the hobby OS 'FedoraCore' but not for the much used server OS 'RedHat Enterprise 3 (and 4)'? The FedoraCore (which Core?) needs libstdc++.so.6 whereas RHEL 3 only has libstdc++.so.5 ... There also seems to be no SRPM's. Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

6 14

[MonetDB-users] Issues with concurrent connections using JDBC
by Anderson Supriano 09 Apr '06

09 Apr '06

Hi! I'm working on a research about database performance and I'm running a TPC-W implementation (based on http://www.ece.wisc.edu/~pharm/tpcw.shtml) on some databases (Monet, MySQL, Postgresql). Basically, what is being done is having some emulated browsers generating load on the servlet container (tomcat in my case) that access the database through JDBC. -------------- -------------- ---------------- | Emulated | | Tomcat | | DB | | Browser | -----> | | ------> | | -------------- -------------- ---------------- When running this benchmark with concurrent accesses I'm getting problems. If I try 5 concurrent Emulated Browsers running (and 5 concurrent database connections) everything goes well. The problem starts when I increase the concurrency. With 30 concurrent connections everything goes well for a few minutes and then it stops working. The servlet container stops responding and monet uses low percentage of CPU on this state. When I try to kill tomcat and start again (without killing Monet) it starts working again and stops after a while. Based on this experiment it seems that Monet is still responsive, but the instance of servlet container that was accessing Monet just freezes. I'm trying to investigate it a little more, but since I'm not an expert on MonetDB internals, I'd like to know if there is some known issue like this one or if anyone can have a tip on how to solve this. Since Monet is responsive and the servlet container is freezing, it looks like JDBC driver is doing something that is freezing the container (I used to suspect on application, but since it is working very well with MySQL and Postgresql, it seems to not be the problem). I'll appreciate any help on this subject. Thanks very much for your attention. Best regards, Anderson Supriano

2 2

[MonetDB-users] Commit failure on concurrent transactions
by Anderson Supriano 02 Apr '06

02 Apr '06

Hi! I am running several concurrent transactions on Monet DB using JDBC and I'm getting an error when commiting a transaction: java.sql.SQLException: COMMIT: failed ERROR: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2185) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1937) at nl.cwi.monetdb.jdbc.MonetConnection.commit(MonetConnection.java:443) Is there a way that this exception can be handled in order to have all transactions working (even if waiting the last one to be finished)? I am using MonetDB-4.10.0 and SQL-2.10.0. Thanks for your cooperation. Best regards, Anderson Supriano

2 2