public inbox for [email protected]  
help / color / mirror / Atom feed
PgAdmin4 Runtime Environment Error
3+ messages / 2 participants
[nested] [flat]

* PgAdmin4 Runtime Environment Error
@ 2024-10-25 14:08 Alex Escott <[email protected]>
  2024-10-28 05:06 ` Re: PgAdmin4 Runtime Environment Error Anil Sahoo <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Alex Escott @ 2024-10-25 14:08 UTC (permalink / raw)
  To: pgadmin-support

Hello,

Having issues with opening the PgAdmin4 application. Please see the error message attached.  Would appreciate any help with this issue.

Thank you,


Alex Escott
Senior Auditor – Lead Data Analytics, Corporate Audit, IAS

3000 N Sam Houston Pkwy E
Houston, TX 77032

[email protected]<mailto:[email protected]>

[Halliburton]<https://www.halliburton.com/;

LinkedIn<http://www.linkedin.com/company/halliburton; | Instagram<https://www.instagram.com/halliburton; | YouTube<http://www.youtube.com/halliburton; | Twitter<http://www.twitter.com/halliburton; | Facebook<https://www.facebook.com/halliburton;





This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\h236962\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\h236962\AppData\Roaming
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: NTBK0020605
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - EFC_13212: 0
  - ELECTRON_ENABLE_SECURITY_WARNINGS: false
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\h236962
  - LOCALAPPDATA: C:\Users\h236962\AppData\Local
  - LOGONSERVER: \\NP2DCGC20
  - NUMBER_OF_PROCESSORS: 12
  - OneDrive: C:\Users\h236962\OneDrive - Halliburton
  - OneDriveCommercial: C:\Users\h236962\OneDrive - Halliburton
  - ORIGINAL_XDG_CURRENT_DESKTOP: undefined
  - OS: Windows_NT
  - Path: C:\Program Files\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X64\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X86\;C:\Program Files (x86)\Common Files\Pulse Secure\TNC Client Plugin\;C:\Users\h236962\AppData\Local\Microsoft\WindowsApps;
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 740f75c0-671e-4ae1-b252-696fefc451b5
  - PGADMIN_INT_PORT: 60509
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: AMD64 Family 25 Model 80 Stepping 0, AuthenticAMD
  - PROCESSOR_LEVEL: 25
  - PROCESSOR_REVISION: 5000
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SNC_LIB: C:\Program Files (x86)\Quest Software\VAS SSO for SAP\qgsskrb5.dll
  - SNC_LIB_2: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SSF_LIBRARY_PATH: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SSF_LIBRARY_PATH_64: C:\Program Files\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\h236962\AppData\Local\Temp
  - TMP: C:\Users\h236962\AppData\Local\Temp
  - UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
  - USERDNSDOMAIN: CORP.HALLIBURTON.COM
  - USERDOMAIN: HALAMERICA
  - USERDOMAIN_ROAMINGPROFILE: HALAMERICA
  - USERNAME: H236962
  - USERPROFILE: C:\Users\h236962
  - windir: C:\WINDOWS
  - __PSLockDownPolicy: 0
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.013 Sec
2024-10-14 15:40:11,465: ERROR	pgadmin:	Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database

Traceback (most recent call last):
  File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app

    run_migration_for_sqlite()
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 440, in run_migration_for_sqlite
    backup_db_file()
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file
    os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20241014154011'



Attachments:

  [image/png] Outlook-Halliburto.png (2.3K, 3-Outlook-Halliburto.png)
  download | view image

  [text/plain] pgAdmin Runtime Environment (2).txt (4.0K, 4-pgAdmin%20Runtime%20Environment%20%282%29.txt)
  download | inline:
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\h236962\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\h236962\AppData\Roaming
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: NTBK0020605
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - EFC_13212: 0
  - ELECTRON_ENABLE_SECURITY_WARNINGS: false
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\h236962
  - LOCALAPPDATA: C:\Users\h236962\AppData\Local
  - LOGONSERVER: \\NP2DCGC20
  - NUMBER_OF_PROCESSORS: 12
  - OneDrive: C:\Users\h236962\OneDrive - Halliburton
  - OneDriveCommercial: C:\Users\h236962\OneDrive - Halliburton
  - ORIGINAL_XDG_CURRENT_DESKTOP: undefined
  - OS: Windows_NT
  - Path: C:\Program Files\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X64\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X86\;C:\Program Files (x86)\Common Files\Pulse Secure\TNC Client Plugin\;C:\Users\h236962\AppData\Local\Microsoft\WindowsApps;
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 740f75c0-671e-4ae1-b252-696fefc451b5
  - PGADMIN_INT_PORT: 60509
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: AMD64 Family 25 Model 80 Stepping 0, AuthenticAMD
  - PROCESSOR_LEVEL: 25
  - PROCESSOR_REVISION: 5000
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SNC_LIB: C:\Program Files (x86)\Quest Software\VAS SSO for SAP\qgsskrb5.dll
  - SNC_LIB_2: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SSF_LIBRARY_PATH: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SSF_LIBRARY_PATH_64: C:\Program Files\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\h236962\AppData\Local\Temp
  - TMP: C:\Users\h236962\AppData\Local\Temp
  - UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
  - USERDNSDOMAIN: CORP.HALLIBURTON.COM
  - USERDOMAIN: HALAMERICA
  - USERDOMAIN_ROAMINGPROFILE: HALAMERICA
  - USERNAME: H236962
  - USERPROFILE: C:\Users\h236962
  - windir: C:\WINDOWS
  - __PSLockDownPolicy: 0
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.013 Sec
2024-10-14 15:40:11,465: ERROR	pgadmin:	Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database

Traceback (most recent call last):
  File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app

    run_migration_for_sqlite()
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 440, in run_migration_for_sqlite
    backup_db_file()
  File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file
    os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20241014154011'


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PgAdmin4 Runtime Environment Error
  2024-10-25 14:08 PgAdmin4 Runtime Environment Error Alex Escott <[email protected]>
@ 2024-10-28 05:06 ` Anil Sahoo <[email protected]>
  2024-10-28 12:54   ` Re: [EXTERNAL] Re: PgAdmin4 Runtime Environment Error Alex Escott <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Anil Sahoo @ 2024-10-28 05:06 UTC (permalink / raw)
  To: Alex Escott <[email protected]>; +Cc: pgadmin-support

Hi Alex,

Do you have any other pgAdmin installations?

Please try as per the steps mentioned here
<https://github.com/pgadmin-org/pgadmin4/issues/7901#issuecomment-2333222484;.
And let us know if you have any questions.

Thanks

<http://www.enterprisedb.com;

*Anil Sahoo*

Software Engineer

www.enterprisedb.com

Power to Postgres

<https://www.linkedin.com/company/edbpostgres;
<https://twitter.com/edbpostgres?lang=en;
<https://www.facebook.com/EDBpostgres;
<https://www.instagram.com/EDBpostgres/;


On Sat, Oct 26, 2024 at 2:03 PM Alex Escott <[email protected]>
wrote:

> Hello,
>
> Having issues with opening the PgAdmin4 application. Please see the error
> message attached.  Would appreciate any help with this issue.
>
> Thank you,
>
> *Alex Escott*
> Senior Auditor – Lead Data Analytics, Corporate Audit, IAS
>
> 3000 N Sam Houston Pkwy E
> Houston, TX 77032
>
> [email protected]
>
> [image: Halliburton] <https://www.halliburton.com/;
>
> LinkedIn <http://www.linkedin.com/company/halliburton; | Instagram
> <https://www.instagram.com/halliburton; | YouTube
> <http://www.youtube.com/halliburton; | Twitter
> <http://www.twitter.com/halliburton; | Facebook
> <https://www.facebook.com/halliburton;
>
>
>
>
> This e-mail, including any attached files, may contain confidential and
> privileged information for the sole use of the intended recipient. Any
> review, use, distribution, or disclosure by others is strictly prohibited.
> If you are not the intended recipient (or authorized to receive information
> for the intended recipient), please contact the sender by reply e-mail and
> delete all copies of this message.
>


Attachments:

  [image/png] Outlook-Halliburto.png (2.3K, 3-Outlook-Halliburto.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [EXTERNAL] Re: PgAdmin4 Runtime Environment Error
  2024-10-25 14:08 PgAdmin4 Runtime Environment Error Alex Escott <[email protected]>
  2024-10-28 05:06 ` Re: PgAdmin4 Runtime Environment Error Anil Sahoo <[email protected]>
@ 2024-10-28 12:54   ` Alex Escott <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Alex Escott @ 2024-10-28 12:54 UTC (permalink / raw)
  To: Anil Sahoo <[email protected]>; +Cc: pgadmin-support

Issue resolved. Thank you for the help!
________________________________
From: Anil Sahoo <[email protected]>
Sent: Monday, October 28, 2024 12:06 AM
To: Alex Escott <[email protected]>
Cc: [email protected] <[email protected]>
Subject: [EXTERNAL] Re: PgAdmin4 Runtime Environment Error

External Sender: Use caution with links/attachments.


Hi Alex,

Do you have any other pgAdmin installations?

Please try as per the steps mentioned here<https://github.com/pgadmin-org/pgadmin4/issues/7901#issuecomment-2333222484;. And let us know if you have any questions.

Thanks

[https://lh4.googleusercontent.com/z3gqWcL4RRm8JR6E31h8IRyRoNiLzFfI4HP2_ZCrR7S7KjnVBGqSUr7WHE-xFv0MRm...]<http://www.enterprisedb.com/;

Anil Sahoo

Software Engineer

www.enterprisedb.com<http://www.enterprisedb.com/;

Power to Postgres

[https://lh6.googleusercontent.com/Y2kH6bwEN2kBgj5xRfH-s_brdmNopZJNCEpMqWB7_Y-PH-Ldxltn483TMj3O5V-1Iy...]

[https://lh4.googleusercontent.com/gQtQu_3aB3EkFUO37EqGafJ0-iYTy5QB_Kw8wT5Vwy8Jl54SO6jcNsPqwhNHtzHs31...]<https://www.linkedin.com/company/edbpostgres;      [https://lh4.googleusercontent.com/wdEHTBb3aIIlGfSW_VKwZY7SuFoTLdIbvsTK06RaJYLh1sy0DPOHOaNDi_XVG2wMmd...] <https://twitter.com/edbpostgres?lang=en;      [https://lh3.googleusercontent.com/6xHSbeAKDXavcMUzo8SV70efsuyGV3EFgZTKU5GEBp5cx0CI1fGnh0_9fb6P5O6Bb6...] <https://www.facebook.com/EDBpostgres;      [https://lh4.googleusercontent.com/dUWc-r-Gp5YPWOQ13n-xrO_y1n8KJROva9me-pvlAbXLji3f_rIE1ye8d82GYMwjIN...] <https://www.instagram.com/EDBpostgres/;


On Sat, Oct 26, 2024 at 2:03 PM Alex Escott <[email protected]<mailto:[email protected]>> wrote:
Hello,

Having issues with opening the PgAdmin4 application. Please see the error message attached.  Would appreciate any help with this issue.

Thank you,


Alex Escott
Senior Auditor – Lead Data Analytics, Corporate Audit, IAS

3000 N Sam Houston Pkwy E
Houston, TX 77032

[email protected]<mailto:[email protected]>

[Halliburton]<https://www.halliburton.com/;

LinkedIn<http://www.linkedin.com/company/halliburton; | Instagram<https://www.instagram.com/halliburton; | YouTube<http://www.youtube.com/halliburton; | Twitter<http://www.twitter.com/halliburton; | Facebook<https://www.facebook.com/halliburton;





This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.


Attachments:

  [image/png] Outlook-Halliburto.png (2.3K, 3-Outlook-Halliburto.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2024-10-28 12:54 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-25 14:08 PgAdmin4 Runtime Environment Error Alex Escott <[email protected]>
2024-10-28 05:06 ` Anil Sahoo <[email protected]>
2024-10-28 12:54   ` Alex Escott <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox