今天测试反馈了一个测试环境的错误,错误信息如下:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: no partition of relation "swap_data_info" found for row
详细:Partition key of the failing row contains (create_time) = (2022-11-15 14:44:38.531).
### The error may exist in file [/home/waiqin365_swapsvr/waiqin365-swapsvr-1.3.1/web/WEB-INF/classes/com/zk/api/swap/config/sqlmap/swapMapper.xml]
### The error may involve com.zk.api.swap.vo.SwapVO.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO swap_data_info ( id , tenant_id , app_id , data_id , data_type , data_version , data_format , data_source , data , status , status_time , create_time ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
### Cause: org.postgresql.util.PSQLException: ERROR: no partition of relation "swap_data_info" found for row
详细:Partition key of the failing row contains (create_time) = (2022-11-15 14:44:38.531).
; SQL []; ERROR: no partition of relation "swap_data_info" found for row
看了下这个错误的详情,得出大致原因:
1.新增数据的时候,分区字段是够传值了
2.分区表是否存在
我的是第二个原因,希望能帮助大家!