Menu
▾
▴
sequoiadb-discuss — Mailing list for discussing topics related to Sequoia clustering
You can subscribe to this list here.
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
(10) |
May
(44) |
Jun
(10) |
Jul
(4) |
Aug
(3) |
Sep
(1) |
Oct
(4) |
Nov
(3) |
Dec
(2) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2010 |
Jan
|
Feb
|
Mar
(4) |
Apr
|
May
(5) |
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
|
|
From: Emmanuel C. <ma...@fr...> - 2009-05-08 00:21:28
|
Hi Heshel, > I have a couple of questions concerning the replication of Sequoia. > Some background info, we have two locations that we are in the process > of setting up. In each location will be two controllers, currently > sitting on the same box as the application server. These controllers > then have one or more PostgreSQL database boxes for backends. We will > also be setting up a pair of switches for the internal communications > in each location. Hopefully the duplication will allow me to sleep > soundly if we ever have a piece of hardware fail.. ;) We are running > FreeBSD for the under lying OS, and the binary of Sequoia 2.10.10. > > First, I am attempting to use a dedicated link between the controllers > in the same physical location, however I cannot see to get the > controllers to use the IP of this interface for replication. I will be > removing my current configuration and starting fresh in hopes that it > may just be an error in them, but I thought I would also ask here if > can it be done while I work that out. You can force which IP address you want the controller to bind in the controller configuration file. > Second, I did have a working configuration for using a single nic for > all communication, however, there was some issues with it. The > controllers would disconnect shortly after forming the cluster, upon > checking my logs they were using ports outside of what I had > configured the hedra/jgroups configuration files for. I had configured > the controllers to use 7900 as the communication port, which they did > use, but none of the other ports were defined by myself to connect to. > (This is a reason I am looking at the separate interface for the > controller communication, as opening pf right up on the main > interface(s), or turning it off is not an option. However, having a > crossconnect between the two servers that is unhindered is acceptable.) Are you sure that the controller is using your configuration file? It will use the first one it finds in the classpath. > Third I am required to setup replication between 2 physical locations. > Since the plan is to use Sequoia for replication in each location, > there have been talks of using it for the wan replication as well. I > am curious about peoples experience with such a setup. As another > possibility, I have been looking into the use of the tungsten > connector between the controllers at each site. For Tungsten, I guess you will have to ask on the Tungsten mailing list. I have not been following their development closely (shame on me) and I am not sure how this would work. You can try to setup a tunnel for the group communication between the 2 sites but latency is probably going to be a penalty. Another option is to use the remote controller as an additional backend of the local controller. > Some additonal questions; > > FreeBSD rc scripts? I did some digging in the past to see if this was > possible, found some talk of it but nothing more. There are some scripts for Linux but nothing for FreeBSD as far as I know. > Probably a very common question, new releases of Sequoia? I know > working is being done on 4.x, and possibly 2.10.11? Just curious if > there is any timelimes? Sequoia 2.10.11 if it ever comes out will be provided by Continuent. Not sure if this will ever happen. Sequoia 4 relies on me. I have been very busy with my 2 other jobs recently and I have had no time to make progress. I have to make a new release (probably a beta), if possible this month, otherwise in June. The problem is that I have to redo the documentation and that will take time. Also I have no access to the test suite that was developed at Continuent so the debugging phase might be more painful. Keep us posted with your progress. Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Heshel R. <hs...@gm...> - 2009-05-07 17:53:57
|
Hello all, I have a couple of questions concerning the replication of Sequoia. Some background info, we have two locations that we are in the process of setting up. In each location will be two controllers, currently sitting on the same box as the application server. These controllers then have one or more PostgreSQL database boxes for backends. We will also be setting up a pair of switches for the internal communications in each location. Hopefully the duplication will allow me to sleep soundly if we ever have a piece of hardware fail.. ;) We are running FreeBSD for the under lying OS, and the binary of Sequoia 2.10.10. First, I am attempting to use a dedicated link between the controllers in the same physical location, however I cannot see to get the controllers to use the IP of this interface for replication. I will be removing my current configuration and starting fresh in hopes that it may just be an error in them, but I thought I would also ask here if can it be done while I work that out. Second, I did have a working configuration for using a single nic for all communication, however, there was some issues with it. The controllers would disconnect shortly after forming the cluster, upon checking my logs they were using ports outside of what I had configured the hedra/jgroups configuration files for. I had configured the controllers to use 7900 as the communication port, which they did use, but none of the other ports were defined by myself to connect to. (This is a reason I am looking at the separate interface for the controller communication, as opening pf right up on the main interface(s), or turning it off is not an option. However, having a crossconnect between the two servers that is unhindered is acceptable.) Third I am required to setup replication between 2 physical locations. Since the plan is to use Sequoia for replication in each location, there have been talks of using it for the wan replication as well. I am curious about peoples experience with such a setup. As another possibility, I have been looking into the use of the tungsten connector between the controllers at each site. Some additonal questions; FreeBSD rc scripts? I did some digging in the past to see if this was possible, found some talk of it but nothing more. Probably a very common question, new releases of Sequoia? I know working is being done on 4.x, and possibly 2.10.11? Just curious if there is any timelimes? Thanks for your time, Heshel |
|
From: Emmanuel C. <ma...@fr...> - 2009-05-06 14:01:30
|
Owais, You can find an example at http://forge.continuent.org/pipermail/sequoia/2007-September/005654.html. Use pgDumpFlags to pass extra options to pgdump. Hope this helps, Emmanuel > Emmanuel, I want to add "ignore flag" as well, so that I can overcome the > limitation of different version numbers. Can you tell me how can I do that ? > secondly, can you send me the sample xml backuper tag? > > -Owais > > -----Original Message----- > From: Emmanuel Cecchet [mailto:ma...@fr...] > Sent: Tuesday, May 05, 2009 5:45 PM > To: owais > Cc: seq...@li... > Subject: Re: [Sequoiadb-discuss] Postgre Backup Problem > > Hi Owais, > > I would recommend the PostgreSQLPlainTextBackuper if disk space is not > an issue otherwise the PostgreSQLBinaryBackuper is pretty good too. > Avoid Octopus at all costs. > > Thanks for your interest in Sequoia, > Emmanuel > > >> I am facing difficulty in backup process. I am using Postgre as my >> backend database. I have the following question: >> >> >> >> What is the recommended backuper to use for Postgre backend? >> >> >> >> -Owais >> >> ------------------------------------------------------------------------ >> >> >> > ---------------------------------------------------------------------------- > -- > >> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your >> production scanning environment may not be a perfect world - but thanks to >> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK >> > i700 > >> Series Scanner you'll get full speed at 300 dpi even with all image >> processing features enabled. http://p.sf.net/sfu/kodak-com >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Sequoiadb-discuss mailing list >> Seq...@li... >> https://lists.sourceforge.net/lists/listinfo/sequoiadb-discuss >> >> > > > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: owais <ow...@pr...> - 2009-05-06 04:32:04
|
Emmanuel, I want to add "ignore flag" as well, so that I can overcome the limitation of different version numbers. Can you tell me how can I do that ? secondly, can you send me the sample xml backuper tag? -Owais -----Original Message----- From: Emmanuel Cecchet [mailto:ma...@fr...] Sent: Tuesday, May 05, 2009 5:45 PM To: owais Cc: seq...@li... Subject: Re: [Sequoiadb-discuss] Postgre Backup Problem Hi Owais, I would recommend the PostgreSQLPlainTextBackuper if disk space is not an issue otherwise the PostgreSQLBinaryBackuper is pretty good too. Avoid Octopus at all costs. Thanks for your interest in Sequoia, Emmanuel > I am facing difficulty in backup process. I am using Postgre as my > backend database. I have the following question: > > > > What is the recommended backuper to use for Postgre backend? > > > > -Owais > > ------------------------------------------------------------------------ > > ---------------------------------------------------------------------------- -- > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your > production scanning environment may not be a perfect world - but thanks to > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 > Series Scanner you'll get full speed at 300 dpi even with all image > processing features enabled. http://p.sf.net/sfu/kodak-com > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoiadb-discuss mailing list > Seq...@li... > https://lists.sourceforge.net/lists/listinfo/sequoiadb-discuss > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-05-05 13:12:11
|
Hi Owais, I would recommend the PostgreSQLPlainTextBackuper if disk space is not an issue otherwise the PostgreSQLBinaryBackuper is pretty good too. Avoid Octopus at all costs. Thanks for your interest in Sequoia, Emmanuel > I am facing difficulty in backup process. I am using Postgre as my > backend database. I have the following question: > > > > What is the recommended backuper to use for Postgre backend? > > > > -Owais > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your > production scanning environment may not be a perfect world - but thanks to > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 > Series Scanner you'll get full speed at 300 dpi even with all image > processing features enabled. http://p.sf.net/sfu/kodak-com > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoiadb-discuss mailing list > Seq...@li... > https://lists.sourceforge.net/lists/listinfo/sequoiadb-discuss > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: owais <ow...@pr...> - 2009-05-05 07:24:47
|
11:02:10,419 INFO backup.backupers.OctopusBackuper Starting restore of backend mssql2 from checkpoint dump12
Default (Standard) Logger is load.
OctopusGenerator started.
CreateIncludeFiles is started. Generating sql and xml files is started.
createIncludeFiles method is started.
Working....test
done...
createIncludeFiles method is finished.
CreateIncludeFiles is finished. Generating sql and xml files is finished.
Generating of LoaderJob.olj file is started.
loadJobWriter method is started.
loadJobWriter method is finished.
Generating of LoaderJob.olj file is finished.
Duration: 0,118 seconds
OctopusGenerator finished.
Default (Standard) Logger is load.
Application is started.
Loader loads XML file : /tmp/backup/dump12/LoaderJob.olj
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropIntegrity.sql
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropIntegrity.sql (No such file or directory)
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropIntegrity.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropTables.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropTables.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateTables.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateTables.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIndex.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIndex.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreatePrimary.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreatePrimary.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIntegrity.sql
Document not found: file:/tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIntegrity.sql
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/DropTables.sql (No such file or directory)
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateTables.sql (No such file or directory)
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIndex.sql (No such file or directory)
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreatePrimary.sql (No such file or directory)
java.io.FileNotFoundException: /tmp/backup/tmp/backup/dump12/SQLForAllVendors/Csv/sql/CreateIntegrity.sql (No such file or directory)
XML document is valid.
All rows are commited.
Application is finished.
All jobs duration: 0,341 seconds
|
|
From: owais <ow...@pr...> - 2009-05-05 06:13:40
|
I am facing difficulty in backup process. I am using Postgre as my backend database. I have the following question: What is the recommended backuper to use for Postgre backend? -Owais |
|
From: xzy12345 <xzy...@12...> - 2009-05-03 15:05:58
|
Hi,Thanks for your help.I test the application again using junit.
The select and update statements is ok.But when writing,the console will
print :
23:00:08,046 WARN sequoia.controller.cache Table t_head_sys not found in cache
schema. Flushing whole cache.
When I changed the configuration from
<bean id="myDataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="org.continuent.sequoia.driver.Driver">
</property>
<property name="url" value="jdbc:sequoia://localhost:25322/myDB"></property>
<property name="username" value="user"></property>
<property name="password" value="user"></property>
</bean>
to
<bean id="myDataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url" value="jdbc:mysql://localhost:3306/coas"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
It's right ok.So I think the problem lies in that the way I fetch the database schema from my database backends.
myDB(admin) > show backend localhost1
+--------------------------+-------------------------------------+
| Backend Name | localhost1 |
| Driver | org.gjt.mm.mysql.Driver |
| URL | jdbc:mysql://192.168.1.10:3306/coas |
| Active transactions | 0 |
| Pending Requests | 0 |
| Read Enabled | true |
| Write Enabled | true |
| Is Initialized | true |
| Static Schema | false |
| Connection Managers | 2 |
| Total Active Connections | 25 |
| Persistent Connections | 0 |
| Total Requests | 2039 |
| Total Transactions | 0 |
| Last known checkpoint | <unknown> |
+--------------------------+-------------------------------------+
I looked the sequoia.dtd file.But I don't know what should I change.
My configuration is:
<DatabaseBackend name="localhost1" driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://192.168.1.10:3306/coas" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="root" rPassword="root">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="localhost2" driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://192.168.1.25:3306/coas" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="root" rPassword="root">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
Thanks for your help.
|
|
From: Emmanuel C. <ma...@fr...> - 2009-05-03 13:07:57
|
Hi, As the error says: > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: Unknown table 'coas.t_counsellor_sys' in this UPDATE > statement: 'update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, > COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, > EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, > COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=?') It looks like the table coas.t_counsellor_sys was not found. Do you have tables in different schemas or is coas your database name? If the table really exists, you might have to look into the options to fetch the database schema from your database backend. Keep us posted with your progress, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: xzy12345 <xzy...@12...> - 2009-05-03 08:50:30
|
Hi,thanks for your last two emails.I configured success with one controller,two backends.When I just use junit to test,It's ok.But once I configured with hibernate and spring,It has errors.
my configuration is ：
<bean id="myDataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="org.continuent.sequoia.driver.Driver">
</property>
<property name="url" value="jdbc:sequoia://localhost:25322/myDB"></property>
<property name="username" value="user"></property>
<property name="password" value="user"></property>
</bean>
The relevant trace is:
2009-05-02 23:08:51,343 INFO (com.opensymphony.xwork2.validator.ActionValidatorManagerFactory:29) - Detected AnnotationActionValidatorManager, initializing it...
2009-05-02 23:13:11,843 WARN (org.hibernate.util.JDBCExceptionReporter:77) - SQL Error: 0, SQLState: null
2009-05-02 23:13:11,843 ERROR (org.hibernate.util.JDBCExceptionReporter:78) - Batch failed for request 0: update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=? (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Unknown table 'coas.t_counsellor_sys' in this UPDATE statement: 'update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=?')
2009-05-02 23:13:11,859 ERROR (org.hibernate.event.def.AbstractFlushingEventListener:301) - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate3.HibernateTemplate.merge(HibernateTemplate.java:775)
at org.fantasyworks.xidian.coas.dao.hibernate.HibernateBaseDAO.update(HibernateBaseDAO.java:95)
at org.fantasyworks.xidian.coas.dao.hibernate.CounsellorDAO.updateCounsellor(CounsellorDAO.java:91)
at org.fantasyworks.xidian.coas.services.impl.CounsellorService.updateCounsellorInfo(CounsellorService.java:113)
.....
Caused by: java.sql.BatchUpdateException: Batch failed for request 0: update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=? (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Unknown table 'coas.t_counsellor_sys' in this UPDATE statement: 'update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=?')
at org.continuent.sequoia.driver.PreparedStatement.executeBatch(PreparedStatement.java:1027)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 132 more
2009-05-02 23:13:11,984 INFO (org.springframework.beans.factory.xml.XmlBeanDefinitionReader:309) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2009-05-02 23:13:12,046 INFO (org.springframework.jdbc.support.SQLErrorCodesFactory:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2009-5-2 23:13:12 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet default threw exception
java.sql.BatchUpdateException: Batch failed for request 0: update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=? (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of cause: Unknown table 'coas.t_counsellor_sys' in this UPDATE statement: 'update coas.t_counsellor_sys set ADMIN_ID=?, FLAG_ID=?, COUNSELLOR_ID=?, NAME=?, GENDER=?, DORM=?, DORM_TEL=?, CELLPHONE=?, EMAIL=?, LAST_LOGIN_TIME=?, PERSONALINDEX=?, COUNSELLOR_USERNAME=?, COUNSELLOR_PASSWORD=?, LAST_LOGIN_IP=? where COUNSELLOR_SYS_ID=?')
at org.continuent.sequoia.driver.PreparedStatement.executeBatch(PreparedStatement.java:1027)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate3.HibernateTemplate.merge(HibernateTemplate.java:775)
at org.fantasyworks.xidian.coas.dao.hibernate.HibernateBaseDAO.update(HibernateBaseDAO.java:95)
at org.fantasyworks.xidian.coas.dao.hibernate.CounsellorDAO.updateCounsellor(CounsellorDAO.java:91)
at org.fantasyworks.xidian.coas.services.impl.CounsellorService.updateCounsellorInfo(CounsellorService.java:113)
at org.fantasyworks.xidian.coas.web.action.sysLogin.execute(sysLogin.java:86)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
.....
Thanks for any help
|
|
From: Adam D. <ada...@gm...> - 2009-05-01 22:32:59
|
I am testing Sequoia 4 in Ubuntu 8.10 with Java 1.6.0_10. When flushing preferences inside a process that starts Sequoia, the preferences aren't saved and I get Exception in thread "Timer-0" java.lang.AbstractMethodError: org.apache.crimson.tree.XmlDocument.getXmlStandalone()Z at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.setDocumentInfo(DOM2TO.java:373) at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.setDocumentInfo(DOM2TO.java:373) at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:127) at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:94) at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:662) at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:708) at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:313) at java.util.prefs.XmlSupport.writeDoc(XmlSupport.java:259) at java.util.prefs.XmlSupport.exportMap(XmlSupport.java:338) at java.util.prefs.FileSystemPreferences$8.run(FileSystemPreferences.java:607) at java.security.AccessController.doPrivileged(Native Method) at java.util.prefs.FileSystemPreferences.writeBackCache(FileSystemPreferences.java:600) at java.util.prefs.FileSystemPreferences.syncSpiPrivileged(FileSystemPreferences.java:784) at java.util.prefs.FileSystemPreferences.access$2300(FileSystemPreferences.java:33) at java.util.prefs.FileSystemPreferences$13.run(FileSystemPreferences.java:754) at java.security.AccessController.doPrivileged(Native Method) at java.util.prefs.FileSystemPreferences.syncSpi(FileSystemPreferences.java:752) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1317) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1322) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1322) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1322) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1322) at java.util.prefs.AbstractPreferences.sync2(AbstractPreferences.java:1322) at java.util.prefs.AbstractPreferences.sync(AbstractPreferences.java:1308) at java.util.prefs.FileSystemPreferences.sync(FileSystemPreferences.java:731) at java.util.prefs.FileSystemPreferences.flush(FileSystemPreferences.java:807) at java.util.prefs.FileSystemPreferences.syncWorld(FileSystemPreferences.java:458) at java.util.prefs.FileSystemPreferences.access$1200(FileSystemPreferences.java:33) at java.util.prefs.FileSystemPreferences$4.run(FileSystemPreferences.java:419) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) If I add this jvm option, preferences work again. -Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl But, then Sequoia can't start. java.lang.RuntimeException: Unable to create and start controller, reason: org.continuent.sequoia.common.exceptions.ControllerException: Error while analysing xml configuration file (org.xml.sax.SAXException: Controller Xml configuration file is not valid.). java.lang.RuntimeException: Unable to create and start controller, reason: org.continuent.sequoia.common.exceptions.ControllerException: Error while analysing xml configuration file (org.xml.sax.SAXException: Controller Xml configuration file is not valid.). Caused by: org.continuent.sequoia.common.exceptions.ControllerException: Error while analysing xml configuration file (org.xml.sax.SAXException: Controller Xml configuration file is not valid.). at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Throwable.java:196) at java.lang.Exception.<init>(Exception.java:41) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51) at org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:213) at org.continuent.sequoia.controller.core.ControllerConfiguration.<init>(ControllerConfiguration.java:103) at com.popstarnetworks.popstar_db.process.ControllerConfig.createSetupAndStartController(ControllerConfig.java:35) Regards, Adam |
|
From: Robert H. <rob...@co...> - 2009-05-01 04:50:34
|
Hi! Sequoia: pserver:ano...@se...:/cvsroot/sequoiadb Myosotis: https://tungsten.svn.sourceforge.net/svnroot/tungsten/trunk/connector Myosotis has moved to the Tungsten project and is now the Tungsten Connector, which is why the URL has a different name. Cheers, Robert On 4/30/09 10:02 PM PDT, "owais" <ow...@pr...> wrote: Can anyone tell me about the URL of Sequoia and Myosotis Repository?. Secondly, I have my own local SVN repository, how can I synchronize my local repository with Sequoia and Myosotis Repository? -- Robert Hodges, CTO, Continuent, Inc. Email: rob...@co... Mobile: +1-510-501-3728 Skype: hodgesrm |
|
From: owais <ow...@pr...> - 2009-05-01 04:42:12
|
Can anyone tell me about the URL of Sequoia and Myosotis Repository?. Secondly, I have my own local SVN repository, how can I synchronize my local repository with Sequoia and Myosotis Repository? |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-29 17:01:28
|
Gary, > Thanks for your quick reply. However to summarize, writes are going to > be done in parallel to all databases. So even ignoring the overhead > issue, this doesn't sound like it will scale at all by adding more > machines? When the write traffic grows, eventually it will overload > the databases. Am I missing something here? You are correct, as every database has to execute the writes, there is no speedup when adding machines (there might even be a slowdown due to the increased synchronization between the databases). The next step to scale writes is to partition your database. Sequoia has something called RAIDb-2 that allows you to distribute tables on different nodes, this way you can send writes to different tables to different nodes. This code has not been tested for quite some time now so it might be better handled at the application level. If you want to partition a single table (slice it in smaller chunks), you will need a database that supports that natively. Unfortunately this is usually not compatible with replication. Sequoia will work on top of a partitioned database but it might eliminate the benefits of the partitioning by sequentializing the writes (needs to be tested to be sure). There is currently no magic solution to scale writes. It's either you buy faster hardware or you re-design your application to partition data so that writes can really be performed in parallel to different partitions (you can then use Sequoia to replicate each partition separately). Hope this helps, Emmanuel > > Emmanuel Cecchet wrote: >> Hi Gary, >> >> I am CC-ing the new mailing list. >> >>> Recently saw your post on Sequoia mailing list and have a quick newbie >>> question. Does Sequoia handle write requests? How exactly does Sequoia >>> scales with write requests? I understand that for read requests, it >>> would scale somewhat (hopefully) linearly. That is, I expect that when >>> I add 2x more databases to the group, it should be able to handle 2x >>> more incoming requests. But what about write requests? Are the data >>> updates replicated by Sequoia? If so, what kind of performance and >>> delay can I expect? Any help or hint is much appreciated! >>> >> If you are using RAIDb-1, writes are sent in parallel to all databases. >> If you have a single controller, the overhead is about a millisecond in >> latency per query. >> If you have multiple controllers, you have to add the group >> communication latency which varies depending on your configuration. >> Typical numbers range from 1 to 8ms of added latency to a request. >> So if you have a single threaded application that perform writes, you >> will see a significant overhead especially if your writes are small >> (adding 1 ms to a sub-millisecond query is more than doubling its >> execution time). As writes also have to be executed in the same order by >> all databases, Sequoia adds some constraints to make sure that writes to >> the same table are done sequentially. If you were updating in parallel >> the same table, this will now become sequential. Therefore you can see a >> significant slowdown in such use case too (we are talking pure writes, >> no reads here). >> As you pointed it out, reads are distributed among the backends and you >> can achieve fairly easily a linear speedup. So if you inject twice the >> load, the response time will remain constant and your throughput >> doubles. But if your number of requests remain constant, adding nodes to >> a non-overloaded system is not likely to bring any noticeable >> performance improvement. >> >> I hope this clarifies things a bit. >> Thanks for your interest in Sequoia, >> Emmanuel >> >> -- >> Emmanuel Cecchet >> FTO @ Frog Thinker >> Open Source Development & Consulting >> -- >> Web: http://www.frogthinker.org >> email: ma...@fr... >> Skype: emmanuel_cecchet >> >> -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-29 16:13:13
|
Hi Gary, I am CC-ing the new mailing list. > Recently saw your post on Sequoia mailing list and have a quick newbie > question. Does Sequoia handle write requests? How exactly does Sequoia > scales with write requests? I understand that for read requests, it > would scale somewhat (hopefully) linearly. That is, I expect that when > I add 2x more databases to the group, it should be able to handle 2x > more incoming requests. But what about write requests? Are the data > updates replicated by Sequoia? If so, what kind of performance and > delay can I expect? Any help or hint is much appreciated! If you are using RAIDb-1, writes are sent in parallel to all databases. If you have a single controller, the overhead is about a millisecond in latency per query. If you have multiple controllers, you have to add the group communication latency which varies depending on your configuration. Typical numbers range from 1 to 8ms of added latency to a request. So if you have a single threaded application that perform writes, you will see a significant overhead especially if your writes are small (adding 1 ms to a sub-millisecond query is more than doubling its execution time). As writes also have to be executed in the same order by all databases, Sequoia adds some constraints to make sure that writes to the same table are done sequentially. If you were updating in parallel the same table, this will now become sequential. Therefore you can see a significant slowdown in such use case too (we are talking pure writes, no reads here). As you pointed it out, reads are distributed among the backends and you can achieve fairly easily a linear speedup. So if you inject twice the load, the response time will remain constant and your throughput doubles. But if your number of requests remain constant, adding nodes to a non-overloaded system is not likely to bring any noticeable performance improvement. I hope this clarifies things a bit. Thanks for your interest in Sequoia, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-29 16:05:57
|
Hi, I just wanted to inform you that the mailing list has now officially moved to SourceForge. The new mailing list is: *seq...@li...* You can subscribe to the new mailing list from this web page: http://sourceforge.net/mail/?group_id=252061 The se...@li... is now discontinued. Cheers, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-29 16:02:43
|
Hi Freek, > I dont know how mailinglists works, so i send the questions to you. > (you may put also my questions and your answers on it) > You can subscribe to the *seq...@li... *mailing list at http://sourceforge.net/mail/?group_id=252061 > At the moment I've got 1 virtualdatabase working over 1 controller and > three nodes (2 postgresql- and 1 mssql 2005 -server). > I want to put a another controller in the cluster and connect them to > the controller en the three nodes. > > Here are my questions: > 1. I cant find an tutorial (with examples) how to place (install, > configure) an second controller next to the other one. Could give my > some tutorials to look at? > In the Sequoia distribution, there is a demo/ directory. Look at the demo-distributed-raidb1* scripts. You will see the configuration files that are used in config/controller and config/virtualdatabase. The install guide in doc/installGuide.pdf should contain step by step instructions on how to setup Sequoia with 2 controllers. > 2. I want to put an connection between the controllers. I read in the > official documentation and several tutorials that this connection is > named "appia" and you can put a connection layer on it (hedera, > jgroups, etc). But i cant find a tutorial/howto to install or > configure it. > By default, Sequoia 2.10.10 uses JGroups. You should find all necessary info in the install guide mentioned above. There are multiple group communication config file examples in the config/ directory. > 3. Do i have change my controller.xml, so that the first controller > can see controller 2? Or another file? > You need to update your virtual database config file to add a 'Distributed' element. See the examples and the doc. > 4. How do i give the controllers a name? In lots of examples i see > "name=agivenname" but doesn't work (Also if i changed the dtd.) > By default a controller name is it's IP address and port number. It cannot be overridden in Sequoia 2.10.10 (it's bogus). > Here a my working configs of the first controller (the files from > controller 2 are the same with some ip-adress & port changes): > == controller.xml == > <?xml version="1.0" encoding="UTF-8" ?> > <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA- > CONTROLLER @VERSION@//EN" "http://sequoia.continuent.org/dtds/sequoia- > controller-@VERSION@.dtd"> > <SEQUOIA-CONTROLLER> > <Controller ipAddress="10.0.2.1" port="25322"> > <JmxSettings> > <RmiJmxAdaptor port="1090"/> > </JmxSettings> > <VirtualDatabase configFile="topitest.xml" > virtualDatabaseName="topitest" autoEnableBackends="true"/> > </Controller> > </SEQUOIA-CONTROLLER> > ====================== > > ==topitest.xml (virtualdatabase)== > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN" > "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd"> > > <SEQUOIA> > <VirtualDatabase name="topitest"> > <Monitoring> > <SQLMonitoring defaultMonitoring="off"> > <SQLMonitoringRule queryPattern="^select" > caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> > </SQLMonitoring> > </Monitoring> > > <Backup> > <Backuper backuperName="Octopus" > className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper" > options="zip=true"/> > <Backuper backuperName="postgresqlbackuper" > className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"/> > <Backuper backuperName="mssqlbackuper" > className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper" > /> > </Backup> > > <AuthenticationManager> > <Admin> > <User username="admin" password="topitest"/> > </Admin> > <VirtualUsers> > <VirtualLogin vLogin="user" vPassword="topitest"/> > </VirtualUsers> > </AuthenticationManager> > > <DatabaseBackend name="ND1-UBU-RAID1" driver="org.postgresql.Driver" > url="jdbc:postgresql://10.0.2.5:5432/topitest" > connectionTestStatement="select now()"> > <ConnectionManager vLogin="user" rLogin="postgres" rPassword="topitest"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > > <DatabaseBackend name="ND2-UBU-RAID1" driver="org.postgresql.Driver" > url="jdbc:postgresql://10.0.2.7:5432/topitest" > connectionTestStatement="select now()"> > <ConnectionManager vLogin="user" rLogin="postgres" rPassword="topitest"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > > <DatabaseBackend name="ND3-WIN-SQL-R1" > driver="net.sourceforge.jtds.jdbc.Driver" > url="jdbc:jtds:sqlserver://10.0.2.9:1433;DatabaseName=topitest;SelectMethod=Cursor" > connectionTestStatement="select 1"> > > <ConnectionManager vLogin="user" rLogin="sa" rPassword="topitest"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > > <RequestManager> > <RequestScheduler> > <RAIDb-1Scheduler level="passThrough"/> > </RequestScheduler> > > <RequestCache> > <MetadataCache/> > <ParsingCache/> > <!-- <ResultCache granularity="table"/> --> > </RequestCache> > > <LoadBalancer> > <RAIDb-1> > <WaitForCompletion policy="first"/> > <RAIDb-1-LeastPendingRequestsFirst/> > </RAIDb-1> > </LoadBalancer> > > <RecoveryLog driver="org.postgresql.Driver" > url="jdbc:postgresql://10.0.2.1:5432/recovery" > login="postgres" password="topitest"> > <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL" > vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" > extraStatementDefinition=",PRIMARY KEY (log_id)"/> > <CheckpointTable tableName="CHECKPOINT" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <BackendTable tableName="BACKEND" > databaseNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL"/> > <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="VARCHAR NOT NULL" > dumpFormatColumnType="VARCHAR NOT NULL" > checkpointNameColumnType="VARCHAR NOT NULL" > backendNameColumnType="VARCHAR NOT NULL" > tablesColumnType="VARCHAR NOT NULL"/> > </RecoveryLog> > </RequestManager> > > </VirtualDatabase> > > </SEQUOIA> > ====== > I hope that this will get you started. Thanks for your interest in Sequoia, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-27 14:38:08
|
Hey Robert, Yes, I am subscribed to sequoiadb-discuss. I'll rebuild a 2.10.10 version and upload it on the Forge. Cheers manu > > If you would be so kind as to rebuild, we will look at doing a 2.10.11 > version. Also, are you subscribed to the sequoiadb-discuss list? It > seems to work and emails are posting into the archive. Finally, I'll > get CVS hooks properly running. > > Cheers, Robert > > > On 4/27/09 5:35 AM PDT, "Emmanuel Cecchet" <ma...@fr...> wrote: > > Hi Robert, > > It looks like you only uploaded the Sequoia 2.10.10 doc on SourceForge > but not the actual distribution. As it seems that there is no more > download option from the Continuent web site, no one can download > Sequoia anymore. > I can rebuild new packages but it would probably be better if you > had a > copy of the original ones. Any plans on releasing a 2.10.11 version? > > Cheers > manu > > -- > Emmanuel Cecchet > FTO @ Frog Thinker > Open Source Development & Consulting > -- > Web: http://www.frogthinker.org > email: ma...@fr... > Skype: emmanuel_cecchet > > _______________________________________________ > Sequoia mailing list > Se...@li... > http://forge.continuent.org/mailman/listinfo/sequoia > > > -- > Robert Hodges, CTO, Continuent, Inc. > Email: _ro...@co... > _Mobile: +1-510-501-3728 Skype: hodgesrm > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensign option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoiadb-discuss mailing list > Seq...@li... > https://lists.sourceforge.net/lists/listinfo/sequoiadb-discuss > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Robert H. <rob...@co...> - 2009-04-27 14:04:04
|
Hi Emmanuel, If you would be so kind as to rebuild, we will look at doing a 2.10.11 version. Also, are you subscribed to the sequoiadb-discuss list? It seems to work and emails are posting into the archive. Finally, I'll get CVS hooks properly running. Cheers, Robert On 4/27/09 5:35 AM PDT, "Emmanuel Cecchet" <ma...@fr...> wrote: Hi Robert, It looks like you only uploaded the Sequoia 2.10.10 doc on SourceForge but not the actual distribution. As it seems that there is no more download option from the Continuent web site, no one can download Sequoia anymore. I can rebuild new packages but it would probably be better if you had a copy of the original ones. Any plans on releasing a 2.10.11 version? Cheers manu -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list Se...@li... http://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: rob...@co... Mobile: +1-510-501-3728 Skype: hodgesrm |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-27 13:19:38
|
Hi, I recommend that you read the documentation on how to initialize the cluster. There are 2 possible causes for your problem: 1. You never initialized properly the cluster 2. You did not stop properly your cluster You can download a copy of the documentation from https://sourceforge.net/project/showfiles.php?group_id=252061 Hope this helps, Emmanuel xzy12345 wrote: > Hi,thank you for your last email.Now I encountered a new problem.And I > find several persons in the web have met the same problem,but no open > solution has been provided. > the full message of start is: > 16:52:49,765 INFO controller.core.Controller Sequoia controller (2.10.10) > 16:52:49,828 INFO controller.core.Controller Loading configuration > file: ..\con > fig\controller\controller-distributed-3.xml > 16:52:49,890 INFO controller.core.Controller JMX is enabled > 16:52:49,906 INFO controller.core.Controller Starting JMX server on > host: 127.0 > .0.1 > 16:52:49,906 WARN controller.core.Controller Could not parse RMI > Server Port 'n > ull > 16:52:50,203 INFO backup.backupers.OctopusBackuper OctopusBackuper > backup compr > ession is set to true > 16:52:50,203 INFO controller.backup.BackupManager Registering backuper > Octopus > to handle format Octopus v3.4.1 database neutral dump compressed > 16:52:50,218 INFO DatabaseBackend.myDB.localhost3 Adding connection > manager for > virtual user "user" > 16:52:50,234 INFO DatabaseBackend.myDB.localhost4 Adding connection > manager for > virtual user "user" > 16:52:50,531 INFO sequoia.controller.recoverylog Creating recovery log > table: l > ogtable > 16:52:50,609 INFO sequoia.controller.recoverylog Creating checkpoint > table: che > ckpointtable > 16:52:50,687 INFO sequoia.controller.recoverylog Creating backend > table: backen > dtable > 16:52:50,734 INFO sequoia.controller.recoverylog Creating dump table: > dumptable > 16:52:50,875 INFO controller.RequestManager.myDB Request manager will > parse req > uests with the following granularity: TABLE > 16:52:50,890 INFO controller.virtualdatabase.myDB Recovery log size: 0 > 16:52:50,890 INFO controller.virtualdatabase.myDB Using Hedera > properties file: > /hedera_jgroups.properties > ------------------------------------------------------- > GMS: address is 192.168.1.10:2613 > ------------------------------------------------------- > 16:52:53,375 INFO controller.virtualdatabase.myDB Waiting 2000 ms for > group mem > bership to be stable > 16:52:55,375 INFO controller.virtualdatabase.myDB Group myDB connected > to Membe > r(address=/192.168.1.10:2613, uid=myDB) > 16:52:55,375 INFO controller.virtualdatabase.myDB First controller in > group myD > B > 16:52:55,453 INFO sequoia.controller.recoverylog Checking recovery log > consiste > ncy > 16:52:55,484 WARN controller.virtualdatabase.myDB Cannot enable > backend localho > st3 from a known state. Resynchronize this backend by restoring a dump. > 16:52:55,484 WARN controller.virtualdatabase.myDB Cannot enable > backend localho > st4 from a known state. Resynchronize this backend by restoring a dump. > 16:52:55,500 INFO controller.core.Controller Adding VirtualDatabase myDB > 16:52:55,500 INFO controller.core.Controller Loading backend > interceptor classe > s > 16:52:55,500 INFO controller.core.Controller Loading frontend > interceptor class > es > 16:52:55,500 INFO controller.core.Controller Interceptors initialized > 16:52:55,500 INFO controller.core.Controller Waiting for connections > on 127.0.0 > .1:25322 > 16:52:55,500 INFO controller.core.PingResponder Ping responder started > 16:52:55,515 INFO controller.core.Controller Controller started on > 2009.04.27 1 > 8 at 04:52:55 ÏÂÎç CST > 16:52:55,515 INFO controller.core.Controller Controller > 127.0.0.1:25322 ready, > listening to requests ... > my configuration is: > <DatabaseBackend name="localhost3" driver="org.gjt.mm.mysql.Driver" > url="jdbc:mysql://192.168.1.10/coas" connectionTestStatement="call now()"> > <ConnectionManager vLogin="user" rLogin="root" rPassword="root"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > <DatabaseBackend name="localhost4" driver="org.gjt.mm.mysql.Driver" > url="jdbc:mysql://192.168.1.25/coas" connectionTestStatement="call now()"> > <ConnectionManager vLogin="user" rLogin="root" rPassword="root"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > when I use junit,the eclipse console prints: > org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: null.... > while the cmd append the message: > 16:57:00,187 WARN sequoia.controller.cache Unable to remove pending > query user, > select * from t_theme_sys > 16:57:00,203 WARN controller.RequestManager.myDB An error occured > while executi > ng remote select request 1 > org.continuent.sequoia.common.exceptions.NoMoreBackendException > at org.continuent.sequoia.controller.requestmanager.distributed.RAIDb1Di > stributedRequestManager.execRemoteStatementExecuteQuery(RAIDb1DistributedRequest > Manager.java:170) > at org.continuent.sequoia.controller.requestmanager.distributed.Distribu > tedRequestManager.statementExecuteQuery(DistributedRequestManager.java:1371) > at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.sta > tementExecuteQuery(VirtualDatabase.java:592) > at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork > erThread.statementExecuteQuery(VirtualDatabaseWorkerThread.java:2217) > at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork > erThread.run(VirtualDatabaseWorkerThread.java:451) > 16:57:00,203 INFO virtualdatabase.VirtualDatabaseWorkerThread.myDB > Error during > command execution (null) > Thank you for your help! > > > > ------------------------------------------------------------------------ > ÍøÒ×ÓÊÏ䣬ÖйúµÚÒ»´óµç×ÓÓʼþ·þÎñÉÌ <http://email.163.com> > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoia mailing list > Se...@li... > http://forge.continuent.org/mailman/listinfo/sequoia -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Emmanuel C. <ma...@fr...> - 2009-04-27 13:02:39
|
Hi Robert, It looks like you only uploaded the Sequoia 2.10.10 doc on SourceForge but not the actual distribution. As it seems that there is no more download option from the Continuent web site, no one can download Sequoia anymore. I can rebuild new packages but it would probably be better if you had a copy of the original ones. Any plans on releasing a 2.10.11 version? Cheers manu -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Robert H. <rob...@co...> - 2009-04-25 16:41:22
|
Hi Manu, Great idea! I was just about to do suggest moving this along with several other continuent lists. There is a new mailing list on SourceForge.net with the following address: seq...@li... I have tested the list and it works. Also, it does not have the DNS reverse look-up issue that continuent.org now suffers from after moving to Amazon. Also, there is a similar list named seq...@li... that will receive CVS commit notifications. I still need to do the final setup so that it actually gets email. If you have time to do that we should be all set. This message is cross-posted to both lists. Cheers, Robert On 4/25/09 6:51 AM PDT, "Emmanuel Cecchet" <ma...@fr...> wrote: Hi Robert, Do we still have problems with the mailing list on continuent.org and should we migrate to the mailing lists on sf.net? If this is the case, we can start to crosspost in both lists. Cheers, manu -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list Se...@li... http://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: rob...@co... Mobile: +1-510-501-3728 Skype: hodgesrm |
|
From: Robert H. <rob...@co...> - 2009-04-25 16:37:09
|
This is an initial test message for seq...@li.... -- Robert Hodges, CTO, Continuent, Inc. Email: rob...@co... Mobile: +1-510-501-3728 Skype: hodgesrm |
