12.x svn LTS recent regression: mysql table for unified index doesn't exist and page edit displays fatal error (even if edition saved properly)
- Status
- Closed
- Subject
- 12.x svn LTS recent regression: mysql table for unified index doesn't exist and page edit displays fatal error (even if edition saved properly)
- Version
- 12.x Regression
- Category
- Release Blocker
- Regression
- Feature
- Search
Wiki (page view, edit, history, rename, etc) - Resolution status
- Fixed or Solved
- Submitted by
- Xavier de Pedro
- Lastmod by
- Xavier de Pedro
- Rating
- Description
12.x svn LTS recent regression: mysql table for unified index doesn't exist and page edit displays fatal error (even if edition saved properly)
I recently noticed that, in a few tikis that I migrated from a server to a new one. They were working fine for a few days, unified search index being updated on a cron job at night time, page edits fine, etc.
And suddenly, page edits in some tiki sites started to display this fatal error message of missing mysql table for the index (using Mysql Full Text Search engine for the advanced unified search).I also noticed that the index update failed for one site because some tracker field had a perm name too long for Mysql Full Text Search as unified search engine.
Anyway, I'll dop a note here just in case other people start to experience similar issues, so that we can look for common patterns to track the issue down.
In myc ase, workaround was to manually reindex again the site through console. Then no error was shown in further wiki page edits for the same users, etc.
- Solution
No idea what happened, but at some point in May or June 2015, this error might have stopped existing. I've reverted the production sites to default value again (index updated automatically upon site changes, and index refreshed only once per day based on cron job) and site doesn't show that error any more.
- Importance
- 9
- Easy to solve?
- 9
- Priority
- 81
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 5636
- Created
- Sunday 19 April, 2015 10:38:38 UTC
by Xavier de Pedro - LastModif
- Tuesday 15 September, 2015 10:45:25 UTC