- users-list - monetdb.org

[MonetDB-users] RHEL 4 x86_64 RPMs
by Henk van Lingen 03 May '06

03 May '06

On Fri, Apr 28, 2006 at 06:44:42PM +0200, Stefan Manegold wrote: > > > RPM build errors: > > > File not found by glob: /var/tmp/MonetDB-root/usr/share/MonetDB/lib/*jar > > Can it be that you don't have Java installed on your system? > > Nevertheless I think this is a bug. > > yes, yes, yes: > > - it should also work with REHL4 on x86_64 --- ate least I don't see any > reason why it should not work, provided the systems … [View More]

3 3

[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.… [View More]

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 … [View More]

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.… [View More]

2 2

[MonetDB-users] JDBC: Not all results returned
by Martin Beck 23 Feb '06

23 Feb '06

Hi, I have a simple SQL script which starts like this: CREATE TABLE people ( pid integer NOT NULL PRIMARY KEY, name varchar(40) NOT NULL DEFAULT '', number varchar(15) NOT NULL UNIQUE DEFAULT '0', email varchar(100) NOT NULL, spid integer NOT NULL DEFAULT '0' ); Afterwards, it inserts 251 People with ascending pids from 0 to 250. I apply it to the MonetDB database either with MapiClient, or JDBCClient. However, if I login with the JDBCClient and do a "select name,number from … [View More]

3 8

[MonetDB-users] network setup
by Colin Foss 15 Feb '06

15 Feb '06

How do you configure MonetDB to listen to connections from anywhere besides the localhost? I can make a local connection but as soon as I try to connect from another computer I get an error. I have even tested with netcat (nc) to make sure there wasn't a firewall blocking the connection. Colin Foss

2 1

[MonetDB-users] Mondrian and MonetDB
by Martin Kersten 31 Jan '06

31 Jan '06

LS, I think the combination of the opensource project Mondrian and MonetDB would be a very strong couple. Especially given the history of MonetDB in the area of datamining. However, the resources at the core team are insufficient at this point in time to embark on such a (short term) project. Perhaps someone in our user community is willing to take up the challenge and report on the problems encountered/ results obtained. The core development teams is particularly interested in missing … [View More]

2 1

[MonetDB-users] MonetDB-SQL 2.10.0 - Status of temorary tables?
by leemarks＠netspace.net.au 31 Jan '06

31 Jan '06

Hi, Are temporary tables currently supported in monetdb-sql? If I do something like, create temporary table foo (abc integer) It fails with a strange error. [Perhaps I'm using invalid syntax?] Thanks in advance, Lee ------------------------------------------------------------ This email was sent from Netspace Webmail: http://www.netspace.net.au

4 8

[MonetDB-users] 8 hours of Photoshop Video Tutorials
by Cole 23 Jan '06

23 Jan '06

1 0

[MonetDB-users] MonetDB/Five slotting: on running M4 next to M5
by Fabian Groffen 25 Dec '05

25 Dec '05

Hi list, Scheduled for next year is the (alpha/beta) release of MonetDB/Five, the successor of the current MonetDB generation. MonetDB/Five is the logical successor to its predecessor in terms of speed and performance. However, MonetDB/Five is not fully backwards compatible with it's predecessor. Instead of using the MIL language for kernel operations, it uses MAL. Although many MIL operations can be easily mapped on MAL operations, a fully automatic (and correct) translation of MIL to MAL … [View More]is not possible. Directly related to this, is the availability of MonetDB/XQuery, which currently heavily relies on the MIL language. The SQL users of MonetDB will be the only ones that will immediately benefit from the improved MonetDB/Five engine, as SQL is fully functional and there is no difference in language or output. Due to this situation where both M4 (curent MonetDB generation) and M5 (MonetDB/Five generation) have it's own advantages (XQuery support, MIL, MAL, better performance) it is most likely that one would like to run both M4 and M5 engines next to each other to benefit from both. This would currently cause problems when applied out of the box. Given that M4 and M5 would be slotted, and hence installable next to each other, starting it's services would cause problems because both engines try to bind to the same ports by default. To give a short view on the ports in use by default: M4 M5 Mapi 50000 50000 SQL 45123 45123 XQuery 45789 N/A This obviously clases for default MIL/MAL (Mapi) connections as well as SQL connections. XQuery is not an issue for the moment. A few observations: - The actual language spoken over the Mapi server port is engine specific, i.e. MIL for M4 and MAL for M5. This is probably somewhat confusing. For SQL it is clear, and the port specifies which language to use, regardless the engine. - XQuery support is not available for M5 yet, but it should be dealt with as for SQL. Possible scenarios to solve the problems of clashing ports can be: 1. Use different port numbers based on the engine, i.e. use 55123 for SQL on M5 and 45123 on M4. Mapi could become something like 50005 for M5. 2. Build (or extend for instance the DatabasePool) an application that handles transparently the request for a service making use of a combination of port and challenge response to give the client a M4 MIL, M5 MAL, M5 SQL or M4 XQuery connection, using the ports currently known. (Note: this also allows for multi-catalog support for SQL, when the DatabasePool is taken as base.) 3. Ignore the problem and only document it, including how to change the default ports to avoid clashes. (Note: unfortunately we're unable to bind to a certain interface...) 4. A combination between 1 and 2, with the purpose of getting each language it's own port in the system, reducing the problem and possibly disable M4's SQL server. Are end-users interested in/aided by such changes made, or will they figure out themselves easily enough? Just a few thoughts on a problem that will arise in distribution land... [View Less]

1 0