Hi Yogesh,
Please find the Log Details .
OS version:Windows 10.
Tried relaunching multiple times but still not working.
Regards,
Umega
Classification: Internal
From: Yogesh Mahajan <yogesh.maha...@enterprisedb.com>
Sent: 26 September 2023 16:56
To: Umega Kaul <umega.k...@maersk.com>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PG Admin v 7.7 error
This message was sent from outside of your organization. Please do not click
links or open attachments unless you recognize the source of this email and
know the content is safe.
Hi,
Can you please specify OS version and complete error logs?
Could you please try relaunching pgAdmin?
Thanks,
Yogesh Mahajan
EnterpriseDB
On Tue, Sep 26, 2023 at 4:14 PM Umega Kaul
<umega.k...@maersk.com<mailto:umega.k...@maersk.com>> wrote:
Hi team ,
While Installing the PG Admin version 7 ,we are getting the below error .
Can you please help us in resolving this .
[cid:image001.png@01D9EFCE.55FB1500]
Regards,
Umega
________________________________
The information contained in this message is privileged and intended only for
the recipients named. If the reader is not a representative of the intended
recipient, any review, dissemination or copying of this message or the
information it contains is prohibited. If you have received this message in
error, please immediately notify the sender, and delete the original message
and attachments.
Maersk will as part of our communication and interaction with you collect and
process your personal data. You can read more about Maersk’s collection and
processing of your personal data and your rights as a data subject in our
privacy policy <https://www.maersk.com/front-page-requirements/privacy-policy>
Please consider the environment before printing this email.
Classification: Internal
________________________________
The information contained in this message is privileged and intended only for
the recipients named. If the reader is not a representative of the intended
recipient, any review, dissemination or copying of this message or the
information it contains is prohibited. If you have received this message in
error, please immediately notify the sender, and delete the original message
and attachments.
Maersk will as part of our communication and interaction with you collect and
process your personal data. You can read more about Maersk’s collection and
processing of your personal data and your rights as a data subject in our
privacy policy <https://www.maersk.com/front-page-requirements/privacy-policy>
Please consider the environment before printing this email.
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\python.exe"
Runtime Config File:
"C:\Users\UKA018\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\config.py"
Webapp Path: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\python.exe -s C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\UKA018\AppData\Roaming
- ATERNITY_AGENT_HOME: C:\Program Files (x86)\Aternity Information
Systems\Agent\
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_22312_HVISENLIGFZKSGGW
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: MMD5CG2523JG1
- ComSpec: C:\windows\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- HOMEDRIVE: C:
- HOMEPATH: \Users\UKA018
- JAVA_TOOL_OPTIONS:
-agentpath:"C:\windows\system32\Aternity\Java\JavaHookLoader.dll"="C:\ProgramData\Aternity\hooks"
- LOCALAPPDATA: C:\Users\UKA018\AppData\Local
- LOGONSERVER: \\MMD5CG2523JG1
- NUMBER_OF_PROCESSORS: 8
- OneDrive: C:\Users\UKA018\OneDrive - Maersk Group
- OneDriveCommercial: C:\Users\UKA018\OneDrive - Maersk Group
- OnlineServices: Online Services
- OS: Windows_NT
- Path: C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\runtime;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\windows\System32\OpenSSH\;C:\Users\UKA018\AppData\Local\Microsoft\WindowsApps;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: b866f914-fa1d-4968-9d3d-dc3b9ce915dc
- PGADMIN_INT_PORT: 54599
- PGADMIN_SERVER_MODE: OFF
- platformcode: AN
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 140 Stepping 1, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 8c01
- 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;C:\Program
Files (x86)\Microsoft Azure Information Protection\Powershell
- PUBLIC: C:\Users\Public
- RegionCode: APJ
- SESSIONNAME: Console
- STEELCENTRAL_ATERNITY_AGENT_HOME: C:\Program Files (x86)\Aternity
Information Systems\Agent\
- SystemDrive: C:
- SystemRoot: C:\windows
- TEMP: C:\Users\UKA018\AppData\Local\Temp
- TMP: C:\Users\UKA018\AppData\Local\Temp
- USERDNSDOMAIN: CRB.APMOLLER.NET
- USERDOMAIN: CRB
- USERDOMAIN_ROAMINGPROFILE: CRB
- USERNAME: UKA018
- USERPROFILE: C:\Users\UKA018
- windir: C:\windows
- ZES_ENABLE_SYSMAN: 1
--------------------------------------------------------
Total spawn time to start the pgAdmin4 server: 0.837 Sec
2023-09-26 16:57:37,050: ERROR pgadmin: Database migration failed
2023-09-26 16:57:37,057: ERROR pgadmin: Traceback (most recent call
last):
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 691, in
drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
db_upgrade(app)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\command.py", line 399, in upgrade
script.run_env()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\script\base.py", line 578, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 93, in
load_python_file
module = load_module_py(module_id, path)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 109, in
load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in
run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 937, in
run_migrations
self.get_context().run_migrations(**kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 624, in
run_migrations
step.migration_fn(**kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\migrations\versions\7c56ea250085_.py", line 26, in upgrade
with op.batch_alter_table("server") as batch_op:
File "contextlib.py", line 142, in __exit__
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\base.py", line 375, in
batch_alter_table
impl.flush()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 159, in flush
fn(*arg, **kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 702, in
drop_constraint
raise ValueError("No such constraint: '%s'" % const.name)
ValueError: No such constraint: 'ck_port_range'
Traceback (most recent call last):
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 691, in
drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
db_upgrade(app)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\command.py", line 399, in upgrade
script.run_env()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\script\base.py", line 578, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 93, in
load_python_file
module = load_module_py(module_id, path)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 109, in
load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in
run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 937, in
run_migrations
self.get_context().run_migrations(**kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 624, in
run_migrations
step.migration_fn(**kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\migrations\versions\7c56ea250085_.py", line 26, in upgrade
with op.batch_alter_table("server") as batch_op:
File "contextlib.py", line 142, in __exit__
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\base.py", line 375, in
batch_alter_table
impl.flush()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 159, in flush
fn(*arg, **kw)
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\python\lib\site-packages\alembic\operations\batch.py", line 702, in
drop_constraint
raise ValueError("No such constraint: '%s'" % const.name)
ValueError: No such constraint: 'ck_port_range'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgAdmin4.py",
line 104, in <module>
app = create_app()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 477, in create_app
run_migration_for_sqlite()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 436, in run_migration_for_sqlite
upgrade_db()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 395, in upgrade_db
backup_db_file()
File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin
4\v7\web\pgadmin\__init__.py", line 372, 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\\UKA018\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' ->
'C:\\Users\\UKA018\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20230926165737'
