Issue: Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

Issue Tools
- View Changes

May 16, 2018 4:36 AM

SeToY

Junior Member

Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

Hello,

when editing a wiki page, I get the following error:

Code:

Server Error
Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter.php at line 1654
XenForo_DataWriter->_update() in XenForo/DataWriter.php at line 1623
XenForo_DataWriter->_save() in vw/XenForo/DataWriter.php at line 369
vw_XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
XenForo_DataWriter->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/dm/xf.php at line 436
vw_DM_Controller_XF->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/dm/base/routable/vw.php at line 518
vw_DM_Base_Routable_Controller->save_path() in D:/inetpub/wwwroot/domain.com/vault/core/controller/dm/page/vw.php at line 1508
vw_DM_Page_Controller->post_save_each() in vw/XenForo/DataWriter.php at line 505
vw_XenForo_DataWriter->_postSave() in XenForo/DataWriter.php at line 1423
XenForo_DataWriter->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/dm/xf.php at line 436
vw_DM_Controller_XF->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/ui/edit/vw.php at line 228
vw_UI_Edit_Controller->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/ui/page/vw.php at line 346
vw_UI_Page_Controller->save() in D:/inetpub/wwwroot/domain.com/vault/core/controller/ui/page/vw.php at line 133
vw_UI_Page_Controller->execute() in D:/inetpub/wwwroot/domain.com/vault/core/controller/ui/page/xf.php at line 58
vw_UI_Page_Controller_XF->execute() in D:/inetpub/wwwroot/domain.com/vault/core/controller/ui/stack/vw.php at line 276
vw_UI_Stack_Controller->execute() in vw/XenForo/ControllerPublic/Wiki.php at line 70
vw_XenForo_ControllerPublic_Wiki->actionIndex() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in D:/inetpub/wwwroot/domain.com/index.php at line 13

Issue Details

Issue Number 5406

Issue Type Bug

Project VaultWiki 4.x Series

Category Editing Pages

Status No Response

Priority 2 - Fatal / Database Errors

Affected Version 4.0.22

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

May 16, 2018 1:18 PM

pegasus

VaultWiki Team

So it took nearly a year for this database error to occur again on your site? Are you able to reproduce the issue consistently? Does it occur only on the same page or many pages? Any information about the pages affected would be great, as well as the full error text which includes the query-body that triggered the error. Again I would ask that you open a support ticket for this, as you are the only user who has encountered the issue in the past year, and I don't see a reason for it. Even with the information above, I may not be able to reproduce it without a ticket, if it relates to orphan data or other situations which might be unique to your database.

Reply
August 12, 2018 9:00 PM

pegasus

VaultWiki Team

For this to occur, it requires that the page DM is started up using a pageID or a routeID that is from a different page than the one starting up the DM. At the end, this would result in changes being saved to a different page than the one you edited. So this error message protects you.

I don't see any way for this to occur naturally. If you have a data set that generates this error, you need to supply it, or this error will not be fixed. You have not replied to the reports you created about this spanning over 12 months.

Reply
August 13, 2018 5:57 AM

SeToY

Junior Member

I've not yet come across this error anymore. I will get back to you and supply sample data as soon as I can get this to reproduce.

Reply
August 20, 2018 11:41 AM

pegasus

VaultWiki Team

If the MySQL server is load-balanced, it might be an issue with restarting a master without shutting down its slaves first: https://dba.stackexchange.com/questi...r-is-restarted

If using a MySQL cluster, it might be due to abnormal lag between masters: https://www.clustrix.com/bettersql/m...ate-key-error/

Reply
December 21, 2018 2:45 PM

pegasus

VaultWiki Team

After researching this more, I have determined that this is a bug in the InnoDB engine, which is part of MySQL. They have been studying it for some time and have not yet found a fix that works: https://jira.mariadb.org/browse/MDEV-15237
The bug is related to FULLTEXT indexes on InnoDB tables (which applies to vw_route).

Reply

+ Reply

All times are GMT -4. The time now is 2:39 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

Issue Tools