search

Geend / HshHelper

Hannover University of Applied Sciences and Arts - Master Project - Security competition to make a secure filesharing website.
GNU General Public License v3.0
0 stars 1 forks source link

Exception tritt MANCHMAL auf, wenn Server gestartet wird und man auf Single Sign-On in der Oberflaeche drueckt #140

Closed eloquenza closed 5 years ago

eloquenza commented 5 years ago 
[error] application -                                                                                    [139/1116]
                                                                                                         [138/1116]
! @7a66m2mjc - Internal server error, for (GET) [/credentials] ->                                        [137/1116]
                                                                                                         [136/1116]
play.api.UnexpectedException: Unexpected exception[PersistenceException: Query threw SQLException:Column [135/1116]
_SERVICE_ID" not found; SQL statement:                                                                             
select t0.fk_user_id, t0.net_service_credential_id, t0.initialization_vector_username, t0.username_cipher_text, t0.
initialization_vector_password, t0.password_cipher_text, t0.fk_net_service_id, t0.fk_user_id from net_service_crede
ntial t0 where (t0.fk_user_id) in (? )  [42122-197] Bind values:[null] Query was:select t0.fk_user_id, t0.net_servi
ce_credential_id, t0.initialization_vector_username, t0.username_cipher_text, t0.initialization_vector_password, t0
.password_cipher_text, t0.fk_net_service_id, t0.fk_user_id from net_service_credential t0 where (t0.fk_user_id) in 
(? ) ]                                                                                                             
        at play.api.http.HttpErrorHandlerExceptions$.throwableToUsefulException(HttpErrorHandler.scala:247)        
        at play.api.http.HttpErrorHandlerExceptions.throwableToUsefulException(HttpErrorHandler.scala)             
        at play.http.DefaultHttpErrorHandler.throwableToUsefulException(DefaultHttpErrorHandler.java:204)          
        at play.http.DefaultHttpErrorHandler.onServerError(DefaultHttpErrorHandler.java:164)                       
        at play.core.j.JavaHttpErrorHandlerAdapter.$anonfun$onServerError$1(JavaHttpErrorHandlerAdapter.scala:22)  
        at play.core.j.JavaHelpers.$anonfun$invokeWithContext$1(JavaHelpers.scala:273)                             
        at play.core.j.JavaHelpers.withContext(JavaHelpers.scala:284)                                              
        at play.core.j.JavaHelpers.withContext$(JavaHelpers.scala:280)                                             
        at play.core.j.JavaHelpers$.withContext(JavaHelpers.scala:293)                                             
        at play.core.j.JavaHelpers.invokeWithContext(JavaHelpers.scala:272)                                        
Caused by: javax.persistence.PersistenceException: Query threw SQLException:Column "T0.FK_NET_SERVICE_ID" not found
; SQL statement:                                                                                                   
select t0.fk_user_id, t0.net_service_credential_id, t0.initialization_vector_username, t0.username_cipher_text, t0.
initialization_vector_password, t0.password_cipher_text, t0.fk_net_service_id, t0.fk_user_id from net_service_crede
ntial t0 where (t0.fk_user_id) in (? )  [42122-197] Bind values:[null] Query was:select t0.fk_user_id, t0.net_servi
ce_credential_id, t0.initialization_vector_username, t0.username_cipher_text, t0.initialization_vector_password, t0
.password_cipher_text, t0.fk_net_service_id, t0.fk_user_id from net_service_credential t0 where (t0.fk_user_id) in 
(? )                                                                                                               
        at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:52)                       
        at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:211)
        at io.ebeaninternal.server.query.CQueryEngine.translate(CQueryEngine.java:141)
        at io.ebeaninternal.server.query.DefaultOrmQueryEngine.translate(DefaultOrmQueryEngine.java:45)
        at io.ebeaninternal.server.core.OrmQueryRequest.translate(OrmQueryRequest.java:97)
        at io.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:700)
        at io.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:399)
        at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:156)
        at io.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:442)
        at io.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1516)
Caused by: org.h2.jdbc.JdbcSQLException: Column "T0.FK_NET_SERVICE_ID" not found; SQL statement:
select t0.fk_user_id, t0.net_service_credential_id, t0.initialization_vector_username, t0.username_cipher_text, t0.
initialization_vector_password, t0.password_cipher_text, t0.fk_net_service_id, t0.fk_user_id from net_service_crede
ntial t0 where (t0.fk_user_id) in (? )  [42122-197]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)
        at org.h2.command.dml.Select.prepare(Select.java:858)
        at org.h2.command.Parser.prepareCommand(Parser.java:283)
        at org.h2.engine.Session.prepareLocal(Session.java:611)
        at org.h2.engine.Session.prepareCommand(Session.java:549)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
Geend commented 5 years ago

Konnte das nochmal reproduziert werden?

eloquenza commented 5 years ago

Nein, konnte nicht reproduziert werden nach etlichen, stundenlangen Versuchen. Diese Fehler ist aber auch bei keinen anderem aufgetreten - daher folgende Klassifikation: PEBCAK.