| Bug #67247 | constraint exception | ||
|---|---|---|---|
| Submitted: | 16 Oct 2012 2:02 | Modified: | 27 May 2013 15:26 |
| Reporter: | xie pizi | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 6.5.4 | OS: | Windows (windows 7 ultimate) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | C# constraint exception | ||
[17 Oct 2012 20:49]
Fernando Gonzalez.Sanchez
Hi, It is very strange if this actually gets "fixed" by restarting service. Can you provide some sample data to test against? Also I have thought that it is related to http://bugs.mysql.com/bug.php?id=65065 Which is in progress, If so, you can check the workarounds available there, until a fix is provided.
[20 Oct 2012 3:34]
xie pizi
only one table 'userinfo',query it with typed dataset
Attachment: bug_test.zip (application/x-zip-compressed, text), 9.97 KiB.
[20 Oct 2012 3:35]
xie pizi
visual studio 2010 sample for repeat bugs
Attachment: ConsoleApplication1.zip (application/x-zip-compressed, text), 118.48 KiB.
[26 Oct 2012 20:55]
Fernando Gonzalez.Sanchez
Hi, Can you provide the sql scripts (ie. you can use workbench, then Server Administration and Data Export). (I tried attaching the files, and after 'repair table' the table is empty).
[29 Oct 2012 6:12]
xie pizi
sql scripts for 'userinfo'
Attachment: bug_test_userinfo.sql (application/octet-stream, text), 17.87 KiB.
[27 May 2013 15:26]
Fernando Gonzalez.Sanchez
Duplicate of #65065.
Description: windows 7 ultimate .net framework 4.0 mysql connector/net 6.5.4 mysql 5.0.45-community-nt-log -----------MyISAM typed dataset occurr a constraint error when i invoke adapter.Fill(). Number of errors caused by uncertainty。 Sometimes have, sometimes don't have. How to repeat: Each time you restart mysql service. Before you execute the query by GUI( mysql workbench,navicat,phpmyadmin) can occurr this error. error example: 1、restart mysql service. 2、adapter.Fill()----------select * from student. 3、throw a constraint exception. no error example: 1、restart mysql service. 2、GUI---------------------select * from student. 3、adapter.Fill()----------select * from student. 4、all is OK Suggested fix: 使用这个数据库有几年时间，期间碰到过的问题很多（ 数据库表损坏(InnoDB,MyISAM都有)， 服务无法启动， 表无法修复， 不同版本的数据库拷贝数据文件后，有的表损坏，有的表正常 mysql conntector执行相同语句有时正常，有时异常）。 这根本就没有达到同类产品应有的质量， 一个数据库品牌对应着好多个存储引擎，却又没有一个使用起来稳定！！！ MySQL就像个山寨厂家的广告词。