Re: URGENT ACTION : Fatal Error with launching pgAdmn

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: EGHANA MARREDDY <180050016(at)kluniversity(dot)in>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: URGENT ACTION : Fatal Error with launching pgAdmn
Date: 2020-08-28 09:36:35
Message-ID: CANxoLDd3UOcjFQOqtKnLk9EWHHh2Sq_FwXAR7x9mSeJsZA-5zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi EGHANA

After checking the logs it is showing below error:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate
column name: connect_timeout
[SQL: ALTER TABLE server ADD COLUMN connect_timeout INTEGER DEFAULT 0]

It seems that problem with the database file when you did upgrade/downgrade
the PostgreSQL.
I would suggest performing the following steps:

- Take the backup of the '*pgadmin4.db*' file and delete it. You may
find the file at "*C:\Users\<user_name>\.pgadmin*" folder.
- Restart the pgAdmin4

On Fri, Aug 28, 2020 at 2:32 PM EGHANA MARREDDY <180050016(at)kluniversity(dot)in>
wrote:

> Hi Akshay,
>
> Thanks for reaching out!
>
> Here are the log files as advised.
>
> Thanks,
> Meghana
> ------------------------------
> *From:* Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> *Sent:* 28 August 2020 09:04
> *To:* EGHANA MARREDDY <180050016(at)kluniversity(dot)in>
> *Cc:* pgadmin-support(at)postgresql(dot)org <pgadmin-support(at)postgresql(dot)org>
> *Subject:* Re: URGENT ACTION : Fatal Error with launching pgAdmn
>
> Hi EGHANA
>
> Can you please provide the pgAdmin4 log file available at "
> *C:\Users\<user_name>\AppData\Local*" folder.
>
> On Thu, Aug 27, 2020 at 7:54 PM EGHANA MARREDDY <180050016(at)kluniversity(dot)in>
> wrote:
>
> Hi Team,
>
> I am facing issues with launching the pgAdmn 4 from Postgresql 12. I am
> using a windows 64bit laptop with Windows 10 OS.
>
> I have tried launching as administrator also tried installing lower
> versions of the postgresql to verify if that works, with no luck so far.
>
> Please can you help me what would be the potential troubleshooting that I
> can perform to resolve the issue
>
> Thanks,
> Meghana
>
>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
> *pgAdmin Hacker | Sr. Software Architect*
> *EDB Postgres <http://edbpostgres.com>*
>
> *Mobile: +91 976-788-8246 *
>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Sr. Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2020-08-28 10:03:09 Re: Having trouble with connecting to database via kerberos
Previous Message EGHANA MARREDDY 2020-08-28 09:02:03 Re: URGENT ACTION : Fatal Error with launching pgAdmn