按时间分表报错

[xiaocang]

中间件运行多日后，会突然开始报错（如下），开始报错后分表查询功能失效，insert 功能正常。
重启中间件后报错消失，功能恢复正常

报错信息：

2017/10/12 10:17:55 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777262
2017/10/12 10:17:56 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:17:56 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777263
2017/10/12 10:17:57 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:17:57 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777264
2017/10/12 10:17:57 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:17:57 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777265
2017/10/12 10:17:57 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:17:57 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777266
2017/10/12 10:17:59 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:17:59 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777267
2017/10/12 10:18:00 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:18:00 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777268
2017/10/12 10:18:01 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:18:01 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777269
2017/10/12 10:18:02 - ERROR - router.go:[414] - [Route] "BuildUpdatePlan" "plan have no criteria" "" conn_id=0
2017/10/12 10:18:02 - ERROR - conn.go:[280] - [server] "Run" "plan have no criteria" "" conn_id=11777271

配置信息

addr: 127.0.0.1
user: user
password: passwd

log_level : error
log_sql : off
slow_log_time : 100
log_path: /data/log/ks/

nodes:
-
    name: node1
    user: nodeuser
    password: nodepasswd
    master : 127.0.0.1:3306

schema:
    nodes: [node1]
    default: node1
    shard:
    -
        db: db1
        table: p_records
        key: created_at
        nodes: [node1]
        type: date_month
        date_range: [201705-202706]
    -
        db: db1
        table: r_records
        key: created_at
        nodes: [node1]
        type: date_month
        date_range: [201705-202706]

[xiaocang]

go version

go version go1.7.4 linux/amd64

cat /etc/redhat-release

CentOS release 6.8 (Final)

[xiaocang]

kingshard version

Git commit:2017-08-13 11:30:51 +0800 @e35f462
Build time:2017-09-06 11:15:25 +0800 by go version go1.7.4 linux/amd64

[Tom-Kail]

现在还有这种情况吗

[xiaocang]

还有的

[Tom-Kail]

能把log_level 开低点，然后将对应的SQL语句贴出来吗，看看created_at字段对应的值是啥，搞不好是数据问题导致的

[xiaocang]

好的，我这边改一下log_level试试

[Tom-Kail]

有发现什么吗

[flike]

SQL语句是什么？

[flike]

fixed
9ecd66e

[xiaocang]

thx