Hi,
This is probably related to SEQUOIA-1132.
Please use another version of the connector/j (version 5.1.6 should work just
fine).
Beware that this could also trigger SEQUOIA-1131.
Cheers
Stephane
On 25/11/08 16:57, "Eric Faden" <[EMAIL PROTECTED]> wrote:
See below for the full setup etc. Anything else you need?
-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
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
