pathman creates the same partition
LJXLJX1 opened this issue · 3 comments
Problem description
pathman creates the same partition
Environment
pg_pathman 1.5
db_zenap_pm_db_zenap=# select * from pathman_partition_list where parent = 532635;
cnngcxgwe05124 | cnngcxgwe05124_166 | 2 | begintime | 2020-06-24 00:00:00 | 2020-06-25 00:00:00
cnngcxgwe05124 | cnngcxgwe05124_167 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00
cnngcxgwe05124 | cnngcxgwe05124_168 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00
cnngcxgwe05124 | cnngcxgwe05124_169 | 2 | begintime | 2020-06-26 00:00:00 | 2020-06-27 00:00:00
cnngcxgwe05124 | cnngcxgwe05124_167 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00
cnngcxgwe05124 | cnngcxgwe05124_168 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00
The same problem i encountered
| parent | partition | parttype | expr | range_min | range_max |
|---|---|---|---|---|---|
| d_face_recognition | d_face_recognition_1066 | 2 | countdate | 2020-09-24 | 2020-09-25 |
| d_face_recognition | d_face_recognition_1067 | 2 | countdate | 2020-09-24 | 2020-09-25 |
| d_face_recognition | d_face_recognition_1058 | 2 | countdate | 2020-09-17 | 2020-09-18 |
| d_face_recognition | d_face_recognition_1059 | 2 | countdate | 2020-09-17 | 2020-09-18 |
This resulted in the data being stored in two tables separately,and small amount of data in 1067 and 1059,large amounts of data in 1066 and 1058
The database uses Alibaba Cloud's RDS database,datebase's version is PostgreSQL 10.10