Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Detect crashed mysql tables & display a message in the UI #2194

Closed
mattab opened this issue Mar 17, 2011 · 2 comments
Closed

Detect crashed mysql tables & display a message in the UI #2194

mattab opened this issue Mar 17, 2011 · 2 comments
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone
1.7

Comments

@mattab
Copy link
Member

mattab commented Mar 17, 2011

When the log tables are crashed, the SQL error /exception is caught upstream, and it is not displayed in the UI. The report shows "No data" but not the error.

However in the API, the error is displayed:


su www-data -c "sh /home/piwik/misc/cron/archive.sh"
Starting Piwik reports archiving...

Archiving period = day for idsite = 1...
<?xml version="1.0" encoding="utf-8" ?>
<result>
        <error message="SQLSTATE[HY000]: General error: 145 Table './piwik_demo/piwik_log_visit' is marked as crashed and should be repaired" /       >
</result>
Archiving period = week for idsite = 1...

We should detect such error in the UI, and display a warning message in red / yellow, telling the user that statistics are not tracked because tables are crashed.
@mattab
Copy link
Member Author

mattab commented Sep 17, 2011

Definitely important to show these errors in the UI at all times.

@mattab
Copy link
Member Author

mattab commented Dec 18, 2011

Actually, current behaviour is fine

  • Archiving script, if a table is crashed, will report the error
  • UI: the Visitors > Overview will show the error

@mattab mattab added this to the 1.7 Piwik 1.7 milestone Jul 8, 2014
@mattab mattab mentioned this issue Jun 1, 2011
Closed
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Milestone
1.7
Development

No branches or pull requests
1 participant
@mattab