Ask Your Question
0

MariaDB database migration issue

asked 2014-11-07 02:51:12 -0500

bigmike2238 gravatar image

Hello,

I have spent the better part of tonight trying to set up puppet-dasboard. I have gotten to the point where DB entries are being inserted. The problem is, a syntax error is keeping the process from completing. Here is the output:

rake aborted! An error has occurred, all later migrations canceled:

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name))' at line 1: CREATE INDEX indexnodelowername ON nodes (lower(name)) /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/connectionadapters/abstractmysqladapter.rb:245:in query' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inblock in execute' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/connectionadapters/abstractadapter.rb:280:in block in log' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activesupport-3.2.20/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/connectionadapters/abstractadapter.rb:275:in log' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inexecute' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/connectionadapters/mysql2adapter.rb:213:in execute' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:466:inblock in methodmissing' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/migration.rb:438:in block in say_with_time' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:438:insaywithtime' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/migration.rb:458:in method_missing' /opt/puppet/share/puppet-dashboard/db/migrate/20131210204300_lower_node_name_index.rb:4:inup' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/migration.rb:410:in block (2 levels) in migrate' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:410:inblock in migrate' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/connectionadapters/abstract/connectionpool.rb:129:in with_connection' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:389:inmigrate' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/migration.rb:528:in migrate' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:720:inblock (2 levels) in migrate' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/activerecord/migration.rb:777:in call' /usr/local/rvm/gems/ruby-1.9.3-p550/gems/activerecord-3.2.20/lib/active_record/migration.rb:777:inddltransaction' /usr/local ... (more)

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2014-11-09 11:32:27 -0500

bigmike2238 gravatar image

Issue resolved. Went back to the drawing board, and everything is now functional.

Mike

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2014-11-07 02:51:12 -0500

Seen: 85 times

Last updated: Nov 09 '14