ashish19977 commented on issue #13023:
URL:
https://github.com/apache/shardingsphere/issues/13023#issuecomment-2513562483
@RaigorJiang, I have applied all the solutions mentioned above, but the
problem still persists in my case. Sometimes it gives an error, and sometimes
it works when I'm storing emojis. The issue gets resolved temporarily when I
restart the proxy; after the restart, the error disappears for a while, but it
reappears after some time. Once the error starts occurring, it continues to
happen until I restart again.
Here is my JDBC URL:
`jdbc:mysql://127.0.0.1:3306/portal-uat-1?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4&connectionCollation=utf8mb4_bin`
`jdbc:mysql://127.0.0.1:3306/portal-uat21?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4&connectionCollation=utf8mb4_bin`
And here is my table schema:
CREATE TABLE `appt_data` (
`id` int NOT NULL AUTO_INCREMENT,
`appointment_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28080676 DEFAULT CHARSET=utf8mb4;
This schema is same across both the datasouces.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
