division by zero
Request Method: | GET |
---|---|
Request URL: | http://fresno.otsukalab.nitech.ac.jp/graphs/3/precision |
Django Version: | 2.1.1 |
Exception Type: | ZeroDivisionError |
Exception Value: | division by zero |
Exception Location: | ./graphs/views.py in data_make_precision, line 547 |
Python Executable: | /home/itolab/aqua4/bin/uwsgi |
Python Version: | 3.6.8 |
Python Path: | ['.', '', '/usr/lib64/python36.zip', '/usr/lib64/python3.6', '/usr/lib64/python3.6/lib-dynload', '/home/itolab/aqua4/lib64/python3.6/site-packages', '/home/itolab/aqua4/lib/python3.6/site-packages'] |
Server time: | 金, 29 3月 2024 06:06:07 +0900 |
/home/itolab/aqua4/lib64/python3.6/site-packages/django/core/handlers/exception.py
in inner
This decorator is automatically applied to all middleware to ensure that
no middleware leaks an exception and that the next middleware in the stack
can rely on getting a response instead of an exception.
"""
@wraps(get_response)
def inner(request):
try:
response = get_response(request)...
except Exception as exc:
response = response_for_exception(request, exc)
return response
return inner
Variable | Value |
---|---|
exc | ZeroDivisionError('division by zero',) |
get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7fbb2fe8cba8>> |
request | <WSGIRequest: GET '/graphs/3/precision'> |
/home/itolab/aqua4/lib64/python3.6/site-packages/django/core/handlers/base.py
in _get_response
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)
except Exception as e:
response = self.process_exception_by_middleware(e, request)...
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
view_name = callback.__name__
else: # CBV
Variable | Value |
---|---|
callback | <function one_prev_view at 0x7fbb0648ea60> |
callback_args | () |
callback_kwargs | {'sen_id': 3} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fbb2de30eb8>> |
request | <WSGIRequest: GET '/graphs/3/precision'> |
resolver | <URLResolver 'mysite.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=graphs.views.one_prev_view, args=(), kwargs={'sen_id': 3}, url_name=one_prev_view, app_names=['graphs'], namespaces=['graphs']) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fbb2fe8cba8> |
wrapped_callback | <function one_prev_view at 0x7fbb0648ea60> |
/home/itolab/aqua4/lib64/python3.6/site-packages/django/core/handlers/base.py
in _get_response
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)...
except Exception as e:
response = self.process_exception_by_middleware(e, request)
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
Variable | Value |
---|---|
callback | <function one_prev_view at 0x7fbb0648ea60> |
callback_args | () |
callback_kwargs | {'sen_id': 3} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fbb2de30eb8>> |
request | <WSGIRequest: GET '/graphs/3/precision'> |
resolver | <URLResolver 'mysite.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=graphs.views.one_prev_view, args=(), kwargs={'sen_id': 3}, url_name=one_prev_view, app_names=['graphs'], namespaces=['graphs']) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fbb2fe8cba8> |
wrapped_callback | <function one_prev_view at 0x7fbb0648ea60> |
./graphs/views.py
in one_prev_view
#地点sen_idのセンサデータを取得
SCRIPT ='(SELECT sen_nodename,sen_areaname,sen_longitude,sen_latitude FROM tblsensor)'
cursor.execute(SCRIPT)
sensor_dataset = cursor.fetchall()
cursor.close()
#データを加工する
dump,error_view = data_make_precision(water_pre_dataset,water_act_dataset,sensor_dataset[sen_id-1],'1日後予測精度')...
#レンダリング
return render(request, 'graphs/pre_errorshow.html', {'chart': dump,'sensor_dataset': sensor_dataset, 'error_view':error_view, 'sensor_name':sensor_dataset[sen_id-1]})
"""
Variable | Value |
---|---|
SCRIPT | '(SELECT sen_nodename,sen_areaname,sen_longitude,sen_latitude FROM tblsensor)' |
cnx | <mysql.connector.connection_cext.CMySQLConnection object at 0x7fbb0610bf60> |
cursor | <mysql.connector.cursor_cext.CMySQLCursor object at 0x7fbb060fc080> |
error_view | [] |
logger | <Logger command (WARNING)> |
now | datetime.datetime(2024, 3, 29, 6, 6, 7, 597609) |
prev_week | '2024/03/22 06:06' |
request | <WSGIRequest: GET '/graphs/3/precision'> |
sen_id | 3 |
sensor_dataset | [('五ヶ所湾 床なぎ', '伊勢志摩エリア', Decimal('136.689100'), Decimal('34.320625')), ('的矢湾 三ケ所', '伊勢志摩エリア', Decimal('136.863852'), Decimal('34.362337')), ('英虞湾 湾奥', '伊勢志摩エリア', Decimal('136.820295'), Decimal('34.303683')), ('英虞湾 湾央', '伊勢志摩エリア', Decimal('136.791292'), Decimal('34.283213')), ('神前浦', '伊勢志摩エリア', Decimal('136.521523'), Decimal('34.262643')), ('間崎', '志摩エリア', Decimal('136.809167'), Decimal('34.284520')), ('和具', '志摩エリア', Decimal('136.818327'), Decimal('34.282102')), ('布施田', '志摩エリア', Decimal('136.819165'), Decimal('34.274969')), ('船越', '志摩エリア', Decimal('136.830149'), Decimal('34.274578')), ('片田', '志摩エリア', Decimal('136.831573'), Decimal('34.269135')), ('旧テストセンサー', 'テストエリア', Decimal('0.000000'), Decimal('0.000000')), ('旧テストセンサーnull', 'テストエリア', Decimal('0.000000'), Decimal('0.000000'))] |
water_act_dataset | [] |
water_pre_dataset | [] |
./graphs/views.py
in data_make_precision
water_pre_1.append(float(entry[5]))
water_pre_2.append(float(entry[6]))
water_pre_3.append(float(entry[7]))
water_pre_4.append(float(entry[8]))
#差の絶対値を全部足して要素数で割ったものを2桁まで丸めている
error_1 = round(sum([abs(x - y) for (x, y) in zip(water_act_1, water_pre_1)])/len(water_pre_1),2)...
error_2 = round(sum([abs(x - y) for (x, y) in zip(water_act_2, water_pre_2)])/len(water_pre_2),2)
error_3 = round(sum([abs(x - y) for (x, y) in zip(water_act_3, water_pre_3)])/len(water_pre_3),2)
error_4 = round(sum([abs(x - y) for (x, y) in zip(water_act_4, water_pre_4)])/len(water_pre_4),2)
error.append(float(error_1))
error.append(float(error_2))
error.append(float(error_3))
Variable | Value |
---|---|
act_date | [] |
act_df | Empty DataFrame Columns: [date, water_act_1, water_act_2, water_act_3, water_act_4] Index: [] |
act_time | [] |
df | Empty DataFrame Columns: [water_act_1, water_act_2, water_act_3, water_act_4, date, water_pre_1, water_pre_2, water_pre_3, water_pre_4] Index: [] |
error | [] |
mode | '1日後予測精度' |
pre_df | Empty DataFrame Columns: [date, water_pre_1, water_pre_2, water_pre_3, water_pre_4] Index: [] |
sensor_dataset | ('英虞湾 湾奥', '伊勢志摩エリア', Decimal('136.820295'), Decimal('34.303683')) |
water_act_1 | [] |
water_act_2 | [] |
water_act_3 | [] |
water_act_4 | [] |
water_act_dataset | [] |
water_combined_dataset | [] |
water_pre_1 | [] |
water_pre_2 | [] |
water_pre_3 | [] |
water_pre_4 | [] |
water_pre_dataset | [] |
AnonymousUser
No GET data
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
CONTENT_LENGTH | '' |
CONTENT_TYPE | '' |
DOCUMENT_ROOT | '/etc/nginx/html' |
HTTP_ACCEPT | '*/*' |
HTTP_HOST | 'fresno.otsukalab.nitech.ac.jp' |
HTTP_USER_AGENT | 'claudebot' |
PATH_INFO | '/graphs/3/precision' |
QUERY_STRING | '' |
REMOTE_ADDR | '3.226.254.255' |
REMOTE_PORT | '33166' |
REQUEST_METHOD | 'GET' |
REQUEST_SCHEME | 'http' |
REQUEST_URI | '/graphs/3/precision' |
SCRIPT_NAME | '' |
SERVER_NAME | 'fresno.otsukalab.nitech.ac.jp' |
SERVER_PORT | '80' |
SERVER_PROTOCOL | 'HTTP/1.1' |
uwsgi.node | b'localhost.localdomain' |
uwsgi.version | b'2.0.17.1' |
wsgi.errors | <_io.TextIOWrapper name=2 mode='w' encoding='UTF-8'> |
wsgi.file_wrapper | '' |
wsgi.input | <uwsgi._Input object at 0x7fbb04cd4a68> |
wsgi.multiprocess | True |
wsgi.multithread | False |
wsgi.run_once | False |
wsgi.url_scheme | 'http' |
wsgi.version | (1, 0) |
mysite.settings
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ADMINS | [] |
ALLOWED_HOSTS | ['fresno.otsukalab.nitech.ac.jp', '133.68.31.24'] |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
AUTH_PASSWORD_VALIDATORS | '********************' |
AUTH_USER_MODEL | 'auth.User' |
BASE_DIR | '/home/itolab/aqua4/mysite' |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CSRF_COOKIE_AGE | 31449600 |
CSRF_COOKIE_DOMAIN | None |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_NAME | 'csrftoken' |
CSRF_COOKIE_PATH | '/' |
CSRF_COOKIE_SAMESITE | 'Lax' |
CSRF_COOKIE_SECURE | False |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
CSRF_TRUSTED_ORIGINS | [] |
CSRF_USE_SESSIONS | False |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.mysql', 'HOST': '', 'NAME': 'djangodb', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '3306', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'itolab'}} |
DATABASE_ROUTERS | [] |
DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
DATA_UPLOAD_MAX_NUMBER_FIELDS | 1000 |
DATETIME_FORMAT | 'N j, Y, P' |
DATETIME_INPUT_FORMATS | ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y'] |
DATE_FORMAT | 'N j, Y' |
DATE_INPUT_FORMATS | ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y'] |
DEBUG | True |
DEBUG_PROPAGATE_EXCEPTIONS | False |
DECIMAL_SEPARATOR | '.' |
DEFAULT_CHARSET | 'utf-8' |
DEFAULT_CONTENT_TYPE | 'text/html' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
EMAIL_HOST | 'localhost' |
EMAIL_HOST_PASSWORD | '********************' |
EMAIL_HOST_USER | '' |
EMAIL_PORT | 25 |
EMAIL_SSL_CERTFILE | None |
EMAIL_SSL_KEYFILE | '********************' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_TIMEOUT | None |
EMAIL_USE_LOCALTIME | False |
EMAIL_USE_SSL | False |
EMAIL_USE_TLS | False |
FILE_CHARSET | 'utf-8' |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
FILE_UPLOAD_PERMISSIONS | None |
FILE_UPLOAD_TEMP_DIR | None |
FIRST_DAY_OF_WEEK | 0 |
FIXTURE_DIRS | [] |
FORCE_SCRIPT_NAME | None |
FORMAT_MODULE_PATH | None |
FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
IGNORABLE_404_URLS | [] |
INSTALLED_APPS | ['accounts.apps.AccountsConfig', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrapform', 'bootstrap4', 'crud', 'graphs'] |
INTERNAL_IPS | [] |
LANGUAGES | [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')] |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
LANGUAGE_CODE | 'ja' |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_COOKIE_DOMAIN | None |
LANGUAGE_COOKIE_NAME | 'django_language' |
LANGUAGE_COOKIE_PATH | '/' |
LOCALE_PATHS | [] |
LOGGING | {} |
LOGGING_CONFIG | 'logging.config.dictConfig' |
LOGIN_REDIRECT_URL | '/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_REDIRECT_URL | None |
MANAGERS | [] |
MEDIA_ROOT | '' |
MEDIA_URL | '' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
MIDDLEWARE | ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] |
MIGRATION_MODULES | {} |
MONTH_DAY_FORMAT | 'F j' |
NUMBER_GROUPING | 0 |
PASSWORD_HASHERS | '********************' |
PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
PREPEND_WWW | False |
ROOT_URLCONF | 'mysite.urls' |
SECRET_KEY | '********************' |
SECURE_BROWSER_XSS_FILTER | False |
SECURE_CONTENT_TYPE_NOSNIFF | False |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
SECURE_HSTS_PRELOAD | False |
SECURE_HSTS_SECONDS | 0 |
SECURE_PROXY_SSL_HEADER | None |
SECURE_REDIRECT_EXEMPT | [] |
SECURE_SSL_HOST | None |
SECURE_SSL_REDIRECT | False |
SERVER_EMAIL | 'root@localhost' |
SESSION_CACHE_ALIAS | 'default' |
SESSION_COOKIE_AGE | 1209600 |
SESSION_COOKIE_DOMAIN | None |
SESSION_COOKIE_HTTPONLY | True |
SESSION_COOKIE_NAME | 'sessionid' |
SESSION_COOKIE_PATH | '/' |
SESSION_COOKIE_SAMESITE | 'Lax' |
SESSION_COOKIE_SECURE | False |
SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
SESSION_FILE_PATH | None |
SESSION_SAVE_EVERY_REQUEST | False |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
SETTINGS_MODULE | 'mysite.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SILENCED_SYSTEM_CHECKS | [] |
STATICFILES_DIRS | ('static',) |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '' |
STATIC_URL | '/static/' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/home/itolab/aqua4/mysite/templates'], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}}] |
TEST_NON_SERIALIZED_APPS | [] |
TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
THOUSAND_SEPARATOR | ',' |
TIME_FORMAT | 'P' |
TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
TIME_ZONE | 'Asia/Tokyo' |
USE_I18N | True |
USE_L10N | True |
USE_THOUSAND_SEPARATOR | False |
USE_TZ | True |
USE_X_FORWARDED_HOST | False |
USE_X_FORWARDED_PORT | False |
WSGI_APPLICATION | 'mysite.wsgi.application' |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
YEAR_MONTH_FORMAT | 'F Y' |
You're seeing this error because you have DEBUG = True
in your
Django settings file. Change that to False
, and Django will
display a standard page generated by the handler for this status code.