[AIRAVATA-2564] Incorrect string value for default user password: starting Airavata on a fresh install fails

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Registry API
• Assignee: Unassigned
• Reporter: Marcus Christie
• Created: 20/Oct/17 18:02
• Updated: 20/Oct/17 18:08

Description

Stack trace:

[ERROR] The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594)
        at org.apache.airavata.registry.core.experiment.catalog.resources.UserResource.save(UserResource.java:174)
        at org.apache.airavata.registry.api.service.util.ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:119)
        at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:57)
        at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:149)
        at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:372)
        at org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:221)
        at org.apache.airavata.server.ServerMain.main(ServerMain.java:206)
Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2337)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2174)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2072)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1990)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1514)
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
        ... 7 common frames omitted
Caused by: org.apache.openjpa.persistence.PersistenceException: (conn:148) Incorrect string value: '\xEF\xBF\xBD3\xEF\xBF...' for column 'PASSWORD' at row 1 {prepstmnt 635001030
INSERT INTO USERS (GATEWAY_ID, USER_NAME, AIRAVATA_INTERNAL_USER_ID,
        PASSWORD)
    VALUES (?, ?, ?, ?)
[params=(String) default, (String) admin, (String) admin@default, (String) �3�*�H��f^O�^T
�5�^LM��]} [code=1366, state=22007]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)

I wonder if we can just remove the whole notion of a default user and default gateway. I doubt they make sense in the multi-tenanted Airavata.

Issue Links

• relates to: AIRAVATA-2566 Remove the default user, default gateway?