Hello Team,
I had shared all the data with Lefteris. When database crashes we restore it
from the backup.
Thank you
Souri Ratnaparkhi
United Software Associates Pvt. Ltd.
Pune, India
Mob: 8975677255
Phone (India Lines): (91) 020-25445550
www.usain.com
-----Original Message-----
From: users-list
[mailto:users-list-bounces+souri.ratnaparkhi=usain.com@monetdb.org] On
Behalf Of Stefan Manegold
Sent: Monday, March 14, 2016 2:10 PM
To: Communication channel for MonetDB users
Subject: Re: Monetdb crashes.
Dear Souri,
as both Hannes and Lefteris already mentioned with their replies to your
earlier messages, we need detailed instructions (and data) how to reproduce
the problem, otherwise, we have no means to debug it.
We easily operate tables with thousands of columns and millions of rows in
MonetDB; hence, neither is expected to be a problem in general.
If your server crashes, and then fails to restart, this should be reflected
in the merovingian.log . Please re-consult the log and feel free to share
the relevant snippets.
If the server fails to restart and you fail to reconnect, how could you test
with inserting fewer records into the very same table or inserting all
records into a new empty table?
Best,
Stefan
----- On Mar 14, 2016, at 5:10 AM, Souri Ratnaparkhi
souri.ratnaparkhi@usain.com wrote:
> Hello,
> We have a main table with 126 columns and approx. 94000 rows.
> We are trying to load approx 2500 records from temporary table into
> main table using query “insert into select” query. The database
> crashes upon query execution.
> We get error “ monetdbd: internal error while starting mserver, please
> refer to the logs ” when to try to connect again.
>
>
> No specific error is created in log file.
> 1500 records successfully loads from temp table to main table.
> We also created another main table with same DDL, that table is empty
> & inserted all the records from temp successfully without any issue.
>
> What could be the reason? Is 126 cols an issue? Please help. We are stuck.
>
> (btw: We have machine about 200GB of hard disk & 16 GB RAM (14 GB
> free))
>
> OS - Ubuntu 14.04.2 LTS (GNU/Linux 3.13.0-55-generic x86_64)
>
> Monetdb version - MonetDB v11.21.13 (Jul2015-SP2)
>
>
> Thank you
>
>
>
>
> Souri Ratnaparkhi
> United Software Associates Pvt. Ltd.
> Pune, India
> Mob: 8975677255
> Phone (India Lines): (91) 020-25445550 www.usain.com
>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
--
| Stefan.Manegold@CWI.nl | DB Architectures (DA) |
| www.CWI.nl/~manegold/ | Science Park 123 (L321) |
| +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list