mysql+sql线程崩溃,查询时MySQL崩溃

在使用特定条件查询时,MySQL 5.7.17 在作者的笔记本电脑上出现崩溃,而同样的查询在Linux测试服务器上运行正常。尝试了重建表、重新安装相同版本的MySQL,问题仍然存在。错误日志显示可能与配置文件my.cnf有关,或者可能是硬件问题。更新Windows解决了该问题。
摘要由CSDN通过智能技术生成

When I select with 2 conditions, mysql is always crashed.For me the problem is very strange:

It's just for this table

It's only happened on my notebook. We have test server (linux) with the same version mysql and the same sql is ok

It's not happened with either condition only

I tried drop and recreate the table, dump data and problem is still

I tried reinstall the same version mysql and in my notebook it happened again

Someone said mysql 5.6 is Ok, I haven't try

Mysql version is 5.7.17.OS: win7 64. I want to use 5.7. Can anybody give some advice.

PS: Is is possible that the problem is relevant with my.cnf?

Error log:

01:15:19 UTC - mysqld got exception 0xc000001d ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against i

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值