Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10359

Unknown locale utf-8 when applying query fomr another galera node

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.49-galera
    • N/A
    • Galera
    • 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)

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            Ev Evan Jardine-Skinner
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.