tag:blogger.com,1999:blog-3935073175121071865.post1419173693950182437..comments2022-03-25T12:12:43.846-07:00Comments on NMMM Pictures: Bug in TokuDBNMMM.NUhttp://www.blogger.com/profile/03498174084265748638noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3935073175121071865.post-28322401665576604492011-01-12T05:45:23.993-08:002011-01-12T05:45:23.993-08:00Bug was fixed in TokuDB 4.1.3, here you are the &q...Bug was fixed in TokuDB 4.1.3, here you are the "dump" of the test.<br /><br />=====================<br /><br />insert into video_toku select * from video;<br /><br />Query OK, 10875440 rows affected (1 min 43.00 sec)<br /><br />=====================<br /><br />Size on disk<br />558M<br /><br />Size on show table status<br />846M<br /><br />=====================<br /><br />update video_toku set artist=concat(artist,' ok');<br /><br />Query OK, 10873941 rows affected, 1635 warnings (8 min 30.91 sec)<br />Rows matched: 10875440 Changed: 10873941 Warnings: 1635<br /><br />=====================<br /><br />delete from video_toku where artist like 'ni%';<br /><br />Query OK, 68155 rows affected (18.89 sec)<br /><br />=====================<br /><br />insert into video_bh select * from video_toku where date = '2010-11-11' ;<br /><br />Query OK, 10853 rows affected (0.23 sec)<br />Records: 10853 Duplicates: 0 Warnings: 0<br /><br />=====================<br /><br />insert into video_bh select * from video_toku where artist like 'a%' ;<br /><br />Query OK, 790356 rows affected (9.37 sec)<br />Records: 790356 Duplicates: 0 Warnings: 0<br /><br />=====================<br /><br />select count(*) from video_toku where date = '2010-11-11' ;<br /><br />1 row in set (0.11 sec)<br /><br />=====================<br /><br />select count(*) from video_toku where artist like 'a%' ;<br /><br />1 row in set (0.46 sec)<br /><br />=====================<br /><br />select count(*) from video_toku;<br /><br />1 row in set (6.61 sec)<br /><br />=====================<br /><br />select min(date), max(date) from video_toku;<br /><br />1 row in set (0.01 sec)<br /><br />=====================<br /><br />Concurrent operation returned lock timoutNMMM.NUhttps://www.blogger.com/profile/03498174084265748638noreply@blogger.comtag:blogger.com,1999:blog-3935073175121071865.post-21191503325594537542011-01-07T18:12:14.509-08:002011-01-07T18:12:14.509-08:00Nikolay, thanks for finding this bug. We reproduce...Nikolay, thanks for finding this bug. We reproduced it and we found that it is an error in our Fast Loader, a feature we introduced in v4.0 for accelerating loading into an empty index. We have fixed the bug and are currently testing a new release which we expect to release for General Availability early next week. <br /><br />We have apprised all our customers of the problem and are working with them to determine if their tables or indexes have been corrupted - fortunately it turns out that this bug causes data inconsistencies or data loss rarely and only under very specific circumstances. Details on the bug are available on the Known Issues page on the Support tab of our website.<br /><br />Again, on behalf of ourselves and our customers, please accept our thanks for finding this important bug and reporting it to us.Bradley C. Kuszmaulhttps://www.blogger.com/profile/16428429628432728830noreply@blogger.comtag:blogger.com,1999:blog-3935073175121071865.post-27564727794251037972010-12-23T09:28:07.673-08:002010-12-23T09:28:07.673-08:00Hi, this Bradley Kuszmaul, chief architect at Toku...Hi, this Bradley Kuszmaul, chief architect at Tokutek. We're looking into this.<br /><br />-BradleyBradley C. Kuszmaulhttps://www.blogger.com/profile/16428429628432728830noreply@blogger.com