https://bugzilla.wikimedia.org/show_bug.cgi?id=46134
Web browser: ---
Bug ID: 46134
Summary: filearchive mysql queries are not replication safe
Product: MediaWiki
Version: 1.21-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
130314 18:20:51 [Warning] Unsafe statement written to the binary log using
statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table
with an auto-increment column after selecting from another table are unsafe
because the order in which rows are retrieved determines what (if any) rows
will be written. This order cannot be predicted and may differ on master and
the slave. Statement: INSERT /* LocalFileDeleteBatch::doDBInserts */ INTO
`filearchive`
(fa_storage_group,fa_storage_key,fa_deleted_user,fa_deleted_timestamp,fa_deleted_reason,fa_deleted,fa_name,fa_archive_name,fa_size,fa_width,fa_height,fa_metadata,fa_bits,fa_media_type,fa_major_mime,fa_minor_mime,fa_description,fa_user,fa_user_text,fa_timestamp,fa_sha1)
SELECT 'deleted',CASE WHEN img_sha1='' THEN '' ELSE CONCAT(img_sha1,'.jpg')
END,'6923','20130314180657','([....file
metadata....]',0,img_name,NULL,img_size,img_width,img_height,img_metadata,im...
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
