Periodic failure to replicate transactions across all controllers
-----------------------------------------------------------------
Key: SEQUOIA-1046
URL: https://forge.continuent.org/jira/browse/SEQUOIA-1046
Project: Sequoia
Type: Bug
Versions: Sequoia 2.10.9
Environment: Current Configuration:
3 Geronimo Application Servers (3 physical boxes) connected to 3 Sequoia
controllers (3 physical boxes) using Appia for Multicast replication, each
controller connecting to 1 PostgreSQL backends (3 physical boxes)
Reporter: Dominic Vieira
Fire the following queries from geronimo will violates foreign key constraint
on one of the controllers while the other two will execute the statements
successfully.
# Step 1: insert a new name to the user table
insert into user ('name') values ('John')
# Step 2: retrieve the generated id for the record just inserted
select currval user_user_id
# Step 3: insert a phone number associated to the new user, assuming the
user_id is 1
# This statement may fail sometimes with a foreign key constraint exception
insert into phone ('user_id', 'phone') values (1, '1234567890')
commit
All the queries above had been recorded to the 'log_table' by the Sequoia
controllers in the right order.
When failure occurs backend disables, with a foreign missing error in the
full_cluster.log
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
