- users-list - monetdb.org

[MonetDB-users] Is there any way to run MonetDB as a Windows Service?
by 小波顾 05 Jan '09

05 Jan '09

Thanks. _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

3 2

[MonetDB-users] COPY INTO on aggregate queries crashes MonetDB
by Peter Farkash 04 Jan '09

04 Jan '09

Hi, When I use COPY INTO with a count query, monetDB crashes. For example: copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; Gives me the following result and kills the server: MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; ERROR = Connection terminated The same happens if I use sum, average, etc. On normal queries the copy into works just fine. I am using v5.8.2, and am getting the crash both when using mclient and the MAPI programming interface. Any ideas? -- View this message in context: http://www.nabble.com/COPY-INTO-on-aggregate-queries-crashes-MonetDB-tp2127… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] What code page does Monetdb currentlly use?
by 小波顾 03 Jan '09

03 Jan '09

We are Chinese users, and hoping Monetdb will support multi-byte character encodings like UTF-8 and GBK. _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

5 6

[MonetDB-users] Monetdb5 threading question.
by 小波顾 02 Jan '09

02 Jan '09

When I start the default demo database (or a new created one) process on Windows XP, the following messaged appears in the command window : # Serving databse 'demo', using 1 thread Does it mean the whole database process is single-threaded? The following section in the monetdb5.config file shows we can config multiple threads # Mserver 5 recognizes a series of command line names instead:# --threads ( 1 | PARMASK)# --memory (MEMMASK )# --properties (CHECKMASK | PROPMASK | BATMASK )# --io (IOMASK | PERFMASK )# --transactions ( TMMASK | DELTAMASK | TEMMASK)# --modules (DLMASK | LOADMASK)# --algorithms (ALGOMASK | ESTIMASK)# --xproperties (XPROPMASK )# --performance (JOINPROPMASK | DEADBEEFMASK) What does 'parmsk' mean, and how to config monetdb to use multiple threads? _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

3 4

[MonetDB-users] Multiple database question.
by 小波顾 02 Jan '09

02 Jan '09

I have created a customed version of the MServer5.bat and MClient.bat to serve multiple databases. MServer5.bat : set MONETHOME=D:\Amber\Program\MonetDB\MonetDB5 set MONETDATAROOT=%1set MONETDATAROOT=%MONETDATAROOT:~0,-1%set MONETDBNAME=%2 if "%MONETDATAROOT%" == "" pauseif "%MONETDBNAME%" == "" pause set PATH=%MONETHOME%\bin;%MONETHOME%\lib;%MONETDB%\lib\MonetDB5;%PATH% set MONETDBFARM=--dbfarm="%MONETDATAROOT%\dbfarm"set SQLLOGDIR=--set "sql_logdir=%MONETDATAROOT%\sql_logs"set XQUERYLOGDIR=--set "xquery_logdir=%MONETDATAROOT%\xquery_logs" rem start the real server"%MONETHOME%\bin\mserver5.exe" --set "prefix=%MONETHOME%" --set "exec_prefix=%MONETHOME%" %MONETDBFARM% %SQLLOGDIR% --dbname=%MONETDBNAME% --dbinit="include sql;" MClient5.bat @set MONETHOME=D:\Amber\Program\MonetDB\MonetDB5 @set DBNAME=%1if "%DBNAME%" == "" pause @rem extend the search path with our EXE and DLL folders@rem we depend on pthreadVCE.dll having been copied to the lib folder@set PATH=%MONETHOME%\bin;%MONETHOME%\lib;%MONETHOME%\lib\bin;%PATH% @rem start the real client@"%MONETHOME%\bin\mclient.exe" -lsql -d %DBNAME% @if ERRORLEVEL 1 pause Using "MServer5.bat D:\MONETDB amber" I am able to start a new server process, ant it successfully created a new database in D:\MONETDB directory, but with the new server and default demo server process all running, I can't use mclient connect to the new database. MClient5.bat amber D:\>mclient.exe -E GB2312 -lsql -d amber!database 'amber' does not exist But the demo database can be connected to, and the new database can be connected to only when I close the demo database process. The netstat -a command shows there are two processes listening on port 50000. _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx…

2 2

[MonetDB-users] Is there any load speed measurements of MonetDB?
by 小波顾 30 Dec '08

30 Dec '08

_________________________________________________________________ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/photos.aspx

1 0

[MonetDB-users] Can someone point to me some resources about memory and storage model of MonenDB.
by 小波顾 30 Dec '08

30 Dec '08

Thanks. _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx…

1 0

[MonetDB-users] Copy Into problem
by Alfred Nordman 30 Dec '08

30 Dec '08

Hi there, I'm trying to use the copy into with csv file (utf-8 encoded) and I encounter some problem. The create statement is: CREATE TABLE "sa3e7e9f4d666429ea2c5bb61a532f5b9" ("A" DATE ,"B" VARCHAR (22) ,"C" DECIMAL (12, 5) ,"D" DECIMAL (12, 5) ,"E" DECIMAL (12, 5) ,"F" DECIMAL (12, 5) ) The copy into statement is: COPY INTO "sa3e7e9f4d666429ea2c5bb61a532f5b9" FROM 'T:\\Prism\\Applications\\Desktop\\PrismDesktop\\bin\\Debug\\LocalRepository\\ImportedCSV\\ImportedCSV0.csv' USING DELIMITERS '|' NULL AS 'A56A9FC261A143a48F6019F602ABF409'; And csv is attached. Any advice?!?!?! tnx, Alfred. http://www.nabble.com/file/p21200441/ImportedCSV0.csv ImportedCSV0.csv -- View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21200441.html Sent from the monetdb-users mailing list archive at Nabble.com.

6 13

[MonetDB-users] COPY INTO problem
by Alfred Nordman 30 Dec '08

30 Dec '08

Hi there, I'm trying to use the copy into with csv file (utf-8 encoded) and I encounter some problem. The create statement is: CREATE TABLE "sa3e7e9f4d666429ea2c5bb61a532f5b9" ("A" DATE ,"B" VARCHAR (22) ,"C" DECIMAL (12, 5) ,"D" DECIMAL (12, 5) ,"E" DECIMAL (12, 5) ,"F" DECIMAL (12, 5) ) The copy into statement is: COPY INTO "sa3e7e9f4d666429ea2c5bb61a532f5b9" FROM 'T:\\Prism\\Applications\\Desktop\\PrismDesktop\\bin\\Debug\\LocalRepository\\ImportedCSV\\ImportedCSV0.csv' USING DELIMITERS '|' NULL AS 'A56A9FC261A143a48F6019F602ABF409'; And csv is attached. Any advice?!?!?! tnx, Alfred. http://www.nabble.com/file/p21193416/ImportedCSV0.csv ImportedCSV0.csv -- View this message in context: http://www.nabble.com/COPY-INTO-problem-tp21193416p21193416.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Announcement: New bug fix release of MonetDB suite
by Sjoerd Mullender 22 Dec '08

22 Dec '08

The MonetDB team at CWI is pleased to announce the Nov2008-SP1 bug fix release of the MonetDB suite of programs. This is a bug fix release of last month's Nov2008 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/Nov2008/#Nov200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

3 2