On Wed, Apr 08, 2015 at 02:18:23PM +0000, Caroptions Caroptions wrote:
> Hi User-list!
> 
> 
> I am experiencing segfault monetdb crash, platform:
> 
> 
>   CentOS Linux release 7.1.1503 (Core) 
> 
>   3.10.0-229.1.2.el7.x86_64 #1 SMP Fri Mar 27 03:04:26 UTC 2015 x86_64
> x86_64 x86_64 GNU/Linux
> 
> 
> Table:
> 
> 
> CREATE TABLE "marketdata"."quotes" (
> 
> "id"     INTEGER       NOT NULL DEFAULT next value for
> "marketdata"."seq_6391",
> 
> "qtime"  TIMESTAMP WITH TIME ZONE NOT NULL,
> 
> "sdate"  TIMESTAMP WITH TIME ZONE,
> 
> "sym"    VARCHAR(10)   NOT NULL,
> 
> "cur"    VARCHAR(10)   NOT NULL,
> 
> "open"   DOUBLE        NOT NULL,
> 
> "high"   DOUBLE        NOT NULL,
> 
> "low"    DOUBLE        NOT NULL,
> 
> "close"  DOUBLE        NOT NULL,
> 
> "volume" DOUBLE,
> 
> CONSTRAINT "quotes_id_pkey" PRIMARY KEY ("id")
> 
> );
> 
> 
> SQL: 
> 
> 
> WITH cte(qtime, open, close, sdate, id, rnk) as (
> 
>   select qtime, sdate, id, row_number() over (partition by sdate order
> by qtime asc) as rnk
> 
>   from marketdata.quotes where sym='SPY'
> 
> ) select * from cte where rnk=1;
> 
> 
> ~2M records loaded from csv.
> 
> 
> Always segfault crashes monetdb daemon and DB became not repairable.
> 
> 
> 
> Reproducible on MonetDB-11.19.9 installed from yum repository, as well
> as compiled from sources, with-optimization and without.
> Also it crashed on latest development source branch 
> MonetDB-11c0c6cf614f with optimization and without.
> From mclient and JDBC client.
> 
> 
> Any help is very appreciated!! I am available to debug /
> provide additional information if needed.
John

 Could you add your bug to the bug tracker?

 Niels
> 
> 
> Thanks,
> John

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

-- 
Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098 	sip:4098@sip.cwi.nl
url: https://www.cwi.nl/people/niels	e-mail: Niels.Nes@cwi.nl