Bug #76221 | Assertion `1 == num_erased' failed in remove_global_thread | sql/mysqld.cc:874 | ||
---|---|---|---|
Submitted: | 9 Mar 2015 9:52 | Modified: | 16 Mar 2015 6:18 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.6.23 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[9 Mar 2015 9:52]
Ramesh Sivaraman
[9 Mar 2015 9:54]
Ramesh Sivaraman
Testcase bundle
Attachment: 1425600530_bug_bundle.tar.gz (application/gzip, text), 144.38 KiB.
[9 Mar 2015 9:54]
Ramesh Sivaraman
added debug tag
[16 Mar 2015 5:53]
MySQL Verification Team
Hello Ramesh, Thank you for the report. I cannot repeat the issue with 5.6.23/5.6.25 opt/debug builds. Moreover, provided reproducible test case *run_pquery Segfaults most of the times. (few samples collected) [umshastr@hod03]/export/umesh/mysql-5.6.25: ./1425600530_run_pquery Fri Mar 13 13:39:05 CET 2015 Executing testcase ./1425600530.sql against mysqld with socket /tmp/mysql_ushastry.sock using pquery... Infile is ./1425600530.sql Database is test Starting with 30 threads Query limit per thread is 400000 User is root Socket is /tmp/mysql_ushastry.sock MySQL Connection Info: Localhost via UNIX socket MySQL Client Info: 5.6.25 MySQL Server Info: 5.6.25-enterprise-commercial-advanced * Last 250 consecutive queries all failed. Likely crash/assert, user privileges drop, or similar. Ending run. ./1425600530_run_pquery: line 6: 27588 Segmentation fault (core dumped) ./1425600530_pquery --infile=./1425600530.sql --database=test --threads=30 --queries=400000 --user=root --socket=/tmp/mysql_ushastry.sock Fri Mar 13 13:40:31 CET 2015 [umshastr@hod03]/export/umesh/mysql-5.6.25: ./1425600530_run_pquery Fri Mar 13 13:42:23 CET 2015 Executing testcase ./1425600530.sql against mysqld with socket /tmp/mysql_ushastry.sock using pquery... Infile is ./1425600530.sql Database is test Starting with 30 threads Query limit per thread is 400000 User is root Socket is /tmp/mysql_ushastry.sock MySQL Connection Info: Localhost via UNIX socket MySQL Client Info: 5.6.25 MySQL Server Info: 5.6.25-enterprise-commercial-advanced-debug * Last 250 consecutive queries all failed. Likely crash/assert, user privileges drop, or similar. Ending run. ./1425600530_run_pquery: line 6: 12238 Segmentation fault (core dumped) ./1425600530_pquery --infile=./1425600530.sql --database=test --threads=30 --queries=400000 --user=root --socket=/tmp/mysql_ushastry.sock Fri Mar 13 13:59:29 CET 2015 Please feel free to reopen the bug with exact reproducible test case. Thanks, Umesh
[16 Mar 2015 6:18]
Ramesh Sivaraman
Could you please check the error log. pquery segfaults error is due to crash.
[17 Mar 2015 10:23]
MySQL Verification Team
No, Ramesh. mysqld didn't assert - confirmed it from error log.