Trap in Python 3.5 under Apache 2.2 when Django database returns 'None'.

[jomowillacyhotmailcom]

BPO	37397
Nosy	@tirkarthi

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2019-06-25.02:53:11.491>
created_at = <Date 2019-06-25.02:29:17.627>
labels = ['type-bug']
title = "Trap in Python 3.5 under Apache 2.2 when Django database returns 'None'."
updated_at = <Date 2019-06-25.02:53:11.486>
user = 'https://bugs.python.org/jomowillacyhotmailcom'

bugs.python.org fields:

activity = <Date 2019-06-25.02:53:11.486>
actor = 'xtreak'
assignee = 'none'
closed = True
closed_date = <Date 2019-06-25.02:53:11.491>
closer = 'xtreak'
components = []
creation = <Date 2019-06-25.02:29:17.627>
creator = 'jomo_willacy@hotmail.com'
dependencies = []
files = []
hgrepos = []
issue_num = 37397
keywords = []
message_count = 2.0
messages = ['346476', '346479']
nosy_count = 2.0
nosy_names = ['xtreak', 'jomo_willacy@hotmail.com']
pr_nums = []
priority = 'normal'
resolution = 'third party'
stage = 'resolved'
status = 'closed'
superseder = None
type = 'behavior'
url = 'https://bugs.python.org/issue37397'
versions = ['Python 3.5']

[jomowillacyhotmailcom]

I am using Python 3.5 with Django and the Python web server and Apache 2.2 web server.
I am querying the database for a "drug_name" and an "insurer" - # and minimum "price".

Here is what works and what does not work

Valid Drug Name Valid Insurer Works Python web Server Apache

Epipen 2 Yes Yes Yes

Lisenopril 2 Yes Yes Yes

Naftin 7 Yes Yes Yes

Invalid Drug Name Insurer Works Python Server Apache

Licenopril Yes Yes Yes

Licenopril 2 Yes No

In the last case up above it traps and the server logs at /var/www/logs/error.log say "Unhandled Exception".

This is where it traps ans what it says :

Cannot convert str to float : 'None'

File "/usr/local/lib64/python3.5/site-packages/django/db/models/fields/init.py" line 1747, in get_prep_value

   return float( output_value )

I then went into the file where the trap occurred and I added a try catch like the function after line 1747 and the problem went away.

The trap only happens under Apache.

If you wish to reproduce this problem then go to these links and try the input listed above :

Python Web Server :

http://34.200.216.166:8000/health_insurer2/minimum_price_for_drug/

Apache Web Server :

http://34.200.216.166/health_insurer2/minimum_price_for_drug/

As an aid I have left debug=on in django so you will be able to trace the trap in the browser

The file that I am running is views.py
I am running Amazon AMI Linux in the cloud.

Sincerely Yours,

Jomo Willacy

[tirkarthi]

This tracker deals with CPython development and this doesn't seem like am issue in CPython but rather an error in your program. I assume you might be passing None somewhere in the django ORM query that is expecting a number. Also please don't post open web server endpoints with debug mode on. The debug server is not meant to be exposed to the internet. This question could find better answer from stackoverflow.