distal-attribute
distal-attribute
distal-attribute
distal-attribute

Doubling inserts after timeout?

User, date Message
Written by ReinShope
10 months ago
Category: General
2 posts since Sun, 07 Jul 13
So I'm pretty new to MySQL in general, and even newer to HeidiSQL -- but I've found an issue that I can't seem to solve.

I can connect to my databases fine and edit them through the HeidiSQL GUI just fine. Inserting rows works like a charm... until in the bottom it shows a timeout and says "connection to [site] closed". Once that happens, every time I try to insert a new row into a table, it INSERTs two of the same thing I just entered, instead of one. If I close the connection and reopen it altogether, the problem is no longer there.

Is this an issue on my side? Anything I can do to prevent this?

Thanks!
Written by ansgar
10 months ago
4801 posts since Fri, 07 Apr 06
Are you using the latest build of HeidiSQL? If not, please update and test again.
Written by ReinShope
10 months ago
2 posts since Sun, 07 Jul 13
Yep, up to date and everything. Still haven't found any new information about it, either.
Written by pzahra
8 months ago
2 posts since Tue, 03 Sep 13
Same.
Version 8.0 4502
Also does it on Updates which causes warnings.

/* Connecting to #.#.#.# via Percona (TCP/IP), username ****, using password: Yes ... */
/* Connected. Thread-ID: 110200738 */
SHOW STATUS;
SHOW VARIABLES;
USE `lbmedia_pbmag`;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT LAST_INSERT_ID();
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
SHOW COLLATION;
SHOW ENGINES;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` LIMIT 1000;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
/* Connection to #.#.#.# closed at 2013-09-03 18:53:45 */
 

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