Details
Description
http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4205/steps/test/logs/stdio
sys_vars.max_sp_recursion_depth_func [ fail ]
|
Test ended at 2014-11-24 15:25:04
|
|
CURRENT_TEST: sys_vars.max_sp_recursion_depth_func
|
mysqltest: At line 64: query 'CALL sp_addRecords(0,8)' failed: 1436: Thread stack overrun: 172008 bytes used of a 294912 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
|
|
The result from queries just before the failure was:
|
< snip >
|
** Connection test_con1 **
|
SET @@session.max_sp_recursion_depth = 10;
|
SELECT @@session.max_sp_recursion_depth;
|
@@session.max_sp_recursion_depth
|
10
|
DROP PROCEDURE IF EXISTS sp_addRecords;
|
CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)
|
BEGIN
|
SELECT var1,var2;
|
IF var1 < var2 THEN
|
CALL sp_addRecords(var1+1,var2);
|
SELECT var1,var2;
|
END IF;
|
END //
|
CALL sp_addRecords(0,8);
|
main.signal_demo3 [ fail ]
|
Test ended at 2014-11-24 15:19:00
|
|
CURRENT_TEST: main.signal_demo3
|
mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun: 172008 bytes used of a 294912 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.', instead of 1644...
|
|
The result from queries just before the failure was:
|
< snip >
|
resignal sqlstate '45000' set message_text='Oops in proc_7';
|
call proc_8();
|
end
|
$$
|
create procedure proc_8()
|
begin
|
declare exit handler for sqlexception
|
resignal sqlstate '45000' set message_text='Oops in proc_8';
|
call proc_9();
|
end
|
$$
|
create procedure proc_9()
|
begin
|
declare exit handler for sqlexception
|
resignal sqlstate '45000' set message_text='Oops in proc_9';
|
## Do something that fails, to see how errors are reported
|
drop table oops_it_is_not_here;
|
end
|
$$
|
call proc_1();
|
Attachments
Issue Links
- blocks
-
MDEV-7172 Fix buildbot failures in 10.1 tree
- Closed
- links to