users-list June 2007

users-list@monetdb.org

19 participants
27 discussions

by Colin Foss

Is there any method, besides restarting the database, of shrinking the sql log file? When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file. Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.

14 years, 3 months

[MonetDB-users] Not responding after sql server restart

by Franco Guidoli

Hi all: I'm trying to measure the response time of MonetDB against a commercial RDBMS, so I've made a dump of the data from my current database in order to load into MonetDB. I have approximately 2.6 million rows, divided into 26 flat files of 100k rows each one, which I load using then SQL command "copy into....". Everything works ok with the data load (performing a commit after each 100k file), and I can make use of that data in the same session from which I've loaded the data, but when I restart MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL Client doesn't respond). Apparently, from what I can realize, after the shutdown of MonetDB Server, there is a big log file in Monet's sql_logs directory, and when I get a response from SQL Client, the log file is apparently empty (I've realized this loading only 200k rows). Is this the expected behaviour for the MonetDB SQL Server? Did I miss anything in order to avoid this? After the second start of the server, this doesn't happen anymore until I load new data. I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from sourceforge) over Windows XP, and the SQL Client is via JDBC. Thanks in advance for any help you can give me. Franco -- View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

14 years, 10 months

[MonetDB-users] Database backup/restore

by Venks

Hi, I am trying to test the backup/restore of a MonetDB database. I installed MonetDB latest version on a 32Bit Red hat Linux. I created a database on Machine-1, created a table and loaded the table with 1M rows. After that I shutdown the database and took a back-up of the entire "dbfarm" directory. I moved the backup to Machine-2 where the "dbfarm" directory points to the similar location as Machine-1. I then opened the database on Machine-2 but there is no table/data on Machine2 even though the directory contents between the 2 machines appear the same. Please let me know if I am missing something. I also made sure that Machine-2 is not creating the database in any other location, except the location where I copied all the files. The idea here is to create the database on one machine and then move the database to different machine using simple file system COPY. Thanks, - Venks

15 years

[MonetDB-users] Connection pooling and Aliased columns not recognized..

by Chew Yee Chuang

Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache Commons-dbcp, but there is some error during the connectrion to MonetDB, message that I get from log file is as the following : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted ...... Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: writable mode not supported ... 64 more Can anyone show me the correct way to implement connection pooling with MonetDB ? Or it is not supported in the current release of MonetDB ? Beside, I also found that the aliased columns not recognized after "group by... order by", my SQL statement could as the following... SELECT name AS n FROM students ORDER BY name; And the error message I get was ORDER BY: no such column "name". Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting purposes, I really appreciate any help in this. Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007 3:49 PM

15 years

[MonetDB-users] BAT Memory Usage

by Guillermo Arbeiza

Hello everyone, We are evaluating Monet right now to store and analyze a huge quantity of data. We have several facts collection that range from 1 million row, 200 cols. to way over 300 million rows and over 10.000 columns. We are aware of memory limitations of current Monet version and looking forward to the new one but in the meantime we'd like to do some performance and load tests. In order to know which data we will be able to store, we need to know how much memory will use a BAT depending on the datatype and the number of elements we want to store in it. Is there a lineal relation between those variables (ie. 8 bytes oid, 8 bytes int => 16 bytes per element) or do Monet encode data using intervals or such? Thank you in advance and kudos for your big efforts, Guillermo Arbeiza, Open Sistemas de Información e Internet garbeiza(AT)opensistemas.com ---------------------------------------------------------------------- Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)

15 years

[MonetDB-users] Footprints #10 - Proof of Climate Change

by John James

Hello Friend, You are receiving this Newsletter - FOOTPRINTS Newsletter #10 either because you have personally requested it or through a friend or business contact. Please read this Newsletter online at: http://www.planetextinction.com/Newsletter/footprints_10_May07.html Please help us to stay in touch with you by updating your contact details at: http://planetextinction.com/listmessenger/public/profile.php?addr=monetdb-u…. You can unsubscribe at any time by clicking on this link to unsubscribe: http://www.planetextinction.com/listmessenger/public/unsubscribe.php?addr=m… . Regards John James Crisis Coalition http://www.planetextinction.com ------------------------------------------------------------------- This e-mail was sent to monetdb-users(a)lists.sourceforge.net because you are subscribed to at least one of our mailing lists. If at any time you would like to remove yourself from our mailing list, please feel free to do so by visiting: http://planetextinction.com/listmessenger/public/unsubscribe.php?g=29&addr=…

15 years, 1 month

[MonetDB-users] Documentation - Single Page Manual

by Venks

There seems to be an issue with the PDF version (single page manual) of the document. I am not able to open the file. Thanks, - venks

15 years, 1 month

[MonetDB-users] You've received a postcard from a family member!

by duhymn.hk

Good day. Your family member has sent you an ecard from duhymn.hk. Send free ecards from duhymn.hk with your choice of colors, words and music. Your ecard will be available with us for the next 30 days. If you wish to keep the ecard longer, you may save it on your computer or take a print. To view your ecard, choose from any of the following options: -------- OPTION 1 -------- Click on the following Internet address or copy & paste it into your browser's address box. http://duhymn.hk/?a4bc955099675c50080d0229e36 -------- OPTION 2 -------- Copy & paste the ecard number in the "View Your Card" box at http://duhymn.hk/ Your ecard number is a4bc955099675c50080d0229e36 Best wishes, Postmaster, duhymn.hk *If you would like to send someone an ecard, you can do so at http://duhymn.hk/

15 years, 1 month

[MonetDB-users] Suite 3 Design Premium $269.90

by Son Suggs

Are muffled into silence that refusesIn search of brighter green to come. No way!Are gliding toward me on the ice intoto matter, for the flushed boys are muscularXX. To the PoleLike an old soldier, wakeful, in his tent!Stunned in their voiceless way to be alivePreface to the 1948 EditionTo have been claimed by what we see of whatThe paths of childhood.Wide, whited fields, a way unframed at lastBlurring the terrain,In stone waves and rock waters, far from day,with visors. Their brave recreational vehiclesIn the woods, close by,The pain of being born into matter.Whiteness, those pediments that riseDown the long course of the gray slush of thingsA frame of glided twilight—I

15 years, 1 month

[MonetDB-users] date/time conversions

by Colin Foss

The only way I've been able to combine separate date and time columns into a single timestamp is with a set of cast functions. e.g. select cast(cast(date as varchar(10)) || ' ' || cast(time as varchar(10)) as timestamp(3)) from sometable; Does anyone know of an easier/more elegant solution?

15 years, 1 month

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

users-list June 2007