sveatlo
sveatlo

Reputation: 593

Python requests ssl [Errno 1] _ssl.c:1428: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number

I'm creating a python app, using requests module. I recently add multiprocessing to speed it up a bit, but I started to get some strange errors like [Errno 1] _ssl.c:1428: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number or [Errno 1] _ssl.c:1428: error:1408F119:SSL routines:SSL3_GET_RECORD:decryption failed or bad record mac. The code looks like this:

def hometables_one(conn, request, s, hostname, payload, company):
    date1 = request.query.get('date1', '')      
    date2 = request.query.get('date2', '')

    prijmyCelk = 0;
    vydajeCelk = 0;
    neuhrPrijCelk = 0;
    neuhrVydCelk = 0;
    dph = 0;
    dbNazev = company['dbNazev'];
    nazev = company['nazev'];

    if date1 and date2:
        try:
            r = s.get("%s/c/%s/faktura-vydana/(duzpPuv between %s %s)/$sum.json" % (hostname, dbNazev, date1[0], date2[0]), params=payload, verify=False)
            r.raise_for_status()
        except requests.exceptions.RequestException as err:
            #response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
            #return response
            conn.send({ "success": False, "errors": { "reason": str(err)}})
            conn.close()
            return None

    else:
        try:
            r = s.get("%s/c/%s/faktura-vydana/$sum.json" % (hostname, dbNazev), params=payload, verify=False)
            r.raise_for_status()
        except requests.exceptions.RequestException as err:
            #response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
            #return response
            conn.send({ "success": False, "errors": { "reason": str(err)}})
            conn.close()
            return None

    obj_vydana = r.json()
    data_vydana = obj_vydana['winstrom']['sum']['sumDoklUcetni']['values']
    prijmyCelk = float(data_vydana['sumDoklCelkem']['value'])
    neuhrVydCelk = float(data_vydana['sumDoklZbyvaUh']['value'])
    dph_vydane = float(data_vydana['sumDoklDphCelk']['value'])


    if date1 and date2:
        try:
            r = s.get("%s/c/%s/faktura-prijata/(duzpPuv between %s %s)/$sum.json" % (hostname, dbNazev, date1[0], date2[0]), params=payload, verify=False)
            r.raise_for_status()
        except requests.exceptions.RequestException as err:
            #response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
            #return response
            conn.send({ "success": False, "errors": { "reason": str(err)}})
            conn.close()
            return None

    else:
        try:
            r = s.get("%s/c/%s/faktura-prijata/$sum.json" % (hostname, dbNazev), params=payload, verify=False)
            r.raise_for_status()
        except requests.exceptions.RequestException as err:
            #response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
            #return response
            conn.send({ "success": False, "errors": { "reason": str(err)}})
            conn.close()
            return None

    obj_prijata = r.json();
    data_prijata = obj_prijata['winstrom']['sum']['sumDoklUcetni']['values']
    vydajeCelk = float(data_prijata['sumDoklCelkem']['value'])
    neuhrPrijCelk = float(data_prijata['sumDoklZbyvaUh']['value'])
    dph_prijate = float(data_prijata['sumDoklDphCelk']['value'])

    if prijmyCelk != 0:
        result = {
            "corporation": nazev,
            "dbName": dbNazev,
            "prijmyCelk": "%s €" % prijmyCelk,
            "nakladyCelk": "%s €" % vydajeCelk,
            "ziskCelk": "%s €" % (prijmyCelk-vydajeCelk),
            "marzaCelk": ((prijmyCelk-vydajeCelk)/prijmyCelk*100),
            "neuhrVydCelk": "%s €" % neuhrVydCelk,
            "neuhrPrijCelk": "%s €" % neuhrPrijCelk,
            "dph": "%s €" % (dph_vydane-dph_prijate),
        }
    else:
        result = {
            "corporation": nazev,
            "dbName": dbNazev,
            "prijmyCelk": "%s €" % prijmyCelk,
            "nakladyCelk": "%s €" % vydajeCelk,
            "ziskCelk": "%s €" % (prijmyCelk-vydajeCelk),
            "marzaCelk": 0,
            "neuhrVydCelk": "%s €" % neuhrVydCelk,
            "neuhrPrijCelk": "%s €" % neuhrPrijCelk,
            "dph": "%s €" % (dph_vydane-dph_prijate),
        }
    conn.send(result)
    conn.close()
    return None
#####################################################################################

def hometables(request):
    s = requests.Session()
    response = HTTPResponse()
    hostname = request.query.get('hostname', '')[0]
    auth = request.query.get('auth', '')[0]
    p_queue = []
    result = []

    json_r = {"success": True}
    payload = {'authSessionId': request.query.get('auth', '')[0]}
    try:
        r = s.get("%s/c.json" % hostname, params=payload, verify=False)
        r.raise_for_status()
    except requests.exceptions.RequestException as err:
        response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
        return response

    obj = r.json()
    data = obj['companies']['company']
    data = make_list(data)

    parent_conn, child_conn = Pipe()
    for company in data:
        p_queue.append(Process(target=hometables_one, args=(child_conn, request, s, hostname, payload, company))) #create a new process with hometables_one function
        p_queue[-1].start()

    for p in p_queue:
        received_data = parent_conn.recv()
        if "success" not in received_data:
            result.append(received_data)s
            p.join()
        else:
            response.write(ujson.dumps(received_data)) #error in hometables_one function
            return response

    json_r["data"] = result
    response.write(ujson.dumps(json_r))
    return response

In this part

    try:
        r = s.get("%s/c.json" % hostname, params=payload, verify=False)
        r.raise_for_status()
    except requests.exceptions.RequestException as err:
        response.write(ujson.dumps({ "success": False, "errors": { "reason": str(err)}}))
        return response

    obj = r.json()
    data = obj['companies']['company']
            data = make_list(data)

I get a JSON request with all companies currently in system and then I run the hometables_one function for each of them. The final data may look like this:

[{"createDt":"2014-01-28T00:00:00+01:00","dbNazev":"sveatlo","id":"4","licenseGroup":"null","nazev":"Sveatlo","show":"true","stavEnum":"ESTABLISHED","watchingChanges":"false"}]

or like this:

[{"createDt":"2014-01-28T00:00:00+01:00","dbNazev":"sveatlo","id":"4","licenseGroup":"null","nazev":"Sveatlo","show":"true","stavEnum":"ESTABLISHED","watchingChanges":"false"},{"createDt":"2014-01-28T00:00:00+01:00","dbNazev":"sveatlo1","id":"4","licenseGroup":"null","nazev":"Sveatlo1","show":"true","stavEnum":"ESTABLISHED","watchingChanges":"false"}]

In the first case, when there is just one item the hometables_one function runs without any problems, but adding another item results in error [Errno 1] _ssl.c:1428: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number or [Errno 1] _ssl.c:1428: error:1408F119:SSL routines:SSL3_GET_RECORD:decryption failed or bad record mac. Another thing is that when I run the code without multiprocessing, i.e. content of hometable_one function is in the for loop in hometables function, it runs without any problems. Why am I getting these errors? Could anybody help me please?

Thanks for any answer

Upvotes: 0

Views: 4563

Answers (1)

X.D.Zhai
X.D.Zhai

Reputation: 31

I have experienced similar problems. I think this error is the result of multiple processes trying to access the same SSL connection. What you can try is to introduce a random delay for each process before they fire off the request:

time.sleep(random.randrange(10))
r = s.get("%s/c.json" % hostname, params=payload, verify=False)

Upvotes: 3

Related Questions