Fresh copy hangs on table change save

[expired user #9058]'s profile image [expired user #9058] posted 9 years ago in General Permalink
HI - longtime Heidi user - always has worked flawlessly. On a new, fresh install, I imported an sql file and it's working perfectly, however, if I try to save table changes, even on an empty table with no data, it just hangs when Save is clicked. I eventually terminate the process and restart, and the changes are not saved.

Any troubleshooting steps recommended to figure out what the problem could be?

Thank you.

Bill
ansgar's profile image ansgar posted 9 years ago Permalink
Perhaps turn on debug logging in tools > preferences > logging. Then, when Heidi hangs, watch out for what happened so far in the SQL log panel.
[expired user #9058]'s profile image [expired user #9058] posted 9 years ago Permalink
Hello - thanks for quick reply. It seems to be worse now. I can't even view the table in question. Hangs right when I click the table name. The log also seems to stop mid-word:

/* 2015-07-01 13:40:01 [] */ /* Writing to session log file now: C:\Users\Administrator\AppData\Roaming\HeidiSQL\Sessionlogs\000001.log */
/* 2015-07-01 13:40:08 [Unnamed] */ /* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
/* 2015-07-01 13:40:08 [Unnamed] */ SELECT CONNECTION_ID();
/* 2015-07-01 13:40:08 [Unnamed] */ /* Connected. Thread-ID: 65635 */
/* 2015-07-01 13:40:08 [Unnamed] */ /* Unknown character set: 'utf8mb4' */
/* 2015-07-01 13:40:08 [Unnamed] */ /* Characterset: utf8 */
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW STATUS;
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW VARIABLES;
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW DATABASES;
/* 2015-07-01 13:40:08 [Unnamed] */ USE `spw_online`;
/* 2015-07-01 13:40:08 [] */ /* Entering session "Unnamed" */
/* 2015-07-01 13:40:08 [Unnamed] */ SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='spw_online';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW TABLE STATUS FROM `spw_online`;
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW FUNCTION STATUS WHERE `Db`='spw_online';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW PROCEDURE STATUS WHERE `Db`='spw_online';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW TRIGGERS FROM `spw_online`;
/* 2015-07-01 13:40:08 [Unnamed] */ SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW TABLE STATUS FROM `information_schema`;
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW FUNCTION STATUS WHERE `Db`='information_schema';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW TRIGGERS FROM `information_schema`;
/* 2015-07-01 13:40:08 [Unnamed] */ SHOW EVENTS FROM `information_schema`;
/* 2015-07-01 13:40:08 [Unnamed] */ SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='spw_online';
/* 2015-07-01 13:40:25 [Unnamed] */ SHOW CREATE TABLE `spw_onl

That's it - just stopped right there. Any ideas?
[expired user #9058]'s profile image [expired user #9058] posted 9 years ago Permalink
Hi - update: the table had 1.3m records and was still processing. Later yesterday I finally ran a SHOW FULL PROCESSLIST and sure enough, I had 30 tasks queued up - by then I'd tried dropping tables and databases etc.

So I don't think Heidi was involved in the problem at all, and simply couldn't get MySQL to respond to her.

Love your software. Thanks again!

Bill

Please login to leave a reply, or register at first.