https://bugzilla.wikimedia.org/show_bug.cgi?id=68942
Bug ID: 68942
Summary: Database upgrade MariaDB 10: Engine / Option mismatch
on table `user_properties`
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Infrastructure
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: metat...@online.ms
CC: abog...@wikimedia.org, m...@uberbox.org,
rlan...@gmail.com, t...@tim-landscheidt.de
Web browser: ---
Mobile Platform: ---
My optimizer throws mismatch error on dump/recreation for table
user_properties.
Compression doesn't match with Engine=InnoDB. Maybe forgot to change to TokuDB.
CREATE TABLE `user_properties` (
`up_user` int(11) NOT NULL DEFAULT '0',
`up_property` varbinary(255) DEFAULT NULL,
`up_value` blob,
UNIQUE KEY `user_properties_user_property` (`up_user`,`up_property`),
KEY `user_properties_property` (`up_property`)
) ENGINE=InnoDB DEFAULT CHARSET=binary `compression`='tokudb_zlib';
/*!40101 SET character_set_client = @saved_cs_client */;
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
