- users-list - monetdb.org

Re: [MonetDB-users] Running multiple mserver5 processes, Merovingian
by McKennirey.Matthew 19 Feb '08

19 Feb '08

2 2

Re: [MonetDB-users] New MonetDB Release
by Rahul Chopra 19 Feb '08

19 Feb '08

Congratulations on the release. I ran a TPC-H test on it. The majority of queries now seem slower Example: Query 21: 119 sec (was 18 sec), while others are closer, example: Query 13: 21 sec (was 18 sec). Did you verify performance for this release? It could be something I misconfigured for the new release, so take this with a grain of salt. Thanks. > ----- Original Message ----- > From: "Stefan Manegold" <Stefan.Manegold(a)cwi.nl> > To: monetdb-announce(a)lists.sourceforge.net > Subject: [MonetDB-users] New MonetDB Release > Date: Tue, 19 Feb 2008 13:51:24 +0100 > > > > The MonetDB team at CWI is pleased to announce the new "Feb2008" release of > the MonetDB suite of programs. > > This release marks the roll forward of the binary storage layout to a single > column storage layout. This involved a major overhaul of the MonetDB Server > code. > > IMPORTANT NOTE: > The database format of this release is not compatible with that of any > previous release. Before installing this release, make a dump of your > database, and do a restore afterwards. > > Further changes include: > > SQL: The functional extensions to SQL are limited. The mostly concern > minor bugs and some of the optimizers have been improved to better exploit > re-occurring joins. The core cracker code has been cleaned up for better > inspection and sharing in the community. > > XQuery: Next to the original Pathfinder compiler (nick-named > "milprint_summer" or simply "MPS"), the development of the new improved and > enhanced Algebra-based Pathfinder compiler ("ALG") is progressing quickly. > While the original MPS version remains the default in this release of > MonetDB/XQuery, a preview of the new ALG version is now available without > recompilation. > > JDBC & XRPC: The Java code (JDBC driver & XRPC wrapper) has been moved from > the clients and pathfinder source trees to a dedicated java source tree in > CVS, which can simply be compiled using "ant". > > Apart from this, many bugs have been fixed, and many speed improvements have > been made. See > http://monetdb.cwi.nl/Development/Releases/Version4.22/ > for more details. > > The new release consists of the following packages: > > MonetDB Common 1.22.0 > MonetDB Clients 1.22.0 > MonetDB4 Server 4.22.0 > MonetDB XQuery 0.22.0 > MonetDB5 Server 5.4.0 > MonetDB SQL 2.22.0 > monetdb-1.7-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. > > -- > | 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 | > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > = Fishing Vacation Deals at Hyatt® Book Your Hyatt Fishing Vacation Now. Best Rates Online Guaranteed. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=a0e62a460a6115c26a11780… -- Powered by Outblaze

4 3

[MonetDB-users] compression & temp space
by Rahul Chopra 19 Feb '08

19 Feb '08

Hello, Does MonetDB use compression at all? I saw something on the site that made me think it might be used for low cardinality columns, but it was not clear, and I could not find any other instances, like for long char columns. Also, are there any plans to allow for specifying a separate device to use for temp space? (Or, can I create a link somewhere on the filesystem?) I just notice that sometimes MonetDB uses an awful lot of virtual memory, and I/O quickly becomes the bottleneck when it no longer fits in RAM. Thanks. = Profit From On Hold Messages 20 Years experience. Custom messages, free equipment, no contracts. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=49dd4ae6b19ee653ce7d12b… -- Powered by Outblaze

1 0

Re: [MonetDB-users] Analyze
by Rahul Chopra 19 Feb '08

19 Feb '08

Thank you. So, the database on its own will collect selectivity statistics so that if there are multiple atomic conditions on a column, it will choose to apply the more selective one first? Thanks > ----- Original Message ----- > From: "Martin Kersten" <Martin.Kersten(a)cwi.nl> > To: "Communication channel for MonetDB users" <monetdb-users(a)lists.sourceforge.net> > Subject: Re: [MonetDB-users] Analyze > Date: Tue, 19 Feb 2008 14:35:48 +0100 > > > Dear Rahul > > thank you for your interest in MonetDB. > There is no such thing as ANALYZE or UPDATE STATISTICS. > They are not part of the SQL 99 standard > and its implementation would not make sense. > The database performance continuous analysis to optimize > execution using actual properties of the tables involved. > > regards, Martin > Rahul Chopra wrote: > > Is there the equivalent of ANALYZE or UPDATE STATISTICS in > > MonetDB? I tried both, but could not get them to work. > > > > Thanks! > > > > = > > embedded system > > UML 2.0-Based Software Engineering Using Model-Driven Development. > > http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=b006f31a35aad8826624507… > > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > = Sell Your Annuity If you are receiving payments from a structured settlement or annuity and need cash now, the Structured Settlement Alliance is here to help you get your cash now. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=fc012ccf36676d4eeec4d34… -- Powered by Outblaze

1 0

[MonetDB-users] protocol violation Unexpected line in data block
by sateesh 19 Feb '08

19 Feb '08

Hi All, When i try to fetch data from a table some times i am getting this error: It seems it has some thing to do with the type of characters that are being inserted. I am wondering why it didn't threw any exception while inserting but throwing the excep when trying to retrieve !! I hope this is not because of the sql client i am using..I tried using Squrriel and QuantumDB plugin of Eclipse. Here is the Stack Trace Error Executing: select * from dpa.collection_info:java.sql.SQLException: protocol violation: unexpected line in data block: . java.sql.SQLException: protocol violation: unexpected line in data block: . at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2048) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1798) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:371) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:340) at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.quantum.util.proxy.ProxyFactory$InvocationHandlerImpl.invoke(ProxyFactory.java:37) at $Proxy4.execute(Unknown Source) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:133) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:91) at com.quantum.actions.BaseExecuteAction.getSQLResults(BaseExecuteAction.java:202) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:174) at com.quantum.actions.ExecuteAction.execute(ExecuteAction.java:98) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:125) at com.quantum.actions.BaseExecuteAction.run(BaseExecuteAction.java:111) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1101) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3319) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169) -- View this message in context: http://www.nabble.com/protocol-violation-Unexpected-line-in-data-block-tp15… Sent from the monetdb-users mailing list archive at Nabble.com.

4 11

[MonetDB-users] Analyze
by Rahul Chopra 19 Feb '08

19 Feb '08

Is there the equivalent of ANALYZE or UPDATE STATISTICS in MonetDB? I tried both, but could not get them to work. Thanks! = embedded system UML 2.0-Based Software Engineering Using Model-Driven Development. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=b006f31a35aad8826624507… -- Powered by Outblaze

2 1

[MonetDB-users] Loading user-defined mal function on server start
by Michael 19 Feb '08

19 Feb '08

Hi, I'd like to place some MAL functions on the server and make them available asap the server starts. Placing a user.mal in the lib dir did not help. Placing in an existing file tells me that the appropriate module is not loaded and the datatypes I am using in are not available yet. Does that mean, that I have to place the functions when my app starts and opens the connection? Is there a desired way at all like the above? Thx, Mike -- <NO> OOXML - Say NO To Microsoft Office broken standard http://www.noooxml.org

2 1

[MonetDB-users] Trouble loading DLLs when called from scripting environment
by Yuvaraj Athur Raghuvir 19 Feb '08

19 Feb '08

Hello, I am using a language called J (www.jsoftware.com) What I have done so far is as follows: 1) Got the Mbedded example running in a C++ project 2) Moving the DLL interactions to J-MonetDB interactions by wrapping the main calls in my own dll called mdbdll.dll Everything is fine until I get to the call embedded_sql (set, setlen) in mdbdll.dll. What I see is that when the lib_sql.dll is loaded I get an access violation error and the program crashes. Is there any assumption on the location at which lib_sql.dll is loaded? Any other clues will be appreciated. Thanks, Yuva

1 0

[MonetDB-users] Windows 64-bit DBGEN
by Jos van Dongen 17 Feb '08

17 Feb '08

Hello, I want to run some TPC-H test on a Windows 64bit server. Does anyone have an executable version of the DBGEN tool which runs on Windows 64bit and will generate large (SF100 or more) files? Thanks in advance. Met vriendelijke groet/kind regards, Jos van Dongen Tholis Consulting T: 06-51169606 F: 0842-231136 M: jvdongen(a)tholis.com www.tholis.com No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1283 - Release Date: 16-2-2008 14:16

1 0

[MonetDB-users] Embedded Use: Persisting and Metadata
by Yuvaraj Athur Raghuvir 13 Feb '08

13 Feb '08

Finally, I have managed to get the Mbeddded example working in VC++ 2005 Express Edition on Windows XP ! Thanks to the folks in the mailing list. Use Case: MonetDB5 , Embedded Mode , SQL To move towards the application I intend to experiment on, I need some more information: 1) How to make data durable? In the simple example, I tried the following: a) First Run: Create table and insert rows. Select to check if everything is ok. b) Second Run: Only perform selection >> I get an error in the second run. 2) How to get meta data of the database? a) I want to know the size of the tables and meta tables in the data base. In particular I am interested in seeing the growth of the database on addition of content. b) Typically, there is a master table in the database that records information of the schema persisted. What is the name of the Master Table and its schema in MonetDB? c) SQLite has an independent analyzer tool which dumps the state of the storage from which I can extract most of the data I need. Does MonetDB have a similar mechanism? ~Yuva >>>> code snippet >>>>> dbh = embedded_sql (set, setlen); if (dbh == NULL || mapi_error(dbh)) die(dbh, hdl); /* switch off autocommit */ if (mapi_setAutocommit(dbh, 0) != MOK || mapi_error(dbh)) die(dbh,NULL); if ((hdl = mapi_query(dbh, "create table emp" " (name varchar(20),age int)")) == NULL || mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); for(i=0; i< 1000; i++) { char query[100]; _snprintf(query, 100,"insert into emp values(\'user%d\', %d)", i, (i % 82)); if ((hdl = mapi_query(dbh, query)) == NULL || mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); } if ((hdl = mapi_query(dbh, "select * from emp")) == NULL || mapi_error(dbh)) die(dbh, hdl); i=0; while (mapi_fetch_row(hdl)) { char *age = mapi_fetch_field(hdl, 1); i= i+ atoi(age); } if (mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); printf("The sum is %d \n",i); mapi_disconnect(dbh); return 0;

4 8

[MonetDB-users] How to convert time from seconds to Year Month Day...
by Iftikharn 11 Feb '08

11 Feb '08

Thanks to people out there for providing excellent answers. I have time values in the form of seconds since 1970/01/01 00:00:00.000 GMT e.g. "1087488000". How could I convert them into Year, Month, Day, Hour, Minute, and Second. Iftikhar -- View this message in context: http://www.nabble.com/How-to-convert-time-from-seconds-to-Year-Month-Day...… Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] monetdb x100
by Cam Bazz 08 Feb '08

08 Feb '08

hello, I could not find a download for monetdb x100. is that a part of monetdb? Best.

2 1

[MonetDB-users] How to import tables along with data from MS Access into MonetDB
by Iftikharn 07 Feb '08

07 Feb '08

Hi Could any one kindly tell me how to import tables and data from MS Access into MonetDB. Regards, Iftikharn -- View this message in context: http://www.nabble.com/How-to-import-tables-along-with-data-from-MS-Access-i… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] MonetDB database server (Merovingian) is not running
by Iftikharn 06 Feb '08

06 Feb '08

Hi In MonetDB I want to create my own database "test" In one console I turned the mserver5 on by $mserver5 --dbinit="include sql;" # MonetDB server v5.2.0, based on kernel v1.20.0 # Serving database 'demo' # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.20.0 loaded > In another concole, I issued the following command $monetdb create test The following message appears: Warning: MonetDB database server is not running successfully created database 'test' $monetdb status test monetdb status test name state uptime crashes test stopped 0 And $monetdb start test start: cannot perform: MonetDB Server (merovingian) is not running mserver5 is already running, how to run merovingian? I tried at the prompt $merovingian $ nothing happens Could any one help me to create my own database rather than the default one 'demo'. Regards, Iftikhar -- View this message in context: http://www.nabble.com/MonetDB-database-server-%28Merovingian%29-is-not-runn… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Accessing MonetDB with MAL through JBDC
by Michael 06 Feb '08

06 Feb '08

Hi folks, I just installed MonetDB. I tried to run the simplest examples and failed. :-( The MAL Reference does not semm really helpful though to me. My questions is, is it possible to use the DB as an embedded server with a Java application? The exampled displayed a C example only. Is it possible to communicate to the server with MAL? I want to write a backend for the Apache Directory Server. I want MonetDB to be it. I want to transform LDAP requests to MAL and get results back form the server. Is this possible at all with this DB? FYI: I am a C illiterate Mike -- <NO> OOXML - Say NO To Microsoft Office broken standard http://www.noooxml.org

5 10

Re: [MonetDB-users] (MonetWeb) monetweb/Docs manual.texi, Stable_2008-02-03, 1.37.2.3, 1.37.2.4
by Martin Kersten 04 Feb '08

04 Feb '08

This is not good and a remnant of Peter's attempt to get the Xquery stuff in. I did not have the time to correct it in a way that all intended results are available. Stefan Manegold wrote: > Update of /ufs/monet/repository/monetweb/Docs > In directory corona.ins.cwi.nl:/tmp/cvs-serv22830/Docs > > Modified Files: > Tag: Stable_2008-02-03 > manual.texi > Log Message: > > since I do not know, whether all these .texi files are supposed to exist, > or whether the reference to them are just legacy, > I (try to) comment them out, > to hope fully get (at least) a tiny step further with building the web site ... > > XQuery/Apache.texi > XQuery/POSIX.texi > XQuery/Windows.texi > XQuery/intro.texi > XQuery/Overview.texi > XQuery/DocMgmt.texi > XQuery/ListDoc.texi > XQuery/AddDoc.texi > XQuery/DelDoc.texi > XQuery/DocOther.texi > XQuery/Xquery.texi > XQuery/Functions.texi > XQuery/xrpc.texi > XQuery/FAQ.texi > > > Index: manual.texi > =================================================================== > RCS file: /ufs/monet/repository/monetweb/Docs/manual.texi,v > retrieving revision 1.37.2.3 > retrieving revision 1.37.2.4 > diff -u -d -r1.37.2.3 -r1.37.2.4 > --- manual.texi 4 Feb 2008 17:58:15 -0000 1.37.2.3 > +++ manual.texi 4 Feb 2008 18:21:05 -0000 1.37.2.4 > @@ -258,14 +258,15 @@ > @include MonetDB/iSQL-Viewer.texi > > @node Apache Configuration, CGI Interface, iSQL-Viewer, Client Interfaces > +@c @include XQuery/Apache.texi > @include XQuery/Security.texi > > @node CGI Interface, POSIX Interface, Apache Configuration, Client Interfaces > @include XQuery/CGI.texi > @node POSIX Interface, Windows Interface, CGI Interface, Client Interfaces > -@include XQuery/POSIX.texi > +@c @include XQuery/POSIX.texi > @node Windows Interface , SQL Reference, POSIX Interface, Client Interfaces > -@include XQuery/Windows.texi > +@c @include XQuery/Windows.texi > > @c ---------------------- SQL PART > @node SQL Reference, SQL Core, Windows Interface , Top > @@ -286,13 +287,13 @@ > > @node XQuery Reference, XQuery Overview, External Functions , Top > @chapter XQuery > -@include XQuery/intro.texi > +@c @include XQuery/intro.texi > > @node XQuery Overview, Database Scaleability, XQuery Reference , XQuery Reference > -@include XQuery/Overview.texi > +@c @include XQuery/Overview.texi > > @node Document Management, Document Collection, Pathfinder Project,XQuery Reference > -@include XQuery/DocMgmt.texi > +@c @include XQuery/DocMgmt.texi > @menu > * Document Collection:: > * Add Document:: > @@ -302,20 +303,20 @@ > @end menu > > @node Document Collection , Add Document, Document Management, Document Management > -@include XQuery/ListDoc.texi > +@c @include XQuery/ListDoc.texi > @node Add Document, Remove Document, Document Collection, Document Management > -@include XQuery/AddDoc.texi > +@c @include XQuery/AddDoc.texi > @node Remove Document, Cache Policy, Add Document, Document Management > -@include XQuery/DelDoc.texi > +@c @include XQuery/DelDoc.texi > @node Cache Policy, Miscellaneous, Remove Document, Document Management > @include XQuery/Cache.texi > @node Miscellaneous, Supported Functions, Cache Policy, Document Management > -@include XQuery/DocOther.texi > +@c @include XQuery/DocOther.texi > > @node Supported Functions, Prepared Queries , Miscellaneous , XQuery Reference > @section Supported Functions > -@include XQuery/Xquery.texi > -@include XQuery/Functions.texi > +@c @include XQuery/Xquery.texi > +@c @include XQuery/Functions.texi > > @node Prepared Queries, StandOff Extensions , Supported Functions ,XQuery Reference > @include XQuery/PreparedQueries.texi > @@ -325,10 +326,10 @@ > @include XQuery/Standoff.texi > > @node XRPC Extention, XQuery FAQ, Why StandOff Extensions?, XQuery Reference > -@include XQuery/xrpc.texi > +@c @include XQuery/xrpc.texi > > @node XQuery FAQ, Design Overview, SOAP Protocol, Top > -@include XQuery/FAQ.texi > +@c @include XQuery/FAQ.texi > > @c ---------------------- MAL Design PART > > >

1 0

[MonetDB-users] embedded SQL server under Windows
by Grigorio V. Moshkin 04 Feb '08

04 Feb '08

Hi, I've installed MonetDB/SQL/32bit under Windows, but I can't find DLL or LIB for embedded server. Although, MonetDB documentation mentioned embedded libraries for UNIX-like system: http://monetdb.cwi.nl/projects/monetdb/MonetDB/Documentation/A-Simple-Examp… But, what about Windows? Can I use MonetDB under Windows in embedded mode?

6 12

[MonetDB-users] MonetDB - backup, restore, transaction logs?
by Артур Суилин 04 Feb '08

04 Feb '08

I have a questions regarding MonetDB readiness for 24h per day production server usage: 1. Does it have any method for online (hot) full backup? Manual says about database dumps via mclient. Are they intended only for database transporation? Can I perform online backup via dump? What about data modifications/uncommited transactions during dump? 2. What about incremental backups? It seems MonetDB have some kind of transaction logs? How can I use them? 3. Does it have any defence against unexpected server crash? Manual says that checkpoint/recovery facility exists, but still not completely implemented/tested? 4. In the case of server crash and database corruption - how can I return database to consistent state? Does it have any tool like myisamchk for MySQL? Thank you. -- Arthur Suilin

1 0

[MonetDB-users] How to reset the password for a DB Insatnce
by sateesh 01 Feb '08

01 Feb '08

Hi All, How can i reset the password for a given DB Instance. Some how the default password monetdb is not getting accepted.. Thanks Sateesh -- View this message in context: http://www.nabble.com/How-to-reset-the-password-for-a-DB-Insatnce-tp1519457… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] JDBC Driver Problem with the new Build..
by sateesh 01 Feb '08

01 Feb '08

HI All, We got the latest build and the JDBC Driver seems to be giving lot of problems.. When i try to view the tables for a given schema it doesn't show any even if there are tables. ( if i execute a select query it returns the results..) Also when i execute a query i am getting the following Error after the results.. [ERROR] Exception in ResultSet for "MYSCHEMA" java.sql.SQLException: Method not implemented yet, sorry! at nl.cwi.monetdb.jdbc.MonetResultSet.getCharacterStream(MonetResultSet.java:294) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.quantum.util.proxy.ProxyFactory$InvocationHandlerImpl.invoke(ProxyFactory.java:37) at $Proxy3.getCharacterStream(Unknown Source) at com.quantum.sql.SQLStandardResultSetResults.getStringFromCharacterSteam(SQLStandardResultSetResults.java:250) at com.quantum.sql.SQLStandardResultSetResults.parseResultSet(SQLStandardResultSetResults.java:147) at com.quantum.sql.SQLStandardResultSetResults.create(SQLStandardResultSetResults.java:69) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:139) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:91) at com.quantum.actions.BaseExecuteAction.getSQLResults(BaseExecuteAction.java:202) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:174) at com.quantum.actions.ExecuteAction.execute(ExecuteAction.java:98) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:125) at com.quantum.actions.BaseExecuteAction.run(BaseExecuteAction.java:111) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1101) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3319) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169) [/ERROR] thanks sateesh -- View this message in context: http://www.nabble.com/JDBC-Driver-Problem-with-the-new-Build..-tp15205660p1… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] Running multiple mserver5 processes, Merovingian port allocation
by McKennirey.Matthew 01 Feb '08

01 Feb '08

2 1

[MonetDB-users] ALTER TABLE doesn't work in MonetDB !!
by sateesh 30 Jan '08

30 Jan '08

Hi All, I am trying to add columns at the run time to one of the Tables and i am getting an error No Such Table. But when i try to select values from the table i get the values ( there are no rows in this table and no key columns as well..) Here is the Error: [CODE] Error Executing: ALTER TABLE collection_1234.collection_info add customer_a_name varchar(256):java.sql.SQLException: ALTER TABLE: no such table 'collection_info' java.sql.SQLException: ALTER TABLE: no such table 'collection_info' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2048) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1798) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:371) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:340) at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.quantum.util.proxy.ProxyFactory$InvocationHandlerImpl.invoke(ProxyFactory.java:37) at $Proxy4.execute(Unknown Source) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:133) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:91) at com.quantum.actions.BaseExecuteAction.getSQLResults(BaseExecuteAction.java:202) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:174) at com.quantum.actions.ExecuteAction.execute(ExecuteAction.java:98) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:125) at com.quantum.actions.BaseExecuteAction.run(BaseExecuteAction.java:111) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1101) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3319) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169) SQL (DPACUSTOMER1) [select * from collection_1234.collection_info] Success: result set displayed [/CODE] Is this a bug or am i missing some thing ?? Thanks Sateesh -- View this message in context: http://www.nabble.com/ALTER-TABLE-doesn%27t-work-in-MonetDB-%21%21-tp151680… Sent from the monetdb-users mailing list archive at Nabble.com.

2 5

Re: [MonetDB-users] subscribe
by Yuvaraj Athur Raghuvir 30 Jan '08

30 Jan '08

Hello, I am experimenting with in-memory row-based & column-based stores. For the row-based store I am using SQLite. For the column-based, I am proposing to use MonetDB. In this context, I would like to join the mailing list. I am working on Windows XP / 32 and would like to use MonetDB as a DLL. Regards, Yuva

1 0

[MonetDB-users] SQL Function to remove all alpha characters
by Venks 28 Jan '08

28 Jan '08

Hi, Does MonetDB has regular expression support in SQL? I am looking to remove all alpha characters in a column value and wondering if there is a better way to do so rather than removing one character at a time. Thanks, -Venks

3 2

[MonetDB-users] Crash during COPY INTO on --nightly=stable 2008-01-21
by Bob Ippolito 23 Jan '08

23 Jan '08

So here's the core dump for our ETL test with --nightly=stable. We have not yet tried to restart mserver5. Here's some stats on the data dirs: $ du -sh * 10G bat 4.0K box 5.6G core.6950 $ find bat|wc -l 777933 (box is an empty dir) Core was generated by `//mochi/bin/mserver5 --dbname=mochiads_stats --dbinit=include sql; --dbfarm=/da'. Program terminated with signal 6, Aborted. #0 0x00002b5e2eb77cab in raise () from /lib/libc.so.6 (gdb) bt #0 0x00002b5e2eb77cab in raise () from /lib/libc.so.6 #1 0x00002b5e2eb79660 in abort () from /lib/libc.so.6 #2 0x00002b5e2ebaf66b in ?? () from /lib/libc.so.6 #3 0x00002b5e2ebb6b23 in ?? () from /lib/libc.so.6 #4 0x00002b5e2ebba26c in free () from /lib/libc.so.6 #5 0x00002b5e2d18f63e in GDKfree (blk=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_utils.mx:1140 #6 0x00002b5e2d12bd2d in HEAPfree (h=0x1e7270d0) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_heap.mx:265 #7 0x00002b5e2d1d3a50 in BATfree (b=0x1e726f98) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_bat.mx:522 #8 0x00002b5e2d129d3e in BBPfree (b=0x1e726f98, calledFrom=0x2b5e2d2eb338 "BBPtrim") at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_bbp.mx:1748 #9 0x00002b5e2d12a841 in BBPtrim (memtarget=0, vmtarget=0) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_bbp.mx:2081 #10 0x00002b5e2d190d7d in GDKmemchk (memchk=1, vmchk=761245848) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_utils.mx:688 #11 0x00002b5e2d19166d in GDKvmalloc (size=707393416, maxsize=0x42801688, emergency=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_utils.mx:1306 #12 0x00002b5e2d191b30 in GDKmallocmax (size=<value optimized out>, maxsize=0x3439f438, emergency=0) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_utils.mx:1051 #13 0x00002b5e2d12c630 in HEAPalloc (h=0x3439f438, nitems=88424175, itemsize=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_heap.mx:127 #14 0x00002b5e2d115a02 in HASHnew (hp=0x1b26, tpe=6, size=21315311, mask=18446744073709551615) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_search.mx:289 #15 0x00002b5e2d116fc4 in BAThash (b=0x2aab2d943118, masksize=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_search.mx:383 #16 0x00002b5e2d253853 in BAThashjoin (l=0x190, r=0x2aab2d943118, estimate=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_relop.mx:426 #17 0x00002b5e2d2501aa in batjoin (l=0x2aab9c1f6128, r=0x2aabb04f49f8, estimate=9223372036854775808, swap=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_relop.mx:1157 #18 0x00002b5e2d25050b in BATjoin (l=0x1b26, r=0x2356, estimate=6) at /scratch/monet.GNU.64.64.d.29168/MonetDB/src/gdk/gdk_relop.mx:1168 #19 0x00002aaab14a5302 in ALGjoinPath (mb=<value optimized out>, stk=0x2aab56174f18, pci=0x245b2378) ---Type <return> to continue, or q <return> to quit--- at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/optimizer/opt_joinpath.mx:223 #20 0x00002b5e2c880504 in runMALsequence (cntxt=0x604980, mb=0x2aab697741b8, startpc=1, stoppc=0, stk=0x2aab56174f18, env=0x0, pcicaller=0x0) at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/mal/mal_interpreter.mx:1159 #21 0x00002b5e2c8821cb in callMAL (cntxt=0x604980, mb=0x2aab697741b8, env=0x42803fd8, argv=0x42803fb0, debug=0 '\0') at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/mal/mal_interpreter.mx:377 #22 0x00002aaab266d19c in SQLexecutePrepared (cntxt=0x604980, be=<value optimized out>, q=0x2aab1c3ca488) at /scratch/monet.GNU.64.64.d.29168/sql/src/backends/monet5/sql_scenario.mx:1188 #23 0x00002aaab266ed0d in SQLengineIntern (c=0x604980, be=0x2aab140554d8) at /scratch/monet.GNU.64.64.d.29168/sql/src/backends/monet5/sql_scenario.mx:1273 #24 0x00002b5e2c8a105d in runScenarioBody (c=0x604980) at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/mal/mal_scenario.mx:558 #25 0x00002b5e2c8a113a in runScenario (c=0x1b26) at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/mal/mal_scenario.mx:622 #26 0x00002b5e2c87c1d8 in MSserveClient (dummy=<value optimized out>) at /scratch/monet.GNU.64.64.d.29168/MonetDB5/src/mal/mal_session.mx:471 #27 0x00002b5e2df362a5 in start_thread () from /lib/libpthread.so.0 #28 0x00002b5e2ec1661d in clone () from /lib/libc.so.6 #29 0x0000000000000000 in ?? () (gdb) And this is the log of everything printed by mserver5: !WARNING: GDKlockHome: created directory /data/db/monetdb/mochiads_stats/ !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB server v5.2.3, based on kernel v1.20.1 # Serving database 'mochiads_stats' # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /mochi/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.20.3 loaded >*** glibc detected *** //mochi/bin/mserver5: free(): invalid pointer: 0x00002aae5199e008 *** ======= Backtrace: ========= /lib/libc.so.6[0x2b5e2ebb6b23] /lib/libc.so.6(cfree+0x8c)[0x2b5e2ebba26c] /mochi/lib/libbat.so.0(GDKfree+0x2e)[0x2b5e2d18f63e] /mochi/lib/libbat.so.0(HEAPfree+0xad)[0x2b5e2d12bd2d] /mochi/lib/libbat.so.0(BATfree+0x1f0)[0x2b5e2d1d3a50] /mochi/lib/libbat.so.0[0x2b5e2d129d3e] /mochi/lib/libbat.so.0(BBPtrim+0x851)[0x2b5e2d12a841] /mochi/lib/libbat.so.0[0x2b5e2d190d7d] /mochi/lib/libbat.so.0(GDKvmalloc+0xdd)[0x2b5e2d19166d] /mochi/lib/libbat.so.0(GDKmallocmax+0xf0)[0x2b5e2d191b30] /mochi/lib/libbat.so.0(HEAPalloc+0x170)[0x2b5e2d12c630] /mochi/lib/libbat.so.0(HASHnew+0x32)[0x2b5e2d115a02] /mochi/lib/libbat.so.0(BAThash+0x334)[0x2b5e2d116fc4] /mochi/lib/libbat.so.0(BAThashjoin+0x3193)[0x2b5e2d253853] /mochi/lib/libbat.so.0[0x2b5e2d2501aa] /mochi/lib/libbat.so.0(BATjoin+0xb)[0x2b5e2d25050b] /mochi/lib/MonetDB5/lib/lib_optimizer.so(ALGjoinPath+0x222)[0x2aaab14a5302] /mochi/lib/libmal.so.0[0x2b5e2c880504] /mochi/lib/libmal.so.0(callMAL+0x25b)[0x2b5e2c8821cb] /mochi/lib/MonetDB5/lib/lib_sql.so(SQLexecutePrepared+0x25c)[0x2aaab266d19c] /mochi/lib/MonetDB5/lib/lib_sql.so(SQLengineIntern+0x21d)[0x2aaab266ed0d] /mochi/lib/libmal.so.0(runScenarioBody+0x14d)[0x2b5e2c8a105d] /mochi/lib/libmal.so.0(runScenario+0x3a)[0x2b5e2c8a113a] /mochi/lib/libmal.so.0(MSserveClient+0x58)[0x2b5e2c87c1d8] /lib/libpthread.so.0[0x2b5e2df362a5] /lib/libc.so.6(clone+0x6d)[0x2b5e2ec1661d] ======= Memory map: ======== 00400000-00404000 r-xp 00000000 fe:00 2115695 /mochi/bin/mserver5 00604000-00605000 rw-p 00004000 fe:00 2115695 /mochi/bin/mserver5 00605000-3ffec000 rw-p 00605000 00:00 0 [heap] 40000000-40001000 ---p 40000000 00:00 0 40001000-40801000 rw-p 40001000 00:00 0 40801000-40802000 ---p 40801000 00:00 0 40802000-41002000 rw-p 40802000 00:00 0 41002000-41003000 ---p 41002000 00:00 0 41003000-41803000 rw-p 41003000 00:00 0 41803000-41804000 ---p 41803000 00:00 0 41804000-42004000 rw-p 41804000 00:00 0 42004000-42005000 ---p 42004000 00:00 0 42005000-42805000 rw-p 42005000 00:00 0 2aaaaabaf000-2aaaaabb3000 r-xp 00000000 fe:00 2085181 /mochi/lib/MonetDB5/lib/lib_mdb.so.0.0.0 2aaaaabb3000-2aaaaadb3000 ---p 00004000 fe:00 2085181 /mochi/lib/MonetDB5/lib/lib_mdb.so.0.0.0 2aaaaadb3000-2aaaaadb4000 rw-p 00004000 fe:00 2085181 /mochi/lib/MonetDB5/lib/lib_mdb.so.0.0.0 2aaaaadb4000-2aaaaadb6000 r-xp 00000000 fe:00 2084480 /mochi/lib/MonetDB5/lib/lib_xml.so.0.0.0 2aaaaadb6000-2aaaaafb5000 ---p 00002000 fe:00 2084480 /mochi/lib/MonetDB5/lib/lib_xml.so.0.0.0 2aaaaafb5000-2aaaaafb6000 rw-p 00001000 fe:00 2084480 /mochi/lib/MonetDB5/lib/lib_xml.so.0.0.0 2aaaaafbd000-2aaaab03e000 r-xp 00000000 fe:00 540697 /lib/libm-2.5.so 2aaaab03e000-2aaaab23d000 ---p 00081000 fe:00 540697 /lib/libm-2.5.so 2aaaab23d000-2aaaab23f000 rw-p 00080000 fe:00 540697 /lib/libm-2.5.so 2aaaab23f000-2aaaab24d000 r-xp 00000000 fe:00 2016109 /mochi/lib/libMapi.so.0.0.0 2aaaab24d000-2aaaab44c000 ---p 0000e000 fe:00 2016109 /mochi/lib/libMapi.so.0.0.0 2aaaab44c000-2aaaab44d000 rw-p 0000d000 fe:00 2016109 /mochi/lib/libMapi.so.0.0.0 2aaaab44d000-2aaaab44e000 r-xp 00000000 fe:00 2085120 /mochi/lib/MonetDB5/lib/lib_unix.so.0.0.0 2aaaab44e000-2aaaab64d000 ---p 00001000 fe:00 2085120 /mochi/lib/MonetDB5/lib/lib_unix.so.0.0.0 2aaaab64d000-2aaaab64e000 rw-p 00000000 fe:00 2085120 /mochi/lib/MonetDB5/lib/lib_unix.so.0.0.0 2aaaab64e000-2aaaab650000 r-xp 00000000 fe:00 2085099 /mochi/lib/MonetDB5/lib/lib_lock.so.0.0.0 2aaaab650000-2aaaab84f000 ---p 00002000 fe:00 2085099 /mochi/lib/MonetDB5/lib/lib_lock.so.0.0.0 2aaaab84f000-2aaaab850000 rw-p 00001000 fe:00 2085099 /mochi/lib/MonetDB5/lib/lib_lock.so.0.0.0 2aaaab850000-2aaaab851000 r-xp 00000000 fe:00 2085118 /mochi/lib/MonetDB5/lib/lib_sema.so.0.0.0 2aaaab851000-2aaaaba51000 ---p 00001000 fe:00 2085118 /mochi/lib/MonetDB5/lib/lib_sema.so.0.0.0 2aaaaba51000-2aaaaba52000 rw-p 00001000 fe:00 2085118 /mochi/lib/MonetDB5/lib/lib_sema.so.0.0.0 2aaaaba52000-2aaaaba57000 r-xp 00000000 fe:00 2085116

2 1