This forum is now out of date, for our new forum Click Here
After reboot, repository DB error
Problem Reported
We intalled YellowFin on Amazon Windows instance for evaluation. The repository is local hsqldb.
We stopped the instance (should be orderly shutdown), then started it.
Since then, the system fails to load the repository db. From yellowfin.log:

YF:2013-08-06 13:23:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2013-08-06 13:23:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2013-08-06 13:28:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException

Looking at the DATA folder, I see there is no .lck file, but there is a .log file of 26MB (the .DATA is 49MB).

What went wrong? How can I ensure nothing like this happens again - use a more solid DB?

Thanks!

guest

Wed Aug 7, 2013 4:40 AM

Comment
Hi,

Sorry to hear you're having issues with Yellowfin.
From the sounds of it, the database may have broken. With HSQL this isn't too hard to do, simply having 2 connections open to the database (e.g. Yellowfin & DB tool) will corrupt the DB.
In your case however, you actually shutdown yellowfin before restarting, so I wouldn't have expected anything to break.

In cases like this, we can get a copy of the DATA folder, we can then try to restore and repair it here. If this doesn't work, you will need to re-install Yellowfin.

The only way to ensure the DB does not break , is to steer away from HSQL.

Had you created many items?
How would you like to proceed with this?

Thanks,
David

David

Wed Aug 7, 2013 8:32 AM

Comment
Thank you for the proposal!
We did lose some work, but it's evaluation and we'll recreate the views in any case, so the loss is not too much.
For the production, we'll use a robust DB.

guest

Wed Aug 7, 2013 2:46 PM

Comment
Np!

Let us know if you run into any other issues

David

Thu Aug 8, 2013 8:36 AM