monitor-table-change-with-sqltabledependency icon indicating copy to clipboard operation
monitor-table-change-with-sqltabledependency copied to clipboard

Published 20 hours ago • verified publisher icon IsNemoEqualTrue

- Fix the trigger "auto-drop" function (the trigger drop needs to be …

Open darkag opened this issue 5 years ago • 5 comments
trafficstars

…the last operation before return)

  • Fix incorrect WaitForNotifications start that prevent stop to termitate if stoped on application closing (wrong task was waited)

darkag avatar Oct 16 '20 13:10 darkag

Before making this change, did you experience orphaned triggers in SQL that were causing problems?

SteffeyDev avatar Oct 30 '20 13:10 SteffeyDev

Yes that's why I started to look in the source code. When the problem occured I was not able to update the watched table since the trigger drop command failed.

I got error messages like the ones described in issue #214 or #188.

darkag avatar Oct 31 '20 10:10 darkag

Have you run your version of the code in production for some time without issues? We are seeing the same issues

SteffeyDev avatar Nov 02 '20 16:11 SteffeyDev

Yes, no problems since the corrections I've made.

darkag avatar Nov 02 '20 17:11 darkag

unfortunately this fix didn't work for me: had issues with stopping listener and also it was not possible to do a restart after an error, something is wrong with changes to WaitForNotifications await

lekrus avatar Dec 16 '20 15:12 lekrus