mysql error

[Henri Gomez <he...@gmail.com>]

Hi to all,

It's the second time I got a Mysql table garbled after an archiva shutdown :

When I restart archiva I see :

3748 [main] ERROR JPOX.RDBMS  - An exception was thrown while
adding/validating class(es) : You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '-users.`SECURITY_USERASSIGNMENT_ROLENAMES`
ADD CONSTRAINT `SECURITY_USERASSIGNME' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near
'-users.`SECURITY_USERASSIGNMENT_ROLENAMES` ADD CONSTRAINT
`SECURITY_USERASSIGNME' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:59)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:41)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:528)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
        at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:463)
        at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:388)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3123)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
        at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
        at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
        at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
        at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
        at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
        at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getUserAssignmentsForRoles(JdoTool.java:242)
        at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.getUserAssignmentsForRoles(JdoRbacManager.java:586)
        at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.getUserAssignmentsForRoles(CachedRbacManager.java:407)

What's the problem with the SQL synthax since the table was generated
by archiva ?

Regards

BTW, when did 1.1 is expected ?