Project

General

Profile

Forums » Help »

[solved] DB problem when upgrading a Redmine 1.3.1.devel (MySQL) to 3.1

Added by Ben Blanco over 8 years ago

Hi,

I'm trying to upgrade an old Redmine instance running 1.3.1.devel (MySQL) to 3.1.

I've run into an error when running the bundle exec rake db:migrate RAILS_ENV=production

rake aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: SHOW FULL FIELDS FROM `Users_Report`

Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Tasks: TOP => db:schema:dump
(See full trace by running task with --trace)
On my server I have:
  • mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (x86_64) using readline 6.2
  • ruby 2.1.7p400 (2015-08-18 revision 51632) [x86_64-linux] (using rbenv)

Seeing that in the RedmineUpgrade it says:

"If you're running Redmine >= 1.4 with mysql and ruby1.9, change the database adapter to `mysql2`."

I checked mysql2 gem's compatibility info, and it seems to be fine for use with ruby 2.1.x.

Any idea how I can troubleshoot/solve the above db:migrate error?

Thx!


Replies (4)

RE: DB problem when upgrading a Redmine 1.3.1.devel (MySQL) to 3.1 - Added by Ben Blanco over 8 years ago

I've checked legacy plugins, and none changed the DB.

I've also tried to advance on the mysql2 gem's error message, and got the following step further:

mysql> SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'redmine' AND TABLE_NAME = 'Users_Report';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| VIEW_DEFINITION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| select `redmine`.`users`.`id` AS `id`,`redmine`.`users`.`login` AS `login`,`redmine`.`users`.`mail` AS `mail`,`redmine`.`users`.`firstname` AS `firstname`,`redmine`.`users`.`lastname` AS `lastname`,`redmine`.`users`.`status` AS `status`,`redmine`.`users`.`language` AS `language`,`redmine`.`users`.`type` AS `type`,`redmine`.`users`.`created_on` AS `created_on`,`redmine`.`users`.`last_login_on` AS `last_login`,`users_1`.`lastname` AS `groupname` from ((`redmine`.`users` left join `redmine`.`groups_users` on((`redmine`.`users`.`id` = `redmine`.`groups_users`.`user_id`))) left join `redmine`.`users` `users_1` on((`redmine`.`groups_users`.`group_id` = `users_1`.`id`))) where (`redmine`.`users`.`type` = 'User') order by `redmine`.`users`.`created_on` |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

I then checked Grant privileges, which I think are correct (if someone could confirm that, that would be very cool):

mysql> SHOW GRANTS FOR CURRENT_USER;
+-----------------------------------------------------------------------------+
| Grants for redmine@localhost                                                |
+-----------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'redmine'@'localhost' IDENTIFIED BY PASSWORD <secret> |
| GRANT SELECT, LOCK TABLES ON `REDMINE`.* TO 'redmine'@'localhost'           |
| GRANT ALL PRIVILEGES ON `redmine`.* TO 'redmine'@'localhost'                |
+-----------------------------------------------------------------------------+
3 rows in set (0.00 sec)

RE: DB problem when upgrading a Redmine 1.3.1.devel (MySQL) to 3.1 - Added by Ben Blanco over 8 years ago

here is the full --trace on the rake db:migrate

bundle exec rake db:migrate RAILS_ENV=production --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
** Invoke db:_dump (first_time)
** Execute db:_dump
** Invoke db:schema:dump (first_time)
** Invoke environment 
** Invoke db:load_config 
** Execute db:schema:dump
rake aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: SHOW FULL FIELDS FROM `Users_Report`
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/mysql2_adapter.rb:211:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:84:in `table'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:79:in `block in tables'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:70:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:70:in `tables'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:27:in `dump'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:21:in `dump'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:393:in `block (4 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:392:in `open'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:392:in `block (3 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:201:in `block (2 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:196:in `block (2 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'
/home/sven/.rbenv/versions/2.1.7/bin/rake:23:in `load'
/home/sven/.rbenv/versions/2.1.7/bin/rake:23:in `<main>'
Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/mysql2_adapter.rb:211:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:84:in `table'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:79:in `block in tables'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:70:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:70:in `tables'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:27:in `dump'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/schema_dumper.rb:21:in `dump'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:393:in `block (4 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:392:in `open'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:392:in `block (3 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:201:in `block (2 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:196:in `block (2 levels) in <top (required)>'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'
/home/sven/.rbenv/versions/2.1.7/lib/ruby/gems/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'
/home/sven/.rbenv/versions/2.1.7/bin/rake:23:in `load'
/home/sven/.rbenv/versions/2.1.7/bin/rake:23:in `<main>'
Tasks: TOP => db:schema:dump

RE: DB problem when upgrading a Redmine 1.3.1.devel (MySQL) to 3.1 - Added by Ben Blanco over 8 years ago

I've done a checkout of redmine 2.3-stable, and can get it up and running using 

rails s -e production

I can log in using http://x.x.x.x:3000, and all seems fine

However, when I try to access it via the apache2 server, I get redmine's error page:

We're sorry, but something went wrong.

We've been notified about this issue and we'll take a look at it shortly.

checking the log file

tail -n 20 log/production.log | tac

I see:

Completed 200 OK in 245ms (Views: 78.5ms | ActiveRecord: 19.8ms)
  Rendered welcome/index.html.erb within layouts/base (60.6ms)
  Rendered news/_news.html.erb (12.2ms)
  Current user: anonymous
Processing by WelcomeController#index as HTML
Started GET "/" for 10.0.52.54 at 2015-10-21 11:49:15 +0100
Creating scope :sorted. Overwriting existing method User.sorted.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :system. Overwriting existing method Enumeration.system.
OpenIdAuthentication.store is nil. Using in-memory store.
Connecting to database specified by database.yml
Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: SHOW FULL FIELDS FROM `Users_Report`
Mysql2::Error: View 'redmine.Users_Report' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: SHOW FULL FIELDS FROM `Users_Report`

Any help/idea welcome, as I'm currently at a loss seeing what next step I can try...

RE: DB problem when upgrading a Redmine 1.3.1.devel (MySQL) to 3.1 - Added by Ben Blanco over 8 years ago

Ok. This is sorted. I got redmine to update to 3.1.0-stable :)

After further tests, I realized that the SQL error was being caused by a custom (& outdated, hence the error) view which is not part of stock redmine db.

Whereas, at first, I wrongly assumed this Users_Report view was a "genuine" redmine db view, and thus focused on definer/invoker of view lack rights to use them part of the error message, it actually was the references invalid table(s) or column(s) or function(s) which was causing the migration to fail.

So, easiest fix was to remove the view & then run the rake db:migrate

mysql -u root -p
   use redmine;
   drop view Users_Report ;
   exit
bundle exec rake db:migrate RAILS_ENV=production
    (1-4/4)