Page MenuHomeMiraheze
Create Task
Maniphest T4709

Bug in the Flow extension
Closed, ResolvedPublic
Actions

Description

Every time I try to post a link on a flow discussion, I get this error.

[65e7c79dfe278b96d761808a] Caught exception of type Wikimedia\Rdbms\DBQueryError

The only way I can bypass this error is by removing the link destination by using <nowiki></nowiki> or removing it. Can you fix it?

Related Objects

Event Timeline

Eijitheawesome created this task.Sep 9 2019, 05:56
Herald added a subscriber: RhinosF1. · View Herald TranscriptSep 9 2019, 05:56
RhinosF1 triaged this task as Normal priority.Sep 9 2019, 06:05
RhinosF1 added a project: Site Reliability Engineering.
RhinosF1 added a subscriber: Reception123.
Herald added a subscriber: CnocBride. · View Herald TranscriptSep 9 2019, 06:05
RhinosF1 removed Void as the assignee of this task.Sep 9 2019, 06:05
RhinosF1 added a subscriber: Void.
RhinosF1 removed a subscriber: Void.
RhinosF1 added a comment.Sep 9 2019, 15:00

T4655?

Paladox subscribed.EditedSep 9 2019, 15:03

exception:

2019-09-09 05:37:45 mw3 atrociousyoutuberswiki: [65e7c79dfe278b96d761808a] /w/api.php   Wikimedia\Rdbms\DBQueryError from line 1587 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: INSERT  INTO `flow_wiki_ref` (ref_id,ref_src_wiki,ref_src_workflow_id,ref_src_namespace,ref_src_title,ref_src_object_type,ref_src_object_id,ref_type,ref_target_namespace,ref_target_title) VALUES ('?R?? ?1?','atrociousyoutuberswiki','?R???1?','2600','V6zd4u5qvo0vu0sy','post','?R???1?','link','2','Eijitheawesome/sandbox/TheQuartering')
Function: Flow\Data\Storage\BasicDbStorage::insert (flow_wiki_ref)
Error: 1406 Data too long for column 'ref_src_wiki' at row 1 (mediawiki-internal-db-master.miraheze.org)

#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2149): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/w/extensions/Flow/includes/Data/Storage/BasicDbStorage.php(66): Wikimedia\Rdbms\Database->insert(string, array, string)
#4 /srv/mediawiki/w/extensions/Flow/includes/Data/ObjectManager.php(248): Flow\Data\Storage\BasicDbStorage->insert(array)
#5 /srv/mediawiki/w/extensions/Flow/includes/Data/ObjectManager.php(173): Flow\Data\ObjectManager->insert(array, array)
#6 /srv/mediawiki/w/extensions/Flow/includes/Data/ManagerGroup.php(98): Flow\Data\ObjectManager->multiPut(array, array)
#7 /srv/mediawiki/w/extensions/Flow/includes/Data/ManagerGroup.php(107): Flow\Data\ManagerGroup->multiMethod(string, array, array)
#8 /srv/mediawiki/w/extensions/Flow/includes/Data/Listener/ReferenceRecorder.php(85): Flow\Data\ManagerGroup->multiPut(array)
#9 /srv/mediawiki/w/extensions/Flow/includes/Data/ObjectManager.php(264): Flow\Data\Listener\ReferenceRecorder->onAfterInsert(Flow\Model\PostRevision, array, array)
#10 /srv/mediawiki/w/extensions/Flow/includes/Data/ObjectManager.php(173): Flow\Data\ObjectManager->insert(array, array)
#11 /srv/mediawiki/w/extensions/Flow/includes/Data/ObjectManager.php(146): Flow\Data\ObjectManager->multiPut(array, array)
#12 /srv/mediawiki/w/extensions/Flow/includes/Data/ManagerGroup.php(81): Flow\Data\ObjectManager->put(Flow\Model\PostRevision, array)
#13 /srv/mediawiki/w/extensions/Flow/includes/Block/TopicListBlock.php(179): Flow\Data\ManagerGroup->put(Flow\Model\PostRevision, array)
#14 /srv/mediawiki/w/extensions/Flow/includes/SubmissionHandler.php(160): Flow\Block\TopicListBlock->commit()
#15 /srv/mediawiki/w/extensions/Flow/includes/WorkflowLoader.php(66): Flow\SubmissionHandler->commit(Flow\Model\Workflow, array)
#16 /srv/mediawiki/w/extensions/Flow/includes/Api/ApiFlowBasePost.php(35): Flow\WorkflowLoader->commit(array)
#17 /srv/mediawiki/w/extensions/Flow/includes/Api/ApiFlow.php(98): Flow\Api\ApiFlowBasePost->execute()
#18 /srv/mediawiki/w/includes/api/ApiMain.php(1593): Flow\Api\ApiFlow->execute()
#19 /srv/mediawiki/w/includes/api/ApiMain.php(531): ApiMain->executeAction()
#20 /srv/mediawiki/w/includes/api/ApiMain.php(502): ApiMain->executeActionWithErrorHandling()
#21 /srv/mediawiki/w/api.php(87): ApiMain->execute()
#22 {main}
RhinosF1 changed the task status from Open to Stalled.Sep 9 2019, 15:10
RhinosF1 claimed this task.
RhinosF1 merged a task: T4655: Flow doesn't work after importing xml dump.
RhinosF1 edited projects, added Extensions, Upstream; removed Site Reliability Engineering.
RhinosF1 added subscribers: Bounce, NDKilla, Void.

https://phabricator.wikimedia.org/T232351

RhinosF1 moved this task from Backlog to Deployed Extension Bugs on the Extensions board.Sep 9 2019, 15:12
Bounce added a comment.Sep 13 2019, 10:04

How is this related to my task?

RhinosF1 added a comment.EditedSep 13 2019, 14:12
In T4709#89863, @Bounce wrote:

How is this related to my task?

Because I believe it could be linked as during testing they both produced DBQuery issues.

Bounce added a comment.Sep 13 2019, 17:40
In T4709#89865, @RhinosF1 wrote:

Because I believe it could be linked as during testing they both produced DBQuery issues.

Should I remove those bugged pages?

Like this: oecumene.miraheze.org/wiki/Ns2600:Tufutiuxxufi40i7

RhinosF1 added a comment.Sep 13 2019, 18:20
In T4709#89866, @Bounce wrote:
In T4709#89865, @RhinosF1 wrote:

Because I believe it could be linked as during testing they both produced DBQuery issues.

Should I remove those bugged pages?

Like this: oecumene.miraheze.org/wiki/Ns2600:Tufutiuxxufi40i7

That's probably the best bet

Bounce added a comment.Sep 14 2019, 15:16

Can I restore them if task will be resolved?

RhinosF1 added a comment.Sep 14 2019, 15:39

You should be able to if it is the same error but I think the page might have to be re-created because it looks like on your wiki those pages have had the content model messed up.

RhinosF1 merged a task: T4748: Can't post links on flow..Nov 9 2019, 22:30
RhinosF1 merged a task: T4881: Bug when posting links.
RhinosF1 added a subscriber: • Examknow.
RhinosF1 added a subscriber: Masson_Thief.
RhinosF1 merged a task: T5010: Flow errors out.Dec 23 2019, 15:12
RhinosF1 added a subscriber: Icanttellyou.
RhinosF1 added a comment.Dec 23 2019, 15:21

Patch has now been created by @Paladox

Paladox closed this task as Resolved.EditedDec 23 2019, 21:48

Fixed with https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Flow/+/560392/

(also rolled the fix out)