Jan-willem,
It seems that there are a couple of issues:
We use auto commit normally, but libmysequoia doesn't like it (gives
an error 'Operation not allowed after ResultSet closed'), so we ran
without auto commit, but didn't perform manual commits...
Ok, so it looks like you don't really understand what transactions are
about. If you set autocommit to false, it starts a transaction. If you
never commit, nothing will ever be persisted in the database (all your
updates will be rollback when the connection dies).
The 'Operation not allowed after ResultSet closed' is due to the fact
that you are trying to access a ResultSet after it has been closed. This
is likely a problem in your application logic.
What we found is that Sequoia has a tendency to stop a backend (crash)
on trivial things like a typing error in an sql statement.
No it does not. It is only when a backend does not behave as the others
(one fails but the other succeed). If you send garbage to the cluster,
all nodes will fail the same way and reject the statement.
In your scenario where you just start a single big transaction, the
transaction is aborted after the first error on a write (typical
database behavior). So you have to rollback the transaction and start a
new one if you want to make progress.
Combined with the trouble of performing a dump/restore whenever a
backend looses its state (not a quick job for a multiple GB database),
it isn't the solution for us (at least not at the moment).
A backend should never lose its state unless a real failure happens. The
backup operation should not take more time than for a single database
instance where you should also do backups I guess.
We also had a lot of problems getting Appia to work correctly, but
that's probably for another forum?
Yes, you can post on [EMAIL PROTECTED] Group communication setup is
not trivial.
Although there is a lot of documentation, it's still a bit of a hit &
miss affair to get things up and running, especially if you want to
combine Sequoia, Appia and libmysequoia. I could have done with an
idiot's guide for that :-)
Yes, you are right, we are certainly lacking documentation on these
aspects. All contributions are welcome to help the community.
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
