Re: [External] Re: pgadmin--pgagent---the process hang by unknow reasons

Hi Dave

 

   Thanks for your update. I try to upgrade pgagent_10-3.4.0. But failed.

   Would you like to help me narrow down this upgrade issue ？ Thanks

   

upgrade path	version upgrade	status
yum install pgagent_10 \i pgagent--3.4--4.0.sql create extension pgagent;	3.4 – 4.0	failed
compile and build. (install cmake and Boost)   \i pgagent--3.4--4.2.sql create extension pgagent;	3.4 – 4.2	failed.

 

 Currently pgagent_10 3.4.0 env  installed by my teammate. He told me that he install it by yum command and execute a script.

Then those pgagent tables created by this script. There is no extension exist. But those pgagent table exist.

 

 

 Then I try upgrade pgagent_10 3.40 to 4.0 by yum command.  It’s successfully upgrade by yum command.

But the pgagent_10 process unable start.  

 

[root@sltfjfrauxq ~]# yum upgrade pgagent_10   Total download size: 138 k Is this ok [y/N]: y Downloading Packages: pgagent_10-4.0.0-4.rhel6.x86_64.rpm                                                                       | 138 kB     00:08 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction   Updating   : pgagent_10-4.0.0-4.rhel6.x86_64                                                                               1/2   Cleanup    : pgagent_10-3.4.0-10.rhel6.x86_64                                                                              2/2   Verifying  : pgagent_10-4.0.0-4.rhel6.x86_64                                                                               1/2   Verifying  : pgagent_10-3.4.0-10.rhel6.x86_64                                                                              2/2   Updated:   pgagent_10.x86_64 0:4.0.0-4.rhel6   Complete! Version: 4.0.0

 

 

 

The 4.0 pgagent start logs.

Tue Dec 1 13:57:53 2020 DEBUG: Creating primary connection Tue Dec 1 13:57:53 2020 DEBUG: Parsing connection information... Tue Dec 1 13:57:53 2020 DEBUG: user: postgres Tue Dec 1 13:57:53 2020 DEBUG: password: ***** Tue Dec 1 13:57:53 2020 DEBUG: dbname: postgres Tue Dec 1 13:57:53 2020 DEBUG: hostaddr: 127.0.0.1 Tue Dec 1 13:57:53 2020 DEBUG: port: 5432 Tue Dec 1 13:57:53 2020 DEBUG: Creating DB connection: user=postgres password=abcd-1234  hostaddr=127.0.0.1 port=5432 dbname=postgres Tue Dec 1 13:57:53 2020 DEBUG: Database sanity check

 

I try to upgrade it by sql. But still on failed. 

 

[root@slbwcbnos2 sql]# pwd /data/postgres/new_package/pgAgent-4.0.0-Source/sql [root@slbwcbnos2 sql]# ls -al total 36 drwxr-xr-x 2 501 games    90 Dec  1 14:25 . drwxr-xr-x 6 501 games   298 Jul 12  2018 .. -rw-r--r-- 1 501 games   538 Jul 12  2018 pgagent--3.4--4.0.sql -rw-r--r-- 1 501 games 27772 Jul 12  2018 pgagent.sql -rw-r--r-- 1 501 games  2603 Jul 12  2018 pgagent--unpackaged--4.0.sql

 

postgres=# \i pgagent--3.4--4.0.sql Use "CREATE EXTENSION pgagent UPDATE" to load this file. postgres=# CREATE EXTENSION pgagent UPDATE; ERROR:  syntax error at or near "UPDATE" LINE 1: CREATE EXTENSION pgagent UPDATE;                                  ^ postgres=# CREATE EXTENSION pgagent UPDATE; ERROR:  syntax error at or near "UPDATE" LINE 1: CREATE EXTENSION pgagent UPDATE;                                  ^ postgres=# CREATE EXTENSION pgagent ; ERROR:  extension "pgagent" has no installation script nor update path for version "3.4" postgres=#

 

After failed. I try to build and compile the latest version 4.2.

 Build and install successfully. But I still on unable upgrade current 3.4 version.   

 I could create extension successfully on a new database.

 

 

postgres=# \i pgagent--3.4--4.2.sql Use "CREATE EXTENSION pgagent UPDATE" to load this file. postgres=# CREATE EXTENSION pgagent UPDATE; ERROR:  syntax error at or near "UPDATE" LINE 1: CREATE EXTENSION pgagent UPDATE;                                  ^ postgres=# CREATE EXTENSION pgagent ; ERROR:  relation "pga_jobagent" already exists postgres=#