Mysql 报Table has no partition for value xxx

最新推荐文章于 2023-10-05 22:46:38 发布

花花世界芸芸众生

最新推荐文章于 2023-10-05 22:46:38 发布

阅读量8.4k

点赞数 3

分类专栏： Mysql 文章标签： Mysql 分区

本文链接：https://blog.csdn.net/qq_36805343/article/details/103580138

版权

Mysql 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

### Error updating database.  Cause: java.sql.SQLException: Table has no partition for value 737759
### The error may involve xxx-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO table 
### Cause: java.sql.SQLException: Table has no partition for value 737759
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1526]; Table has no partition for value 737759; nested exception is java.sql.SQLException: Table has no partition for value 737759
com.xxx.exception.ParamException: 发生异常
        at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy25.devicePlanToHis(Unknown Source)
        at com.dangdang.ddframe.job.executor.type.SimpleJobExecutor.process(SimpleJobExecutor.java:41)
        at com.dangdang.ddframe.job.executor.AbstractElasticJobExecutor.process(AbstractElasticJobExecutor.java:206)
        at com.dangdang.ddframe.job.executor.AbstractElasticJobExecutor.process(AbstractElasticJobExecutor.java:171)
        at com.dangdang.ddframe.job.executor.AbstractElasticJobExecutor.execute(AbstractElasticJobExecutor.java:150)
        at com.dangdang.ddframe.job.executor.AbstractElasticJobExecutor.execute(AbstractElasticJobExecutor.java:122)
        at com.dangdang.ddframe.job.lite.internal.schedule.LiteJob.execute(LiteJob.java:26)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

查看是否缺少分区

添加分区

alter table tableName add partition(partition p202112 VALUES LESS THAN (738521) ENGINE = InnoDB);