[Wikidata-bugs] [Maniphest] [Changed Project Column] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

[Addshore]

Addshore moved this task from Incoming to Wikidata-Campsite-Iteration-∞ on the 
Wikidata-Campsite board.
Addshore edited projects, added Wikidata-Campsite 
(Wikidata-Campsite-Iteration-∞); removed Wikidata-Campsite.

TASK DETAIL
  https://phabricator.wikimedia.org/T151789

WORKBOARD
  https://phabricator.wikimedia.org/project/board/3402/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Addshore
Cc: Ladsgroup, alaa_wmde, Michael, mmodell, Addshore, Krinkle, Aklapper, hoo, 
Iflorez, darthmon_wmde, Dinadineke, DannyS712, Nandana, tabish.shaikh91, Lahi, 
Gq86, GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, 
QZanden, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, 
Wikidata-bugs, aude, Lydia_Pintscher, TheDJ, Jdforrester-WMF, Mbch331, Rxy, 
Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Changed Project Column] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

[Ladsgroup]

Ladsgroup moved this task from Sept 2019 / 1.34.wmf21–25 to Found longer ago on 
the Wikimedia-production-error board.
Ladsgroup added a comment.


  In T151789#5569384 , 
@Krinkle wrote:
  
  > Seems to have come back, now happening a few hundred times a day as of 
1.34.0-wmf.24.
  
  No, this ticket is about the old term store. The errors you have been seeing 
is about the new term store which is tracked in T234948: New Wikibase deadlocks 
on Wikidata wiki since 2019-10-08T00:00:02: 
Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; 
try restarting transaction 

TASK DETAIL
  https://phabricator.wikimedia.org/T151789

WORKBOARD
  https://phabricator.wikimedia.org/project/board/1055/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup
Cc: Ladsgroup, alaa_wmde, Michael, mmodell, Addshore, Krinkle, Aklapper, hoo, 
darthmon_wmde, Dinadineke, DannyS712, Nandana, tabish.shaikh91, Lahi, Gq86, 
Pablo-WMDE, GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, 
QZanden, merbst, LawExplorer, _jensen, rosalieper, Jonas, Wikidata-bugs, aude, 
Lydia_Pintscher, TheDJ, Jdforrester-WMF, Mbch331, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Changed Project Column] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

[Krinkle]

Krinkle moved this task from Found longer ago to Since Oct 2019 / 1.35.wmf1– on 
the Wikimedia-production-error board.
Krinkle added a comment.


  Seems to have come back, now happening a few hundred times a day as of 
1.35.0-wmf.1

TASK DETAIL
  https://phabricator.wikimedia.org/T151789

WORKBOARD
  https://phabricator.wikimedia.org/project/board/1055/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Krinkle
Cc: alaa_wmde, Michael, mmodell, Addshore, Krinkle, Aklapper, hoo, 
darthmon_wmde, Dinadineke, DannyS712, Nandana, tabish.shaikh91, Lahi, Gq86, 
GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, QZanden, 
merbst, LawExplorer, _jensen, rosalieper, Jonas, Wikidata-bugs, aude, 
Lydia_Pintscher, TheDJ, Jdforrester-WMF, Mbch331, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Changed Project Column] T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction

[Krinkle]

Krinkle moved this task from Production Impact to Production 1.32-wmf.20+ on the Wikimedia-production-error board.Krinkle added a comment.
Still seen:

exception.message:
Wikimedia\Rdbms\DBTransactionStateError
Cannot execute query from Wikibase\Repo\Content\DataUpdateAdapter::doUpdate while transaction status is ERROR.

exception.previous.message:
A database query error has occurred. 
Query: DELETE FROM `wb_terms` WHERE term_language = 'ru' AND term_type = 'label' AND term_text = 'Соловецкий (Архангельская область)' AND term_full_entity_id = 'Q3964446'
Function: Wikibase\Lib\Store\Sql\TermSqlIndex::deleteTerms
Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.48.26)

exception.previous.trace:
#0 /srv/mediawiki/php-1.32.0-wmf.20/includes/libs/rdbms/database/Database.php(1192): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.32.0-wmf.20/includes/libs/rdbms/database/Database.php(2907): Wikimedia\Rdbms\Database->query(string, string)
#2 /srv/mediawiki/php-1.32.0-wmf.20/extensions/Wikibase/lib/includes/Store/Sql/TermSqlIndex.php(390): Wikimedia\Rdbms\Database->delete(string, string, string)
#3 /srv/mediawiki/php-1.32.0-wmf.20/extensions/Wikibase/lib/includes/Store/Sql/TermSqlIndex.php(169): Wikibase\Lib\Store\Sql\TermSqlIndex->deleteTerms(Wikibase\DataModel\Entity\ItemId, array, Wikimedia\Rdbms\DatabaseMysqli)
#4 [internal function]: Wikibase\Lib\Store\Sql\TermSqlIndex->saveTermsOfEntity(Wikibase\DataModel\Entity\Item)
#5 /srv/mediawiki/php-1.32.0-wmf.20/extensions/Wikibase/repo/includes/Content/DataUpdateAdapter.php(64): call_user_func_array(array, array)
#6 /srv/mediawiki/php-1.32.0-wmf.20/includes/deferred/DeferredUpdates.php(268): Wikibase\Repo\Content\DataUpdateAdapter->doUpdate()
#7 /srv/mediawiki/php-1.32.0-wmf.20/includes/deferred/DeferredUpdates.php(214): DeferredUpdates::runUpdate(Wikibase\Repo\Content\DataUpdateAdapter, Wikimedia\Rdbms\LBFactoryMulti, string, integer)
#8 /srv/mediawiki/php-1.32.0-wmf.20/includes/deferred/DeferredUpdates.php(134): DeferredUpdates::execute(array, string, integer)
#9 /srv/mediawiki/php-1.32.0-wmf.20/includes/MediaWiki.php(914): DeferredUpdates::doUpdates(string)
#10 /srv/mediawiki/php-1.32.0-wmf.20/includes/MediaWiki.php(734): MediaWiki->restInPeace(string, boolean)
#11 [internal function]: Closure$MediaWiki::doPostOutputShutdown()
#12 {main}

reqId: W5NWcgpAEMQAAD@Ex1wAAABP
wiki: www.wikidata.org
url: /w/api.phpTASK DETAILhttps://phabricator.wikimedia.org/T151789WORKBOARDhttps://phabricator.wikimedia.org/project/board/1055/EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: KrinkleCc: Krinkle, Aklapper, hoo, tabish.shaikh91, Lahi, Gq86, GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, QZanden, merbst, LawExplorer, D3r1ck01, Wikidata-bugs, aude, TheDJ, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs