Sporadic PostgreSQL errors
Bugs » #23
This section on the Community is no longer supported, in favour of Wikidot's Official Feedback Site.
It is retained here for archiving purposes.
Bugs
Tags
attached-files
backlinks
block
bug
button
categories
code
comments
css
custom
deleting
disabled
div
edit-sections
embed
false
file
files
filesize
float
format
formating
forum
frontforum
gallery
hidden
html
iframe
include
listpages
live-template
lock
manager
page-variables
pictures
postgresql
posting
privacy
recognizing
rename
save
security-error
slow
social
tag
template
timeout
upload
url
Posted by pieterh on 21 Aug 2008 11:46, last edited on 04 Mar 2009 14:18
| This bug has been fixed |
Description
This happened on 21 August on a wikidot site. I've seen this now and then, it goes away with a refresh:
"Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: connection limit exceeded for non-superusers in /var/www/www.wikidot.com/ozone/ozone/php/core/database/PgConnection.php on line 87
A nasty error has occurred. If the problem repeats, please fill (if possible) a bug report.
exception 'OzoneDatabaseException' with message 'error: ' in
/var/www/www.wikidot.com/ozone/ozone/php/core/database/PgConnection.php:90 Stack trace: #0
/var/www/www.wikidot.com/ozone/ozone/php/core/database/Database.php(48): PgConnection->connect() #1
/var/www/www.wikidot.com/ozone/ozone/php/core/database/Database.php(61): Database::init() #2
/var/www/www.wikidot.com/ozone/ozone/php/core/database/BaseDBPeer.php(67): Database::connection() #3
/var/www/www.wikidot.com/ozone/ozone/php/core/database/BaseDBPeer.php(117): BaseDBPeer->selectByCriteria(Object(Criteria)) #4
/var/www/www.wikidot.com/wikidot/php/screens/wiki/WikiScreen.php(345): BaseDBPeer->select(Object(Criteria)) #5
/var/www/www.wikidot.com/wikidot/php/screens/wiki/WikiScreen.php(14): WikiScreen->handleNotifications(Object(RunData)) #6
/var/www/www.wikidot.com/wikidot/php/utils/WikiFlowController.php(198): WikiScreen->render(Object(RunData)) #7
/var/www/www.wikidot.com/wikidot/web/index.php(89): WikiFlowController->process() #8 {main}"
How to Reproduce
Not directly reproducible.
Workarounds
Refresh usually works but obviously this is not something end users want to be confronted by.
Contact
Pieter Hintjens <moc.xitami|hp#moc.xitami|hp>
Rate this Bug
Rate the urgency of this bug. If you think it is more urgent and important than it's current rating suggests, rate it up.
This could be a sign of Wikidot's growth. It sounds like too many users are hitting the database at once. I suspect it is an easy fix, unless the Wikidot servers would be stressed too much if the limit is increased.
-Ed
Community Admin