anhapu / SDFplay

3 stars 0 forks source link

live server: keine Tauschanfrage möglich #42

Closed ghost closed 10 years ago

ghost commented 10 years ago

Aktuell gibt es einen bug auf unserem live server. Wer sich einloggt und dann auf einen anderen User clickt um einen Tauschanfrage zu machen, der bekommt folgendes:

http://sdfw-play.f4.htw-berlin.de/trade/user/10

Oops, an error occured This exception has been logged with id 6h037ai63.

Ich kann den Server-log nicht einsehen und weiß deshalb nicht, was eigentlich das Problem ist.

PS: Lokal tritt der bug bei mir nicht auf.

stubb commented 10 years ago
[error] application - 

! @6h037ai63 - Internal server error, for (GET) [/trade/user/10] ->

play.api.Application$$anon$1: Execution exception[[PersistenceException: Query threw SQLException:ERROR: column t0.updated_time does not exist
  Position: 109 
Bind values:[1,10] 
Query was:
select t0.id as c0, t0.state as c1, t0.comment_owner as c2, t0.comment_recipient as c3, t0.init_time as c4, t0.updated_time as c5, t0.owner_id as c6, t0.recipient_id as c7 from tradetransaction t0 where (t0.owner_id = ?  and t0.recipient_id = ? )  

]]
    at play.api.Application$class.handleError(Application.scala:293) ~[com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]
    at play.api.DefaultApplication.handleError(Application.scala:399) [com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]
    at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.2.jar:na]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2.applyOrElse(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]
Caused by: javax.persistence.PersistenceException: Query threw SQLException:ERROR: column t0.updated_time does not exist
  Position: 109 
Bind values:[1,10] 
Query was:
select t0.id as c0, t0.state as c1, t0.comment_owner as c2, t0.comment_recipient as c3, t0.init_time as c4, t0.updated_time as c5, t0.owner_id as c6, t0.recipient_id as c7 from tradetransaction t0 where (t0.owner_id = ?  and t0.recipient_id = ? )  

    at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:790) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:767) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:202) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:77) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:265) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1460) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: column t0.updated_time does not exist
  Position: 109
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[postgresql.postgresql-9.1-901.jdbc4.jar:na]
stubb commented 10 years ago

SQLException:ERROR: column t0.updated_time does not exist

ist wohl der interessante Teil

ghost commented 10 years ago

Ich habe die folgende property in dem Model TradeTransaction hinzugefügt.

@UpdatedTimestamp public Timestamp updatedTime;

Daran liegt es scheinbar. Aber warum funktioniert es bei mir lokal?

stubb commented 10 years ago

play muss neugestartet werden, ich versuchs mal. Moment

Edit: Bringt nix, da muss @MagicMayer mal danach schauen.