Hello,
Me again :) sorry ...
On magento there is a search field that return me nothing even if I am
sure an item exists ...
I get this error on the sequoia side (I searched the word 'MARTINIQUE'):
The request does not use any procedures as I can read it.
[15:57:11] ERROR
[org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler] - Error
processing query: REPLACE INTO `catalogsearch_result` (SELECT '5',
`product_id`, MATCH (`data_index`) AGAINST ('MARTINIQUE' IN BOOLEAN MODE)
FROM `catalogsearch_fulltext` WHERE ((`data_index` LIKE '%MARTINIQUE%'))
AND `store_id`='1')
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: RETURN_GENERATED_KEYS is not supported for stored
procedures
at
org.continuent.sequoia.driver.Connection.statementExecuteUpdateWithKeys(Connection.java:3111)
at
org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:583)
at
org.continuent.sequoia.driver.Statement.executeUpdate(Statement.java:557)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:1123)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:459)
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.ControllerCoreException:
RETURN_GENERATED_KEYS is not supported for stored procedures
SerializableStackTrace of each cause:
org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException:
RETURN_GENERATED_KEYS is not supported for stored procedures
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.BadJDBCApiUsageException.<init>(BadJDBCApiUsageException.java:54)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteUpdateWithKeys(VirtualDatabaseWorkerThread.java:2378)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:457)
Again, according to you, is it reasonable to get magento working with a
sequoia cluster yet ?
Cheers,
--
Damien Hardy
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
http://forge.continuent.org/mailman/listinfo/sequoia
