[JIRA] Created: (MYO-70) write from client fail BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)

Discussion:

Alessandro Gaspari (JIRA)

2008-08-05 13:32:29 UTC

Permalink

write from client fail BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)
-----------------------------------------------------------------------------------------------------------------------------------------------

Key: MYO-70
URL: https://forge.continuent.org/jira/browse/MYO-70
Project: Myosotis
Type: Bug

Components: PostgreSQL protocol
Versions: 0.6.2
Environment: CentOS 5.x - Postgresql 8.1 - JRE.5.0_15 - sequoia 2.10.10 (client, controllers, backend db have the same configuration)
Reporter: Alessandro Gaspari
Assigned to: Gilles Rayrat
Priority: Blocker
12:06:31,311 WARN controller.RequestManager.live_calciomercato SQLException while executing distributed write request write request 30 failed:
Backend live_calciomercato - BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)

java.sql.SQLException: write request 30 failed:
Backend live_calciomercato - BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)

at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:1006)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWriteRequest(RAIDb1.java:346)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteUpdateWithKeys(RAIDb1.java:272)
at org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecuteUpdateWithKeys(RequestManager.java:893)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdateWithKeys.executeScheduledRequest(DistributedStatementExecuteUpdateWithKeys.java:88)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:375)
at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Alessandro Gaspari (JIRA)

2008-08-05 14:30:29 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-70?page=comments#action_14680 ]

Alessandro Gaspari commented on MYO-70:
---------------------------------------

Remove from conf/myosotis.properties line with jdbc.driver.options = ?alwaysGetGeneratedKeys=true
and the problem is solved

Post by Alessandro Gaspari (JIRA)
write from client fail BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)
-----------------------------------------------------------------------------------------------------------------------------------------------
Key: MYO-70
URL: https://forge.continuent.org/jira/browse/MYO-70
Project: Myosotis
Type: Bug
Components: PostgreSQL protocol
Versions: 0.6.2
Environment: CentOS 5.x - Postgresql 8.1 - JRE.5.0_15 - sequoia 2.10.10 (client, controllers, backend db have the same configuration)
Reporter: Alessandro Gaspari
Assignee: Gilles Rayrat
Priority: Blocker
Backend live_calciomercato - BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)
Backend live_calciomercato - BackendWorkerThread for backend 'cm-db01-c2' with RAIDb level:1 failed (Returning autogenerated keys is not supported.)
at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:1006)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWriteRequest(RAIDb1.java:346)
at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteUpdateWithKeys(RAIDb1.java:272)
at org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecuteUpdateWithKeys(RequestManager.java:893)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdateWithKeys.executeScheduledRequest(DistributedStatementExecuteUpdateWithKeys.java:88)
at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:375)
at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)

Gilles Rayrat (JIRA)

2008-08-05 14:37:29 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-70?page=comments#action_14681 ]

Gilles Rayrat commented on MYO-70:
----------------------------------

Hi Alessandro,

Thanks a lot for the report, very complete !

Can you also give the version of the jdbc driver you used to install sequoia ?

Cheers,
Gilles.

Gilles Rayrat (JIRA)

2009-03-18 09:04:58 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-70?page=all ]

Gilles Rayrat closed MYO-70:
----------------------------

Resolution: Not an issue

alwaysGetGeneratedKeys not to be used with postgres