users-list March 2010

users-list@monetdb.org

22 participants
28 discussions

[MonetDB-users] Meaning of: Scenario not initialized 'sql'

by Alex Bo.

Hi, Sometimes I get !MALException:setScenario:Scenario not initialized 'sql' from the server when I try to start it in scenarios that usually work without any problems. I can't reproduce it consistently, but sometimes I get it. What does this exception mean? Thanks. -- View this message in context: http://www.nabble.com/Meaning-of%3A-Scenario-not-initialized-%27sql%27-tp26… Sent from the monetdb-users mailing list archive at Nabble.com.

12 years, 1 month

[MonetDB-users] Parallel Processing

by Nafees Ur Rehman

Hi, Does monetdb has support for parallel processing? If some can guide me on that. Regards Nafees Ur Rehman

12 years, 2 months

[MonetDB-users] Announcement: New Feb2010-SP1 bugfix release of MonetDB suite

by Sjoerd Mullender

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2010-SP1 bug fix release of the MonetDB suite of programs. More information on this release is available at <http://monetdb.cwi.nl/Development/Releases/Feb2010/>. -- Sjoerd Mullender

12 years, 3 months

[MonetDB-users] ubuntu server installation / php modules

by dariuszs

Hi, I've installed monetdb on *Ubuntu 9.04 Server* with apt-get. These are the contents of php client /. /usr /usr/share /usr/share/doc /usr/share/doc/php5-monetdb-client /usr/share/doc/php5-monetdb-client/changelog.Debian.gz /usr/share/doc/php5-monetdb-client/copyright I need the moduels, where are they? Thanks. Dariusz.

12 years, 4 months

[MonetDB-users] can't log in to my own databases...

by Robert Dormer

Hello all, I've installed monetdb from the Feb 2010 source release on a Gentoo 10.1 box. I've created a database (finance), and have released it from administration mode, but every time I try to access it with mclient, I get a prompt for a user name and password, followed by an InvalidCredentialsException:checkCredentials error. When I created the database it didn't ask for any user name or password. How do I get in to my own database?

12 years, 4 months

[MonetDB-users] doco on syntax for SQL create function?

by Michael Pheasant

Hi I'm trying to create an SQL function but struggling with thi syntax for the body of the function. Is there other more detailed doco than this page? http://monetdb.cwi.nl/SQL/Documentation/Functions.html#Functions Cheers Mike

12 years, 4 months

[MonetDB-users] PHP Benchmarks of Native versus Cimpl?

by Steve Benz

Hi~ I've recently converted our monet install from the cimpl version of the php interface to the new native socket interface. I see the readme references some benchmarks at a url that does not appear to exist (http://www.ins.cwi.nl/~gm/bench/). Would someone be able to please point me to a version of these? Thanks so much! Steve

12 years, 4 months

[MonetDB-users] Virtual Memory Requirement

by Hering Cheng

Hi, I am trying to understand the limitations of MonetDB with regard to memory. It seems that the amount of virtual memory (RAM plus swap space) available to MonetDB must be greater than the amount of data. Before I give up on MonetDB, can someone please confirm or correct my understanding? I did not understand the virtual memory requirement when I read the following in its documentation ( http://monetdb.cwi.nl/MonetDB/Documentation/Size-Limitations.html#Size-Limi… ): *The maximal database size supported by MonetBD depends on the underlying processing platform, e.g., a 32- or 64-bit processor, and storage device, e.g., the file system and disk raids. * For example, I started up merovingian (using the Feb 2010 release), limiting it and its child processes to 32 GB of virtual memory (via ulimit -v). I then try to load 115 GB of data into a single table. mclient reports the following: MAPI = chenher@myserver50000 COPY 472112651 RECORDS INTO mytable FROM 'mydata.txt' DELIMITERS '|', '\n'; ERROR = !SQLException:importTable:failed to import table !ERROR: HEAPextend: failed to extend to 1888450604 for 17/1734tail !ERROR: TABLETcreate_bats: Failed to create bat of size 472112651 I understand if MonetDB must be able to fit all its data within virtual memory. But if this is the case, then unfortunately I cannot use it, since I have terabytes of data and I do not have that much virtual memory on my hardware. Thank you. Hering

12 years, 4 months

[MonetDB-users] How to run monetdb and create a database, with the geom module?

by Michael Pheasant

I cannot figure out how to do geom stuff with the Fedora 12 rpm binary install. If I run $ sudo mserver5 --dbinit="include geom; include sql;sql.start();" then in another shell try and create a test database i get an error than monetdb (merovingian) is not running: $ sudo monetdb create test monetdb: cannot perform: MonetDB Database Server (merovingian) is not running If I run merovingian, then it starts the MonetDB with --dbinit="include sql" I can then create a database, but I cant load the GEOM extensions. So I feel like I end up in a catch-22. Can someone explain how I can run monetdb, and create a database, with the geom module? Cheers Mike.

12 years, 4 months

[MonetDB-users] Load a file.txt in bats

by Miguel Ángel Águila Lorente

Hello, I'm creating a database with MAL. I would need help for creating bats with the information of a file. May be It could be posible to do with tablet.load but I still not know how it works. The format of the file is quite simple: int;int;int; int;int;int; I expect you can help me. Thank you. Mike

12 years, 4 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

users-list March 2010