- users-list - monetdb.org

[MonetDB-users] Jdbc error
by Franck Routier 08 Jul '09

08 Jul '09

Hi, I am trying to populate a table using jdbc and CloverETL, but I get the following message : Caused by: java.sql.SQLException: SQLException:sql.prepare:wrong argument for prepared statement (expected decimal instead of decimal) So, Monetdb is expecting decimal, but gets ... decimal :-) What can be the problem ? Thanks, Franck

2 4

Re: [MonetDB-users] PCRE
by idf＠synctrading.com 04 Jul '09

04 Jul '09

I can't get much to work on windows version of MonetDB. It is terribly documented. On Sat Jul 4 8:39 , 'Alex Bo.' <alex.bodinner(a)gmail.com> sent: > >Hi, > >I am trying to build the new May2009 SP from CVS on Windows64, however, >building the MonetDB5 module fails because of pcre. >I built pcre successfully, and have it in 'C:\PCRE'. Then I added >'LIBPCRE=C:\PCRE' and 'PCRE_LIBS=C:\PCRE\lib\pcre.lib' to my nmake command, >but I get the following errors: > > Creating library lib_pcre.lib and object lib_pcre.exp >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_compile >referen >ced in function _pcre_compile_wrap >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_exec >referenced > in function _pcre_exec_wrap >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_study >reference >d in function _pcre_uselect >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_fullinfo >refere >nced in function _pcre_replace >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_free >referenced > in function _pcre_init >pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_malloc >referenc >ed in function _pcre_init >lib_pcre.dll : fatal error LNK1120: 6 unresolved externals > >Please help. >Thanks. > >-- >View this message in context: http://www.nabble.com/PCRE-tp24334669p24334669.html >Sent from the monetdb-users mailing list archive at Nabble.com. > > >------------------------------------------------------------------------------ >_______________________________________________ >MonetDB-users mailing list >MonetDB-users(a)lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/monetdb-users

1 0

[MonetDB-users] PCRE
by Alex Bo. 04 Jul '09

04 Jul '09

Hi, I am trying to build the new May2009 SP from CVS on Windows64, however, building the MonetDB5 module fails because of pcre. I built pcre successfully, and have it in 'C:\PCRE'. Then I added 'LIBPCRE=C:\PCRE' and 'PCRE_LIBS=C:\PCRE\lib\pcre.lib' to my nmake command, but I get the following errors: Creating library lib_pcre.lib and object lib_pcre.exp pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_compile referen ced in function _pcre_compile_wrap pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_exec referenced in function _pcre_exec_wrap pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_study reference d in function _pcre_uselect pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_fullinfo refere nced in function _pcre_replace pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_free referenced in function _pcre_init pcre.obj : error LNK2019: unresolved external symbol __imp__pcre_malloc referenc ed in function _pcre_init lib_pcre.dll : fatal error LNK1120: 6 unresolved externals Please help. Thanks. -- View this message in context: http://www.nabble.com/PCRE-tp24334669p24334669.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] zlib dll problems in May2009 SP
by Alex Bo. 02 Jul '09

02 Jul '09

Hi, There seems to be a bug in the new service pack. Trying to compile it from CVS fails because zlib1.dll isn't found, even though it is found with the same configuration in the original May2009 release. I noticed that winrulesm.msc in the MonetDB folder doesn't handle the zlib dlls correctly for 32 bit machines. Moving the #!IFDEF HAVE_LIBZ portion of the file back to how it is the the May2009 non SP release solved the problem. -- View this message in context: http://www.nabble.com/zlib-dll-problems-in-May2009-SP-tp24307397p24307397.h… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Announcement: May2009-SP1 bug fix release
by Sjoerd Mullender 30 Jun '09

30 Jun '09

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

1 0

Re: [MonetDB-users] problem with MonetDB
by Stefan Manegold 29 Jun '09

29 Jun '09

Dear Christoph, I'm currently traveling, hence only a quick reply. Most probably, the reason that your haven't receive any answer to your question, yet, is that noone seems to have an answer, yet. Looking at your report, again, I do have a couple of questions and suggestions (inlined below) that might help you and us to locate the origin of your problem. On Mon, Jun 29, 2009 at 05:37:56PM +0200, Christoph Beekmans wrote: > Dear Mr. Manegold, > > i have a problem with MonetDB and i sent my problem to the user-mailing > list. > Unfortunately nobody answered on my topic and this is a few weeks ago and > i wasn't the first to mail the problem. > > So i decided to contact someone of the cwi-team directly and i hope you > are able > to help me in some way. > > Here the message i sent to the mailing list: > >> Hi everybody, >> >> I posted my issue a few weeks ago, but i got no answer, so >> i try i again. >> >> I installed MonetDB on Windows with the geom module and Which version of MonetDB are you using/talking about? >> afterwards i tried to execute a query with some geometric data types. >> But after a few changes to the query and execution i got an error. What data did you load? What kind of queries did you run? Which error did you get? >> After that i had to restart MonetDB but i got an error message that >> the system tables couldn`t be loaded. Could you quote the exact error message? >> If i start the server without geom support it starts fine but the sql >> client >> can`t connect: >> >> "Connection terminated >> Press any key to continue . . . " Does the server continue running, or does it crash in that case? If the latter, is there any error message on the server console/window? If so, which? >> If i start the server with geom support it loads the sql and geom modules >> but shuts down after that without error message. Could you try running the server on a new empty database? Does that work? If so, could you then replay the steps you did before to see, whether you can reproduce the crash and (potential) corruption of the database? >> Even a reinstall didn't fix it so the error must be somewhere else. did you remove your database before/after the reistall, or are you (still) using the same (possibly corrupoted) database? >> Has anyone an idea about that? >> >> Please help, >> Thanks. > > I would be grateful for an answer, > Christoph Hope this helps for now ... 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

[MonetDB-users] String performance
by Alex Bo. 29 Jun '09

29 Jun '09

Hi, How can I know if a string field in a table has a hash table or not? I am asking this because I noticed that string fields with millions of unique values run very slowly, and from your documentation I understood that if I add too many unique strings to a column, then internally Monet will stop using a hash-table, and performance will be affected. Thanks. -- View this message in context: http://www.nabble.com/String-performance-tp24256780p24256780.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Missing JDBC-driver
by Sten Hjelmqvist 25 Jun '09

25 Jun '09

Hello, I've downloaded MonetDB5-SQL-Installer-i386-20090530.msi <http://monetdb.cwi.nl/downloads/Windows/May2009/MonetDB5-SQL-Installer-i386…> for windows. However there was no JDBC-driver in the package. After some searching on Google I found one called "jdbcclient.jar". But I still cannot connect to the database as I get a error message saying that the "demo"-database does not exist. What am I missing? Thanks in advance. --------------------------------------- Sten Hjelmqvist DataKonsult MERdata AB Sveavägen 33, 111 34 Stockholm Mobil : 0708 305616 E-mejl : sten.hjelmqvist(a)merdata.se <mailto:sten.hjelmqist@merdata.se> Webb : www.merdata.se <http://www.main.se/> ---------------------------------------

3 7

[MonetDB-users] disk usage
by dariuszs 25 Jun '09

25 Jun '09

Hi, I've loaded 60 GB of data file into a table. On Windows (NTFS) the size of dbfarm changed to 80GB but on Linux (ext4 or reiserfs) dbfarm changed to 180GB. Why is that? Thanks. Dariusz.

5 15

[MonetDB-users] connection terminated
by Christoph Beekmans 25 Jun '09

25 Jun '09

Hi everybody, I posted my issue a few weeks ago, but i got no answer, so i try i again. I installed MonetDB on Windows with the geom module and afterwards i tried to execute a query with some geometric data types. But after a few changes to the query and execution i got an error. After that i had to restart MonetDB but i got an error message that the system tables couldn`t be loaded. If i start the server without geom support it starts fine but the sql client can`t connect: "Connection terminated Press any key to continue . . . " If i start the server with geom support it loads the sql and geom modules but shuts down after that without error message. Even a reinstall didn't fix it so the error must be somewhere else. Has anyone an idea about that? Please help, Thanks.

1 0

[MonetDB-users] Deployment of MonetDB
by Martin Kersten 24 Jun '09

24 Jun '09

Dear users, In our ongoing effort to improve the MonetDB software suite we would like to hear from you. It appears that MonetDB is used for teaching, and customers use it for/within their products. Also, the divergence in primary platform is crucial for us to keep focus. We would greately appreciate if you could replay with a short message how you deploy the software and your top priorities for a next release. Thank you for you cooperation, Martin Kersten

3 6

[MonetDB-users] May2009 - can't connect on Windows64
by Alex Bo. 24 Jun '09

24 Jun '09

Hi, I installed the new May2009 release. On Windows32 I have no problem connecting through Mapi. On Windows64, however, I can't connect. I get a 'Setup connection failed' error from Mapi. (I had no problem connecting on Windows64 with the Feb09 release) Please help, Thanks. -- View this message in context: http://www.nabble.com/May2009---can%27t-connect-on-Windows64-tp24056525p240… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

Re: [MonetDB-users] [Monetdb-checkins] load data from a file to a table
by Stefan Manegold 24 Jun '09

24 Jun '09

Hi Pedro, A) Thanks for using MonetDB. B) The users mailing list is "monetdb-users(a)lists.sourceforge.net", not "monetdb-checkins(a)lists.sourceforge.net". C) I'm afraid your report contains too little information (basically none) for us to provide any help. The least we'd (obviously) need to know is which version of MonetDB you're using on wich operating system and, in particular, what the exact problem is, i.e., the a detailed description of the symptoms and/or the error messages that you encounter. Stefan On Tue, Jun 16, 2009 at 02:54:01PM +0000, Pedro Bramao wrote: > > I'm trying to load data into a table from a file, named criminoso.sql, to a table named criminos stored in MonetDB. > I'm doing the following coomand : > > copy 2 records into criminoso from '/home/pedro/Escola/tabd/criminoso1.sql' using delimiters tuple_separator ',' record_separator ';'; > > But it's not working... i nedd some help!!!! > > thanks > > _________________________________________________________________ > Conheça os novos produtos Windows Live! Clique aqui. > http://www.windowslive.com.br > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- | 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] disk usage
by Jens Oehlschlägel 23 Jun '09

23 Jun '09

> > http://www.fusionio.com/Products.aspx If this SSD sits on the bus, it is not compatible with i-core7, is it?

2 1

[MonetDB-users] Schema Changes Through JDBC
by Scott Stephens 22 Jun '09

22 Jun '09

I've been seeing some weird behavior when using Eclipse SQL Explorer to execute statements that modify the schema with the MonetDB May2009 release and the monetdb-1.10-jdbc.jar file. For instance, the statement CREATE TABLE Archive.Test ( var1 int, var2 varchar(100) ); yields a pop-up error message titled "Error Executing SQL" with the text "Schema statements are directly executed and therefor cannot be debugged, explained, profiled, traced, or used in a prepare statement". I'm not a Java user and haven't tried this in Java code as opposed to through SQL Explorer, so I can't conclusively link it to the JDBC driver as opposed to the SQL Explorer code, but I seem to recall this working in previous versions of MonetDB with SQL Explorer. Thoughts anyone? Is this supposed to work? Scott

2 1

Re: [MonetDB-users] CRT and GKLoad errors
by Florian Joßbächer 16 Jun '09

16 Jun '09

Hey, this issue is still unsolved. Are there any ideas or hints? Best regards, Florian.

1 0

[MonetDB-users] Is MonetDB for me?
by Bohák András 12 Jun '09

12 Jun '09

Dear Community, I plan to bulid a database of stock market data. The database structure is very simple, there will be a main table with columns like timestamp, stockID, price, volume. The size of the database is about 4 TB. I would like to use the database to search certain patterns, like "5% stock price change in 5 minutes", so all my queries will likely touch all the data in the database. Is MonetDB for me? Is it considerably faster than an OLTP database (Mysql, Oracle)? Another question: would you use cheap SATA hard drives for this, or is it worth to invest in 15k SAS drives? Is HDD an important performance factor? Thanks in advance for all your answers, Andras Bohak

2 1

[MonetDB-users] Crash after recurring column updates
by Alex Bo. 11 Jun '09

11 Jun '09

Hi, I am working on MonetDB Feb2009SP2 compiled and run on windows64 from CVS. After Creating a 40 Million row table, I did a series of ADD COLUMN and UPDATE operations on all 40M rows. After a few update queries the server crashed. I noticed that for each query a lot of memory was allocated, but not all of it freed after the query returned, so that after each update query the total amount of memory used by MonetDB has gone up, until eventually the server crashed. (The machine is 64 bit with 8GB of RAM) I then tried to reproduce it on a smaller database with 20 Million rows. I ran this query over and over: UPDATE testtable set testtable."MonthColumn" = "month"("DateColumn"); This too eventually crashed. I attached an image of the memory consumption from task manager that was taken right after the crash. http://www.nabble.com/file/p23984181/MonetMemory.jpg Any ideas on why this happens and how I can work around it? Is it at all a memory issue like I suspected? Thanks. -- View this message in context: http://www.nabble.com/Crash-after-recurring-column-updates-tp23984181p23984… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Slow import of large XML documents
by John van Schie (DT) 11 Jun '09

11 Jun '09

Hi, Today I tried to shred a XML document of 1.6 giga bytes using mclient and it took more than 3 hours (~150 kb/s) on a quite fast machine. I was a bit suprised. because for smaller documents shredding is quite fast. Are these numbers expected? I know that it can be hard to say something about this case without the document itself. So I'm currently working to anonymize the document, but what is the prefered way to get the document to the CWI? System information: - Fedora Core 10, x86_64, 32 GB RAM (24G cached/free), 5.5 GB disk free (after import) - MonetDB4 / XQuery v4.28.4, 64bit OIDs (RPM version) Commands: $ time mclient -p 50000 -l xq -s"pf:add-doc('/tmp/structure.xml', 'structure3.xml')" real 198m49.543s user 0m0.002s sys 0m0.003s [user@host tmp]$ ls -lah /tmp/structure.xml -rw-r--r-- 1 user user 1.6G 2009-06-08 16:26 /tmp/structure.xml Regards, John van Schie

3 3

[MonetDB-users] Insert tuples with special characters especially umlauts
by Sebastian Bräuer 09 Jun '09

09 Jun '09

Hallo everybody, I would like to know whether there exist any possibilities to add tuples with umlauts as characters (ä,ö,ü) or other special characters like ß to tables. I tried to use the regular INSERT-statement as well as the COPY INTO-statement with a csv input file but without success (unexpected end of input error or missing ' to close the string). Example: CREATE TABLE Umlautnamelist(CUST_ID numeric(9,0) not null, CUST_NAME varchar(100) not null, constraint Umlautnamelist_PK primary key (CUST_ID)); INSERT INTO Umlautnamelist (123456789,'Bräuer'); Are there any chances to get it working? Thank you in advance. Sebastian

4 3

[MonetDB-users] possible bug in monetdb-install.sh
by Ying Zhang 09 Jun '09

09 Jun '09

Hi, I was using moentdb-install.sh to install the May 2009 release with the following command, which ends in an error: ================================ $ monetdb-install.sh --prefix=[pathto]/mdb_may2009 --enable-optimize --enable-xquery --22:11:36-- http://www.ins.cwi.nl/~monet/tars/latest/release/MonetDB.tar.bz2 => `/private/var/tmp/MonetDB-1244491895/MonetDB/ MonetDB.tar.bz2' Resolving www.ins.cwi.nl... 192.16.196.21 Connecting to www.ins.cwi.nl|192.16.196.21|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 882,241 (862K) [application/x-bzip2] 0K ........ ..... 100% 780.55 KB/s 22:11:37 (780.55 KB/s) - `/private/var/tmp/MonetDB-1244491895/MonetDB/ MonetDB.tar.bz2' saved [882241/882241] fetching http://www.ins.cwi.nl/~monet/tars/latest/release/MonetDB.tar {,bz2:bzip2,gz:gzip} failed! Please refer to the full log at /private/var/tmp/MonetDB-1244491895/log If you believe this is an error in the script or the software, file a bug and attach the logfile. Terminated ================================ The following code in the 'fetch()' function seems incorrect to me: for c in $LZMA $BZIP2 $GZIP ; do wget --progress=dot:mega -t 5 --passive-ftp $1.${c%:*} -P "$BUILDROOT"/$f > $QUIET ... done [[ ! -f "$BUILDROOT"/$f/$f.tar ]] && \ die "fetching $1 {$LZMA,$BZIP2,$GZIP} failed!" First, in the for-loop, e.g., MonetDB.tar.bz2 is fetched. Then, the code following the for-loop checks if ".../MonetDB.tar" exists, if not, it complains that fetching ".../MonetDB.tar.bz2" has failed, returning the error I got. Kind regards, Jennie

2 3

[MonetDB-users] connecting to mserver
by Henrik Vendelbo 08 Jun '09

08 Jun '09

I've installed mserver in a fresh Ubuntu Jaunty running in vmware, but cannot seem to connect. At first I thought it was just because I hadn't opened port 50000 in iptables, but things are a bit odd even now that I have opened the port. within Ubuntu port 50000 only seems to be open on the lo interface, while on the eth0 interface it is closed. Can this be an issue with mserver or is it just my iptables conf that is screwed?

3 2

[MonetDB-users] CRT and GKLoad errors
by Florian Joßbächer 08 Jun '09

08 Jun '09

Hi, I am trying to run the Star Schema Benchmark with Scale Factor 10 on MonetDB and get the following errors while loading the tables from a csv. The GKLoad-Errors occur just once in a while, the CRT-error is reproducible. Every time I try to run SF10, the server crashes while loading the lineorder-table (SF10) - with SF1 everything works fine. I googled this issue but only found a hint deleting a registry-key which is not existing on my machine. What can I do? Best regards, Florian. "# MonetDB server v5.10.4, based on kernel v1.28.4 # Serving database 'ssb', using 1 thread # Compiled for i686-pc-win32/64bit with 32bit OIDs dynamically linked # 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 #warning: please don't forget to set your vault key! #(see D:\MonetDB5\etc\monetdb5.conf) # Listening for connection requests on mapi:monetdb://CS-MONETDB:50000/ # MonetDB/SQL module v2.28.4 loaded >!ERROR: GDKload: cannot read: name=65\6560, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3440) for sys_customer_custkey !ERROR: GDKload: cannot read: name=65\6547, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3431) for sys_customer_name !ERROR: GDKload: cannot read: name=65\6553, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3435) for sys_customer_address !ERROR: GDKload: cannot read: name=65\6554, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3436) for sys_customer_city !ERROR: GDKload: cannot read: name=65\6557, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3439) for sys_customer_nation !ERROR: GDKload: cannot read: name=66\6672, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3514) for sys_customer_region !ERROR: GDKload: cannot read: name=70\7067, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3639) for sys_customer_phone !ERROR: GDKload: cannot read: name=70\7070, ext=tail, 800000 bytes missing. !OS: The operation completed successfully. !ERROR: logger: could not use bat (3640) for sys_customer_mktsegment runtime error R6031 - Attempt to initialize the CRT more than once. This indicates a bug in your application."

4 10

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

07 Jun '09

Hello, I have carefully read the link you have sent me. Too bad comments are closed. I have now uninstalled my 20090424 version and installed the newest 20090530. However I still have problems running the server. The 2009 4 24 version wouldn't start even after loading all the modules by hand from the Mserver interactive commandline - nor the client or browser would connect. They would just hang, connecting forever. Now this works for the 05 30 version, but I can't use the web interface (which now works) for adding the files - I get a bug (I'm not sure If I am allowed to send attachements, so I'll include them in the next mail). Adding from commandline, mclient --language=xquery -I %1 -C WOcollection < %1 , where %1 is filename, works, but the collection name is %1 WOcollection (e.g. three different files end up in different collections instead of one). What is more interresting, if I try to run pf:add-doc("DATA_wo3.xml", "DATA_wo3.xml", "WOcollection", 1) from the client's interactive commandline, I get this error (no matter where the file really is): MAPI = monetdb@localhost:50000 QUERY = pf:add-doc("DATA_wo3.xml", "DATA_wo3.xml", "WOcollection", 1) ERROR = !ERROR: interpret: no matching MIL operator to 'ws_create(int)'. I have run procmon and created trace as described in the link, the file is attached (to the second mail). I hope this issue can be solved somehow, Best regards, 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

2 3

Re: [MonetDB-users] connection terminated
by Christoph Beekmans 05 Jun '09

05 Jun '09

> hi, > i started to have suddenly following problem with the M5Server. I can > start > the server and get the following screen which seems fine: > > # MonetDB server v5.10.2, based on kernel v1.28.2 > # Serving database 'demo', using 1 thread > # Compiled for i686-pc-win32/32bit with 32bit OIDs dynamically linked > # Copyright (c) 1993-July 2008 CWI. > # Copyright (c) August 2008- MonetDB B.V., all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > #warning: please don't forget to set your vault key! > #(see C:\Program Files\MonetDB\MonetDB5\etc\monetdb5.conf) > # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > # MonetDB/SQL module v2.28.2 loaded > > When i start the client I get following message and the server shuts down: > > Connection terminated > Press any key to continue . . . > > I have tried to reinstall monetDb but it does not help. can anyone > point me > into the right direction? > Thanks Hi, i have the same problem. It started after i sent a query refering to the geom module. Maybe someone has an idea? Thanks

1 0