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

Hi

It sounds like the extension hasn't been installed properly at the
operating system level - what is the output from:

ls -al /usr/pgsql-10/share/extension

On Tue, Dec 1, 2020 at 10:00 AM Zhiyu ZY13 Xu <xuzy13(at)lenovo(dot)com> wrote:

> Hi Dave
>
>
>
> Thanks for your quick response.
>
>
>
> I try this command on 4.0 and 4.2. I got a warning that the extension not
> exist.
>
>
>
>
>
>
>
>
>
>
>
> 徐志宇（Jack）
>
> Database Engineer
>
>
>
> DB Team,ITS. Lenovo China
>
> Phone: 86-18910860709
>
> Email:xuzy13(at)lenovo(dot)com
>
> No.6 Shangdi West Road, Haidian District Beijing, China, 100085
>
>
>
> *发件人:* Dave Page <dpage(at)pgadmin(dot)org>
> *发送时间:* 2020年12月1日 17:48
> *收件人:* Zhiyu ZY13 Xu <xuzy13(at)lenovo(dot)com>
> *抄送:* pgadmin-support(at)postgresql(dot)org
> *主题:* Re: [External] Re: pgadmin--pgagent---the process hang by unknow
> reasons
>
>
>
> Hi
>
>
>
> On Tue, Dec 1, 2020 at 9:17 AM Zhiyu ZY13 Xu <xuzy13(at)lenovo(dot)com> wrote:
>
> 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(at)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(at)slbwcbnos2 sql]# pwd
>
> /data/postgres/new_package/pgAgent-4.0.0-Source/sql
>
> [root(at)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=#
>
>
>
>
>
>
>
>
>
> I think the message is wrong (which I'll fix if you can confirm) - it
> should be:
>
>
>
> ALTER EXTENSION pgagent UPDATE;
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: http://www.enterprisedb.com
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com