Insert Row duplicating

4 posts
[expired user #8467]'s profile image [expired user #8467] posted 9 years ago in General Permalink
In the interface when I say insert row, it will insert two rows with the same data. Does not happen when I run the query direct. This is happening on a mariadb cluster.
10146 posts
ansgar's profile image ansgar posted 9 years ago Permalink
What does the SQL log panel say? Are there two INSERT queries or?
4 posts
[expired user #8467]'s profile image [expired user #8467] posted 9 years ago Permalink

What does the SQL log panel say? Are there two INSERT queries or?

Yes there are two insert queries.
4 posts
[expired user #8467]'s profile image [expired user #8467] posted 9 years ago Permalink 
SHOW STATUS;
SHOW VARIABLES;
USE `test`;
INSERT INTO `test`.`test` (`test`) VALUES ('1');
SELECT LAST_INSERT_ID();
SELECT `id`, `test` FROM `test`.`test` WHERE  `id`=3;
SHOW CREATE TABLE `test`.`test`;
SHOW COLLATION;
SHOW ENGINES;
INSERT INTO `test`.`test` (`test`) VALUES ('1');
SELECT `id`, `test` FROM `test`.`test` WHERE  `id`=3;
SELECT * FROM `test`.`test` LIMIT 1000;
SHOW CREATE TABLE `test`.`test`;
10146 posts
ansgar's profile image ansgar posted 9 years ago Permalink
Hm... that's strange. Will check that.
4 posts
[expired user #8467]'s profile image [expired user #8467] posted 9 years ago Permalink

Hm... that's strange. Will check that.

Could it be something like.. Heidi checks to see if row got inserted but it's still trying to replicate to the cluster so it inserts again? I've never used Heidi on a cluster before.

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