On 22-mrt-2007, at 12:33, Emmanuel Cecchet wrote:

Leander,

Hmm, we've been seeing all kinds of weird behavior and/or bugs
in Sequoia in combination with JDK 1.6, The problems appear to
be mostly XML related, although this is based on my subjective
observations. At one point during failover testing, I ran into a
situation where it was impossible to re-add a controller to a RAIDb-1
cluster, because Sequoia thought that the vdb config files on
the two controllers were different, which was positively not the
case, because the config files had not changed since I removed
the controller from the cluster:

========================
2007-03-15 00:13:12,928 ERROR controller.xml.DatabasesParser The virtual database sequoiadb could not be added to the controller (because of Error while joining group sequoiadb (org.continuent.sequoia.common. exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.)) java.lang.Exception: Error while joining group sequoiadb (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.)

The other controller should print the explicit message saying what is incompatible in the configuration. Could you retrieve that message?

Well, this is the only thing that is logged on the other (functioning) controller:

2007-03-15 00:15:19,404 WARN Controller Member(address=/ 10.0.30.50:10000, uid=10.0.30.50:10000) has left distributed virtual database unicorn

I don't think that the loglevel was set very high at that moment.

By the way, I see this in the log of the controller I was trying to add to the
cluster during start-up and right before the failure to load the vdb:

2007-03-15 00:15:03,267 INFO controller.core.Controller Sequoia controller (3.0-beta2) 2007-03-15 00:15:03,338 INFO controller.core.Controller Loading configuration file: /usr/local/sequoia/config/controller/controller.xml
2007-03-15 00:15:03,406 INFO  controller.core.Controller JMX is enabled
2007-03-15 00:15:03,429 INFO controller.core.Controller Starting JMX server on host: 10.0.30.50:1090 2007-03-15 00:15:03,546 DEBUG controller.core.Controller JMX server started 2007-03-15 00:15:03,552 INFO controller.core.Controller Waiting for connections on 0.0.0.0:25322 2007-03-15 00:15:03,552 DEBUG controller.core.Controller Backlog size is 10 connections. 2007-03-15 00:15:03,563 INFO controller.core.Controller Controller started on 2007.03.15 11 at 12:15:03 AM CET 2007-03-15 00:15:03,563 INFO controller.core.Controller Controller db02 ready, listening to requests ... 2007-03-15 00:15:15,517 DEBUG controller.core.Controller Loading New Virtual Database 2007-03-15 00:15:15,517 DEBUG controller.core.Controller Adding VirtualDatabase null 2007-03-15 00:15:15,670 INFO controller.backup.BackupManager Registering backuper postgres to handle format PostgreSQL Binary Dump 2007-03-15 00:15:16,522 INFO appia.xml.AppiaXML Loading XML configuration from file: /usr/local/sequoia/config/appia.xml 2007-03-15 00:15:16,905 INFO continuent.hedera.appia AppiaThread: Starting Appia. 2007-03-15 00:15:20,086 ERROR controller.xml.DatabasesParser The virtual database unicorn could not be added to the controller (because of Error while joining group unicorn (org.continuent.sequoia.common.e xceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.)) java.lang.Exception: Error while joining group unicorn (org.continuent.sequoia.common.exceptions.ControllerException: Virtual database configuration is not compatible with other controller settings.) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualData base.joinGroup(DistributedVirtualDatabase.java:629) at org.continuent.sequoia.controller.xml.DatabasesParser.endElement (DatabasesParser.java:646) at org.apache.crimson.parser.Parser2.maybeElement (Parser2.java:1528)
        at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement (Parser2.java:1507) at org.apache.crimson.parser.Parser2.parseInternal (Parser2.java:500)
        at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
<SNIP rest of exception>


This looks weird to me:

2007-03-15 00:15:15,517 DEBUG controller.core.Controller Adding VirtualDatabase null



Also, I had criticial issues while restoring dumps to a backend,
because Sequoia was unable to drop the database first:

========================
...
2007-03-14 23:38:52,100 DEBUG backup.backupers.NativeCommandOutputThread Thread-7: dropdb: database removal failed: ERROR: database "sequoiadb" is being accessed by other users

Which version of PostgreSQL are you using?

PostgreSQL 8.2.2


Are you sure that you did not have a client directly connected to the PostgreSQL backend?

Yes, positively.


As you can see, the backend database cannot be dropped because
there are client connections to it, but these connections are from
Sequoia. However, I could not find a way to prevent Sequoia from
starting connections to the database. I was able to cirumvent this by
killing the postgresql processes from the command line, but then the
restore of the recovery log would fail after restoring the SQL dump.
Basically, we had been running around in circles like this for days,
where solving one issue introduced another and seeing unpredictable
and erratic behavior until we switched to JDK 1.5, after which all these issues basically went away. I would like to ask this question again: is
JDK 1.6 even supported for Sequoia? If not, then _please_ add this
information to the website and documentation, with a big fat warning
sign next to it, so other users will not have to experience the madness
we did...

As far as I know, JDK 1.6 has not been tested, so we should certainly update the documentation to mention this.

Yes, please do! Which java version do you guys use normally?


Just to make sure that the problem is due to the runtime, you are using a binary version provided on Continuent.org and not a version that you recompiled with JDK 1.6, is that correct ?

Yes, we use the binary distribution from continuent.org.

Thanks,
Leander




_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to