What does the error "VALUE_PRINT_NOT_SUPPORTED" mean and how do I fix it?
I'm using DMS to move a MySQL 5.7 database from one AWS account to another. I'm not changing versions or schemas or anything, just migrating it to a new RDS instance. Everything was going pretty well until I ran into the "VALUE_PRINT_NOT_SUPPORTED" error. This error only seems to happen on MySQL "TEXT" fields, and only on some of them.
Looking at my table statistics I can see that there are 10 tables that have a Validation State of "Mismatched records". When I query the "awsdms_validation_failures_v1" table in the TARGET database I can see these errors are listed as "VALUE_PRINT_NOT_SUPPORTED".
{'contact_notes': '<VALUE_PRINT_NOT_SUPPORTED>'}, {'contact_notes': '<VALUE_PRINT_NOT_SUPPORTED>'}
What is this error trying to tell me? Are there characters in those records that can't be migrated? Is the content on the fields too large? Is there some other error?
if we are moving db instance across VPC. i would suggest create a read replica from main instance using a precreated dbsubnet group of the required vpc subnets.
once ready to cutover just promote the read replica.
In case of cross account you can use rds snapshot to restore to that account. lastly if downtime windows is smaller you can setup native mysql replication between them post snapshot restore.
also you can refer to this article to create read replica in another account https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-cross-region-replica/
Hello, Within an AWS Region, we strongly recommend that you create all read replicas in the same virtual private cloud (VPC) based on Amazon VPC as the source DB instance. If you create a read replica in a different VPC from the source DB instance, classless inter-domain routing (CIDR) ranges can overlap between the replica and the RDS system. CIDR overlap makes the replica unstable, which can negatively impact applications connecting to it. If you receive an error when creating the read replica, choose a different destination DB subnet group.
That is correct, you cannot create a RR in a different AWS account from the source DB instance.
I'm also getting this error on a field in one of my tables. I've tried reloading and re-verifying the data but it still doesn't work. I also can't find the row that is having problems because the "key" doesn't seem to match up with any of the indexes on that table.
+--------------------------+----------+--------------------------+--------------+-----------------------------------------------------------------------------------------------------------+
| KEY_TYPE | KEY | FAILURE_TYPE | DETAILS |
+--------------------------+----------+--------------------------+--------------+-----------------------------------------------------------------------------------------------------------+
| Row | {"key": ["11111111"] } | RECORD_DIFF |
[[{'object_changes': '<VALUE_PRINT_NOT_SUPPORTED>'}, {'object_changes': '<VALUE_PRINT_NOT_SUPPORTED>'}],] |
| Row | {"key": ["22222222"] } | RECORD_DIFF |
[[{'object_changes': '<VALUE_PRINT_NOT_SUPPORTED>'}, {'object_changes': '<VALUE_PRINT_NOT_SUPPORTED>'}],] |Relevant questions
Does AWS DMS has any way to touch or modify source tables?
asked 4 days agoHow do I transfer my AWS account to another person or business?
asked 17 days agoHow do i fix the "ERROR: The request is missing a valid API key." from my wordpress installation
asked 2 months agoWhat does the error "VALUE_PRINT_NOT_SUPPORTED" mean and how do I fix it?
asked 2 months agoAWS Lightsail - Accessing a mysql database in a different account?
asked a year agoCan i move Lightsail Instance Snapshot from one account (test) to another account (production)?
Accepted Answerasked 5 months agoIs there a service to move a database from MSSQL to MySQL (both hosted on AWS)
asked 4 months agomoving a SES identity from one account to another account
asked 3 days agoMove AWS Amazon Lightsail Instance From One Account to Another ??
asked 2 years agoHow to connect MySQL database in nodeJS file.
asked 2 years ago
That's a good idea and I didn't realize that RDS supported read replicas for MySQL. Unfortunately, I am moving my DB to a VPN in a different account and according to the docs, read replicas are only supported in the same account.
However, I will probably use MySQL RR for some upcoming data warehousing situations. So, thanx for the tip!