More graceful error message when database is unavailable or crashed
- Status
- Closed
- Subject
- More graceful error message when database is unavailable or crashed
- Version
- 1.9.x
- Category
- Usability
- Feature request
- Feature
- Database MySQL (MyISAM)
Administration
Installer (profiles, upgrades and server-related issues)
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Infrastructure - Resolution status
- Out of Date
- Submitted by
- Marc Laporte
- Lastmod by
- Kissaki
- Rating
- Description
I got this on October 25th 2006:
Warning: mysql error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) in query:select count(*) from `tiki_banners` where `wed` = ? and `hourFrom`<=?
and `hourTo`>=? and
( `useDates` = ?) and (`fromDate`<=? and `toDate`>=? or
(`useDates` = ?) ) and
`impressions`<`maxImpressions` and `zone`=?in lib/tikidblib.php on line 134
How could we show a more meaningful error message?
mysql tables sometimes crash.When they do, the error message is cryptic, at best.
An average Tiki admin won't know what the problem is and could think it's Tiki's fault.
A graceful error message would inform the admin that:"There are problems with the following tables: ". Please repair (link to how to repair)
Especially the tiki_sessions, which shuts down the site completely...
Some others are not so bad. Just a path disclosure.
Copy to clipboardWarning: mysql error: Can't open file: 'tiki_images.MYI' (errno: 145) in query: select count(*) from `tiki_images` where `galleryId`=? in lib/tikidblib.php on line 134
Another error to watch for:
Copy to clipboardUnable to connect to the database ! User droit_tiki has already more than 'max_user_connections' active connections
Maybe Tiki admin email should be in db/local.php? So the system could send email alerts when DB can't connect.
- Solution
Please upgrade to a recent version of tiki.
If the problem persists, please add a new tracker item.- Importance
- 5
- Priority
- 25
- 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
- 949
- Created
- Friday 05 January, 2007 06:23:34 UTC
by Unknown - LastModif
- Saturday 08 August, 2009 20:07:55 UTC