[RESOLU] ID-SI : Message "Exception Value: database is locked"

Messages

Par Christophe Bertrand le 06/04/2017 à 17:01
Bonjour,

Nous n’arrivons plus à accéder aux données des établissements dont nous avons importé les données.

Nous pouvons toujours accéder à nos données et aux restitutions ..

Pouvez-vous m'aider ?



Ci dessous le message d'erreur ..



-------------------------------------------



OperationalError at /gestion/principal/3193e25c-2b1a-4faa-9918-61f9bd363396

database is locked





Request Method:

GET



Request URL:

http://localhost:8000/gestion/principal/3193e25c-2b1a-4faa-9918-61f9bd363396?redirect_url=/restitution/simple/informations_generales/



Django Version:

1.8.4



Exception Type:

OperationalError



Exception Value:

database is locked





Python Executable:

I:\ECHANGE\id-si\id-si.exe



Python Version:

3.4.4



Python Path:

['I:\\ECHANGE\\id-si\\base_library.zip', 'I:\\ECHANGE\\id-si']





Server time:

jeu, 6 Avr 2017 16:58:09 +0200





Request information



GET





Variable



Value





redirect_url '/restitution/simple/informations_generales/'





POST



No POST data



FILES



No FILES data



COOKIES





Variable



Value





csrftoken 'H6OnB45PMT7YH2rcJCncZegBoCdXS8ct'





META





Variable



Value





wsgi.version (1, 0)



HTTP_ACCEPT_LANGUAGE 'fr-FR'



wsgi.run_once False



SERVER_NAME 'P1213.hus.chru-strasbourg.fr'



wsgi.input <_io.BytesIO object at 0x03AC1650>



HTTP_REFERER 'http://localhost:8000/restitution/simple/informations_generales/?synthese=t'



REMOTE_ADDR '127.0.0.1'



HTTP_CONNECTION 'Keep-Alive'



wsgi.url_scheme 'http'



wsgi.multithread True



wsgi.errors <_io.TextIOWrapper name='' mode='w' encoding='cp850'>



HTTP_ACCEPT_ENCODING 'gzip, deflate'



PATH_INFO '/gestion/principal/3193e25c-2b1a-4faa-9918-61f9bd363396'



SERVER_SOFTWARE 'waitress'



HTTP_COOKIE 'csrftoken=H6OnB45PMT7YH2rcJCncZegBoCdXS8ct'



CSRF_COOKIE 'H6OnB45PMT7YH2rcJCncZegBoCdXS8ct'



HTTP_ACCEPT 'text/html, application/xhtml+xml, */*'



REQUEST_METHOD 'GET'



SCRIPT_NAME ''



QUERY_STRING 'redirect_url=/restitution/simple/informations_generales/'



SERVER_PORT '8000'



HTTP_HOST 'localhost:8000'



wsgi.multiprocess False



wsgi.file_wrapper ''



HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko'



SERVER_PROTOCOL 'HTTP/1.1'





Settings



Using settings module anap.settings





Setting



Value





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')



SILENCED_SYSTEM_CHECKS []



ADMINS ()



SESSION_COOKIE_PATH '/'



SESSION_COOKIE_SECURE False



EMAIL_USE_TLS False



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')



LANGUAGE_CODE 'fr-fr'



EMAIL_HOST_USER ''



IGNORABLE_404_URLS ()



LOGOUT_URL '/accounts/logout/'



MIDDLEWARE_CLASSES ('django.middleware.common.CommonMiddleware',

'django.middleware.csrf.CsrfViewMiddleware',

'django.middleware.clickjacking.XFrameOptionsMiddleware',

'django.middleware.security.SecurityMiddleware')



TIME_FORMAT 'P'



FILE_CHARSET 'utf-8'



USE_ETAGS False



AUTHENTICATION_BACKENDS ('django.contrib.auth.backends.ModelBackend',)



X_FRAME_OPTIONS 'SAMEORIGIN'



PREPEND_WWW False



FILE_UPLOAD_PERMISSIONS None



DEBUG_PROPAGATE_EXCEPTIONS False



ALLOWED_INCLUDE_ROOTS ()



CACHES {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}



FILE_UPLOAD_TEMP_DIR None



MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage'



THOUSAND_SEPARATOR ','



DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter'



SECURE_CONTENT_TYPE_NOSNIFF False



DEFAULT_CONTENT_TYPE 'text/html'



ROOT_URLCONF 'anap.urls'



SESSION_FILE_PATH None



DEFAULT_TABLESPACE ''



SESSION_CACHE_ALIAS 'default'



TEST_RUNNER 'django.test.runner.DiscoverRunner'



SESSION_COOKIE_DOMAIN None



DATETIME_FORMAT 'N j, Y, P'



WSGI_APPLICATION 'anap.wsgi.application'



EMAIL_SUBJECT_PREFIX '­[Django]­ '



YEAR_MONTH_FORMAT 'F Y'



TIME_INPUT_FORMATS ('%H:%M:%S', '%H:%M:%S.%f', '%H:%M')



SESSION_COOKIE_AGE 1209600



FIRST_DAY_OF_WEEK 0



SECURE_SSL_HOST None



DECIMAL_SEPARATOR '.'



EMAIL_USE_SSL False



INTERNAL_IPS ()



EMAIL_HOST_PASSWORD '********************'



FILE_UPLOAD_MAX_MEMORY_SIZE 2621440



FIXTURE_DIRS ()



INSTALLED_APPS ('django.contrib.contenttypes',

'django.contrib.staticfiles',

'rest_framework',

'mesis',

'widget_tweaks')



CACHE_MIDDLEWARE_ALIAS 'default'



LANGUAGE_COOKIE_DOMAIN None



USE_I18N True



SESSION_ENGINE 'django.contrib.sessions.backends.db'



APPEND_SLASH True



EMAIL_SSL_KEYFILE '********************'



USE_TZ True



PASSWORD_HASHERS '********************'



TEMPLATE_STRING_IF_INVALID ''



FILE_UPLOAD_DIRECTORY_PERMISSIONS None



MEDIA_ROOT ''



LOGGING {}



PASSWORD_RESET_TIMEOUT_DAYS '********************'



CSRF_COOKIE_DOMAIN None



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'))



STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage'



MANAGERS ()



CSRF_COOKIE_HTTPONLY False



SECURE_REDIRECT_EXEMPT []



CSRF_COOKIE_SECURE False



SETTINGS_MODULE 'anap.settings'



LANGUAGES_BIDI ('he', 'ar', 'fa', 'ur')



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')



TIME_ZONE 'Europe/Paris'



STATICFILES_FINDERS ('django.contrib.staticfiles.finders.FileSystemFinder',

'django.contrib.staticfiles.finders.AppDirectoriesFinder')



LOCALE_PATHS ()



DEFAULT_FROM_EMAIL 'webmaster@localhost'



FORMAT_MODULE_PATH None



DEBUG True



BASE_DIR 'I:\\ECHANGE\\id-si'



SECURE_PROXY_SSL_HEADER None



EMAIL_SSL_CERTFILE None



MIGRATION_MODULES {}



SIGNING_BACKEND 'django.core.signing.TimestampSigner'



DEFAULT_CHARSET 'utf-8'



NUMBER_GROUPING 0



SHORT_DATE_FORMAT 'm/d/Y'



DEFAULT_INDEX_TABLESPACE ''



SECURE_HSTS_INCLUDE_SUBDOMAINS False



SESSION_COOKIE_HTTPONLY True



SESSION_COOKIE_NAME 'sessionid'



MONTH_DAY_FORMAT 'F j'



SESSION_SERIALIZER 'django.contrib.sessions.serializers.JSONSerializer'



STATIC_ROOT 'staticfiles'



CSRF_COOKIE_NAME 'csrftoken'



FORCE_SCRIPT_NAME None



SECURE_SSL_REDIRECT False



STATICFILES_DIRS ['I:\\ECHANGE\\id-si\\static']



TEST_NON_SERIALIZED_APPS []



SESSION_EXPIRE_AT_BROWSER_CLOSE False



EMAIL_HOST 'localhost'



TEMPLATES [{'APP_DIRS': True,

'BACKEND': 'django.template.backends.django.DjangoTemplates',

'DIRS': [],

'OPTIONS': {'context_processors': ['django.template.context_processors.debug',

'django.template.context_processors.request',

'mesis.context_processors.liste_hopitaux']}}]



EMAIL_BACKEND 'django.core.mail.backends.smtp.EmailBackend'



DATABASES {'default': {'ATOMIC_REQUESTS': False,

'AUTOCOMMIT': True,

'CONN_MAX_AGE': 0,

'ENGINE': 'django.db.backends.sqlite3',

'HOST': '',

'NAME': 'I:\\ECHANGE\\id-si\\prod.sqlite3',

'OPTIONS': {},

'PASSWORD': '********************',

'PORT': '',

'TEST': {'CHARSET': None,

'COLLATION': None,

'MIRROR': None,

'NAME': None},

'TIME_ZONE': 'UTC',

'USER': ''}}



SECRET_KEY '********************'



SHORT_DATETIME_FORMAT 'm/d/Y P'



LOGIN_URL '/accounts/login/'



CSRF_COOKIE_AGE 31449600



LANGUAGE_COOKIE_NAME 'django_language'



ABSOLUTE_URL_OVERRIDES {}



EMAIL_PORT 25



LANGUAGE_COOKIE_AGE None



CSRF_COOKIE_PATH '/'



TEMPLATE_DEBUG False



STATIC_URL '/static/'



TEMPLATE_DIRS ()



FILE_UPLOAD_HANDLERS ('django.core.files.uploadhandler.MemoryFileUploadHandler',

'django.core.files.uploadhandler.TemporaryFileUploadHandler')



USE_THOUSAND_SEPARATOR False



SECURE_HSTS_SECONDS 0



SESSION_SAVE_EVERY_REQUEST False



DATABASE_ROUTERS []



CSRF_FAILURE_VIEW 'django.views.csrf.csrf_failure'



USE_X_FORWARDED_HOST False



DISALLOWED_USER_AGENTS ()



MEDIA_URL ''



AUTH_USER_MODEL 'auth.User'



SECURE_BROWSER_XSS_FILTER False



SERVER_EMAIL 'root@localhost'



TEMPLATE_LOADERS ('django.template.loaders.filesystem.Loader',

'django.template.loaders.app_directories.Loader')



DATE_FORMAT 'N j, Y'



EMAIL_TIMEOUT None



DEFAULT_FILE_STORAGE 'django.core.files.storage.FileSystemStorage'



USE_L10N True



ALLOWED_HOSTS ['*']



LOGIN_REDIRECT_URL '/accounts/profile/'



LOGGING_CONFIG 'logging.config.dictConfig'



LANGUAGE_COOKIE_PATH '/'



CACHE_MIDDLEWARE_SECONDS 600



CACHE_MIDDLEWARE_KEY_PREFIX '********************'­
Par Christophe Bertrand le 12/04/2017 à 08:59
Pour info, le problème est clos.

Un de nos DBA avait gardé la base ouverte dans SQLite Browser ..­
Par METTY MAVOUNIA le 13/04/2017 à 15:27 Animateur de groupes
Merci de votre réponse !



Bien cordialement,­