RE: MonetDB, data loss in restart server
OK, to update, just use apt-get, I will have problems with structure of database? I can use the old dbfarm, will be compatible? 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 />/ /
-- 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
On Wed, Apr 08, 2015 at 02:16:39PM -0300, Luciano Sasso wrote:
OK, to update, just use apt-get, I will have problems with structure of database? I can use the old dbfarm, will be compatible? Always backup your data. We are updatable from release to release. Do not skip versions as we drop support for older version soon after each release.
Niels
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 />/ /
--
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