{"action":"closed","issue":{"url":"https://api.github.com/repos/ukwa/w3act/issues/350","labels_url":"https://api.github.com/repos/ukwa/w3act/issues/350/labels{/name}","comments_url":"https://api.github.com/repos/ukwa/w3act/issues/350/comments","events_url":"https://api.github.com/repos/ukwa/w3act/issues/350/events","html_url":"https://github.com/ukwa/w3act/issues/350","id":81476536,"number":350,"title":"Errors noticed in live logs of 1.0.3 release","user":{"login":"anjackson","id":87843,"avatar_url":"https://avatars.githubusercontent.com/u/87843?v=3","gravatar_id":"","url":"https://api.github.com/users/anjackson","html_url":"https://github.com/anjackson","followers_url":"https://api.github.com/users/anjackson/followers","following_url":"https://api.github.com/users/anjackson/following{/other_user}","gists_url":"https://api.github.com/users/anjackson/gists{/gist_id}","starred_url":"https://api.github.com/users/anjackson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anjackson/subscriptions","organizations_url":"https://api.github.com/users/anjackson/orgs","repos_url":"https://api.github.com/users/anjackson/repos","events_url":"https://api.github.com/users/anjackson/events{/privacy}","received_events_url":"https://api.github.com/users/anjackson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ukwa/w3act/labels/3%20-%20Done","name":"3 - Done","color":"CCCCCC"},{"url":"https://api.github.com/repos/ukwa/w3act/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"anjackson","id":87843,"avatar_url":"https://avatars.githubusercontent.com/u/87843?v=3","gravatar_id":"","url":"https://api.github.com/users/anjackson","html_url":"https://github.com/anjackson","followers_url":"https://api.github.com/users/anjackson/followers","following_url":"https://api.github.com/users/anjackson/following{/other_user}","gists_url":"https://api.github.com/users/anjackson/gists{/gist_id}","starred_url":"https://api.github.com/users/anjackson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anjackson/subscriptions","organizations_url":"https://api.github.com/users/anjackson/orgs","repos_url":"https://api.github.com/users/anjackson/repos","events_url":"https://api.github.com/users/anjackson/events{/privacy}","received_events_url":"https://api.github.com/users/anjackson/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ukwa/w3act/milestones/10","html_url":"https://github.com/ukwa/w3act/milestones/1.0.4%20W3ACT%20Bugfix%20Deployment","labels_url":"https://api.github.com/repos/ukwa/w3act/milestones/10/labels","id":1115530,"number":10,"title":"1.0.4 W3ACT Bugfix Deployment","description":"","creator":{"login":"anjackson","id":87843,"avatar_url":"https://avatars.githubusercontent.com/u/87843?v=3","gravatar_id":"","url":"https://api.github.com/users/anjackson","html_url":"https://github.com/anjackson","followers_url":"https://api.github.com/users/anjackson/followers","following_url":"https://api.github.com/users/anjackson/following{/other_user}","gists_url":"https://api.github.com/users/anjackson/gists{/gist_id}","starred_url":"https://api.github.com/users/anjackson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anjackson/subscriptions","organizations_url":"https://api.github.com/users/anjackson/orgs","repos_url":"https://api.github.com/users/anjackson/repos","events_url":"https://api.github.com/users/anjackson/events{/privacy}","received_events_url":"https://api.github.com/users/anjackson/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2015-05-18T11:50:10Z","updated_at":"2015-05-27T16:26:08Z","due_on":"2015-05-31T23:00:00Z","closed_at":null},"comments":0,"created_at":"2015-05-27T14:43:38Z","updated_at":"2015-05-27T16:26:08Z","closed_at":"2015-05-27T16:26:08Z","body":"First, column misconfiguration, it seems:\r\n\r\n```\r\nCaused by: javax.persistence.PersistenceException: java.util.concurrent.ExecutionException: javax.persistence.PersistenceException: Query threw SQLException:ERROR: column t0.log does not exist\r\n  Position: 295 ^M\r\nBind values:[18656] ^M\r\nQuery was:^M\r\nselect t0.id as c0, t0.url as c1, t0.created_at as c2, t0.title as c3, t0.language as c4, t0.revision as c5, t0.edit_url as c6, t0.notes as c7, t0.format as c8, t0.qa_issue_category as c9, t0.qa_notes as c10, t0.field_timestamp as c11, t0.value as c12, t0.summary as c13, t0.field_date as c14, t0.log as c15, t0.updated_at as c16, t2.ttype as c17, t0.qaissue_id as c18, t0.author_id as c19, t1.id as c20, t1.url as c21, t1.created_at as c22, t1.title as c23, t1.language as c24, t1.revision as c25, t1.edit_url as c26, t1.notes as c27, t1.format as c28, t1.originating_organisation as c29, t1.description as c30, t1.is_in_scope_ip as c31, t1.is_in_scope_ip_without_license as c32, t1.active as c33, t1.flag_notes as c34, t1.value as c35, t1.summary as c36, t1.special_dispensation as c37, t1.special_dispensation_reason as c38, t1.is_uk_hosting as c39, t1.is_top_level_domain as c40, t1.is_uk_registration as c41, t1.live_site_status as c42, t1.key_site as c43, t1.wct_id as c44, t1.spt_id as c45, t1.keywords as c46, t1.synonyms as c47, t1.authors as c48, t1.date_of_publication as c49, t1.justification as c50, t1.selection_type as c51, t1.selector_notes as c52, t1.archivist_notes as c53, t1.legacy_site_id as c54, t1.uk_postal_address as c55, t1.uk_postal_address_url as c56, t1.via_correspondence as c57, t1.professional_judgement as c58, t1.professional_judgement_exp as c59, t1.no_ld_criteria_met as c60, t1.scope as c61, t1.depth as c62, t1.ignore_robots_txt as c63, t1.crawl_frequency as c64, t1.crawl_start_date as c65, t1.crawl_end_date as c66, t1.white_list as c67, t1.black_list as c68, t1.license_status as c69, t1.updated_at as c70, t3.ttype as c71, t1.qaissue_id as c72, t1.author_id as c73, t1.organisation_id as c74 from instance t0 left outer join taxonomy t2 on t2.id = t0.qaissue_id and t2.ttype = 'quality_issues'  left outer join target t1 on t1.id = t0.target_id  left outer join taxonomy t3 on t3.id = t1.qaissue_id and t3.ttype = 'quality_issues'  where t0.target_id = ?  order by t0.created_at desc\r\nlimit 11 ^M\r\n^M\r\n\r\n        at com.avaje.ebeaninternal.server.query.LimitOffsetPage.getList(LimitOffsetPage.java:64) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.query.LimitOffsetPage.getDisplayXtoYofZ(LimitOffsetPage.java:100) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at views.html.instances.listByTarget$.pagination$1(listByTarget.template.scala:67) ~[w3act.w3act-1.0.jar:1.0]\r\n        at views.html.instances.listByTarget$.apply(listByTarget.template.scala:141) ~[w3act.w3act-1.0.jar:1.0]\r\n        at views.html.instances.listByTarget$.render(listByTarget.template.scala:196) ~[w3act.w3act-1.0.jar:1.0]\r\n        at views.html.instances.listByTarget.render(listByTarget.template.scala) ~[w3act.w3act-1.0.jar:1.0]\r\n```\r\n\r\nSecond, a loop:\r\n\r\n```\r\n    ...aje.ebean.common.BeanList[0]->models.User[\"role\"]->models.Role[\"users\"]->com.avaje.ebean.common.BeanList[0]->models.User[\"role\"]->models.Role[\"users\"]->com.avaje.ebean.common.BeanList[0]->models.User[\"role\"]->models.Role[\"users\"]->com.avaje.ebean.common.BeanList[0]->models.User[\"role\"]->models.Role[\"users\"]->com.avaje.ebean.common.BeanList[0]->models.User[\"role\"]->models.Role[\"users\"]->com.avaje.ebean.common.BeanList[0]->models...\r\n        at play.libs.Json.toJson(Json.java:32) ~[com.typesafe.play.play-json_2.10-2.2.1.jar:2.2.1]\r\n        at controllers.UserController.filterByJson(UserController.java:117) ~[w3act.w3act-1.0.jar:1.0]\r\n```\r\n\r\nThirds, a complication (as reported in #334):\r\n\r\n```\r\n! @6m9oi1ck0 - Internal server error, for (POST) [/act/ukwa/licenses/submit] ->\r\n\r\nplay.api.Application$$anon$1: Execution exception[[ActException: javax.persistence.PersistenceException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"pk_license_target\"\r\n  Detail: Key (target_id, license_id)=(2993, 295) already exists.]]\r\n        at play.api.Application$class.handleError(Application.scala:293) ~[com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]\r\n        at play.api.DefaultApplication.handleError(Application.scala:399) [com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]\r\n        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]\r\n        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]\r\n        at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.2.jar:na]\r\n        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]\r\nCaused by: uk.bl.exception.ActException: javax.persistence.PersistenceException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"pk_license_target\"\r\n  Detail: Key (target_id, license_id)=(2993, 295) already exists.\r\n        at controllers.LicenseController.submit(LicenseController.java:363) ~[w3act.w3act-1.0.jar:1.0]\r\n        at Routes$$anonfun$routes$1$$anonfun$applyOrElse$8$$anonfun$apply$8.apply(routes_routing.scala:1173) ~[w3act.w3act-1.0.jar:na]\r\n        at Routes$$anonfun$routes$1$$anonfun$applyOrElse$8$$anonfun$apply$8.apply(routes_routing.scala:1173) ~[w3act.w3act-1.0.jar:na]\r\n        at play.core.Router$HandlerInvoker$$anon$7$$anon$2.invocation(Router.scala:183) ~[com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]\r\n        at play.core.Router$Routes$$anon$1.invocation(Router.scala:377) ~[com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]\r\n        at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:56) ~[com.typesafe.play.play_2.10-2.2.1.jar:2.2.1]\r\nCaused by: javax.persistence.PersistenceException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"pk_license_target\"\r\n  Detail: Key (target_id, license_id)=(2993, 295) already exists.\r\n        at com.avaje.ebeaninternal.server.persist.ExeUpdateSql.execute(ExeUpdateSql.java:76) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeSqlUpdate(DefaultPersistExecute.java:115) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.core.PersistRequestUpdateSql.executeNow(PersistRequestUpdateSql.java:44) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.core.PersistRequest.executeStatement(PersistRequest.java:74) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.core.PersistRequestUpdateSql.executeOrQueue(PersistRequestUpdateSql.java:49) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\n        at com.avaje.ebeaninternal.server.persist.DefaultPersister.executeSqlUpdate(DefaultPersister.java:139) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]\r\nCaused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"pk_license_target\"\r\n  Detail: Key (target_id, license_id)=(2993, 295) already exists.\r\n        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[postgresql.postgresql-9.1-901-1.jdbc4.jar:na]\r\n```\r\n\r\n"}}