- users-list - monetdb.org

[MonetDB-users] Announcement: New feature release of MonetDB suite
by Sjoerd Mullender 05 Jun '09

05 Jun '09

The MonetDB team at CWI/MonetDB BV are pleased to announce the new "May2009" feature release of the MonetDB suite of programs. This is a feature release, however it is is (mostly) backward compatible with the previous releases (Nov2008 and Feb2009). The two slight incompatibilities are: - The way string data is stored was changed for 64-bit architectures with 32-bit OIDs. There is however an automatic conversion on startup of the server. The biggest problem is, you can't go back to an older version once the new version has run. This incompatibility affects only the Windows 64 bit build (the other 64 bit builds use 64-bit OIDs). - The default location of the write-ahead log (WAL) has changed. This is relevant for both MonetDB5/SQL and MonetDB4/XQuery on all platforms. When the server first starts on an existing database, it will notice that the WAL is missing and will refuse to continue with a message which indicates where the WAL is now expected. You can either use a command line option to tell the server where the WAL is, or you can manually move the WAL to the new location. This latter option is done automatically on Windows when you use the Start menu to start the server. More information on the new release (and the above mentioned incompatibilities) is available at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/May2009/>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

2 1

[MonetDB-users] May 2009 Windows binaries - no Python bindings
by Pawel Lewicki 05 Jun '09

05 Jun '09

Hi, Would it be possible to get compiled Windows Python bindings? They are missing in installer and previous version is not compatible with recent server. Paweł Lewicki

2 1

Re: [MonetDB-users] [Monetdb-developers] problems with starting the monetDB4xquery server + ATTACHEMENTS
by Mtekel 04 Jun '09

04 Jun '09

This mail contains attached files I described in the previous one... Michael -----Original Message----- From: Ying Zhang [mailto:Y.Zhang@cwi.nl] Sent: 2. júna 2009 10:41 To: Mtekel Cc: monetdb-developers(a)lists.sourceforge.net Subject: Re: [Monetdb-developers] problems with starting the monetDB4xquery server Hello Michael, Thanks for using MonetDB, and sorry for the inconvenience! Your problem has been reported earlier. Unfortunately, we don't have a solution for this problem at this moment. However, there is a workaround, which seems to work according to other users. So please have a look at the following bug report (the workaround is in the report): http://sourceforge.net/tracker/index.php?func=detail&aid=2693363&group_id=56 967&atid=482468 Kind regards, Jennie On Mon, Jun 01, 2009 at 10:55:45AM +0200, Mtekel wrote: > Hello, > > I have problems starting the monetDB xquery server under windowsXP sp3. When > I click on the link in the start menu, dos window appears but then it closes > immediatelly and I can't see what's there (after pausing I can see only the > first 6 lines of the program output as described below, then after unpausing > it immediatelly quits and closes the window). If I run MXQserver.bat, or > Mserver.bat --dbinit="module(pathfinder);" I get only this: > > # MonetDB Server v4.28.4 > # based on GDK v1.28.4 > # Copyright (c) 1993-July 2008, CWI. All rights reserved. > # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. > # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah > > That's all. The server immediatelly ends. However If I run only Mserver.bat, > the server "runs" - I get the prompt, but for example I can't connect to the > web interface on the port 50000. > > Does anyone have any advice what to do? How to make it work? > Any advice appreciated, > > Best regards > > Michael > > > ---------------------------------------------------------------------------- -- > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp as they present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers

1 0

[MonetDB-users] Best way to lookup a varchar field?
by Henri Asseily 04 Jun '09

04 Jun '09

Hi, I've got a very simple table structure in SQL, with a non-unique varchar field and a few other fields including a CLOB. I found that it's abnormally slow to filter the varchar field with an 'IN' statement and simply return the CLOB. i.e.: select clob from x where varchar in ('a','b','c') With a couple million rows, the query is in multiple seconds if the results are around a couple thousand rows. Is there something I'm doing wrong? I should be just the varchar BAT filter, then join on the CLOB BAT. Should I manually assign the varchars to integers in another table and use ints on this table? That would be surprising... Thanks. H

2 1

[MonetDB-users] Memory Allocation errors
by Rob Wickert 04 Jun '09

04 Jun '09

Hi all, I've been testing MonetDB and I've been getting strange memory allocation errors while running large 'group by' queries. From a dataset of around 60GB, I'm running 'group by' queries against it to test for speed. Queries of the sort: select keyword, count(*) as c from raw_data group by keyword order by c desc limit 100; What's happening is that it will trundle along ok for a while, generally consuming all the available memory (98%) on 3GB box. But after a while I get these messages on the server: # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.28.4 loaded >#GDKmmap(10412883968) fails, try to free up space [memory in use=72431192,virtual memory in use=71134150656] #GDKmmap(10412883968) result [mem=71387384,vm=71134150656] #GDKvmalloc(10412883984) fails, try to free up space [memory in use=71386904,virtual memory in use=71134150656] #GDKvmalloc(10412883984) result [mem=71130480,vm=71134150656] !ERROR: HEAPalloc: Insufficient space for HEAP of 10412883968 bytes. Also while checking top it will reports a much large RES size than physical memory. E.g. (250% for %MEM). I haven't changed any out of the box settings. Is there a minimum memory size that MonetDB requires to play nice? Is there anywhere I can go to limit the amount of memory MonetDB requires? The version I'm using is: mserver5 --version MonetDB server v5.10.4 (64-bit), based on kernel v1.28.4 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /usr Libraries: libpcre: 6.6 06-Feb-2006 (compiled with 6.6) openssl: OpenSSL 0.9.8e-rhel5 01 Jul 2008 (compiled with OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008) libxml2: 2.6.26 (compiled with 2.6.26) Compiled by: mockbuild(a)surya.karan.org Compilation: gcc -O2 -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize Linking : ld -IPA -m elf_x86_64 Cheers

2 3

[MonetDB-users] LIKE queries failing
by Rob Wickert 04 Jun '09

04 Jun '09

Hi all, I'm having problems with MonetDB5 while performing LIKE queries against it. Normal queries work fine, but anything with a LIKE in it gets this response: sql> select * from raw_data where keyword like 'apple%' limit 1; !MALException:batcalc.str:can not create bat 0 tuples Any ideas? This is the version of mserver5 I'm using: MonetDB server v5.10.4 (64-bit), based on kernel v1.28.4 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /usr Libraries: libpcre: 6.6 06-Feb-2006 (compiled with 6.6) openssl: OpenSSL 0.9.8e-rhel5 01 Jul 2008 (compiled with OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008) libxml2: 2.6.26 (compiled with 2.6.26) Compiled by: mockbuild(a)surya.karan.org Compilation: gcc -O2 -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize Linking : ld -IPA -m elf_x86_64 Cheers

2 1

[MonetDB-users] MonetDB and NFS
by Mag Gam 04 Jun '09

04 Jun '09

Is anyone hosting their MonetDB on NFS? TIA

1 0

[MonetDB-users] May2009 branch - missing openssl/md5.h
by Alex Bo. 03 Jun '09

03 Jun '09

Hi, I am trying to build the new May2009 release from CVS on windows. Unlike in previous releases, I get this error when compiling MonetDB5: .\..\..\..\src\mal\mal_autorize.mx(97) : fatal error C1083: Cannot open include file: 'openssl/md5.h': No such file or directory There doesn't seem to be an 'openssl' directory anywhere. Any ideas? -- View this message in context: http://www.nabble.com/May2009-branch---missing-openssl-md5.h-tp23850193p238… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] 'Out of client slots' with MAPI
by Alex Bo. 03 Jun '09

03 Jun '09

Hi, I am using the MAPI programming interface to communicate with MonetDB on windows. I am using mapi_connect, mapi_query, mapi_disconnect and mapi_destroy as is shown in the examples. However, after querying for a long time, I eventually get an 'Out of client slots' exception. Moreover, it seems that ports aren't closed properly - If I run 'netstat' in the windows command prompt to see all the open ports, I see a huge list of open 50000 ports, which are used by MonetDB. These ports are marked with a 'TIME_WAIT' state, which I think means that they're inactive but not released. Could it be that I'm not using the MAPI interface properly? Or could it be a bug? I am running a compiled version of the Feb2009SP2 branch. Thanks. -- View this message in context: http://www.nabble.com/%27Out-of-client-slots%27-with-MAPI-tp23849981p238499… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] problems with starting the monetDB4 xquery server
by Mtekel 31 May '09

31 May '09

Hello, I have problems starting the monetDB xquery server under windowsXP sp3. When I click on the link in the start menu, dos window appears but then it closes immediatelly and I can't see what's there (after pausing I can see only the first 6 lines of the program output as described below, then after unpausing it immediatelly quits and closes the window). If I run MXQserver.bat, or Mserver.bat --dbinit="module(pathfinder);" I get only this: # MonetDB Server v4.28.4 # based on GDK v1.28.4 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah That's all. The server immediatelly ends. However If I run only Mserver.bat, the server "runs" - I get the prompt, but for example I can't connect to the web interface on the port 50000. Does anyone have any advice what to do? How to make it work? Any advice appreciated, Best regards Michael

1 0

[MonetDB-users] Python Library Problems
by Scott Stephens 31 May '09

31 May '09

I'm having problems connecting to a MonetDB 5 SQL database via the Python interface. I am working on a Mac OS X (10.5.6) system, with python 2.5.1. I downloaded and compiled the Feb 2009 SP2 release from source and added the appropriate directory to my PYTHONPATH. When running the connect command, I get some errors: >>> import MonetSQLdb >>> x = MonetSQLdb.connect(host='greensburg.local',user='scott',password='notmyrealpassword',lang='sql',dbname='HistoricalData') Traceback (most recent call last): File "<stdin>", line 1, in <module> File "MonetSQLdb/__init__.py", line 131, in __init__ self._mapi = Mapi(kwargs['host'], kwargs['port'], kwargs['user'], kwargs['password'], kwargs['lang'], kwargs['dbname']) File "MonetDB/CMapi.py", line 30, in __init__ raise IOError(self.error_str()) IOError: !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'scott' I have checked and double checked that my user name and password are correct: I am able to login to the database from the same machine using SQL Explorer in Eclipse with the same credentials. The connection shows up in the merovingian log on the server as being proxied to the appropriate databse. The weird thing is, it doesn't show the connection ending until I quit() the python interactive session, or try connecting again, or do something else with the connection object (c = x.cursor() also causes a disconnect, and thows an exception that complains that x is not defined). Ideas anyone? The only thing I can think of that may be wrong is I'm not using the same releases of MonetDB for the python library and the server. mserver5 --version says I'm running MonetDB server v5.6.0 based on kernel v1.24.0 (I can't seem to remember/figure out which named release this corresponds to). Do the versions need to be the same? Thanks, Scott

3 3

[MonetDB-users] Re cycler optimizer in May2009 branch?
by Alex Bo. 31 May '09

31 May '09

Hi, Will the recycler optimizer be part of the next release? Is it enabled in the May2009 branch? Thanks. -- View this message in context: http://www.nabble.com/Recycler-optimizer-in-May2009-branch--tp23801028p2380… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] ODBC + non-ascii (RELOADED)
by Pawel Lewicki 29 May '09

29 May '09

Hi, Last year I reported problems with inserting non-ascii data using ODBC interface. I submitted a bug #2014118 and it was resolved. At least I hope so. Unfortunately I had no time to play with MonetDB and had no opportunity to use it for real data. It has recently changed so I'm back with testing. I have to report that the problem is not resolved, at least it's back in Windows 32-bit Feb2009-SP2 release. I have a problem with using queries with properly encoded utf-8 data. The same data inserted using Python bindings is perfect. I have noticed that broken "LIKE" queries give proper result on broken inserted data. It means that the same characters are being recognized. ODBC driver version is 1.28.04.01 Regards, Pawel Lewicki

2 3

[MonetDB-users] Version 5 crashing.
by Mag Gam 29 May '09

29 May '09

My monetdb has been constantly crashing in the past several days and I am not able to even get to the SQL prompt of my database. Its just hanging Some information MSG DataBase[29614]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -bash-3.2$ /home/dbuser/MonetDB/bin/monetdb status name state uptime health last crash DataBase running 2h 34m 33s 40%, 2h 2009-05-12 16:49:50 demo stopped 100%, 4s - DataBase.1 stopped 100%, 2h - -bash-3.2$ /home/dbuser/MonetDB/bin/monetdb version MonetDB Database Server Toolkit v0.4 MSG merovingian[18807]: database 'DataBase' already running since 2009-05-12 16:52:20, up min/avg/max: 8609/8609/8609, crash average: 0.00 0.30 0.10 (5-1=3) MSG merovingian[18807]: proxying client 127.0.0.1:38462 for database 'DataBase' to mapi:monetdb://server01:50001/ MSG merovingian[18807]: client has 127.0.0.1:38462 disconnected from proxy Anything I should do to fix this? TIA

3 12

[MonetDB-users] alter table - rename?
by dariuszs 28 May '09

28 May '09

Hi, How do you rename table? Thanks. Dariusz.

1 0

Re: [MonetDB-users] Query plans
by Peter Boncz 25 May '09

25 May '09

Anthony, Suppose you installed MonetDB in the default directory, and have a directory c:\tmp with in it xquery c:\tmp\q.xq, then open a dos box and type (ignoring the prompt>): prompt> cd c:\Program Files\CWI\MonetDB4\bin prompt> set PATH=%PATH%;c:\Program Files\CWI\MonetDB4\lib\ prompt> pf c:\tmp\q.xq The plan you now see on your screen is a low-level physical binary table algebra (MIL) plan. This is what MonetDB executes in the end. The "pf" command is a standalone tool that invokes the "pathfinder" xquery compiler (www.pathfinder-xquery.org) that is integrated in MonetDB/XQuery. It provides many options (see: pf -H). Alternative things to try if you want to undertand query plans: prompt> pf -cPs15 c:\tmp\q.xq prompt> pf -lDs18 c:\tmp\q.xq prompt> pf -pDs20 c:\tmp\q.xq The first one prints the "XQuery Core" representation. At that stage, the query is still formulated in xQuery, but minimized to the subset defined in the XQuery Formal Semantics spec by W3C. The second one produces a logical relational algebra query plan, the third the physical relational algebra plan. Both are a more classical relational algebra (in the database textbook sense), these are intermediate stages the query goes through in the pathfinder. To understand these better, you would probably need to read some papers on MonetDB/XQuery and pathfinder (see the publication library). The last two commands produce output in the "dot" format, you can visualize these with dotty.exe. To do so, download and install the graphviz package (http://www.graphviz.org/Download.php) and make sure the location of "dotty.exe" is in your PATH. Then the following works: prompt> pf -pDs20 c:\tmp\q.xq > c:\tmp\ prompt> dotty c:\tmp\q.dotty (you can resize the screen, and use the menu under the right mouse buttom to zoom in) Peter PS Even though MonetDB/XQuery does not use it, you can even translate xqueries to SQL (to be executed on DB2 only, it does not work on MonetDB/SQL or other systems AFAIK): prompt> pf -Sc:\tmp\q.xq From: Anthony Gkountintas [mailto:agkount@hotmail.com] Sent: Monday, May 25, 2009 10:55 AM To: monet Subject: Query plans Hi all, Is there a possibility to view the xquery execution plans in MonetDb? I am running XQueries on windows platform. thanks Tony ________________________________________ Share your photos with Windows Live Photos – Free. Try it Now! Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 8.5.238 / Virus Database: 270.12.23/2106 - Release Date: 05/09/09 06:54:00

2 1

Re: [MonetDB-users] Query plans
by Peter Boncz 25 May '09

25 May '09

correction: ..... > Then the following works: > prompt> pf -pDs20 c:\tmp\q.xq > c:\tmp\ prompt> pf -pDs20 c:\tmp\q.xq > c:\tmp\q.dotty > prompt> dotty c:\tmp\q.dotty

1 0

[MonetDB-users] Mapi connection hangs
by Alex Bo. 24 May '09

24 May '09

Hi, I reached a certain state where there's some sort of data corruption that prevents MonetDB to start. I get this message: !ERROR: Please move away <log folder> and its corresponding dbfarm. !mvc_init: unable to create system tables. I use Mapi to connect to Monet, but the problem is that in this case I do net get back a failed mapi connection - instead the connection attempt hangs and never returns. Is this a mapi bug? If I remove the log folder Monet goes back up again. I am using v2.28.5 compiled on Windows from CVS (branch May2009). -- View this message in context: http://www.nabble.com/Mapi-connection-hangs-tp23643072p23643072.html Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] Strange io exception
by Alex Bo. 24 May '09

24 May '09

Hi, I am running "Select * from tables" and am going over the results with Mapi commands. I tried to run this query with parallel clients, and reran the query hundreds of times. Once in a while I get this exception: !TypeException:user.s32_7[157]:'io.s3019_1' undefined in: _233:any := io.s3019_1() What does this mean? Why does this happen? I am using v2.28.5 compiled on Windows from CVS (branch May2009). -- View this message in context: http://www.nabble.com/Strange-io-exception-tp23692587p23692587.html Sent from the monetdb-users mailing list archive at Nabble.com.

3 6

[MonetDB-users] pcre exception with LIKE inside CASE
by Alex Bo. 24 May '09

24 May '09

Hi, I can successfully run the following query: select "field1", "field2" from testlike where field2 like '%hel%' However, I cannot run this one: select "field1", "field2", (case when ("field2" like '%hel%') then cast("field1" as double) else cast("field1" as bigint) end) as dd from testlike I get this exception: !MALException:pcre_match:not available as required version of libpcre was not found by configure. (This is on Feb SP2 2009 compiled on Windows from CVS) -- View this message in context: http://www.nabble.com/pcre-exception-with-LIKE-inside-CASE-tp23694479p23694… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] time series benchmark dataset and query/analyses set
by Tom H 22 May '09

22 May '09

Hi monetDB artistes, I found an epic thread on "Tick Database Implementations" and there were lots of intelligent replies here; Subject:dataset for performance testing a time series implementation http://www.elitetrader.com/vb/showthread.php?s=&threadid=81345&perpage=6&pa… So amongst others, monetdb, kdb+ and HDF5 were mentioned, along with streamSQL and CEP/ESPER style analysis tools. However I think the proof is in the testing, so I was looking for a financial price stream orientated dataset that I could download import and run my analysis against for a metric. (obviously I would only testing performance of running retrieval annd analysis rather than storing the ticks) I had a look at the TPC site, http://www.tpc.org/ but I couldn't find anything relevant. I also found some acedemic papers, with the sort of thing that would be useful, but no datasets supplied. So I would like to suggest maybe taking a dataset like OHLC data for the S&P for the last x years, to get it up to something sizable, and then a bunch of analyses that would test the implementation. Has anyone got any suggestions on such a beast, and indeed would anyone like to compare against my monetDB system with their own HDF5 or kdb implementation? Cheers, T

1 0

[MonetDB-users] ADO .net provider & ODBC error
by Zheng Han 18 May '09

18 May '09

Hi, Is there any ADO .net provider for MonetDB? We tried to use odbc driver in C#. When fecth unicode Chinese values, some error ocurred: System.InvalidOperationException Message="Internal .Net Framework Data Provider error 30." Source="System.Data" StackTrace: at System.Data.ProviderBase.DbBuffer.Validate(Int32 offset, Int32 count) at System.Data.ProviderBase.DbBuffer.PtrToStringUni(Int32 offset, Int32 length) at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i) at System.Data.Odbc.OdbcDataReader.GetString(Int32 i) at MonetDBTest.Form1.button1_Click(_object_ sender, EventArgs e) in E:\D_Bak\~MyWorks\MonetDB\MonetDBTest\Form1.cs:line 41 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.PerformClick() at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.PreProcessMessage(Message& msg) at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg) at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg) at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FPreTranslateMessage(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at MonetDBTest.Program.Main() in E:\D_Bak\~MyWorks\MonetDB\MonetDBTest\Program.cs:line 18 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(_object_ state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, _object_ state) at System.Threading.ThreadHelper.ThreadStart() InnerException: Regards, Aiyoyo

1 0

[MonetDB-users] ADO .net provider & ODBC error
by Zheng Han 18 May '09

18 May '09

Hi, Is there any ADO .net provider for MonetDB? We tried to use odbc driver in C#. When fecth unicode Chinese values, some error ocurred: System.InvalidOperationException Message="Internal .Net Framework Data Provider error 30." Source="System.Data" StackTrace: at System.Data.ProviderBase.DbBuffer.Validate(Int32 offset, Int32 count) at System.Data.ProviderBase.DbBuffer.PtrToStringUni(Int32 offset, Int32 length) at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i) at System.Data.Odbc.OdbcDataReader.GetString(Int32 i) at MonetDBTest.Form1.button1_Click(_object_ sender, EventArgs e) in E:\D_Bak\~MyWorks\MonetDB\MonetDBTest\Form1.cs:line 41 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.PerformClick() at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.PreProcessMessage(Message& msg) at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg) at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg) at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FPreTranslateMessage(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at MonetDBTest.Program.Main() in E:\D_Bak\~MyWorks\MonetDB\MonetDBTest\Program.cs:line 18 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(_object_ state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, _object_ state) at System.Threading.ThreadHelper.ThreadStart() InnerException: Regards, Zheng Han

1 0

[MonetDB-users] MAL samples
by Henri Asseily 18 May '09

18 May '09

Hi, where can I find some MAL samples? I'm trying to do very simple things such as storing and loading a bat, joining bats and iterating through them. I know I can do an explain on SQL statements, but those seem incredibly convoluted even for a simple select on a single column, which should be a straightforward sql.bind(,,,0) with follow-through sql.resultSet and sql.rsColumn if I understand this whole business correctly. Instead, it's doing a couple of algebra kunion and kdifference that I don't understand. I'm not trying to do MAL algebra on a SQL database, I'm trying to go 100% MAL and hand-coding some simple joins and iterators. I would have gone SQL all the way, but I need to iterate through a bat and calculate a result for each row, then return that sorted new bat based on the result. Doing it in SQL is overly complicated when some simple MAL statements should do the job. Thanks. --- Henri Asseily henri.tel

4 6

[MonetDB-users] Freeing memory through Mapi
by Alex Bo. 18 May '09

18 May '09

Hi, Sometimes when memory-heavy operations on MonetDB finish (I run them through Mapi), memory that is used by the MonetDB process isn't freed. Is there a Mapi command I can use too make Monet free up memory? What I do now is restart the process, but I am hoping to be able to avoid that. Thanks. -- View this message in context: http://www.nabble.com/Freeing-memory-through-Mapi-tp23595876p23595876.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1