Infrastructure/fedora-infrastructure
1
0
Fork 0
Code Issues 70 Pull requests Projects Releases Packages Wiki Activity Actions

Wiki can’t connect to database #12188

New issue
Closed
opened 2024-09-19 08:00:59 +00:00 by nphilipp · 6 comments
nphilipp commented 2024-09-19 08:00:59 +00:00
Copy link

Accessing https://fedoraproject.org/wiki/Architectures, I often get this error (but not always):

MediaWiki internal error.

Original exception: [ZuvbCSer93RCVHVMl8GfVgAAAZY] /wiki/Architectures Wikimedia\Rdbms\DBConnectionError: Cannot access the database: Too many connections (db03)
Backtrace:
from /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1149)
#0 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(805): Wikimedia\Rdbms\LoadBalancer->reportConnectionError()
#1 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(793): Wikimedia\Rdbms\LoadBalancer->getServerConnection()
#2 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(99): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal()
#3 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#4 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(369): Wikimedia\Rdbms\DBConnRef->__call()
#5 /usr/share/mediawiki/includes/page/WikiPage.php(358): Wikimedia\Rdbms\DBConnRef->selectRow()
#6 /usr/share/mediawiki/includes/page/WikiPage.php(386): WikiPage->pageData()
#7 /usr/share/mediawiki/includes/page/WikiPage.php(426): WikiPage->pageDataFromTitle()
#8 /usr/share/mediawiki/includes/page/WikiPage.php(542): WikiPage->loadPageData()
#9 /usr/share/mediawiki/includes/page/WikiPage.php(614): WikiPage->exists()
#10 /usr/share/mediawiki/includes/page/WikiPage.php(251): WikiPage->getContentModel()
#11 /usr/share/mediawiki/includes/MediaWiki.php(480): WikiPage->getContentHandler()
#12 /usr/share/mediawiki/includes/MediaWiki.php(361): MediaWiki->initializeArticle()
#13 /usr/share/mediawiki/includes/MediaWiki.php(960): MediaWiki->performRequest()
#14 /usr/share/mediawiki/includes/MediaWiki.php(613): MediaWiki->main()
#15 /usr/share/mediawiki/index.php(50): MediaWiki->run()
#16 /usr/share/mediawiki/index.php(46): wfIndexMain()
#17 {main}

Exception caught inside exception handler: [ZuvbCSer93RCVHVMl8GfVgAAAZY] /wiki/Architectures Wikimedia\Rdbms\DBConnectionError: Cannot access the database: Too many connections (db03)
Backtrace:
from /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1149)
#0 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(805): Wikimedia\Rdbms\LoadBalancer->reportConnectionError()
#1 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(793): Wikimedia\Rdbms\LoadBalancer->getServerConnection()
#2 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(99): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal()
#3 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#4 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(338): Wikimedia\Rdbms\DBConnRef->__call()
#5 /usr/share/mediawiki/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(725): Wikimedia\Rdbms\DBConnRef->selectField()
#6 /usr/share/mediawiki/includes/language/LCStoreDB.php(65): Wikimedia\Rdbms\SelectQueryBuilder->fetchField()
#7 /usr/share/mediawiki/includes/language/LocalisationCache.php(559): LCStoreDB->get()
#8 /usr/share/mediawiki/includes/language/LocalisationCache.php(606): LocalisationCache->isExpired()
#9 /usr/share/mediawiki/includes/language/LocalisationCache.php(516): LocalisationCache->initLanguage()
#10 /usr/share/mediawiki/includes/language/LocalisationCache.php(396): LocalisationCache->loadSubitem()
#11 /usr/share/mediawiki/includes/language/MessageCache.php(745): LocalisationCache->getSubitem()
#12 /usr/share/mediawiki/includes/language/MessageCache.php(1323): MessageCache->isMainCacheable()
#13 /usr/share/mediawiki/includes/language/MessageCache.php(1205): MessageCache->getMsgFromNamespace()
#14 /usr/share/mediawiki/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang()
#15 /usr/share/mediawiki/includes/language/MessageCache.php(1072): MessageCache->getMessageFromFallbackChain()
#16 /usr/share/mediawiki/includes/language/Message.php(1485): MessageCache->get()
#17 /usr/share/mediawiki/includes/language/Message.php(972): Message->fetchMessage()
#18 /usr/share/mediawiki/includes/language/Message.php(1059): Message->format()
#19 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(254): Message->text()
#20 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(398): MWExceptionRenderer::msg()
#21 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(103): MWExceptionRenderer::reportOutageHTML()
#22 /usr/share/mediawiki/includes/exception/MWExceptionHandler.php(134): MWExceptionRenderer::output()
#23 /usr/share/mediawiki/includes/exception/MWExceptionHandler.php(251): MWExceptionHandler::report()
#24 /usr/share/mediawiki/includes/MediaWiki.php(632): MWExceptionHandler::handleException()
#25 /usr/share/mediawiki/index.php(50): MediaWiki->run()
#26 /usr/share/mediawiki/index.php(46): wfIndexMain()
#27 {main}

When I reload the page, it’s about a coin toss (50%/50%) if the page loads successfully or runs into the error. I get either via the same proxies.

This should display the page instead.

When do you need this to be done by? (YYYY/MM/DD)

Soon

Accessing https://fedoraproject.org/wiki/Architectures, I often get this error (but not always): ``` MediaWiki internal error. Original exception: [ZuvbCSer93RCVHVMl8GfVgAAAZY] /wiki/Architectures Wikimedia\Rdbms\DBConnectionError: Cannot access the database: Too many connections (db03) Backtrace: from /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1149) #0 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(805): Wikimedia\Rdbms\LoadBalancer->reportConnectionError() #1 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(793): Wikimedia\Rdbms\LoadBalancer->getServerConnection() #2 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(99): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal() #3 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection() #4 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(369): Wikimedia\Rdbms\DBConnRef->__call() #5 /usr/share/mediawiki/includes/page/WikiPage.php(358): Wikimedia\Rdbms\DBConnRef->selectRow() #6 /usr/share/mediawiki/includes/page/WikiPage.php(386): WikiPage->pageData() #7 /usr/share/mediawiki/includes/page/WikiPage.php(426): WikiPage->pageDataFromTitle() #8 /usr/share/mediawiki/includes/page/WikiPage.php(542): WikiPage->loadPageData() #9 /usr/share/mediawiki/includes/page/WikiPage.php(614): WikiPage->exists() #10 /usr/share/mediawiki/includes/page/WikiPage.php(251): WikiPage->getContentModel() #11 /usr/share/mediawiki/includes/MediaWiki.php(480): WikiPage->getContentHandler() #12 /usr/share/mediawiki/includes/MediaWiki.php(361): MediaWiki->initializeArticle() #13 /usr/share/mediawiki/includes/MediaWiki.php(960): MediaWiki->performRequest() #14 /usr/share/mediawiki/includes/MediaWiki.php(613): MediaWiki->main() #15 /usr/share/mediawiki/index.php(50): MediaWiki->run() #16 /usr/share/mediawiki/index.php(46): wfIndexMain() #17 {main} Exception caught inside exception handler: [ZuvbCSer93RCVHVMl8GfVgAAAZY] /wiki/Architectures Wikimedia\Rdbms\DBConnectionError: Cannot access the database: Too many connections (db03) Backtrace: from /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1149) #0 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(805): Wikimedia\Rdbms\LoadBalancer->reportConnectionError() #1 /usr/share/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php(793): Wikimedia\Rdbms\LoadBalancer->getServerConnection() #2 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(99): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal() #3 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection() #4 /usr/share/mediawiki/includes/libs/rdbms/database/DBConnRef.php(338): Wikimedia\Rdbms\DBConnRef->__call() #5 /usr/share/mediawiki/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(725): Wikimedia\Rdbms\DBConnRef->selectField() #6 /usr/share/mediawiki/includes/language/LCStoreDB.php(65): Wikimedia\Rdbms\SelectQueryBuilder->fetchField() #7 /usr/share/mediawiki/includes/language/LocalisationCache.php(559): LCStoreDB->get() #8 /usr/share/mediawiki/includes/language/LocalisationCache.php(606): LocalisationCache->isExpired() #9 /usr/share/mediawiki/includes/language/LocalisationCache.php(516): LocalisationCache->initLanguage() #10 /usr/share/mediawiki/includes/language/LocalisationCache.php(396): LocalisationCache->loadSubitem() #11 /usr/share/mediawiki/includes/language/MessageCache.php(745): LocalisationCache->getSubitem() #12 /usr/share/mediawiki/includes/language/MessageCache.php(1323): MessageCache->isMainCacheable() #13 /usr/share/mediawiki/includes/language/MessageCache.php(1205): MessageCache->getMsgFromNamespace() #14 /usr/share/mediawiki/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang() #15 /usr/share/mediawiki/includes/language/MessageCache.php(1072): MessageCache->getMessageFromFallbackChain() #16 /usr/share/mediawiki/includes/language/Message.php(1485): MessageCache->get() #17 /usr/share/mediawiki/includes/language/Message.php(972): Message->fetchMessage() #18 /usr/share/mediawiki/includes/language/Message.php(1059): Message->format() #19 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(254): Message->text() #20 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(398): MWExceptionRenderer::msg() #21 /usr/share/mediawiki/includes/exception/MWExceptionRenderer.php(103): MWExceptionRenderer::reportOutageHTML() #22 /usr/share/mediawiki/includes/exception/MWExceptionHandler.php(134): MWExceptionRenderer::output() #23 /usr/share/mediawiki/includes/exception/MWExceptionHandler.php(251): MWExceptionHandler::report() #24 /usr/share/mediawiki/includes/MediaWiki.php(632): MWExceptionHandler::handleException() #25 /usr/share/mediawiki/index.php(50): MediaWiki->run() #26 /usr/share/mediawiki/index.php(46): wfIndexMain() #27 {main} ``` When I reload the page, it’s about a coin toss (50%/50%) if the page loads successfully or runs into the error. I get either via the same proxies. This should display the page instead. # When do you need this to be done by? (YYYY/MM/DD) Soon
zlopez commented 2024-09-19 08:07:39 +00:00
Contributor
Copy link

Metadata Update from @zlopez:

  • Issue priority set to: Waiting on Assignee (was: Needs Review)
  • Issue tagged with: Needs investigation
**Metadata Update from @zlopez**: - Issue priority set to: Waiting on Assignee (was: Needs Review) - Issue tagged with: Needs investigation
zlopez commented 2024-09-19 08:08:42 +00:00
Contributor
Copy link

This is happening only for some proxies, if you hit the working ones it will redirect you without issue.

This is happening only for some proxies, if you hit the working ones it will redirect you without issue.
zlopez commented 2024-09-19 10:31:40 +00:00
Contributor
Copy link

It seems that this was resolved by itself. I don't see any more alerts in nagios. Could you confirm that it's working for you?

It seems that this was resolved by itself. I don't see any more alerts in nagios. Could you confirm that it's working for you?
kevin commented 2024-09-19 17:12:29 +00:00
Copy link

So, in the past this has been when database backups are running, the wiki is slow/unresponsive. ;(

It may be that there's some kind of leak in mariadb and restarting it will help... I did so, so I guess we can see if it happens the next database backup window.

So, in the past this has been when database backups are running, the wiki is slow/unresponsive. ;( It may be that there's some kind of leak in mariadb and restarting it will help... I did so, so I guess we can see if it happens the next database backup window.
nphilipp commented 2024-09-20 10:13:43 +00:00
Author
Copy link

I don’t get these errors anymore.

I don’t get these errors anymore.
nphilipp commented 2024-09-20 10:13:46 +00:00
Author
Copy link

Metadata Update from @nphilipp:

  • Issue close_status updated to: Fixed
  • Issue status updated to: Closed (was: Open)
**Metadata Update from @nphilipp**: - Issue close_status updated to: Fixed - Issue status updated to: Closed (was: Open)
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
announcement

   
authentication

Authentication related issues

  
automate

   
aws

Issues related to Amazon Web Services

  
backlog

Tasks that will take longer then ~4 hours to do

  
blocked

Issue is blocked

  
bodhi

Issues with Bodhi

  
ci

Continuous Integration

  
Closed As
Duplicate
Closed with the reason of Duplicate

  
Closed As
Fixed
Closed with the reason of Fixed

  
Closed As
Fixed with Explanation
Closed with the reason of Fixed with Explanation

  
Closed As
Initiative Worthy
Closed with the reason of Initiative Worthy

  
Closed As
Insufficient data
Closed with the reason of Insufficient data

  
Closed As
Invalid
Closed with the reason of Invalid

  
Closed As
Spam
Closed with the reason of Spam

  
Closed As
Upstream
Closed with the reason of Upstream

  
Closed As/Will Not
Can Not fix
Closed with the reason of Will Not/Can Not fix

  
cloud

Items in FedoraInfraCloud or COmmunishift

  
communishift

issues/questions about os.edorainfracloud.org ( Community OpenShift)

  
copr

COPR system (run by other team)

  
database

Issues related to databases

  
deprecated

Tools which Infrastructure may not be able to fix

  
dev

Tasks requiring some dev work

  
discourse

outsourced tool

  
dns

Changes or problems with DNS

  
downloads

rsync,dl.fp.o,AWS,torrents

  
easyfix

   
epel

Issues relating to epel

  
factory2

Generic issues for the factory2 team

  
firmitas

   
gitlab

   
greenwave

Issues with greenwave

  
hardware

Problem is with Fedora Infrastructure Owned/Leased Hardware

  
help wanted

   
high-gain

task that gets us a lot / is important / makes many people happy

  
high-trouble

task that is complex/long/difficult

  
iad2

Something to do with the iad2 datacenter

  
koji

Issues with the build system

  
koschei

Items needing Koschei team

  
lists

issues with lists

  
low-gain

tasks that gets us little / isn't very important / makes only 1 person or few happy

  
low-trouble

task that is easy/short

  
mbs

Issues with mbs.fedoraproject.org

  
medium-gain

task that gets us some / is somewhat important / makes some people happy

  
medium-trouble

task that is medium complex / difficult

  
mini-initiative

Something that is bigger than one person but not a full initiative

  
mirrorlists

Way to tell systems where downloads are

  
monitoring

   
Needs investigation

   
notifier

   
odcs

On Demand Compose Service issues

  
OpenShift

Issues with OpenShift

  
ops

ops problem now...

  
OSBS

OpenShift Build System issues in Fedora

  
outage

   
packager_workflow_blocker

Blocks the packager workflow

  
pagure

Issues with pagure.io

  
permissions

Items which need permissions set in outside tools

  
Priority
Needs Review
Priority of Needs Review

  
Priority
Next Meeting
Priority of Next Meeting

  
Priority
🔥 URGENT 🔥
Priority of 🔥 URGENT 🔥

  
Priority
Waiting on Assignee
Priority of Waiting on Assignee

  
Priority
Waiting on External
Priority of Waiting on External

  
Priority
Waiting on Reporter
Priority of Waiting on Reporter

  
rabbitmq

issues with the message broker

  
rdu-cc

Items doing with RDU Community Cage

  
release-monitoring

release-monitoring.org (Anitya)

  
releng

For problems which should be in the releng ticket system

  
repoSpanner

Issues with repoSpanner

  
request-for-resources

   
s390x

The secondary architecture hardware and problems related with it

  
security

   
SMTP

Email issues outside of lists (DMARC, SPF, aliases)

  
src.fp.o

Issues related to src.fedoraproject.org

  
staging

Issues in staging

  
taiga

outsourced tool

  
unfreeze

Patches to be applied after freeze is lifted

  
waiverdb

Issues with waiverdb

  
websites-general

General items with a website focus

  
wiki

Issues with the Wiki

No labels
announcement
authentication
automate
aws
backlog
blocked
bodhi
ci
Closed As
Duplicate
Closed As
Fixed
Closed As
Fixed with Explanation
Closed As
Initiative Worthy
Closed As
Insufficient data
Closed As
Invalid
Closed As
Spam
Closed As
Upstream
Closed As/Will Not
Can Not fix
cloud
communishift
copr
database
deprecated
dev
discourse
dns
downloads
easyfix
epel
factory2
firmitas
gitlab
greenwave
hardware
help wanted
high-gain
high-trouble
iad2
koji
koschei
lists
low-gain
low-trouble
mbs
medium-gain
medium-trouble
mini-initiative
mirrorlists
monitoring
Needs investigation
notifier
odcs
OpenShift
ops
OSBS
outage
packager_workflow_blocker
pagure
permissions
Priority
Needs Review
Priority
Next Meeting
Priority
🔥 URGENT 🔥
Priority
Waiting on Assignee
Priority
Waiting on External
Priority
Waiting on Reporter
rabbitmq
rdu-cc
release-monitoring
releng
repoSpanner
request-for-resources
s390x
security
SMTP
src.fp.o
staging
taiga
unfreeze
waiverdb
websites-general
wiki
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
3 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: Infrastructure/fedora-infrastructure#12188
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?