{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/mysql-5.6/issues/111","labels_url":"https://api.github.com/repos/facebook/mysql-5.6/issues/111/labels{/name}","comments_url":"https://api.github.com/repos/facebook/mysql-5.6/issues/111/comments","events_url":"https://api.github.com/repos/facebook/mysql-5.6/issues/111/events","html_url":"https://github.com/facebook/mysql-5.6/issues/111","id":118896456,"number":111,"title":"mysqld some times crashes at the end of Random Query Generator test","user":{"login":"dleeyh","id":9353914,"avatar_url":"https://avatars.githubusercontent.com/u/9353914?v=3","gravatar_id":"","url":"https://api.github.com/users/dleeyh","html_url":"https://github.com/dleeyh","followers_url":"https://api.github.com/users/dleeyh/followers","following_url":"https://api.github.com/users/dleeyh/following{/other_user}","gists_url":"https://api.github.com/users/dleeyh/gists{/gist_id}","starred_url":"https://api.github.com/users/dleeyh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dleeyh/subscriptions","organizations_url":"https://api.github.com/users/dleeyh/orgs","repos_url":"https://api.github.com/users/dleeyh/repos","events_url":"https://api.github.com/users/dleeyh/events{/privacy}","received_events_url":"https://api.github.com/users/dleeyh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"spetrunia","id":2734550,"avatar_url":"https://avatars.githubusercontent.com/u/2734550?v=3","gravatar_id":"","url":"https://api.github.com/users/spetrunia","html_url":"https://github.com/spetrunia","followers_url":"https://api.github.com/users/spetrunia/followers","following_url":"https://api.github.com/users/spetrunia/following{/other_user}","gists_url":"https://api.github.com/users/spetrunia/gists{/gist_id}","starred_url":"https://api.github.com/users/spetrunia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spetrunia/subscriptions","organizations_url":"https://api.github.com/users/spetrunia/orgs","repos_url":"https://api.github.com/users/spetrunia/repos","events_url":"https://api.github.com/users/spetrunia/events{/privacy}","received_events_url":"https://api.github.com/users/spetrunia/received_events","type":"User","site_admin":false},"milestone":null,"comments":19,"created_at":"2015-11-25T18:28:19Z","updated_at":"2015-12-08T00:09:09Z","closed_at":null,"body":"nodes:  Single server, no replication\r\npartition support: disabled\r\n\r\nI executed the RQG sample test 5 times.  For 2 of them, mysqld crashed at the end of the tests.\r\n\r\nRQG test command:\r\n\r\nperl gentest.pl    --dsn=dbi:mysql:host=localhost:port=3306:user=root:database=test:mysql_socket=/tmp/mysql.sock    --gendata=conf/examples/example.zz    --grammar=conf/examples/example.yy --threads=10 --queries=10000\r\n\r\nTerminal output:\r\n.\r\n.\r\n.\r\n# 2015-11-25T11:28:04 [2538] Killing remaining worker process with pid 2553...\r\n# 2015-11-25T11:28:04 [2555] Mixer: Server crash or critical failure (STATUS_SERVER_CRASHED) reported at dsn dbi:mysql:host=localhost:port=3306:user=root:database=test:mysql_socket=/tmp/mysql.sock\r\n# 2015-11-25T11:28:04 [2538] Killing remaining worker process with pid 2546...\r\n# 2015-11-25T11:28:04 [2538] Killing remaining worker process with pid 2555...\r\n# 2015-11-25T11:28:04 [2538] Killing remaining worker process with pid 2547...\r\n# 2015-11-25T11:28:05 [2538] Killing periodic reporting process with pid 2545...\r\n# 2015-11-25T11:28:05 [2545] GenTest: child is being stopped with status STATUS_OK\r\n# 2015-11-25T11:28:05 [2538] For pid 2545 reporter status STATUS_OK\r\n# 2015-11-25T11:28:05 [2538] Kill GenTest::ErrorFilter(2544)\r\n# 2015-11-25T11:28:05 [2538] Server crash reported, initiating post-crash analysis...\r\n# 2015-11-25T11:28:05 [2538] datadir is /home/myrocks/builds/mytest/install.db/\r\n# 2015-11-25T11:28:05 [2538] binary is \r\n# 2015-11-25T11:28:05 [2538] bindir is \r\n# 2015-11-25T11:28:05 [2538] WARNING: Core file not found!\r\n: No such file or directory.\r\n\"/home/myrocks/mariadb-patches\" is not a core dump: Is a directory\r\nbacktrace.gdb:19: Error in sourced command file:\r\nNo stack.\r\n# 2015-11-25T11:28:05 [2538] \r\n: No such file or directory.\r\n\"/home/myrocks/mariadb-patches\" is not a core dump: Is a directory\r\n# 2015-11-25T11:28:05 [2538] \r\n# 2015-11-25T11:28:05 [2538] Test completed with failure status STATUS_SERVER_CRASHED (101)\r\nmyrocks@rocksdb:~/mariadb-patches$\r\n\r\nmysqld output for failed test #1:\r\n \r\nrocksdb.number.keys.read COUNT : 794851\r\nrocksdb.number.keys.updated COUNT : 0\r\nrocksdb.bytes.written COUNT : 5927602\r\nrocksdb.bytes.read COUNT : 39486267\r\nrocksdb.num\r\nmysqld: /home/myrocks/builds/mytest/mysql-5.6/sql/sql_error.cc:432: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.\r\n\r\nmysqld output for failed test #2:\r\n\r\n2015-11-25 12:00:07 2598 [Note] RocksDB: Begin filtering dropped index (0,651)\r\n2015-11-25 12:00:07 2598 [Note] RocksDB: Begin filtering dropped index (0,652)\r\n2015-11-25 12:00:07 2598 [Note] RocksDB: Begin filtering dropped index (0,653)\r\n2015-11-25 12:00:07 2598 [Note] RocksDB: Begin filtering dropped index (0,654)\r\n2015-11-25 12:00:07 2598 [Note] RocksDB: Begin filtering dropped index (0,655)\r\nmysqld: /home/myrocks/builds/mytest/mysql-5.6/sql/sql_error.cc:432: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/facebook/mysql-5.6/issues/comments/162711175","html_url":"https://github.com/facebook/mysql-5.6/issues/111#issuecomment-162711175","issue_url":"https://api.github.com/repos/facebook/mysql-5.6/issues/111","id":162711175,"user":{"login":"hermanlee","id":6656176,"avatar_url":"https://avatars.githubusercontent.com/u/6656176?v=3","gravatar_id":"","url":"https://api.github.com/users/hermanlee","html_url":"https://github.com/hermanlee","followers_url":"https://api.github.com/users/hermanlee/followers","following_url":"https://api.github.com/users/hermanlee/following{/other_user}","gists_url":"https://api.github.com/users/hermanlee/gists{/gist_id}","starred_url":"https://api.github.com/users/hermanlee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hermanlee/subscriptions","organizations_url":"https://api.github.com/users/hermanlee/orgs","repos_url":"https://api.github.com/users/hermanlee/repos","events_url":"https://api.github.com/users/hermanlee/events{/privacy}","received_events_url":"https://api.github.com/users/hermanlee/received_events","type":"User","site_admin":false},"created_at":"2015-12-08T00:09:09Z","updated_at":"2015-12-08T00:09:09Z","body":"The bug is not setting the errkey in the update path. errkey is set when info is called, but the error is printed out before info is called. It should be easy to fix by setting errkey and dupp_errkey when the problem occurs. dupp_errkey is still needed for info to be more precise about which index caused the duplicate key error. I'll post a fix shortly."}}