BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade

From: lishengxian123(at)163(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade
Date: 2016-07-01 03:30:18
Message-ID: 20160701033018.1397.88367@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14221
Logged by: li shengxian
Email address: lishengxian123(at)163(dot)com
PostgreSQL version: 9.1.22
Operating system: CentOS release 6.7 (Final)
Description:

[postgres(at)tm04ac ~]$ /usr/local/pgsql/bin/pg_upgrade -c --link -b
/usr/local/pgsql_9.1/bin -B /usr/local/pgsql/bin/ -d
/disk-DATA/pgsql-data9.1 -D /disk-DATA/pg-data

successful

but [postgres(at)tm04ac ~]$ /usr/local/pgsql/bin/pg_upgrade --link -b
/usr/local/pgsql_9.1/bin -B /usr/local/pgsql/bin/ -d
/disk-DATA/pgsql-data9.1 -D /disk-DATA/pg-data

failed

[postgres(at)tm04ac ~]$ /usr/local/pgsql/bin/pg_upgrade --link -b
/usr/local/pgsql_9.1/bin -B /usr/local/pgsql/bin/ -d
/disk-DATA/pgsql-data9.1 -D /disk-DATA/pgsql-data
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is a superuser ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for reg* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
ok
Checking for presence of required libraries ok
Checking database user is a superuser ok
Checking for prepared transactions ok

If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.

Performing Upgrade
------------------
Analyzing all rows in the new cluster ok
Freezing all rows on the new cluster ok
Deleting files from new pg_clog ok
Copying old pg_clog to new server ok
Setting next transaction ID and epoch for new cluster ok
Deleting files from new pg_multixact/offsets ok
Setting oldest multixact ID on new cluster ok
Resetting WAL archives ok
Setting frozenxid and minmxid counters in new cluster ok
Restoring global objects in the new cluster ok
Adding support functions to new cluster ok
Restoring database schemas in the new cluster
postgres
*failure*

Consult the last few lines of "pg_upgrade_dump_12699.log" for
the probable cause of the failure.
Failure, exiting

postgres(at)tm04ac ~]$ cat pg_upgrade_dump_12699.log
command: "/usr/local/pgsql/bin/pg_dump" --host "/home/postgres" --port 50432
--username "postgres" --schema-only --quote-all-identifiers --binary-upgrade
--format=custom --file="pg_upgrade_dump_12699.custom" "postgres" >>
"pg_upgrade_dump_12699.log" 2>&1

command: "/usr/local/pgsql/bin/pg_restore" --host "/home/postgres" --port
50432 --username "postgres" --exit-on-error --verbose --dbname "postgres"
"pg_upgrade_dump_12699.custom" >> "pg_upgrade_dump_12699.log" 2>&1
pg_restore: connecting to database for restore
pg_restore: creating pg_largeobject pg_largeobject
pg_restore: creating pg_largeobject_metadata pg_largeobject_metadata
pg_restore: creating COMMENT postgres
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA "public"
pg_restore: creating EXTENSION dblink
pg_restore: creating COMMENT EXTENSION "dblink"
pg_restore: creating EXTENSION pg_buffercache
pg_restore: creating COMMENT EXTENSION "pg_buffercache"
pg_restore: creating EXTENSION pg_stat_statements
pg_restore: creating COMMENT EXTENSION "pg_stat_statements"
pg_restore: creating TYPE dblink_pkey_results
pg_restore: creating FUNCTION dblink("text")
pg_restore: creating FUNCTION dblink("text", boolean)
pg_restore: creating FUNCTION dblink("text", "text")
pg_restore: creating FUNCTION dblink("text", "text", boolean)
pg_restore: creating FUNCTION dblink_build_sql_delete("text", "int2vector",
integer, "text"[])
pg_restore: creating FUNCTION dblink_build_sql_insert("text", "int2vector",
integer, "text"[], "text"[])
pg_restore: creating FUNCTION dblink_build_sql_update("text", "int2vector",
integer, "text"[], "text"[])
pg_restore: creating FUNCTION dblink_cancel_query("text")
pg_restore: creating FUNCTION dblink_close("text")
pg_restore: creating FUNCTION dblink_close("text", boolean)
pg_restore: creating FUNCTION dblink_close("text", "text")
pg_restore: creating FUNCTION dblink_close("text", "text", boolean)
pg_restore: creating FUNCTION dblink_connect("text")
pg_restore: creating FUNCTION dblink_connect("text", "text")
pg_restore: creating FUNCTION dblink_connect_u("text")
pg_restore: creating FUNCTION dblink_connect_u("text", "text")
pg_restore: creating FUNCTION dblink_current_query()
pg_restore: creating FUNCTION dblink_disconnect()
pg_restore: creating FUNCTION dblink_disconnect("text")
pg_restore: creating FUNCTION dblink_error_message("text")
pg_restore: creating FUNCTION dblink_exec("text")
pg_restore: creating FUNCTION dblink_exec("text", boolean)
pg_restore: creating FUNCTION dblink_exec("text", "text")
pg_restore: creating FUNCTION dblink_exec("text", "text", boolean)
pg_restore: creating FUNCTION dblink_fetch("text", integer)
pg_restore: creating FUNCTION dblink_fetch("text", integer, boolean)
pg_restore: creating FUNCTION dblink_fetch("text", "text", integer)
pg_restore: creating FUNCTION dblink_fetch("text", "text", integer,
boolean)
pg_restore: creating FUNCTION dblink_get_connections()
pg_restore: creating FUNCTION dblink_get_notify()
pg_restore: creating FUNCTION dblink_get_notify("text")
pg_restore: creating FUNCTION dblink_get_pkey("text")
pg_restore: creating FUNCTION dblink_get_result("text")
pg_restore: creating FUNCTION dblink_get_result("text", boolean)
pg_restore: creating FUNCTION dblink_is_busy("text")
pg_restore: creating FUNCTION dblink_open("text", "text")
pg_restore: creating FUNCTION dblink_open("text", "text", boolean)
pg_restore: creating FUNCTION dblink_open("text", "text", "text")
pg_restore: creating FUNCTION dblink_open("text", "text", "text", boolean)
pg_restore: creating FUNCTION dblink_send_query("text", "text")
pg_restore: creating FUNCTION pg_buffercache_pages()
pg_restore: creating FUNCTION pg_stat_statements()
pg_restore: creating FUNCTION pg_stat_statements_reset()
pg_restore: creating VIEW pg_buffercache
pg_restore: creating VIEW pg_stat_statements
pg_restore: creating VIEW vw_currentqueries
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 167; 1259 103429584 VIEW
vw_currentqueries dbadmin
pg_restore: [archiver (db)] could not execute query: ERROR: column
pg_stat_activity.procpid does not exist
LINE 14: SELECT "pg_stat_activity"."procpid", "pg_stat_activity"."cli...
^
Command was:
-- For binary upgrade, must preserve pg_type oid
SELECT binary_upgrade.set_next_pg_type_oid('103429586'::pg_catalog.oid);

...
[postgres(at)tm04ac ~]$

==============

As I know for the postgresql 9.3 the column already change to pid from
procpid on table pg_stat_activity . please help to confirm if it bug or not
. thanks a lot

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pange.akshaya 2016-07-01 12:54:21 BUG #14222: psqlODBC driver connection pooling not working for .net codebase
Previous Message Michael Paquier 2016-07-01 01:12:06 Re: BUG #14220: pg_get_expr() with an incorrect relation id crashes the server