There is a table in the database

create table pre_Accounts ( pre_account_id int auto_increment primary key, mail varchar(64) not null, password varchar(128) not null, solt varchar(128) not null, confirm_token varchar(128) not null, confirm bool default false );

I want to update the data in it, and specifically in the confirm column, change from false to true. I set the following command:

 update pre_Accounts set confirm = true where pre_account_id = 1;

However, the DBMS gives me an error:

 Error Code: 1436. Thread stack overrun: 8196 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

Help to understand who knows ..

  • 2
    You have the answer in the question: Use 'mysqld --thread_stack = #' to specify a bigger stack. Or in the configuration file add thread_stack = 512K. Restart mysql - Alexus
  • Thank you all corrected - it worked, but a new problem appeared. Stackoverflow.com/questions/619287/… - Roman Timokhov

0