Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Tip
titleNothing to do for MySQL, Microsoft SQL Server and Oracle

Only PostgreSQL may require an action here, if you reach 2 billion records.

Requirement Yogi 2.6.4 for Confluence and above.

Introduction

Prior to version 2.6.4, all our database records were identified by IDs which were limited to 2 billion rows.

...

In future versions, we will change the rest of the tables.

As a database administrator, when should I act?

  • At the latest, you can wait for users to raise the issue. Unfortunately, it means pages will be saved but requirements won't be updated from the moment users meet the issue.
  • If you want to act early, we suggest you act when the ID "2 billion" is generated in the table AO_32F7CE_AOINTEGRATION_QUEUE, since the limit is ~2.147 billion. You can check this using the tab "Usage metrics" in the Requirement Yogi administration.
  • It's just a sequence where you need to increase its max.

Expected error on PostgreSQL

...