RE: MonetDB, data loss in restart server
Anyone have any idea about ?
- OS is Debian 7 64-bit, in a VM in VMware virtualization System.
- Hard disk 100G with 26% usage.
- 5 cores.
- 6G RAM.
- Version MonetDB: MonetDB 5 server v11.15.17 "Feb2013-SP5"
- Table: create table (id int, dt date, product varchar (50) .... etc,
and another 30 columns between int and varchar.
- Query: select dt, count (id) from table where produtct in (....) group
by dt
Message: 1
Date: Thu, 2 Apr 2015 23:16:39 +0200
From: Ying Zhang
On Wed, Apr 08, 2015 at 11:08:53AM -0300, Luciano Sasso wrote:
Anyone have any idea about ?
- OS is Debian 7 64-bit, in a VM in VMware virtualization System. - Hard disk 100G with 26% usage. - 5 cores. - 6G RAM. - Version MonetDB: MonetDB 5 server v11.15.17 "Feb2013-SP5" Thats a very old version. I recall a fix which we did in the meantime related to possible data loss, ie we added extra f(data)sync calls. Which could very well be the problem on a virtual system.
Niels
- Table: create table (id int, dt date, product varchar (50) .... etc, and another 30 columns between int and varchar. - Query: select dt, count (id) from table where produtct in (....) group by dt
Message: 1 Date: Thu, 2 Apr 2015 23:16:39 +0200 From: Ying Zhang
https://www.monetdb.org/mailman/listinfo/users-list> To: "Communication channel for developers of the MonetDB suite." https://www.monetdb.org/mailman/listinfo/users-list> Cc:users-list at monetdb.org https://www.monetdb.org/mailman/listinfo/users-list Subject: Re: MonetDB, data loss in restart server Message-ID:<6C2903C0-4399-462D-9D3F-822351DE1979 at cwi.nl https://www.monetdb.org/mailman/listinfo/users-list> Content-Type: text/plain; charset=windows-1252 Hello Luciano,
Thanks for using monetdb, and sorry for the inconvenience. Would you please give us some background information about your setting:
- which OS? - hardware spec. of your system - which monetdb version? - what does your query do? - when and how did the database stop? If the monetdb server stopped, did it give any error message? - what's at the end of the merovingian log?
With kind regards,
Jennie
--
Luciano Sasso Vieira Gestor - Inteligência de Negócios
luciano@gsgroup.com.br http://www.gsgroup.com.br | tel: 17 3353-0833 | cel: 17 9706-9335 www.gsgroup.com.br http://www.gsgroup.com.br
--- Este email foi escaneado pelo Avast antivírus. http://www.avast.com
_______________________________________________ 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
participants (2)
-
Luciano Sasso -
Niels Nes