ERROR while trying to upgrade APSC SQL database from 11.1.0

[sda0]

Hello,
There is problem during update 11.0.9 to 11.5.30

*****  problem report *****
ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jul 30 11:31:10 MSK 2013

I have made mysql_upgrade as its wrote on another thread but it doesn't help.

What else I can do ?

just for info, I dont use APS at all. I have empty application storage in my plesk installation.

 

[IgorG]

Do you have in /tmp/plesk_11.5.30_installation.log something like:

ERROR 1436 (HY000) at line 85: Thread stack overrun: 9056 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

or any other useful error messages?

 

[sda0]

Yes, there is ERROR 1436 (HY000) at line 85: Thread stack overrun: 7984 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

but I saw it too and I have changed thread_stack = 128K in [mysqld] section of my.cnf, but no changes
how can fix this?

 

[IgorG]

Try to set it:

thread_stack = 256K

restart mysqld and check that it is applied with something like

mysql> show variables where `Variable_name` = 'thread_stack';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| thread_stack | 262144 |
+---------------+--------+
1 row in set (0.01 sec)

 

[sda0]

thank you, will try this night

 

[VictorLav]

I have the same error trying to upgrade to 11.5.30
I looked at the log file: /tmp/plesk_11.5.30_installation.log and I see this error:

ERROR 1548 (HY000) at line 67: Cannot load from mysql.proc. The table is probably corrupted
InnoDB

Have any idea what is referring to?

 

[Nikolay.]

Probably you've upgraded MySQL and need to run mysql_upgrade command. Search this forum for details.