MonetDB, data loss in restart server
Hello, I have used the MonetDB in production for some time, and I have nothing to complain about, are tables with more than 30 columns and 30 million records, do analysis through cubes in Pentaho / Saiku. Have restarted the server several times, and never had problems with loss of data.But today, after performing a query that was consuming a lot of machine, stopped the database, and when I started, data from some columns were blank. How can it, will the data were still uncommitted? when performing a query the MonetDB changes the data or reorganized? which may have occurred, I am concerned. -- 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
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
On Apr 01, 2015, at 06:46, Luciano Sasso
wrote: Hello,
I have used the MonetDB in production for some time, and I have nothing to complain about, are tables with more than 30 columns and 30 million records, do analysis through cubes in Pentaho / Saiku. Have restarted the server several times, and never had problems with loss of data.But today, after performing a query that was consuming a lot of machine, stopped the database, and when I started, data from some columns were blank. How can it, will the data were still uncommitted? when performing a query the MonetDB changes the data or reorganized? which may have occurred, I am concerned.
--
Luciano Sasso Vieira Gestor - Inteligência de Negócios luciano@gsgroup.com.br | tel: 17 3353-0833 | cel: 17 9706-9335
www.gsgroup.com.br Este email foi escaneado pelo Avast antivírus. www.avast.com
_______________________________________________ developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list
participants (2)
-
Luciano Sasso
-
Ying Zhang