Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Description
Started MariaDB 10.4.6 debug cluster and run following on one of the nodes:
MariaDB [test]> SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Feature\", \"geometry\": [10, 20] }"); |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
mysqld: /home/shako/Galera_Tests/MariaDB/sql/spatial.cc:395: static Geometry* Geometry::create_from_json(Geometry_buffer*, json_engine_t*, bool, String*): Assertio |
n `je->state == JST_KEY' failed.
|
190610 12:57:03 [ERROR] mysqld got signal 6 ; |
|
|
sql/spatial.cc:397(Geometry::create_from_json(Geometry_buffer*, st_json_engine_t*, bool, String*))[0x55b4350f19ff] |
sql/item_geofunc.cc:157(Item_func_geometry_from_json::val_str(String*))[0x55b434ff5afc]
|
sql/sql_type.cc:6737(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x55b434e24177] |
sql/sql_type.h:4629(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x55b434e2fb40] |
/home/shako/Galera_Tests/dbs/maria_10.4/bin/mysqld(+0x6caaaa)[0x55b434b00aaa]
|
/home/shako/Galera_Tests/dbs/maria_10.4/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xcb)[0x55b434afb7ad]
|
/home/shako/Galera_Tests/dbs/maria_10.4/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xe2)[0x55b434ba8d7a]
|
sql/item.h:1036(Item::send(Protocol*, st_value*))[0x55b434c6786e]
|
sql/protocol.cc:1024(Protocol::send_result_set_row(List<Item>*))[0x55b434c67186]
|
sql/sql_class.cc:3002(select_send::send_data(List<Item>&))[0x55b434c6882d]
|
sql/sql_select.cc:4257(JOIN::exec_inner())[0x55b434c58e15]
|
sql/sql_select.cc:4173(JOIN::exec())[0x55b434c22745]
|
sql/sql_select.cc:4606(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55b434c179b5] |
sql/sql_select.cc:412(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55b434c264d9] |
sql/sql_parse.cc:6612(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b434c25b4f]
|
sql/sql_parse.cc:3884(mysql_execute_command(THD*))[0x55b434c11a46]
|
sql/sql_parse.cc:8164(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b434c1035d] |
sql/sql_parse.cc:7987(wsrep_mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b434d887ff] |
sql/sql_parse.cc:1813(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b434d88563] |
nptl/pthread_create.c:463(start_thread)[0x7ff0044686db]
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Alexey Botchkov [ holyfoot ] |
| Summary | spatial.cc:395: static Geometry* Geometry::create_from_json(Geometry_buffer*, json_engine_t*, bool, String*): Assertion `je->state == JST_KEY' failed while SELECT ST_GEOMFROMGEOJSON() | Assertion `je->state == JST_KEY' failed while SELECT ST_GEOMFROMGEOJSON() and Assertion `!mysql_bin_log.is_open() || thd.is_current_stmt_binlog_format_row()' |
| Comment |
[ Idem (again sporadic or C-connector required) for:
{noformat} CREATE TABLE t1 (ROWID INT, f1 INT, f2 INT, KEY i1 (f1, f2), KEY i2 (f2)) ENGINE=MyISAM; SET GLOBAL wsrep_forced_binlog_format='STATEMENT'; INSERT DELAYED INTO t1 VALUES ('24','1','1'); SELECT ST_GEOMFROMGEOJSON ("{ \"type\": \"Feature\", \"GEOMETRY\": [10, 20] }"); {noformat} ] |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.6 [ 24028 ] |
| Fix Version/s | 10.5 [ 23123 ] |
| Labels | GIS json | GIS affects-tests json |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2021-01-19 12:30:06.0 | 2021-01-19 12:30:06.86 |
| Fix Version/s | 10.2.37 [ 25112 ] | |
| Fix Version/s | 10.3.28 [ 25111 ] | |
| Fix Version/s | 10.4.18 [ 25110 ] | |
| Fix Version/s | 10.5.9 [ 25109 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 97427 ] | MariaDB v4 [ 156333 ] |