Hi Ramak, I can reproduce your problem. Could you please file a bug report via http://bugs.monetdb.org/ ? Until we manage to locate and hopefully fix the problem, I'd recommend to simply omit the "--single-user" option --- everything seems to work fine without "--single-user". What was/is your reason/need to use MonetDB in single-user mode? Stefan On Sun, Jun 12, 2011 at 09:59:37AM -0700, Ramak wrote:
Hi,
I am trying to use MonetDB in single user mode. While I could load the data using "COPY INTO" command and run a few select queries successfully, the moment i run a query with group by on more than one column, the server crashes saying " ---- >Segmentation fault". Is there a way to get around it? or, am I using it the wrong way? I could recreate the problem doing this--- 1. Start server with "sudo mserver5 --dbfarm='/home/user/work/tmp/data/test' --single-user" 2. start mclient (and create a simple table and fire a select query with group by on multiple columns)
create table test ( market_size int not null, market int not null, state int not null); select count(*) from test group by market_size, state; -- server crashes on the above query.
I am using MonetDB 5 server v11.3.3 "Apr2011-SP1" (64-bit, 64-bit oids)
Thanks, Ram
-- View this message in context: http://old.nabble.com/Select-Query-crashes-the-server-with-%22--single-user%... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |