I ran into second issue as well: "Failed to read auto-increment from storage engine"
It is apparently a bug in MySQL from 5.1.24 on. It says in the patch queue, but the issue has still yet to be addressed as of 5.1.30. http://bugs.mysql.com/35602 http://bugs.mysql.com/35602 As it was reported in April and still isn't patched on the 5.1 mysql branch, it's probably best to just update the sample-data.xml to use non negative numbers for the tests, along with the unit tests which reference the negative ids. (One of the last comments on the bug states that negative numbers are undefined in MySQL for auto-increment columns, so it's really not appropriate to use them, even if it is sample data.) Still have yet get this working even after modifying the above. Surely this doesn't mean that no one has started any new appFuse projects on mySQL for the past 8 months except for md10024 and myself? -Ben md10024 wrote: > > > > Secondly, further down, I get this error: > > Signup: > [INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] JDBCException > Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000 > [INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] JDBCExceptio > nReporter.logExceptions(78) | Failed to read auto-increment value from s > torage engine > [INFO] ----------------------------------------------------------------- > > I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB tables > I see this in the app_user table: > -2 false false Denver US 80210 CO false > m...@raibledesigns.com.... > -1 false false Denver US 80210 CO false > matt_rai...@yahoo.com... > > I'm not sure how these got created with negative value ID's. Note, I am > able to reproduce this with the JSF archetype also. > > Any hints as to what is going on here would be much appreciated. > > Mark > -- View this message in context: http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p21782899.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net
