Advertisement
Guest User

Untitled

a guest
Jul 17th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.80 KB | None | 0 0
  1. Started by user root
  2. Building in workspace /var/lib/jenkins/jobs/OKA_DEV_Deploy/workspace
  3. > git rev-parse --is-inside-work-tree # timeout=10
  4. Fetching changes from the remote Git repository
  5. > git config remote.origin.url http://localhost:80/cbr/oka.git # timeout=10
  6. Fetching upstream changes from http://localhost:80/cbr/oka.git
  7. > git --version # timeout=10
  8. using GIT_ASKPASS to set credentials
  9. > git fetch --tags --progress http://localhost:80/cbr/oka.git +refs/heads/*:refs/remotes/origin/*
  10. > git rev-parse refs/remotes/origin/master^{commit} # timeout=10
  11. > git rev-parse refs/remotes/origin/origin/master^{commit} # timeout=10
  12. Checking out Revision 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0 (refs/remotes/origin/master)
  13. > git config core.sparsecheckout # timeout=10
  14. > git checkout -f 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0
  15. > git rev-list 1b5e6ffce2dcc3dce290211b6d576fdea320e4b0 # timeout=10
  16. [workspace] $ /bin/sh -xe /tmp/hudson851515373875031598.sh
  17. + cp -R configs/dev/flyway configs/dev/OKAPoller configs/dev/OKAPortlets configs/dev/OKARMIServer configs/dev/OKAScheduler configs/dev/OKAStatemachine configs/dev/OKATestLib .
  18. [workspace] $ /bin/sh -xe /tmp/hudson5103949668653419873.sh
  19. + scp -P 22476 database/reload.sh root@185.98.85.56:/tmp
  20. + ssh root@185.98.85.56 -p 22476 'su oracle -c '\''bash /tmp/reload.sh'\'''
  21.  
  22. SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 17 17:09:26 2017
  23.  
  24. Copyright (c) 1982, 2013, Oracle. All rights reserved.
  25.  
  26. SQL> Connected.
  27. SQL>
  28. PL/SQL procedure successfully completed.
  29.  
  30. SQL> SQL> 2
  31. User dropped.
  32.  
  33. SQL> 2
  34. User created.
  35.  
  36. SQL> 2
  37. Grant succeeded.
  38.  
  39. SQL> 2
  40. Grant succeeded.
  41.  
  42. SQL> 2
  43. Grant succeeded.
  44.  
  45. SQL> 2
  46. Grant succeeded.
  47.  
  48. SQL> 2
  49. Grant succeeded.
  50.  
  51. SQL> 2
  52. Grant succeeded.
  53.  
  54. SQL> 2
  55. Grant succeeded.
  56.  
  57. SQL>
  58. PL/SQL procedure successfully completed.
  59.  
  60. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  61. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  62.  
  63. Export: Release 11.2.0.4.0 - Production on Mon Jul 17 17:09:43 2017
  64.  
  65. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  66.  
  67. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  68. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  69. 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
  70. Processing object type SCHEMA_EXPORT/USER
  71. Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
  72. Processing object type SCHEMA_EXPORT/ROLE_GRANT
  73. Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
  74. Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
  75. Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
  76. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  77. Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
  78. Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
  79. Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
  80. Processing object type SCHEMA_EXPORT/DB_LINK
  81. Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
  82. Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
  83. Processing object type SCHEMA_EXPORT/XMLSCHEMA/XMLSCHEMA
  84. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  85. Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  86. Processing object type SCHEMA_EXPORT/TABLE/COMMENT
  87. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
  88. Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
  89. Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
  90. Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
  91. Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
  92. Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
  93. Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
  94. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  95. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  96. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  97. Processing object type SCHEMA_EXPORT/VIEW/VIEW
  98. Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  99. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
  100. Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
  101. Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
  102. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  103. Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
  104. Master table "OKATECHUSER"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
  105. ******************************************************************************
  106. Dump file set for OKATECHUSER.SYS_EXPORT_SCHEMA_02 is:
  107. /oracle11/okatest.dmp
  108. Job "OKATECHUSER"."SYS_EXPORT_SCHEMA_02" successfully completed at Mon Jul 17 17:11:46 2017 elapsed 0 00:02:03
  109.  
  110.  
  111. Import: Release 11.2.0.4.0 - Production on Mon Jul 17 17:11:47 2017
  112.  
  113. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  114.  
  115. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  116. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  117. Master table "SYS"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
  118. 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
  119. Processing object type SCHEMA_EXPORT/USER
  120. ORA-31684: Object type USER:"OKATEST" already exists
  121. Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
  122. Processing object type SCHEMA_EXPORT/ROLE_GRANT
  123. Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
  124. Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
  125. Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
  126. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  127. Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
  128. Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
  129. Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
  130. Processing object type SCHEMA_EXPORT/DB_LINK
  131. Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
  132. Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
  133. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  134. Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  135. Processing object type SCHEMA_EXPORT/TABLE/COMMENT
  136. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
  137. Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
  138. Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
  139. Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
  140. Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
  141. Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
  142. Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
  143. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  144. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  145. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  146. Processing object type SCHEMA_EXPORT/VIEW/VIEW
  147. Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  148. ORA-39082: Object type VIEW:"OKATEST"."V_SUBJECT_SRO" created with compilation warnings
  149. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
  150. Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
  151. Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
  152. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  153. Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
  154. Job "SYS"."SYS_IMPORT_SCHEMA_02" completed with 2 error(s) at Mon Jul 17 17:12:25 2017 elapsed 0 00:00:38
  155.  
  156.  
  157. Export: Release 11.2.0.4.0 - Production on Mon Jul 17 17:12:26 2017
  158.  
  159. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  160.  
  161. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  162. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  163. Starting "OKATECHUSER"."SYS_EXPORT_TABLE_02": okatechuser/********@dbeispd11 directory=IMP dumpfile=okatest.dmp tables=\"schema_version\" reuse_dumpfiles=Y compression=all
  164. Estimate in progress using BLOCKS method...
  165. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  166. Total estimation using BLOCKS method: 64 KB
  167. Processing object type TABLE_EXPORT/TABLE/TABLE
  168. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  169. Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  170. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  171. . . exported "OKATECHUSER"."schema_version" 8.273 KB 75 rows
  172. Master table "OKATECHUSER"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
  173. ******************************************************************************
  174. Dump file set for OKATECHUSER.SYS_EXPORT_TABLE_02 is:
  175. /data/oracle12/okatest.dmp
  176. Job "OKATECHUSER"."SYS_EXPORT_TABLE_02" successfully completed at Mon Jul 17 17:12:31 2017 elapsed 0 00:00:04
  177.  
  178.  
  179. Import: Release 11.2.0.4.0 - Production on Mon Jul 17 17:12:31 2017
  180.  
  181. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  182.  
  183. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  184. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  185. Master table "OKATEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
  186. Starting "OKATEST"."SYS_IMPORT_FULL_01": okatest/********@dbeispd11 directory=IMP dumpfile=okatest.dmp remap_schema=OKATECHUSER:OKATEST TABLE_EXISTS_ACTION=REPLACE
  187. Processing object type TABLE_EXPORT/TABLE/TABLE
  188. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  189. . . imported "OKATEST"."schema_version" 8.273 KB 75 rows
  190. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  191. Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  192. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  193. Job "OKATEST"."SYS_IMPORT_FULL_01" successfully completed at Mon Jul 17 17:12:33 2017 elapsed 0 00:00:01
  194.  
  195. + 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
  196. + cd flyway
  197. + bash flyway -user=okatest -password=okatest repair
  198. Flyway 4.2.0 by Boxfuse
  199.  
  200. Database: jdbc:oracle:thin:@185.98.85.56:51522:dbeispd11 (Oracle 11.2)
  201. Repair of failed migration in metadata table "OKATEST"."schema_version" not necessary. No failed migration detected.
  202. Repairing metadata for version 20170602100101 (Description: OKA-564 ddl, Checksum: 60916491) ...
  203. Repairing metadata for version 20170602100202 (Description: OKA-564 dml, Checksum: -1737914644) ...
  204. Repairing metadata for version 20170602120101 (Description: OKA-500 ddl, Checksum: 494148189) ...
  205. Repairing metadata for version 20170612100101 (Description: OKA-582 ddl, Checksum: 530513711) ...
  206. Repairing metadata for version 20170612100202 (Description: OKA-582 dml, Checksum: 114276521) ...
  207. Repairing metadata for version 20170613100101 (Description: OKA-582 ddl, Checksum: -738701283) ...
  208. Repairing metadata for version 20170613100202 (Description: OKA-582 dml, Checksum: 73356474) ...
  209. Repairing metadata for version 20170616183900 (Description: OKA-605 ddl, Checksum: 227979678) ...
  210. Repairing metadata for version 20170616185000 (Description: temp dimcont ddl, Checksum: 1617424451) ...
  211. Repairing metadata for version 20170616191500 (Description: dropunusedobjects ddl, Checksum: 943552391) ...
  212. Repairing metadata for version 20170618233510 (Description: alter schemafile, Checksum: -460547916) ...
  213. Repairing metadata for version 20170620112811 (Description: formula ddl, Checksum: 1455606838) ...
  214. Repairing metadata for version 20170623134010 (Description: OKA-637 ddl, Checksum: 1441482164) ...
  215. Repairing metadata for version 20170623134130 (Description: OKA-637 dml, Checksum: -156114918) ...
  216. Repairing metadata for version 20170628164500 (Description: OKA-647 ddl, Checksum: 1884802331) ...
  217. Repairing metadata for version 20170629144200 (Description: protocol ddl, Checksum: 1742883561) ...
  218. Repairing metadata for version 20170705163900 (Description: department dml, Checksum: -122453283) ...
  219. Repairing metadata for version 20170706174600 (Description: OKA-323 dml, Checksum: 1262318487) ...
  220. Repairing metadata for version 20170707094500 (Description: subjecttype dml, Checksum: 190545354) ...
  221. Repairing metadata for version 20170712115000 (Description: report ddl, Checksum: 556395015) ...
  222. Successfully repaired metadata table "OKATEST"."schema_version" (execution time 00:00.271s).
  223. Manual cleanup of the remaining effects the failed migration may still be required.
  224. + bash flyway -user=okatest -password=okatest migrate
  225. Flyway 4.2.0 by Boxfuse
  226.  
  227. Database: jdbc:oracle:thin:@185.98.85.56:51522:dbeispd11 (Oracle 11.2)
  228. Successfully validated 100 migrations (execution time 00:00.197s)
  229. Current version of schema "OKATEST": 20170712115000
  230. Migrating schema "OKATEST" with repeatable migration V EXTERNAL CONTROLLIST
  231. Migrating schema "OKATEST" with repeatable migration p db log
  232. Migrating schema "OKATEST" with repeatable migration p db utility
  233. Migrating schema "OKATEST" with repeatable migration p load instance
  234. Migrating schema "OKATEST" with repeatable migration p load xsd
  235. Migrating schema "OKATEST" with repeatable migration p rep form
  236. Migrating schema "OKATEST" with repeatable migration p statemachine
  237. Migrating schema "OKATEST" with repeatable migration p validator
  238. Migrating schema "OKATEST" with repeatable migration p webform
  239. Migrating schema "OKATEST" with repeatable migration t reglaments
  240. Migrating schema "OKATEST" with repeatable migration trg collectionplangen log
  241. Migrating schema "OKATEST" with repeatable migration v department
  242. Migrating schema "OKATEST" with repeatable migration v license
  243. Migrating schema "OKATEST" with repeatable migration v license limitatoin
  244. Migrating schema "OKATEST" with repeatable migration v license type
  245. Migrating schema "OKATEST" with repeatable migration v log c
  246. Migration of schema "OKATEST" with repeatable migration v log c failed! Please restore backups and roll back database and code!
  247.  
  248. Migration R__v_log_c.sql failed
  249. -------------------------------
  250. SQL State : 42000
  251. Error Code : 1031
  252. Message : ORA-01031: insufficient privileges
  253. 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)
  254. Line : 1
  255. Statement : create or replace view okatest.v_log_c as
  256. select r.id as report_id, nvl(status_id,-3) as status_id, nvl(l.insdate,inf.uploadbegin_date) as insdate
  257. from infilestorage inf, report r
  258. left outer join (select distinct report_id,
  259. first_value (status_id) over (partition by report_id order by insdate desc) as status_id,
  260. first_value (insdate) over (partition by report_id order by insdate desc) as insdate
  261. from log_c) l on (l.report_id = r.id)
  262. where inf.id = r.zipstorage_id
  263.  
  264. Build step 'Execute shell' marked build as failure
  265. Finished: FAILURE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement