- users-list - monetdb.org

[MonetDB-users] ODBC + non-ascii
by Pawel Lewicki 08 Jul '08

08 Jul '08

Hi, I don't know if problem is related to used interface (ODBC) but I have a problem with inserting non-ascii data. All data I insert seems broken. I started with 'utf-8' but tested 'cp1250' and 'iso8859-2' as well. No luck. All data I take back has broken non-ascii characters. Any clues? (Windows 32-bit "Jun 2008" release) Pawel Lewicki

2 4

[MonetDB-users] Update using two (2) tables
by Kirk Abbott 04 Jul '08

04 Jul '08

Hello, I am having trouble with the syntax for doing an update using 2 tables. In postgres, one can do something like: update table1 set name = table2.name from table2 where table1.id = table2.id ; In oracle (it's something like) update table1 a set name = (select b.name from table2 b where a.id = b.id) ; What is the correct way to do this in MonetDb (as both of the above fail) Thanks, Kirk.

3 2

[MonetDB-users] XQ: inconsistency between fn:collection and pf:collection after a del-doc
by luc touraille 03 Jul '08

03 Jul '08

Hi, Currently working on a big project with MonetDB XQuery, I stumbled upon an awkward bug (unless it is a *very* perturbing feature): after deleting a document in a collection "myColl", using the function pf:del-doc, this document is still displayed when calling fn:collection("myColl"), and not when using pf:collection("myColl"). I assume the latter result is the expected one, so why is the first query displaying data that is not supposed to be in the database anymore ? Have I misunderstood something or is it a true bug (maybe related to the http://www.nabble.com/--monetdb-Bugs-1976341---XQ%3A-leftovers-after-deleti… bug #1976341 : leftovers after deleting a document ) ? N.B.: this problem occured with the Feb 2008 release; I tried to reproduce it with the Jun 2008 release, and this time it's the pf:collection() function that gave me the wrong results (the fn: one being unsupported yet). Greetings, Luc Touraille -- View this message in context: http://www.nabble.com/XQ%3A-inconsistency-between-fn%3Acollection-and-pf%3A… Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] New MonetDB Release
by Stefan Manegold 28 Jun '08

28 Jun '08

Dear MonetDB users and developers, The MonetDB team at CWI is pleased to announce the new "Jun2008" release of the MonetDB suite of programs. For MonetDB/XQuery, this release marks the roll forward from the old "milprint_summer"-based Pathfinder compiler to the new "Algebra"-based Pathfinder compiler. MonetDB/SQL has been extended with initial support for OpenGIS via the "Geom[etry]" extension module, aka. MonetDB/SQL/GIS. Additionally, the configure defaults for compilation from sources on Unix(-like) systems as well as the Windows installers have been cleaned-up. For more information, please see the detailed release notes at http://monetdb.cwi.nl/Development/Releases/Version4.24/ IMPORTANT NOTE: Before upgrading to the latest "Jun2008" release from any previous release of MonetDB, please make a dump of your database, and rename/move/backup the database directories (dbfarm, sql_logs, xquery_logs). After the upgrade, restore your database, again. Once you have checked and confirmed the correctness of the restore, you can delete the above renamed/moved/backed-up old database directories. For more information, please see the detailed release notes at http://monetdb.cwi.nl/Development/Releases/Version4.24/ The new release consists of the following packages: MonetDB Common 1.24.0 MonetDB Clients 1.24.0 MonetDB4 Server 4.24.0 MonetDB4 XQuery 0.24.0 MonetDB5 Server 5.6.0 MonetDB5 SQL 2.24.0 MonetDB5 Geom 0.4.0 monetdb-1.8-jdbc.jar There is of course also a new "Super Source Ball", a tarball containing the combined sources. All this is available on our SourceForge project page. See https://sourceforge.net/project/showfiles.php?group_id=56967 for the downloadable files. Enjoy! The MonetDB development team. -- | 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 |

1 0

[MonetDB-users] Python on Windows
by Kees Varekamp 27 Jun '08

27 Jun '08

Does anyone know how to get the Python libs running on Win XP? Tried it with latest trunk and release versions of Monet, and with Python 2.4 and 2.5 File "C:\Python25\lib\MonetDB\MapiLib.py", line 7, in <module> import _MapiLib ImportError: DLL load failed: The specified module could not be found. _MapiLib.pyd is there alright. Is this a version problem? Thanks, Kees

1 0

[MonetDB-users] MonetDB database size restrictions
by Sam Mason 19 Jun '08

19 Jun '08

Hi, I hope you don't get asked this question too often, I've had a look for FAQs but couldn't find anything obvious. I'm trying to load some data into MonetDB (built on a i386 Debian "etch" box from MonetDB-Feb2008-SuperBall.tar.bz2) and I'm getting strange problems. I've got a table with 11 columns (2 int, 5 varchar, 4 date) and about 38 million rows (the text file I want to pull in is 3.3GB). If I try COPYing the data in, Monet alternately stops making progress (the computer is reading from the disk slowly, so maybe it's just going to take a *long* time to finish) or crashes with the following message: !SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=24/2470, ext=tail.priv !OS: Cannot allocate memory !ERROR: GDKload failed: name=24/2470, ext=tail.priv If I try splitting the file into smaller pieces (about a gig each), things work and I end up with the data in the database. It would be nice to know why I needed to split the file up first. Now I've got the data in I tried running a few queries to make sure everything went OK. I'm getting some very strange results when doing aggregations. The following work: SELECT count(*) FROM source_livestock; +----------+ | count_ | +==========+ | 37898310 | +----------+ SELECT sex_code, count(*) FROM source_livestock GROUP BY sex_code; +----------+---------------+ | sex_code |count_sex_code | +==========+===============+ | M | 17505304 | | F | 20392997 | | null | 9 | +----------+---------------+ This last query came back amazingly quickly, about ten times faster than Postgres. Monet looks like a fairly amazing database if I can routinely expect queries to be this much faster. SELECT count(*); +--------------+ | single_value | +==============+ | 1 | +--------------+ but the following don't do what I'd expect: SELECT count(1); MAPI = monetdb@endemic:50001 ACTION= read_line QUERY = select count(1); ERROR = Connection terminated I'd expect to get a single row with a single value containing the number 1 from this query. And for the following query I'd expect to get the same, just with the result being zero. SELECT count(null); !syntax error, unexpected sqlNULL in: "select count(null" This is how I found the bug: SELECT sex_code, count(1) FROM source_livestock GROUP BY sex_code; !TypeException:user.s3_1[26]:'aggr.count_no_nil' undefined in: _36:bat[:any,:int] := aggr.count_no_nil(_35:bte, _31:bat[:oid,:oid], _32:bat[:oid,:oid]) !SQLException:sql.rsColumn:Cannot access descriptor !WARNING: BATdescriptor: range error 1 I've come to expect COUNT(*) and COUNT(1) as having the same semantics. But I may be missing something. SELECT sex_code, count(1+1) FROM source_livestock GROUP BY sex_code; !TypeException:user.s4_1[28]:'aggr.count_no_nil' undefined in: _39:bat[:any,:int] := aggr.count_no_nil(_38:bte, _32:bat[:oid,:oid], _33:bat[:oid,:oid]) +----------+---------------------+ | sex_code |sql_add_single_value | +==========+=====================+ | M | monetdb | +----------+---------------------+ This second one is particularly bad because I get an incorrect answer back. Any idea what I'm doing wrong? Thanks, Sam

2 13

[MonetDB-users] MonetDB Server dies on connect
by Robert Schumacher 17 Jun '08

17 Jun '08

Hello, i was evaluating MonetDB. Got the Server running finr on Windows XP x64. I created about 12 Tabled by using a JDBC Client, then the Server died instantly. Since then when I start the Server it dies asap when I either start the Windows Client or perform a JDBC connection. I get no error log, no message, nothing. Has anybody an idea how to get MonetDB to stop crashing on connect? Thanks, Robert Robert Schumacher, Senior Software Developer prevero Systems GmbH Landsberger Straße 154 80339 München Tel +49 89 455 77 - 0 Fax +49 89 455 77 - 200 Registergericht: Amtsgericht München, HRB 143809 -- Geschäftsführer: Matthias Thurner Bitte beachten Sie unsere Veranstaltungshinweise unter www.prevero.de

4 14

Re: [MonetDB-users] [Monetdb-developers] arrow keys not working in mclient in stable nightly
by Martin Kersten 16 Jun '08

16 Jun '08

Rt Ibmer wrote: > Hi - I use a SSH client to access my Fedora 8 core box. When I was using the RELEASE built I was able to use left/right/up/down/home/end keys within mclient to edit the line. For instance I could push up arrow to have it automatically cycle through the previous lines, and then use left arrow to move over to a part of the line and process to change it. > There have not been changes in that area. Running against the current also does not show the problem > That all worked fine under the RELEASE build. > > However now that I have built from source the nightly stable (as of a couple nights ago) I can no longer use these keys. For instance when I press UP arrow it simply adds "^[[A" to the line. Other arrow keys / home /end do something similar. > Nothing has changed in this area. I mostly use a Putty ssh client to access my machine and work with mclient. It works as expected. You may want to check the preference setting of the ssh client. > Not sure but I think something broke regarding this at some point between the released build and the stable nightly. Thanks. > > > > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >

2 1

Re: [MonetDB-users] replication in MonetDB
by Martin Kersten 15 Jun '08

15 Jun '08

Alexandru Toth wrote: > Hello, > > I'm the developer of Cubulus OLAP > (http://sourceforge.net/projects/cubulus/ ) . Hello Alexandru Welcome to the MonetDB user community. > > On the roadmap there is a hint about replication, coming in SQL 2.2 > (February 2008) release. Is it implemented ? If not, is it possible to use We have been experimenting with replication techniques. Some of the hooks have been included in the distribution. However, we are not yet satisfied and with the result. It remains on our R&D list to come up with a novel and efficient solution. > some existing software ex: http://dbreplicator.org/ Middleware solutions could potentially provide a short term solution. However, we don't know if they are powerful enough or require functionality currently not available in our JDBC driver. > > Or, is it possible to load data into "master", stop it, sync the > dbfarm to several slaves (into new directories), and re-start the > slaves with the new dbfarm path ? Of course, slaves are used as > read-only copies. ofcourse, provided you don't forget to copy the sql_logs as well. You can even instruct the server that the database is readonly. See the documentation : http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Storage-Modes.html regards, Martin > > -Alex > >

1 0

Re: [MonetDB-users] [Monetdb-developers] MonetDB Server dies on connect
by Martin Kersten 13 Jun '08

13 Jun '08

Sjoerd Mullender wrote: > Martin Kersten wrote: > >> Sjoerd, >> >> I was planning to try out the installers on my Vista machine. >> The previous version is v5.4.0 installed >> >> Uninstalling it gives the following error: >> There is a problem with this Windows Installer >> package. A program required for this install >> to complete could not be run. Contact your >> support personnel or package vendor. >> >> You want specific information, or should i manually >> remove the C:\Program Files\CWI/MonetDB5 >> > > Manually removing won't help unless you also edit the registry. > > My guess is that it complains about the uninstall of the ODBC driver. > Can you run > "C:\Program Files\CWI\MonetDB5\odbcinstall" /Uninstall > (I think that is the exact name) manually from a cmd window? > ran this program , which worked. However, uninstalling MonetDB still gives the same error.

2 1

[MonetDB-users] New default configure options for MonetDB
by Stefan Manegold 09 Jun '08

09 Jun '08

Dear MonetDB developer and users, For convenience of both developers and users as well as to comply even more with open source standards, we now set/use the following defaults for the configure options --enable-strict, --enable-assert, --enable-debug, --enable-optimize (Unless specified differently, the same defaults are used for both the "Stable" release branches and the "Current" development trunk.) When compiling from CVS sources (as mainly done by developers): strict=yes assert=yes debug=yes optimize=no (*) When compiling from packaged/distributed sources (i.e., tarballs) (as mainly done by users): strict=no assert=no debug=no optimize=no (*) For building binary distributions (RPMs, MSIs): strict=no assert=no debug=no optimize=yes With nightly testing for the "Stable" release branches: strict=yes assert=no debug=no optimize=yes With nightly testing for the "Current" development trunk: strict=yes assert=yes debug=no optimize=yes (*) IMPORTANT NOTE: Since "--enable-optimize=yes" is no longer the default for any case except binary packages, it is *strongly recommended* to (re)compile everything from scratch, *explicitly configured* with "--enable-debug=no --enable-optimize=yes", in case you want/need to run any performance experiments with MonetDB! (Please note: "--enable-X=yes" is equivalent to "--enable-X", and "--enable-X=no" is equivalent to "--disable-X".) Don't hesitate to ask in case you have any questions! Enjoy! Stefan -- | 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 |

1 0

Re: [MonetDB-users] [Monetdb-developers] Fastest way to calculate median?
by Martin Kersten 08 Jun '08

08 Jun '08

Rt Ibmer wrote: > Hi - I have an int column with several million rows of data. What is the fastest way to write a query to get the median value of the column? Apparently there is no median() function in SQL. A web search revealed lots of various talk about using stored procedures and fancy functions. None of this looked like it would be very efficient. I searched these archives but didn't see a single mention of median. Thank you! > True, the complexity of the median() in essence requires a partial sort of the complete list. It is a member of a group of statistical functions. A feature request has been added to the list. > > > > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >

1 0

[MonetDB-users] Moving records from SQL Server to MonetDB
by Rt Ibmer 07 Jun '08

07 Jun '08

Hi All - I'm new to monetdb and it looks fantastic! I have about 2 millions rows of data that I'd like to export from SQL Server and import them into Monetdb so I can do some preliminary benchmarking. What is the best way to do this? The schemas are the same for SQL Server and MonetDB. So basically I'm looking for the best command to run on SQL Server to export the data in a format best suited for importing into MonetDB, and what is the command to then load the data into MonetDB? Thanks!

1 0

[MonetDB-users] [Fwd: RE: PROBLEM WITH MONETDB 5.0]
by Martin Kersten 07 Jun '08

07 Jun '08

-------- Original Message -------- Subject: RE: PROBLEM WITH MONETDB 5.0 Date: Sat, 7 Jun 2008 23:16:13 +0800 From: Tran Quoc Trung <tqtrung(a)comp.nus.edu.sg> To: 'Martin Kersten' <Martin.Kersten(a)cwi.nl> References: <38563.137.132.80.35.1212469981.squirrel(a)mysoc.nus.edu.sg> <4844E431.2090403(a)cwi.nl> <3363.137.132.80.35.1212475247.squirrel(a)mysoc.nus.edu.sg> <4844F364.70601(a)cwi.nl> Hi Mr. Martin, I have installed MonetDB both by using monetdb-install.h and following the document for expert in the website on Ubuntu 2.6 64-bits. I can use the MonetDB server and client. However, when writing a program (in C) to connect to MonetDB, I encounter the error that libMapi.so require libc-2.7.so (The libc in my system is libc-2.5.so). Are there any solution to handle this situation (b/c I restrict not to upgrade the libc due to using the common server with other project). Could you please help me to take a look at this. Thank you very much Trung. -----Original Message----- From: Martin Kersten [mailto:Martin.Kersten@cwi.nl] Sent: Tuesday, 3 June, 2008 3:32 PM To: tqtrung(a)comp.nus.edu.sg; Communication channel for MonetDB users Subject: Re: PROBLEM WITH MONETDB 5.0 tqtrung(a)comp.nus.edu.sg wrote: > Hi, > Thank you very much. I also guess the reason due to the size of the > operands. Currently, I am running on Linux Fedora Core 8, 32 bit. The > cardinality of the opearand s in the range 100,000 to 1,500,000 records. > the sizes themselves are not a problem, but the expected size of the join result could be. you could take a sample to see how it explodes (algebra.sample()) > Are there any other solutions if my machine could not play with those > queries. > Please help me to check it again. > > Thanks, > Trung > > > >> tqtrung(a)comp.nus.edu.sg wrote: >> >>> Dear all, >>> I am a PhD student at School of Computing, NUS, Singapore. Currently, I >>> used MonetDB as the DBMS to do some experiments. I issue a query with >>> about 10 joins, but the system responds with the following errors: >>> >>> >> Please inform us about the platform and distribution you are useing. >> >>> !MALException:algebra.join:GDKerror >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> >>> >> this typically is an error when the join algorithm can not allocated >> enough memory >> to hold the intermediate result. For example, on a 32-bit system this >> might cause >> a problem quickly. >> If the join result should fit in memory, then there might be a problem >> in the >> estimation of the intermediate size needed. For this we need more >> information, >> such as the cardinality of the operands and properties obtained by >> bat.info() >> >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=tail.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=44/4401, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=44/4401, ext=tail.priv >>> >>> I also try to change the parameter in monetdb5.conf about the memory: >>> gdk_maxsize and gdk_vm_minsize but it still does NOT work. >>> >>> >> please don't play with these settings. They only control a thread for >> flushing dirty pages to disk. >> >>> Could you please help me to figure out which parameters I could change >>> to >>> make it work. >>> >>> Thank you very much >>> Trung >>> >>> >>> >> > >

1 0

[MonetDB-users] [Fwd: Re: php extension]
by Martin Kersten 06 Jun '08

06 Jun '08

-------- Original Message -------- Subject: Re: php extension Date: Fri, 6 Jun 2008 11:20:39 +1200 From: Kees Varekamp <kees.varekamp(a)gmail.com> To: Sjoerd Mullender <sjoerd(a)acm.org> CC: Niels Nes <Niels.Nes(a)cwi.nl>, monet(a)cwi.nl, Sjoerd Mullender <Sjoerd.Mullender(a)cwi.nl> References: <d8981ee0806042218l13609c8an47065c5b9a8354e9(a)mail.gmail.com> <20080605054117.GA350(a)cwi.nl> <4847D4D4.8020608(a)acm.org> <d8981ee0806050543w19dd0028gbb9327c5378549b1(a)mail.gmail.com> <4847EEFD.8080102(a)acm.org> Tnx. Na een herstart doet ie het! Groeten, Kees 2008/6/6 Sjoerd Mullender <sjoerd(a)acm.org <mailto:sjoerd@acm.org>>: Kees Varekamp wrote: > Bedankt! Hij start nu, ik ben weer een stap verder. > > Krijg nu een *Warning*: monetdb_connect() [function.monetdb-connect > <http://localhost/monet/function.monetdb-connect>]: Unable to connect to > MonetDB server: gethostbyname failed > > Het voorbeeldje op de website > (http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/The-PHP-Library.ht…) > connect als volgt: > $db = monetdb_connect('sql', 'localhost', 50000, 'monetdb','monetdb') > > De synopsis eronder vermeldt echter: > monetdb_connect([string host [, string port [, string username [, string > password [, string language]]]]] > > Beide returnen bovenstaande foutmelding (zowel met localhost als met > 127.0.0.1 <http://127.0.0.1> <http://127.0.0.1>). Welke is juist? En klopt het dat ik in > principe de php_pgsql.dll functies kan vertalen naar Monet functies? > > Het is niet kritiek trouwens, if all else fails zet ik een Linux machine op. Het ziet ernaar uit dat de synopsis niet correct is en de volgorde van de argumenten inderdaad is zoals in dat voorbeeld. Ik heb dit ook net geprobeerd en het werkt. De hostnaam wordt met de C functie gethostbyname vertaald. Zowel de string 'localhost' als '127.0.0.1 <http://127.0.0.1>' zou moeten werken, maar het ligt aan je Windows installatie. Je kunt experimenteren met php -a (in een cmd window) en dan: php > print gethostbyname('localhost'); Dat zou 127.0.0.1 <http://127.0.0.1> moeten printen. Je kunt ook de file c:\windows\system32\drivers\etc\hosts bekijken om te zien of er een entry in staat voor localhost. -- Sjoerd Mullender

1 0

Re: [MonetDB-users] PROBLEM WITH MONETDB 5.0
by Martin Kersten 03 Jun '08

03 Jun '08

tqtrung(a)comp.nus.edu.sg wrote: > Hi, > Thank you very much. I also guess the reason due to the size of the > operands. Currently, I am running on Linux Fedora Core 8, 32 bit. The > cardinality of the opearand s in the range 100,000 to 1,500,000 records. > the sizes themselves are not a problem, but the expected size of the join result could be. you could take a sample to see how it explodes (algebra.sample()) > Are there any other solutions if my machine could not play with those > queries. > Please help me to check it again. > > Thanks, > Trung > > > >> tqtrung(a)comp.nus.edu.sg wrote: >> >>> Dear all, >>> I am a PhD student at School of Computing, NUS, Singapore. Currently, I >>> used MonetDB as the DBMS to do some experiments. I issue a query with >>> about 10 joins, but the system responds with the following errors: >>> >>> >> Please inform us about the platform and distribution you are useing. >> >>> !MALException:algebra.join:GDKerror >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> >>> >> this typically is an error when the join algorithm can not allocated >> enough memory >> to hold the intermediate result. For example, on a 32-bit system this >> might cause >> a problem quickly. >> If the join result should fit in memory, then there might be a problem >> in the >> estimation of the intermediate size needed. For this we need more >> information, >> such as the cardinality of the operands and properties obtained by >> bat.info() >> >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=tail.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=44/4401, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=44/4401, ext=tail.priv >>> >>> I also try to change the parameter in monetdb5.conf about the memory: >>> gdk_maxsize and gdk_vm_minsize but it still does NOT work. >>> >>> >> please don't play with these settings. They only control a thread for >> flushing dirty pages to disk. >> >>> Could you please help me to figure out which parameters I could change >>> to >>> make it work. >>> >>> Thank you very much >>> Trung >>> >>> >>> >> > >

1 0

Re: [MonetDB-users] PROBLEM WITH MONETDB 5.0
by Martin Kersten 03 Jun '08

03 Jun '08

tqtrung(a)comp.nus.edu.sg wrote: > Dear all, > I am a PhD student at School of Computing, NUS, Singapore. Currently, I > used MonetDB as the DBMS to do some experiments. I issue a query with > about 10 joins, but the system responds with the following errors: > Please inform us about the platform and distribution you are useing. > !MALException:algebra.join:GDKerror > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > this typically is an error when the join algorithm can not allocated enough memory to hold the intermediate result. For example, on a 32-bit system this might cause a problem quickly. If the join result should fit in memory, then there might be a problem in the estimation of the intermediate size needed. For this we need more information, such as the cardinality of the operands and properties obtained by bat.info() > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=tail.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=tail.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=44/4401, ext=tail.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=44/4401, ext=tail.priv > > I also try to change the parameter in monetdb5.conf about the memory: > gdk_maxsize and gdk_vm_minsize but it still does NOT work. > please don't play with these settings. They only control a thread for flushing dirty pages to disk. > Could you please help me to figure out which parameters I could change to > make it work. > > Thank you very much > Trung > >

1 0

[MonetDB-users] Is it possible getting types IN params or result set?
by Marc Weber 29 May '08

29 May '08

Hi, I'd like to work on embedding query statements into the haskell language by using template haskell to automatically derive insert and select functions having proper types automatically. sqli for Java already does it. resulting in something as: (rows :: [ (Int, String) ]) = $( select "SELECT intV, stringV FROM table") $( ) means a function is automatically created returning a list of tules of type (Int, String). Because haskell is strongly typed the function select creating the the type safe function must get to know which type the query will return. When using INSERT statements it would be nice to also now which type of parameters have to be passed. Does MonetDB provide kind of query function WhichInOutTypesDoesQueryHave("SELECT ..") or WhichInOutTypesDoesQueryHave("INSERT INTO FOO (abc,def) VALUES (?,?)") This way syntax and semantics could be checked at compile time. Sincerly Marc Weber

3 5

[MonetDB-users] /bin/bash: ../Mx/Mx: No such file or directory
by Ying Zhang 28 May '08

28 May '08

Dear all, I'm trying to compile monet on my laptop But I already get a problem when I 'make' in buildtools: ../Mx/Mx -x C /home/jennie/monet/current/buildtools/mel/any_arg.mx /bin/bash: ../Mx/Mx: No such file or directory The directory Mx indeed contains too few files, but 'make' in Mx seems doing nothing: $ cd ../Mx $ ls config.log config.status Makefile mx_config.h stamp-h1 $ make make all-am make[1]: Entering directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' make[1]: Nothing to be done for `all-am'. make[1]: Leaving directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' $ ls config.log config.status Makefile mx_config.h stamp-h1 Sys. info: $ uname -a Linux 2.6.22-14-generic #1 SMP Tue Feb 12 07:42:25 UTC 2008 i686 GNU/Linux I did: bootstrap && configure && make && make install with the configure options: --prefix=$INSTALL_DIR --enable-strict --enable-assert --enable-debug --disable-optimize Does anyone have an idea why Mx is not generated by 'make'? Thanks! Jennie

2 1

Re: [MonetDB-users] (no subject)
by Martin Kersten 27 May '08

27 May '08

Yeo Yvonne wrote: > Dear Sir, > > I would like to find out more about MONETDB and the diffenerces > betwwen ORacle and MONETBD? Dear Yeo This is a question of comparing apples and oranges ;) There is no document available to compare the systems. Please have a look at the introductionary sections of the MonetDB manual. The rest is a study by itself. regards, Martin > > Thanks. > > With Regards, > Yvonne Yeo. >

3 2

[MonetDB-users] fedora core 9 repo or rpms?
by mobiledreamers＠gmail.com 23 May '08

23 May '08

Please share fc9 repos or how do we install monetdb in fc9 sudo yum -c /tmp/MonetDB-Stable-Fedora.repo resolvedep http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_lates…: [Errno 14] HTTP Error 404: Not Found Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: MonetDB-Stable. Please verify its path and try again *Forcing to use the 8 repo in 9 gives these errors* sudo yum -c /tmp/MonetDB-Release-Fedora.repo install MonetDB5-server MonetDB MonetDB-SQL-server5 Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: MonetDB-client >= 1.22 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Processing Dependency: libMapi.so.0 for package: MonetDB5-server ---> Package MonetDB-SQL-server5.i386 0:2.22.0-1.fc8.oid32 set to be updated --> Running transaction check ---> Package MonetDB-client.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB-client --> Processing Dependency: libcrypto.so.6 for package: MonetDB-client ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Finished Dependency Resolution MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release)

2 1

[MonetDB-users] MonetDB users
by Seth Grimes 23 May '08

23 May '08

Hello all, I've just joined the list to learn more about use of MonetDB. The DBMS looks quite interesting. Who's using it outside the research community at CWI? For what type and size of applications? Thanks, Seth -- Seth Grimes Alta Plana Corp, analytical computing & data management Intelligent Enterprise magazine (CMP), Contributing Editor grimes(a)altaplana.com http://altaplana.com 301-270-0795

1 0

[MonetDB-users] deep-equals function
by luc touraille 21 May '08

21 May '08

Hi everyone, I was wondering if the deep-equals function, described in the http://www.w3.org/TR/xpath-functions/#func-deep-equal W3C XQuery functions spec , was planned to be supported soon in MonetDB/XQuery. I saw on the CVS repository that the latest files of pathfinder included its signature, but I can't find its implementation. Can anyone enlighten me ? Thanks, Luc -- View this message in context: http://www.nabble.com/deep-equals-function-tp17364244p17364244.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Data Compression Algorithms
by Veneta Dobreva 20 May '08

20 May '08

Hello, I have the following question about MonetDB: does MonetDB implement some data compression algorithms? I would like to use an RLE (run-length encoding) algorithm for compression of my data. Is this already implemented in MonetDB? Thank you in advace for your help! Regards, Veneta Dobreva -- Dipl.-Inf. Veneta Dobreva Lehrstuhl Informatik III Tel.: ++49 (0)89 289-17288 Fakultät für Informatik Fax: ++49 (0)89 289-17263 TU München, Raum 02.11.041 MI veneta.dobreva(a)in.tum.de http://www-db.in.tum.de/~dobreva/

2 1

[MonetDB-users] MonetDB V 4.22 installation on Mac OS X 10.5.2 and Mac OS X 10.4.0.
by Irini Fundulaki 18 May '08

18 May '08

Hi, I have the following problems with MonetDB XQuery Release Feb 2008, V. 4.22 on Mac OS X 10.5.2 and Mac OS X 10.4.0. 1) Mac OS X 10.5.2: a) I was not able to install MonetDB from sources. I downloaded MonetDB-Feb2008-SuperBall.bz2 and followed the instructions in http://monetdb.cwi.nl/projects/monetdb//MonetDB/Documentation/Linux-Install…. I successfully installed MonetDB, clients and MonetDB4-server, but when installing MonetDB4-XQuery I had the following error: Undefined symbols: "_embedded_mil", referenced from: _main in prog.o ld: symbol(s) not found collect2: ld returned 1 exit status make[5]: *** [Mbeddedxq] Error 1 make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 b) by calling monetdb-install.sh. MonetDB was installed with no problems. Nevertheless, mclient with a simple query (e.g., <example>hello</example) stalled. Mserver stalled when executing xmldb_print(); 2) Mac OS X 10.4.0 a) I was able to install MonetDB XQuery Release Feb 2008, V. 4.22 using monetdb-install.sh. Mserver did not stall with xmldb_print(). mclient for the same query exhibited different behaviors: that is, sometimes it stalled, and others not (again, the same simple query as before). I had downloaded MonetDB on September 2007, and installed it on Mac OS X 10.4.0. I had no problem with that version. Thanks for looking into it, Irini

2 1