question

FedericoArturoRamirezSeidel-6534 avatar image
0 Votes"
FedericoArturoRamirezSeidel-6534 asked ManiRaja-1409 published

Error while trying to copy a MySQL data base to azure synapse analytics

Hello, so I want to copy a MySQL DB to synapse, but I keep getting this error, do you know what it is?

{
"errorCode": "2200",
"message": "ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server ticketYYY.com at port: 3306.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server: TYYYY.YYYl.com at port: 3306.,Source=,'",
"failureType": "UserError",
"target": "copiar_tabla",
"details": []
}

Thanks!

azure-synapse-analyticsazure-database-mysql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm facing same issue, where connection is established and data is showing in the copy data preview, but while debug it is throwing time out error. Please share the resolution if it is solved.
Thanks

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered HimanshuSinha-MSFT commented

Hello @FedericoArturoRamirezSeidel-6534 ,
Thanks for the ask and using Microsoft Q&A platform .
As we understand the ask here is how to connect to the mysqldatabase from Synapse . Please do let me know if that not accurate
Looking at the error it appears that the you are trying to connect to tiXXX.YYYl.com , but when I do a simple ping

174160-image.png

The domain name tiXXX.YYYl.com is refering to XXX.cloudapp.azure.com whcih is not correct , if you are refering to a mysql server whcih is hosted on azure then the name should be
somename.mysql.database.azure.com .

Please do let me if you have any queries .
Thanks
Himanshu


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators



image.png (4.8 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello, I have already connected the linked service of MySQL, I even have the data sets ready, the error occurs when I clic debug in the pipeline, so I think that is not the issue.

0 Votes 0 ·
HimanshuSinha-MSFT avatar image HimanshuSinha-MSFT FedericoArturoRamirezSeidel-6534 ·

Hello @FedericoArturoRamirezSeidel-6534 ,
Are you saying that you are able to preview the dataset ? Can you please check and confirm the same ?
Thanks
Himanshu

0 Votes 0 ·

Yes, exactly. I can, this shows up when I preview.

175118-screenshot.png


0 Votes 0 ·
screenshot.png (11.7 KiB)