Flink SQL1.11.0提交到集群测试遇到的问题，记录

忘是亡心i 2023-02-28 12:43 63阅读 0赞

Flink开发中社区也有人提问：

[http://apache-flink.147419.n8.nabble.com/flink-sql-Could-not-find-any-factory-for-identifier-kafka-td4751.html\#a4778][http_apache-flink.147419.n8.nabble.com_flink-sql-Could-not-find-any-factory-for-identifier-kafka-td4751.html_a4778]

开始遇到这个问题，Flink lib下的包：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70][]

> java.lang.NoClassDefFoundError: org/apache/flink/streaming/connectors/kafka/KafkaTableSourceSinkFactoryBase  
>     at java.lang.ClassLoader.defineClass1(Native Method)  
>     at java.lang.ClassLoader.defineClass(ClassLoader.java:763)  
>     at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)  
>     at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)  
>     at java.net.URLClassLoader.access$100(URLClassLoader.java:74)  
>     at java.net.URLClassLoader$1.run(URLClassLoader.java:369)  
>     at java.net.URLClassLoader$1.run(URLClassLoader.java:363)  
>     at java.security.AccessController.doPrivileged(Native Method)  
>     at java.net.URLClassLoader.findClass(URLClassLoader.java:362)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:424)  
>     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:411)  
>     at org.apache.flink.util.FlinkUserCodeClassLoader.loadClassWithoutExceptionHandling(FlinkUserCodeClassLoader.java:61)  
>     at org.apache.flink.util.FlinkUserCodeClassLoader.loadClass(FlinkUserCodeClassLoader.java:48)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:357)  
>     at java.lang.Class.forName0(Native Method)  
>     at java.lang.Class.forName(Class.java:348)  
>     at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:370)  
>     at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404)  
>     at java.util.ServiceLoader$1.next(ServiceLoader.java:480)  
>     at java.util.Iterator.forEachRemaining(Iterator.java:116)  
>     at org.apache.flink.table.factories.TableFactoryService.discoverFactories(TableFactoryService.java:214)  
>     at org.apache.flink.table.factories.TableFactoryService.findAllInternal(TableFactoryService.java:170)  
>     at org.apache.flink.table.factories.TableFactoryService.findAll(TableFactoryService.java:125)  
>     at org.apache.flink.table.factories.ComponentFactoryService.find(ComponentFactoryService.java:48)  
>     at org.apache.flink.table.api.bridge.java.internal.StreamTableEnvironmentImpl.lookupExecutor(StreamTableEnvironmentImpl.java:148)  
>     at org.apache.flink.table.api.bridge.java.internal.StreamTableEnvironmentImpl.create(StreamTableEnvironmentImpl.java:126)  
>     at org.apache.flink.table.api.bridge.java.StreamTableEnvironment.create(StreamTableEnvironment.java:111)  
>     at flink\_sql.ReadCsv2kafka.main(ReadCsv2kafka.java:50)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
>     at java.lang.reflect.Method.invoke(Method.java:498)  
>     at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:288)  
>     at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198)  
>     at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:149)  
>     at org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:699)  
>     at org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:232)  
>     at org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:916)  
>     at org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:992)  
>     at java.security.AccessController.doPrivileged(Native Method)  
>     at javax.security.auth.Subject.doAs(Subject.java:422)  
>     at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1924)  
>     at org.apache.flink.runtime.security.contexts.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41)  
>     at org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:992)  
> Caused by: java.lang.ClassNotFoundException: org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactoryBase  
>     at java.net.URLClassLoader.findClass(URLClassLoader.java:382)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:424)  
>     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:357)  
>     ... 45 more

代码加入依赖包：

![20200721141918687.png][]

>  java.lang.NoClassDefFoundError: org/apache/kafka/common/errors/InvalidTxnStateException  
>     at org.apache.flink.streaming.connectors.kafka.table.KafkaDynamicSink.createKafkaProducer(KafkaDynamicSink.java:59)  
>     at org.apache.flink.streaming.connectors.kafka.table.KafkaDynamicSinkBase.getSinkRuntimeProvider(KafkaDynamicSinkBase.java:84)  
>     at org.apache.flink.table.planner.plan.nodes.common.CommonPhysicalSink.createSinkTransformation(CommonPhysicalSink.scala:68)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlanInternal(StreamExecSink.scala:103)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlanInternal(StreamExecSink.scala:43)  
>     at org.apache.flink.table.planner.plan.nodes.exec.ExecNode$class.translateToPlan(ExecNode.scala:58)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlan(StreamExecSink.scala:43)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner$$anonfun$translateToPlan$1.apply(StreamPlanner.scala:67)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner$$anonfun$translateToPlan$1.apply(StreamPlanner.scala:66)  
>     at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)  
>     at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)  
>     at scala.collection.Iterator$class.foreach(Iterator.scala:891)  
>     at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)  
>     at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)  
>     at scala.collection.AbstractIterable.foreach(Iterable.scala:54)  
>     at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)  
>     at scala.collection.AbstractTraversable.map(Traversable.scala:104)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner.translateToPlan(StreamPlanner.scala:66)  
>     at org.apache.flink.table.planner.delegation.PlannerBase.translate(PlannerBase.scala:166)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.translate(TableEnvironmentImpl.java:1248)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:694)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeOperation(TableEnvironmentImpl.java:781)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:684)  
>     at flink\_sql.ReadCsv2kafka.main(ReadCsv2kafka.java:58)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
>     at java.lang.reflect.Method.invoke(Method.java:498)  
>     at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:288)  
>     at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198)  
>     at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:149)  
>     at org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:699)  
>     at org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:232)  
>     at org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:916)  
>     at org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:992)  
>     at java.security.AccessController.doPrivileged(Native Method)  
>     at javax.security.auth.Subject.doAs(Subject.java:422)  
>     at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1924)  
>     at org.apache.flink.runtime.security.contexts.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41)  
>     at org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:992)  
> Caused by: java.lang.ClassNotFoundException: org.apache.kafka.common.errors.InvalidTxnStateException  
>     at java.net.URLClassLoader.findClass(URLClassLoader.java:382)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:424)  
>     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:357)  
>     ... 40 more

现在报这个包不存在，我觉得是方向出现错误了，及时加了这个下面的包也不行 ：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 1][]

>  java.lang.NoClassDefFoundError: org/apache/kafka/clients/producer/Producer  
>     at org.apache.flink.streaming.connectors.kafka.table.KafkaDynamicSink.createKafkaProducer(KafkaDynamicSink.java:59)  
>     at org.apache.flink.streaming.connectors.kafka.table.KafkaDynamicSinkBase.getSinkRuntimeProvider(KafkaDynamicSinkBase.java:84)  
>     at org.apache.flink.table.planner.plan.nodes.common.CommonPhysicalSink.createSinkTransformation(CommonPhysicalSink.scala:68)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlanInternal(StreamExecSink.scala:103)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlanInternal(StreamExecSink.scala:43)  
>     at org.apache.flink.table.planner.plan.nodes.exec.ExecNode$class.translateToPlan(ExecNode.scala:58)  
>     at org.apache.flink.table.planner.plan.nodes.physical.stream.StreamExecSink.translateToPlan(StreamExecSink.scala:43)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner$$anonfun$translateToPlan$1.apply(StreamPlanner.scala:67)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner$$anonfun$translateToPlan$1.apply(StreamPlanner.scala:66)  
>     at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)  
>     at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)  
>     at scala.collection.Iterator$class.foreach(Iterator.scala:891)  
>     at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)  
>     at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)  
>     at scala.collection.AbstractIterable.foreach(Iterable.scala:54)  
>     at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)  
>     at scala.collection.AbstractTraversable.map(Traversable.scala:104)  
>     at org.apache.flink.table.planner.delegation.StreamPlanner.translateToPlan(StreamPlanner.scala:66)  
>     at org.apache.flink.table.planner.delegation.PlannerBase.translate(PlannerBase.scala:166)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.translate(TableEnvironmentImpl.java:1248)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:694)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeOperation(TableEnvironmentImpl.java:781)  
>     at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:684)  
>     at flink\_sql.ReadCsv2kafka.main(ReadCsv2kafka.java:59)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
>     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
>     at java.lang.reflect.Method.invoke(Method.java:498)  
>     at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:288)  
>     at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198)  
>     at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:149)  
>     at org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:699)  
>     at org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:232)  
>     at org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:916)  
>     at org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:992)  
>     at java.security.AccessController.doPrivileged(Native Method)  
>     at javax.security.auth.Subject.doAs(Subject.java:422)  
>     at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1924)  
>     at org.apache.flink.runtime.security.contexts.HadoopSecurityContext.runSecured(HadoopSecurityContext.java:41)  
>     at org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:992)  
> Caused by: java.lang.ClassNotFoundException: org.apache.kafka.clients.producer.Producer  
>     at java.net.URLClassLoader.findClass(URLClassLoader.java:382)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:424)  
>     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)  
>     at java.lang.ClassLoader.loadClass(ClassLoader.java:357)  
>     ... 40 more

最后饶了一圈看官网，解决方案：

[https://ci.apache.org/projects/flink/flink-docs-release-1.11/dev/table/connectors/kafka.html][https_ci.apache.org_projects_flink_flink-docs-release-1.11_dev_table_connectors_kafka.html]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 2][]

只导入下面一个kafka相关性的包，pom里面 集群都不要跟kafka相关系的包就可以了。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 3][]

[http_apache-flink.147419.n8.nabble.com_flink-sql-Could-not-find-any-factory-for-identifier-kafka-td4751.html_a4778]: http://apache-flink.147419.n8.nabble.com/flink-sql-Could-not-find-any-factory-for-identifier-kafka-td4751.html#a4778
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70]: /images/20230209/418e20264a624e4b84cf4f4611056004.png
[20200721141918687.png]: /images/20230209/ef3f92391c174eb2a99b8b19ee81167a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 1]: /images/20230209/9a7b2c31c7414b99818aaf263c1596e7.png
[https_ci.apache.org_projects_flink_flink-docs-release-1.11_dev_table_connectors_kafka.html]: https://ci.apache.org/projects/flink/flink-docs-release-1.11/dev/table/connectors/kafka.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 2]: /images/20230209/c3884213a50141869be026fe4fd11f7d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxODY2Nzkz_size_16_color_FFFFFF_t_70 3]: /images/20230209/b5a9d67dc4544cc1a4f56d73088d043f.png