Hello,
I have an error on sequoia when I want to display the default page of a
magento application (ebusiness application running PHP).
Here is the end of the full_cluster.log file (just after a backup ->
backend enabled) :
2009-04-17 13:23:47,272 INFO controller.recoverylog.RecoverThread
Database backend db1 is now enabled
2009-04-17 13:25:48,835 INFO controller.loadbalancer.RAIDb1 Request 5
failed (Request START TRANSACTION failed on backend db1 (Error while
building Sequoia ResultSet (ResultSet is from UPDATE. No Data.)))
2009-04-17 13:25:48,836 WARN sequoia.controller.cache Unable to remove
pending query magento,START TRANSACTION
2009-04-17 13:25:48,836 INFO
virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command
execution (Request START TRANSACTION failed on backend db1 (Error while
building Sequoia ResultSet (ResultSet is from UPDATE. No Data.)))
2009-04-17 13:25:48,898 WARN sequoia.controller.cache Table log_visitor
not found in cache schema. Flushing whole cache.
and here is the corresponding recoverylog dump :
myDB(admin) > dump recoverylog
+--------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+------------+-------------+-----------+--------------+
| log_id | vlogin | sqlsrc
| auto_conn_tran | transaction_id | request_id
| exec_status | exec_time | update_count |
+--------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+------------+-------------+-----------+--------------+
| 1 | magento | SET SQL_MODE=''
| A | 0 | 1
| S | 9 | 0 |
| 2 | magento | SET NAMES utf8
| A | 0 | 2
| S | 1 | 0 |
| 3 | magento | INSERT INTO `log_visitor` (`session_id`,
`first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES
('6a0456b4a5ee6891f57cb115fb219d6f', '2009-04-17 13:25:48', '2009-04-17
13:25:48', '0', '1')
| A | 0
| 6 | S | 14 | 1 |
| 4 | magento | INSERT INTO `log_visitor_info` (`visitor_id`,
`http_referer`, `http_user_agent`, `http_accept_charset`,
`http_accept_language`, `server_addr`, `remote_addr`) VALUES ('29', '',
'Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.0.8) Gecko/2009032711
Ubuntu/8.10 (intrepid) Firefox/3.0.8', 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
'fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3', '182601391', '1411737038') | A
| 0 | 7 | S | 52 | 1
|
+--------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+------------+-------------+-----------+--------------+
I use myosotis to interconnect magento on sequoia and it returns me errors
too :
################################################
ERROR [org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler] -
Error processing query: START TRANSACTION
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Request START TRANSACTION failed on backend db1 (Error
while building Sequoia ResultSet (ResultSet is from UPDATE. No Data.))
at
org.continuent.sequoia.driver.Connection.statementExecute(Connection.java:3034)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:484)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:461)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processQuery(MySQLProtocolHandler.java:455)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processCommand(MySQLProtocolHandler.java:230)
at
org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler.processClientPacket(MySQLProtocolHandler.java:186)
at
org.continuent.myosotis.protocol.mysql.MySQLConnectionHandler.run(MySQLConnectionHandler.java:85)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Request START TRANSACTION failed on backend db1 (Error while building
Sequoia ResultSet (ResultSet is from UPDATE. No Data.))
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
Error while building Sequoia ResultSet (ResultSet is from UPDATE. No
Data.)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
ResultSet is from UPDATE. No Data.
SerializableStackTrace of each cause:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Request START TRANSACTION failed on backend db1 (Error while building
Sequoia ResultSet (ResultSet is from UPDATE. No Data.))
at
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:505)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.executeRoundRobinRequest(RAIDb1_RR.java:208)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.execSingleBackendReadRequest(RAIDb1_RR.java:94)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:163)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:623)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1338)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(DistributedRequestManager.java:1362)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:592)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2493)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:478)
Caused-by
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
Error while building Sequoia ResultSet (ResultSet is from UPDATE. No
Data.)
at
org.continuent.sequoia.controller.backend.result.ControllerResultSet.<init>(ControllerResultSet.java:185)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(AbstractLoadBalancer.java:915)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:493)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.executeRoundRobinRequest(RAIDb1_RR.java:208)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.execSingleBackendReadRequest(RAIDb1_RR.java:94)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:163)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:623)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1338)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(DistributedRequestManager.java:1362)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:592)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2493)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:478)
Caused-by
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
ResultSet is from UPDATE. No Data.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:7287)
at
org.continuent.sequoia.controller.backend.result.ControllerResultSet.<init>(ControllerResultSet.java:147)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(AbstractLoadBalancer.java:915)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:493)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.executeRoundRobinRequest(RAIDb1_RR.java:208)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_RR.execSingleBackendReadRequest(RAIDb1_RR.java:94)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:163)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:623)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1338)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(DistributedRequestManager.java:1362)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:592)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2493)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:478)
################################################
Thank you for your help.
Cheers,
--
Damien
_______________________________________________
Sequoia mailing list
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
