API tools faq
paste
Guest User

Untitled

a guest
Oct 23rd, 2019
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.83 KB | None | 0 0
raw download clone embed print report
  1. gitlab_1 | * bash[migrate gitlab-rails database] action run
  2. gitlab_1 | [execute] rake aborted!
  3. gitlab_1 | StandardError: An error has occurred, all later migrations canceled:
  4. gitlab_1 |
  5. gitlab_1 | Multiple indexes found on ci_trigger_requests columns [:trigger_id]. Specify an index name from ci_trigger_requests_trigger_id_idx, fk_rails_b8ec8b7245, index_ci_trigger_requests_on_trigger_id
  6. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:121:in `block in remove_concurrent_index'
  7. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:252:in `disable_statement_timeout'
  8. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:120:in `remove_concurrent_index'
  9. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20191016072826_replace_ci_trigger_requests_index.rb:13:in `up'
  10. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
  11. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
  12. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
  13. gitlab_1 |
  14. gitlab_1 | Caused by:
  15. gitlab_1 | ArgumentError: Multiple indexes found on ci_trigger_requests columns [:trigger_id]. Specify an index name from ci_trigger_requests_trigger_id_idx, fk_rails_b8ec8b7245, index_ci_trigger_requests_on_trigger_id
  16. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:121:in `block in remove_concurrent_index'
  17. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:252:in `disable_statement_timeout'
  18. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:120:in `remove_concurrent_index'
  19. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20191016072826_replace_ci_trigger_requests_index.rb:13:in `up'
  20. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
  21. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
  22. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
  23. gitlab_1 | Tasks: TOP => db:migrate
  24. gitlab_1 | (See full trace by running task with --trace)
  25. gitlab_1 | == 20191016072826 ReplaceCiTriggerRequestsIndex: migrating ====================
  26. gitlab_1 | -- transaction_open?()
  27. gitlab_1 | -> 0.0000s
  28. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
  29. gitlab_1 | -> 0.0081s
  30. gitlab_1 | -- transaction_open?()
  31. gitlab_1 | -> 0.0000s
  32. gitlab_1 | -- select_one("SELECT current_setting('server_version_num') AS v")
  33. gitlab_1 | -> 0.0004s
  34. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
  35. gitlab_1 | -> 0.0042s
  36. gitlab_1 | -- execute("SET statement_timeout TO 0")
  37. gitlab_1 | -> 0.0002s
  38. gitlab_1 | -- remove_index(:ci_trigger_requests, {:algorithm=>:concurrently, :column=>[:trigger_id]})
  39. gitlab_1 | -- execute("RESET ALL")
  40. gitlab_1 | -> 0.0002s
  41. gitlab_1 |
  42. gitlab_1 | ================================================================================
  43. gitlab_1 | Error executing action `run` on resource 'bash[migrate gitlab-rails database]'
  44. gitlab_1 | ================================================================================
  45. gitlab_1 |
  46. gitlab_1 | Mixlib::ShellOut::ShellCommandFailed
  47. gitlab_1 | ------------------------------------
  48. gitlab_1 | Expected process to exit with [0], but received '1'
  49. gitlab_1 | ---- Begin output of "bash" "/tmp/chef-script20191023-27-1ttcn9o" ----
  50. gitlab_1 | STDOUT: rake aborted!
  51. gitlab_1 | StandardError: An error has occurred, all later migrations canceled:
  52. gitlab_1 |
  53. gitlab_1 | Multiple indexes found on ci_trigger_requests columns [:trigger_id]. Specify an index name from ci_trigger_requests_trigger_id_idx, fk_rails_b8ec8b7245, index_ci_trigger_requests_on_trigger_id
  54. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:121:in `block in remove_concurrent_index'
  55. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:252:in `disable_statement_timeout'
  56. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:120:in `remove_concurrent_index'
  57. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20191016072826_replace_ci_trigger_requests_index.rb:13:in `up'
  58. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
  59. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
  60. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
  61. gitlab_1 | Tasks: TOP => db:migrate
  62. gitlab_1 | (See full trace by running task with --trace)
  63. gitlab_1 | == 20191016072826 ReplaceCiTriggerRequestsIndex: migrating ====================
  64. gitlab_1 | -- transaction_open?()
  65. gitlab_1 | -> 0.0000s
  66. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
  67. gitlab_1 | -> 0.0080s
  68. gitlab_1 | -- transaction_open?()
  69. gitlab_1 | -> 0.0000s
  70. gitlab_1 | -- select_one("SELECT current_setting('server_version_num') AS v")
  71. gitlab_1 | -> 0.0005s
  72. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
  73. gitlab_1 | -> 0.0042s
  74. gitlab_1 | -- execute("SET statement_timeout TO 0")
  75. gitlab_1 | -> 0.0003s
  76. gitlab_1 | -- remove_index(:ci_trigger_requests, {:algorithm=>:concurrently, :column=>[:trigger_id]})
  77. gitlab_1 | -- execute("RESET ALL")
  78. gitlab_1 | -> 0.0003s
  79. gitlab_1 | STDERR:
  80. gitlab_1 | ---- End output of "bash" "/tmp/chef-script20191023-24-bjjln9" ----
  81. gitlab_1 | Ran "bash" "/tmp/chef-script20191023-24-bjjln9" returned 1
  82. gitlab_1 |
  83. gitlab_1 | Resource Declaration:
  84. gitlab_1 | ---------------------
  85. gitlab_1 | # In /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb
  86. gitlab_1 |
  87. gitlab_1 | 54: bash "migrate gitlab-rails database" do
  88. gitlab_1 | 55: code <<-EOH
  89. gitlab_1 | 56: set -e
  90. gitlab_1 | 57: log_file="#{node['gitlab']['gitlab-rails']['log_directory']}/gitlab-rails-db-migrate-$(date +%Y-%m-%d-%H-%M-%S).log"
  91. gitlab_1 | 58: umask 077
  92. gitlab_1 | 59: /opt/gitlab/bin/gitlab-rake gitlab:db:configure 2>& 1 | tee ${log_file}
  93. gitlab_1 | 60: STATUS=${PIPESTATUS[0]}
  94. gitlab_1 | 61: chown #{account_helper.gitlab_user}:#{account_helper.gitlab_group} ${log_file}
  95. gitlab_1 | 62: echo $STATUS > #{db_migrate_status_file}
  96. gitlab_1 | 63: exit $STATUS
  97. gitlab_1 | 64: EOH
  98. gitlab_1 | 65: environment env_variables unless env_variables.empty?
  99. gitlab_1 | 66: notifies :run, "execute[clear the gitlab-rails cache]", :immediately
  100. gitlab_1 | 67: dependent_services.each do |svc|
  101. gitlab_1 | 68: notifies :restart, svc, :immediately
  102. gitlab_1 | 69: end
  103. gitlab_1 | 70: not_if "(test -f #{db_migrate_status_file}) && (cat #{db_migrate_status_file} | grep -Fx 0)"
  104. gitlab_1 | 71: only_if { node['gitlab']['gitlab-rails']['auto_migrate'] }
  105. gitlab_1 | 72: end
  106. gitlab_1 | 73:
  107. gitlab_1 |
  108. gitlab_1 | Compiled Resource:
  109. gitlab_1 | ------------------
  110. gitlab_1 | # Declared in /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb:54:in `from_file'
  111. gitlab_1 |
  112. gitlab_1 | bash("migrate gitlab-rails database") do
  113. gitlab_1 | action [:run]
  114. gitlab_1 | default_guard_interpreter :default
  115. gitlab_1 | command nil
  116. gitlab_1 | backup 5
  117. gitlab_1 | interpreter "bash"
  118. gitlab_1 | declared_type :bash
  119. gitlab_1 | cookbook_name "gitlab"
  120. gitlab_1 | recipe_name "database_migrations"
  121. gitlab_1 | code " set -e\n log_file=\"/var/log/gitlab/gitlab-rails/gitlab-rails-db-migrate-$(date +%Y-%m-%d-%H-%M-%S).log\"\n umask 077\n /opt/gitlab/bin/gitlab-rake gitlab:db:configure 2>& 1 | tee ${log_file}\n STATU
  122. S=${PIPESTATUS[0]}\n chown git:git ${log_file}\n echo $STATUS > /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-1425a56c75b\n exit $STATUS\n"
  123. gitlab_1 | domain nil
  124. gitlab_1 | user nil
  125. gitlab_1 | not_if "(test -f /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-1425a56c75b) && (cat /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-1425a56
  126. c75b | grep -Fx 0)"
  127. gitlab_1 | only_if { #code block }
  128. gitlab_1 | end
  129. gitlab_1 |
  130. gitlab_1 | System Info:
  131. gitlab_1 | ------------
  132. gitlab_1 | chef_version=14.13.11
  133. gitlab_1 | platform=ubuntu
  134. gitlab_1 | platform_version=16.04
  135. gitlab_1 | ruby=ruby 2.6.3p62 (2019-04-16 revision 67580) [x86_64-linux]
  136. gitlab_1 | program_name=/opt/gitlab/embedded/bin/chef-client
  137. gitlab_1 | executable=/opt/gitlab/embedded/bin/chef-client
  138. gitlab_1 |
  139. gitlab_1 |
  140. gitlab_1 | Running handlers:
  141. gitlab_1 | There was an error running gitlab-ctl reconfigure:
  142. gitlab_1 |
  143. gitlab_1 | bash[migrate gitlab-rails database] (gitlab::database_migrations line 54) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
  144. gitlab_1 | ---- Begin output of "bash" "/tmp/chef-script20191023-24-bjjln9" ----
  145. gitlab_1 | STDOUT: rake aborted!
  146. gitlab_1 | StandardError: An error has occurred, all later migrations canceled:
  147. gitlab_1 |
  148. gitlab_1 | Multiple indexes found on ci_trigger_requests columns [:trigger_id]. Specify an index name from ci_trigger_requests_trigger_id_idx, fk_rails_b8ec8b7245, index_ci_trigger_requests_on_trigger_id
  149. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:121:in `block in remove_concurrent_index'
  150. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:252:in `disable_statement_timeout'
  151. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:120:in `remove_concurrent_index'
  152. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20191016072826_replace_ci_trigger_requests_index.rb:13:in `up'
  153. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
  154. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
  155. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
  156. gitlab_1 |
  157. gitlab_1 | Caused by:
  158. gitlab_1 | ArgumentError: Multiple indexes found on ci_trigger_requests columns [:trigger_id]. Specify an index name from ci_trigger_requests_trigger_id_idx, fk_rails_b8ec8b7245, index_ci_trigger_requests_on_trigger_id
  159. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:121:in `block in remove_concurrent_index'
  160. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:252:in `disable_statement_timeout'
  161. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:120:in `remove_concurrent_index'
  162. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20191016072826_replace_ci_trigger_requests_index.rb:13:in `up'
  163. gitlab_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
  164. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
  165. gitlab_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
  166. gitlab_1 | Tasks: TOP => db:migrate
  167. gitlab_1 | (See full trace by running task with --trace)
  168. gitlab_1 | == 20191016072826 ReplaceCiTriggerRequestsIndex: migrating ====================
  169. gitlab_1 | -- transaction_open?()
  170. gitlab_1 | -> 0.0000s
  171. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id, :id], {:order=>{:id=>:desc}, :algorithm=>:concurrently})
  172. gitlab_1 | -> 0.0080s
  173. gitlab_1 | -- transaction_open?()
  174. gitlab_1 | -> 0.0000s
  175. gitlab_1 | -- select_one("SELECT current_setting('server_version_num') AS v")
  176. gitlab_1 | -> 0.0005s
  177. gitlab_1 | -- index_exists?(:ci_trigger_requests, [:trigger_id], {:algorithm=>:concurrently})
  178. gitlab_1 | -> 0.0042s
  179. gitlab_1 | -- execute("SET statement_timeout TO 0")
  180. gitlab_1 | -> 0.0003s
  181. gitlab_1 | -- remove_index(:ci_trigger_requests, {:algorithm=>:concurrently, :column=>[:trigger_id]})
  182. gitlab_1 | -- execute("RESET ALL")
  183. gitlab_1 | -> 0.0003s
  184. gitlab_1 | STDERR:
  185. gitlab_1 | ---- End output of "bash" "/tmp/chef-script20191023-24-bjjln9" ----
  186. gitlab_1 | Ran "bash" "/tmp/chef-script20191023-24-bjjln9" returned 1
  187. gitlab_1 |
  188. gitlab_1 | Running handlers complete
  189. gitlab_1 | Chef Client failed. 8 resources updated in 24 seconds
  190. gitlab_gitlab_1 exited with code 1
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!