Poll transactions (Source) are not committed #56
Comments
ivanyu
added a commit
that referenced
this issue
Oct 5, 2020
#56 To prevent long-running read-only transactions, this makes commit when an iteration of `JdbcSourceTask.poll()` finishes.
ivanyu
added a commit
that referenced
this issue
Oct 5, 2020
#56 To prevent long-running read-only transactions, this makes commit when an iteration of `JdbcSourceTask.poll()` finishes.
ivanyu
added a commit
that referenced
this issue
Oct 5, 2020
To prevent long-running read-only transactions, this makes commit when an iteration of `JdbcSourceTask.poll()` finishes. See #56 for details.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In 29581b3, we disabled autocommit for DB connections.
In Sink transactions are explicitly committed and it causes any trouble.
However, in Source, where transactions are read-only, it effectively creates very long running transactions, which is generally a bad idea. Also it causes different problems like #54.
Committing periodically (e.g. in
poll()) is a good idea.The text was updated successfully, but these errors were encountered: