peacelink/phpeace
peacelink/phpeace
1
0
Fork 0
Code Issues 12 Pull requests Projects Releases Packages Wiki Activity Actions

nextId not atomic in MariaDB cluster #64

New issue
Closed
opened 2025-09-09 09:29:51 +00:00 by iannuzzelli · 6 comments
iannuzzelli commented 2025-09-09 09:29:51 +00:00 (Migrated from gitlab.com)
Copy link

https://gitlab.com/peacelink/phpeace/-/blob/main/classes/dbmysql.php?ref_type=heads#L306-327

https://gitlab.com/peacelink/phpeace/-/blob/main/classes/dbmysql.php?ref_type=heads#L306-327
iannuzzelli commented 2025-09-09 09:30:32 +00:00 (Migrated from gitlab.com)
Copy link

changed the description

changed the description
iannuzzelli commented 2025-09-09 09:30:35 +00:00 (Migrated from gitlab.com)
Copy link

assigned to @iannuzzelli

assigned to @iannuzzelli
iannuzzelli commented 2025-09-09 09:31:02 +00:00 (Migrated from gitlab.com)
Copy link

changed title from Current nextId is not atomic in MariaDB cluster to nextId not atomic in MariaDB cluster

<p>changed title from <code class="idiff"><span class="idiff left deletion">Current </span>nextId <span class="idiff right deletion">is </span>not atomic in MariaDB cluster</code> to <code class="idiff">nextId not atomic in MariaDB cluster</code></p>
iannuzzelli commented 2025-09-09 10:56:53 +00:00 (Migrated from gitlab.com)
Copy link

see https://stackoverflow.com/questions/78824255/how-to-get-a-safe-and-correct-sequential-number-in-a-mariadb-galera-cluster

see https://stackoverflow.com/questions/78824255/how-to-get-a-safe-and-correct-sequential-number-in-a-mariadb-galera-cluster
iannuzzelli commented 2025-10-17 19:28:27 +00:00 (Migrated from gitlab.com)
Copy link

Decreasing priority as it seems a rare event, probably a race condition

Decreasing priority as it seems a rare event, probably a race condition
iannuzzelli (Migrated from gitlab.com) closed this issue 2026-02-03 17:11:56 +00:00
iannuzzelli commented 2026-02-03 17:11:57 +00:00 (Migrated from gitlab.com)
Copy link

We move to Postgres instead

We move to Postgres instead
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
develop
main
v3.12.13
v3.12.12
v3.12.11
v3.12.10
v3.12.9
v3.12.8
v3.12.7
v3.12.6
v3.12.5
v3.12.4
v3.12.3
v3.12.2
v3.12.1
v3.12.0
v3.11.2
v3.11.1
v3.11.0
v3.10.3
v3.10.2
v3.10.1
v3.10.0
v3.9.5
v3.9.4
v3.9.3
v3.9.2
v3.9.1
v3.9.0
v3.8.1
v3.8.0
v3.7.1
v3.7.0
v3.6.6
v3.6.5
v3.6.4
v3.6.3
v3.6.2
v3.6.1
v3.6.0
v3.5.11
v3.5.10
v3.5.9
v3.5.8
v3.5.7
v3.5.6
v3.5.5
v3.5.4
v3.5.3
v3.5.2
v3.5.1
v3.5.0
v3.4.4
v3.4.3
v3.4.2
v3.4.1
v3.4.0
v3.3.3
v3.3.2
v3.3.1
v3.3.0
v3.2.11
v3.2.10
v3.2.9
v3.2.8
v3.2.7
v3.2.6
v3.2.5
v3.2.4
v3.2.3
v3.2.2
v3.2.1
v3.2.0
v3.1.0
v3.0.7
Labels
Clear labels   
Doing

   
P1: critical

   
P2: important

   
P3: useful

   
P4: nice to have

   
P5: reminder

   
To Do

   
bug

   
duplicate

   
invalid

   
wontfix
No labels
Doing
P1: critical
P2: important
P3: useful
P4: nice to have
P5: reminder
To Do
bug
duplicate
invalid
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
peacelink/phpeace#64
No description provided.