search

NAVADMC / ADSM

A simulation of disease spread in livestock populations. Includes detection and containment simulation.
Other
10 stars 5 forks source link

User moves too fast #685

Closed missyschoenbaum closed 9 years ago

missyschoenbaum commented 9 years ago

3.3.6.2 When I navigate quickly between related program areas, I can move fast enough to lock the database. This will likely be resolved within the Performance Issues ticket

OperationalError at /setup/AssignSpreads/ database is locked Request Method: GET Request URL: http://127.0.0.1:8000/setup/AssignSpreads/ Django Version: 1.8.2 Exception Type: OperationalError Exception Value:
database is locked Python Executable: C:\Users\meschoenbaum\Desktop\ADSM_9_16\ADSM_Beta.exe Python Version: 3.4.2 Python Path:
['C:\Users\meschoenbaum\Desktop\ADSM_9_16\ADSM_Beta.exe', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\ADSM_Beta.zip', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\library.zip', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\bin', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\bin\env', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16'] Server time: Thu, 19 Nov 2015 16:55:55 +0000 Request information

GET No GET data POST No POST data FILES No FILES data COOKIES No cookie data META Variable Value wsgi.input
<cherrypy.wsgiserver.wsgiserver3.KnownLengthRFile object at 0x00000000128C1208> wsgi.version
(1, 0) SERVER_NAME '127.0.0.1' REQUEST_URI '/setup/AssignSpreads/' wsgi.run_once
False wsgi.multiprocess
False SCRIPT_NAME '' REMOTE_PORT '49266' SERVER_PORT '8001' SERVER_SOFTWARE 'CherryPy/3.6.0 Server' HTTPACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/_;q=0.8' QUERY_STRING
'' HTTP_HOST
'127.0.0.1:8000' HTTP_ACCEPT_LANGUAGE
'en-us,en;q=0.8' HTTP_X_REAL_IP
'127.0.0.1' SERVER_PROTOCOL 'HTTP/1.0' HTTP_X_FORWARDED_FOR
'127.0.0.1' wsgi.multithread
True HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/39.0.2171.95 Safari/537.36' wsgi.errors

<_io.TextIOWrapper name='' mode='w' encoding='cp437'> wsgi.url_scheme 'http' PATH_INFO '/setup/AssignSpreads/' REQUEST_METHOD 'GET' HTTP_ACCEPT_ENCODING 'gzip, deflate' REMOTE_ADDR '127.0.0.1' HTTP_REFERER 'http://127.0.0.1:8000/setup/DiseaseSpread/' ACTUAL_SERVER_PROTOCOL 'HTTP/1.1' HTTP_CONNECTION 'close' Settings Using settings module ADSM.settings Setting Value EMAIL_HOST 'localhost' CSRF_COOKIE_SECURE False SHORT_DATETIME_FORMAT 'm/d/Y P' DEFAULT_FILE_STORAGE 'django.core.files.storage.FileSystemStorage' INTERNAL_IPS () DEFAULT_INDEX_TABLESPACE '' SESSION_COOKIE_NAME 'sessionid' OVERRIDE_DEBUG False ABSOLUTE_URL_OVERRIDES {} PASSWORD_HASHERS '*******************_' EMAIL_USE_TLS False X_FRAME_OPTIONS 'SAMEORIGIN' SESSION_SERIALIZER 'django.contrib.sessions.serializers.JSONSerializer' DEFAULT_CONTENT_TYPE 'text/html' LANGUAGE_COOKIE_DOMAIN None CRISPY_TEMPLATE_PACK 'bootstrap' LOCALE_PATHS () SIGNING_BACKEND 'django.core.signing.TimestampSigner' ALLOWED_HOSTS [] SILENCED_SYSTEM_CHECKS [] EMAIL_HOST_USER '' ROOT_URLCONF 'ADSM.urls' 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') CSRF_FAILURE_VIEW 'django.views.csrf.csrf_failure' CACHES {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} DISALLOWED_USER_AGENTS () USE_L10N True DEFAULT_FROM_EMAIL 'noreply@development.server' FILE_UPLOAD_DIRECTORY_PERMISSIONS None SESSION_COOKIE_SECURE False SESSION_EXPIRE_AT_BROWSER_CLOSE False SECURE_CONTENT_TYPE_NOSNIFF False EMAIL_PORT 25 SESSION_COOKIE_AGE 1209600 SECURE_REDIRECT_EXEMPT [] USE_ETAGS False LOGGING_CONFIG 'logging.config.dictConfig' LOGGING {} SECURE_BROWSER_XSS_FILTER False FILE_CHARSET 'utf-8' EMAIL_SUBJECT_PREFIX '[Django] ' TEMPLATE_DIRS () EMAIL_USE_SSL False TIME_ZONE 'UTC' SECURE_SSL_REDIRECT False SESSION_COOKIE_HTTPONLY True MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage' CACHE_MIDDLEWARE_SECONDS 600 DEBUG True 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'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian 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'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('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 Bokmal'), ('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-cn', 'Simplified Chinese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese'), ('zh-tw', 'Traditional Chinese')) PASSWORD_RESET_TIMEOUT_DAYS '**_****************_' SECURE_HSTS_SECONDS 0 CSRF_COOKIE_HTTPONLY False CSRF_COOKIE_PATH '/' USE_THOUSAND_SEPARATOR False SHORT_DATE_FORMAT 'm/d/Y' DB_BASE_DIR 'C:\Users\meschoenbaum\Documents\ADSM Workspace\settings' STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage' BASE_DIR 'C:\Users\meschoenbaum\Desktop\ADSM_9_16' EMAIL_HOST_PASSWORD '**_****************_' DEFAULT_CHARSET 'utf-8' EMAIL_SSL_CERTFILE None MEDIA_URL '/media/' OS_DIR 'windows' TEMPLATE_LOADERS ('django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader') LANGUAGE_COOKIE_AGE None LOGOUT_URL '/accounts/logout/' 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') DEFAULT_TABLESPACE '' LOGIN_URL '/accounts/login/' EMAIL_SSL_KEYFILE '**_****************_' APPEND_SLASH True MEDIA_ROOT 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\media' LANGUAGES_BIDI ('he', 'ar', 'fa', 'ur') DEBUG_PROPAGATE_EXCEPTIONS False PREPEND_WWW False AUTHENTICATION_BACKENDS ('django.contrib.auth.backends.ModelBackend',) SESSION_ENGINE 'django.contrib.sessions.backends.db' MANAGERS () TIME_INPUT_FORMATS ('%H:%M:%S', '%H:%M:%S.%f', '%H:%M') TEST_NON_SERIALIZED_APPS [] USE_X_FORWARDED_HOST False SECURE_HSTS_INCLUDE_SUBDOMAINS False STATICFILES_DIRS ('C:\Users\meschoenbaum\Desktop\ADSM_9_16\ADSM\static',) THOUSAND_SEPARATOR ',' EMAIL_BACKEND 'django.core.mail.backends.console.EmailBackend' FILE_UPLOAD_MAX_MEMORY_SIZE 2621440 STATIC_ROOT 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\static' CSRF_COOKIE_DOMAIN None SESSION_SAVE_EVERY_REQUEST False CSRF_COOKIE_AGE 31449600 DATABASE_ROUTERS ['ScenarioCreator.router.ScenarioRouter'] TEMPLATE_STRING_IF_INVALID '' FILE_UPLOAD_PERMISSIONS None FILE_UPLOAD_TEMP_DIR None YEAR_MONTH_FORMAT 'F Y' DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter' USE_I18N False TIME_FORMAT 'P' DATE_FORMAT 'N j, Y' TEMPLATE_CONTEXT_PROCESSORS ('django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages') SECRET_KEY '**_****************_' SETTINGS_MODULE 'ADSM.settings' ALLOWED_INCLUDE_ROOTS () FIXTURE_DIRS () AUTH_USER_MODEL 'auth.User' USE_TZ True LANGUAGE_COOKIE_NAME 'django_language' TEMPLATES [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['C:\Users\meschoenbaum\Desktop\ADSM_9_16\ADSM\templates', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\ScenarioCreator', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\Results', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\ADSMSettings', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\django.contrib.admin', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\django.contrib.auth', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\floppyforms', 'C:\Users\meschoenbaum\Desktop\ADSM_9_16\templates\crispy_forms'], 'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.core.context_processors.static', 'django.core.context_processors.tz', 'django.contrib.messages.context_processors.messages', 'django.core.context_processors.request', 'ADSMSettings.context_processor.adsm_context', 'ScenarioCreator.context_processor.basic_context', 'Results.context_processor.results_context']}}] DECIMAL_SEPARATOR '.' CACHE_MIDDLEWARE_ALIAS 'default' EXTENSION '.exe' FIRST_DAY_OF_WEEK 0 MIDDLEWARE_CLASSES ('django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'ADSMSettings.disable.DisableCSRF') WORKSPACE_PATH 'C:\Users\meschoenbaum\Documents\ADSM Workspace' NUMBER_GROUPING 0 LOGIN_REDIRECT_URL '/' CSRF_COOKIE_NAME 'csrftoken' INSTALLED_APPS ('ScenarioCreator', 'Results', 'ADSMSettings', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.humanize', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'floppyforms', 'crispy_forms', 'productionserver') SESSION_COOKIE_PATH '/' SECURE_PROXY_SSL_HEADER None STATIC_URL '/static/' ADMINS () TEMPLATE_DEBUG True IGNORABLE_404_URLS () LANGUAGE_CODE 'en-us' EMAIL_TIMEOUT None SESSION_FILE_PATH None DATETIME_FORMAT 'N j, Y, P' DATABASES {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.sqlite3', 'HOST': '', 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\settings\settings.sqlite3', 'OPTIONS': {}, 'PASSWORD': '**_****************_', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\settings\test_settings.sqlite3'}, 'TIME_ZONE': 'UTC', 'USER': ''}, 'import_db': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.sqlite3', 'HOST': '', 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\missyTexas.sqlite3', 'OPTIONS': {'timeout': 300}, 'PASSWORD': '**_****************_', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\missyTexas.sqlite3'}, 'TIME_ZONE': 'UTC', 'USER': ''}, 'scenario_db': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.sqlite3', 'HOST': '', 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\settings\activeSession.sqlite3', 'OPTIONS': {'timeout': 300}, 'PASSWORD': '**_****************_', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': 'C:\Users\meschoenbaum\Documents\ADSM ' 'Workspace\settings\test_activeSession.sqlite3'}, 'TIME_ZONE': 'UTC', 'USER': ''}} CSIDL_PERSONAL 5 TEST_RUNNER 'django.test.runner.DiscoverRunner' LANGUAGE_COOKIE_PATH '/' SESSION_COOKIE_DOMAIN None MONTH_DAY_FORMAT 'F j' SECURE_SSL_HOST None CACHE_MIDDLEWARE_KEY_PREFIX '**_*****************' FORCE_SCRIPT_NAME None STATICFILES_FINDERS ('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder') PRODUCTION_SETTINGS False SERVER_EMAIL 'server@development.server' FORMAT_MODULE_PATH None FILE_UPLOAD_HANDLERS ('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler') SESSION_CACHE_ALIAS 'default' MIGRATION_MODULES {} WSGI_APPLICATION 'ADSM.wsgi.application' SHGFP_TYPE_CURRENT 0 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.
missyschoenbaum commented 9 years ago

682