What is normally done to recover from 'crash'ed databases.
Hello, I have a toy database on my laptop that I've been using while testing development of a Pentaho Data Integration plugin for bulk loading. One day I shutdown my machine without stopping monetdb. When I turned on the computer and started monetdbd on the database everything seems to work fine. 'monetdb status' outputs the following: brandon-jacksons-macbook-pro:bin bjackson$ ./monetdb status name state uptime health demo crashed 0%, 0s crash 2013-01-05 00:29:20 brandon-jacksons-macbook-pro:bin bjackson$ ./monetdb start demo starting database 'demo'... done brandon-jacksons-macbook-pro:bin bjackson$ ./monetdb status name state uptime health demo running 5s 50%, 0s crash 2013-01-05 00:29:20 brandon-jacksons-macbook-pro:bin bjackson$ I cannot really tell if there is any real damage. What do people normally do to check the integrity of their databases and repair damage if it exists? Does a set of actions restore the health of the database? If I missed some documentation please feel free to refer me to some links. Thanks for the information. Brandon _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 08-01-2013 12:21:34 -0600, Brandon Jackson wrote:
brandon-jacksons-macbook-pro:bin bjackson$ ./monetdb status name state uptime health demo running 5s 50%, 0s crash 2013-01-05 00:29:20 brandon-jacksons-macbook-pro:bin bjackson$
I cannot really tell if there is any real damage. What do people normally do to check the integrity of their databases and repair damage if it exists? Does a set of actions restore the health of the database?
The "crash" info is not cleared. For the next feature release, this has changed, to avoid confusion like this. In that release, a successful start (which includes a recovery of the database) will clear the crashed flag. In your case now, you can safely ignore the last crash information. -- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
I had a problem over Christmas where my database ended up on 0% health and
had restore it from a dump . The db would not start at all is that what 0%
health would trigger and is there anyway of clearing the crashed status.
Brian Hood
On Jan 8, 2013 6:27 PM, "Fabian Groffen"
On 08-01-2013 12:21:34 -0600, Brandon Jackson wrote:
brandon-jacksons-macbook-pro:bin bjackson$ ./monetdb status name state uptime health demo running 5s 50%, 0s crash 2013-01-05
00:29:20
brandon-jacksons-macbook-pro:bin bjackson$
I cannot really tell if there is any real damage. What do people normally do to check the integrity of their databases and repair damage if it exists? Does a set of actions restore the health of the database?
The "crash" info is not cleared. For the next feature release, this has changed, to avoid confusion like this. In that release, a successful start (which includes a recovery of the database) will clear the crashed flag. In your case now, you can safely ignore the last crash information.
-- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 08-01-2013 20:21:49 +0000, Brian Hood wrote:
I had a problem over Christmas where my database ended up on 0% health and had restore it from a dump . The db would not start at all is that what 0% health would trigger and is there anyway of clearing the crashed status.
No. A start should bring it out of the crash status, or bring it into a new crash state, in which case you have a serious problem. -- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Brandon Jackson -
Brian Hood -
Fabian Groffen