Details
Major Description
This issue was reported by Robert Lodahl from the University Medical Center Gottingen.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used.
Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists.
The ERROR message that appears is:
"Caused by: org.postgresql.util.PSQLException: ERROR: relation "temp_fact_param_table" does not exist“
The exception can be traced back to the part of the code:
edu.harvard.i2b2.crc.dao.pdo.PdoQueryConceptDao.getConceptByFact(PdoQueryConceptDao.java:346)
The section of code that appears to be causing the problem can be seen in the attached document.
ATTACHMENTS:
EMAIL_Parallel_Queries_Error.pdf = original email from Robert.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used.
Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists.
The ERROR message that appears is:
"Caused by: org.postgresql.util.PSQLException: ERROR: relation "temp_fact_param_table" does not exist“
The exception can be traced back to the part of the code:
edu.harvard.i2b2.crc.dao.pdo.PdoQueryConceptDao.getConceptByFact(PdoQueryConceptDao.java:346)
The section of code that appears to be causing the problem can be seen in the attached document.
ATTACHMENTS:
EMAIL_Parallel_Queries_Error.pdf = original email from Robert.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
This issue was reported by Robert Lodahl from the University Medical Center Gottingen.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used. Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists. |
This issue was reported by Robert Lodahl from the University Medical Center Gottingen.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used. Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists. The ERROR message that appears is: "Caused by: org.postgresql.util.PSQLException: ERROR: relation "temp_fact_param_table" does not exist“ The exception can be traced back to the part of the code: edu.harvard.i2b2.crc.dao.pdo.PdoQueryConceptDao.getConceptByFact(PdoQueryConceptDao.java:346) Which reads as follows (many lines of codes omitted, only showing relevant parts): ATTACHMENTS: EMAIL_Parallel_Queries_Error.pdf = original email from Robert. |
| Attachment | EMAIL_Parallel_Queries_Error.pdf [ 10630 ] | |
| Component/s | CRC Cell [ 10049 ] | |
| Description |
This issue was reported by Robert Lodahl from the University Medical Center Gottingen.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used. Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists. The ERROR message that appears is: "Caused by: org.postgresql.util.PSQLException: ERROR: relation "temp_fact_param_table" does not exist“ The exception can be traced back to the part of the code: edu.harvard.i2b2.crc.dao.pdo.PdoQueryConceptDao.getConceptByFact(PdoQueryConceptDao.java:346) Which reads as follows (many lines of codes omitted, only showing relevant parts): ATTACHMENTS: EMAIL_Parallel_Queries_Error.pdf = original email from Robert. |
This issue was reported by Robert Lodahl from the University Medical Center Gottingen.
When running multiple parallel queries requesting a PDO, the CRC will return an error. It appears, for all parallel queries run by the custom plugin, the same connection is used. Upon further investigation, Robert has located the problem to the local temporary tables (like #temp_fact_param_table in this case) are only local for every connection, not per statement. So the first query starts, creating the table, wanting to execute something using this table, while the second query starts and drops the table (marked in bold). Obviously an exception occurs because the table no longer exists. The ERROR message that appears is: "Caused by: org.postgresql.util.PSQLException: ERROR: relation "temp_fact_param_table" does not exist“ The exception can be traced back to the part of the code: edu.harvard.i2b2.crc.dao.pdo.PdoQueryConceptDao.getConceptByFact(PdoQueryConceptDao.java:346) The section of code that appears to be causing the problem can be seen in the attached document. ATTACHMENTS: EMAIL_Parallel_Queries_Error.pdf = original email from Robert. |
| i2b2 Sponsored Project/s | i2b2 Core [ 10196 ] | |
| Reporter | Mike Mendis [ mem61 ] | Janice Donahoe [ jmd86 ] |
| Assignee | Nich [ nich ] |
| Fix Version/s | 1.7.09 [ 10306 ] | |
| Status | New [ 10000 ] | Open [ 1 ] |
| Fix Version/s | 1.7.09 [ 10306 ] |
| Assignee | Nich [ nich ] | Mike Mendis [ mem61 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Ready to Test [ 10001 ] |
| Fix Version/s | 1.7.09 [ 10306 ] |
| Assignee | Mike Mendis [ mem61 ] | Janice Donahoe [ jmd86 ] |
| Status | Ready to Test [ 10001 ] | Testing [ 10002 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Testing [ 10002 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |