17 January 2019
Sorry for the delayed response.
Please see: https://dba.stackexchange.com/questions/105578/error-this-version-of-mariadb-doesnt-yet-support-multiple-triggers-with-the-s
The error you're getting means that your MySQL server does not allow tables to have several triggers with the same action at a time (i.e. after insert or before insert triggers, etc.).
When performing synchronization repeatedly, Skyvia synchronizes only data that was changed since the previous synchronization. For this, it creates special tracking tables and triggers in relational databases for data modification tracking. The parameter that is responsible for this in Synchronization package is InitTrackingObjects. When it is set to True this means that tracking tables and triggers were created for the tables. It is not recommended to add new tasks to the synchronization package which already performed initial sync. One of the reasons - tracking tables and triggers will not be created for newly added tables until the InitTrackingObjects parameter is reset. The recommended option is to use separate packages for new tasks or re-create the package with several tasks (new tasks and tasks that you have in an existing package).
In order to resolve mentioned error, we recommended you to try these steps:
- check triggers for the tables that are used in synchronization package directly in the database; delete them (Skyvia creates 3 triggers - with the insert, update, delete events, type - after);
- create new synchronization package (or check that InitTrackingObjects and LastSyncTime parameters are reset in existing one);
- run package.
Please notify us about the results.