- users-list - monetdb.org

[MonetDB-users] MonetDB binary distribution question
by Hans van Rijswijk (DT) 14 Nov '08

14 Nov '08

Dear MonetDB users, Our install procedure for MonetDB currently consists of unpacking MonetDB-Aug2008-SuperBall.tar.bz2 and running the monetdb-install.sh script. This takes a long time to complete. We would like to get or create a binary distribution for a Linux system (Ubuntu 8.04 / Fedora). For this, we like to know the following: - Is the Monet binary dependent on the system where it is built? - Can we pack the generated binaries and install them on a different Linux (Ubuntu/Fedora) … [View More]

3 2

[MonetDB-users] Table trace in file system
by Alfred Nordman 13 Nov '08

13 Nov '08

Hi there, Is there any way to export\import tables between machines by only coping files and\or folders Thanks, Alfred -- View this message in context: http://www.nabble.com/Table-trace-in-file-system-tp20478519p20478519.html Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] MonetDB install script problem.
by Hans van Rijswijk (DT) 13 Nov '08

13 Nov '08

Dear monetdb-users, When installing MonetDB (compile from MonetDB-Aug2008-SuperBall.tar.bz2) we encountered a problem. We had Java JDK installed, but no Internet connection. The monetdb-install.sh script stopped with an error message: fetching MonetDB-java failed! After some investigation we found what the problem might be: In line 209 and following lines the monetdb-install.sh script tests whether a java compiler and ant are present. If present the fetch() procedure tries to get the Java … [View More]

2 1

[MonetDB-users] More timing information in MonetDB/XQuery
by pitro55 13 Nov '08

13 Nov '08

Hi, I am running some XQuery queries on MonetDB/XQuery (june release) and I cannot get all timing information like trans, fetch, shred, print time. All I can get is one time ofomration Timer, which I guess is overall information about how much time did the query take. I tried to run queries both in session and from shell: 1. xquery>\t xquery>\<test.xq 2. mclient -lx -t test.xq My OS is MAC OS 10.5 (Leopard). When I tried it on Windows, I will get all the timing information. … [View More]

2 1

[MonetDB-users] JDBC Support
by nori 11 Nov '08

11 Nov '08

Hi, Is there a plan to support JDK(JRE)6 in JDBC driver? Regards. Nori.

2 2

[MonetDB-users] MonetDB server thread architecture
by xxiao 28 Oct '08

28 Oct '08

Hi, does anyone know whether there is any doc on how the server is implemented in Pthreads, such as how many threads are forked and what job each different thread is responsible for? Thanks a lot. -- View this message in context: http://www.nabble.com/MonetDB-server-thread-architecture-tp20134440p2013444… Sent from the monetdb-users mailing list archive at Nabble.com.

2 9

[MonetDB-users] How to print a BAT with MIL?
by Chaojing Yang 26 Oct '08

26 Oct '08

Dear all, I'm using MonetDB/XQuery. After i have added a few XML-files into MonetDB, i want to check out how their BATs looks like. /MonetDB>ls(); #---------------------------------------------------------------------------------------------------------------------------------# # name htype ttype count heat dirty status kind refcnt lrefcnt # # str str str lng int str … [View More] str str int int # #---------------------------------------------------------------------------------------------------------------------------------# [ "1000000001_attr_own", "void", "oid", 5, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_attr_prop", "void", "oid", 5, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_attr_qn", "void", "oid", 5, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_frag_root", "oid", "oid", 1, 0, "clean", "disk", "pers", 0, 1 ] [ "1000000001_map_pid", "void", "oid", 1, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_nid_rid", "void", "oid", 25, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_prop_com", "void", "str", 0, 0, "clean", "disk", "pers", 0, 2 ] [ "1000000001_prop_ins", "void", "str", 0, 0, "clean", "disk", "pers", 0, 2 ]/ *I get a list of BAT-data summary. But i cann't figure out how to use print functions from buildin module as listed:* / / 231 .COMMAND print(ANY value) = CMDprint_val; 232 "Print a MIL value between square brackets." 233 234 .COMMAND print(BAT[ANY::1,ANY], ...BAT[ANY::1,ANY]...) = CMDprint_table; 235 "BATs are printed with '#' for legend lines, and the BUNs on seperate 236 lines between brackets, containing each to comma separated values 237 (head and tail). 238 If multiple BATs are passed for printing, print() performs an implicit 239 natural join, producing a multiattribute table." 240 241 .COMMAND print(INT order, BAT[ANY::1,ANY], ...BAT[ANY::1,ANY]...) 242 = CMDprint_otable; 243 "The same as normal table print, but enforces to use the order of 244 BAT number [1..argc] to do the printing." 245 246 .COMMAND table(BAT[any::1,any], ...BAT[any::1,any]...) = print_table_default; 247 "Print an n-ary table. Like print(n-ary) but does not print oid column" 248 249 .COMMAND table(INT order, BAT[any::1,any], ...BAT[any::1,any]...) = print_table; 250 "Print an n-ary table. Use the ordering of param [1..argc]" 251 252 .COMMAND multitable(BAT[any,bat]) = CMDprint_multitable; 253 "Print an n-ary table contained within a BAT of BATs" 254 255 .COMMAND printf(str format, ...) = print_format; 256 "Print a formatted string on the standard client output." 257 258 .COMMAND sprintf(str format, ...) : str = print_str; 259 "Print a formatted string on the standard client output." 260 261 262 .END builtin; One single example may help me out of this trap. Best regards, Chaojing ------------------------------------------------------------------------------------------------------------------------------------------ Email: chaojing.yang(a)gmail.com Blog: http://goethe-ist-taoist.blogspot.com/ §1 Ich widerspreche der Nutzung oder Übermittlung meiner Daten für Werbezwecke oder sowie andere unbefugte Verwendungszwecke. (§ 28 Abs. 4 BDSG=Bundesdatenschutzgesetz). §2 Durch die Datenübertragung bzw. Kommunikation per E-Mail liegt ein Verstoß gegen das BDSG vor, da ihre Daten insoweit nicht ausreichend geschützt sind. Ich bitte Sie daher, mir schriftlich zu bestätigen, dass Sie mit dem Verstoß gegen das BDSG einverstanden sind und keine Schadensersatzanspräche bzw. Unterlassungsanspräche mir gegenüber geltend machen. §3 Der Inhalt dieser Nachricht ist vertraulich und nur für den oben angegebenen Empfänger bestimmt. [View Less]

3 3

[MonetDB-users] Using MonetDB on Windows X64
by Daniel Murray 24 Oct '08

24 Oct '08

Hi all, I am trying to use MonetDB on a 32bit Windows XP SP2, but am having a lot of trouble given the size of my tables. Is there any experience in regards to using MOnetDB on a "virtual" server set up on Windows 2003 Server and configuring it with "X64" inlieu of a true "64bit". Thanks you in advance for your support. Daniel Murray G.

1 0

[MonetDB-users] Use cases for monetdb
by steve 24 Oct '08

24 Oct '08

What are the use cases for monetdb?

3 3

[MonetDB-users] MonetDB5 Server crashes and shuts-down
by Daniel Murray 22 Oct '08

22 Oct '08

Hi All, I am working with Windows XP SP2 (32-bit), with 2Gb RAM; am using Java 1.5. I downloaded MonetDB5-SQL-Installer-i386-20080624.msi; Squirell has been update to use monetdb-1.8-jdbc.jar. I am trying to upload data from MySQL to MonetDB5, using the MonetDB Bulk Loader that comes with Pentaho Kettle 3.1. I am using a MySQL table with a little over 9 millon rows & 7 columns (2 BIGINT, 2 INT and 3 FLOAT, consequently I understand no encoding issues are involved). After a number of … [View More]failed transformation attempts to load my data to MonetDB, on all attempts the Monetdb Server is suddenly shutting down after some 20,000 records are processed. When trying to review the data -that I understand to be in MonetDB- using Squirell, the following server console screen out is shown (I had to modify the .config file to "gdk_debug=1") and as likewise, the MonetDB Server shuts down: ***console output start*** C:\MONETDB\CWI\MonetDB5>MSQLServer.bat # MonetDB server v5.6.0, based on kernel v1.24.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:\MONETDB\CWI\MonetDB5\etc\monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.24.0 loaded >!01 ERROR: MT_mmap: MapViewOfFileEx(150c, 1, 0, 0, 196885248, 0) failed !01 OS: Espacio de almacenamiento insuficiente para procesar este comando. #01 #GDKmmap(196885248) fail => BBPtrim(enter) usage[mem=4583848,vm=1158283264] #01 #mallinfo.arena = 5927701 #01 #mallinfo.ordblks = 61996 #01 #mallinfo.smblks = 383 #01 #mallinfo.hblkhd = 0 #01 #mallinfo.hblks = 0 #01 #mallinfo.usmblks = 1768421 #01 #mallinfo.fsmblks = 345928 #01 #mallinfo.uordblks = 3811784 #01 #mallinfo.fordblks = 1568 #01 #BBPTRIM_ENTER: memsize=4583848,vmsize=1158283264 #01 #BBPTRIM: memtarget=0 vmtarget=1073741824 #01 #TRIMSCAN: mem=0 vm=1, start=1, limit=1 #01 #TRIMSCAN: 92596* 0=tmp_2143 (#20500000) #01 #TRIMSCAN: 92598* 1=tmp_2144 (#20510000) #01 #TRIMSCAN: 92599* 2=tmp_2145 (#20510000) #01 #TRIMSCAN: 92600* 3=tmp_2146 (#20510000) #01 #TRIMSCAN: 92601* 4=tmp_2147 (#20510000) #01 #TRIMSCAN: 92602* 5=tmp_2151 (#20500000) #01 #TRIMSCAN: end at 1 (size=1197) #01 #TRIMSELECT: dirty = 0 #01 #TRIMSELECT: candidate=tmp_2143 BAT*=454e700 #01 # (cnt=20500000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92598,92596,-2147391052) #01 #TRIMSELECT: delete tmp_2143 from trimlist (has been touched since last scan ) #01 #TRIMSELECT: candidate=tmp_2144 BAT*=454e7f8 #01 # (cnt=20510000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92599,92598,-2147391050) #01 #TRIMSELECT: delete tmp_2144 from trimlist (has been touched since last scan ) #01 #TRIMSELECT: candidate=tmp_2145 BAT*=454e8f0 #01 # (cnt=20510000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92600,92599,-2147391049) #01 #TRIMSELECT: delete tmp_2145 from trimlist (has been touched since last scan ) #01 #TRIMSELECT: candidate=tmp_2146 BAT*=454e9e8 #01 # (cnt=20510000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92601,92600,-2147391048) #01 #TRIMSELECT: delete tmp_2146 from trimlist (has been touched since last scan ) #01 #TRIMSELECT: candidate=tmp_2147 BAT*=454eae0 #01 # (cnt=20510000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92602,92601,-2147391047) #01 #TRIMSELECT: delete tmp_2147 from trimlist (has been touched since last scan ) #01 #TRIMSELECT: candidate=tmp_2151 BAT*=454ecd0 #01 # (cnt=20500000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92596,92602,-2147391046) #01 #TRIMSELECT: keep tmp_2151 [82035748,82035520] bytes [82035748,82035520] dir ty target(mem=0 vm=1073741824) #01 #TRIMSELECT: end #01 #TRIMSELECT: dirty = 1 #01 #TRIMSELECT: candidate=tmp_2151 BAT*=454ecd0 #01 # (cnt=20500000, mode=4096, refs=0, wait=0, parent=0,0, lastused= 92596,92602,-2147391046) #01 #TRIMSELECT: unload tmp_2151 [82035748,82035520] bytes [82035748,82035520] d irty #01 #TRIMSELECT: end #01 #BBPTRIM: lastused batid name #01 #BBPTRIM: -2147391046 1129 tmp_2151 #01 #BBPTRIM_EXIT: memsize=114688,vmsize=1076232192 #01 #GDKmmap(196885248) fail => BBPtrim(ready) usage[mem=4583792,vm=1076232192] #01 #mallinfo.arena = 5927717 #01 #mallinfo.ordblks = 61993 #01 #mallinfo.smblks = 384 #01 #mallinfo.hblkhd = 0 #01 #mallinfo.hblks = 0 #01 #mallinfo.usmblks = 1768421 #01 #mallinfo.fsmblks = 346232 #01 #mallinfo.uordblks = 3811728 #01 #mallinfo.fordblks = 1336 !01 ERROR: MT_mmap: MapViewOfFileEx(1510, 1, 0, 0, 196885248, 0) failed !01 OS: Espacio de almacenamiento insuficiente para procesar este comando. !01 ERROR: GDKload: cannot mmap(): name=21\2150, ext=tail !01 OS: Espacio de almacenamiento insuficiente para procesar este comando. !01 ERROR: GDKload failed: name=21\2150, ext=tail ***console output ends*** Furthermore, I have tried to find the folders holding \var\MonetDB5\dbfarm with no luck. Ie, they are not in the MonetDB folders that are installed when using the Windows Installer referenced above. I would very much appreciate any asisstance you can provide, as my interest is to actively use MonetDb in my DW / BI projects. Kind Regards, Daniel Murray [View Less]

1 0