Error: `nan` in IDs passed to `/concepts`
Closed this issue · 2 comments
joeflack4 commented
Overview
Couldn't replicate. I was trying to replicate an error in another issue, and then afterwards I noticed that there were these errors on the backend too.
It doesn't seem like these backend errors are what caused the issue I was trying to replicate. And I'm not even sure if these errors caused any issue at all that I could notice while using the frontend.
Local server log w/ error
import sys; print('Python %s on %s' % (sys.version, sys.platform))
/Users/joeflack4/virtualenvs/termhub/bin/python /Applications/PyCharm.app/Contents/plugins/python/helpers/pydev/pydevd.py --multiprocess --qt-support=auto --client 127.0.0.1 --port 59913 --file /Users/joeflack4/projects/termhub/backend/app.py
Connected to pydev debugger (build 233.15325.20)
./load_relationship_graph step 1 loading /Users/joeflack4/projects/termhub/termhub-vocab/relationship_graph.pickle completed in 0:00:08.206029
./load_relationship_graph completed in 0:00:08.206029
INFO: Started server process [5224]
INFO: Waiting for application startup.
INFO: Application startup complete.
INFO: Uvicorn running on http://0.0.0.0:8000 (Press CTRL+C to quit)
http://127.0.0.1:8000/next-api-call-group-id
http://127.0.0.1:8000/get-all-csets
INFO: 127.0.0.1:60227 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
INFO: 127.0.0.1:60228 - "GET /get-all-csets HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:60228 - "OPTIONS /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:60228 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:60442 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-csets?codeset_ids=479356
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
INFO: 127.0.0.1:60442 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:60443 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:60443 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:60443 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:60443 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:60443 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/whoami
http://127.0.0.1:8000/concept-graph?codeset_ids=479356
INFO: 127.0.0.1:60442 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
/Users/joeflack4/projects/termhub/backend/routes/db.py:146: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
select = select.as_string(con.connection.connection)
curl -H "authorization: TOKEN"\
-H "Content-type: application/json" \
'https://unite.nih.gov/multipass/api/me'
INFO: 127.0.0.1:60482 - "GET /concept-graph?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366
INFO: 127.0.0.1:60482 - "GET /concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366 HTTP/1.1" 200 OK
INFO: 127.0.0.1:60481 - "GET /whoami HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61101 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
http://127.0.0.1:8000/whoami
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366
INFO: 127.0.0.1:61101 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
curl -H "authorization: TOKEN"\
-H "Content-type: application/json" \
'https://unite.nih.gov/multipass/api/me'
INFO: 127.0.0.1:61102 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61104 - "GET /concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61103 - "GET /whoami HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61170 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/whoami
curl -H "authorization: TOKEN"\
-H "Content-type: application/json" \
'https://unite.nih.gov/multipass/api/me'
http://127.0.0.1:8000/concept-graph
INFO: 127.0.0.1:61171 - "GET /concept-graph HTTP/1.1" 422 Unprocessable Entity
INFO: 127.0.0.1:61170 - "GET /whoami HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61254 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:61254 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61277 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=400614256
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=400614256
http://127.0.0.1:8000/concept-graph?codeset_ids=400614256
INFO: 127.0.0.1:61277 - "GET /get-cset-members-items?codeset_ids=400614256 HTTP/1.1" 200 OK
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
/Users/joeflack4/projects/termhub/backend/routes/db.py:146: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
select = select.as_string(con.connection.connection)
INFO: 127.0.0.1:61278 - "GET /get-csets?codeset_ids=400614256 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61279 - "GET /concept-graph?codeset_ids=400614256 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3124228&id=46274059&id=40561687&id=42539549&id=3452456&id=36684328&id=44831278&id=36684335&id=40483397&id=45766727&id=45766728&id=46274124&id=46270028&id=46270029&id=46270030&id=3468370&id=3164757&id=45940320&id=3661412&id=40395876&id=40395878&id=40395891&id=4123253&id=3201654&id=40345719&id=312950&id=3105910&id=40345717&id=45939829&id=3466361&id=40316544&id=3080832&id=3476610&id=45938316&id=3153572&id=44832423&id=42536648&id=3240140&id=44824287&id=44824288&id=45769441&id=45769442&id=4271333&id=3458794&id=3430639&id=3456756&id=35609846&id=4191479&id=42538744&id=3124987&id=3124988&id=3124991&id=40389375&id=4119299&id=4119300&id=3557638&id=3475208&id=45909769&id=3452171&id=4112669&id=45946655&id=37310241&id=3137829&id=3137830&id=4147509&id=3427139&id=4309833&id=46269770&id=4211530&id=46269771&id=46269776&id=46269777&id=46269784&id=46269785&id=45939036&id=3459941&id=3447664&id=3427698&id=45557624&id=3162019&id=3432874&id=3472300&id=46273452&id=46273454&id=252341&id=46273462&id=3429308&id=4112831&id=3436486&id=3472327&id=3451853&id=3439569&id=4283362&id=3451367&id=45917166&id=259055&id=3141621&id=3141622&id=45939199
INFO: 127.0.0.1:61279 - "GET /concepts?id=3124228&id=46274059&id=40561687&id=42539549&id=3452456&id=36684328&id=44831278&id=36684335&id=40483397&id=45766727&id=45766728&id=46274124&id=46270028&id=46270029&id=46270030&id=3468370&id=3164757&id=45940320&id=3661412&id=40395876&id=40395878&id=40395891&id=4123253&id=3201654&id=40345719&id=312950&id=3105910&id=40345717&id=45939829&id=3466361&id=40316544&id=3080832&id=3476610&id=45938316&id=3153572&id=44832423&id=42536648&id=3240140&id=44824287&id=44824288&id=45769441&id=45769442&id=4271333&id=3458794&id=3430639&id=3456756&id=35609846&id=4191479&id=42538744&id=3124987&id=3124988&id=3124991&id=40389375&id=4119299&id=4119300&id=3557638&id=3475208&id=45909769&id=3452171&id=4112669&id=45946655&id=37310241&id=3137829&id=3137830&id=4147509&id=3427139&id=4309833&id=46269770&id=4211530&id=46269771&id=46269776&id=46269777&id=46269784&id=46269785&id=45939036&id=3459941&id=3447664&id=3427698&id=45557624&id=3162019&id=3432874&id=3472300&id=46273452&id=46273454&id=252341&id=46273462&id=3429308&id=4112831&id=3436486&id=3472327&id=3451853&id=3439569&id=4283362&id=3451367&id=45917166&id=259055&id=3141621&id=3141622&id=45939199 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=e64b8f7b-7af8-4b44-a570-557b812c0eeb
INFO: 127.0.0.1:61279 - "GET /researchers?ids=e64b8f7b-7af8-4b44-a570-557b812c0eeb HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61331 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-csets?codeset_ids=400614256
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=400614256
INFO: 127.0.0.1:61331 - "GET /get-csets?codeset_ids=400614256 HTTP/1.1" 200 OK
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61332 - "GET /get-cset-members-items?codeset_ids=400614256 HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:61332 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=e64b8f7b-7af8-4b44-a570-557b812c0eeb
INFO: 127.0.0.1:61332 - "GET /researchers?ids=e64b8f7b-7af8-4b44-a570-557b812c0eeb HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61343 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:61343 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61343 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-csets?codeset_ids=479356
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
INFO: 127.0.0.1:61343 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61346 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/related-cset-concept-counts
INFO: 127.0.0.1:61346 - "POST /related-cset-concept-counts HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61346 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61346 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:61346 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61343 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366
INFO: 127.0.0.1:61352 - "GET /concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61352 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61370 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:61370 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=3052648&id=3052716&id=3018737&id=3048530&id=37021210&id=42870366
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61377 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concept-search?search_str=cancer
INFO: 127.0.0.1:61377 - "GET /concept-search?search_str=cancer HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=4179963&id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945
INFO: 127.0.0.1:61377 - "GET /concepts?id=4179963&id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=4179963&id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945
http://127.0.0.1:8000/concepts?id=4179963
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61381 - "GET /concepts?id=4179963&id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61382 - "GET /concepts?id=4179963 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61383 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945&id=4164784
INFO: 127.0.0.1:61383 - "GET /concepts?id=42535500&id=43530673&id=3037551&id=3022914&id=759652&id=37396808&id=3013520&id=3006588&id=46236059&id=3037970&id=3010872&id=4087256&id=4115276&id=4048727&id=4186868&id=2617406&id=3007835&id=42529201&id=3048228&id=3024552&id=4195970&id=42529199&id=46236058&id=37117053&id=42529200&id=42742564&id=3002384&id=42742338&id=43527945&id=4164784 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61389 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
http://127.0.0.1:8000/concept-graph?codeset_ids=479356&cids=4179963
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
/Users/joeflack4/projects/termhub/backend/routes/db.py:146: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
select = select.as_string(con.connection.connection)
INFO: 127.0.0.1:61389 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61390 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61391 - "GET /concept-graph?codeset_ids=479356&cids=4179963 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61391 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61391 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
http://127.0.0.1:8000/get-csets?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61410 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61411 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61412 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61412 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
http://127.0.0.1:8000/get-csets?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61417 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61418 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61419 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61419 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:61446 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61447 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61448 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:61497 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:61497 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61498 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61499 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61499 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
http://127.0.0.1:8000/get-csets?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61599 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61600 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
http://127.0.0.1:8000/get-csets?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
INFO: 127.0.0.1:61601 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61600 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61599 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61619 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366
INFO: 127.0.0.1:61619 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61600 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61601 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366 HTTP/1.1" 200 OK
INFO: 127.0.0.1:61599 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61601 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1
INFO: 127.0.0.1:61599 - "GET /researchers?ids=ef6678a4-283c-419d-b422-26612bd9d8e1 HTTP/1.1" 200 OK
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:62023 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:62023 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366&id=NaN
/Users/joeflack4/projects/termhub/backend/utils.py:228: UserWarning: Traceback (most recent call last):
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
self.dialect.do_execute(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column "nan" does not exist
LINE 4: ...8530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/joeflack4/projects/termhub/backend/db/utils.py", line 539, in sql_query
q: CursorResult = run_sql(con, query, params)
File "/Users/joeflack4/projects/termhub/backend/db/utils.py", line 482, in run_sql
return con.execute(query, params) if params else con.execute(query)
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
return meth(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
return connection._execute_clauseelement(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement
ret = self._execute_context(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1987, in _exec_single_context
self._handle_dbapi_exception(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2344, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
self.dialect.do_execute(
File "/Users/joeflack4/virtualenvs/termhub/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column "nan" does not exist
LINE 4: ...8530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;
^
[SQL:
SELECT *
FROM concepts_with_counts
WHERE concept_id IN (3023361, 3051714, 4328583, 3052648, 46270155, 3052716, 3018737, 3048530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;]
(Background on this error at: https://sqlalche.me/e/20/f405)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/joeflack4/projects/termhub/backend/utils.py", line 220, in decorated_func
return await func(*args, **kwargs)
File "/Users/joeflack4/projects/termhub/backend/routes/db.py", line 260, in get_concepts_route
raise e
File "/Users/joeflack4/projects/termhub/backend/routes/db.py", line 256, in get_concepts_route
rows = get_concepts(concept_ids=id, table=table)
File "/Users/joeflack4/projects/termhub/backend/db/queries.py", line 17, in get_concepts
rows: List = sql_query(conn, q)
File "/Users/joeflack4/projects/termhub/backend/db/utils.py", line 555, in sql_query
raise RuntimeError(
RuntimeError: Got an error [(psycopg2.errors.UndefinedColumn) column "nan" does not exist
LINE 4: ...8530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;
^
[SQL:
SELECT *
FROM concepts_with_counts
WHERE concept_id IN (3023361, 3051714, 4328583, 3052648, 46270155, 3052716, 3018737, 3048530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;]
(Background on this error at: https://sqlalche.me/e/20/f405)] executing the following statement:
SELECT *
FROM concepts_with_counts
WHERE concept_id IN (3023361, 3051714, 4328583, 3052648, 46270155, 3052716, 3018737, 3048530, 42535025, 37021210, 4179963, 4176765, 42870366, NaN) ;, {}
warnings.warn(stacktrace) # added so that we can see the stacktrace in the console and logs
INFO: 127.0.0.1:62024 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:62025 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366&id=NaN HTTP/1.1" 500 Internal Server Error
http://127.0.0.1:8000/next-api-call-group-id
INFO: 127.0.0.1:62025 - "GET /next-api-call-group-id HTTP/1.1" 200 OK
http://127.0.0.1:8000/get-cset-members-items?codeset_ids=479356
/Users/joeflack4/projects/termhub/backend/routes/db.py:133: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)
where = sql.SQL(f" WHERE codeset_id IN ({pstr})").as_string(con.connection.connection)
http://127.0.0.1:8000/get-csets?codeset_ids=479356
INFO: 127.0.0.1:62025 - "GET /get-cset-members-items?codeset_ids=479356 HTTP/1.1" 200 OK
INFO: 127.0.0.1:62024 - "GET /get-csets?codeset_ids=479356 HTTP/1.1" 200 OK
http://127.0.0.1:8000/concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366&id=NaN
INFO: 127.0.0.1:62065 - "GET /concepts?id=3023361&id=3051714&id=4328583&id=3052648&id=46270155&id=3052716&id=3018737&id=3048530&id=42535025&id=37021210&id=4179963&id=4176765&id=42870366&id=NaN HTTP/1.1" 500 Internal Server Error
Sigfried commented
@joeflack4 -- this included our token, which is now revoked
joeflack4 commented
Probably fixed. Brief problem.