MySQL Issue: Repository Server is Crashing – OSKAR

This requires being connected to your database server.

Issue:

The iDashboards repository on a MySQL server is crashing. After crashing the MySQL Server service will not start. The logfile for MySQL shows the following line:

MySQL - InnoDB: Error: log file ./ib_logfile0 is of different size

Resolution:

Delete both ib_logfile0 and ib_logfile1 and restart MySQL Server. At this time the MySQL server will be able to start. These log files can be located in the following location:

{path to program directory}\MySQL\MySQL Server {version number}\data\

For More Information:

iDashboards Admin Manual 10. Managing Data Sources
MySQL Documentation
MySQL Connection Failing

Disclaimer: iDashboards Technical Support Engineers are not Database Administrators who know in depth knowledge of them and their quirks. We often learn these skills on the job and have limited knowledge. We do our best to help you with your software in determining if: you are not leveraging the software in the best way for your data or you found a bug in the software, because we want to assist you in your success.

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.