- users-list - monetdb.org

[MonetDB-users] how to completely remove the MonetDB5 installation?
by ewilde 14 Apr '08

14 Apr '08

thanks for replying my previous message. as i mentioned in the previous message, the first installation worked fine (more or less), so in order to finish evaluating MonetDB5 regarding my certain needs, i just want to completely remove it and re-install it. it looks like that the installation program doesn't completely remove the MonetDB5 installation, so, what's the secrete? how do i (manually) completely remove the installation, so i be able to successfully re-install it as it happened the first time. thanks again, ewilde.

3 2

[MonetDB-users] Error building PF/Tijah index
by Desislava I. Petkova 14 Apr '08

14 Apr '08

Hello I'm trying to build a full-text PF/Tijah index. After starting the Mserver, I add 10 XML files into a new collection. I've divided the collection into files so that the files are not too large. This finishes without errors and the collection exists since pf:collections( ) <> returns <collection updatable="false" size="100 MiB" numDocs="1">dblp.xml1</collection>, <collection updatable="false" size="61 MiB" numDocs="1">dblp.xml10</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml2</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml3</collection>, <collection updatable="false" size="102 MiB" numDocs="1">dblp.xml4</collection>, <collection updatable="false" size="103 MiB" numDocs="1">dblp.xml5</collection>, <collection updatable="false" size="101 MiB" numDocs="1">dblp.xml6</collection>, <collection updatable="false" size="101 MiB" numDocs="1">dblp.xml7</collection>, <collection updatable="false" size="107 MiB" numDocs="1">dblp.xml8</collection>, <collection updatable="false" size="107 MiB" numDocs="1">dblp.xml9</collection> Then I try to build a full-text index for the collection let $opt := <TijahOptions stemmer="porter-english" /> return tijah:create-ft-index($opt) <> But the Mserver aborts after some time with the following error message: MonetDB>*** glibc detected *** free(): invalid pointer: 0x0000002be9d42010 *** I would like to know what this error message means, and how can I fix the problem. Thank you for your response, Desislava

2 1

[MonetDB-users] mserver crashes on windows server 2003 x64
by ewilde 14 Apr '08

14 Apr '08

hi, i do the following steps: 1. run the install program: MonetDB5-SQL-Installer-x86_64-20080214.msi 2. from the start menu, run the shortcut: MonetDB SQL Server 3. from the start menu, run the shortcut: MonetDB SQL Client and... the MonetDB SQL Server window disapears.... a few days ago i installed it (first time in my life) and it worked. i started doing some testing for a couple of days, and suddenly the server stopped working. finally, i gave up: i removed it (using the install program) and re-installed it again (and again (to another directory)..). more info: 1. starting the client with the -lmal option (instead of -lsql) dose NOT crashes the server. so i guess something is probably wrong with the sql layer. 2. during those couple of days that the server was working, i could not find any file related to the database in the whole file system, even though i managed to store some tables with a few millions of records. i was able to query these tables and (most of the time) getting the expected results, so i moved on ignoring this strange thing. BTW: i wonder what is the best way to migrate a database from MSSql server to MonetDB5? i tried to export a whole database (~30 millions of records) from MSSql2005 to MonetDB. first, i thought i could do it with the MSSql export wizard using the odbc driver, but this driver did not show up in the wizard as a target possibility. next, i tried to write a java program using the jdbc driver, but the performances rate weren't constant: one table with 3 columns (int,int,decimal) and about a half a million of records moved to MonetDB in ~3000 records per second. but another very similar table with 3 columns (int,int,int) and about 8 millions of records moved to MonetDB in ~30 records per second (actually, this process had been stopped as a result of an attempt to create another table, and since than, the server is dead.) thanks in advanced for any help, ewilde

2 1

[MonetDB-users] New to MonetDB
by Shankar Yoganathan 13 Apr '08

13 Apr '08

Hello I am new to monetDB. I have a few questions about using MonetDB in embedded environment. I read in the embedded server page that only client is allowed to connect to the embedded server. 1. Does this mean I can not have multiple processes accessing the same database? 2. Can multiple threads with in the same process access the same database? 3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can automatically populate the database to the previous state? Thank you for your help in advance Shankar

3 2

[MonetDB-users] linux flavor
by mobigital1 12 Apr '08

12 Apr '08

>From my testing of the windows 64 bit port it seems that may be the linux version is a bit more stable to run? (due to specifics of memory mapped file implementations)? can anyone suggest what flavor of linux is best to use to load most data? also the one that's easy to run under vmware? -- View this message in context: http://www.nabble.com/linux-flavor-tp15860790p15860790.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] cvs version (0.23) error
by Jorge Martín Cuervo 09 Apr '08

09 Apr '08

Hi all, I use the an script to download and compile the latest version of cvs, but despite theres no error messages and seems to start very good i can't store any file. The version i see in the console is 0.23, and if i return to my 0.22 version compiled from source it works perfect. I mean storing files, listing and so on. Also, i made a simple java program that connects to database throw jdbc to create documents quickly, and works pretty good with 0.22, but no way with 0.23. In the console (http://127.0.0.1:50001/admin/) i get the same error when i push on every button: Internal Receiver Error: out-of memory any idea? thanks. -- ;-) ____________________________________ Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email <jorge.martin(a)defactops.com> voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info(a)defactops.com) También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

1 0

[MonetDB-users] !ERROR: err:FORG0001
by Jorge Martín Cuervo 08 Apr '08

08 Apr '08

Hi all, i have some error messages from mclient when i try to run an xquery. First i've got: ERROR = !type error: body of hr:fw() evaluates to `double | integer' which is not a subtype of `xs:double' and i removed the return type from function, and later i've got: ERROR = !ERROR: err:FORG0001: could not cast value from string to double. is there any way to know where is the error (like the before message)? thanks. -- ;-) ____________________________________ Jorge Martin Cuervo Outsourcing Emarketplace deFacto Powered by Standards email <jorge.martin(a)defactops.com> voice +34 985 129 820 voice +34 660 026 384 ____________________________________ DE FACTO STANDARDS, S.L., le informa que su dirección de correo electrónico, así como el resto de los datos de carácter personal que nos facilite, serán objeto de tratamiento automatizado en nuestros ficheros, con la finalidad del envío de información comercial y/o personal por vía electrónica. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica de Protección de Datos de Carácter Personal (LOPD. 15/1999), dirigiendo un escrito a C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias), o a nuestra dirección de correo electrónico (info(a)defactops.com) También informamos que la información incluida en este e-mail es CONFIDENCIAL, siendo para uso exclusivo del destinatario arriba mencionado. Si Usted lee este mensaje y no es el destinatario indicado, le informamos que está totalmente prohibida cualquier utilización, divulgación, distribución y/o reproducción de esta comunicación sin autorización expresa en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos nos lo notifique inmediatamente por esta misma vía y proceda a su eliminación. This e-mail contains information that will be added to our computerised guest data base and will be trated in the strict confidence. If you wish to access, correct, oppose or cancel your details, as specified the Law 15/99, December 13th, please send a certified letter to this effect to DE FACTO STANDARDS, S.L.., (C/ Rivero 31 1º Izda. - 33402 AVILES (Asturias) SPAIN). If you read this message, and is not the destinatary, we informal you that is forbidden anything utility, distribution, divulgation or reproduction of this communication without express authorization, of the present law. If you received this message for mistake, we proud in order to the present law, immediate communication to us, and please erase this e-mail

4 12

[MonetDB-users] urlbox in MonetDB5
by Gifford Hesketh 02 Apr '08

02 Apr '08

Can someone help me understand exactly what the urlbox is for and how to use it ?

1 0

[MonetDB-users] blobs performance
by Henrik Vendelbo 29 Mar '08

29 Mar '08

I am working through the options for clustered file management. Normally I would expect fairly poor performance of binary file storage in a database. Hence I would favor using the file system, and sync across the machines in the cluster. Being quite different from common relational implementations, how well does Monet handle blobs of 1-10Mb? As a side question is there a support for multi-master replication? The technology looks really impressive, I hope to be able to base my future projects on MonetDB Thanks, Henrik

1 0

[MonetDB-users] !IOException:mal_mapi.listen When Starting MonetDB5 SQL Server
by kevin.haas＠openbi.com 27 Mar '08

27 Mar '08

When I try to start the MonetDB5 Server, I get the following error: # MonetDB server v5.4.0, based on kernel v1.22.0 # Serving database 'demo' # Compiled for i686-pc-win32/32bit with 32bit OIDs dynamically linked # Copyright (c) 1993-2008 CWI, 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\CWI\MonetDB5\etc\monetdb5.conf) !IOException:mal_mapi.listen:Creation of stream socket failedi: Unknown error #function user.main():void; ##library logger; # alarm.prelude(); ##command bat(ht:int, tt:int) :bat[:any_1,:any_2] ##address BKCnewBat_default ##comment "Creates a new empty transient BAT with head- and tail-types ## as indicated."; ##command bat(ht:int, tt:int, size:lng) :bat[:any_1,:any_2] <EDITED FOR BREVITY> ##comment "Execute the XQuery against the elements #end main; # MonetDB/SQL module v2.22.0 loaded > This does not seem like a "good" error. Any tips on how to correct? -- View this message in context: http://www.nabble.com/%21IOException%3Amal_mapi.listen-When-Starting-MonetD… Sent from the monetdb-users mailing list archive at Nabble.com.

3 3