Error occured when access to api entityset

Hi,

When accees to api:entityset, i alway get a 500 ERROR. By using browser debug tools, i found it is all because of this api https://icgcportal.genomics.cn/api/v1/entityset?async=false.

And it seems that many ICGC pages may POST some information to this api.
Eg:https://icgcportal.genomics.cn/analysis

Response:
"Internal Server Error. There was an error processing your request, with the message of 'org.postgresql.util.PSQLException: This connection has been closed. [statement:"INSERT INTO entity_set (id, data, version) VALUES (:id, :data, :version)", located:"INSERT INTO entity_set (id, data, version) VALUES (:id, :data, :version)", rewritten:"INSERT INTO entity_set (id, data, version) VALUES (?, ?, ?)", arguments:{ positional:{}, named:{data:'{"id":"502531dd-5dba-414f-b377-8d3857c68f0d","state":"PENDING","name":"Top 75 PCAWG Liver Donors","description":"","type":"DONOR","version":2,"timestamp":1479794992653,"subtype":"TRANSIENT"}',id:502531dd-5dba-414f-b377-8d3857c68f0d,version:2}, finder:[]}]'. It has been logged (ID b95b69233dcbf324)."

https://icgcportal.genomics.cn/genesets/R-HSA-5633007

Response:
Internal Server Error. There was an error processing your request, with the message of 'org.postgresql.util.PSQLException: This connection has been closed. [statement:"INSERT INTO entity_set (id, data, version) VALUES (:id, :data, :version)", located:"INSERT INTO entity_set (id, data, version) VALUES (:id, :data, :version)", rewritten:"INSERT INTO entity_set (id, data, version) VALUES (?, ?, ?)", arguments:{ positional:{}, named:{data:'{"id":"1a0bd3fe-609e-4a63-9fd8-21292e64fa8f","state":"PENDING","name":"R-HSA-5633007","description":"","type":"GENE","version":2,"timestamp":1479794807005,"subtype":"NORMAL"}',id:1a0bd3fe-609e-4a63-9fd8-21292e64fa8f,version:2}, finder:[]}]'. It has been logged (ID 6ff716b5e01d42a5).

When i check official page: https://dcc.icgc.org/genesets/R-HSA-5633007, i get the correct response.

Response from our mirror site:

Response from official site:

I have already updated our database schema as @andricDu said in Topic “Invalid Analysis c1760c15-def7-4d06-9bdf-739f37b982a2”.

Any ideas to solve this problem?

Thanks!

Hi Felix,

There may be an issue between your portal and postgres. Could you try restarting both the portal and the database and try again?

Hi andricDu,

As you said, i rebuilt my database
using file:https://github.com/icgc-dcc/dcc-portal/blob/develop/dcc-portal-server/src/main/sql/schema.sql and restarted portal server/ postgresql server, our mirror site returned back to normal.

It looks like something was wrong with your db schema.sql file?

Thanks!

Thanks for posting back. We’ve fixed this line in our source.