RC Bug?

[Richard Valdivieso]

I had the following error in an event handler after I annotated it with @RestController annotation. Am I missing something?

@NoArgsConstructor

@RestController --> this produces an ending loop with the below error

public class SavedAccountEventHandler {


    AccountQueryRepository accountQueryRepository;
    private final Logger log = LoggerFactory.getLogger(this.getClass());

    public SavedAccountEventHandler(AccountQueryRepository accountQueryRepository) {
        this.accountQueryRepository = accountQueryRepository;
    }


    @EventHandler
    public void on(AccountCreatedEvent event) {

        AccountEntity accountEntity = new AccountEntity();
        try {
            accountEntity.setCompanyNumber(event.getCompanyNumber());
            accountEntity.setEmail(event.getEmail());
            accountEntity.setFirstName(event.getFirstName());
            accountEntity.setLastName(event.getLastName());
            accountEntity.setPhone(event.getPhone());
            accountEntity.setType(event.getType());
            accountEntity.setPassword(event.getPassword());
            accountEntity.setActive(event.getActive());
            log.info("ACCOUNT SERVICE before save using repo");
            accountQueryRepository.save(accountEntity);
            log.info("ACCOUNT SERVICE after save using repo");
        }catch (Exception ex) {
            log.info(ex.getStackTrace().toString());
        }

 }
}

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1619) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1106) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1046) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) ~[na:na]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_102]

at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_102]

at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298) ~[spring-orm-4.3.3.RELEASE.jar:4.3.3.RELEASE]

at com.sun.proxy.$Proxy139.find(Unknown Source) ~[na:na]

at org.axonframework.eventhandling.tokenstore.jpa.JpaTokenStore.loadOrCreateToken(JpaTokenStore.java:98) ~[axon-core-3.0-RC1.jar:3.0-RC1]

at org.axonframework.eventhandling.tokenstore.jpa.JpaTokenStore.fetchToken(JpaTokenStore.java:93) ~[axon-core-3.0-RC1.jar:3.0-RC1]

at org.axonframework.eventhandling.TrackingEventProcessor.ensureEventStreamOpened(TrackingEventProcessor.java:270) [axon-core-3.0-RC1.jar:3.0-RC1]

at org.axonframework.eventhandling.TrackingEventProcessor.processingLoop(TrackingEventProcessor.java:211) [axon-core-3.0-RC1.jar:3.0-RC1]

at org.axonframework.eventhandling.TrackingEventProcessor.lambda$start$3(TrackingEventProcessor.java:181) [axon-core-3.0-RC1.jar:3.0-RC1]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_102]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_102]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_102]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_102]

at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_102]

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3967) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:124) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1129) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.internal.SessionImpl.access$2600(SessionImpl.java:164) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2689) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.internal.SessionImpl.get(SessionImpl.java:1082) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1069) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

... 16 common frames omitted

Caused by: org.postgresql.util.PSQLException: ERROR: relation "account.token_entry" does not exist

  Position: 253

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) ~[postgresql-9.4-1200-jdbc41.jar:9.4]

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]

... 33 common frames omitted

[Richard Valdivieso]

Never mind this is happening because we are using flyway and we had the old schema. Now it is fine.