[txn_mode=PESSIMISTIC] [err=“connection was bad\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15\ github.com/pingcap/tidb/server.(*packetIO).writePacket\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/packetio.go:160\ngithub.com/pingcap/tidb/server.(*clientConn).writePacket\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:294\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1433\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1371\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1279\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:899\ngithub.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:713\ngithub.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/server.go:415\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357”]
报错日志已附
什么样的 SQL 以及查询是什么样的？另外麻烦日志信息给多一些方便判断。
[conn.go:728] [“command dispatched failed”] [conn=181640] [connInfo=“id:181640, addr:l”] [command=Query] [status=“inTxn:1, autocommit:0”] [sql=“select \ a.attendance_day_id,\ a.corp_id,\ d.corp_name,\ a.project_id,\ b.project_name,\ a.team_id,\ a.worker_id,\ c.worker_name,\ e.work_type as work_type,\ a.date,\ a.start_time,\ a.end_time,\ round((UNIX_TIMESTAMP(end_time)-UNIX_TIMESTAMP(start_time))/3600,1) as work_hours\ from ods.ods_hzsmz_rn_worker_attend_day_df a\ left join dim.dim_project_info_df b on a.project_id=b.project_id\ left join dim.dim_worker_info_df c on a.worker_id=c.worker_id\ left join dim.dim_corp_basic_info_df d on a.corp_id=d.corp_id\ left join dim.dim_team_worker_df e on a.worker_id=e.worker_id and a.team_id=e.team_id\ where a.start_time is not null \ and a.end_time is not null \ and a.start_time<=a.end_time\ ”] [txn_mode=PESSIMISTIC] [err=“connection was bad\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15\ github.com/pingcap/tidb/server.(*packetIO).writePacket\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/packetio.go:160\ngithub.com/pingcap/tidb/server.(*clientConn).writePacket\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:294\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1433\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1371\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:1279\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:899\ngithub.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/conn.go:713\ngithub.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/server/server.go:415\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357”]
这里有个类似的报错，可以参考看下
老兄解决问题了吗，我们遇到了相同的报错