[ https://forge.continuent.org/jira/browse/SEQUOIA-539?page=comments#action_13626 ]
Guillaume Smet commented on SEQUOIA-539: ---------------------------------------- Hi Emmanuel, You mean that recovery log will then respect the fact that sequences were incremented in different connections and will execute each nextval in the right one? I'm not sure this is even feasible to have a working behaviour for that. At least it won't work if you don't close all the connections to the database when you backup to remove the sequences cache of each PostgreSQL backend associated with a connection. -- Guillaume > Postgres Sequences > ------------------ > > Key: SEQUOIA-539 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-539 > Project: Sequoia > Type: Bug > Components: Recovery Log > Versions: Sequoia 2.8.1 > Environment: 2 Windows XP running Postgres, One XP machine running Sun > Application Server 8.1 (J2EE Application that uses Hibernate) that > communicates with controller running on the same machine. Controller is > configured with one cluster which interact with the 2 Postgres databases. > HSQL database stores recovery log. > Reporter: Lee Cooper > Assignee: Emmanuel Cecchet > Fix For: Sequoia 2.9 > Attachments: information.zip > > > I am new to sequoia but I believe I have found a bug with the version I am > running 2.8.1 BUILD 10. I am investigating the use of sequoia in a BT > project. > I have been testing Sequoia Recovery: > When I run both backends everything works well all data and sequences are > duplicated across both databases (RAIDb-1 approach). > However in the follwing senario I dicoover a problem with recovery. > disable backend1 > (ADD NEW ROW USING HIBERNATE WHICH USES MY SequoiaDialect which overloads the > sequence method on the PostgresDialect) > enable backend1 > The recovery seems to work well on the surface but when you dig deeper the > sequence value on backend1 (relating to that new added row) does not change > (increment) > This later causes obvious problems when sequence is gained from backend1 and > then violates the PK constaint on backend1 and backend2. > I have followed the documentation to the letter in regards to postgres and > hibernate and am very confident that I have configured the Controller > correctly. > I will be happy to provide all xml config if required. > I am very keen to use the product and when I have more experience with it I > hope to contribute to its further development. > Lee -- 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
