[midPoint-git] [Evolveum/midpoint] d8b774: Sqale: Switched transaction isolation to Repeatabl...

[Tony Tkáčik]

  Branch: refs/heads/feature/sqale-repeatable-read
  Home:   https://github.com/Evolveum/midpoint
  Commit: d8b7740083521052a53db90c09300588911b08ca
      https://github.com/Evolveum/midpoint/commit/d8b7740083521052a53db90c09300588911b08ca
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2024-03-04 (Mon, 04 Mar 2024)

  Changed paths:
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/SqaleRepositoryConfiguration.java

  Log Message:
  -----------
  Sqale: Switched transaction isolation to Repeatable Reads

Originally native postgres repository used Read Commited transaction
but that is not sufficient in multiple cases such as:
  - search containers (2+ selects, data could desync between selects)
  - lookup tables (data are in separate table than object)
  - splitted objects (data are in multiple tables)

This commit does not provide full support for Repeatable Reads.


  Commit: 1bdf4d7d8d29ca225786bc95ea086ab6e238d687
      https://github.com/Evolveum/midpoint/commit/1bdf4d7d8d29ca225786bc95ea086ab6e238d687
  Author: Tony Tkáčik <tonydamage at gmail.com>
  Date:   2024-03-04 (Mon, 04 Mar 2024)

  Changed paths:
    M repo/repo-sqale/src/main/java/com/evolveum/midpoint/repo/sqale/SqaleRepositoryService.java

  Log Message:
  -----------
  sqale: Introduced retry mechanism and use it for advance sequence.


Compare: https://github.com/Evolveum/midpoint/compare/d8b774008352%5E...1bdf4d7d8d29

To unsubscribe from these emails, change your notification settings at https://github.com/Evolveum/midpoint/settings/notifications