Bug #98273 | Assertion failure upon INSERT into the table with SPATIAL index | ||
---|---|---|---|
Submitted: | 17 Jan 2020 15:56 | Modified: | 18 Jan 2020 12:47 |
Reporter: | Valeriy Kravchuk | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S6 (Debug Builds) |
Version: | 5.7.29, 8.0.19, 8.0.11 | OS: | Ubuntu (16.04) |
Assigned to: | CPU Architecture: | Any |
[17 Jan 2020 15:56]
Valeriy Kravchuk
[18 Jan 2020 12:47]
MySQL Verification Team
Hello Valeriy, Thank you for the report and test case. Verified as described on debug builds of 5.7.29/8.0.19. regards, Umesh
[18 Jan 2020 12:48]
MySQL Verification Team
Test results - 5.7.29
Attachment: 98273_5.7.29.results (application/octet-stream, text), 57.03 KiB.
[18 Jan 2020 12:48]
MySQL Verification Team
Test results - 8.0.19
Attachment: 98273_8.0.19.results (application/octet-stream, text), 152.49 KiB.
[18 Jan 2020 12:52]
MySQL Verification Team
- Lowest version checked 8.0.11 - affected ./mtr --debug-server bug98273 Logging: ./mtr --debug-server bug98273 2020-01-18T12:49:26.723650Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.11/bin/mysqld-debug (mysqld 8.0.11-debug) starting as process 1205 MySQL Version 8.0.11 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.11/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.bug98273 [ fail ] Test ended at 2020-01-18 13:49:48 Server [mysqld.1 - pid: 1262, winpid: 1262, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2020-01-18T12:49:44.781715Z 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2020-01-18T12:49:44.781809Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-01-18T12:49:44.781891Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.11/bin/mysqld-debug (mysqld 8.0.11-debug) starting as process 1263 2020-01-18T12:49:47.542056Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 023919de-39f1-11ea-8a93-0010e05f3e06. 2020-01-18T12:49:47.549714Z 0 [Warning] [MY-010068] [Server] CA certificate /export/umesh/server/binaries/GABuilds/mysql-8.0.11/mysql-test/std_data/cacert.pem is self signed. 2020-01-18T12:49:47.715047Z 0 [System] [MY-010931] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.11/bin/mysqld-debug: ready for connections. Version: '8.0.11-debug' socket: '/export/umesh/server/binaries/GABuilds/mysql-8.0.11/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - GPL - Debug. 2020-01-18T12:49:48.417359Z 8 [ERROR] [MY-011825] [InnoDB] InnoDB: [FATAL] Data field type 240, len 10752 2020-01-18T12:49:48.417395Z 8 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: ut0ut.cc:675
[18 Jan 2020 12:53]
MySQL Verification Team
- 5.6.47 No assertion as mtr fails ./mtr --debug-server bug98273 Logging: ./mtr --debug-server bug98273 2020-01-18 13:51:53 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-01-18 13:51:53 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.47-linux-glibc2.12-x86_64/bin/mysqld-debug (mysqld 5.6.47-debug) starting as process 1417 ... 2020-01-18 13:51:53 1417 [Note] Plugin 'FEDERATED' is disabled. 2020-01-18 13:51:53 1417 [Note] Binlog end 2020-01-18 13:51:53 1417 [Note] Shutting down plugin 'CSV' 2020-01-18 13:51:53 1417 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.47 Too long tmpdir path '/export/umesh/server/binaries/GABuilds/mysql-5.6.47-linux-glibc2.12-x86_64/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/RCVDE36i9s' Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.47-linux-glibc2.12-x86_64/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 SET @save_limit = @@innodb_limit_optimistic_insert_debug; main.bug98273 [ fail ] Test ended at 2020-01-18 13:51:57 CURRENT_TEST: main.bug98273 mysqltest: At line 5: query 'create table t1(a serial, b geometry not null, spatial index(b)) engine=innodb' failed: 1464: The used table type doesn't support SPATIAL indexes - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.6.47-linux-glibc2.12-x86_64/mysql-test/var/log/main.bug98273/bug98273.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 5 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bug98273 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
[2 Jan 2021 3:11]
Roel Van de Paar
This bug seems fixed in 5.7.32, 8.0.22?