问题： 今天开发同事在执行jenkins自动化构建时，由于执行一个mysql更新的操作导致构建失败，报错如下： [

1](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/1.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/1.jpg) 这个文件主要是开发用于执行构建部署的时候更新数据库的sql文件，里面有大量的插入语句； 登录到测试服务器将jenkins中的语句在命令行执行了一遍还是报同样的错误 [![2](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/2.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/2.jpg) 看到这个报错貌似与存储引擎有关系，于是登录到mysql中执行了以下操作 [![3](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/3.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/3.jpg) **解决思路** 1.看了下具体错误代码 [![4](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/4.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/4.jpg) 在tmp下没有这个文件？但是这个文件时临时生成的，本来就应该没有啊！ 那就是创建的时候出错了?! 2.查看了一下磁盘空间，我滴个乖乖，原来第一块磁盘满了 [![5](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/5.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/5.jpg) 好吧，清理了一些文件 [![6](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/6.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/6.jpg) [![66](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/66.jpg)
1](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/1.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/1.jpg) 这个文件主要是开发用于执行构建部署的时候更新数据库的sql文件，里面有大量的插入语句； 登录到测试服务器将jenkins中的语句在命令行执行了一遍还是报同样的错误 [![2](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/2.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/2.jpg) 看到这个报错貌似与存储引擎有关系，于是登录到mysql中执行了以下操作 [![3](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/3.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/3.jpg) **解决思路** 1.看了下具体错误代码 [![4](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/4.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/4.jpg) 在tmp下没有这个文件？但是这个文件时临时生成的，本来就应该没有啊！ 那就是创建的时候出错了?! 2.查看了一下磁盘空间，我滴个乖乖，原来第一块磁盘满了 [![5](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/5.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/5.jpg) 好吧，清理了一些文件 [![6](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/6.jpg)](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/6.jpg) [![66](https://qcloud.coding.net/u/guomaoqiu/p/guomaoqiu/git/raw/master/uploads/2016/03/66.jpg)
再次执行构建，顺利完成！