The bug was what Stephane said. I downgraded the driver to 5.1.6 and it worked fine. Thanks Stephane....
-Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: Tuesday, November 25, 2008 11:32 AM To: Sequoia general mailing list Subject: Re: [Sequoia] RE: Auto Generated Keys w/ MySQL 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 _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
