Closed missyschoenbaum closed 4 years ago
OK, I see where active session is. I will try deleting it.
That didn't fix it.
I've gotten this error before but have never been able to track it down... restarting my device seems to be the most reliable way to fix the error. I think it may have something to do with other programs having the database open and conflicting with ADSM. Did you have SQLite open or something else that may have been accessing the database when you started the app?
Well, I don't think I had something open, but maybe I am wrong. It did recover itself this morning, so I better get back to work!
Like I said, I've run into this before. We should watch out for this happening in the future and see if there is a common denominator over all occurrences.
I hit this again while working on PDF import code.
OK, tried deleting Active Session, tried overwriting Active session with a sample scenario, restarted PC.
Request Method: | GET |
---|
http://127.0.0.1:50861/setup/Scenario/1/ 1.8.2 AccessDenied (pid=11176) C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\ADSM_Beta.exe 3.4.2 ['C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\ADSM_Beta.exe', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\ADSM_Beta.zip', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\library.zip', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\bin', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9\bin\env', 'C:\Users\MeSchoenbaum\Desktop\ADSM_Beta_2019_12_9'] Fri, 21 Feb 2020 21:22:08 +0000 Request information GET No GET data POST No POST data FILES No FILES data Cookies
Variable | Value |
---|---|
sessionid | '1jok6gg21ptoo9w3dman52ed79lswykc' |
META
wsgi.multiprocess | False |
---|---|
HTTP_X_REAL_IP | '127.0.0.1' |
SERVER_NAME | '127.0.0.1' |
HTTP_ACCEPT_ENCODING | 'gzip, deflate, br' |
HTTP_USER_AGENT | 'Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/75.0.3770.100 Safari/537.36' |
HTTP_UPGRADE_INSECURE_REQUESTS | '1' |
HTTP_CONNECTION | 'close' |
wsgi.multithread | True |
wsgi.errors | <_io.TextIOWrapper name=' |
HTTP_ACCEPT_LANGUAGE | 'en-US,en;q=0.9' |
wsgi.input | <cherrypy.wsgiserver.wsgiserver3.KnownLengthRFile object at 0x000000000B999DA0> |
wsgi.run_once | False |
REQUEST_METHOD | 'GET' |
wsgi.url_scheme | 'http' |
SCRIPT_NAME | '' |
HTTP_X_FORWARDED_FOR | '127.0.0.1' |
HTTP_HOST | '127.0.0.1:50861' |
wsgi.version | (1, 0) |
ACTUAL_SERVER_PROTOCOL | 'HTTP/1.1' |
SERVER_PROTOCOL | 'HTTP/1.0' |
HTTP_ACCEPT | 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3' |
REMOTE_PORT | '50883' |
REQUEST_URI | '/setup/Scenario/1/' |
PATH_INFO | '/setup/Scenario/1/' |
HTTP_COOKIE | 'sessionid=1jok6gg21ptoo9w3dman52ed79lswykc' |
SERVER_SOFTWARE | 'CherryPy/3.6.0 Server' |
REMOTE_ADDR | '127.0.0.1' |
QUERY_STRING | '' |
SERVER_PORT | '50862' |
HTTP_REFERER | 'http://127.0.0.1:50861/LoadingScreen/?loading_url=/app/Startup/' |
I think we'll need to talk over this one in our next meeting.
It appears to be working today...hummm
Could we possibly create a utility that will detect what other process could be accessing the database?
I cannot get this to replicate no matter how many different ways I open my DB file in another program.
Without seeing it happen, I can't tell exactly what point in the code it fails and how to notify the user in a better way.
I think we just need to write good documentation around AccessDenied.
Known bug is posted. Will reopen if we learn more details on conflict.
Just adding to comments. Got this while testing Prod. Nothing else open. Took a screenshot of pop map, and then hit return to inputs.
Request Method: | GET |
---|
http://127.0.0.1:58954/setup/OutputSettings/1/ 1.8.2 AccessDenied (pid=17568) C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\ADSM.exe 3.4.2 ['C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\ADSM.exe', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\ADSM.zip', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\library.zip', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\bin', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App\bin\env', 'C:\Users\MeSchoenbaum\Desktop\ADSMPROD_2020_7_15 App'] Mon, 20 Jul 2020 19:00:54 +0000
REQUEST_METHOD | 'GET' |
---|---|
wsgi.url_scheme | 'http' |
ACTUAL_SERVER_PROTOCOL | 'HTTP/1.1' |
wsgi.multithread | True |
wsgi.multiprocess | False |
HTTP_CONNECTION | 'close' |
HTTP_ACCEPT_ENCODING | 'gzip, deflate, br' |
HTTP_X_FORWARDED_FOR | '127.0.0.1' |
SERVER_PROTOCOL | 'HTTP/1.0' |
REQUEST_URI | '/setup/OutputSettings/1/' |
SCRIPT_NAME | '' |
wsgi.version | (1, 0) |
PATH_INFO | '/setup/OutputSettings/1/' |
QUERY_STRING | '' |
SERVER_SOFTWARE | 'CherryPy/3.6.0 Server' |
REMOTE_PORT | '60722' |
HTTP_REFERER | 'http://127.0.0.1:58954/results/' |
HTTP_ACCEPT | 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3' |
HTTP_ACCEPT_LANGUAGE | 'en-US,en;q=0.9' |
wsgi.errors | <_io.TextIOWrapper name=' |
HTTP_HOST | '127.0.0.1:58954' |
SERVER_PORT | '58955' |
wsgi.run_once | False |
SERVER_NAME | '127.0.0.1' |
HTTP_UPGRADE_INSECURE_REQUESTS | '1' |
HTTP_X_REAL_IP | '127.0.0.1' |
wsgi.input | <cherrypy.wsgiserver.wsgiserver3.KnownLengthRFile object at 0x00000000050A3B38> |
REMOTE_ADDR | '127.0.0.1' |
HTTP_USER_AGENT | 'Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/75.0.3770.100 Safari/537.36' |
Not leaving open
If I was in Prod, I would just delete the active session and try again to see if it would rebuild. However, I don't know where the active session lives in Beta.
AccessDenied at /setup/Scenario/1/ (pid=4936) Request Method: GET Request URL: http://127.0.0.1:53340/setup/Scenario/1/ Django Version: 1.8.2 Exception Type: AccessDenied Exception Value:
(pid=4936) 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: Fri, 21 Jun 2019 21:07:54 +0000
HTTP_REFERER
<_io.TextIOWrapper name=''http://127.0.0.1:53340/LoadingScreen/?loading_url=/app/Startup/' HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/39.0.2171.95 Safari/537.36' PATH_INFO
'/setup/Scenario/1/' wsgi.input
<cherrypy.wsgiserver.wsgiserver3.KnownLengthRFile object at 0x000000000BB34978> wsgi.multiprocess
False ACTUAL_SERVER_PROTOCOL
'HTTP/1.1' SERVER_SOFTWARE 'CherryPy/3.6.0 Server' SERVER_NAME '127.0.0.1' SERVER_PROTOCOL 'HTTP/1.0' REMOTE_ADDR '127.0.0.1' QUERY_STRING
'' SCRIPT_NAME '' wsgi.errors