日志贴全了的,这是从yarn ui贴的full log,用yarn logs命令也是这些log,太简短,看不出错误在哪。。。


我又提交了另外之前用flink1.10跑过的任务,现在用flink1.11跑,报了异常:


SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in 
[jar:file:/opt/flink-1.11.0/lib/log4j-slf4j-impl-2.12.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in 
[jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]


------------------------------------------------------------
 The program finished with the following exception:


org.apache.flink.client.program.ProgramInvocationException: The main method 
caused an error: findAndCreateTableSource failed.
at 
org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:302)
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:1875)
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: org.apache.flink.table.api.TableException: findAndCreateTableSource 
failed.
at 
org.apache.flink.table.factories.TableFactoryUtil.findAndCreateTableSource(TableFactoryUtil.java:49)
at 
org.apache.flink.table.planner.plan.schema.LegacyCatalogSourceTable.findAndCreateLegacyTableSource(LegacyCatalogSourceTable.scala:190)
at 
org.apache.flink.table.planner.plan.schema.LegacyCatalogSourceTable.toRel(LegacyCatalogSourceTable.scala:89)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.toRel(SqlToRelConverter.java:3492)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:2415)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2102)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2051)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:661)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:642)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3345)
at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:568)
at 
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$rel(FlinkPlannerImpl.scala:164)
at 
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.rel(FlinkPlannerImpl.scala:151)
at 
org.apache.flink.table.planner.operations.SqlToOperationConverter.toQueryOperation(SqlToOperationConverter.java:773)
at 
org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlQuery(SqlToOperationConverter.java:745)
at 
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:238)
at 
org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlInsert(SqlToOperationConverter.java:527)
at 
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:204)
at 
org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:78)
at 
org.apache.flink.table.api.internal.TableEnvironmentImpl.sqlUpdate(TableEnvironmentImpl.java:747)
at 
cn.ibobei.qile.dataflow.sql.FromKafkaSinkJdbcForUserUV$.main(FromKafkaSinkJdbcForUserUV.scala:78)
at 
cn.ibobei.qile.dataflow.sql.FromKafkaSinkJdbcForUserUV.main(FromKafkaSinkJdbcForUserUV.scala)
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)
... 11 more
Caused by: org.apache.flink.table.api.NoMatchingTableFactoryException: Could 
not find a suitable table factory for 
'org.apache.flink.table.factories.TableSourceFactory' in
the classpath.


Reason: Required context properties mismatch.


The following properties are requested:
connector.properties.bootstrap.servers=cdh1:9092,cdh2:9092,cdh3:9092
connector.properties.group.id=user_flink
connector.properties.zookeeper.connect=cdh1:2181,cdh2:2181,cdh3:2181
connector.startup-mode=latest-offset
connector.topic=user
connector.type=kafka
connector.version=universal
format.derive-schema=true
format.type=json
schema.0.data-type=VARCHAR(2147483647)
schema.0.name=uid
schema.1.data-type=VARCHAR(2147483647)
schema.1.name=sex
schema.2.data-type=INT
schema.2.name=age
schema.3.data-type=TIMESTAMP(3)
schema.3.name=created_time
schema.4.data-type=TIMESTAMP(3) NOT NULL
schema.4.expr=PROCTIME()
schema.4.name=proctime
schema.watermark.0.rowtime=created_time
schema.watermark.0.strategy.data-type=TIMESTAMP(3)
schema.watermark.0.strategy.expr=`created_time` - INTERVAL '3' SECOND


The following factories have been considered:
org.apache.flink.table.sources.CsvBatchTableSourceFactory
org.apache.flink.table.sources.CsvAppendTableSourceFactory
org.apache.flink.table.filesystem.FileSystemTableFactory
at 
org.apache.flink.table.factories.TableFactoryService.filterByContext(TableFactoryService.java:322)
at 
org.apache.flink.table.factories.TableFactoryService.filter(TableFactoryService.java:190)
at 
org.apache.flink.table.factories.TableFactoryService.findSingleInternal(TableFactoryService.java:143)
at 
org.apache.flink.table.factories.TableFactoryService.find(TableFactoryService.java:96)
at 
org.apache.flink.table.factories.TableFactoryUtil.findAndCreateTableSource(TableFactoryUtil.java:46)
... 37 more












我把maven依赖的provide范围全部去掉了:
<properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <flink.version>1.11.0</flink.version>
        <hive.version>2.1.1</hive.version>
        <java.version>1.8</java.version>
        <scala.version>2.11.12</scala.version>
        <scala.binary.version>2.11</scala.binary.version>
        <maven.compiler.source>${java.version}</maven.compiler.source>
        <maven.compiler.target>${java.version}</maven.compiler.target>
    </properties>


    <repositories>
        <repository>
            <id>maven-net-cn</id>
            <name>Maven China Mirror</name>
            <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
            <releases>
                <enabled>true</enabled>
            </releases>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </repository>


        <repository>
            <id>apache.snapshots</id>
            <name>Apache Development Snapshot Repository</name>
            
<url>https://repository.apache.org/content/repositories/snapshots/</url>
            <releases>
                <enabled>false</enabled>
            </releases>
            <snapshots>
                <enabled>true</enabled>
            </snapshots>
        </repository>
    </repositories>


    <dependencies>
        <!-- Apache Flink dependencies -->
        <!-- These dependencies are provided, because they should not be 
packaged into the JAR file. -->
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-scala_2.11</artifactId>
            <version>${flink.version}</version>
<!--            <scope>provided</scope>-->
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-streaming-scala_2.11</artifactId>
            <version>${flink.version}</version>
<!--            <scope>provided</scope>-->
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-clients_2.11</artifactId>
            <version>${flink.version}</version>
<!--            <scope>provided</scope>-->
        </dependency>


        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-table-common</artifactId>
            <version>${flink.version}</version>
<!--            <scope>provided</scope>-->
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-table-api-scala-bridge_2.11</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-table-planner-blink_2.11</artifactId>
            <version>${flink.version}</version>
<!--            <scope>provided</scope>-->
        </dependency>




        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-sql-connector-kafka_2.11</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-connector-kafka_2.11</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-avro</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-csv</artifactId>
            <version>${flink.version}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-json</artifactId>
            <version>${flink.version}</version>
            <scope>provided</scope>
        </dependency>




        <dependency>
            <groupId>org.apache.bahir</groupId>
            <artifactId>flink-connector-redis_2.11</artifactId>
            <version>1.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-pool2</artifactId>
            <version>2.8.0</version>
        </dependency>
        <dependency>
            <groupId>redis.clients</groupId>
            <artifactId>jedis</artifactId>
            <version>3.3.0</version>
        </dependency>


        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-connector-hbase_2.11</artifactId>
            <version>1.11-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hbase</groupId>
            <artifactId>hbase-client</artifactId>
            <version>2.1.0</version>
        </dependency>


        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>


        <dependency>
            <groupId>io.lettuce</groupId>
            <artifactId>lettuce-core</artifactId>
            <version>5.3.1.RELEASE</version>
        </dependency>


        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <!--<scope>test</scope>-->
        </dependency>


        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-email</artifactId>
            <version>1.5</version>
        </dependency>


        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-common</artifactId>
            <version>3.0.0-cdh6.3.2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-hdfs</artifactId>
            <version>3.0.0-cdh6.3.2</version>
        </dependency>




        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-connector-hive_2.11</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hive</groupId>
            <artifactId>hive-exec</artifactId>
            <version>${hive.version}</version>
            <scope>provided</scope>
        </dependency>


        <!-- Add logging framework, to produce console output when running in 
the IDE. -->
        <!-- These dependencies are excluded from the application JAR by 
default. -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.7</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
            <scope>runtime</scope>
        </dependency>


        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.68</version>
        </dependency>


        <dependency>
            <groupId>com.jayway.jsonpath</groupId>
            <artifactId>json-path</artifactId>
            <version>2.4.0</version>
        </dependency>


        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-connector-jdbc_2.11</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-core</artifactId>
            <version>3.9.1</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-jdbc-client</artifactId>
            <version>3.9.1</version>
        </dependency>


    </dependencies>






集群节点flink-1.11.0/lib/:
-rw-r--r-- 1 root root    197597 6月  30 10:28 flink-clients_2.11-1.11.0.jar
-rw-r--r-- 1 root root     90782 6月  30 17:46 flink-csv-1.11.0.jar
-rw-r--r-- 1 root root 108349203 6月  30 17:52 flink-dist_2.11-1.11.0.jar
-rw-r--r-- 1 root root     94863 6月  30 17:45 flink-json-1.11.0.jar
-rw-r--r-- 1 root root   7712156 6月  18 10:42 flink-shaded-zookeeper-3.4.14.jar
-rw-r--r-- 1 root root  33325754 6月  30 17:50 flink-table_2.11-1.11.0.jar
-rw-r--r-- 1 root root     47333 6月  30 10:38 
flink-table-api-scala-bridge_2.11-1.11.0.jar
-rw-r--r-- 1 root root  37330521 6月  30 17:50 flink-table-blink_2.11-1.11.0.jar
-rw-r--r-- 1 root root    754983 6月  30 12:29 flink-table-common-1.11.0.jar
-rw-r--r-- 1 root root     67114 4月  20 20:47 log4j-1.2-api-2.12.1.jar
-rw-r--r-- 1 root root    276771 4月  20 20:47 log4j-api-2.12.1.jar
-rw-r--r-- 1 root root   1674433 4月  20 20:47 log4j-core-2.12.1.jar
-rw-r--r-- 1 root root     23518 4月  20 20:47 log4j-slf4j-impl-2.12.1.jar


把table相关的包都下载下来了,还是报同样的错,好奇怪。。。

















在 2020-07-10 10:24:02,"Congxian Qiu" <[email protected]> 写道:
>Hi
>
>这个看上去是提交到 Yarn 了,具体的原因需要看下 JM log 是啥原因。另外是否是日志没有贴全,这里只看到本地 log,其他的就只有小部分
>jobmanager.err 的 log。
>
>Best,
>Congxian
>
>
>Zhou Zach <[email protected]> 于2020年7月9日周四 下午9:23写道:
>
>> hi all,
>> 原来用1.10使用per job模式,可以提交的作业,现在用1.11使用应用模式提交失败,看日志,也不清楚原因,
>> yarn log:
>> Log Type: jobmanager.err
>>
>>
>> Log Upload Time: Thu Jul 09 21:02:48 +0800 2020
>>
>>
>> Log Length: 785
>>
>>
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in
>> [jar:file:/yarn/nm/usercache/hdfs/appcache/application_1594271580406_0010/filecache/11/data-flow-1.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in
>> [jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
>> explanation.
>> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
>> log4j:WARN No appenders could be found for logger
>> (org.apache.flink.runtime.entrypoint.ClusterEntrypoint).
>> log4j:WARN Please initialize the log4j system properly.
>> log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for
>> more info.
>>
>>
>> Log Type: jobmanager.out
>>
>>
>> Log Upload Time: Thu Jul 09 21:02:48 +0800 2020
>>
>>
>> Log Length: 0
>>
>>
>>
>>
>> Log Type: prelaunch.err
>>
>>
>> Log Upload Time: Thu Jul 09 21:02:48 +0800 2020
>>
>>
>> Log Length: 0
>>
>>
>>
>>
>> Log Type: prelaunch.out
>>
>>
>> Log Upload Time: Thu Jul 09 21:02:48 +0800 2020
>>
>>
>> Log Length: 70
>>
>>
>> Setting up env variables
>> Setting up job resources
>> Launching container
>>
>>
>>
>>
>>
>>
>>
>>
>> 本地log:
>> 2020-07-09 21:02:41,015 INFO  org.apache.flink.client.cli.CliFrontend
>>                 [] -
>> --------------------------------------------------------------------------------
>> 2020-07-09 21:02:41,020 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: jobmanager.rpc.address, localhost
>> 2020-07-09 21:02:41,020 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: jobmanager.rpc.port, 6123
>> 2020-07-09 21:02:41,021 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: jobmanager.memory.process.size, 1600m
>> 2020-07-09 21:02:41,021 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: taskmanager.memory.process.size, 1728m
>> 2020-07-09 21:02:41,021 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: taskmanager.numberOfTaskSlots, 1
>> 2020-07-09 21:02:41,021 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: parallelism.default, 1
>> 2020-07-09 21:02:41,021 INFO
>> org.apache.flink.configuration.GlobalConfiguration           [] - Loading
>> configuration property: jobmanager.execution.failover-strategy, region
>> 2020-07-09 21:02:41,164 INFO
>> org.apache.flink.runtime.security.modules.HadoopModule       [] - Hadoop
>> user set to hdfs (auth:SIMPLE)
>> 2020-07-09 21:02:41,172 INFO
>> org.apache.flink.runtime.security.modules.JaasModule         [] - Jaas file
>> will be created as /tmp/jaas-2213111423022415421.conf.
>> 2020-07-09 21:02:41,181 INFO  org.apache.flink.client.cli.CliFrontend
>>                 [] - Running 'run-application' command.
>> 2020-07-09 21:02:41,194 INFO
>> org.apache.flink.client.deployment.application.cli.ApplicationClusterDeployer
>> [] - Submitting application in 'Application Mode'.
>> 2020-07-09 21:02:41,201 WARN
>> org.apache.flink.yarn.configuration.YarnLogConfigUtil        [] - The
>> configuration directory ('/opt/flink-1.11.0/conf') already contains a LOG4J
>> config file.If you want to use logback, then please delete or rename the
>> log configuration file.
>> 2020-07-09 21:02:41,537 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - No path for the flink jar passed. Using the location
>> of class org.apache.flink.yarn.YarnClusterDescriptor to locate the jar
>> 2020-07-09 21:02:41,665 INFO
>> org.apache.hadoop.yarn.client.ConfiguredRMFailoverProxyProvider [] -
>> Failing over to rm220
>> 2020-07-09 21:02:41,717 INFO  org.apache.hadoop.conf.Configuration
>>                  [] - resource-types.xml not found
>> 2020-07-09 21:02:41,718 INFO
>> org.apache.hadoop.yarn.util.resource.ResourceUtils           [] - Unable to
>> find 'resource-types.xml'.
>> 2020-07-09 21:02:41,755 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - Cluster specification:
>> ClusterSpecification{masterMemoryMB=2048, taskManagerMemoryMB=4096,
>> slotsPerTaskManager=1}
>> 2020-07-09 21:02:42,723 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - Submitting application master
>> application_1594271580406_0010
>> 2020-07-09 21:02:42,969 INFO
>> org.apache.hadoop.yarn.client.api.impl.YarnClientImpl        [] - Submitted
>> application application_1594271580406_0010
>> 2020-07-09 21:02:42,969 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - Waiting for the cluster to be allocated
>> 2020-07-09 21:02:42,971 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - Deploying cluster, current state ACCEPTED
>> 2020-07-09 21:02:47,619 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - YARN application has been deployed successfully.
>> 2020-07-09 21:02:47,620 INFO  org.apache.flink.yarn.YarnClusterDescriptor
>>                 [] - Found Web Interface cdh003:38716 of application
>> 'application_1594271580406_0010'

回复