K8S安装,创建表偶发性失败,是不是集群性能太差导致的?

Viewed 26
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [CREATE TABLE IF NOT EXISTS c_6ed2b542c95c4d8fbfcf17526e12a62b ( `@_row_identifier` BIGINT NOT NULL AUTO_INCREMENT,  `time_field` datetime(3) COMMENT '', `value_field` double COMMENT '') DISTRIBUTED BY HASH(`time_field`) BUCKETS 8 PROPERTIES ("replication_num" = 2,"enable_duplicate_without_keys_by_default" = "true")]; SQL state [HY000]; error code [1105]; errCode = 2, detailMessage = Syntax error in line 1:
...TIES ("replication_num" = 2,"enable_duplicate_without_...
                             ^
Encountered: INTEGER LITERAL
Expected
; nested exception is java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 1:
...TIES ("replication_num" = 2,"enable_duplicate_without_...
                             ^
Encountered: INTEGER LITERAL
Expected

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:418)
        at com.DorisDataService.createTable(DorisDataService.java:800)
        at com.DorisDataService.createTable(DorisDataService.java:985)
        at org.writers.doris.DorisWriter.prepare(DorisWriter.java:102)
        at org.service.DataSourceService.run(DataSourceService.java:189)
        at org.service.PluginService.doOnce(PluginService.java:295)
        at org..service.PluginService.runSchedule(PluginService.java:259)
        at org.StartJobEventProcessor.execute(StartJobEventProcessor.java:44)
        at org.JobChangedListener.lambda$run$0(JobChangedListener.java:87)
        at org.listener.RedisMessageListenerContainer.executeListener(RedisMessageListenerContainer.java:250)
        at org.springframework.data.redis.listener.RedisMessageListenerContainer.processMessage(RedisMessageListenerContainer.java:240)
        at org.springframework.data.redis.listener.RedisMessageListenerContainer.lambda$dispatchMessage$0(RedisMessageListenerContainer.java:986)
        at java.base/java.lang.Thread.run(Thread.java:832)
Caused by: java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 1:
...TIES ("replication_num" = 2,"enable_duplicate_without_...
                             ^
Encountered: INTEGER LITERAL
Expected

        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
        at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
        at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:632)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:409)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
        ... 13 common frames omitted

里面的语句单独拷贝出来,是可以执行成功的,程序偶尔也是可以执行成功的。
是不是因为集群性能导致的问题?

1 Answers

这个报错和集群性能关系不大,看着是语法问题。

"replication_num" = 2,副本数也需要加引号:"replication_num" = "2"