I got a 500 error with just a very simple JSON user registration request, I have no idea how to fix it. Can I get any help here? Because I got the following message so I assume it is not my problem.
Backendless encountered an error while handling the request. An internal trouble ticket with ID 47C3F688-1656-360E-FF16-93D24FC3C400 has been created and we will be investigating the issue.
My request body:
POST /{my APPID}/{my REST API KEY}/users/register HTTP/1.1
Content-Type: application/json
Host: api.backendless.com
Connection: close
User-Agent: Paw/2.3.4 (Macintosh; OS X/10.16.0) GCDHTTPRequest
Content-Length: 47{“email":"timyys@gmail.com”,“password”:“abcde”}
Respond I get:
HTTP/1.1 500 Internal Server Error
Server: nginx
Date: Sun, 28 Feb 2021 02:40:51 GMT
Content-Type: text/plain; charset=UTF-8
Content-Length: 7282
Connection: close
Access-Control-Allow-Origin: *
Access-Control-Allow-Methods: POST, GET, OPTIONS, PUT, DELETE, PATCH
Strict-Transport-Security: max-age=31536000; preload
Backendless encountered an error while handling the request. An internal trouble ticket with ID 47C3F688-1656-360E-FF16-93D24FC3C400 has been created and we will be investigating the issue.
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542)
at org.hibernate.query.Query.getResultList(Query.java:165)
at com.backendless.datamodel.application.dao.RoleDao.lambda$findByName$1(RoleDao.java:37)
at com.backendless.datamodel.dao.JpaContext.executeAppSync(JpaContext.java:125)
at com.backendless.datamodel.dao.JpaContext.lambda$executeApp$0(JpaContext.java:150)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed: java.util.concurrent.ExecutionException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)
at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999)
at com.backendless.async.UncheckedCompletableFutureImpl.getUnchecked(UncheckedCompletableFutureImpl.java:158)
at com.backendless.services.users.services.UserRoles.getRole(UserRoles.java:165)
at com.backendless.services.users.services.UserRoles.getSystemRoles(UserRoles.java:98)
at com.backendless.services.users.services.UserRoles.getAllRoles(UserRoles.java:80)
at com.backendless.gamification.AbstractGamificationInterceptor.invoke(AbstractGamificationInterceptor.java:51)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
at com.backendless.old.security.authorization.AuthorizationUserManager$$EnhancerByGuice$$645535ee.resumeSession()
at com.backendless.old.security.Authorization.resumeSession(Authorization.java:120)
at com.backendless.old.security.ResumeSessionAction.call(ResumeSessionAction.java:55)
at com.backendless.old.security.OriginAction.call(OriginAction.java:48)
at com.backendless.old.security.ApplicationExistenceAndUseAction.call(ApplicationExistenceAndUseAction.java:39)
at com.backendless.old.security.ConsiderApiCallAction.call(ConsiderApiCallAction.java:29)
at com.backendless.TimeOutAction.call(TimeOutAction.java:28)
at com.backendless.old.security.SuperScalingAction.lambda$call$0(SuperScalingAction.java:26)
at com.backendless.services.billing.superscaling.SuperScalingManager.applyWithPolicies(SuperScalingManager.java:60)
at com.backendless.old.security.SuperScalingAction.call(SuperScalingAction.java:26)
at com.backendless.ApiCallLimitAction.call(ApiCallLimitAction.java:26)
at com.backendless.ApiCallAction.call(ApiCallAction.java:15)
at com.backendless.StaticHttpResponseHeadersAction.call(StaticHttpResponseHeadersAction.java:22)
at com.backendless.StackOverflowHandlerAction.call(StackOverflowHandlerAction.java:21)
at com.backendless.CloseEntityManagerAction.call(CloseEntityManagerAction.java:36)
at com.backendless.CurrentRequestsNumberAction.call(CurrentRequestsNumberAction.java:31)
at com.backendless.ContextInitAction.call(ContextInitAction.java:19)
at play.core.j.JavaAction.$anonfun$apply$8(JavaAction.scala:175)
at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:672)
at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:431)
at play.core.j.HttpExecutionContext.$anonfun$execute$1(HttpExecutionContext.scala:64)
at play.api.libs.streams.Execution$trampoline$.execute(Execution.scala:70)
at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:59)
at scala.concurrent.impl.Promise$Transformation.submitWithValue(Promise.scala:393)
at scala.concurrent.impl.Promise$DefaultPromise.submitWithValue(Promise.scala:302)
at scala.concurrent.impl.Promise$DefaultPromise.dispatchOrAddCallbacks(Promise.scala:276)
at scala.concurrent.impl.Promise$DefaultPromise.map(Promise.scala:146)
at scala.concurrent.Future$.apply(Future.scala:672)
at play.core.j.JavaAction.apply(JavaAction.scala:176)
at play.api.mvc.Action.$anonfun$apply$4(Action.scala:82)
at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:434)
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:48)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2311)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026)
at org.hibernate.loader.Loader.doQuery(Loader.java:951)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
at org.hibernate.loader.Loader.doList(Loader.java:2857)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2701)
at org.hibernate.loader.Loader.list(Loader.java:2663)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
… 8 more
Caused by: java.sql.SQLSyntaxErrorException: Unknown database ‘B3480308-7A10-8960-FF8E-54E01930E000’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
… 22 more