[MDEV-7186] get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot Created: 2014-11-24  Updated: 2015-11-06  Resolved: 2015-01-19

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.16

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled
blocks MDEV-7185 main.func_isnull fails in buildbot on... Closed
Relates
relates to MDEV-9089 Server crashes in MDL_key::mdl_key_in... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6560/steps/test/logs/stdio

main.sp_notembedded                      [ fail ]
        Test ended at 2014-11-21 17:53:25
 
CURRENT_TEST: main.sp_notembedded
mysqltest: At line 331: query 'SELECT GET_LOCK('Bug44521', 0)' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv,
Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv,
Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,
Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv,
Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions,
max_updates, max_connections, max_user_connections) 
VALUES('%', 'mysqltest_1', password(''), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N',
'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', '',
'', '', '', '0', '0', '0', '0');
Warnings:
Warning	1364	Field 'authentication_string' doesn't have a default value
FLUSH PRIVILEGES;
CREATE PROCEDURE p1(i INT) BEGIN END;
DROP PROCEDURE p1;
DELETE FROM mysql.user WHERE User='mysqltest_1';
FLUSH PRIVILEGES;
#
# Bug#44521 Prepared Statement: CALL p() - crashes: `! thd->main_da.is_sent' failed et.al.
#
SELECT GET_LOCK('Bug44521', 0);
 
More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\sp_notembedded.log
 
 
Server [mysqld.1 - pid: 281136, winpid: 281136, exit: 768] failed during test run
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------

main.trigger_notembedded                 [ fail ]
        Test ended at 2014-11-21 17:57:03
 
CURRENT_TEST: main.trigger_notembedded
mysqltest: At line 897: query 'SELECT GET_LOCK('B26162',120)' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
ERROR 42000: SELECT command denied to user 'mysqltest_dfn'@'localhost' for column 'i1' in table 't1'
DROP PROCEDURE p1;
CREATE PROCEDURE p1(INOUT i INT) DETERMINISTIC NO SQL SET i = i + 51;
INSERT INTO t1 VALUES (53);
ERROR 42000: SELECT command denied to user 'mysqltest_dfn'@'localhost' for column 'i1' in table 't1'
DROP PROCEDURE p1;
REVOKE UPDATE ON mysqltest_db1.* FROM mysqltest_dfn@localhost;
DROP TRIGGER t1_bi;
DROP USER mysqltest_inv@localhost;
DROP USER mysqltest_dfn@localhost;
DROP TABLE t2;
DROP TABLE t1;
DROP DATABASE mysqltest_db1;
USE test;
CREATE TABLE t1 (id INTEGER);
CREATE TABLE t2 (id INTEGER);
INSERT INTO t2 VALUES (1),(2);
CREATE TRIGGER t1_test AFTER INSERT ON t1 FOR EACH ROW 
INSERT INTO t2 VALUES (new.id);
SELECT GET_LOCK('B26162',120);
 
More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\trigger_notembedded.log
 
 
Server [mysqld.1 - pid: 278220, winpid: 278220, exit: 768] failed during test run
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------



 Comments   
Comment by Elena Stepanova [ 2014-11-24 ]

select get_lock('Bug44521',0)

mysqld.exe!my_sigabrt_handler()[my_thr_init.c:475]
mysqld.exe!raise()[winsig.c:593]
mysqld.exe!abort()[abort.c:82]
mysqld.exe!_wassert()[assert.c:155]
mysqld.exe!MDL_key::mdl_key_init()[mdl.h:354]
mysqld.exe!MDL_request::init()[mdl.cc:1244]
mysqld.exe!Item_func_get_lock::val_int()[item_func.cc:4280]
mysqld.exe!Item::send()[item.cc:6489]
mysqld.exe!Protocol::send_result_set_row()[protocol.cc:904]
mysqld.exe!select_send::send_data()[sql_class.cc:2542]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:2456]
mysqld.exe!JOIN::exec()[sql_select.cc:2372]
mysqld.exe!mysql_select()[sql_select.cc:3310]
mysqld.exe!handle_select()[sql_select.cc:373]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5261]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2545]
mysqld.exe!mysql_parse()[sql_parse.cc:6407]
mysqld.exe!dispatch_command()[sql_parse.cc:1302]
mysqld.exe!do_command()[sql_parse.cc:996]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
kernel32.dll!BaseFormatTimeOut()
ntdll.dll!RtlEqualDomainName()
ntdll.dll!RtlValidateHeap()
kernel32.dll!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

Only aborts on debug build, release seems to be okay.

Generated at Thu Feb 08 07:17:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.