Can't enter sample info for project 12604 #558
Assignees
Milestone
Comments
|
Hi Julia,
Thanks for the bug report! We've already fixed some of the code in this
area, so this will be a perfect to use as a use case!
Best,
Charlie
…On Tue, Aug 6, 2019 at 7:46 AM jtoronczak ***@***.***> wrote:
In Qiita we've selected for the tube id to be input into the platemap, and
once the samples are pasted into the plate map (using tube id) in this
error shows up:
Error
Error running SQL query: Query: SELECT sample_values->'tube_id' FROM
qiita.sample_12604 as tube_id WHERE sample_id = %s Arguments:
['12604.MAD.1.17.268.01'] Error: permission denied for relation sample_12604
Traceback
Traceback (most recent call last):
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 586, in _execute cur.execute(sql, sql_args)
File
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/psycopg2/extras.py",
line 142, in execute return super(DictCursor, self).execute(query, vars)
psycopg2.errors.InsufficientPrivilege: permission denied for relation
sample_12604
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py",
line 1590, in _execute result = method(*self.path_args, **self.path_kwargs)
File
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py",
line 3006, in wrapper return method(self, *args, **kwargs)
File
"/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py", line
267, in get
self.write(json_encode(plate_layout_handler_get_request(plate_id)))
File
"/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py", line
256, in plate_layout_handler_get_request sample = composition.specimen_id
File "/home/labcontrol/labcontrol/labman/labcontrol/db/composition.py",
line 582, in specimen_id return
study.sample_id_to_specimen_id(self.sample_id)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/study.py", line
177, in sample_id_to_specimen_id res = TRN.execute_fetchflatten()
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 391, in wrapper return func(self, *args, **kwargs)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 735, in execute_fetchflatten return
list(chain.from_iterable(self.execute()[idx]))
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 391, in wrapper return func(self, *args, **kwargs)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 643, in execute return self._execute()
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 590, in _execute self._raise_execution_error(sql, sql_args, e)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
line 535, in _raise_execution_error % (sql, str(sql_args), str(error)))
ValueError: Error running SQL query: Query: SELECT
sample_values->'tube_id' FROM qiita.sample_12604 as tube_id WHERE sample_id
= %s Arguments: ['12604.MAD.1.17.268.01'] Error: permission denied for
relation sample_12604
Request Info
uri: /plate/251/layout
host: labcontrol.ucsd.edu
body_arguments: {}
body: b''
headers: Cookie: _ga=GA1.2.515592774.1562178083; jlinkauthserver=findlay;
__utmc=57960238; jlinkserver=act; jssoserver=findlay;
_fbp=fb.1.1562618242476.53653934;
user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7;
__utma=57960238.515592774.1562178083.1562682506.1563890447.3;
__utmz=57960238.1563890447.3.3.utmcsr=a5.ucsd.edu|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO;
jlinksessionidx=z7790792b2ece3298735a8a3888893b37;
xjlinkloginMyTimeEntry.User=REMOVE; jlinkappx=/marketplace-sso/signon;
xjlinkloginStaff.InquiryA4=OK; jlinkpedjat=pedjat X-Real-Ip: 137.110.66.21
Accept-Encoding: identity Accept: */* Accept-Language: en-US,en;q=0.9
Host: labcontrol.ucsd.edu X-Requested-With: XMLHttpRequest User-Agent:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/75.0.3770.142 Safari/537.36 Connection: upgrade Referer:
https://labcontrol.ucsd.edu/plate?process_id=309 X-Forwarded-For:
137.110.66.21
protocol: https
_finish_time: None
_cookies: Set-Cookie:
__utma=57960238.515592774.1562178083.1562682506.1563890447.3 Set-Cookie:
__utmc=57960238 Set-Cookie: __utmz="57960238.1563890447.3.3.utmcsr=
a5.ucsd.edu|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO"
Set-Cookie: _fbp=fb.1.1562618242476.53653934 Set-Cookie:
_ga=GA1.2.515592774.1562178083 Set-Cookie:
jlinkappx="/marketplace-sso/signon" Set-Cookie: jlinkauthserver=findlay
Set-Cookie: jlinkpedjat=pedjat Set-Cookie: jlinkserver=act Set-Cookie:
jlinksessionidx=z7790792b2ece3298735a8a3888893b37 Set-Cookie:
jssoserver=findlay Set-Cookie:
user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7
Set-Cookie: xjlinkloginMyTimeEntry.User=REMOVE Set-Cookie:
xjlinkloginStaff.InquiryA4=OK
server_connection:
query_arguments: {}
version: HTTP/1.1
arguments: {}
method: GET
host_name: labcontrol.ucsd.edu
path: /plate/251/layout
connection:
files: {}
remote_ip: 127.0.0.1
_start_time: 1565102063.703464
query:
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#558>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AKFU7E3CTV6N7HSJE63HHBLQDGFD3ANCNFSM4IJXFJRQ>
.
|
|
Hi Charlie,
thanks for getting back to me! I'm not entirely sure what that means, but
I've also had issues in the last few plates (Alderete: 12604) and (Twins
UK: 11624) with none of the samples matching the qiita project.
Best,
Julia
On Tue, Aug 6, 2019 at 10:44 AM charles-cowart <[email protected]>
wrote:
… Hi Julia,
Thanks for the bug report! We've already fixed some of the code in this
area, so this will be a perfect to use as a use case!
Best,
Charlie
On Tue, Aug 6, 2019 at 7:46 AM jtoronczak ***@***.***>
wrote:
> In Qiita we've selected for the tube id to be input into the platemap,
and
> once the samples are pasted into the plate map (using tube id) in this
> error shows up:
>
> Error
> Error running SQL query: Query: SELECT sample_values->'tube_id' FROM
> qiita.sample_12604 as tube_id WHERE sample_id = %s Arguments:
> ['12604.MAD.1.17.268.01'] Error: permission denied for relation
sample_12604
>
> Traceback
> Traceback (most recent call last):
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 586, in _execute cur.execute(sql, sql_args)
> File
>
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/psycopg2/extras.py",
> line 142, in execute return super(DictCursor, self).execute(query, vars)
> psycopg2.errors.InsufficientPrivilege: permission denied for relation
> sample_12604
> During handling of the above exception, another exception occurred:
> Traceback (most recent call last):
> File
>
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py",
> line 1590, in _execute result = method(*self.path_args,
**self.path_kwargs)
> File
>
"/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py",
> line 3006, in wrapper return method(self, *args, **kwargs)
> File
> "/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py",
line
> 267, in get
> self.write(json_encode(plate_layout_handler_get_request(plate_id)))
> File
> "/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py",
line
> 256, in plate_layout_handler_get_request sample = composition.specimen_id
> File "/home/labcontrol/labcontrol/labman/labcontrol/db/composition.py",
> line 582, in specimen_id return
> study.sample_id_to_specimen_id(self.sample_id)
> File "/home/labcontrol/labcontrol/labman/labcontrol/db/study.py", line
> 177, in sample_id_to_specimen_id res = TRN.execute_fetchflatten()
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 391, in wrapper return func(self, *args, **kwargs)
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 735, in execute_fetchflatten return
> list(chain.from_iterable(self.execute()[idx]))
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 391, in wrapper return func(self, *args, **kwargs)
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 643, in execute return self._execute()
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 590, in _execute self._raise_execution_error(sql, sql_args, e)
> File
"/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py",
> line 535, in _raise_execution_error % (sql, str(sql_args), str(error)))
> ValueError: Error running SQL query: Query: SELECT
> sample_values->'tube_id' FROM qiita.sample_12604 as tube_id WHERE
sample_id
> = %s Arguments: ['12604.MAD.1.17.268.01'] Error: permission denied for
> relation sample_12604
>
> Request Info
> uri: /plate/251/layout
> host: labcontrol.ucsd.edu
> body_arguments: {}
> body: b''
> headers: Cookie: _ga=GA1.2.515592774.1562178083; jlinkauthserver=findlay;
> __utmc=57960238; jlinkserver=act; jssoserver=findlay;
> _fbp=fb.1.1562618242476.53653934;
>
user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7;
> __utma=57960238.515592774.1562178083.1562682506.1563890447.3;
> __utmz=57960238.1563890447.3.3.utmcsr=a5.ucsd.edu
|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO;
> jlinksessionidx=z7790792b2ece3298735a8a3888893b37;
> xjlinkloginMyTimeEntry.User=REMOVE; jlinkappx=/marketplace-sso/signon;
> xjlinkloginStaff.InquiryA4=OK; jlinkpedjat=pedjat X-Real-Ip:
137.110.66.21
> Accept-Encoding: identity Accept: */* Accept-Language: en-US,en;q=0.9
> Host: labcontrol.ucsd.edu X-Requested-With: XMLHttpRequest User-Agent:
> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36
(KHTML,
> like Gecko) Chrome/75.0.3770.142 Safari/537.36 Connection: upgrade
Referer:
> https://labcontrol.ucsd.edu/plate?process_id=309 X-Forwarded-For:
> 137.110.66.21
> protocol: https
> _finish_time: None
> _cookies: Set-Cookie:
> __utma=57960238.515592774.1562178083.1562682506.1563890447.3 Set-Cookie:
> __utmc=57960238 Set-Cookie: __utmz="57960238.1563890447.3.3.utmcsr=
> a5.ucsd.edu
|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO"
> Set-Cookie: _fbp=fb.1.1562618242476.53653934 Set-Cookie:
> _ga=GA1.2.515592774.1562178083 Set-Cookie:
> jlinkappx="/marketplace-sso/signon" Set-Cookie: jlinkauthserver=findlay
> Set-Cookie: jlinkpedjat=pedjat Set-Cookie: jlinkserver=act Set-Cookie:
> jlinksessionidx=z7790792b2ece3298735a8a3888893b37 Set-Cookie:
> jssoserver=findlay Set-Cookie:
>
user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7
> Set-Cookie: xjlinkloginMyTimeEntry.User=REMOVE Set-Cookie:
> xjlinkloginStaff.InquiryA4=OK
> server_connection:
> query_arguments: {}
> version: HTTP/1.1
> arguments: {}
> method: GET
> host_name: labcontrol.ucsd.edu
> path: /plate/251/layout
> connection:
> files: {}
> remote_ip: 127.0.0.1
> _start_time: 1565102063.703464
> query:
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <
#558
>,
> or mute the thread
> <
https://github.com/notifications/unsubscribe-auth/AKFU7E3CTV6N7HSJE63HHBLQDGFD3ANCNFSM4IJXFJRQ
>
> .
>
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#558>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AM2VVBO33ARE6SXXGD2HKELQDG2APANCNFSM4IJXFJRQ>
.
|
|
@fedarko Adding you to this, as this will be a useful sample test case once code is pushed to maptest.ucsd.edu, and we get access to the study data required to debug this. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In Qiita we've selected for the tube id to be input into the platemap, and once the samples are pasted into the plate map (using tube id) in this error shows up:
Error
Error running SQL query: Query: SELECT sample_values->'tube_id' FROM qiita.sample_12604 as tube_id WHERE sample_id = %s Arguments: ['12604.MAD.1.17.268.01'] Error: permission denied for relation sample_12604
Traceback
Traceback (most recent call last):
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 586, in _execute cur.execute(sql, sql_args)
File "/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/psycopg2/extras.py", line 142, in execute return super(DictCursor, self).execute(query, vars)
psycopg2.errors.InsufficientPrivilege: permission denied for relation sample_12604
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py", line 1590, in _execute result = method(*self.path_args, **self.path_kwargs)
File "/home/labcontrol/miniconda3/envs/labcontrol2019.6.1/lib/python3.5/site-packages/tornado/web.py", line 3006, in wrapper return method(self, *args, **kwargs)
File "/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py", line 267, in get self.write(json_encode(plate_layout_handler_get_request(plate_id)))
File "/home/labcontrol/labcontrol/labman/labcontrol/gui/handlers/plate.py", line 256, in plate_layout_handler_get_request sample = composition.specimen_id
File "/home/labcontrol/labcontrol/labman/labcontrol/db/composition.py", line 582, in specimen_id return study.sample_id_to_specimen_id(self.sample_id)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/study.py", line 177, in sample_id_to_specimen_id res = TRN.execute_fetchflatten()
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 391, in wrapper return func(self, *args, **kwargs)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 735, in execute_fetchflatten return list(chain.from_iterable(self.execute()[idx]))
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 391, in wrapper return func(self, *args, **kwargs)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 643, in execute return self._execute()
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 590, in _execute self._raise_execution_error(sql, sql_args, e)
File "/home/labcontrol/labcontrol/labman/labcontrol/db/sql_connection.py", line 535, in _raise_execution_error % (sql, str(sql_args), str(error)))
ValueError: Error running SQL query: Query: SELECT sample_values->'tube_id' FROM qiita.sample_12604 as tube_id WHERE sample_id = %s Arguments: ['12604.MAD.1.17.268.01'] Error: permission denied for relation sample_12604
Request Info
uri: /plate/251/layout
host: labcontrol.ucsd.edu
body_arguments: {}
body: b''
headers: Cookie: _ga=GA1.2.515592774.1562178083; jlinkauthserver=findlay; __utmc=57960238; jlinkserver=act; jssoserver=findlay; _fbp=fb.1.1562618242476.53653934; user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7; __utma=57960238.515592774.1562178083.1562682506.1563890447.3; __utmz=57960238.1563890447.3.3.utmcsr=a5.ucsd.edu|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO; jlinksessionidx=z7790792b2ece3298735a8a3888893b37; xjlinkloginMyTimeEntry.User=REMOVE; jlinkappx=/marketplace-sso/signon; xjlinkloginStaff.InquiryA4=OK; jlinkpedjat=pedjat X-Real-Ip: 137.110.66.21 Accept-Encoding: identity Accept: / Accept-Language: en-US,en;q=0.9 Host: labcontrol.ucsd.edu X-Requested-With: XMLHttpRequest User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 Safari/537.36 Connection: upgrade Referer: https://labcontrol.ucsd.edu/plate?process_id=309 X-Forwarded-For: 137.110.66.21
protocol: https
_finish_time: None
_cookies: Set-Cookie: __utma=57960238.515592774.1562178083.1562682506.1563890447.3 Set-Cookie: __utmc=57960238 Set-Cookie: __utmz="57960238.1563890447.3.3.utmcsr=a5.ucsd.edu|utmccn=(referral)|utmcmd=referral|utmcct=/tritON/profile/SAML2/Redirect/SSO" Set-Cookie: _fbp=fb.1.1562618242476.53653934 Set-Cookie: _ga=GA1.2.515592774.1562178083 Set-Cookie: jlinkappx="/marketplace-sso/signon" Set-Cookie: jlinkauthserver=findlay Set-Cookie: jlinkpedjat=pedjat Set-Cookie: jlinkserver=act Set-Cookie: jlinksessionidx=z7790792b2ece3298735a8a3888893b37 Set-Cookie: jssoserver=findlay Set-Cookie: user=2|1:0|10:1563385655|4:user|28:Imp0b3JvbmN6YWtAdWNzZC5lZHUi|6375bf15df215358c0f5a69dfb4dbb3b5e3b671beb149d0c2db5f2c87f4e4eb7 Set-Cookie: xjlinkloginMyTimeEntry.User=REMOVE Set-Cookie: xjlinkloginStaff.InquiryA4=OK
server_connection:
query_arguments: {}
version: HTTP/1.1
arguments: {}
method: GET
host_name: labcontrol.ucsd.edu
path: /plate/251/layout
connection:
files: {}
remote_ip: 127.0.0.1
_start_time: 1565102063.703464
query:
The text was updated successfully, but these errors were encountered: