Hi John, It is generic, but each database has its own dialect implementation because they all have their differences unfortunately :)
I wish I knew how I could help you out here. Perhaps some of the JDBC maintainers could chip in. Best regards, Martijn On Sun, 1 May 2022 at 04:06, John Smith <java.dev....@gmail.com> wrote: > Plus in a way isn't the flink-jdbc connector kinda generic? At least the > older one didn't seem to be server specific. > > On Sat, Apr 30, 2022 at 10:04 PM John Smith <java.dev....@gmail.com> > wrote: > >> Hi Martin, is there anything I need to check for? >> >> On Tue, Apr 26, 2022 at 9:50 PM John Smith <java.dev....@gmail.com> >> wrote: >> >>> Yeah based off the flink JDBC output format... >>> >>> >>> On Tue, Apr 26, 2022 at 10:05 AM Martijn Visser < >>> martijnvis...@apache.org> wrote: >>> >>>> Hi John, >>>> >>>> Have you built your own JDBC MSSQL source or sink or perhaps a CDC >>>> driver? Because I'm not aware of a Flink Microsoft SQL Server JDBC driver. >>>> >>>> Best regards, >>>> >>>> Martijn Visser >>>> https://twitter.com/MartijnVisser82 >>>> https://github.com/MartijnVisser >>>> >>>> >>>> On Tue, 26 Apr 2022 at 16:01, John Smith <java.dev....@gmail.com> >>>> wrote: >>>> >>>>> Hi running 1.14.4 >>>>> >>>>> Logs included: >>>>> https://www.dropbox.com/s/8zjndt5rzd9o80f/flink-flink-taskexecutor-138-task-0002.log?dl=0 >>>>> >>>>> 1- My task managers shut down with: Terminating TaskManagerRunner with >>>>> exit code 1. >>>>> 2- It seems to happen at the same time every day. Which leads me to >>>>> believe it's our database indexing (See below for reasoning of this). >>>>> 3- Most of our jobs are ETL from Kafka to SQL Server. >>>>> 4- We see the following exceptions in the logs: >>>>> - Task 'Sink: jdbc (1/1)#10' did not react to cancelling signal >>>>> - interrupting; it is stuck for 30 seconds in method: >>>>> ... com.microsoft.sqlserver.jdbc.TDSChannel ... >>>>> - Sink: jdbc (1/1)#9 (3aaf6d8a45df6c43198bc8297b42354c) switched >>>>> from RUNNING to FAILED with failure cause: >>>>> org.apache.flink.util.FlinkException: Disconnect from JobManager >>>>> responsible for ... >>>>> 5- Also seeing this: Failed to close consumer network client with type >>>>> org.apache.kafka.clients.consumer.internals.ConsumerNetworkClient >>>>> java.lang.NoClassDefFoundError: >>>>> org/apache/kafka/common/network/Selector$CloseMode >>>>> >>>>> So what I'm guessing is happening is the indexing is blocking the job >>>>> and the task manager cannot cleanly remove the job and finally after a >>>>> while it decides to shut down completely? >>>>> >>>>> Is there a way to pause the stream and restart at a later time knowing >>>>> that this happens always at the same wall clock time? Or maybe allow the >>>>> JDBC to cleanly shutdown with a timeout? >>>>> >>>>> >>>>>
