Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
Starting from the revision 840f1310cb6ee15cffdac5a4d2a95551575b2c3b, the test "compound" fails in build-bot for bb-10.2-ext, with this output:
main.compound w2 [ fail ]
|
Test ended at 2017-09-23 16:35:33
|
|
CURRENT_TEST: main.compound
|
mysqltest: At line 127: query 'prepare stmt from "if fn(?) > 6 then
|
begin
|
declare a int;
|
set a=?*2;
|
insert t1 values(a+?);
|
end;
|
end if"' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
executing: drop table t4
|
create table t1 (x int)|
|
create function fn(a int) returns int
|
begin
|
insert t1 values (a+7);
|
return a+8;
|
end|
|
reset master|
|
/**/ if fn(9) > 5 then
|
select 1;
|
end if|
|
1
|
1
|
prepare stmt from "if fn(?) > 6 then
|
begin
|
declare a int;
|
set a=?*2;
|
insert t1 values(a+?);
|
end;
|
end if"|
|
|
More results from queries before failure can be found in D:\winx64-debug\build\mysql-test\var\2\log\compound.log
|
|
|
Server [mysqld.1 - pid: 6604, winpid: 6604, exit: 65280] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2017-09-23 16:35:27 2360 [Note] D:/winx64-debug/build/sql//Debug/mysqld.exe (mysqld 10.2.9-MariaDB-debug-log) starting as process 4540 ...
|
2017-09-23 16:35:27 2360 [Note] Plugin 'SEQUENCE' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'partition' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'InnoDB' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_LOCKS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMPMEM' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMP' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'FEEDBACK' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'user_variables' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_TRX' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_METRICS' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2017-09-23 16:35:27 2360 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2017-09-23 16:35:27 2360 [Warning] D:/winx64-debug/build/sql//Debug/mysqld.exe: unknown option '--loose-pam-debug'
|
2017-09-23 16:35:27 2360 [Note] Server socket created on IP: '::'.
|
2017-09-23 16:35:27 2360 [Note] Reading of all Master_info entries succeded
|
2017-09-23 16:35:27 2360 [Note] Added new Master_info '' to hash table
|
2017-09-23 16:35:27 2360 [Note] D:/winx64-debug/build/sql//Debug/mysqld.exe: ready for connections.
|
Version: '10.2.9-MariaDB-debug-log' socket: '' port: 16100 Source distribution
|
Assertion failed: pos < 0xFFFFFFFFL, file d:\winx64-debug\build\src\sql\sql_lex.h, line 3450
|
170923 16:35:27 [ERROR] mysqld got exception 0x80000003 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.2.9-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=65537
|
thread_count=3
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4229 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0xe3b482eed8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
mysqld.exe!my_sigabrt_handler()[my_thr_init.c:488]
|
mysqld.exe!raise()[signal.cpp:516]
|
mysqld.exe!abort()[abort.cpp:71]
|
mysqld.exe!common_assert_to_stderr<wchar_t>()[assert.cpp:149]
|
mysqld.exe!_wassert()[assert.cpp:404]
|
mysqld.exe!LEX::add_placeholder()[sql_lex.h:3450]
|
mysqld.exe!MYSQLparse()[sql_yacc.yy:13935]
|
mysqld.exe!parse_sql()[sql_parse.cc:9928]
|
mysqld.exe!Prepared_statement::prepare()[sql_prepare.cc:3910]
|
mysqld.exe!mysql_sql_stmt_prepare()[sql_prepare.cc:2823]
|
mysqld.exe!mysql_execute_command()[sql_parse.cc:3712]
|
mysqld.exe!mysql_parse()[sql_parse.cc:7896]
|
mysqld.exe!dispatch_command()[sql_parse.cc:1814]
|
mysqld.exe!do_command()[sql_parse.cc:1369]
|
mysqld.exe!threadpool_process_request()[threadpool_common.cc:366]
|
mysqld.exe!tp_callback()[threadpool_common.cc:192]
|
mysqld.exe!tp_callback()[threadpool_win.cc:378]
|
mysqld.exe!work_callback()[threadpool_win.cc:452]
|
ntdll.dll!RtlFreeUnicodeString()
|
ntdll.dll!RtlFreeUnicodeString()
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0xe3b49e8978): if fn(?) > 6 then
|
begin
|
declare a int;
|
set a=?*2;
|
insert t1 values(a+?);
|
end;
|
end if
|
Connection ID (thread ID): 5
|
Status: NOT_KILLED
|