Database upgrade MariaDB 10: Engine / Option mismatch on table `user_properties`
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• bzimport
	Jul 31 2014, 6:59 PM

Description

Author: metatron

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

Version: unspecified
Severity: normal

Details

Reference: bz68942

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:41 AM

• bzimport added a project: Cloud-VPS.

• bzimport set Reference to bz68942.

• bzimport created this task.Jul 31 2014, 6:59 PM

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.

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

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).

metatron wrote:

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.

Aklapper added a project: Cloud-Services.Apr 29 2015, 12:18 PM

It looks like labsdb100[13] run 10.0.15 and labsdb1002 runs 10.0.16. Is this resolved now?

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 18 2015, 3:29 AM

• Springle set Security to None.Aug 28 2015, 4:23 AM

• Springle added a subscriber: jcrespo.

Krenair added a project: DBA.Aug 28 2015, 5:03 AM

Krinkle moved this task from Triage to Backlog on the DBA board.Sep 23 2015, 4:27 AM

Krinkle moved this task from Backlog to Triage on the DBA board.Sep 23 2015, 7:04 AM

• chasemp triaged this task as Low priority.Nov 30 2015, 4:19 PM

I have, by chance, arrived to this old ticket, which I believe can be closed.
labsdb1001 runs 10.0.15, 1003 runs 10.0.22 we are getting rid of toku and labsdb1001,1003 will also be decommissioned soon anyways.

Database upgrade MariaDB 10: Engine / Option mismatch on table `user_properties`Closed, ResolvedPublicActions

Description

Details

Event Timeline

Database upgrade MariaDB 10: Engine / Option mismatch on table `user_properties`
Closed, ResolvedPublic
Actions