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