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: Gadafi A. <aei...@en...> - 2009-10-07 11:34:33
|
Hello,
I'm trying to compile the source code of sequoia
To do this, I got the version2.10.10, and I used ant
In the configuration file of ant, these lines are already added,
javac.target = 1.4
javac.source = 1.4
I got many errors {here below}
I used jdk version 1.6.0_05
Thank you in advance
Aeiman
aeiman@jarre:~/Desktop/sequoia-2.10.10-src$ ant
Buildfile: build.xml
init-compile:
[echo] Target JVM is set to: 1.4
[mkdir] Created dir: /home/aeiman/Desktop/sequoia-2.10.10-
src/build/classes
[copy] Copying 1 file to /home/aeiman/Desktop/sequoia-2.10.10-
src/build/classes/org/continuent/sequoia/common/util
[javac] Compiling 1 source file to /home/aeiman/Desktop/sequoia-2.10.10-
src/build/classes
[javac] depend attribute is not supported by the modern compiler
compile-commons:
[javac] Compiling 86 source files to /home/aeiman/Desktop/sequoia-2.10.10-
src/build/classes
[javac] depend attribute is not supported by the modern compiler
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/common/protocol/Array.java:37:
org.continuent.sequoia.common.protocol.Array is not abstract and does not
override abstract method free() in java.sql.Array
[javac] public class Array implements java.sql.Array
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/common/protocol/ByteArrayBlob.java:51:
org.continuent.sequoia.common.protocol.ByteArrayBlob is notabstract and does
not override abstract method getBinaryStream(long,long) in java.sql.Blob
[javac] public class ByteArrayBlob implements java.sql.Blob, Serializable
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/common/protocol/StringClob.java:60:
org.continuent.sequoia.common.protocol.StringClob is not abstract and does not
override abstract method getCharacterStream(long,long) in java.sql.Clob
[javac] public class StringClob implements java.sql.Clob, Serializable
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/Connection.java:83:
org.continuent.sequoia.driver.Connection is not abstract and does not override
abstract method createStruct(java.lang.String,java.lang.Object[]) in
java.sql.Connection
[javac] public class Connection implements java.sql.Connection
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/DatabaseMetaData.java:43:
org.continuent.sequoia.driver.DatabaseMetaData is not abstract and does not
override abstract method
getFunctionColumns(java.lang.String,java.lang.String,java.lang.String,java.lang.String)
in java.sql.DatabaseMetaData
[javac] public class DatabaseMetaData implements java.sql.DatabaseMetaData
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/DriverResultSet.java:116:
org.continuent.sequoia.driver.DriverResultSet is not abstract anddoes not
override abstract method updateNClob(java.lang.String,java.io.Reader) in
java.sql.ResultSet
[javac] public class DriverResultSet
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/Statement.java:62:
org.continuent.sequoia.driver.Statement is not abstract and does not override
abstract method isPoolable() in java.sql.Statement
[javac] public class Statement implements java.sql.Statement
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/Statement.java:1265: isClosed() in
org.continuent.sequoia.driver.Statement cannot implementisClosed() in
java.sql.Statement; attempting to assign weaker access privileges; was public
[javac] protected boolean isClosed()
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/common/sql/metadata/SequoiaParameterMetaData.java:43:
org.continuent.sequoia.common.sql.metadata.SequoiaParameterMetaData is not
abstract and does not override abstract method isWrapperFor(java.lang.Class)
in java.sql.Wrapper
[javac] public class SequoiaParameterMetaData
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/ResultSetMetaData.java:34:
org.continuent.sequoia.driver.ResultSetMetaData is not abstract and does not
override abstract method isWrapperFor(java.lang.Class) in java.sql.Wrapper
[javac] public class ResultSetMetaData implements
java.sql.ResultSetMetaData
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/PreparedStatement.java:77:
org.continuent.sequoia.driver.PreparedStatement is not abstract and does not
override abstract method setNClob(int,java.io.Reader) in
java.sql.PreparedStatement
[javac] public class PreparedStatement extends Statement
[javac] ^
[javac] /home/aeiman/Desktop/sequoia-2.10.10-
src/src/org/continuent/sequoia/driver/CallableStatement.java:92:
org.continuent.sequoia.driver.CallableStatement is not abstract and does not
override abstract method setNClob(java.lang.String,java.io.Reader) in
java.sql.CallableStatement
[javac] public class CallableStatement extends PreparedStatement
[javac] ^
[javac] Note: Some input files use or override a deprecated API.
[javac] Note: Recompile with -Xlint:deprecation for details.
[javac] 12 errors
BUILD FAILED
/home/aeiman/Desktop/sequoia-2.10.10-src/build.xml:175: Compile failed; see
the compiler error output for details.
|
|
From: Emmanuel C. <ma...@fr...> - 2009-09-26 15:10:19
|
Maziyar, > Dear Emmanuel > After I fully read the InstallGuide ,I installed the Sequoia 2.10.10 > on a PC with Windows XP. > I just have 3 PC and I attend to learn working with Sequoia . would > you please solve my following problems ?(I really could not find in > InstallGuide and AdminGuide) > > 1- should I exactly install Sequoia.jar file on every node > (controller and backend),I want to use graphical mode to install. > Yes you should. > > 2- Can I use one PC as backend node ,controller node and the machine > that using JavaApplication in a same time ? > Yes you can. Just be aware that if the machine crashes you will lose the controller and the database together. > > 3- would you please introduce a JavaApplication to me that I can use > it to test Sequoia ? > You can use the Sequoia console which is a java application. Look at the demo it uses the console to execute requests against Sequoia. > > I think you have not enough time To answer my low level questions,If > you do not mind introduce someone who can help me . > Post your questions to the mailing list at seq...@li..., you will get faster responses. > Sincerely ,Maziyar ! > > 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: Robert D. <rob...@bp...> - 2009-08-31 09:52:08
|
> Hi Robert, Hi, > To better understand what the benchmark is doing, could you tell > us more about the transactions that are being executed? How many > reads/writes per transaction? How many threads executing transactions > in parallel? It's a TPC-B Benchmark and was later modified by Guillaume Smet (sequoia-list) for having a read-only benchmark. There are three UPDATEs, one INSERT and one SELECT per transaction and i tried several settings of 10 or more clients doing one transaction at the same time. > About your setup, what network connectivity do you have between the > machines? 100Mbit. > What group communication configuration do you use between your > controllers? I'm using the hedera jgroup communication like in the distributed demo. > When you perform your reference run on a single Postgres, does > Postgres run in a VM as well? Does JDBCBench run in a remote VM? All the PostgreSQL-servers are running on virtualmachines on different servers and JDBCBench is running on my box. Sincerly yours, Robert |
|
From: Robert D. <rob...@bp...> - 2009-08-31 09:51:39
|
> Hi Robert, Hi, > Note that the mailing list has moved to > seq...@li... Ok, so i kept the whole Email. > To better understand what the benchmark is doing, could you tell us more > about the transactions that are being executed? How many reads/writes > per transaction? How many threads executing transactions in parallel? It's a TPC-B Benchmark and was later modified by Guillaume Smet (sequoia-list) for having a read-only benchmark. There are three UPDATEs, one INSERT and one SELECT per transaction and i tried several settings of 10 or more clients doing one transaction at the same time. > About your setup, what network connectivity do you have between the > machines? 100Mbit. > What group communication configuration do you use between your > controllers? I'm using the hedera jgroup communication like in the distributed demo. > When you perform your reference run on a single Postgres, does Postgres > run in a VM as well? Does JDBCBench run in a remote VM? All the PostgreSQL-servers are running on virtualmachines on different servers and JDBCBench is running on my box. Sincerly yours, Robert --- Original Message: > > I'm currently evaluating Sequoia as a PostgreSQL-Cluster Solution, but > > something in my configuration files seems to be wrong. JDBCBench says: > > > > Time to execute 100 transactions: 57.821 seconds. > > Max/Min memory usage: 2640936 / 489680 kb > > 0 / 100 failed to complete. > > Transaction rate: 1.729475450095986 txn/sec. > > > > And i already had to set the "number of accounts in 1 tps db" to 1000 > > it would have taken hours to init the accounts table with 100.000. > > I'm currently using 2 Controllers and 2 Backends running in VirtualBox > > Virtual Machines with 1GB of Ram on some quadcore servers. If i'm > > running JDBCBench on a single node postgresql database the result would > > be: > > > > Time to execute 1000 transactions: 9.679 seconds. > > Max/Min memory usage: 2890896 / 638312 kb > > 0 / 1000 failed to complete. > > Transaction rate: 103.31645831180907 txn/sec. > > > > When i'm doing the JDBCBench-Test on the cluster, the cpu load is mostly > > at 0.8 to 1, with about 30% idle and 20% user and 50% sys. Does someone > > has a clue what i've done wrong? > > > > > > > > Sincerly yours, > > > > Robert |
|
From: Emmanuel C. <ma...@fr...> - 2009-08-29 15:13:46
|
Hi Robert, Note that the mailing list has moved to seq...@li... To better understand what the benchmark is doing, could you tell us more about the transactions that are being executed? How many reads/writes per transaction? How many threads executing transactions in parallel? About your setup, what network connectivity do you have between the machines? What group communication configuration do you use between your controllers? When you perform your reference run on a single Postgres, does Postgres run in a VM as well? Does JDBCBench run in a remote VM? I have never used VirtualBox so I am not aware of any performance problem that could come from it, but running a group communication benchmark on this setup seems like a logical thing to do to make sure that this is not the root cause of the latency overhead on every single query. Keep us posted with your findings Emmanuel > I'm currently evaluating Sequoia as a PostgreSQL-Cluster Solution, but > something in my configuration files seems to be wrong. JDBCBench says: > > Time to execute 100 transactions: 57.821 seconds. > Max/Min memory usage: 2640936 / 489680 kb > 0 / 100 failed to complete. > Transaction rate: 1.729475450095986 txn/sec. > > And i already had to set the "number of accounts in 1 tps db" to 1000 > it would have taken hours to init the accounts table with 100.000. > I'm currently using 2 Controllers and 2 Backends running in VirtualBox > Virtual Machines with 1GB of Ram on some quadcore servers. If i'm > running JDBCBench on a single node postgresql database the result would > be: > > Time to execute 1000 transactions: 9.679 seconds. > Max/Min memory usage: 2890896 / 638312 kb > 0 / 1000 failed to complete. > Transaction rate: 103.31645831180907 txn/sec. > > When i'm doing the JDBCBench-Test on the cluster, the cpu load is mostly > at 0.8 to 1, with about 30% idle and 20% user and 50% sys. Does someone > has a clue what i've done wrong? > > > > Sincerly yours, > > Robert > > > ------------------------------------------------------------------------ > > _______________________________________________ > 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-07-22 16:33:10
|
Hi Pierre, Note that the Sequoia mailing list has moved to seq...@li.... There were known bugs in the JGroups version that shipped with 2.10.9. It might be due to a lost message by JGroups. You should at least try to upgrade JGroups or best move to Sequoia 2.10.10 (config is backward compatible with 2.10.9). Hope this helps, Emmanuel > > > On our configuration (2 controllers (2.10.9) in raidb1), all update queries hanged. We had to restart controllers to unblock database. > > I took a look on logs and I can see where controller hangs : on the 'slave controller' (the one which did not receive request directly from client) > > the last request without hang logged those lines : > 15 Oct 2008 08:15:43,094 | LEVEL3 | sequoia debug: Executing task Autocommit StatementExecuteUpdateTask 384 (delete from ...) > 15 Oct 2008 08:15:43,096 | LEVEL3 | sequoia debug: Task Autocommit StatementExecuteUpdateTask 384 (delete from ...) completed > 15 Oct 2008 08:15:43,096 | LEVEL3 | sequoia debug: Removed delete from ... from total order queue > 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: Logging request 18054 > 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: org.hsqldb.jdbc.jdbcPreparedStatement@199d8[sql=[UPDATE RECOVERY SET exec_status=?,update_count=?,exec_time=? WHERE log_id=?], parameters=[[S], [0], [4], [18054]]] > 15 Oct 2008 08:15:43,097 | LEVEL3 | sequoia debug: Write completed, remaining pending writes: 0 > > the first request with hang only logged those lines > 15 Oct 2008 08:16:43,075 | LEVEL3 | sequoia debug: Executing task Autocommit StatementExecuteUpdateTask 385 (delete from ...) > 15 Oct 2008 08:16:43,076 | LEVEL3 | sequoia debug: Removed delete from ... from total order queue > > > Is that a known bug ? Should I add it to bug tracker ? > > > Thanks in advance > > > Pierre > > The information in this e-mail is confidential. The contents may not be disclosed or used by anyone other then the addressee. Access to this e-mail by anyone else is unauthorised. > If you are not the intended recipient, please notify Airbus immediately and delete this e-mail. > Airbus cannot accept any responsibility for the accuracy or completeness of this e-mail as it has been sent over public networks. If you have any concerns over the content of this message or its Accuracy or Integrity, please contact Airbus immediately. > All outgoing e-mails from Airbus are checked using regularly updated virus scanning software but you should take whatever measures you deem to be appropriate to ensure that this message and any attachments are virus free. > > _______________________________________________ > 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-07-09 19:28:39
|
Hi Julio, Note that the Sequoia mailing list has moved to seq...@li.... I am surprised that COPY works because it should not. If you broadcast the statement "copy test from '/var/lib/pgsql/test1.txt' csv" to all Postgres instances, that means that you should have a copy of /var/lib/pgsql/test1.txt in every machine running Postgres which is unlikely to be the case. You should use a client side batch update rather than the COPY command with Sequoia. Hope this helps, Emmanuel > We run sequoia 2.10 postgresql 8.3.5 > > We are running this sql statement > > copy test from '/var/lib/pgsql/test1.txt' csv > > Affected rows: 0 > Query executed in 0 s 10 ms . > > If we run the same statement right away we got these messages > > > > java.lang.RuntimeException: Unable to clone the parsing of an unknown > request > at > org.continuent.sequoia.controller.requests.UnknownWriteRequest.cloneParsing(UnknownWriteRequest.java:182) > at > org.continuent.sequoia.controller.cache.parsing.ParsingCache.getParsingFromCacheAndParseIfMissing(ParsingCache.java:231) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:368) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteUpdate(RequestManager.java:657) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteUpdate(VirtualDatabase.java:609) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2359) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:445) > 2009-07-09 10:54:49,245 WARN > virtualdatabase.VirtualDatabaseWorkerThread.abrazo Runtime error > during command execution (Unable to clone the parsing of an unk > nown request) > > > If we wait for a minute or so the statement will run ok. > > > copy test from '/var/lib/pgsql/test1.txt' csv > > > > Affected rows: 0 > > Query executed in 0 s 10 ms . > > > Any ideas? > > Thanks in advance for ur help > Julio Leiva > DBA > ------------------------------------------------------------------------ > > _______________________________________________ > 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-07-02 15:21:39
|
Hi, The new Sequoia mailing list is at seq...@li... The RAIDb-0 code is not supported in 2.10.10. I have not worked on it for Sequoia 4 either so it is unlikely to work properly. Sorry for the inconvenience, Emmanuel > I have a configuration with one sequoia 2.10.10 controller and a single > DB - mysql. I set it in Raidb-0 configuration and am experiencing the > same problem with 3 oracle db + 1 sql db. > When i'm creating a new table, i'm having a strange error. I have to > reboot the controller to make it aware of the new table. > > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show tables > +---------------------+ > | tables | > +---------------------+ > | ParticipantActivite | > | AAA | > | Utilisateur | > | AAAB | > | Activites | > +---------------------+ > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > create table AAAC (id > integer not null, name varchar(255)) > An error occured while executing SQL query > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: Failed to execute request create table AAAC (id > integer not null, ... because of (null)) > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show > tables > +---------------------+ > | tables | > +---------------------+ > | ParticipantActivite | > | AAA | > | Utilisateur | > | AAAB | > | Activites | > +---------------------+ > > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from AAAC > Query executed in 0 s 15 ms . > > > According to my DB, the table has been created but I've got a strange > error... > Same thing when i attempt to insert values: > (After controller's reboot) > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > show > tables > +---------------------+ > | tables | > +---------------------+ > | AAAC | > | ParticipantActivite | > | AAA | > | Utilisateur | > | AAAB | > | Activites | > +---------------------+ > > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from > AAA > Query executed in 0 s 13 ms . > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > insert into AAA > values (1,"one") > An error occured while executing SQL query > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: Failed to execute request insert into AAA values > (1,"one")/ because of (null)) > jdbc:sequoia://127.0.0.2:2222/basetest (distant) > select * from > AAA > +----+------+ > | id | name | > +----+------+ > | 1 | one | > +----+------+ > > Query executed in 0 s 20 ms . > > here are my configuration files: > controller.xml > > > > SEQUOIA-CONTROLLER 2.10.10//EN" > "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.10.dtd"> > > > > > > generateOnFatal="true" enableFileLogging="true" /> > > > > > virtualDatabaseName="basetest" /> > > > > basetest.xml > > > > "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd"> > > > > > > > > > > > > > driverPath="/user/share/mysql-connector-java-5.1.7-bin.jar" > url="jdbc:mysql://localhost/test" connectionTestStatement="select 1"> > > rPassword="root"> > > > > > > > > > > > > > > > > > > > Best regards, > Nghi Huynh > > > > > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > 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-07-01 15:59:21
|
Hi, > I wanted to ask you if you know what is the best way to use sequoia > with PHP and MySQL? I've tried Myosotis and Tungsten connector, but > problem is that it does not understand MySQL-specific queries like > "INSERT INTO" with SET and not with VALUES. MySQL has some additions > that are not SQL92 compatible, and myosotis seems to reject those queries. I am not sure if these are Myosotis or Sequoia restrictions. The Sequoia parser does not parse INSERT INTO SET ... queries. For that, you would need to modify the regular expression used for insert queries. This will be tunable in Sequoia 4 but is currently hardcoded in Sequoia 2.10 and will require a re-compilation. > Also mailing lists seem to be dead on Sequoia project? The mailing list has now moved to sf.net and you can post to seq...@li.... 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: li j. <dis...@gm...> - 2009-06-06 07:53:06
|
Hi All, I'm using Sequoia 2.10.10 with derby 10.4.1.3, and have two controllers in a cluster, and each controller has four virtual databases. the problem is when I try to close one controller, then the other one will become dead lock sometimes(not always). from the recovery log, I found that the dead lock is caused by incomplete transaction, the last record in recovery log was an update statement but not "commit" record after that(has "begin" record before the update statement), is there anyone know the reason? thanks very much! Best Wishes! -- Don't schedule every day, make them disorder. |
|
From: Robert H. <rob...@co...> - 2009-06-04 17:58:38
|
Hi Manu, Sequoia has not disappeared. It looks as if some links were broken as a result of us refitting the site. That should be fixed now. Sequoia is now listed as a "Lab" project since it is not directly related to Tungsten. However, all pages are properly listed and have current information about access to the SourceForge.net site. Also, I have tweaked the sequoia-discuss mailing list so that it works better. (I will forward you the admin password under separate cover.) I think it would make sense, however, to begin using the SequoiaDB site on SourceForge.net site as much as possible for materials. So, for example, it would make sense to put things on the SequoiaDB wiki. Let me know if you are seeing broken links and I will add appropriate forwards on forge.continuent.org immediately. Unfortunately I can't see who is linking and what they are looking for. Thanks, Robert On 6/4/09 10:17 AM PDT, "Emmanuel Cecchet" <ma...@fr...> wrote: Hi Robert, It looks like the Sequoia web site has now fully disappeared from the Continuent community web site. A heads-up would have been appreciated since now all Sequoia users can't find a web page about the project (sf.net only has the download part). Is this the official disengagement of Continuent from Sequoia? Best regards, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet -- Robert Hodges, CTO, Continuent, Inc. Email: rob...@co... Mobile: +1-510-501-3728 Skype: hodgesrm |
|
From: Emmanuel C. <ma...@fr...> - 2009-06-04 17:44:05
|
Hi Robert, It looks like the Sequoia web site has now fully disappeared from the Continuent community web site. A heads-up would have been appreciated since now all Sequoia users can't find a web page about the project (sf.net only has the download part). Is this the official disengagement of Continuent from Sequoia? Best regards, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Toni M. L. <ton...@gm...> - 2009-06-03 18:02:44
|
Sorry, I have follwoing configuration : We are working with jboss-4.0.3SP1, sequoia-2.10.10 and mysql 4.1.20 in a RHEL environment ! 2009/6/3 Toni Menendez Lopez <ton...@gm...> > Hello everyone, > > I am studying the parameters that we can set in the DATASOURCE of JBoss to > access the Sequoia Driver.. > > I have following parameters : > > <?xml version="1.0" encoding="UTF-8"?> > <!--============================================================= --> > <!-- --> > <!-- JBoss Server Configuration --> > <!-- --> > <!--============================================================= --> > <!--============================================================= --> > <!-- Datasource config for Sequoia --> > ============================================================= --> > <datasources> > <local-tx-datasource> > <jndi-name>cdpdbDS</jndi-name> > > <connection-url>jdbc:sequoia://mibeas01_data,mibeas02_data/cdpdb?preferredController=mibeas02_data</connection-url> > <driver-class>org.continuent.sequoia.driver.Driver</driver-class> > <user-name>cdpdb</user-name> > <password>cdpdb</password> > <max-pool-size>150</max-pool-size> > <min-pool-size>5</min-pool-size> > <blocking-timeout-millis>8000</blocking-timeout-millis> > <set-tx-query-timeout/> > <query-timeout>60</query-timeout> <!-- maximum of 1 minutes for queries > --> > <idle-timeout-minutes>3</idle-timeout-minutes> > </local-tx-datasource> > </datasources> > But, the Conection pool is never close. > > Do you know if parameter > > <idle-timeout-minutes>3</idle-timeout-minutes> > works fine with sequoia ? > > > > Thanks, > > Toni. > |
|
From: Toni M. L. <ton...@gm...> - 2009-06-03 18:00:47
|
Hello everyone, I am studying the parameters that we can set in the DATASOURCE of JBoss to access the Sequoia Driver.. I have following parameters : <?xml version="1.0" encoding="UTF-8"?> <!--============================================================= --> <!-- --> <!-- JBoss Server Configuration --> <!-- --> <!--============================================================= --> <!--============================================================= --> <!-- Datasource config for Sequoia --> ============================================================= --> <datasources> <local-tx-datasource> <jndi-name>cdpdbDS</jndi-name> <connection-url>jdbc:sequoia://mibeas01_data,mibeas02_data/cdpdb?preferredController=mibeas02_data</connection-url> <driver-class>org.continuent.sequoia.driver.Driver</driver-class> <user-name>cdpdb</user-name> <password>cdpdb</password> <max-pool-size>150</max-pool-size> <min-pool-size>5</min-pool-size> <blocking-timeout-millis>8000</blocking-timeout-millis> <set-tx-query-timeout/> <query-timeout>60</query-timeout> <!-- maximum of 1 minutes for queries --> <idle-timeout-minutes>3</idle-timeout-minutes> </local-tx-datasource> </datasources> But, the Conection pool is never close. Do you know if parameter <idle-timeout-minutes>3</idle-timeout-minutes> works fine with sequoia ? Thanks, Toni. |
|
From: Emmanuel C. <ma...@fr...> - 2009-06-02 12:49:42
|
> Master Hello young padawan :-) > I manage to put the SQL Monitoring, and now my surprise is even great... The delays you see at MySQL can come from Sequoia or your application. > Look this a trace in MySQL : > select user0_.ID as ID19_0_, user0_.SPROLE_FK as SPROLE2_19_0_, > user0_.IAPROLE_FK as IAPROLE3_19_0_, user0_.COROLE_FK as > COROLE4_19_0_, user0_.NAME as NAME19_0_, user0_.PASSWORD as > PASSWORD19_0_, user0_.ROLETYPE as ROLETYPE19_0_, user0_.USER_FK as > USER8_19_0_, user0_.EMAIL as EMAIL19_0_, user0_.STATUS as STATUS19_0_, > user0_.TRUSTED as TRUSTED19_0_, user0_.VALIDATIONUSERID as > VALIDAT12_19_0_, user0_.CMSCO as CMSCO19_0_ from cdpdb.user user0_ > where user0_.ID=21 Jun 2, 2009 10:19:17.149134000 > Jun 2, 2009 10:19:17.149185000 > select roleiap0_.ID as ID16_0_, roleiap0_.USER_FK as USER2_16_0_, > roleiap0_.NAME as NAME16_0_ from cdpdb.roleiap roleiap0_ where > roleiap0_.ID=1 Jun 2, 2009 10:19:17.149605000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as > AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat > itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:17.149856000 > Jun 2, 2009 10:19:17.149876000 > Jun 2, 2009 10:19:17.149881000 > Jun 2, 2009 10:19:17.167730000 > Jun 2, 2009 10:19:17.187738000 > Jun 2, 2009 10:19:17.188534000 > Jun 2, 2009 10:19:17.188737000 > Jun 2, 2009 10:19:17.188743000 > Jun 2, 2009 10:19:17.189901000 > Jun 2, 2009 10:19:17.189905000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as > AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat > itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:18.030538000 > Jun 2, 2009 10:19:18.030604000 > Jun 2, 2009 10:19:18.030620000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as > AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat > itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:18.030825000 > > Which it looks that between 10:19:17.149856000 and 10:19:18.030538000 > we have a gap that no selects are executed.... ( remember that > LoadTests are beeing executed so it is impossible this), but when I > try to see the results of SQLMonitoring in Sequoia we don´t have any > "Max time (ms):" bigger that 50, so... It might well be that the problem comes from the application. Can you try to add some monitoring code in your application to output the query execution time you see in the application? Something like: start = System.currentTimeInMillis(); s.execute(...); end = System.currentTimeInMillis(); print(end-start); > So, it seems that we have any kind of problem related to transmission > or queue or I don´t no what.... > > Do you know is there is any chance to monitor traffic between > hibernate ( JBOSS) and the input of sequoia, I think that it is in > port 25322 ( controller ? ). You can turn the Sequoia driver in DEBUG mode if you append the option debugLevel=debug to the JDBC URL you give to the Sequoia driver. You can also set the VirtualDatabaseWorkerThread logger to DEBUG in log4j.properties to log all the commands issued by the driver with their timestamp. > Anyway, now I am going to check Jconsole ! Ok, keep me 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: Toni M. L. <ton...@gm...> - 2009-06-02 10:41:01
|
I configured Jconsole and it seems we don´t have any problem with Memory. After some investigation I think that we have the problem not in sequoia, we have it in JBOSS... I will tell you.... Thanks a lot for the help, Toni. 2009/6/2 Toni Menendez Lopez <ton...@gm...> > Master I manage to put the SQL Monitoring, and now my surprise is even > great... > > > Look this a trace in MySQL : > select user0_.ID as ID19_0_, user0_.SPROLE_FK as SPROLE2_19_0_, > user0_.IAPROLE_FK as IAPROLE3_19_0_, user0_.COROLE_FK as COROLE4_19_0_, > user0_.NAME as NAME19_0_, user0_.PASSWORD as PASSWORD19_0_, user0_.ROLETYPE > as ROLETYPE19_0_, user0_.USER_FK as USER8_19_0_, user0_.EMAIL as EMAIL19_0_, > user0_.STATUS as STATUS19_0_, user0_.TRUSTED as TRUSTED19_0_, > user0_.VALIDATIONUSERID as VALIDAT12_19_0_, user0_.CMSCO as CMSCO19_0_ from > cdpdb.user user0_ where user0_.ID=21 Jun 2, 2009 10:19:17.149134000 > Jun 2, 2009 10:19:17.149185000 > select roleiap0_.ID as ID16_0_, roleiap0_.USER_FK as USER2_16_0_, > roleiap0_.NAME as NAME16_0_ from cdpdb.roleiap roleiap0_ where > roleiap0_.ID=1 Jun 2, 2009 10:19:17.149605000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, > itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where > itvplat0_.ID=4 Jun 2, 2009 10:19:17.149856000 > Jun 2, 2009 10:19:17.149876000 > Jun 2, 2009 10:19:17.149881000 > Jun 2, 2009 10:19:17.167730000 > Jun 2, 2009 10:19:17.187738000 > Jun 2, 2009 10:19:17.188534000 > Jun 2, 2009 10:19:17.188737000 > Jun 2, 2009 10:19:17.188743000 > Jun 2, 2009 10:19:17.189901000 > Jun 2, 2009 10:19:17.189905000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, > itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where > itvplat0_.ID=4 Jun 2, 2009 10:19:18.030538000 > Jun 2, 2009 10:19:18.030604000 > Jun 2, 2009 10:19:18.030620000 > select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, > itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, > itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where > itvplat0_.ID=4 Jun 2, 2009 10:19:18.030825000 > > Which it looks that between 10:19:17.149856000 and 10:19:18.030538000 we > have a gap that no selects are executed.... ( remember that LoadTests are > beeing executed so it is impossible this), but when I try to see the results > of SQLMonitoring in Sequoia we don´t have any "Max time (ms):" bigger that > 50, so... > > So, it seems that we have any kind of problem related to transmission or > queue or I don´t no what.... > > Do you know is there is any chance to monitor traffic between hibernate ( > JBOSS) and the input of sequoia, I think that it is in port 25322 ( > controller ? ). > > Anyway, now I am going to check Jconsole ! > > Toni. > > > > > 2009/6/2 Emmanuel Cecchet <ma...@fr...> > > Toni, >> >> The thing is that the problem only ocurrs from time to time, and when >>> high load is sent, >>> >>> Is there any way to tune sequoia? Or monitor sequoia when high load is >>> sent ? >>> >>> -which are good jvm parameters?any way to monitor jvm ? >>> >>> >> I would recommend to use jconsole ( >> http://java.sun.com/developer/technicalArticles/J2SE/jconsole.html) that >> is shipped since J2SE 5 to monitor your JVM and find out if you have any >> memory problems. >> >>> -how request caché works? >>> >>> >> Sequoia has 3 caches as described in sequoia.dtd: >> " MetadataCache: this cache improves the ResultSet creation time by >> keeping >> the various field information with their metadata. It is strongly >> encouraged >> to use this cache that reduces both cpu and memory usage. >> ParsingCache: allows to parse a request only once for all its executions. >> This reduces the cpu load on the controller. >> ResultCache: this cache keeps the results associated to a given request. >> Cache entries can be invalidated according to various policies. This >> cache >> reduces the load on the database backends." >> >> I would not recommend to use the result cache if you have memory problems. >> >> >>> -for last,how many queries per second can we achice ? >>> >>> The thing is our application works quite bad with high load, and we >>> have to improve the Database access. >>> >>> >> For reads, there is no real limit for queries per second as long as you >> have enough concurrent queries and enough resources to execute them. >> Everything depends on your system setup and your workload. >> >> Hope this helps, >> >> Emmanuel >> >> -- >> Emmanuel Cecchet >> FTO @ Frog Thinker Open Source Development & Consulting >> -- >> Web: http://www.frogthinker.org >> email: ma...@fr... >> Skype: emmanuel_cecchet >> >> > |
|
From: Toni M. L. <ton...@gm...> - 2009-06-02 08:50:43
|
Master I manage to put the SQL Monitoring, and now my surprise is even great... Look this a trace in MySQL : select user0_.ID as ID19_0_, user0_.SPROLE_FK as SPROLE2_19_0_, user0_.IAPROLE_FK as IAPROLE3_19_0_, user0_.COROLE_FK as COROLE4_19_0_, user0_.NAME as NAME19_0_, user0_.PASSWORD as PASSWORD19_0_, user0_.ROLETYPE as ROLETYPE19_0_, user0_.USER_FK as USER8_19_0_, user0_.EMAIL as EMAIL19_0_, user0_.STATUS as STATUS19_0_, user0_.TRUSTED as TRUSTED19_0_, user0_.VALIDATIONUSERID as VALIDAT12_19_0_, user0_.CMSCO as CMSCO19_0_ from cdpdb.user user0_ where user0_.ID=21 Jun 2, 2009 10:19:17.149134000 Jun 2, 2009 10:19:17.149185000 select roleiap0_.ID as ID16_0_, roleiap0_.USER_FK as USER2_16_0_, roleiap0_.NAME as NAME16_0_ from cdpdb.roleiap roleiap0_ where roleiap0_.ID=1 Jun 2, 2009 10:19:17.149605000 select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:17.149856000 Jun 2, 2009 10:19:17.149876000 Jun 2, 2009 10:19:17.149881000 Jun 2, 2009 10:19:17.167730000 Jun 2, 2009 10:19:17.187738000 Jun 2, 2009 10:19:17.188534000 Jun 2, 2009 10:19:17.188737000 Jun 2, 2009 10:19:17.188743000 Jun 2, 2009 10:19:17.189901000 Jun 2, 2009 10:19:17.189905000 select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:18.030538000 Jun 2, 2009 10:19:18.030604000 Jun 2, 2009 10:19:18.030620000 select itvplat0_.ID as ID9_0_, itvplat0_.NAME as NAME9_0_, itvplat0_.BROADCAST as BROADCAST9_0_, itvplat0_.AUTHCLASS as AUTHCLASS9_0_, itvplat0_.PUBLISHER as PUBLISHER9_0_ from cdpdb.itvplat itvplat0_ where itvplat0_.ID=4 Jun 2, 2009 10:19:18.030825000 Which it looks that between 10:19:17.149856000 and 10:19:18.030538000 we have a gap that no selects are executed.... ( remember that LoadTests are beeing executed so it is impossible this), but when I try to see the results of SQLMonitoring in Sequoia we don´t have any "Max time (ms):" bigger that 50, so... So, it seems that we have any kind of problem related to transmission or queue or I don´t no what.... Do you know is there is any chance to monitor traffic between hibernate ( JBOSS) and the input of sequoia, I think that it is in port 25322 ( controller ? ). Anyway, now I am going to check Jconsole ! Toni. 2009/6/2 Emmanuel Cecchet <ma...@fr...> > Toni, > > The thing is that the problem only ocurrs from time to time, and when >> high load is sent, >> >> Is there any way to tune sequoia? Or monitor sequoia when high load is >> sent ? >> >> -which are good jvm parameters?any way to monitor jvm ? >> >> > I would recommend to use jconsole ( > http://java.sun.com/developer/technicalArticles/J2SE/jconsole.html) that > is shipped since J2SE 5 to monitor your JVM and find out if you have any > memory problems. > >> -how request caché works? >> >> > Sequoia has 3 caches as described in sequoia.dtd: > " MetadataCache: this cache improves the ResultSet creation time by > keeping > the various field information with their metadata. It is strongly > encouraged > to use this cache that reduces both cpu and memory usage. > ParsingCache: allows to parse a request only once for all its executions. > This reduces the cpu load on the controller. > ResultCache: this cache keeps the results associated to a given request. > Cache entries can be invalidated according to various policies. This cache > reduces the load on the database backends." > > I would not recommend to use the result cache if you have memory problems. > >> -for last,how many queries per second can we achice ? >> >> The thing is our application works quite bad with high load, and we >> have to improve the Database access. >> >> > For reads, there is no real limit for queries per second as long as you > have enough concurrent queries and enough resources to execute them. > Everything depends on your system setup and your workload. > > Hope this helps, > > 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-06-01 22:03:06
|
Toni, > The thing is that the problem only ocurrs from time to time, and when > high load is sent, > > Is there any way to tune sequoia? Or monitor sequoia when high load is sent ? > > -which are good jvm parameters?any way to monitor jvm ? > I would recommend to use jconsole (http://java.sun.com/developer/technicalArticles/J2SE/jconsole.html) that is shipped since J2SE 5 to monitor your JVM and find out if you have any memory problems. > -how request caché works? > Sequoia has 3 caches as described in sequoia.dtd: " MetadataCache: this cache improves the ResultSet creation time by keeping the various field information with their metadata. It is strongly encouraged to use this cache that reduces both cpu and memory usage. ParsingCache: allows to parse a request only once for all its executions. This reduces the cpu load on the controller. ResultCache: this cache keeps the results associated to a given request. Cache entries can be invalidated according to various policies. This cache reduces the load on the database backends." I would not recommend to use the result cache if you have memory problems. > -for last,how many queries per second can we achice ? > > The thing is our application works quite bad with high load, and we > have to improve the Database access. > For reads, there is no real limit for queries per second as long as you have enough concurrent queries and enough resources to execute them. Everything depends on your system setup and your workload. Hope this helps, 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-06-01 19:36:27
|
Hi, > 1, The Sequoia-2.10.10-src won't compile on JDK1.6 and 1.5. > Some one already printed out the error message on this list. > Sequoia compiles with JDK 1.5 without any problem. With 1.6 you have to make sure that you are not using the JDBC 4 APIs and therefore need to set the target code to 1.4. > 2, The Sequoia-2.10.10-bin has problem when I quit it. It seems some > problems of .java.preference file problem or thread problem. I have > seen some one posted the error message. > I have heard of something similar with JDK 1.6 and the XML parser. I have been working for a fix for Sequoia 4 but I don't think there will be any fix for Sequoia 2.10. You might just have to downgrade your JDK to 1.5. > 3, The Sequoia bin has problem with PostgreSQLPlainTextBackuper. When > I issue command backup localhost1 init_dump pgdump > /var/sequoia/backup. It reports the backup execution did not > accomplish successfully. But when I go to there and have a look. The > init_dump.sql file already there. And I believe it will work. The > thing is that when I show dumps, no dumps found. I cannot transfer > dump to other controller. > I guess this problem is the same as the second problem which is the > thread problem. > If there is an explicit error, it will show if you full_cluster.log file with an accurate description of the problem. If you want more details, you can set the backup logger to DEBUG in your log4j.properties configuration file and you will get more debug output on what the problem is. I can't really help without specific error messages. 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: Toni M. L. <ton...@gm...> - 2009-05-30 22:21:29
|
Emmanuel, The thing is that the problem only ocurrs from time to time, and when high load is sent, Is there any way to tune sequoia? Or monitor sequoia when high load is sent ? -which are good jvm parameters?any way to monitor jvm ? -how request caché works? -for last,how many queries per second can we achice ? The thing is our application works quite bad with high load, and we have to improve the Database access. Thanks again one more time.. Toni 2009/5/30, Emmanuel Cecchet <ma...@fr...>: > Toni, >> I get what has happenned... >> >> The thing is that I am doing only SELECT commands, nor transactional >> comands, and SELECT commands are not saved in recovery log. >> >> Do you know how can I know the time spent in this SELECT commands... >> >> It seems that some commands get stuck a take more that 2 segs to >> answer, when we are doing LoadTests.... > You can profile SELECT statement execution time using the SQLMonitoring > option in your virtual database config file (see sequoia.dtd for > details). You can dump query execution time from the Sequoia console. > Some possible causes for slow SELECTs are: > - large tuples and inappropriate JVM memory settings requiring a lot of > garbage collecting, > - SELECT statement broadcast if the SQL has side effects that must be > performed on every backend, > - inappropriate request cache configuration, > - missing metadata cache, > - backend failure during select, > - request invoking a stored procedure that forces a schema refresh. > > Keep us posted with your findings, > Emmanuel > > -- > 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 > |
|
From: Emmanuel C. <ma...@fr...> - 2009-05-29 22:49:12
|
Toni, > I get what has happenned... > > The thing is that I am doing only SELECT commands, nor transactional > comands, and SELECT commands are not saved in recovery log. > > Do you know how can I know the time spent in this SELECT commands... > > It seems that some commands get stuck a take more that 2 segs to > answer, when we are doing LoadTests.... You can profile SELECT statement execution time using the SQLMonitoring option in your virtual database config file (see sequoia.dtd for details). You can dump query execution time from the Sequoia console. Some possible causes for slow SELECTs are: - large tuples and inappropriate JVM memory settings requiring a lot of garbage collecting, - SELECT statement broadcast if the SQL has side effects that must be performed on every backend, - inappropriate request cache configuration, - missing metadata cache, - backend failure during select, - request invoking a stored procedure that forces a schema refresh. Keep us posted with your findings, Emmanuel -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
|
From: Toni M. L. <ton...@gm...> - 2009-05-29 21:28:28
|
Emmanuel, I get what has happenned... The thing is that I am doing only SELECT commands, nor transactional comands, and SELECT commands are not saved in recovery log. Do you know how can I know the time spent in this SELECT commands... It seems that some commands get stuck a take more that 2 segs to answer, when we are doing LoadTests.... Toni. 2009/5/29, Toni Menendez Lopez <ton...@gm...>: > > No way master, > > localhost:1090 > admin cdpdb > Virtual database Administrator Login > admin > Virtual database Administrator Password > > Ready to administrate virtual database cdpdb > cdpdb(admin) > debug on > Debug mode on > > Now I execute some commands !!!! > > cdpdb(admin) > dump recoverylog > Recovery Log is empty > > > 2009/5/29, Emmanuel Cecchet <ma...@fr...>: >> >> Toni, >> >> When you start the Sequoia admin console, use 'admin myvdb' with your >> login and password and then use 'debug on'. You will be able to use the >> 'dump recoverylog' command of the console. >> >> Let me know if you can't get it working. >> Emmanuel >> >> > >> > Where I have to setup the DEBUG ? >> > >> > Now I have the table empty : >> > >> > mysql> select * from cdpdb_logtable; >> > Empty set (0.00 sec) >> > >> > >> > 2009/5/29, Emmanuel Cecchet <ma...@fr... >> > <mailto:ma...@fr...>>: >> > >> > Toni, >> > > I am not able to get the recovery logs, I have done this in the >> > > log4j.properties : >> > The recovery log is stored in a database that you configure in your >> > virtual database configuration file. You can directly look at the >> > content of the table by connecting to the database or use the >> Sequoia >> > admin console using the 'dump recoverylog' command (note that you >> have >> > to set the debug mode to on first). >> > >> > Hope this helps, >> > Emmanuel >> > >> >> >> -- >> 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 >> > > |
|
From: fulan P. <ful...@gm...> - 2009-05-29 21:23:04
|
1, The Sequoia-2.10.10-src won't compile on JDK1.6 and 1.5. Some one already printed out the error message on this list. 2, The Sequoia-2.10.10-bin has problem when I quit it. It seems some problems of .java.preference file problem or thread problem. I have seen some one posted the error message. 3, The Sequoia bin has problem with PostgreSQLPlainTextBackuper. When I issue command backup localhost1 init_dump pgdump /var/sequoia/backup. It reports the backup execution did not accomplish successfully. But when I go to there and have a look. The init_dump.sql file already there. And I believe it will work. The thing is that when I show dumps, no dumps found. I cannot transfer dump to other controller. I guess this problem is the same as the second problem which is the thread problem. I have 5 hours a day to work on these issues if some one give me some direction. I usually do hard-coding and dirty fix if no one help me. I would make this software work. Thanks! |
|
From: Toni M. L. <ton...@gm...> - 2009-05-29 16:44:35
|
No way master, localhost:1090 > admin cdpdb Virtual database Administrator Login > admin Virtual database Administrator Password > Ready to administrate virtual database cdpdb cdpdb(admin) > debug on Debug mode on Now I execute some commands !!!! cdpdb(admin) > dump recoverylog Recovery Log is empty 2009/5/29, Emmanuel Cecchet <ma...@fr...>: > > Toni, > > When you start the Sequoia admin console, use 'admin myvdb' with your > login and password and then use 'debug on'. You will be able to use the > 'dump recoverylog' command of the console. > > Let me know if you can't get it working. > Emmanuel > > > > > Where I have to setup the DEBUG ? > > > > Now I have the table empty : > > > > mysql> select * from cdpdb_logtable; > > Empty set (0.00 sec) > > > > > > 2009/5/29, Emmanuel Cecchet <ma...@fr... > > <mailto:ma...@fr...>>: > > > > Toni, > > > I am not able to get the recovery logs, I have done this in the > > > log4j.properties : > > The recovery log is stored in a database that you configure in your > > virtual database configuration file. You can directly look at the > > content of the table by connecting to the database or use the Sequoia > > admin console using the 'dump recoverylog' command (note that you > have > > to set the debug mode to on first). > > > > Hope this helps, > > Emmanuel > > > > > -- > 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 > |
|
From: Emmanuel C. <ma...@fr...> - 2009-05-29 16:38:50
|
Toni, When you start the Sequoia admin console, use 'admin myvdb' with your login and password and then use 'debug on'. You will be able to use the 'dump recoverylog' command of the console. Let me know if you can't get it working. Emmanuel > > Where I have to setup the DEBUG ? > > Now I have the table empty : > > mysql> select * from cdpdb_logtable; > Empty set (0.00 sec) > > > 2009/5/29, Emmanuel Cecchet <ma...@fr... > <mailto:ma...@fr...>>: > > Toni, > > I am not able to get the recovery logs, I have done this in the > > log4j.properties : > The recovery log is stored in a database that you configure in your > virtual database configuration file. You can directly look at the > content of the table by connecting to the database or use the Sequoia > admin console using the 'dump recoverylog' command (note that you have > to set the debug mode to on first). > > Hope this helps, > Emmanuel > -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: ma...@fr... Skype: emmanuel_cecchet |
