set tidb_snapshot error

[Still4]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   mysql> set @@tidb_snapshot="2019-05-28 20:00:00";

2. What did you expect to see?

3. What did you see instead?
   ERROR 1105 (HY000): parsing time "20190508-13:00:31 +0000" as "20060102-15:04:05 -0700 MST": cannot parse "" as "MST"

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
   Release Version: v2.1.9
   Git Commit Hash: 7eaea30
   Git Branch: HEAD
   UTC Build Time: 2019-05-06 11:34:16
   GoVersion: go version go1.12 linux/amd64
   Race Enabled: false
   TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
   Check Table Before Drop: false

[XuHuaiyu]

Hi, @Still4 what's the timezone of your tidb-server?

[Still4]

@XuHuaiyu
mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| UTC | UTC |
+--------------------+---------------------+

[XuHuaiyu]

Can you provide us the tidb log related to this problem?

[Still4]

[2019/05/29 06:36:05.852 +00:00] [WARN] [session.go:816] ["run statement error"] [conn=68700211] [schemaVersion=13250] [error="parsing time "20190508-13:00:31 +0000" as "20060102-15:04:05 -0700 MST": cannot parse "" as "MST""] [errorVerbose="parsing time "20190508-13:00:31 +0000" as "20060102-15:04:05 -0700 MST": cannot parse "" as "MST"\ngit.luolix.top/pingcap/errors.AddStack\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ngit.luolix.top/pingcap/errors.Trace\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:15\ngit.luolix.top/pingcap/tidb/executor.validateSnapshot\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:212\ngit.luolix.top/pingcap/tidb/executor.(*SetExecutor).setSysVariable\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:173\ngit.luolix.top/pingcap/tidb/executor.(*SetExecutor).Next\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:96\ngit.luolix.top/pingcap/tidb/executor.(*ExecStmt).handleNoDelayExecutor\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:289\ngit.luolix.top/pingcap/tidb/executor.(*ExecStmt).Exec\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:245\ngit.luolix.top/pingcap/tidb/session.runStmt\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/tidb.go:198\ngit.luolix.top/pingcap/tidb/session.(*session).executeStatement\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:813\ngit.luolix.top/pingcap/tidb/session.(*session).execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:883\ngit.luolix.top/pingcap/tidb/session.(*session).Execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:832\ngit.luolix.top/pingcap/tidb/server.(*TiDBContext).Execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:235\ngit.luolix.top/pingcap/tidb/server.(*clientConn).handleQuery\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:912\ngit.luolix.top/pingcap/tidb/server.(*clientConn).dispatch\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:658\ngit.luolix.top/pingcap/tidb/server.(*clientConn).Run\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:506\ngit.luolix.top/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:384\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337"] [session="{\n "currDBName": "bi_system",\n "id": 68700211,\n "status": 2,\n "strictMode": true,\n "user": {\n "Username": "root",\n "Hostname": "10.84.170.133",\n "CurrentUser": false,\n "AuthUsername": "",\n "AuthHostname": ""\n }\n}"]
[2019/05/29 06:36:05.853 +00:00] [WARN] [conn.go:522] ["dispatch error"] [conn=68700211] [connInfo="id:68700211, addr:10.84.170.133:19365 status:2, collation:latin1_swedish_ci, user:root"] [sql="set @@tidb_snapshot="2019-05-28 20:00:00""] [err="parsing time "20190508-13:00:31 +0000" as "20060102-15:04:05 -0700 MST": cannot parse "" as "MST"\ngit.luolix.top/pingcap/errors.AddStack\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ngit.luolix.top/pingcap/errors.Trace\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:15\ngit.luolix.top/pingcap/tidb/executor.validateSnapshot\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:212\ngit.luolix.top/pingcap/tidb/executor.(*SetExecutor).setSysVariable\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:173\ngit.luolix.top/pingcap/tidb/executor.(*SetExecutor).Next\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/set.go:96\ngit.luolix.top/pingcap/tidb/executor.(*ExecStmt).handleNoDelayExecutor\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:289\ngit.luolix.top/pingcap/tidb/executor.(*ExecStmt).Exec\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:245\ngit.luolix.top/pingcap/tidb/session.runStmt\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/tidb.go:198\ngit.luolix.top/pingcap/tidb/session.(*session).executeStatement\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:813\ngit.luolix.top/pingcap/tidb/session.(*session).execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:883\ngit.luolix.top/pingcap/tidb/session.(*session).Execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/session/session.go:832\ngit.luolix.top/pingcap/tidb/server.(*TiDBContext).Execute\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:235\ngit.luolix.top/pingcap/tidb/server.(*clientConn).handleQuery\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:912\ngit.luolix.top/pingcap/tidb/server.(*clientConn).dispatch\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:658\ngit.luolix.top/pingcap/tidb/server.(*clientConn).Run\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:506\ngit.luolix.top/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:384\nruntime.goexitn\t/usr/local/go/src/runtime/asm_amd64.s:1337"]