API tools faq
paste
Advertisement
Guest User

migration failing

a guest
Feb 5th, 2016
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.71 KB | None | 0 0
raw download clone embed print report
  1. [root@teamforge scripts]# perl -ple '/2016-02-05 12:07:22,607/ ... /2016-02-05 12:07:26.477/' /opt/collabnet/teamforge/log/runtime/migration.log
  2. 2016-02-05 11:42:08,866 INFO Changing working dir to /opt/collabnet/teamforge/dist
  3. 2016-02-05 11:42:08,867 INFO Start -- migration
  4. 2016-02-05 11:42:08,867 INFO Start -- Global sanity check scripts
  5. 2016-02-05 11:42:08,867 INFO No scripts found
  6. 2016-02-05 11:42:08,868 INFO End -- Global sanity check scripts
  7. 2016-02-05 11:42:08,868 INFO Start -- migration (version 7.2.0.0)
  8. 2016-02-05 11:42:08,899 INFO Starting migration at 2016-02-05 11:42:08 EST
  9.  
  10. 2016-02-05 11:42:08,899 INFO Start -- version sanity scripts
  11. 2016-02-05 11:42:08,899 INFO No scripts found
  12. 2016-02-05 11:42:08,900 INFO End -- version sanity scripts
  13. 2016-02-05 11:42:08,900 INFO Start -- version migration scripts
  14. 2016-02-05 11:42:08,904 INFO Run script /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/50-migratorator-run.py
  15. 2016-02-05 11:42:15,484 INFO Executing: /usr/java/jdk1.8.0_45/bin/java -cp migratorator.jar:sf_version.jar:saturn_common.jar:ctf-common.jar:saturn.jar:xe rcesImpl.jar:xml-apis.jar:xmlParserAPI.jar:log4j-1.2.8.jar:commons-digester.jar:commons-collections-3.2.1.jar:commons-logging.jar:commons-beanutils.jar:po stgresql-9.3-1102.jdbc41.jar:ojdbc14.jar:ctf-common.jar:commons-lang-2.6.jar:ctf-model.jar:tracker-core.jar com.vasoftware.sf.migratorator.MigrationManage r jdbc:oracle:thin:@halo.stanadyne.com:1521:halo tfadmin tfadmin700* /opt/collabnet/teamforge/var/filestorage false ctf71_ctf72
  16. Migration script found: jar:file:/opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migratorator.jar!/com/vasoftware/sf/migratorator/ctf71_ct f72/migration.xml
  17. Running database schema migration: 7.1.0.0->7.2.0.0
  18. [2016-02-05 11:42:11.875] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
  19. [2016-02-05 11:42:12.117] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.DeleteRootDocumentFoldersPermissionsGivenByDefault.
  20. [2016-02-05 11:42:12.118] Starting com.vasoftware.sf.migratorator.ctf71_ctf72.DeleteRootDocumentFoldersPermissionsGivenByDefault
  21. [2016-02-05 11:42:12.260] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.DropSfUserView.
  22. [2016-02-05 11:42:12.602] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.DropPasswordHistoryUserView.
  23. [2016-02-05 11:42:12.629] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddUserLoginTable.
  24. [2016-02-05 11:42:12.768] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.ModifySfUserTable.
  25. [2016-02-05 11:42:12.792] adding values to new columnsurrogate_id
  26. [2016-02-05 11:42:12.873] modified 38
  27. [2016-02-05 11:42:12.875] pushing values to user_login table
  28. [2016-02-05 11:42:12.892] inserted 38
  29. [2016-02-05 11:42:13.527] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.ModifyPasswordHistoryTable.
  30. [2016-02-05 11:42:13.600] adding rows to password_history table
  31. [2016-02-05 11:42:13.665] deleting old rows of password_history
  32. [2016-02-05 11:42:13.929] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddSfUserView.
  33. [2016-02-05 11:42:13.957] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddPasswordHistoryUserView.
  34. [2016-02-05 11:42:14.408] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddTaskBoardPreferenceTables.
  35. [2016-02-05 11:42:15.078] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddTaskBoardPreferenceSequences.
  36. [2016-02-05 11:42:15.119] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddUniqueConstraintIntegrationDataValue.
  37. [2016-02-05 11:42:15.119] Starting com.vasoftware.sf.migratorator.ctf71_ctf72.AddUniqueConstraintIntegrationDataValue
  38. [2016-02-05 11:42:15.352] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.AddBurndownViewModeColumnToPlanningFolder.
  39. [2016-02-05 11:42:15.391] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.ExpandCustomEventHandlersJarFileNameColumnLength.
  40. [2016-02-05 11:42:15.473] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
  41.  
  42. 2016-02-05 11:42:15,486 INFO Completed /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/50-migratorator-run.py in 6.586132 secon ds
  43. 2016-02-05 11:42:15,490 INFO Run script /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/55-reports-migratorator-run.py
  44. 2016-02-05 11:42:18,860 INFO Executing: /usr/java/jdk1.8.0_45/bin/java -cp migratorator.jar:sf_version.jar:saturn_common.jar:ctf-common.jar:saturn.jar:xe rcesImpl.jar:xml-apis.jar:xmlParserAPI.jar:log4j-1.2.8.jar:commons-digester.jar:commons-collections-3.2.1.jar:commons-logging.jar:commons-beanutils.jar:po stgresql-9.3-1102.jdbc41.jar:ojdbc14.jar:ctf-common.jar com.vasoftware.sf.migratorator.MigrationManager jdbc:oracle:thin:@halo.stanadyne.com:1521:halo tfa dmin tfadmin700* /opt/collabnet/teamforge/var/filestorage true jdbc:oracle:thin:@halo.stanadyne.com:1521:halo tfreport tfreport700* /opt/collabnet/teamf orge/var/filestorage ctf71_ctf72
  45. Migration script found: jar:file:/opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migratorator.jar!/com/vasoftware/sf/migratorator/ctf71_ct f72/reports_migration.xml
  46. Database timeout not set
  47. [2016-02-05 11:42:18.662] Executing migration script: com.vasoftware.sf.migratorator.ctf71_ctf72.UpdatePointsCapacityInPfDimension.
  48. [2016-02-05 11:42:18.818] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateReportsSchemaVersionTable.
  49.  
  50. 2016-02-05 11:42:18,862 INFO Completed /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/55-reports-migratorator-run.py in 3.3748 14 seconds
  51. 2016-02-05 11:42:18,865 INFO Run script /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/56-copy-custom-events-jar.py
  52. 2016-02-05 11:42:18,875 INFO Completed /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf71_ctf72/migration/56-copy-custom-events-jar.py in 0.012992 seconds
  53. 2016-02-05 11:42:18,876 INFO End-- version migration scripts
  54. 2016-02-05 11:42:18,876 INFO Start -- version validation scripts
  55. 2016-02-05 11:42:18,876 INFO No scripts found
  56. 2016-02-05 11:42:18,876 INFO End -- version validation scripts
  57. 2016-02-05 11:42:18,878 INFO end -- migration (version 7.2.0.0)
  58. 2016-02-05 11:42:18,878 INFO Start -- migration (version 8.0.0.0)
  59. 2016-02-05 11:42:18,906 INFO Starting migration at 2016-02-05 11:42:18 EST
  60.  
  61. 2016-02-05 11:42:18,907 INFO Start -- version sanity scripts
  62. 2016-02-05 11:42:18,907 INFO No scripts found
  63. 2016-02-05 11:42:18,907 INFO End -- version sanity scripts
  64. 2016-02-05 11:42:18,907 INFO Start -- version migration scripts
  65. 2016-02-05 11:42:18,910 INFO Run script /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf72_ctf80/migration/50-migratorator-run.py
  66.  
  67.  
  68. Traceback (most recent call last):
  69. File "./migrate.py", line 228, in <module>
  70. main()
  71. File "./migrate.py", line 193, in main
  72. versionsActivity.runVersionActivity(versions[versions.index(fromArg)+1:versions.index(toArg)+1])
  73. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 170, in runVersionActivity
  74. raise exceptions.MigrationException("Exception in version %s\n%s" %(version, ''.join(util.getStackTraceAndException())))
  75. MigrationException: Exception in version 8.0.0.0
  76. Traceback (most recent call last):
  77. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 164, in runVersionActivity
  78. activityObj.run()
  79. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 131, in run
  80. self.migrate()
  81. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 103, in migrate
  82. historyObj)
  83. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 187, in runOrderedScripts
  84. raise MigrationException, ''.join(getStackTraceAndException())
  85. MigrationException: Traceback (most recent call last):
  86. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 184, in runOrderedScripts
  87. historyObj, logger)
  88. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 221, in runMigrationScript
  89. raise MigrationException, ''.join(getStackTraceAndException())
  90. MigrationException: Traceback (most recent call last):
  91. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 215, in runMigrationScript
  92. runScriptFile(scriptFile, logger, scriptInfo)
  93. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 144, in runScriptFile
  94. return app.util.runScriptFile(scriptFile, logger, scriptInfo)
  95. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 324, in runScriptFile
  96. methodName, pythonLogger, version)
  97. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 186, in execPythonCode
  98. scriptFile, methodName)
  99. File "<string>", line 6, in <module>
  100. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/migration.py", line 71, in run
  101. self.migrate()
  102. File "<string>", line 49, in migrate
  103. MigrationException: Migratorator failed:
  104. Traceback (most recent call last):
  105. File "<string>", line 44, in migrate
  106. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 150, in executeCommand
  107. return app.util.executeCommand(command)
  108. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 60, in executeCommand
  109. 'output: %s' % (command, returncode, stderr, stdout)
  110. RuntimeError: /opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migrate.sh --database-type=oracle --hostname=halo.stanadyne.com --port=15 21 --database-name=halo --username=tfadmin --password='tfadmin700*' --filestorage='/opt/collabnet/teamforge/var/filestorage' ctf72_ctf80 failed with exit code 1
  111. Std Err: log4j:WARN No appenders could be found for logger (com.vasoftware.sf.common.util.XmlErrorHandler).
  112. log4j:WARN Please initialize the log4j system properly.
  113. java.lang.RuntimeException: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migr ate
  114. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:275)
  115. at com.vasoftware.sf.migratorator.MigrationManager.main(MigrationManager.java:115)
  116. Caused by: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  117. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:372)
  118. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:265)
  119. ... 1 more
  120. Caused by: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  121. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:164)
  122. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.execute(AddTeamFieldToTracker.java:88)
  123. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:359)
  124. ... 2 more
  125. Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  126.  
  127. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  128. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  129. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  130. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  131. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  132. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  133. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
  134. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  135. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
  136. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
  137. at com.vasoftware.sf.migratorator.DatabaseUtil.getIdMaxCounterValue(DatabaseUtil.java:704)
  138. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:146)
  139. ... 4 more
  140. Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  141. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:275)
  142. at com.vasoftware.sf.migratorator.MigrationManager.main(MigrationManager.java:115)
  143. Caused by: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  144. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:372)
  145. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:265)
  146. ... 1 more
  147. Caused by: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  148. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:164)
  149. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.execute(AddTeamFieldToTracker.java:88)
  150. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:359)
  151. ... 2 more
  152. Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  153.  
  154. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  155. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  156. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  157. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  158. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  159. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  160. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
  161. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  162. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
  163. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
  164. at com.vasoftware.sf.migratorator.DatabaseUtil.getIdMaxCounterValue(DatabaseUtil.java:704)
  165. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:146)
  166. ... 4 more
  167.  
  168. Stdoutput: Executing: /usr/java/jdk1.8.0_45/bin/java -cp migratorator.jar:sf_version.jar:saturn_common.jar:ctf-common.jar:saturn.jar:xercesImpl.jar:xml-a pis.jar:xmlParserAPI.jar:log4j-1.2.8.jar:commons-digester.jar:commons-collections-3.2.1.jar:commons-logging.jar:commons-beanutils.jar:postgresql-9.3-1102. jdbc41.jar:ojdbc14.jar:ctf-common.jar:commons-lang-2.6.jar:ctf-model.jar:tracker-core.jar com.vasoftware.sf.migratorator.MigrationManager jdbc:oracle:thin :@halo.stanadyne.com:1521:halo tfadmin tfadmin700* /opt/collabnet/teamforge/var/filestorage false ctf72_ctf80
  169. Migration script found: jar:file:/opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migratorator.jar!/com/vasoftware/sf/migratorator/ctf72_ct f80/migration.xml
  170. Running database schema migration: 7.2.0.0->8.0.0.0
  171. [2016-02-05 11:42:21.306] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
  172. [2016-02-05 11:42:21.466] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddFieldsCustomEventHandlersTable.
  173. [2016-02-05 11:42:21.523] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddTableTeam.
  174. [2016-02-05 11:42:21.787] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddSequenceForTableTeam.
  175. [2016-02-05 11:42:21.815] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.
  176. [2016-02-05 11:42:21.969] creating Team field for all existing trackers
  177. [2016-02-05 11:42:22.734] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
  178. 2016-02-05 11:52:26,707 INFO Changing working dir to /opt/collabnet/teamforge/dist
  179. 2016-02-05 11:52:26,708 INFO Start -- migration
  180. 2016-02-05 11:52:26,708 INFO Start -- Global sanity check scripts
  181. 2016-02-05 11:52:26,708 INFO No scripts found
  182. 2016-02-05 11:52:26,708 INFO End -- Global sanity check scripts
  183. 2016-02-05 11:52:26,719 INFO Start -- migration (version 8.0.0.0)
  184. 2016-02-05 11:52:26,871 INFO Starting migration at 2016-02-05 11:52:26 EST
  185.  
  186. 2016-02-05 11:52:26,885 INFO Start -- version sanity scripts
  187. 2016-02-05 11:52:26,885 INFO No scripts found
  188. 2016-02-05 11:52:26,885 INFO End -- version sanity scripts
  189. 2016-02-05 11:52:26,886 INFO Start -- version migration scripts
  190. 2016-02-05 11:52:26,895 INFO Abort history exists: /opt/collabnet/teamforge/var/migrations/ctf72_ctf80/migration/50-migratorator-run.py.abort
  191. 2016-02-05 11:52:26,895 INFO Aborted at /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf72_ctf80/migration/50-migratorator-run.py
  192.  
  193.  
  194. Traceback (most recent call last):
  195. File "./migrate.py", line 228, in <module>
  196. main()
  197. File "./migrate.py", line 193, in main
  198. versionsActivity.runVersionActivity(versions[versions.index(fromArg)+1:versions.index(toArg)+1])
  199. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 170, in runVersionActivity
  200. raise exceptions.MigrationException("Exception in version %s\n%s" %(version, ''.join(util.getStackTraceAndException())))
  201. MigrationException: Exception in version 8.0.0.0
  202. Traceback (most recent call last):
  203. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 164, in runVersionActivity
  204. activityObj.run()
  205. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 131, in run
  206. self.migrate()
  207. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 103, in migrate
  208. historyObj)
  209. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 187, in runOrderedScripts
  210. raise MigrationException, ''.join(getStackTraceAndException())
  211. MigrationException: Traceback (most recent call last):
  212. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 184, in runOrderedScripts
  213. historyObj, logger)
  214. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 204, in runMigrationScript
  215. historyObj.getHistoryFolder())))
  216. Exception: Abort history file exists : /opt/collabnet/teamforge/var/migrations/ctf72_ctf80/migration/50-migratorator-run.py.abort
  217. To rerun migration, rectify the migration failure cause, remove the abort file and run the migration script again.
  218. To rerun migration from the start, rectify the migration failure cause, remove the migration history folder /opt/collabnet/teamforge/var/migrations/ctf72_ ctf80/migration and run the migration process again.2016-02-05 12:06:43,851 INFO Changing working dir to /opt/collabnet/teamforge/dist
  219. 2016-02-05 12:06:43,852 INFO Start -- migration
  220. 2016-02-05 12:06:43,852 INFO Start -- Global sanity check scripts
  221. 2016-02-05 12:06:43,852 INFO No scripts found
  222. 2016-02-05 12:06:43,852 INFO End -- Global sanity check scripts
  223. 2016-02-05 12:06:43,853 INFO Start -- migration (version 8.0.0.0)
  224. 2016-02-05 12:06:43,882 INFO Starting migration at 2016-02-05 12:06:43 EST
  225.  
  226. 2016-02-05 12:06:43,882 INFO Start -- version sanity scripts
  227. 2016-02-05 12:06:43,882 INFO No scripts found
  228. 2016-02-05 12:06:43,883 INFO End -- version sanity scripts
  229. 2016-02-05 12:06:43,883 INFO Start -- version migration scripts
  230. 2016-02-05 12:06:43,883 INFO Abort history exists: /opt/collabnet/teamforge/var/migrations/ctf72_ctf80/migration/50-migratorator-run.py.abort
  231. 2016-02-05 12:06:43,883 INFO Aborted at /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf72_ctf80/migration/50-migratorator-run.py
  232.  
  233.  
  234. Traceback (most recent call last):
  235. File "./migrate.py", line 228, in <module>
  236. main()
  237. File "./migrate.py", line 193, in main
  238. versionsActivity.runVersionActivity(versions[versions.index(fromArg)+1:versions.index(toArg)+1])
  239. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 170, in runVersionActivity
  240. raise exceptions.MigrationException("Exception in version %s\n%s" %(version, ''.join(util.getStackTraceAndException())))
  241. MigrationException: Exception in version 8.0.0.0
  242. Traceback (most recent call last):
  243. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 164, in runVersionActivity
  244. activityObj.run()
  245. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 131, in run
  246. self.migrate()
  247. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 103, in migrate
  248. historyObj)
  249. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 187, in runOrderedScripts
  250. raise MigrationException, ''.join(getStackTraceAndException())
  251. MigrationException: Traceback (most recent call last):
  252. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 184, in runOrderedScripts
  253. historyObj, logger)
  254. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 204, in runMigrationScript
  255. historyObj.getHistoryFolder())))
  256. Exception: Abort history file exists : /opt/collabnet/teamforge/var/migrations/ctf72_ctf80/migration/50-migratorator-run.py.abort
  257. To rerun migration, rectify the migration failure cause, remove the abort file and run the migration script again.
  258. To rerun migration from the start, rectify the migration failure cause, remove the migration history folder /opt/collabnet/teamforge/var/migrations/ctf72_ ctf80/migration and run the migration process again.2016-02-05 12:07:22,576 INFO Changing working dir to /opt/collabnet/teamforge/dist
  259. 2016-02-05 12:07:22,577 INFO Start -- migration
  260. 2016-02-05 12:07:22,577 INFO Start -- Global sanity check scripts
  261. 2016-02-05 12:07:22,578 INFO No scripts found
  262. 2016-02-05 12:07:22,578 INFO End -- Global sanity check scripts
  263. 2016-02-05 12:07:22,578 INFO Start -- migration (version 8.0.0.0)
  264. 2016-02-05 12:07:22,607 INFO Starting migration at 2016-02-05 12:07:22 EST
  265.  
  266. 2016-02-05 12:07:22,607 INFO Start -- version sanity scripts
  267. 2016-02-05 12:07:22,608 INFO No scripts found
  268. 2016-02-05 12:07:22,608 INFO End -- version sanity scripts
  269. 2016-02-05 12:07:22,608 INFO Start -- version migration scripts
  270. 2016-02-05 12:07:22,612 INFO Run script /opt/collabnet/teamforge/dist/hook-scripts/migration/ctf72_ctf80/migration/50-migratorator-run.py
  271.  
  272.  
  273. Traceback (most recent call last):
  274. File "./migrate.py", line 228, in <module>
  275. main()
  276. File "./migrate.py", line 193, in main
  277. versionsActivity.runVersionActivity(versions[versions.index(fromArg)+1:versions.index(toArg)+1])
  278. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 170, in runVersionActivity
  279. raise exceptions.MigrationException("Exception in version %s\n%s" %(version, ''.join(util.getStackTraceAndException())))
  280. MigrationException: Exception in version 8.0.0.0
  281. Traceback (most recent call last):
  282. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/VersionsActivity.py", line 164, in runVersionActivity
  283. activityObj.run()
  284. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 131, in run
  285. self.migrate()
  286. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/activity.py", line 103, in migrate
  287. historyObj)
  288. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 187, in runOrderedScripts
  289. raise MigrationException, ''.join(getStackTraceAndException())
  290. MigrationException: Traceback (most recent call last):
  291. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 184, in runOrderedScripts
  292. historyObj, logger)
  293. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 221, in runMigrationScript
  294. raise MigrationException, ''.join(getStackTraceAndException())
  295. MigrationException: Traceback (most recent call last):
  296. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 215, in runMigrationScript
  297. runScriptFile(scriptFile, logger, scriptInfo)
  298. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 144, in runScriptFile
  299. return app.util.runScriptFile(scriptFile, logger, scriptInfo)
  300. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 324, in runScriptFile
  301. methodName, pythonLogger, version)
  302. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 186, in execPythonCode
  303. scriptFile, methodName)
  304. File "<string>", line 6, in <module>
  305. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/migration.py", line 71, in run
  306. self.migrate()
  307. File "<string>", line 49, in migrate
  308. MigrationException: Migratorator failed:
  309. Traceback (most recent call last):
  310. File "<string>", line 44, in migrate
  311. File "/opt/collabnet/teamforge/dist/multiplatform/scast-upgrade/core/util.py", line 150, in executeCommand
  312. return app.util.executeCommand(command)
  313. File "/opt/collabnet/teamforge/dist/lib/multiplatform/python/app/util.py", line 60, in executeCommand
  314. 'output: %s' % (command, returncode, stderr, stdout)
  315. RuntimeError: /opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migrate.sh --database-type=oracle --hostname=halo.stanadyne.com --port=15 21 --database-name=halo --username=tfadmin --password='tfadmin700*' --filestorage='/opt/collabnet/teamforge/var/filestorage' ctf72_ctf80 failed with exit code 1
  316. Std Err: log4j:WARN No appenders could be found for logger (com.vasoftware.sf.common.util.XmlErrorHandler).
  317. log4j:WARN Please initialize the log4j system properly.
  318. java.lang.RuntimeException: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migr ate
  319. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:275)
  320. at com.vasoftware.sf.migratorator.MigrationManager.main(MigrationManager.java:115)
  321. Caused by: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  322. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:372)
  323. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:265)
  324. ... 1 more
  325. Caused by: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  326. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:164)
  327. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.execute(AddTeamFieldToTracker.java:88)
  328. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:359)
  329. ... 2 more
  330. Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  331.  
  332. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  333. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  334. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  335. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  336. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  337. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  338. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
  339. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  340. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
  341. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
  342. at com.vasoftware.sf.migratorator.DatabaseUtil.getIdMaxCounterValue(DatabaseUtil.java:704)
  343. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:146)
  344. ... 4 more
  345. Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  346. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:275)
  347. at com.vasoftware.sf.migratorator.MigrationManager.main(MigrationManager.java:115)
  348. Caused by: java.lang.RuntimeException: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  349. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:372)
  350. at com.vasoftware.sf.migratorator.MigrationManager.executeMigration(MigrationManager.java:265)
  351. ... 1 more
  352. Caused by: com.vasoftware.sf.migratorator.MigrationException: Database Problems in AddTeamFieldToTracker migrate
  353. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:164)
  354. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.execute(AddTeamFieldToTracker.java:88)
  355. at com.vasoftware.sf.migratorator.MigrationManager.executeMigrationScript(MigrationManager.java:359)
  356. ... 2 more
  357. Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  358.  
  359. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  360. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  361. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  362. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  363. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  364. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  365. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
  366. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  367. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
  368. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
  369. at com.vasoftware.sf.migratorator.DatabaseUtil.getIdMaxCounterValue(DatabaseUtil.java:704)
  370. at com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.createTeamField(AddTeamFieldToTracker.java:146)
  371. ... 4 more
  372.  
  373. Stdoutput: Executing: /usr/java/jdk1.8.0_45/bin/java -cp migratorator.jar:sf_version.jar:saturn_common.jar:ctf-common.jar:saturn.jar:xercesImpl.jar:xml-a pis.jar:xmlParserAPI.jar:log4j-1.2.8.jar:commons-digester.jar:commons-collections-3.2.1.jar:commons-logging.jar:commons-beanutils.jar:postgresql-9.3-1102. jdbc41.jar:ojdbc14.jar:ctf-common.jar:commons-lang-2.6.jar:ctf-model.jar:tracker-core.jar com.vasoftware.sf.migratorator.MigrationManager jdbc:oracle:thin :@halo.stanadyne.com:1521:halo tfadmin tfadmin700* /opt/collabnet/teamforge/var/filestorage false ctf72_ctf80
  374. Migration script found: jar:file:/opt/collabnet/teamforge/dist/migratorator/migratorator_8.1.0.1/migratorator.jar!/com/vasoftware/sf/migratorator/ctf72_ct f80/migration.xml
  375. Running database schema migration: 7.2.0.0->8.0.0.0
  376. [2016-02-05 12:07:25.086] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
  377. [2016-02-05 12:07:25.269] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddFieldsCustomEventHandlersTable.
  378. [2016-02-05 12:07:25.294] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddTableTeam.
  379. [2016-02-05 12:07:25.663] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddSequenceForTableTeam.
  380. [2016-02-05 12:07:25.686] Executing migration script: com.vasoftware.sf.migratorator.ctf72_ctf80.AddTeamFieldToTracker.
  381. [2016-02-05 12:07:25.711] creating Team field for all existing trackers
  382. [2016-02-05 12:07:26.477] Executing migration script: com.vasoftware.sf.migratorator.general.UpdateSchemaVersionTable.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!