RAS database corruption
RAS has a corrupted database. RAS still runs, but some series have become invisible to it and authors complain their profiles got emptied from those items. Trying to push them back (updareq) gets a response that they are already there, so nothing is done about it. I tried to recover. It exits with no troublesome message, but verifying the database gives issues in ACIS/files and ACIS/records. I tried fixing them from dump, but dumping crashes. Backups have even more errors when verifying them. At this point, I think I am left with having to rebuild the database. But I find no indication on how to do that. Christian Zimmermann FIGUGEGL! Economic Research Federal Reserve Bank of St. Louis P.O. Box 442 St. Louis MO 63166-0442 USA https://ideas.repec.org/zimm/ @CZimm_economist
Christian Zimmermann writes
RAS has a corrupted database. RAS still runs, but some series have become invisible to it and authors complain their profiles got emptied from those items. Trying to push them back (updareq) gets a response that they are already there, so nothing is done about it.
I tried to recover. It exits with no troublesome message, but verifying the database gives issues in ACIS/files and ACIS/records. I tried fixing them from dump, but dumping crashes. Backups have even more errors when verifying them.
I suggest you make sure you use recent versions of mariadb berkeleydb.
At this point, I think I am left with having to rebuild the database. But I find no indication on how to do that.
I think you need to empty the database of records, then move the Berkley files out of the way and then start updareq. I would take RAS offline while this is done. -- Cheers, Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
On Thu, 13 Sep 2018, Thomas Krichel wrote:
Christian Zimmermann writes
RAS has a corrupted database. RAS still runs, but some series have become invisible to it and authors complain their profiles got emptied from those items. Trying to push them back (updareq) gets a response that they are already there, so nothing is done about it.
I tried to recover. It exits with no troublesome message, but verifying the database gives issues in ACIS/files and ACIS/records. I tried fixing them from dump, but dumping crashes. Backups have even more errors when verifying them.
I suggest you make sure you use recent versions of mariadb berkeleydb.
Instructions specifically say not to do that.
At this point, I think I am left with having to rebuild the database. But I find no indication on how to do that.
I think you need to empty the database of records, then move the Berkley files out of the way and then start updareq. I would take RAS offline while this is done.
I will research how to do that.
--
Cheers,
Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
Christian Zimmermann writes
I suggest you make sure you use recent versions of mariadb berkeleydb.
Instructions specifically say not to do that.
I'm not aware seeing such instructions. I frequently updated both when I ran authorclaim. -- Cheers, Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
The ACIS databases have been completely refreshed, the files db now passes the tests, the records db now has a large number of "overflow item incomplete" errors and fails. RAS is still functional, but the records that were invisible to users are still so, so nothing has been resolved. Christian Zimmermann FIGUGEGL! Economic Research Federal Reserve Bank of St. Louis P.O. Box 442 St. Louis MO 63166-0442 USA https://ideas.repec.org/zimm/ @CZimm_economist On Thu, 13 Sep 2018, Thomas Krichel wrote:
Christian Zimmermann writes
RAS has a corrupted database. RAS still runs, but some series have become invisible to it and authors complain their profiles got emptied from those items. Trying to push them back (updareq) gets a response that they are already there, so nothing is done about it.
I tried to recover. It exits with no troublesome message, but verifying the database gives issues in ACIS/files and ACIS/records. I tried fixing them from dump, but dumping crashes. Backups have even more errors when verifying them.
I suggest you make sure you use recent versions of mariadb berkeleydb.
At this point, I think I am left with having to rebuild the database. But I find no indication on how to do that.
I think you need to empty the database of records, then move the Berkley files out of the way and then start updareq. I would take RAS offline while this is done.
--
Cheers,
Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
Christian Zimmermann writes
The ACIS databases have been completely refreshed, the files db now passes the tests, the records db now has a large number of "overflow item incomplete" errors and fails.
you mean there is an error in the the mysql table, not bdb? I would update the software for both databases on a different server. -- Cheers, Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
bdb has the errors. Again, local instructions specify not to upgrade bdb. I doubt a software upgrade would solve the issue. Christian Zimmermann FIGUGEGL! Economic Research Federal Reserve Bank of St. Louis P.O. Box 442 St. Louis MO 63166-0442 USA https://ideas.repec.org/zimm/ @CZimm_economist On Wed, 19 Sep 2018, Thomas Krichel wrote:
Christian Zimmermann writes
The ACIS databases have been completely refreshed, the files db now passes the tests, the records db now has a large number of "overflow item incomplete" errors and fails.
you mean there is an error in the the mysql table, not bdb? I would update the software for both databases on a different server.
--
Cheers,
Thomas Krichel http://openlib.org/home/krichel skype:thomaskrichel
participants (2)
-
Christian Zimmermann -
Thomas Krichel