[ https://forge.continuent.org/jira/browse/SEQUOIA-608?page=comments#action_13796 ]
mat damon commented on SEQUOIA-608: ----------------------------------- http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/209/actors.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/210/actres3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/211/actress1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/212/actress1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/213/actress_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/214/adult1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/215/adult1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/216/adult1_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/217/adult2_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/218/adult2_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/219/actors.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/220/actres3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/221/actress1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/222/actress1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/223/actress_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/224/adult1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/225/adult1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/226/adult1_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/227/adult2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/228/adult2_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/229/adult2_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/230/adult3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/231/adult5_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/232/adult6.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/233/adult_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/234/adult_3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/235/age3_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/236/age3_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/237/aika_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/238/aisan.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/239/aisan_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/240/aisan_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/241/aishwary.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/242/aisian.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/243/akira_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/244/amature2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/245/amatures.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/246/amatures_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/247/amatures_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/248/amauter.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/249/amauter_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/250/america.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/251/american.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/252/american_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/253/american_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/254/ameteur.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/255/ameteur_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/256/ameteur_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/257/anderso2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/258/anderso3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/259/anderson.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/260/anima1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/261/anima1_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/262/animated.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/263/animated_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/264/animated_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/265/animati1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/266/arabic_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/267/arabic_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/268/arbic.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/269/archie.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/270/archives.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/271/arse.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/272/artis.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/273/artist.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/274/asain_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/275/asain_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/276/asiansex.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/277/asin.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/278/ass.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/279/ass_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/280/ass_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/281/assfucki.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/282/assholes.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/283/assian.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/284/babe1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/285/babes1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/286/babes1_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/287/babes_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/288/babes_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/289/babies.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/290/baby.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/291/baby_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/292/babys.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/293/beautifu_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/294/beauty_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/295/being.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/296/being_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/297/being_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/298/beutiful.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/299/beutiful_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/300/big3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/301/big3_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/302/bitchs.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/303/bitchs_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/304/black1_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/305/black2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/306/black2_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/307/black3.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/308/black3_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/309/black3_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/310/black4.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/311/black4_1.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/312/black4_2.html http://gforge.casil.ucdavis.edu/tracker/download.php/30/350039/200134/313/blow.html > Create table statement parsing does not lock tables referenced in foreign key > constraints > ----------------------------------------------------------------------------------------- > > Key: SEQUOIA-608 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-608 > Project: Sequoia > Type: Bug > Components: Core > Versions: Sequoia 2.8.2, Sequoia 2.8.1, Sequoia 2.7, Sequoia 2.6.1, > Sequoia 2.6, Sequoia 2.5 > Reporter: Emmanuel Cecchet > Assignee: Stephane Giron > Priority: Critical > Fix For: Sequoia 3.0 beta3 > > > Create requests that have foreign key constraints are not parsed properly. > For example: CREATE table t2(bid int PRIMARY KEY, aid int, foreign key(aid) > references t1(aid)) > will only lock table t2 where it should also lock t1. > This causes problems in the request locking in the load balancer that could > schedule this query in parallel of t1 CREATE TABLE statement and fail if t2 > creation is executed before t1. -- 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
