https://bugzilla.wikimedia.org/show_bug.cgi?id=57049
Web browser: ---
Bug ID: 57049
Summary: Unsafe statements being used when using MySQL
replication
Product: MediaWiki extensions
Version: master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: Unprioritized
Component: Translate
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected]
Classification: Unclassified
Mobile Platform: ---
When using replication on a MediaWiki database, the following warnings show up
in the MySQL log when using the Translate extension:
[Warning] Unsafe statement written to the binary log using statement format
since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a
non-transactional table after accessing a transactional table within the same
transaction. Statement: INSERT /* DatabaseTTMServer::insertSource */ INTO
`translate_tmf` (tmf_sid,tmf_text) VALUES ('421','search data')
This problem is caused by the fact that the translate_tmf is using the MyISAM
storage engine. All MediaWiki tables are using InnoDB except for this
translate_tmf and the searchindex table, as InnoDB lacks the FULLTEXT index
support. See http://www.mediawiki.org/wiki/Manual_talk:Searchindex_table.
Transactions to the translate_tmf table should be separated from other
transactions to the database to prevent unsafe statements from happening when
using replication.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
