Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Schema mismatch (Column DATECREATION precise type mismatch.) during a partial backup import

Description

Issue: 

Same as https://jira.percona.com/browse/PXB-2133, for a column with type datetime. The previously pointed issue is marked as fixed in 8.0.12, but not able import the table even with 8.0.12.

 

Environment:

Red Hat Enterprise Linux Server release 7.6 (Maipo) with MySQL 8.0.19 and xtrabackup 8.0.12.

 

 

Table structure

 

 

 

prtype of the column in DB

 

 

 

Hex value is 

 

 

 

In hexdump of .cfg file I see the different value which may correspond to the wrong ptype.

 

 

 

 

Environment

None

Attachments

2

Activity

Jira Bot 
September 15, 2020 at 3:56 PM

Hello ,
It's been 52 days since this issue went into Incomplete and we haven't heard
from you on this.

At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Jira Bot 
September 7, 2020 at 3:56 PM

Hello ,
It's jira-bot again. Your bug report is important to us, but we haven't heard
from you since the previous notification. If we don't hear from you on
this in 7 days, the issue will be automatically closed.

Jira Bot 
August 23, 2020 at 2:56 PM

Hello ,
I'm jira-bot, Percona's automated helper script. Your bug report is important
to us but we've been unable to reproduce it, and asked you for more
information. If we haven't heard from you on this in 3 more weeks, the issue
will be automatically closed.

Sveta Smirnova 
July 25, 2020 at 2:44 PM

Hi

I am still not able to repeat the failure. Please try with current version 8.0.13 and inform us if it fixes the issue.

Bharathkumar Hegde 
July 23, 2020 at 5:54 PM

Hi @Sveta Smirnova,

Here is the details you asked for

Command used for backup

 

 

Command used to export tables

DISCARD/IMPORT commands

Error Messsage

 

 

Incomplete

Details

Assignee

Reporter

Components

Affects versions

Priority

Created June 12, 2020 at 2:22 PM
Updated March 6, 2024 at 6:57 PM
Resolved September 15, 2020 at 3:56 PM