Project

General

Profile

GX-Bug #64863

MySQL 8: Nummernkreisänderung wird (scheinbar) nicht übernommen | Changes in ID starts are (seemingly) not accepted

Added by Marco Bruchmann almost 2 years ago. Updated 3 months ago.

Status:
Erledigt
Priority:
Hoch
Category:
Core
Target version:
% Done:

0%

Estimated time:
Steps to reproduce:
Betroffene Versionen:
3.15.2.0, 3.15.2.0 beta1, 3.15.2.1, 3.15.3.0, 3.15.3.0 beta1, 3.15.3.1, 3.15.4.0, 3.15.4.0 beta1, 3.15.4.1, 3.15.4.2, 4.0.0.0, 4.0.0.0 beta1, 4.0.0.1, 4.0.1.0, 4.0.1.0 beta1, 4.0.2.0, 4.0.2.0 beta1, 4.0.2.1, 4.0.3.0, 4.0.3.0 beta1, 4.1.1.0, 4.1.1.0 beta1, 4.1.1.0 beta2, 4.1.1.0 beta3, 4.1.1.0 beta4, 4.1.1.0 rc1, 4.1.1.0 rc2, 4.1.1.1, 4.1.1.2, 4.1.1.3, 4.1.2.0, 4.1.2.0 beta1, 4.1.3.0, 4.1.3.0 beta1, 4.2.0.0, 4.2.0.0 beta1, 4.3.1.0 beta1
Release Notes Langtext:

Nummernkreisänderungen werden auch bei der Nutzung von MySQL8 wieder übernommen


Description

Bei Verwendung von MySQL-Version >= 8.0 kann es sein, dass Änderungen an den Nummernkreisen scheinbar nicht übernommen werden, d.h. nach dem Speichern erscheint trotz Übernahme in der Anzeige wieder der alte Wert. Grund dafür ist ein mit MySQL 8 eingeführter Cache für Tabellenstatistiken.
Lösungsweg: Mit „ANALYZE TABLE table_name“ kann der Cache zurückgesetzt werden.


When using MySQL >= 8.0 it may seem that changes in “ID starts“ are not properly saved, i.e. after saving and applying the old values still appear again. The reason for this is a newly introduced cache for table statistics in MySQL 8.
Suggested solution: “ANALYZE TABLE table_name” will clear the cache.

History

#1

Updated by Wilken Haase almost 2 years ago

  • Subject changed from Nummernkreisänderung wird (scheinbar) nicht übernommen | Changes in ID starts are (seemingly) not accepted to MySQL 8: Nummernkreisänderung wird (scheinbar) nicht übernommen | Changes in ID starts are (seemingly) not accepted
  • Description updated (diff)
#2

Updated by Wilken Haase almost 2 years ago

  • Description updated (diff)
#3

Updated by Marco Bruchmann about 1 year ago

  • Priority changed from Normal to Hoch
#4

Updated by Marco Bruchmann about 1 year ago

  • Betroffene Versionen 3.15.2.0, 3.15.2.1, 3.15.3.0, 3.15.3.0 beta1, 3.15.3.1, 3.15.4.0, 3.15.4.0 beta1, 3.15.4.1, 3.15.4.2, 4.0.0.0, 4.0.0.0 beta1, 4.0.0.1, 4.0.1.0, 4.0.1.0 beta1, 4.0.2.0, 4.0.2.0 beta1, 4.0.2.1, 4.0.3.0, 4.0.3.0 beta1, 4.1.1.0, 4.1.1.0 beta1, 4.1.1.0 beta2, 4.1.1.0 beta3, 4.1.1.0 beta4, 4.1.1.0 rc1, 4.1.1.0 rc2, 4.1.1.1, 4.1.1.2, 4.1.1.3, 4.1.2.0, 4.1.2.0 beta1, 4.1.3.0, 4.1.3.0 beta1, 4.2.0.0, 4.2.0.0 beta1, 4.3.1.0 beta1 added
#5

Updated by Ulrich Wenk about 1 year ago

  • Status changed from Gemeldet to Feedback
  • Assignee set to Marco Bruchmann
#6

Updated by Ulrich Wenk about 1 year ago

  • Status changed from Feedback to Anerkannt
  • Assignee deleted (Marco Bruchmann)
#7

Updated by Jonatas Fischer about 1 year ago

  • Status changed from Anerkannt to In Bearbeitung
  • Assignee set to Jonatas Fischer
#8

Updated by Jonatas Fischer about 1 year ago

  • Status changed from In Bearbeitung to Feedback
  • Assignee changed from Jonatas Fischer to Marco Bruchmann
#9

Updated by Marco Bruchmann about 1 year ago

  • Assignee changed from Marco Bruchmann to Jonatas Fischer

Go to “Shop Settings” -> “ID Starts” (up to 4.2) or “Settings“ and search for “Orders and Customers“ (4.3).

#10

Updated by Daniel Wu about 1 year ago

  • Status changed from Feedback to Gemeldet
  • Assignee deleted (Jonatas Fischer)
#11

Updated by Till Tepelmann about 1 year ago

  • Status changed from Gemeldet to Anerkannt
#12

Updated by Jonatas Fischer about 1 year ago

  • Status changed from Anerkannt to In Bearbeitung
#13

Updated by Jonatas Fischer 9 months ago

  • Status changed from In Bearbeitung to Anerkannt
#14

Updated by Daniel Wu 9 months ago

  • Tags changed from MySQL8 to MySQL8, 4.3.3.0
#15

Updated by Julian Heckmann 9 months ago

  • Status changed from Anerkannt to In Bearbeitung
  • Assignee set to Julian Heckmann
#16

Updated by Julian Heckmann 9 months ago

  • Status changed from In Bearbeitung to 30
  • Assignee changed from Julian Heckmann to Core-Entwickler
  • Target version changed from 133 to 4.3.3.0
  • Release Notes Langtext updated (diff)

I tested it with MySQL 5.6, MySQL 8 and MariaDB10.

#17

Updated by Marvin Muxfeld 9 months ago

  • Status changed from 30 to Testing
#18

Updated by Alexandre Ataides 9 months ago

  • Assignee changed from Core-Entwickler to Alexandre Ataides
#19

Updated by Alexandre Ataides 9 months ago

  • Status changed from Testing to Erledigt
#20

Updated by Moritz Bunjes 3 months ago

  • Tags changed from MySQL8, 4.3.3.0 to MySQL8
#21

Updated by Moritz Bunjes 3 months ago

  • Tags deleted (MySQL8)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 5 MB)