Question

2
Replies
417
Views
MarghoobK Member since 2018 4 posts
BT
Posted: July 5, 2018
Last activity: July 6, 2018
Closed

Error while Installing Pega personal edition 7.2.2

Hi Everyone,

While installing PE7.2 , I am getting following error. Please help me fix this.

Targets:Initialization,Database Server Installation,Data Load,Configuration,PRPC Launching
Buildfile: C:\PegaPE\115008_PE72\.\pegaGuiInstallerTemp2\build.xml

Initialization:
[echo] Beginning installation of PRPC 7.2 Personal Edition -- this process should take about 5-10 minutes ...
[unzip] Expanding: C:\PegaPE\115008_PE72\pegaGuiInstallerTemp2\PersonalEdition.zip into C:\PRPCPersonalEdition
[unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\ssleay32.dll
[unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\postgres.exe
[unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libeay32.dll
[unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libintl-8.dll
[unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libxml2.dll
[echo] Configuring Tomcat (Setting Java Home and Catalina Home)...
[replace] Replaced 0 occurrences in 0 files.
[replace] Replaced 1 occurrences in 1 files.
[replace] Replaced 2 occurrences in 1 files.
[replace] Replaced 1 occurrences in 1 files.

Database Server Installation:
[exec] The files belonging to this database system will be owned by user "mk_pe".
[exec] This user must also own the server process.

[exec] The database cluster will be initialized with locale "English_India.1252".
[exec] The default database encoding has accordingly been set to "WIN1252".
[exec] initdb: directory "C:/PRPCPersonalEdition/pgsql/data" exists but is not empty
[exec] The default text search configuration will be set to "english".

[exec] If you want to create a new database system, either remove or empty
[exec] Data page checksums are disabled.
[exec] the directory "C:/PRPCPersonalEdition/pgsql/data" or run initdb

[exec] with an argument other than "C:/PRPCPersonalEdition/pgsql/data".

[echo] Waiting for Postgres to start...
[echo] Connected to Database.
[exec] ALTER ROLE
[exec] psql:C:/PRPCPersonalEdition/scripts/SetupDBandUser.sql:3: ERROR: database "pega" already exists
[exec] ALTER ROLE

Data Load:

[echo] Waiting for Postgres to restart...
Unable to connect to database -- will retry in 1 second...
[echo] Connected to Database.

[echo] Loading database with PRPC...
[exec] pg_restore: connecting to database for restore
[exec] pg_restore: processing item 3678 ENCODING ENCODING
[exec] pg_restore: processing item 3679 STDSTRINGS STDSTRINGS
[exec] pg_restore: processing item 7 SCHEMA sqlj
[exec] pg_restore: creating SCHEMA sqlj
[exec] pg_restore: [archiver (db)] Error while PROCESSING TOC:
[exec] pg_restore: [archiver (db)] Error from TOC entry 7; 2615 18421 SCHEMA sqlj postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: schema "sqlj" already exists
[exec] Command was: CREATE SCHEMA sqlj;

[exec] pg_restore: processing item 403 FUNCTION java_call_handler()
[exec] pg_restore: creating FUNCTION java_call_handler()
[exec] pg_restore: [archiver (db)] Error from TOC entry 403; 1255 18422 FUNCTION java_call_handler() postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "java_call_handler" already exists with same argument types
[exec] Command was: CREATE FUNCTION java_call_handler() RETURNS language_handler
[exec] LANGUAGE c
[exec] AS 'pljava', 'java_call_handler';

[exec] pg_restore: processing item 1396 PROCEDURAL LANGUAGE java
[exec] pg_restore: creating PROCEDURAL LANGUAGE java
[exec] pg_restore: [archiver (db)] Error from TOC entry 1396; 2612 18423 PROCEDURAL LANGUAGE java postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: language "java" already exists
[exec] Command was: CREATE TRUSTED PROCEDURAL LANGUAGE java HANDLER java_call_handler;

[exec] pg_restore: processing item 404 FUNCTION javau_call_handler()
[exec] pg_restore: creating FUNCTION javau_call_handler()
[exec] pg_restore: [archiver (db)] Error from TOC entry 404; 1255 18424 FUNCTION javau_call_handler() postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "javau_call_handler" already exists with same argument types
[exec] Command was: CREATE FUNCTION javau_call_handler() RETURNS language_handler
[exec] LANGUAGE c
[exec] AS 'pljava', 'javau_call_handler';

[exec] pg_restore: processing item 1397 PROCEDURAL LANGUAGE javau
[exec] pg_restore: creating PROCEDURAL LANGUAGE javau
[exec] pg_restore: [archiver (db)] Error from TOC entry 1397; 2612 18425 PROCEDURAL LANGUAGE javau postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: language "javau" already exists
[exec] Command was: CREATE PROCEDURAL LANGUAGE javau HANDLER javau_call_handler;

[exec] pg_restore: processing item 412 FUNCTION add_type_mapping(character varying, character varying)
[exec] pg_restore: creating FUNCTION add_type_mapping(character varying, character varying)
[exec] pg_restore: [archiver (db)] Error from TOC entry 412; 1255 18497 FUNCTION add_type_mapping(character varying, character varying) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "add_type_mapping" already exists with same argument types
[exec] Command was: CREATE FUNCTION add_type_mapping(character varying, character varying) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] A...
[exec] pg_restore: processing item 413 FUNCTION drop_type_mapping(character varying)
[exec] pg_restore: creating FUNCTION drop_type_mapping(character varying)
[exec] pg_restore: [archiver (db)] Error from TOC entry 413; 1255 18498 FUNCTION drop_type_mapping(character varying) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "drop_type_mapping" already exists with same argument types
[exec] Command was: CREATE FUNCTION drop_type_mapping(character varying) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] AS $$org.postgresql...
[exec] pg_restore: processing item 411 FUNCTION get_classpath(character varying)
[exec] pg_restore: creating FUNCTION get_classpath(character varying)
[exec] pg_restore: [archiver (db)] Error from TOC entry 411; 1255 18496 FUNCTION get_classpath(character varying) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "get_classpath" already exists with same argument types
[exec] Command was: CREATE FUNCTION get_classpath(character varying) RETURNS character varying
[exec] LANGUAGE java STABLE SECURITY DEFINER
[exec] AS ...
[exec] pg_restore: processing item 408 FUNCTION install_jar(bytea, character varying, boolean)
[exec] pg_restore: creating FUNCTION install_jar(bytea, character varying, boolean)
[exec] pg_restore: [archiver (db)] Error from TOC entry 408; 1255 18493 FUNCTION install_jar(bytea, character varying, boolean) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "install_jar" already exists with same argument types
[exec] Command was: CREATE FUNCTION install_jar(bytea, character varying, boolean) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] AS $$org....
[exec] pg_restore: processing item 405 FUNCTION install_jar(character varying, character varying, boolean)
[exec] pg_restore: creating FUNCTION install_jar(character varying, character varying, boolean)
[exec] pg_restore: [archiver (db)] Error from TOC entry 405; 1255 18490 FUNCTION install_jar(character varying, character varying, boolean) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "install_jar" already exists with same argument types
[exec] Command was: CREATE FUNCTION install_jar(character varying, character varying, boolean) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] ...
[exec] pg_restore: processing item 407 FUNCTION remove_jar(character varying, boolean)
[exec] pg_restore: creating FUNCTION remove_jar(character varying, boolean)
[exec] pg_restore: [archiver (db)] Error from TOC entry 407; 1255 18492 FUNCTION remove_jar(character varying, boolean) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "remove_jar" already exists with same argument types
[exec] Command was: CREATE FUNCTION remove_jar(character varying, boolean) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] AS $$org.postgres...
[exec] pg_restore: processing item 409 FUNCTION replace_jar(bytea, character varying, boolean)
[exec] pg_restore: creating FUNCTION replace_jar(bytea, character varying, boolean)
[exec] pg_restore: [archiver (db)] Error from TOC entry 409; 1255 18494 FUNCTION replace_jar(bytea, character varying, boolean) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "replace_jar" already exists with same argument types
[exec] Command was: CREATE FUNCTION replace_jar(bytea, character varying, boolean) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] AS $$org....
[exec] pg_restore: processing item 406 FUNCTION replace_jar(character varying, character varying, boolean)
[exec] pg_restore: creating FUNCTION replace_jar(character varying, character varying, boolean)
[exec] pg_restore: [archiver (db)] Error from TOC entry 406; 1255 18491 FUNCTION replace_jar(character varying, character varying, boolean) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "replace_jar" already exists with same argument types
[exec] Command was: CREATE FUNCTION replace_jar(character varying, character varying, boolean) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] ...
[exec] pg_restore: processing item 410 FUNCTION set_classpath(character varying, character varying)
[exec] pg_restore: creating FUNCTION set_classpath(character varying, character varying)
[exec] pg_restore: [archiver (db)] Error from TOC entry 410; 1255 18495 FUNCTION set_classpath(character varying, character varying) postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: function "set_classpath" already exists with same argument types
[exec] Command was: CREATE FUNCTION set_classpath(character varying, character varying) RETURNS void
[exec] LANGUAGE java SECURITY DEFINER
[exec] AS $...
[exec] pg_restore: processing item 179 TABLE classpath_entry
[exec] pg_restore: creating TABLE classpath_entry
[exec] pg_restore: [archiver (db)] Error from TOC entry 179; 1259 18472 TABLE classpath_entry postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "classpath_entry" already exists
[exec] Command was: CREATE TABLE classpath_entry (
[exec] schemaname character varying(30) NOT NULL,
[exec] ordinal smallint NOT NULL,
[exec] jarid integ...
[exec] pg_restore: processing item 178 TABLE jar_descriptor
[exec] pg_restore: creating TABLE jar_descriptor
[exec] pg_restore: [archiver (db)] Error from TOC entry 178; 1259 18457 TABLE jar_descriptor postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_descriptor" already exists
[exec] Command was: CREATE TABLE jar_descriptor (
[exec] jarid integer NOT NULL,
[exec] ordinal smallint NOT NULL,
[exec] entryid integer NOT NULL
[exec] );

[exec] pg_restore: processing item 177 TABLE jar_entry
[exec] pg_restore: creating TABLE jar_entry
[exec] pg_restore: [archiver (db)] Error from TOC entry 177; 1259 18441 TABLE jar_entry postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_entry" already exists
[exec] Command was: CREATE TABLE jar_entry (
[exec] entryid integer NOT NULL,
[exec] entryname character varying(200) NOT NULL,
[exec] jarid integer NOT ...
[exec] pg_restore: processing item 176 SEQUENCE jar_entry_entryid_seq
[exec] pg_restore: creating SEQUENCE jar_entry_entryid_seq
[exec] pg_restore: [archiver (db)] Error from TOC entry 176; 1259 18439 SEQUENCE jar_entry_entryid_seq postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_entry_entryid_seq" already exists
[exec] Command was: CREATE SEQUENCE jar_entry_entryid_seq
[exec] START WITH 1
[exec] INCREMENT BY 1
[exec] NO MINVALUE
[exec] NO MAXVALUE
[exec] CACHE 1;

[exec] pg_restore: processing item 3680 SEQUENCE OWNED BY jar_entry_entryid_seq
[exec] pg_restore: creating SEQUENCE OWNED BY jar_entry_entryid_seq
[exec] pg_restore: processing item 175 TABLE jar_repository
[exec] pg_restore: creating TABLE jar_repository
[exec] pg_restore: [archiver (db)] Error from TOC entry 175; 1259 18428 TABLE jar_repository postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_repository" already exists
[exec] Command was: CREATE TABLE jar_repository (
[exec] jarid integer NOT NULL,
[exec] jarname character varying(100) NOT NULL,
[exec] jarorigin charact...
[exec] pg_restore: processing item 174 SEQUENCE jar_repository_jarid_seq
[exec] pg_restore: creating SEQUENCE jar_repository_jarid_seq
[exec] pg_restore: [archiver (db)] Error from TOC entry 174; 1259 18426 SEQUENCE jar_repository_jarid_seq postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_repository_jarid_seq" already exists
[exec] Command was: CREATE SEQUENCE jar_repository_jarid_seq
[exec] START WITH 1
[exec] INCREMENT BY 1
[exec] NO MINVALUE
[exec] NO MAXVALUE
[exec] CACHE 1;

[exec] pg_restore: processing item 3681 SEQUENCE OWNED BY jar_repository_jarid_seq
[exec] pg_restore: creating SEQUENCE OWNED BY jar_repository_jarid_seq
[exec] pg_restore: processing item 181 TABLE typemap_entry
[exec] pg_restore: creating TABLE typemap_entry
[exec] pg_restore: [archiver (db)] Error from TOC entry 181; 1259 18484 TABLE typemap_entry postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "typemap_entry" already exists
[exec] Command was: CREATE TABLE typemap_entry (
[exec] mapid integer NOT NULL,
[exec] javaname character varying(200) NOT NULL,
[exec] sqlname name NOT ...
[exec] pg_restore: processing item 180 SEQUENCE typemap_entry_mapid_seq
[exec] pg_restore: creating SEQUENCE typemap_entry_mapid_seq
[exec] pg_restore: [archiver (db)] Error from TOC entry 180; 1259 18482 SEQUENCE typemap_entry_mapid_seq postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "typemap_entry_mapid_seq" already exists
[exec] Command was: CREATE SEQUENCE typemap_entry_mapid_seq
[exec] START WITH 1
[exec] INCREMENT BY 1
[exec] NO MINVALUE
[exec] NO MAXVALUE
[exec] CACHE 1;

[exec] pg_restore: processing item 3682 SEQUENCE OWNED BY typemap_entry_mapid_seq
[exec] pg_restore: creating SEQUENCE OWNED BY typemap_entry_mapid_seq
[exec] pg_restore: processing item 3533 DEFAULT entryid
[exec] pg_restore: creating DEFAULT entryid
[exec] pg_restore: processing item 3532 DEFAULT jarid
[exec] pg_restore: creating DEFAULT jarid
[exec] pg_restore: processing item 3534 DEFAULT mapid
[exec] pg_restore: creating DEFAULT mapid
[exec] pg_restore: entering main parallel loop
[exec] pg_restore: launching item 3673 TABLE DATA classpath_entry
[exec] pg_restore: launching item 3672 TABLE DATA jar_descriptor
[exec] pg_restore: launching item 3671 TABLE DATA jar_entry
[exec] pg_restore: launching item 3683 SEQUENCE SET jar_entry_entryid_seq
[exec] pg_restore: processing data for table "classpath_entry"
[exec] pg_restore: executing SEQUENCE SET jar_entry_entryid_seq
[exec] pg_restore: processing data for table "jar_descriptor"
[exec] pg_restore: finished item 3672 TABLE DATA jar_descriptor
[exec] pg_restore: launching item 3669 TABLE DATA jar_repository
[exec] pg_restore: processing data for table "jar_repository"
[exec] pg_restore: finished item 3683 SEQUENCE SET jar_entry_entryid_seq
[exec] pg_restore: launching item 3684 SEQUENCE SET jar_repository_jarid_seq
[exec] pg_restore: executing SEQUENCE SET jar_repository_jarid_seq
[exec] pg_restore: finished item 3684 SEQUENCE SET jar_repository_jarid_seq
[exec] pg_restore: launching item 3675 TABLE DATA typemap_entry
[exec] pg_restore: processing data for table "typemap_entry"
[exec] pg_restore: finished item 3675 TABLE DATA typemap_entry
[exec] pg_restore: launching item 3685 SEQUENCE SET typemap_entry_mapid_seq
[exec] pg_restore: executing SEQUENCE SET typemap_entry_mapid_seq
[exec] pg_restore: finished item 3685 SEQUENCE SET typemap_entry_mapid_seq
[exec] pg_restore: launching item 3544 CONSTRAINT jar_descriptor_pkey
[exec] pg_restore: creating CONSTRAINT jar_descriptor_pkey
[exec] pg_restore: processing data for table "jar_entry"
[exec] pg_restore: [archiver (db)] Error from TOC entry 3544; 2606 18461 CONSTRAINT jar_descriptor_pkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "jar_descriptor" are not allowed
[exec] Command was: ALTER TABLE ONLY jar_descriptor
[exec] ADD CONSTRAINT jar_descriptor_pkey PRIMARY KEY (jarid, ordinal);

[exec] pg_restore: finished item 3544 CONSTRAINT jar_descriptor_pkey
[exec] pg_restore: launching item 3548 CONSTRAINT typemap_entry_pkey
[exec] pg_restore: creating CONSTRAINT typemap_entry_pkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3548; 2606 18489 CONSTRAINT typemap_entry_pkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "typemap_entry" are not allowed
[exec] Command was: ALTER TABLE ONLY typemap_entry
[exec] ADD CONSTRAINT typemap_entry_pkey PRIMARY KEY (mapid);

[exec] pg_restore: finished item 3548 CONSTRAINT typemap_entry_pkey
[exec] pg_restore: [archiver (db)] pg_restore: [archiver (db)] Error from TOC entry 3673; 0 18472 TABLE DATA classpath_entry postgres
[exec] Error from TOC entry 3669; 0 18428 TABLE DATA jar_repository postgres
[exec] pg_restore: [archiver (db)] COPY failed for table "classpath_entry": ERROR: duplicate key value violates unique constraint "classpath_entry_pkey"
[exec] DETAIL: Key (schemaname, ordinal)=(personaledition, 1) already exists.
[exec] CONTEXT: COPY classpath_entry, line 1
[exec] pg_restore: [archiver (db)] COPY failed for table "jar_repository": ERROR: duplicate key value violates unique constraint "jar_repository_jarname_key"
[exec] DETAIL: Key (jarname)=(personaleditionPRREADSTREAM) already exists.
[exec] CONTEXT: COPY jar_repository, line 1
[exec] pg_restore: finished item 3673 TABLE DATA classpath_entry
[exec] pg_restore: launching item 3546 CONSTRAINT classpath_entry_pkey
[exec] pg_restore: finished item 3669 TABLE DATA jar_repository
[exec] pg_restore: launching item 3536 CONSTRAINT jar_repository_jarname_key
[exec] pg_restore: creating CONSTRAINT jar_repository_jarname_key
[exec] pg_restore: creating CONSTRAINT classpath_entry_pkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3536; 2606 18438 CONSTRAINT jar_repository_jarname_key postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_repository_jarname_key" already exists
[exec] Command was: ALTER TABLE ONLY jar_repository
[exec] ADD CONSTRAINT jar_repository_jarname_key UNIQUE (jarname);

[exec] pg_restore: [archiver (db)] Error from TOC entry 3546; 2606 18476 CONSTRAINT classpath_entry_pkey postgres
[exec] pg_restore: pg_restore: [archiver (db)] finished item 3536 CONSTRAINT jar_repository_jarname_key
[exec] pg_restore: could not execute query: ERROR: multiple primary keys for table "classpath_entry" are not allowed
[exec] Command was: ALTER TABLE ONLY classpath_entry
[exec] ADD CONSTRAINT classpath_entry_pkey PRIMARY KEY (schemaname, ordinal);

[exec] launching item 3538 CONSTRAINT jar_repository_pkey
[exec] pg_restore: finished item 3546 CONSTRAINT classpath_entry_pkey
[exec] pg_restore: creating CONSTRAINT jar_repository_pkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3538; 2606 18436 CONSTRAINT jar_repository_pkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "jar_repository" are not allowed
[exec] Command was: ALTER TABLE ONLY jar_repository
[exec] ADD CONSTRAINT jar_repository_pkey PRIMARY KEY (jarid);

[exec] pg_restore: finished item 3538 CONSTRAINT jar_repository_pkey
[exec] pg_restore: launching item 3552 FK CONSTRAINT classpath_entry_jarid_fkey
[exec] pg_restore: creating FK CONSTRAINT classpath_entry_jarid_fkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3552; 2606 18477 FK CONSTRAINT classpath_entry_jarid_fkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: constraint "classpath_entry_jarid_fkey" for relation "classpath_entry" already exists
[exec] Command was: ALTER TABLE ONLY classpath_entry
[exec] ADD CONSTRAINT classpath_entry_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository...
[exec] pg_restore: finished item 3552 FK CONSTRAINT classpath_entry_jarid_fkey
[exec] pg_restore: launching item 3550 FK CONSTRAINT jar_descriptor_jarid_fkey
[exec] pg_restore: creating FK CONSTRAINT jar_descriptor_jarid_fkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3550; 2606 18462 FK CONSTRAINT jar_descriptor_jarid_fkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: constraint "jar_descriptor_jarid_fkey" for relation "jar_descriptor" already exists
[exec] Command was: ALTER TABLE ONLY jar_descriptor
[exec] ADD CONSTRAINT jar_descriptor_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository(j...
[exec] pg_restore: finished item 3550 FK CONSTRAINT jar_descriptor_jarid_fkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3671; 0 18441 TABLE DATA jar_entry postgres
[exec] pg_restore: [archiver (db)] COPY failed for table "jar_entry": ERROR: duplicate key value violates unique constraint "jar_entry_jarid_entryname_key"
[exec] DETAIL: Key (jarid, entryname)=(1, com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter.class) already exists.
[exec] CONTEXT: COPY jar_entry, line 1
[exec] pg_restore: finished item 3671 TABLE DATA jar_entry
[exec] pg_restore: launching item 3540 CONSTRAINT jar_entry_jarid_entryname_key
[exec] pg_restore: creating CONSTRAINT jar_entry_jarid_entryname_key
[exec] pg_restore: [archiver (db)] Error from TOC entry 3540; 2606 18451 CONSTRAINT jar_entry_jarid_entryname_key postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: relation "jar_entry_jarid_entryname_key" already exists
[exec] Command was: ALTER TABLE ONLY jar_entry
[exec] ADD CONSTRAINT jar_entry_jarid_entryname_key UNIQUE (jarid, entryname);

[exec] pg_restore: finished item 3540 CONSTRAINT jar_entry_jarid_entryname_key
[exec] pg_restore: launching item 3542 CONSTRAINT jar_entry_pkey
[exec] pg_restore: creating CONSTRAINT jar_entry_pkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3542; 2606 18449 CONSTRAINT jar_entry_pkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "jar_entry" are not allowed
[exec] Command was: ALTER TABLE ONLY jar_entry
[exec] ADD CONSTRAINT jar_entry_pkey PRIMARY KEY (entryid);

[exec] pg_restore: finished item 3542 CONSTRAINT jar_entry_pkey
[exec] pg_restore: launching item 3549 FK CONSTRAINT jar_entry_jarid_fkey
[exec] pg_restore: creating FK CONSTRAINT jar_entry_jarid_fkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3549; 2606 18452 FK CONSTRAINT jar_entry_jarid_fkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: constraint "jar_entry_jarid_fkey" for relation "jar_entry" already exists
[exec] Command was: ALTER TABLE ONLY jar_entry
[exec] ADD CONSTRAINT jar_entry_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository(jarid) ON D...
[exec] pg_restore: finished item 3549 FK CONSTRAINT jar_entry_jarid_fkey
[exec] pg_restore: launching item 3551 FK CONSTRAINT jar_descriptor_entryid_fkey
[exec] pg_restore: creating FK CONSTRAINT jar_descriptor_entryid_fkey
[exec] pg_restore: [archiver (db)] Error from TOC entry 3551; 2606 18467 FK CONSTRAINT jar_descriptor_entryid_fkey postgres
[exec] pg_restore: [archiver (db)] could not execute query: ERROR: constraint "jar_descriptor_entryid_fkey" for relation "jar_descriptor" already exists
[exec] Command was: ALTER TABLE ONLY jar_descriptor
[exec] ADD CONSTRAINT jar_descriptor_entryid_fkey FOREIGN KEY (entryid) REFERENCES jar_entry(en...
[exec] pg_restore: finished item 3551 FK CONSTRAINT jar_descriptor_entryid_fkey
[exec] pg_restore: finished main parallel loop
[exec] pg_restore: setting owner and privileges for SCHEMA sqlj
[exec] pg_restore: setting owner and privileges for FUNCTION java_call_handler()
[exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE java
[exec] pg_restore: setting owner and privileges for FUNCTION javau_call_handler()
[exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE javau
[exec] pg_restore: setting owner and privileges for FUNCTION add_type_mapping(character varying, character varying)
[exec] pg_restore: setting owner and privileges for FUNCTION drop_type_mapping(character varying)
[exec] pg_restore: setting owner and privileges for FUNCTION get_classpath(character varying)
[exec] pg_restore: setting owner and privileges for FUNCTION install_jar(bytea, character varying, boolean)
[exec] pg_restore: setting owner and privileges for FUNCTION install_jar(character varying, character varying, boolean)
[exec] pg_restore: setting owner and privileges for FUNCTION remove_jar(character varying, boolean)
[exec] pg_restore: setting owner and privileges for FUNCTION replace_jar(bytea, character varying, boolean)
[exec] pg_restore: setting owner and privileges for FUNCTION replace_jar(character varying, character varying, boolean)
[exec] pg_restore: setting owner and privileges for FUNCTION set_classpath(character varying, character varying)
[exec] pg_restore: setting owner and privileges for TABLE classpath_entry
[exec] pg_restore: setting owner and privileges for TABLE jar_descriptor
[exec] pg_restore: setting owner and privileges for TABLE jar_entry
[exec] pg_restore: setting owner and privileges for SEQUENCE jar_entry_entryid_seq
[exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY jar_entry_entryid_seq
[exec] pg_restore: setting owner and privileges for TABLE jar_repository
[exec] pg_restore: setting owner and privileges for SEQUENCE jar_repository_jarid_seq
[exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY jar_repository_jarid_seq
[exec] pg_restore: setting owner and privileges for TABLE typemap_entry
[exec] pg_restore: setting owner and privileges for SEQUENCE typemap_entry_mapid_seq
[exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY typemap_entry_mapid_seq
[exec] pg_restore: setting owner and privileges for DEFAULT entryid
[exec] pg_restore: setting owner and privileges for DEFAULT jarid
[exec] pg_restore: setting owner and privileges for DEFAULT mapid
[exec] pg_restore: setting owner and privileges for TABLE DATA classpath_entry
[exec] pg_restore: setting owner and privileges for TABLE DATA jar_descriptor
[exec] pg_restore: setting owner and privileges for TABLE DATA jar_entry
[exec] pg_restore: setting owner and privileges for SEQUENCE SET jar_entry_entryid_seq
[exec] pg_restore: setting owner and privileges for TABLE DATA jar_repository
[exec] pg_restore: setting owner and privileges for SEQUENCE SET jar_repository_jarid_seq
[exec] pg_restore: setting owner and privileges for TABLE DATA typemap_entry
[exec] pg_restore: setting owner and privileges for SEQUENCE SET typemap_entry_mapid_seq
[exec] pg_restore: setting owner and privileges for CONSTRAINT classpath_entry_pkey
[exec] pg_restore: setting owner and privileges for CONSTRAINT jar_descriptor_pkey
[exec] pg_restore: setting owner and privileges for CONSTRAINT jar_entry_jarid_entryname_key
[exec] pg_restore: setting owner and privileges for CONSTRAINT jar_entry_pkey
[exec] pg_restore: setting owner and privileges for CONSTRAINT jar_repository_jarname_key
[exec] pg_restore: setting owner and privileges for CONSTRAINT jar_repository_pkey
[exec] pg_restore: setting owner and privileges for CONSTRAINT typemap_entry_pkey
[exec] pg_restore: setting owner and privileges for FK CONSTRAINT classpath_entry_jarid_fkey
[exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_descriptor_entryid_fkey
[exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_descriptor_jarid_fkey
[exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_entry_jarid_fkey
[exec] WARNING: errors ignored on restore: 50

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn