The casjobs query results involving bigint column produce errors.

[segasai]

Hi,

When trying to query the skyserver/casjobs I can do it without issues if I don't ask for the specobjid column in a query , but if I add it, I'm getting a bunch of errors.

The simple code (based on the example) is given below

import SciServer
from SciServer import Authentication, LoginPortal, Config, CasJobs, SkyQuery, SciDrive, SkyServer, Files, Jobs
import os
import pandas
import sys
import json
from io import StringIO
from io import BytesIO
#from PIL import Image 
import numpy as np
import matplotlib.pyplot as plt

Authentication_loginName = '**' #CHANGE ME 
Authentication_loginPassword = '**'

token1 = LoginPortal.login(Authentication_loginName,
 Authentication_loginPassword)

casJobsId = CasJobs.getSchemaName()
print(casJobsId)
Query = ' select top 10 ra,dec from specphotoall' # this works 
Query = ' select top 10 ra,dec,plate from specphotoall' # this works 
Query = ' select top 10 ra,dec,specobjid from specphotoall' #this doesn't 
df = CasJobs.executeQuery(sql=Query, context='DR16', format="fits")

fd = open('xx.fits', 'wb')
fd.write(df.read())
fd.close()

The error is

Traceback (most recent call last):
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 685, in _update_chunk_length
 self.chunk_left = int(line, 16)
ValueError: invalid literal for int() with base 16: b''

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 425, in _error_catcher
 yield
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 752, in read_chunked
 self._update_chunk_length()
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 689, in _update_chunk_length
 raise httplib.IncompleteRead(line)
http.client.IncompleteRead: IncompleteRead(0 bytes read)
During handling of the above exception, another exception occurred:

Traceback (most recent call last):
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py", line 751, in generate
 for chunk in self.raw.stream(chunk_size, decode_content=True):
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 560, in stream
 for line in self.read_chunked(amt, decode_content=decode_content):
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 781, in read_chunked
 self._original_response.close()
 File "/home/koposov/python36/lib/python3.6/contextlib.py", line 99, in __exit__
 self.gen.throw(type, value, traceback)
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py", line 443, in _error_catcher
 raise ProtocolError("Connection broken: %r" % e, e)
urllib3.exceptions.ProtocolError: ('Connection broken: IncompleteRead(0 bytes read)', IncompleteRead(0 bytes read))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
 File "doit.py", line 23, in <module>
 df = CasJobs.executeQuery(sql=Query, context='DR16', format="fits")
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/SciServer-2.0.13-py3.6.egg/SciServer/CasJobs.py", line 171, in executeQuery
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py", line 829, in content
 self._content = b''.join(self.iter_content(CONTENT_CHUNK_SIZE)) or b''
 File "/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py", line 754, in generate
 raise ChunkedEncodingError(e)
requests.exceptions.ChunkedEncodingError: ('Connection broken: IncompleteRead(0 bytes read)', IncompleteRead(0 bytes read))

Background info. I'm using sciserver-2.0.13 and python 3.6.10 on linux.

Thanks
Sergey