pgsync icon indicating copy to clipboard operation
pgsync copied to clipboard

Authorization error on bulk inserts

Open Askaiant opened this issue 4 months ago • 0 comments

I'm currently running pgsync to sync data with postgres and opensearch running on AWS.

The instance is running fine, but after a while (let's say 6 hours), the instance exits with this error: opensearchpy.helpers.errors.BulkIndexError: ('3 document(s) failed to index.', [{'index': {'error': 'AuthorizationException(403, \'{"message":"The security token included in the request is expired"}\')'

Of course, after a minute, new instance replaces the old one and the service resumes as usual.

Not sure why this happens, I'm wondering if anyone encountered similar issue, and if so, how would one avoid it?

pgsync - 4.2.1 opensearch - 2.19 pg - 15.12

This is not really version specific.

Askaiant avatar Sep 26 '25 12:09 Askaiant