strange/wrong values after editing with heidi

Dave_B's profile image Dave_B posted 3 years ago in General Permalink
  • HeidiSQL version: 11.2.0.6213
  • Database type and version: MariaDB 10.4.6
  • OS: Windows 10 Pro

Since years I have a table with a DATETIME Field, and only I write to this field, manually, per HeidiSQL (the table is a list, and whenever I solve an entry, I mark it with the current DateTime in the data editor, not with an sql statement). I'm the only person doing that. I always use Heidi for that.

Now I found false, senseless values in this DATETIME column: 3198-04-16 00:00:42, 2955-11-09 28:18:37, 2618-00-01 00:34:33 and so on. And, it get better, I suddenly have a lot of differences between this table and it's replica, in only this field. What can that be?

I thought, maybe it's only a issue with the new heidi version, but old versions show the same wrong values in this column. And of course it could be a serious problem with MariaDB ... but why are replicated values different? Some changes are years old, the replication of this data took place a long time ago, and now, without further changes at this rows, the values are different? But both wrong? And I searched for other DATETIME columns, and there are several, but no one with this "behaviour". And this ist the absolute only column in the database I always change manually with Heidi. I regularly look into this table, several times a week, since a long time. And now I found these false values, only in this column ... the only column I only changed with heidi? I don't understand.

I'm very unsettled right now. I know, it's unlikely, that heidi caused the problem. But only this column of all things?

Is there somebody who can explain what might be happened?

3 attachment(s):
  • primary
  • replica
  • correct_from_dump
ansgar's profile image ansgar posted 3 years ago Permalink

I suppose these were changed externally, by some web application or whatever is writing to your database?

You should probably have a look into the data using another client, and compare that with HeidiSQL.

Dave_B's profile image Dave_B posted 3 years ago Permalink

Definitely not. It's my database, and only my applications write into this database. But not into this column. It has no reference in any application.

ansgar's profile image ansgar posted 3 years ago Permalink

Ok, but you should definitely compare the result with a different client, to check if HeidiSQL is displaying wrong values.

Dave_B's profile image Dave_B posted 3 years ago Permalink

I did. This was my first thought too (because of the new heidi version), but DBeaver shows the same values. Thought too, that the table could be corrupt, but it isn't. Something have written false values into this column, and I only change these values with heidi. Very strange...

Ansgar, thank you very much for looking into it, and thank you for your great work on heidi!

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