[MDEV-10359] Unknown locale utf-8 when applying query fomr another galera node Created: 2016-07-11  Updated: 2019-12-12  Resolved: 2019-12-12

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 5.5.49-galera
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Evan Jardine-Skinner Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: galera
Environment:

Ubuntu 14.04 Galera 25.3.16-1trusty


 Description   

Found this odd error message when this node was applying the changeset from antoher node in my 3 node galera cluster. The other nodes looks to have applied the changeset just fine.

Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Unknown character set: 'utf8'' on query. Default database: 'restore_c0fee9153d45'. Query: 'CREATE TABLE `messaging_message` (
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `msid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique message id.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `method` varchar(255) NOT NULL DEFAULT '' COMMENT 'Messaging send method key.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `store` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `mqid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue id if any.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `language` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Message status.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `created` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp when the item was created.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `updated` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp when the item was created.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `sent` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp, when the last message was sent to this address.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `error` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Error code if any.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   PRIMARY KEY (`msid`),
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   KEY `meth
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777381
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822652, g: 2777381, s: 2777380, d: 2777380, ts: 411468875796376)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Table 'restore_c0fee9153d45.messaging_message' doesn't exist' on query. Default database: 'restore_c0fee9153d45'. Query: '/*!40000 ALTER TABLE `messaging_message` DISABLE KEYS */', Error_code: 1146
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777382
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822653, g: 2777382, s: 2777381, d: 2777381, ts: 411468878319100)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Table 'restore_c0fee9153d45.messaging_message' doesn't exist' on query. Default database: 'restore_c0fee9153d45'. Query: '/*!40000 ALTER TABLE `messaging_message` ENABLE KEYS */', Error_code: 1146
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777383
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822654, g: 2777383, s: 2777382, d: 2777382, ts: 411468879340256)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Unknown character set: 'utf8'' on query. Default database: 'restore_c0fee9153d45'. Query: 'CREATE TABLE `metatag` (
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `entity_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The entity id this data is attached to.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `revision_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The revision_id for the entity object this data is attached to.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `language` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `data` longblob NOT NULL,
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`language`),
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   KEY `type_revision` (`entity_type`,`revision_id`)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: ) ENGINE=InnoDB DEFAULT CHARSET=utf8', Error_code: 1115
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777385
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822656, g: 2777385, s: 2777384, d: 2777384, ts: 411468881754828)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Table 'restore_c0fee9153d45.metatag' doesn't exist' on query. Default database: 'restore_c0fee9153d45'. Query: '/*!40000 ALTER TABLE `metatag` DISABLE KEYS */', Error_code: 1146
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777386
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822657, g: 2777386, s: 2777385, d: 2777385, ts: 411468884218798)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Table 'restore_c0fee9153d45.metatag' doesn't exist' on query. Default database: 'restore_c0fee9153d45'. Query: '/*!40000 ALTER TABLE `metatag` ENABLE KEYS */', Error_code: 1146
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777387
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822658, g: 2777387, s: 2777386, d: 2777386, ts: 411468885196454)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Unknown character set: 'utf8'' on query. Default database: 'restore_c0fee9153d45'. Query: 'CREATE TABLE `metatag_config` (
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `cid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The primary identifier for a metatag configuration set.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `instance` varchar(255) NOT NULL DEFAULT '' COMMENT 'The machine-name of the configuration, typically entity-type:bundle.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   `config` longblob NOT NULL COMMENT 'Serialized data containing the meta tag configuration.',
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   PRIMARY KEY (`cid`),
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld:   UNIQUE KEY `instance` (`instance`)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Storage of meta tag configuration and defaults.'', Error_code: 1115
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777389
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822660, g: 2777389, s: 2777388, d: 2777388, ts: 411468887757045)
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [ERROR] Slave SQL: Error 'Table 'restore_c0fee9153d45.metatag_config' doesn't exist' on query. Default database: 'restore_c0fee9153d45'. Query: '/*!40000 ALTER TABLE `metatag_config` DISABLE KEYS */', Error_code: 1146
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2777390
 
Jul 11 10:02:30 advancedportalnode-test2-20160705-10-144-95-218 mysqld: 160711 10:02:30 [Warning] WSREP: Ignoring error for TO isolated action: source: 8f590b48-4398-11e6-9760-7fd3648dc8f7 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 511625 trx_id: -1 seqnos (l: 2822661, g: 2777390, s: 2777389, d: 2777389, ts: 411468890224271)



 Comments   
Comment by Elena Stepanova [ 2016-07-12 ]

nirbhay_c, bar, any ideas about this?

Slave SQL: Error 'Unknown character set: 'utf8'' on query. Default database: 'restore_c0fee9153d45'. 
...

Comment by Jan Lindström (Inactive) [ 2019-12-12 ]

Support for 5.5-galera has ended.

Generated at Thu Feb 08 07:41:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.