Re: PGAdmin 4 fatal error after enabling the import logging

- The screen print is tiny.
- The PgAdmin mailing list will have better support.
https://www.pgadmin.org/support/list/

On 10/12/22 19:14, Chun Fan Lin wrote:
>
> Hello,
>
>   I encountered a fatal error while I tried to enable import logging in
> PGAdmin 4. I would be very grateful if you can give me any advice or
> suggestions.
>
> *Background:*
>
> I installed Postgres 14 and PGAdmin 4 on Windows Server 2019.
>
> *How to create the problem:*
>
> I followed the instructions on Postgres 4 FAQ to enable the import
> logging. This instruction - https://www.pgadmin.org/faq/#8
>
> The instruction said to create a python file and placed it under
> \PostgreSQL\14\pgAdmin 4\web.
>
> I copied the syntax on FAQ page and created config_local.py (where the
> logging level is set to “DEBUG”), and I placed the file in the above
> mentioned folder.
>
> But afterwards, when I try to launch PGAdmin 4, it is failing to launch
> with a fatal error. And it looks like Postgres also can’t start up at all.
>
> *What have I tried to troubleshoot and fix the problem:*
>
> As a test, I changed the logging level in config_local.py to NOSET, it is
> also causing the error.
>
> I also deleted all files under
> C:\Users\%USERNAME%\AppData\Roaming\pgAdmin\sessions, but the error
> persists when I launch PGADMIN 4.
>
> The only way to resolve the error is to delete all the syntaxes in
> config_local.py, or delete config_local.py from the folder altogether.
>
> I tried and searched the archive in the general community, but I couldn’t
> find a matching the record - https://www.postgresql.org/list/pgsql-general/
>
> *The error message: *
>
> This is the error I am seeing:
>
> The full stack for the fatal error is:
>
> /pgAdmin Runtime Environment/
>
> /--------------------------------------------------------/
>
> /Python Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\python\python.exe"/
>
> /Runtime Config File:
> "C:\Users\Administrator\AppData\Roaming\pgadmin\runtime_config.json"/
>
> /pgAdmin Config File: "C:\Program Files\PostgreSQL\14\pgAdmin
> 4\web\config.py"/
>
> /Webapp Path: "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py"/
>
> /pgAdmin Command: "C:\Program Files\PostgreSQL\14\pgAdmin
> 4\python\python.exe -s C:\Program Files\PostgreSQL\14\pgAdmin
> 4\web\pgAdmin4.py"/
>
> /Environment: /
>
> /  - ALLUSERSPROFILE: C:\ProgramData/
>
> /  - APPDATA: C:\Users\Administrator\AppData\Roaming/
>
> /  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_2108_XAEXTHSRZQXHPLHB/
>
> /  - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch
> now?|LEFT_TO_RIGHT/
>
> /  - CLASSPATH:
> .;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc4.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj4.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar/
>
> /  - CommonProgramFiles: C:\Program Files\Common Files/
>
> /  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files/
>
> /  - CommonProgramW6432: C:\Program Files\Common Files/
>
> /  - COMPUTERNAME: EIA250/
>
> /  - ComSpec: C:\Windows\system32\cmd.exe/
>
> /  - DB2INSTANCE: DB2/
>
> /  - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer/
>
> /  - FPS_BROWSER_USER_PROFILE_STRING: Default/
>
> /  - GEOTRANS_DATA: C:\Program Files (x86)\Common Files\i2
> Shared\Geotrans\Data\/
>
> /  - HOMEDRIVE: C:/
>
> /  - HOMEPATH: \Users\Administrator/
>
> /  - INCLUDE: C:\PROGRA~1\IBM\SQLLIB\INCLUDE;C:\PROGRA~1\IBM\SQLLIB\LIB/
>
> /  - LIB: ;C:\PROGRA~1\IBM\SQLLIB\LIB/
>
> /  - LOCALAPPDATA: C:\Users\Administrator\AppData\Local/
>
> /  - LOGONSERVER: \\I2DC/
>
> /  - NUMBER_OF_PROCESSORS: 4/
>
> /  - OS: Windows_NT/
>
> /  - Path:
> C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program
> Files\ibm\gsk8\lib64;C:\Program Files
> (x86)\ibm\gsk8\lib;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program
> Files (x86)\Common Files\i2 Shared\Geotrans\;C:\Program Files
> (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL
> Server\150\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL
> Server\150\DTS\Binn\;C:\Program Files\Microsoft SQL
> Server\150\DTS\Binn\;C:\Program Files\Microsoft SQL Server\Client
> SDK\ODBC\170\Tools\Binn\;C:\Program Files\Azure Data
> Studio\bin;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;/
>
> /  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC/
>
> /  - PGADMIN_INT_KEY: 639145fb-c750-43c0-9b9f-f698a800886c/
>
> /  - PGADMIN_INT_PORT: 52456/
>
> /  - PGADMIN_SERVER_MODE: OFF/
>
> /  - PROCESSOR_ARCHITECTURE: AMD64/
>
> /  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 10,
> GenuineIntel/
>
> /  - PROCESSOR_LEVEL: 6/
>
> /  - PROCESSOR_REVISION: 8e0a/
>
> /  - ProgramData: C:\ProgramData/
>
> /  - ProgramFiles: C:\Program Files/
>
> /  - ProgramFiles(x86): C:\Program Files (x86)/
>
> /  - ProgramW6432: C:\Program Files/
>
> /  - PSModulePath:
> %ProgramFiles%\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program
> Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\/
>
> /  - PUBLIC: C:\Users\Public/
>
> /  - SystemDrive: C:/
>
> /  - SystemRoot: C:\Windows/
>
> /  - TEMP: C:\Users\ADMINI~1\AppData\Local\Temp/
>
> /  - TMP: C:\Users\ADMINI~1\AppData\Local\Temp/
>
> /  - USERDNSDOMAIN: DL.LAN/
>
> /  - USERDOMAIN: DL/
>
> /  - USERDOMAIN_ROAMINGPROFILE: DL/
>
> /  - USERNAME: Administrator/
>
> /  - USERPROFILE: C:\Users\Administrator/
>
> /  - windir: C:\Windows/
>
> /--------------------------------------------------------/
>
> //
>
> /Total spawn time to start the pgAdmin4 server: 0.006 Sec/
>
> /Traceback (most recent call last):/
>
> /  File "C:\Program Files\PostgreSQL\14\pgAdmin 4\web\pgAdmin4.py", line
> 93, in <module>/
>
> //
>
> /    app = create_app()/
>
> /  File "C:\Program Files\PostgreSQL\14\pgAdmin
> 4\web\pgadmin\__init__.py", line 270, in create_app/
>
> /    create_app_data_directory(config)/
>
> /  File "C:\Program Files\PostgreSQL\14\pgAdmin
> 4\web\pgadmin\setup\data_directory.py", line 65, in create_app_data_directory/
>
> /_create_directory_if_not_exists(os.path.dirname(config.LOG_FILE))/
>
> /  File "C:\Program Files\PostgreSQL\14\pgAdmin
> 4\web\pgadmin\setup\data_directory.py", line 20, in
> _create_directory_if_not_exists/
>
> /    os.mkdir(_path)/
>
> /FileNotFoundError: [WinError 3] The system cannot find the path
> specified: '/desired/path/to'/
>
> May I ask you to help me? Any suggestion or advice would be greatly
> appreciated. Thank you in advance.
>
>
> Regards,
> Daniel
>
>
> *i2group.com* <http://i2group.com/>
>
>
>
> This message has been sent on behalf of a company that is part of the
> Harris Operating Group of Constellation Software Inc.​
> If you prefer not to be contacted by Harris Operating Group, *please
> notify us* <http://subscribe.harriscomputer.com/>.
> ​
> ​This message is intended exclusively for the individual or entity to whom
> it is addressed. This communication may contain information that is
> proprietary, privileged or confidential, or otherwise legally exempt from
> disclosure. If you are not the named addressee, you are not authorized to
> read, print, retain, copy, or disseminate this message or any part of it.
> If you have received this message in error, please notify the sender
> immediately by email and delete all copies of the message.
>

--
Angular momentum makes the world go 'round.