search

hannes / MonetDBLite

MonetDB reconfigured as a library
108 stars 11 forks source link

MonetDBLite database timing out and shutting down #189

Open caewok opened 7 years ago

caewok commented 7 years ago

In long-running Rscripts (several hours at least) it appears that the MonetDBLite database may be shutting down. As a result, a new connection cannot be made as it gives the following error:

Error in monetdb_embedded_query(conn@connenv$conn, statement, execute, : Call monetdb_embedded_startup() first

Are there parameters that I can set to define how long the database runs? Is the embedded database supposed to shutdown after a certain period?

Thanks.

hannes commented 7 years ago

It is not supposed to shut down. Can you describe the circumstances in more detail?

caewok commented 7 years ago

This happens when running a long program, such as training a set of models. For example, the code might pull data from the database, then train a model that takes several hours or more, then attempt to retrieve more data from the database. For the second pull from the database, even starting a new connection does not work, because it errors out claiming the database is not running.  Thanks!

On Monday, August 21, 2017, 2:12:46 AM PDT, Hannes Mühleisen notifications@github.com wrote:

It is not supposed to shut down. Can you describe the circumstances in more detail?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

hannes commented 7 years ago

Thats odd because creating a new connection should start the DB up if it is not running. Are you trying to start another DB during the script? Is the connection saved to disk (serialized) and reloaded?