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

Database migration service error DATA_STRUCTURE:SQLite general error. Code <19>

0

Hello:

We have 18 DMS replicate tasks with origin endpoints from SQL server databases on premises to target ec2 SQL server endpoints. Same database versions. All tasks are replicating with this red status: "Running with errors". we have 2 x r5.2xlarge replication instances. cloudwatch logs are reporting always the same error.

[DATA_STRUCTURE]E:SQLite general error. Code <19>, Message<UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage> What is causing this error? We dont know if the replication is going well

Sujets
Migration et modernisationBase de données
Balises
Migration et modernisationService de migration de base de données AWSMicrosoft SQL Server
Langue
English
AWS-User-2803279
demandé il y a 2 ans809 vues
1 réponse
0

You can ignore the SQLite errors.

If your task(s) are in "Running with errors" flag, it implies that the DMS task is running fine, but some of its table(s) have failed.

To find that out, check the "Table Statistics" on the Task page of the DMS Console and see which table(s) are flagged as failed/error there. Then, go to the DMS task logs and search for the table name and you should see the reason why those table(s) failed.

AWS
D-Rao
répondu il y a 2 ans
  • D-Rao
    il y a 2 ans

    Did this work for you?

  • Dylan_Delport
    il y a 2 ans

    Any idea why these warnings are thrown in the first place? I've got Cloudwatch Alarms monitoring a metric for any errors/warnings so would like to have a better understanding before adjusting my metric to ignore SQLite text

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