Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Started by user root
- Building in workspace /var/lib/jenkins/jobs/OKA_DEV_Deploy/workspace
- > git rev-parse --is-inside-work-tree # timeout=10
- Fetching changes from the remote Git repository
- > git config remote.origin.url http://localhost:80/cbr/oka.git # timeout=10
- Fetching upstream changes from http://localhost:80/cbr/oka.git
- > git --version # timeout=10
- using GIT_ASKPASS to set credentials
- > git fetch --tags --progress http://localhost:80/cbr/oka.git +refs/heads/*:refs/remotes/origin/*
- > git rev-parse refs/remotes/origin/master^{commit} # timeout=10
- > git rev-parse refs/remotes/origin/origin/master^{commit} # timeout=10
- Checking out Revision 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0 (refs/remotes/origin/master)
- > git config core.sparsecheckout # timeout=10
- > git checkout -f 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0
- > git rev-list 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0 # timeout=10
- [workspace] $ /bin/sh -xe /tmp/hudson851515373875031598.sh
- + cp -R configs/dev/flyway configs/dev/OKAPoller configs/dev/OKAPortlets configs/dev/OKARMIServer configs/dev/OKAScheduler configs/dev/OKAStatemachine configs/dev/OKATestLib .
- [workspace] $ /bin/sh -xe /tmp/hudson5103949668653419873.sh
- + scp -P 22476 database/reload.sh root@185.98.85.56:/tmp
- + ssh root@185.98.85.56 -p 22476 'su oracle -c '\''bash /tmp/reload.sh'\'''
- SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 17 17:09:26 2017
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- SQL> Connected.
- SQL>
- PL/SQL procedure successfully completed.
- SQL> SQL> 2
- User dropped.
- SQL> 2
- User created.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL> 2
- Grant succeeded.
- SQL>
- PL/SQL procedure successfully completed.
- SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Export: Release 11.2.0.4.0 - Production on Mon Jul 17 17:09:43 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Starting "OKATECHUSER"."SYS_EXPORT_SCHEMA_02": okatechuser/********@dbeispd11 directory=TAX dumpfile=okatest.dmp schemas=okatechuser reuse_dumpfiles=Y compression=all content=metadata_only EXCLUDE=TABLE_STATISTICS
- Processing object type SCHEMA_EXPORT/USER
- Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
- Processing object type SCHEMA_EXPORT/ROLE_GRANT
- Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
- Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
- Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
- Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
- Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
- Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/DB_LINK
- Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
- Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/XMLSCHEMA/XMLSCHEMA
- Processing object type SCHEMA_EXPORT/TABLE/TABLE
- Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/TABLE/COMMENT
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
- Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
- Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
- Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Processing object type SCHEMA_EXPORT/VIEW/VIEW
- Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
- Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
- Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
- Master table "OKATECHUSER"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
- ******************************************************************************
- Dump file set for OKATECHUSER.SYS_EXPORT_SCHEMA_02 is:
- /oracle11/okatest.dmp
- Job "OKATECHUSER"."SYS_EXPORT_SCHEMA_02" successfully completed at Mon Jul 17 17:11:46 2017 elapsed 0 00:02:03
- Import: Release 11.2.0.4.0 - Production on Mon Jul 17 17:11:47 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Master table "SYS"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
- Starting "SYS"."SYS_IMPORT_SCHEMA_02": "sys/********@dbeispd11 AS SYSDBA" directory=TAX dumpfile=okatest.dmp remap_schema=OKATECHUSER:OKATEST schemas=OKATECHUSER transform=oid:n transform=storage:n exclude=XMLSCHEMA
- Processing object type SCHEMA_EXPORT/USER
- ORA-31684: Object type USER:"OKATEST" already exists
- Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
- Processing object type SCHEMA_EXPORT/ROLE_GRANT
- Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
- Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
- Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
- Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
- Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
- Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/DB_LINK
- Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
- Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/TABLE/TABLE
- Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/TABLE/COMMENT
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
- Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
- Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
- Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Processing object type SCHEMA_EXPORT/VIEW/VIEW
- Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
- ORA-39082: Object type VIEW:"OKATEST"."V_SUBJECT_SRO" created with compilation warnings
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
- Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
- Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
- Job "SYS"."SYS_IMPORT_SCHEMA_02" completed with 2 error(s) at Mon Jul 17 17:12:25 2017 elapsed 0 00:00:38
- Export: Release 11.2.0.4.0 - Production on Mon Jul 17 17:12:26 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Starting "OKATECHUSER"."SYS_EXPORT_TABLE_02": okatechuser/********@dbeispd11 directory=IMP dumpfile=okatest.dmp tables=\"schema_version\" reuse_dumpfiles=Y compression=all
- Estimate in progress using BLOCKS method...
- Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
- Total estimation using BLOCKS method: 64 KB
- Processing object type TABLE_EXPORT/TABLE/TABLE
- Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
- Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- . . exported "OKATECHUSER"."schema_version" 8.273 KB 75 rows
- Master table "OKATECHUSER"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
- ******************************************************************************
- Dump file set for OKATECHUSER.SYS_EXPORT_TABLE_02 is:
- /data/oracle12/okatest.dmp
- Job "OKATECHUSER"."SYS_EXPORT_TABLE_02" successfully completed at Mon Jul 17 17:12:31 2017 elapsed 0 00:00:04
- Import: Release 11.2.0.4.0 - Production on Mon Jul 17 17:12:31 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Master table "OKATEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
- Starting "OKATEST"."SYS_IMPORT_FULL_01": okatest/********@dbeispd11 directory=IMP dumpfile=okatest.dmp remap_schema=OKATECHUSER:OKATEST TABLE_EXISTS_ACTION=REPLACE
- Processing object type TABLE_EXPORT/TABLE/TABLE
- Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
- . . imported "OKATEST"."schema_version" 8.273 KB 75 rows
- Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
- Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Job "OKATEST"."SYS_IMPORT_FULL_01" successfully completed at Mon Jul 17 17:12:33 2017 elapsed 0 00:00:01
- + sed -i s/okatechuser/okatest/Ig flyway/sql/R__p_db_log.sql flyway/sql/R__p_db_utility.sql flyway/sql/R__p_load_instance.sql flyway/sql/R__p_load_xsd.sql flyway/sql/R__p_rep_form.sql flyway/sql/R__p_statemachine.sql flyway/sql/R__p_validator.sql flyway/sql/R__p_webform.sql flyway/sql/R__t_reglaments.sql flyway/sql/R__trg_collectionplangen_log.sql flyway/sql/R__v_department.sql flyway/sql/R__V_EXTERNAL_CONTROLLIST.sql flyway/sql/R__v_license_limitatoin.sql flyway/sql/R__v_license.sql flyway/sql/R__v_license_type.sql flyway/sql/R__v_log_c.sql flyway/sql/R__v_region.sql flyway/sql/R__v_report_all.sql flyway/sql/R__v_report.sql flyway/sql/R__v_subject_filial.sql flyway/sql/R__v_subject.sql flyway/sql/R__v_subject_sro.sql flyway/sql/R__v_subjecttype.sql flyway/sql/R__v_work_days_region.sql flyway/sql/R__v_work_days_rus.sql flyway/sql/V20170602100101__OKA-564_ddl.sql flyway/sql/V20170602100202__OKA-564_dml.sql flyway/sql/V20170602120101__OKA-500_ddl.sql flyway/sql/V20170612100101__OKA-582_ddl.sql flyway/sql/V20170612100202__OKA-582_dml.sql flyway/sql/V20170613100101__OKA-582_ddl.sql flyway/sql/V20170613100202__OKA-582_dml.sql flyway/sql/V20170616183900__OKA-605_ddl.sql flyway/sql/V20170616185000__temp_dimcont_ddl.sql flyway/sql/V20170616191500__dropunusedobjects_ddl.sql flyway/sql/V20170618233510__alter_schemafile.sql flyway/sql/V20170620112811__formula_ddl.sql flyway/sql/V20170622174310__alter_validationlog_ddl.sql flyway/sql/V20170623134010__OKA-637_ddl.sql flyway/sql/V20170623134130__OKA-637_dml.sql flyway/sql/V20170623160010__SCHEMASFILE_ddl.sql flyway/sql/V20170623161010__SCHEMASFILE_dml.sql flyway/sql/V20170625180010__OKA-615_dml.sql flyway/sql/V20170628164500__OKA-647_ddl.sql flyway/sql/V20170629144200__protocol_ddl.sql flyway/sql/V20170705163900__department_dml.sql flyway/sql/V20170706174600__OKA-323_dml.sql flyway/sql/V20170707094500__subjecttype_dml.sql flyway/sql/V20170712115000__report_ddl.sql
- + cd flyway
- + bash flyway -user=okatest -password=okatest repair
- Flyway 4.2.0 by Boxfuse
- Database: jdbc:oracle:thin:@185.98.85.56:51522:dbeispd11 (Oracle 11.2)
- Repair of failed migration in metadata table "OKATEST"."schema_version" not necessary. No failed migration detected.
- Repairing metadata for version 20170602100101 (Description: OKA-564 ddl, Checksum: 60916491) ...
- Repairing metadata for version 20170602100202 (Description: OKA-564 dml, Checksum: -1737914644) ...
- Repairing metadata for version 20170602120101 (Description: OKA-500 ddl, Checksum: 494148189) ...
- Repairing metadata for version 20170612100101 (Description: OKA-582 ddl, Checksum: 530513711) ...
- Repairing metadata for version 20170612100202 (Description: OKA-582 dml, Checksum: 114276521) ...
- Repairing metadata for version 20170613100101 (Description: OKA-582 ddl, Checksum: -738701283) ...
- Repairing metadata for version 20170613100202 (Description: OKA-582 dml, Checksum: 73356474) ...
- Repairing metadata for version 20170616183900 (Description: OKA-605 ddl, Checksum: 227979678) ...
- Repairing metadata for version 20170616185000 (Description: temp dimcont ddl, Checksum: 1617424451) ...
- Repairing metadata for version 20170616191500 (Description: dropunusedobjects ddl, Checksum: 943552391) ...
- Repairing metadata for version 20170618233510 (Description: alter schemafile, Checksum: -460547916) ...
- Repairing metadata for version 20170620112811 (Description: formula ddl, Checksum: 1455606838) ...
- Repairing metadata for version 20170623134010 (Description: OKA-637 ddl, Checksum: 1441482164) ...
- Repairing metadata for version 20170623134130 (Description: OKA-637 dml, Checksum: -156114918) ...
- Repairing metadata for version 20170628164500 (Description: OKA-647 ddl, Checksum: 1884802331) ...
- Repairing metadata for version 20170629144200 (Description: protocol ddl, Checksum: 1742883561) ...
- Repairing metadata for version 20170705163900 (Description: department dml, Checksum: -122453283) ...
- Repairing metadata for version 20170706174600 (Description: OKA-323 dml, Checksum: 1262318487) ...
- Repairing metadata for version 20170707094500 (Description: subjecttype dml, Checksum: 190545354) ...
- Repairing metadata for version 20170712115000 (Description: report ddl, Checksum: 556395015) ...
- Successfully repaired metadata table "OKATEST"."schema_version" (execution time 00:00.271s).
- Manual cleanup of the remaining effects the failed migration may still be required.
- + bash flyway -user=okatest -password=okatest migrate
- Flyway 4.2.0 by Boxfuse
- Database: jdbc:oracle:thin:@185.98.85.56:51522:dbeispd11 (Oracle 11.2)
- Successfully validated 100 migrations (execution time 00:00.197s)
- Current version of schema "OKATEST": 20170712115000
- Migrating schema "OKATEST" with repeatable migration V EXTERNAL CONTROLLIST
- Migrating schema "OKATEST" with repeatable migration p db log
- Migrating schema "OKATEST" with repeatable migration p db utility
- Migrating schema "OKATEST" with repeatable migration p load instance
- Migrating schema "OKATEST" with repeatable migration p load xsd
- Migrating schema "OKATEST" with repeatable migration p rep form
- Migrating schema "OKATEST" with repeatable migration p statemachine
- Migrating schema "OKATEST" with repeatable migration p validator
- Migrating schema "OKATEST" with repeatable migration p webform
- Migrating schema "OKATEST" with repeatable migration t reglaments
- Migrating schema "OKATEST" with repeatable migration trg collectionplangen log
- Migrating schema "OKATEST" with repeatable migration v department
- Migrating schema "OKATEST" with repeatable migration v license
- Migrating schema "OKATEST" with repeatable migration v license limitatoin
- Migrating schema "OKATEST" with repeatable migration v license type
- Migrating schema "OKATEST" with repeatable migration v log c
- Migration of schema "OKATEST" with repeatable migration v log c failed! Please restore backups and roll back database and code!
- Migration R__v_log_c.sql failed
- -------------------------------
- SQL State : 42000
- Error Code : 1031
- Message : ORA-01031: insufficient privileges
- Location : /var/lib/jenkins/jobs/OKA_DEV_Deploy/workspace/flyway/sql/R__v_log_c.sql (/var/lib/jenkins/jobs/OKA_DEV_Deploy/workspace/flyway/sql/R__v_log_c.sql)
- Line : 1
- Statement : create or replace view okatest.v_log_c as
- select r.id as report_id, nvl(status_id,-3) as status_id, nvl(l.insdate,inf.uploadbegin_date) as insdate
- from infilestorage inf, report r
- left outer join (select distinct report_id,
- first_value (status_id) over (partition by report_id order by insdate desc) as status_id,
- first_value (insdate) over (partition by report_id order by insdate desc) as insdate
- from log_c) l on (l.report_id = r.id)
- where inf.id = r.zipstorage_id
- Build step 'Execute shell' marked build as failure
- Finished: FAILURE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement