Hi all,
Each morning our Odoo synchronizer imports data from a sql server database.
2021-01-14 09:30:22,696 23 INFO xxx.addons.connector_dbsource_counter.unit.import_synchronizer: 38929 updated from dbsource
2021-01-14 09:30:23,901 23 INFO xxx.addons.connector_dbsource_counter.unit.import_synchronizer: 10027 updated from dbsource
2021-01-14 09:30:25,172 23 INFO xxx.addons.connector_dbsource_counter.unit.import_synchronizer: 17654 updated from dbsource
2021-01-14 09:30:26,425 23 INFO xxx.addons.connector_dbsource_counter.unit.import_synchronizer: 10965 updated from dbsource
2021-01-14 09:30:27,784 23 INFO xxx.addons.connector_dbsource_counter.unit.import_synchronizer: 1 updated from dbsource
But the sessions in the SQL instance never close and remain blocked with sql='BEGIN TRAN'.
The next morning when the imports restart, the old sql server sessions seem to disappear but other ones appear. However sometimes, the older sessions remain 2 or 1 day.
Do you have any advice to fix that?
Thanks,
Vince
better to check with the module author as it seems to be custom code. Might be connection are not closed after sync. Can you have a look at the code or get in touch with the author of the module and see