RE: FATAL ERROR: The application server could not be contacted.

From: Luana CristinaCroft [mailto:luanacrystinne(at)msn(dot)com]
Sent: Monday, August 20, 2018 1:40 PM
To: Igor Neyman <ineyman(at)perceptron(dot)com>; pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: FATAL ERROR: The application server could not be contacted.

Hi Igor.

So, I already made this. In real fact, I deleted like was said in a site with some possible errors.

I am sending to you a archive of my log. Can you see and give me some solutions?

I will wait.

Thanks a lot.

"pgAdmin4.2123502176.log
Traceback (most recent call last):
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/web/pgAdmin4.py", line 70, in <module>
app = create_app()
File "C:\Program Files\PostgreSQL\10\pgAdmin 4\web\pgadmin\__init__.py", line 317, in create_app
db_upgrade(app)
File "C:\Program Files\PostgreSQL\10\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\flask_migrate\__init__.py", line 259, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\alembic\command.py", line 254, in upgrade
script.run_env()
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\alembic\script\base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\alembic\util\pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\alembic\util\compat.py", line 135, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "C:\Program Files\PostgreSQL\10\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 94, in <module>
run_migrations_online()
File "C:\Program Files\PostgreSQL\10\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/10/pgAdmin 4/venv/Lib/site-packages\alembic\runtime\environment.py", line 836, in run_migrations
self.get_context().run_migrations(**kw)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\alembic\runtime\migration.py", line 330, in run_migrations
step.migration_fn(**kw)
File "C:\Program Files\PostgreSQL\10\pgAdmin 4\web\migrations\versions\02b9dccdcfcb_.py", line 28, in upgrade
'ALTER TABLE server ADD COLUMN bgcolor TEXT(10)'
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 2075, in execute
return connection.execute(statement, *multiparams, **params)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 1104, in _execute_text
statement, parameters
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 1200, in _execute_context
context)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 1413, in _handle_dbapi_exception
exc_info
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\util\compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\base.py", line 1193, in _execute_context
context)
File "C:/Program Files/PostgreSQL/10/pgAdmin 4/venv/Lib/site-packages\sqlalchemy\engine\default.py", line 509, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: bgcolor [SQL: 'ALTER TABLE server ADD COLUMN bgcolor TEXT(10)'] (Background on this error at: http://sqlalche.me/e/e3q8)
Exception KeyError: KeyError(15440,) in <module 'threading' from 'C:/Program Files/PostgreSQL/10/pgAdmin 4/venv\lib\threading.py'> ignored

Luana Cristina de A Silva
Analista em Tecnologia da Informação Senior alocada na SEFAD-OLINDA
Bacharela em Sistemas de Informação (Centro Universitário Maurício de Nassau)
Pós graduada em Engenharia de Software (Unibratec)

Aluna de mestrado das disciplinas de Data Warehousing e Banco de Dados no CIN-UFPE

Aluna no MBA em Análise de Inteligência de Negócio (IGTI)
Skype e e-mail: luanacrystinne(at)msn(dot)com<mailto:luanacrystinne(at)msn(dot)com>

LinkedIn: linkedin.com/in/luanacristinaas

Mobile: (81)9 9900-1226 / 9 8535-1025

So, after deleting PgAdmin4.db, are you still getting:
"Fatal error. The application server could not be contacted."
Regards,
Igor Neyman