Redmine/Oracle - Invalid big Decimal Value

Added by Matthew Rupert over 6 years ago

Added by Matthew Rupert about 16 hours ago

I'm so close, but now when I do:
RAILS_ENV=production rake db:migrate --trace

I get:
Sorry, I posted this in the general forum when I probably should have posted it here.

(in /opt/redmine-1.1.2)
rake aborted!
Invalid big Decimal Value
(See full trace by running task with --trace)
uslzt50x:/opt/redmine/config> RAILS_ENV=production rake db:migrate --trace
(in /opt/redmine-1.1.2)

  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Invalid big Decimal Value
    /opt/redmine-1.1.2/config/initializers/bigdecimal-segfault-fix.rb:26:in `BigDecimal'
    /usr/local/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4/lib/oci8/bindtype.rb:34:in `to_d'
    /usr/local/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4/lib/oci8/bindtype.rb:34:in `get'
    /usr/local/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4/lib/oci8/oci8.rb:119:in `fetch'
    /usr/local/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.4/lib/oci8/oci8.rb:119:in `exec'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:396:in `ping'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:62:in `ping'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:463:in `active?'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `verify!'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:256:in `checkout_and_verify'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:247:in `checkout_new_connection'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
    /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'
    /opt/redmine-1.1.2/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:217:in `quoted_left_column_name'
    /opt/redmine-1.1.2/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:93:in `acts_as_nested_set'
    /opt/redmine-1.1.2/app/models/issue.rb:37
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
    /opt/redmine-1.1.2/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:96:in `const_missing'
    /opt/redmine-1.1.2/app/models/project.rb:40
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
    /opt/redmine-1.1.2/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:96:in `const_missing'
    /opt/redmine-1.1.2/app/models/attachment.rb:36
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
    /opt/redmine-1.1.2/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/plugins/acts_as_attachable/lib/acts_as_attachable.rb:33:in `acts_as_attachable'
    /opt/redmine-1.1.2/app/models/message.rb:22
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
    /opt/redmine-1.1.2/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/inflector.rb:361:in `constantize'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `each'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `constantize'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/core_ext/string/inflections.rb:162:in `constantize'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:157:in `observed_class'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:183:in `observed_classes'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:166:in `initialize'
    /usr/local/lib/ruby/1.8/singleton.rb:94:in `new'
    /usr/local/lib/ruby/1.8/singleton.rb:94:in `instance'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:38:in `instantiate_observers'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `each'
    /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `instantiate_observers'
    /opt/redmine-1.1.2/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:15:in `define_dispatcher_callbacks'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `call'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `evaluate_method'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `each'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `send'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
    /opt/redmine-1.1.2/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `send'
    /opt/redmine-1.1.2/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `run_prepare_callbacks'
    /opt/redmine-1.1.2/config/../vendor/rails/railties/lib/initializer.rb:631:in `prepare_dispatcher'
    /opt/redmine-1.1.2/config/../vendor/rails/railties/lib/initializer.rb:185:in `process'
    /opt/redmine-1.1.2/config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
    /opt/redmine-1.1.2/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
    /opt/redmine-1.1.2/config/environment.rb:23
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
    /opt/redmine-1.1.2/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /opt/redmine-1.1.2/vendor/rails/railties/lib/tasks/misc.rake:4
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
    /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:607:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain'
    /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31

Can anyone assist???? THANKS!

Replies (4)

RE: Redmine/Oracle - Invalid big Decimal Value - Added by Sergey Tischenko over 6 years ago

Matthew Rupert wrote:

RAILS_ENV=production rake db:migrate --trace

I get:
Sorry, I posted this in the general forum when I probably should have posted it here.

(in /opt/redmine-1.1.2)
rake aborted!
Invalid big Decimal Value

Can anyone assist???? THANKS!

I have the same problem :(
Google search did not give anything useful.

RE: Redmine/Oracle - Invalid big Decimal Value - Added by Don Doffe about 6 years ago

I have run into the same issue.

Was anybody able to resolve this? Do we need to raise an issue?

RE: Redmine/Oracle - Invalid big Decimal Value - Added by Etienne Massip about 6 years ago

If you're using Ruby 1.8.6 version p369 or later or Ruby 1.8.7 version p173 or later, then you can try to remove the config/initializers/bigdecimal-segfault-fix.rb file.

RE: Redmine/Oracle - Invalid big Decimal Value - Added by Kevin O almost 6 years ago

I can confirm that deleting config/initializers/bigdecimal-segfault-fix.rb does indeed work.

(1-4/4)