I have resolved this problem by appending the timeout in connection string. But still I want to know that why this is working in other environment without timeout.
ADF Pipeline copy acitivity is failing
In the ADF Copy activity suddenly started giving the below error but the same copy activity is working fine in other environment
Failure happened on 'Sink' side. 'Type=Npgsql.NpgsqlException,Message=Exception while reading from stream,Source=Npgsql,''Type=System.IO.IOException,Message=Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond,Source=System,'
3 answers
Sort by: Most helpful
-
-
AnnuKumari-MSFT 34,011 Reputation points Microsoft Employee
2022-04-15T07:32:41.633+00:00 Hi @Omprakash Lodhi ,
Welcome to Microsoft Q&A platform and thankyou for posting your question here.From the error it looks like failure happened while trying to connect with the source or sink data stores like Azure Postgre SQL , Oracle DB etc. Kindly let us know which dataset you are using as source and sink.
Most often , such kind of errors are transient errors which gets resolved by itself using retry logic. The cause behind such issues might be planned server maintenance.
During the maintenance schedule, the patch is applied, and server may need to be restarted as part of the patching process to complete the update
For more details, please check this article: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview#automated-patching-with-managed-maintenance-window
You can set up activity log alerts for receiving service health notifications by using the Azure portal.
For detailed steps on how to create service health alerts, refer to Create activity log alerts on service notifications.Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on
or upvote
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
- Please don't forget to click on
-
AnnuKumari-MSFT 34,011 Reputation points Microsoft Employee
2022-04-19T06:24:37.46+00:00 Hi @Omprakash Lodhi ,
Thankyou for sharing the source and sink dataset details and making it clear that the datastore you are using as Sink where failure has happened is PostGre SQL. Below is the information I gathered regarding this issue:The planned maintenance event runs for 15 hours, the individual server impact generally lasts 60 seconds depending on the transactional activity on the server. A notification is sent 72 calendar hours before planned maintenance starts and another one while maintenance is in progress for a given region. For detailed steps on how to create service health alerts, refer to Create activity log alerts on service notifications. The planned maintenance event cannot be canceled or postponed. Once the notification is sent to a given Azure region, the patching schedule changes cannot be made for any individual server in that region. The patch is rolled out for entire region at once. The deployment wise window generally stretches from 5 PM - 8 AM local time next day, in a given Azure region.
Azure Database for PostgreSQL - Single server service is designed for cloud native application that doesn't require granular control or customization of the service. If you are looking to have ability to schedule maintenance for your servers, we recommend you consider Flexible servers.Please be informed that Geo-paired Azure regions are patched on different days.
For high availability and business continuity of database servers, leveraging cross region read replicas is recommended.
You can refer below mentioned documents for more information regarding the same -
Business continuity - Azure Database for PostgreSQL
High availability - Azure Database for PostgreSQLIf this answers your query, do click
Accept Answer
andUp-Vote
for the same as accepted answers help community as well. If you want to investigate even further, I would recommend you to raise a support ticket with Microsoft . Here is how you can do that: Create an Azure Support request