Hi Eric,
See below for the full setup etc. Anything else you need?
I would need the exact error messages that appear in full_cluster.log.
Also, how are you executing the query: Statement/PreparedStatement?
execute/executeUpdate with what options?
What happens if you explicitly add a NULL value for id like in:
insert into TABLE1 (id, user_cuid, name, email, api_key, password, account,
publisher, social, deleted) values (NULL, ?, ?, etc)
Thanks for the feedback,
Emmanuel
-Eric
Sequoia Version 2.10.10
MySQL Version 5.0.68
MySQL Driver (mysql-connector-java-5.1.7-bin.jar) - 5.1.7
<START VDB CONFIG>
<VirtualDatabase name="user_management_system">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQLBackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options=""/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="blah"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user1" vPassword="blah"/>
<VirtualLogin vLogin="user2" vPassword="blah"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="SERVER"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://SERVER:3306/DB?autoReconnect=true"
connectionTestStatement="select 1">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="ums_admin">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="50" idleTimeout="30"
waitTimeout="10"/>
</ConnectionManager>
<ConnectionManager vLogin="ums_user">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5"
maxPoolSize="50" idleTimeout="30"
waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache/>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all"
enforceTableLocking="true"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://SERVER:3306/DB" login="blah"
password="blah">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
<END VDB CONFIG>
<SCHEMA>
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| user_cuid | bigint(20) | NO | | | |
| name | varchar(255) | NO | MUL | | |
| email | varchar(255) | NO | | | |
| api_key | varchar(255) | YES | | NULL | |
| password | varchar(32) | YES | | NULL | |
| account | tinyint(1) | YES | | NULL | |
| publisher | tinyint(1) | YES | | NULL | |
| social | tinyint(1) | YES | | NULL | |
| deleted | tinyint(1) | YES | | NULL | |
+-----------+--------------+------+-----+---------+----------------+
</SCHEMA>
<QUERY>
insert into TABLE1 (user_cuid, name, email, api_key, password, account,
publisher, social, deleted) values (?, ?, etc)
parameters (etc)
</QUERY>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet
Sent: Tuesday, November 25, 2008 10:49 AM
To: Sequoia general mailing list
Subject: Re: [Sequoia] RE: Auto Generated Keys w/ MySQL
Could you be more specific on what version of Sequoia you use, what
database backend and driver versions you are using, how you configured
them, what db schema you use and what query failed?
Emmanuel
Eric Faden wrote:
In addition to this the insert request that came in caused a warning
in the controller logs. It also seems that as a result of this insert
neither of the controllers can be shutdown and just hang with the "n
requests pending" in the logs. Is there a way to resolve this?
-Eric
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of
*Eric Faden
*Sent:* Tuesday, November 25, 2008 10:17 AM
*To:* Sequoia general mailing list
*Subject:* [Sequoia] Auto Generated Keys w/ MySQL
I currently have a dual controller sequoia cluster with co-located
MySQL Databases. I am getting the following error when my JDBC
connected Java program issues an insert. "Backend <XXX> does not
support auto generated keys". Does Sequoia not support auto
incrementers at all?
-Eric
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
