SQLAdvisor icon indicating copy to clipboard operation
SQLAdvisor copied to clipboard

Published 20 hours ago • verified publisher icon Meituan-Dianping

docker里安装完后，执行SQL，报错New state of 'nil' is invalid.

Open washi4 opened this issue 7 years ago • 5 comments

[root@044d01672267 sqladvisor]# sqladvisor -h 192.168.13.17 -u root -p root -P 3 306 -d hb -q "SELECT loanterm,ApproveTerm,inputorgid,businesstype FROM business_ apply WHERE serialno='B00501003011610130001';" -v 1 New state of 'nil' is invalid. 有谁知道什么问题？

washi4 avatar Apr 26 '17 13:04 washi4

-p 后面加上单引号试试 -p 'root'

yuqiangit avatar Apr 27 '17 03:04 yuqiangit

试过了，还是同样的问题

washi4 avatar Apr 27 '17 03:04 washi4

我也遇到了同样的问题。在win7下，使用Docker Toolbox，通过命令行进入docker容器。执行sqladvisor 命令后，就会出现New state of 'nil' is invalid 提示，并退出docker。

kangshengsu avatar Apr 28 '17 02:04 kangshengsu

好像是因为输出结果中带有中文的问题

kangshengsu avatar May 04 '17 13:05 kangshengsu

我在docker上安装可以使用 镜像已经上传到阿里云 地址：https://dev.aliyun.com/detail.html?spm=5176.1972343.2.4.599c5715PozbG6&repoId=51517

leiwenjie avatar Jun 18 '17 17:06 leiwenjie