Last modified: 2014-08-02 10:01:53 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T70942, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 68942 - Database upgrade MariaDB 10: Engine / Option mismatch on table `user_properties`


Summary:	Database upgrade MariaDB 10: Engine / Option mismatch on table `user_properties`

Status:	ASSIGNED

Product:	Wikimedia Labs
Classification:	Unclassified
Component:	Infrastructure (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal
Target Milestone:	---
Assigned To:	Sean Pringle

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2014-07-31 18:59 UTC by metatron
Modified:	2014-08-02 10:01 UTC (History)
CC List:	6 users (show)

See Also:
Web browser:	---
Mobile Platform:	---
Assignee Huggle Beta Tester:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description metatron 2014-07-31 18:59:11 UTC

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 */;

Comment 1 Sean Pringle 2014-07-31 22:00:23 UTC

The table is intentionally, though hopefully temporarily, InnoDB, due to a TokuDB issue we're still investigating involving the secondary index and a certain form of DELETE used by Mediawiki.

The compression attribute is an artifact. Need to see whether it can be removed with online DDL.

Comment 2 Sean Pringle 2014-08-02 02:58:29 UTC

https://mariadb.atlassian.net/browse/MDEV-5867

Comment 3 Sean Pringle 2014-08-02 03:10:34 UTC

Have applied on labsdb replicas:

SET GLOBAL SQL_MODE=IGNORE_BAD_TABLE_OPTIONS;

This will only help when loading dumps that include the orphan table options.  It will not prevent the options appearing in dumps in the first place, for which we need MariaDB 10.0.13 (release scheduled within the next month).

Comment 4 metatron 2014-08-02 10:01:53 UTC

Thanks. In addition I've set up a regex to filter this mismatch.
This was mainly for https://tools.wmflabs.org/tools-info/optimizer.php , which runs now as v0.5.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links