下午，windows下升级完postgresql后，发现pgadmin4不能启动，报如下错误：
详细报错如下：
pgAdmin Runtime Environment
——————————————————–
Python Path: “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe”
Runtime Config File: “C:\Users\zymh\AppData\Roaming\pgadmin\runtime_config.json”
pgAdmin Config File: “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\config.py”
Webapp Path: “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py”
pgAdmin Command: “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py”
Environment:
– ALLUSERSPROFILE: C:\ProgramData
– APPDATA: C:\Users\zymh\AppData\Roaming
– CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_12560_PZOZSFBNOCCXVUPT
– CHROME_RESTART: NW.js|哎呀！NW.js 崩溃了。要立即重新启动吗？|LEFT_TO_RIGHT
– CLASSPATH: C:\Java\jdk7;.;C:\IBM\SQLLIB\java\db2java.zip;C:\IBM\SQLLIB\java\db2jcc.jar;C:\IBM\SQLLIB\java\sqlj.zip;C:\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\IBM\SQLLIB\bin;C:\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: LAPTOP-KSR0SN9S
– ComSpec: C:\WINDOWS\system32\cmd.exe
– DB2INSTANCE: DB2
– DriverData: C:\Windows\System32\Drivers\DriverData
– HOMEDRIVE: C:
– HOMEPATH: \Users\zymh
– INCLUDE: C:\IBM\SQLLIB\INCLUDE;C:\IBM\SQLLIB\LIB;C:\Program Files (x86)\IBM\WebSphere MQ\tools\c\include;C:\Program Files (x86)\IBM\WebSphere MQ\tools\cplus\include
– LIB: C:\Program Files (x86)\IBM\WebSphere MQ\tools\lib64;C:\IBM\SQLLIB\LIB;C:\Program Files (x86)\IBM\WebSphere MQ\tools\lib
– LOCALAPPDATA: C:\Users\zymh\AppData\Local
– LOGONSERVER: \\LAPTOP-KSR0SN9S
– MOZ_PLUGIN_PATH: C:\Program Files (x86)\Foxit Software\Foxit PDF Reader\plugins\
– MQ_FILE_PATH: C:\Program Files (x86)\IBM\WebSphere MQ
– MQ_JAVA_DATA_PATH: C:\Program Files (x86)\IBM\WebSphere MQ
– MQ_JAVA_INSTALL_PATH: C:\Program Files (x86)\IBM\WebSphere MQ\java
– MQ_JAVA_LIB_PATH: C:\Program Files (x86)\IBM\WebSphere MQ\java\lib64;C:\Program Files (x86)\IBM\WebSphere MQ\java\lib
– MQ_JRE_PATH: C:\Program Files (x86)\IBM\WebSphere MQ\java\jre
– MySQL57_HOME: C:\DownSoFts\mysql-57-win64
– MySQL80_HOME: C:\DownSoFts\mysql-80-winx64
– NUMBER_OF_PROCESSORS: 4
– OneDrive: C:\Users\zymh\OneDrive
– OS: Windows_NT
– Path: C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime;C:\Program Files (x86)\Common Files\Oracle\Java\java8path;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Anaconda3;C:\ProgramData\Anaconda3\Library\mingw-w64\bin;C:\ProgramData\Anaconda3\Library\usr\bin;C:\ProgramData\Anaconda3\Library\bin;C:\ProgramData\Anaconda3\Scripts;c:\app\zymh\product\11.2.0.4\dbhome_1\bin;C:\Program Files (x86)\NetSarang\Xshell 6\;C:\Java\jdk7\bin;C:\Program Files\Java\jdk1.7.0_80\bin;C:\Program Files (x86)\Common Files\NetSarang;C:\ProgramData\Oracle\Java\javapath;C:\app\zymh\product\11.2.0\dbhome_1\bin;c:\program files (x86)\ibm\websphere mq\java\lib;c:\program files (x86)\ibm\websphere mq\java\lib64;c:\program files (x86)\intel\icls client\;c:\program files\intel\icls client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\wbem;C:\WINDOWS\system32\windowspowershell\v1.0\;c:\program files\intel\wifi\bin\;c:\program files\common files\intel\wirelesscommon\;c:\program files (x86)\intel\intel(r) management engine components\dal;c:\program files\intel\intel(r) management engine components\dal;c:\program files (x86)\intel\intel(r) management engine components\ipt;c:\program files\intel\intel(r) management engine components\ipt;c:\program files\acer proshield\;c:\program files\acer proshield\x86;c:\program files (x86)\ibm\websphere mq\bin64;c:\program files (x86)\ibm\websphere mq\bin;c:\program files (x86)\ibm\websphere mq\tools\c\samples\bin;c:\program files\ibm\gsk8\lib64;c:\program files (x86)\ibm\gsk8\lib;C:\IBM\SQLLIB\BIN;C:\IBM\SQLLIB\FUNCTION;C:\IBM\SQLLIB\SAMPLES\REPL;C:\PROGRA~2\ibm\gsk7\bin;C:\PROGRA~2\ibm\gsk7\lib;C:\Program Files (x86)\ibm\gsk7\bin;C:\Program Files (x86)\ibm\gsk7\lib;C:\Program Files (x86)\IBM\Personal Communications\;C:\Program Files (x86)\IBM\Trace Facility\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\IBM\Informix\Client-SDK\bin;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Users\zymh\AppData\Local\Programs\Python\Python311-32\Scripts\;C:\Users\zymh\AppData\Local\Programs\Python\Python311-32\;C:\Users\zymh\AppData\Local\Programs\Python\Python310\Scripts\;C:\Users\zymh\AppData\Local\Programs\Python\Python310\;C:\Users\zymh\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\IDM Computer Solutions\UltraEdit\;C:\DownSoFts\mysql-57-win64\bin;C:\DownSoFts\mysql-80-winx64\bin;;C:\Program Files\JetBrains\PyCharm Community Edition 2022.3.1\bin;
– PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY
– PCOMM_Root: C:\Program Files (x86)\IBM\Personal Communications\
– PGADMIN_INT_KEY: 00834792-52b3-4d63-bcce-c808d419981c
– PGADMIN_INT_PORT: 13678
– PGADMIN_SERVER_MODE: OFF
– PROCESSOR_ARCHITECTURE: AMD64
– PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 9, GenuineIntel
– PROCESSOR_LEVEL: 6
– PROCESSOR_REVISION: 8e09
– 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 SQL Server\110\Tools\PowerShell\Modules\
– PUBLIC: C:\Users\Public
– PyCharm Community Edition: C:\Program Files\JetBrains\PyCharm Community Edition 2022.3.1\bin;
– SESSIONNAME: Console
– SystemDrive: C:
– SystemRoot: C:\WINDOWS
– TEMP: C:\Users\zymh\AppData\Local\Temp
– TMP: C:\Users\zymh\AppData\Local\Temp
– TNS-ADMIN: C:\Program Files (x86)\PLSQL Developer\instantclient_19_9\NETWORK\ADMIN
– USERDOMAIN: LAPTOP-KSR0SN9S
– USERDOMAIN_ROAMINGPROFILE: LAPTOP-KSR0SN9S
– USERNAME: zymh
– USERPROFILE: C:\Users\zymh
– windir: C:\WINDOWS
– ZWCADPATH: C:\Program Files\ZWSOFT\ZWCAD 2022\ZWCAD.EXE
——————————————————–
Total spawn time to start the pgAdmin4 server: 0.005 Sec
2024-07-06 23:45:38,052: ERROR pgadmin: Database migration failed
2024-07-06 23:45:38,052: ERROR pgadmin: Traceback (most recent call last):
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 690, 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:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 386, in upgrade_db
db_upgrade(app)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\db_upgrade.py”, line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py”, line 111, in wrapped
f(*args, **kwargs)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py”, line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\command.py”, line 403, in upgrade
script.run_env()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py”, line 583, in run_env
util.load_python_file(self.dir, “env.py”)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py”, line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py”, line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “<frozen importlib._bootstrap_external>”, line 940, in exec_module
File “<frozen importlib._bootstrap>”, line 241, in _call_with_frames_removed
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py”, line 95, in <module>
run_migrations_online()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py”, line 87, in run_migrations_online
context.run_migrations()
File “<string>”, line 8, in run_migrations
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py”, line 948, in run_migrations
self.get_context().run_migrations(**kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py”, line 627, in run_migrations
step.migration_fn(**kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\migrations\versions\a77a0932a568_.py”, line 28, in upgrade
with op.batch_alter_table(“server”) as batch_op:
File “contextlib.py”, line 144, in __exit__
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py”, line 398, in batch_alter_table
impl.flush()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 162, in flush
fn(*arg, **kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 701, 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:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 690, 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:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 386, in upgrade_db
db_upgrade(app)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\db_upgrade.py”, line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py”, line 111, in wrapped
f(*args, **kwargs)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py”, line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\command.py”, line 403, in upgrade
script.run_env()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py”, line 583, in run_env
util.load_python_file(self.dir, “env.py”)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py”, line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py”, line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “<frozen importlib._bootstrap_external>”, line 940, in exec_module
File “<frozen importlib._bootstrap>”, line 241, in _call_with_frames_removed
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py”, line 95, in <module>
run_migrations_online()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py”, line 87, in run_migrations_online
context.run_migrations()
File “<string>”, line 8, in run_migrations
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py”, line 948, in run_migrations
self.get_context().run_migrations(**kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py”, line 627, in run_migrations
step.migration_fn(**kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\migrations\versions\a77a0932a568_.py”, line 28, in upgrade
with op.batch_alter_table(“server”) as batch_op:
File “contextlib.py”, line 144, in __exit__
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py”, line 398, in batch_alter_table
impl.flush()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 162, in flush
fn(*arg, **kw)
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py”, line 701, 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:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py”, line 103, in <module>
app = create_app()
^^^^^^^^^^^^
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 473, in create_app
run_migration_for_sqlite()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 432, in run_migration_for_sqlite
upgrade_db()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 391, in upgrade_db
backup_db_file()
File “C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py”, line 368, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] ��һ����������ʹ�ô��ļ������������ʡ�: ‘C:\\Users\\zymh\\AppData\\Roaming\\pgAdmin\\pgadmin4.db’ -> ‘C:\\Users\\zymh\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240706234538’
貌似是环境问题，或者是pgadmin4版本问题。查了一下，现在win10环境主要java 解析版本是jre1.8 32位。卸载这个java 版本，换成jdk1.7 64位，还是一样报错。于是从pgadmin4官网下载最新版本pgadmin4来安装。
安装过程没有问题，一切顺利，在安装完，启动pgadmin4，还是一样的报错。
以下文章点击率最高
Loading…