Hi David,
I've set up two controllers with two backends mirrored as raid 1 with
mysql.
all seems to work fine, but when i try to create tables within the
sequoia controller's mysql client the following happens:
jdbc:sequoia://10.0.0.2:25322/test (test) > create table barfoo (i
integer, vc varchar);
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Internal exception
org.continuent.hedera.adapters.TimeoutException)
The timeout is probably due to a group communication configuration
issue. Do you have any more information in the controller log file that
could help us identifying the issue?
a very simple table structure works on the fly, but only with integer
fields:
jdbc:sequoia://10.0.0.2:25322/test (test) > create table barfoo (i
integer); Affected rows: 0
Query executed in 0 s 130 ms .
ok, perhaps I have an error in my sql statements, but what really
concerns me is that a (maybe) wrong statement produces a timeout
instead of an error message.
This is strange. Maybe the controller gets a non serializable
SQLException from the driver. What version of the MySQL driver are you
using?
What happens if you force the driver to be in the controller classpath
(that could help work around some serialization issues)?
see my confiuration here:
http://kulturbeutel.org/sequoia/controller.xml
http://kulturbeutel.org/sequoia/mysql-raid1.xml
Any Ideas?
The configuration looks good. I suppose the configuration is similar for
the second controller.
You should check if the initialization procedure worked properly and if
the controllers see each other properly.
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
