Hi,
I tried to upgrade my home appliance (home license) from 21.0 EAP1 to 21.0 GA with the following error:
2024-11-18 11:16:20.459 GMT starting old version corporate db
Starting conf database
1 2024-11-18 11:16:21.852 GMTLOG: starting PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by x86_64-linux-gnu-gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
1 2024-11-18 11:16:21.856 GMTLOG: listening on IPv4 address "127.0.0.1", port 5432
1 2024-11-18 11:16:21.872 GMTLOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
4 2024-11-18 11:16:21.913 GMTLOG: database system was shut down at 2024-11-18 11:15:52 GMT
1 2024-11-18 11:16:21.943 GMTLOG: database system is ready to accept connections
2024-11-18 11:16:26.376 GMT
2024-11-18 11:16:26.425 GMT
2024-11-18 11:16:26.427 GMT : Database started after 0 seconds
DROP SCHEMA
UPDATE 3
Stopping database
1 2024-11-18 11:16:27.243 GMTLOG: received fast shutdown request
1 2024-11-18 11:16:27.261 GMTLOG: aborting any active transactions
2 2024-11-18 11:16:27.261 GMTLOG: shutting down
error opening file `/tmp/crun/postgres-reportdb/status`: No such file or directory
error opening file `/tmp/crun/postgres-sigdb/status`: No such file or directory
1 2024-11-18 11:16:27.512 GMTLOG: database system is shut down
2024-11-18 11:16:28.323 GMT : Database stopped after 1 seconds
/sdisk/oldpgconfdump.sql is created
Starting conf database
1 2024-11-18 11:16:29.755 GMTLOG: starting PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by x86_64-linux-gnu-gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
1 2024-11-18 11:16:29.755 GMTLOG: listening on IPv4 address "127.0.0.1", port 5432
1 2024-11-18 11:16:29.775 GMTLOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
4 2024-11-18 11:16:29.811 GMTLOG: database system was shut down at 2024-09-27 16:09:12 GMT
1 2024-11-18 11:16:29.870 GMTLOG: database system is ready to accept connections
2024-11-18 11:16:34.657 GMT
2024-11-18 11:16:34.661 GMT
2024-11-18 11:16:34.805 GMT : Database started after 0 seconds
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
11 2024-11-18 11:16:36.105 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
11 2024-11-18 11:16:36.105 GMTHINT: You can drop extension plpgsql instead.
11 2024-11-18 11:16:36.105 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
set_config
------------
(1 row)
setval
--------
196
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
243
(1 row)
setval
--------
1
(1 row)
Stopping database
1 2024-11-18 11:16:57.103 GMTLOG: received fast shutdown request
error opening file `/tmp/crun/postgres-reportdb/status`: No such file or directory
1 2024-11-18 11:16:57.121 GMTLOG: aborting any active transactions
2 2024-11-18 11:16:57.122 GMTLOG: shutting down
error opening file `/tmp/crun/postgres-sigdb/status`: No such file or directory
1 2024-11-18 11:17:09.002 GMTLOG: database system is shut down
2024-11-18 11:17:09.229 GMT : Database stopped after 12 seconds
old conf to new conf migrated with return value :: 0
nvram_del failed with -32
nvram_del failed with -32
nvram_del failed with -32
nvram_del failed with -32
2024-11-18 11:17:09.374 GMT starting migration log
Starting conf database
1 2024-11-18 11:17:09.818 GMTLOG: starting PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by x86_64-linux-gnu-gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
1 2024-11-18 11:17:09.818 GMTLOG: listening on IPv4 address "127.0.0.1", port 5432
1 2024-11-18 11:17:09.841 GMTLOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
4 2024-11-18 11:17:09.888 GMTLOG: database system was shut down at 2024-11-18 11:17:08 GMT
1 2024-11-18 11:17:09.911 GMTLOG: database system is ready to accept connections
2024-11-18 11:17:14.735 GMT
2024-11-18 11:17:14.738 GMT
2024-11-18 11:17:14.888 GMT : Database started after 0 seconds
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
UPDATE 1
INSERT 0 0
UPDATE 16
INSERT 0 0
UPDATE 1
nvram_get failed with -16
Old version is 21.001 and currentversion is 21.002
Database is upgrading to dbv21.002
Check migration for version dbv21.002
Applying migration for version dbv21.002
366 2024-11-18 11:17:16.402 GMTERROR: update or delete on table "tblrootcainfo" violates foreign key constraint "tblvpncertificate_caid_fkey" on table "tblvpncertificate"
366 2024-11-18 11:17:16.402 GMTDETAIL: Key (companyid)=(151) is still referenced from table "tblvpncertificate".
366 2024-11-18 11:17:16.402 GMTSTATEMENT: delete from tblrootcainfo where caname in ('Lets_Encrypt_R10','Lets_Encrypt_R11','Lets_Encrypt_R12','Lets_Encrypt_R13','Lets_Encrypt_R14','Lets_Encrypt_E5','Lets_Encrypt_E6','Lets_Encrypt_E7','Lets_Encrypt_E8','Lets_Encrypt_E9');
psql:/_conf/DB/dbv21.002/corporate.sql:6: ERROR: update or delete on table "tblrootcainfo" violates foreign key constraint "tblvpncertificate_caid_fkey" on table "tblvpncertificate"
DETAIL: Key (companyid)=(151) is still referenced from table "tblvpncertificate".
/bin/psql -1 -p 5432 -U pgroot -q -v ON_ERROR_STOP=1 -d corporate -f /_conf//DB/dbv21.002/corporate.sql Failed
/bin/sh /_conf//DB/dbv21.002/migration.sh Failed
UPDATE 1
Stopping database
1 2024-11-18 11:17:17.527 GMTLOG: received fast shutdown request
1 2024-11-18 11:17:17.543 GMTLOG: aborting any active transactions
error opening file `/tmp/crun/postgres-reportdb/status`: No such file or directory
2 2024-11-18 11:17:17.543 GMTLOG: shutting down
error opening file `/tmp/crun/postgres-sigdb/status`: No such file or directory
1 2024-11-18 11:17:17.870 GMTLOG: database system is shut down
2024-11-18 11:17:18.586 GMT : Database stopped after 1 seconds
applymigration.sh exited with 1
Can someone help with this issue?
Added V21
[edited by: Erick Jan at 3:06 AM (GMT -8) on 27 Nov 2024]
