July 2009 - users-list

[MonetDB-users] Server only runs on machine it was built on.
by Alex Bo. 13 Jul '09

13 Jul '09

Hi, I successfully built the May2009 SP on Windows from CVS. However, when I copy the files and run MSQLserver.bat on other machines, I get the following error from the server which fails to start: #WARNING: LoaderException:loadLibrary:Loading errorThe application has failed to start because its side-by-side configuration is incorrect. Please see the appli cation event log for more detail. .pcre #WARNING: LoaderException:loadLibrary:Loading errorThe application has failed to start because its side-by-side configuration is incorrect. Please see the appli cation event log for more detail. .pcre Please help. Thanks. -- View this message in context: http://www.nabble.com/Server-only-runs-on-machine-it-was-built-on.-tp244592… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] select count(*) not understood by squirrelsql
by Franck Routier 13 Jul '09

13 Jul '09

Hi, using squirrelsql to access Monetdb (so, via jdbc), the tool fails to display the result for select count(*) from table; Instead it will display <Other>. On the metadata tab, it says the result is seen as culumnType = 1111, columnTypeName = wrd Issuing the same command in montdb command line display the result. Any idea ? Franck

3 6

[MonetDB-users] mserver5/ubuntu crash
by dariuszs 12 Jul '09

12 Jul '09

Hi, mserver5 crashed on ubuntu 64bit while running this query select count(*) from table1 where c1 like 'New Y%'; root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit 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 /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded >Bus error root@monetdb:~# /var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0

3 5

[MonetDB-users] sql module of May2009 SP doesn't compile on windows
by Alex Bo. 12 Jul '09

12 Jul '09

Hi, When building the sql module of MonetDB May2009 SP from CVS on Windows, I get the following compilation errors: sql_gencode.c .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : error C2065: 'leftjoinR ef' : undeclared identifier .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : warning C4047: 'functio n' : 'char *' differs in levels of indirection from 'int' .\..\..\..\..\src\backends\monet5\sql_gencode.mx(1027) : warning C4024: 'newStmt 2' : different types for formal and actual parameter 3 Please help. -- View this message in context: http://www.nabble.com/sql-module-of-May2009-SP-doesn%27t-compile-on-windows… Sent from the monetdb-users mailing list archive at Nabble.com.

2 6

[MonetDB-users] Is monetDB nativeXML or not?
by Mtekel 10 Jul '09

10 Jul '09

Hello, I have a question, whether MonetDB/XQuery is native XML database or not. To clarify what is native or not, http://en.wikipedia.org/wiki/XML_database : " Two major classes of XML database exist: XML-enabled: these map all XML to a traditional database (such as a relational database), accepting XML as input and rendering XML as output. This term implies that the database does the conversion itself (as opposed to relying on middleware). Native XML (NXD): the internal model of such databases depends on XML and uses XML documents as the fundamental unit of storage, which are, however, not necessarily stored in the form of text files. " Then according to this page, monetDB is native XML: http://monetdb.cwi.nl/MonetDB/Version4/Documentation/monet/index.html " 2 MonetDB Features MonetDB is database engine geared at high performance on systems with (complex) queries that have to analyze large amounts of data (i.e. OLAP, not OLTP). The features in which it most differs from other DBMSs are summarized below: Independence of SQL: MonetDB has a front-end/back-end design allowing the storage of more than just relational tables (such as object-oriented or native XML data), and allowing the use of querying paradigms other than just SQL (such as OQL and XQuery). " Whereas according to this one, it is not: http://monetdb.cwi.nl/projects/monetdb/XQuery/Documentation/Separate-Documen ts-vs-Document-Collections.html#Separate-Documents-vs-Document-Collections : " 2.9.1.1 Storage Overhead In MonetDB/XQuery all XML is stored in relational tables. " Is then monetDB really native? Thanks in advance for clarification... Regards, M. Tekel

3 2

[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