En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

MySQL time field type conversion issue with AWS DMS

1

I have a source DB MySQL v5.6 community edition as a source DB and AWS RDS MySQL v5.7 as target in AWS DMS and have an issue with time field type. DMS task is full load and replication. During full load all time columns are migrated correctly, but during ongoing replication/CDC all time field values are converted to either 00:00:00 or 23:59:59. Probably the source of the issue is in bin log used for replication, but I need help in solving that.

  • blagi connecto
    il y a 6 mois

    Conversions are like this: 00:52:19 -> 00:00:00 02:39:08 -> 00:00:00 00:25:56 -> 23:59:59 00:33:01 -> 23:59:59 00:22:51 -> 23:59:59 00:30:26 -> 23:59:59 06:00:52 -> 23:59:59

  • mroy
    il y a 3 jours

    We are also having a similar issue with MariaDB 10.1.46 as the source, and Kinesis as the destination.

    Conversions make no sense at all: 13:23:59 --> -911:43:62 13:22:31 --> 112:16:02

Sujets
Migration et modernisationAnalytiqueBase de données
Balises
Service de migration de base de données AWSAmazon Relational Database ServiceMySQL
Langue
English
blagi connecto
demandé il y a 6 mois257 vues
2 réponses
0

Hi,

This post will provide you with full details on how to obtain timestamps on target when migrating from MySQL to MySQL via AWS DMS:

https://medium.com/devops-journal/migrating-mysql-timestamp-from-non-utc-database-to-rds-with-aws-dms-6a5c382c9d5c

Best,

Didier

profile pictureAWS
EXPERT
Didier_Durand
répondu il y a 6 mois
  • blagi connecto
    il y a 6 mois

    It's not timestamp field type, it's time type: hour:min:sec!

0

This is a serious bug which Amazon needs to fix.

I did a full investigation, and posted about it on StackOverflow.

mroy
répondu il y a un jour

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents