October 2009 - users-list

[MonetDB-users] server does not start anymore
by wilfried＠hafner.ws 24 Oct '09

24 Oct '09

Hello! For some testing purposes, I created a file with 63.158.399 rows and tried to load it into a table with following structure: create table logtest ( id bigint, dim_year smallint, dim_month smallint, dim_day smallint, dim_hour smallint, dim_min smallint, dim_sec smallint ); I loaded the data in pieces of 20.000.000 rows with the 'copy into' command. At the last 3158399 there was an error, the connection to the server terminated, the server crashed. I restarted the server and the error message ERROR: HEAPextend: failed to extend to 480000000 for 01\14\11401tail was displayed. I tried to restart again, but its not possible anymore, the server immediatly returns and there is no error message... C:\MonetDB\MonetDB5>MSQLserver.bat # MonetDB server v5.14.2, based on kernel v1.32.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-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 C:\MonetDB\MonetDB5\etc\monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.32.2 loaded I know I can reinstall the server, but I would like to know the problem. Are there too much rows for the logtest table? There are about 10 other tables in the database, with 10 - 100 rows. As you can see from above, I'm using windows vista, 32 bit... The current size of the dbfarm folder is 1,52 GB, and the size of the file I tried to load is 1,72 GB. Thank you, Wilfried

2 4

[MonetDB-users] union bug?
by Allen Zhang 23 Oct '09

23 Oct '09

Hi, There, We encounter such a strange problem in the union in monetdb, when run attached sql. The where condition did not get applied towards the last union recordset. So the result from the attached sql is like 2009ABC 2008ABC 2007ABC ADD Notice the ADD get into the result!! But when we remove the last union of ADD, then the ABD gets into the result. Looks like the where condition gets ignored in the last union. Regards Allen

2 1

[MonetDB-users] mclient with mal
by Romulo Goncalves 22 Oct '09

22 Oct '09

Hello, Could someone explain what I could have done wrong to get this message when I start mclient: -bash-3.2$ ~/MonetDB/scripts/mclient current debug mal xchange_challenge: frontend mal not found I have the latest version of the cvs head. In the same machine there is another Mserver running. I used a different port for mine, i.e., there is two mservers running on the same machine... Regards, Romulo

2 3

[MonetDB-users] plz help
by ahmed_moon 22 Oct '09

22 Oct '09

Draw a Context as well as Level 0 Data Flow Diagram (DFD) of a Shop Sale Management System for a company sailing shops in different parts of country. The Shop Sale Management System works as follows: Ø Customer Places order. System checks availability of the customer in customer file (If he / she is already a customer). If found, then approved otherwise a new customer is created. Here new customer’s info is sent to ledger file. Ø Then the availability of shops is checked in the stock. If found, an Invoice is generated. Invoice info is sent to the customer, stock, ledger as well as sales department. Ø If shop is not available at this time, then this info is also sent to the customer. Purposes: Ensure that you can analyze existing manual system and can draw Data Flow Diagrams of any proposed system. Before Starting: Detail study of existing system. Rules for drawing DFDs. Differentiate different levels of DFDs. -- View this message in context: http://www.nabble.com/plz-help-tp26004897p26004897.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] bulk upload
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Is there a facility in MonetDB for batch upload of large sets of data, instead of executing many INSERT statements and inserting one row at a time?

3 2

[MonetDB-users] Star Schema and MonetDB
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Do I have to create Star Schema in Monet DB, or is it specially optimized for running data analysis on Just one large denormalized table?

2 1

[MonetDB-users] Invalid Identifier
by Roman Sokolyuk 21 Oct '09

21 Oct '09

So I am trying to import some data from a different DB to Monet. I created a large file with INSERT statements almost 7K insets. I saved it in a .sql file and tried importing it using \< [file_name] - that gave me almost 7K of Invalid identifier error messages. When I try just one insert out of that file it works fine though. Also, I compared my sql file to the VOC tutorial sql file and the only difference I see is that in mine each INSERT is one its own line - which means it has a newline character at the end of each line. Could this be creating a problem?

1 0

[MonetDB-users] How can I truncate a table
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Is there an equivalent in MonetDB of truncating or emptying a table of all data?

2 2

[MonetDB-users] timestamp conversion failed -How can I convert a char string to a timestamp
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Hi, I am trying to insert the following value into a timestamp column: '2/5/2008 4:05:31 PM' and I get the error message: !SQLException:timestamp:conversion of string '2/5/2008 4:05:31 PM' failed I would like to convert that date string into a timestamp type - is there a function in Monet to do that?

2 2

[MonetDB-users] SQL: Connect To statement, help request
by Bart Buter 21 Oct '09

21 Oct '09

I could use some pointers since I have trouble getting something started I have 2 machines ow138 ip:146.50.7.21 and ow139 ip:146.50.9.30 Both machines run a database with the name of the machine Merovingian is running on both systems >>monetdb discover location mapi:monetdb://ow139:50000/ow139 mapi:monetdb://ow138:50000/ow138 I would like to connect these databases using SQL: CONNECT TO statement, however I cannot seem to get past syntax errors etc. Thus something like >>mclient -lsql -d ow138 sql> CONNECT TO ow139 ..... Can someone please help me fill in the dots

2 1