[one-users] Upgrade 4.6 to 4.8 (beta) - onedb fsck report an error

Tue Jul 29 18:14:06 PDT 2014

Hi,

Below is the output from debug.

[oneadmin at opennebula ~]$ ruby -d /usr/bin/onedb fsck -f -S localhost -u oneadmin -p ****** -d opennebula
/usr/lib/one/ruby/cli/command_parser.rb:434: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/cli/command_parser.rb:496: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/cli/command_parser.rb:507: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/cli/command_parser.rb:524: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/cli/command_parser.rb:543: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/cli/command_parser.rb:572: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/onedb/onedb.rb:30: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/onedb/onedb.rb:40: warning: ambiguous first argument; put parentheses or even spaces
/usr/lib/one/ruby/onedb/onedb_backend.rb:24: warning: ambiguous first argument; put parentheses or even spaces
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems.rb:1113 - no such file to load -- rubygems/defaults/operating_system
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/config_file.rb:50 - no such file to load -- Win32API
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31 - no such file to load -- sequel
Exception `NoMethodError' at /usr/lib/ruby/1.8/rational.rb:78 - undefined method `gcd' for Rational(1, 2):Rational
/usr/lib/one/ruby/opennebula/xml_pool.rb:25: warning: method redefined; discarding old initialize
/usr/lib/one/ruby/opennebula/xml_pool.rb:31: warning: method redefined; discarding old each_element
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31 - no such file to load -- nokogiri
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31 - no such file to load -- ox
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31 - no such file to load -- xmlparser
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:38 - no such file to load -- xmlparser
/usr/lib/one/ruby/opennebula/host.rb:124: warning: ambiguous first argument; put parentheses or even spaces
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31 - no such file to load -- mysqlplus
Exception `LoadError' at /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:38 - no such file to load -- mysqlplus
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
Exception `Errno::ECONNREFUSED' at /usr/lib/ruby/1.8/net/http.rb:560 - Connection refused - connect(2)
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
MySQL dump stored in /var/lib/one/mysql_localhost_opennebula.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file

/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/query.rb:80: warning: instance variable @columns not initialized
/usr/lib/ruby/gems/1.8/gems/sequel-4.1.1/lib/sequel/dataset/actions.rb:141: warning: instance variable @row_proc not initialized
Exception `NoMethodError' at /usr/lib/one/ruby/onedb/fsck.rb:623 - undefined method `[]' for nil:NilClass
undefined method `[]' for nil:NilClass
Error running fsck version 4.6.0
The database will be restored
Exception `Errno::ECONNREFUSED' at /usr/lib/ruby/1.8/net/http.rb:560 - Connection refused - connect(2)
MySQL DB opennebula at localhost restored.
[oneadmin at opennebula ~]$

--
Regards,
Anandharaj

From: Carlos Martín Sánchez [mailto:cmartin at opennebula.org]
Sent: Friday, July 25, 2014 4:54 PM
To: Anandharaj Subramaniam
Cc: users at lists.opennebula.org
Subject: Re: [one-users] Upgrade 4.6 to 4.8 (beta) - onedb fsck report an error

Hi Anandharaj,

Can you please try the onedb command again, with the debug flag?

ruby -d `which onedb` fsck ....

Thank you.

--
Carlos Martín, MSc
Project Engineer
OpenNebula - Flexible Enterprise Cloud Made Simple
www.OpenNebula.org<http://www.OpenNebula.org> | cmartin at opennebula.org<mailto:cmartin at opennebula.org> | @OpenNebula<http://twitter.com/opennebula>

On Fri, Jul 25, 2014 at 4:47 AM, Anandharaj Subramaniam <anandharaj.maniam at mimos.my<mailto:anandharaj.maniam at mimos.my>> wrote:
Hi,

I have followed the documentation to upgrade my test OpenNebula from 4.6.2 to the 4.8 (beta 1).  When I run the onedb fsck, I got an error.

[oneadmin at opennebula ~]$ onedb upgrade -v -u oneadmin -d opennebula
MySQL Password:
Version read:
Shared tables 4.6.0 : OpenNebula 4.6.2 daemon bootstrap
Local tables  4.5.80 : OpenNebula 4.6.2 daemon bootstrap

MySQL dump stored in /var/lib/one/mysql_localhost_opennebula.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file

>>> Running migrators for shared tables
Database already uses version 4.6.0

>>> Running migrators for local tables
  > Running migrator /usr/lib/one/ruby/onedb/local/4.5.80_to_4.7.80.rb
  > Done in 0.27s

Database migrated from 4.5.80 to 4.7.80 (OpenNebula 4.7.80) by onedb command.

Total time: 0.27s

[oneadmin at opennebula ~]$ onedb fsck -S localhost -u oneadmin  -d opennebula
MySQL dump stored in /var/lib/one/mysql_localhost_opennebula.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file

undefined method `[]' for nil:NilClass
Error running fsck version 4.6.0
The database will be restored
MySQL DB opennebula at localhost restored.

--
Regards,
Anandharaj

________________________________
DISCLAIMER:

This e-mail (including any attachments) is for the addressee(s) only and may be confidential, especially as regards personal data. If you are not the intended recipient, please note that any dealing, review, distribution, printing, copying or use of this e-mail is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original message (including any attachments).

MIMOS Berhad is a research and development institution under the purview of the Malaysian Ministry of Science, Technology and Innovation. Opinions, conclusions and other information in this e-mail that do not relate to the official business of MIMOS Berhad and/or its subsidiaries shall be understood as neither given nor endorsed by MIMOS Berhad and/or its subsidiaries and neither MIMOS Berhad nor its subsidiaries accepts responsibility for the same. All liability arising from or in connection with computer viruses and/or corrupted e-mails is excluded to the fullest extent permitted by law.

_______________________________________________
Users mailing list
Users at lists.opennebula.org<mailto:Users at lists.opennebula.org>
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org

________________________________
DISCLAIMER:

This e-mail (including any attachments) is for the addressee(s) only and may be confidential, especially as regards personal data. If you are not the intended recipient, please note that any dealing, review, distribution, printing, copying or use of this e-mail is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original message (including any attachments).

MIMOS Berhad is a research and development institution under the purview of the Malaysian Ministry of Science, Technology and Innovation. Opinions, conclusions and other information in this e-mail that do not relate to the official business of MIMOS Berhad and/or its subsidiaries shall be understood as neither given nor endorsed by MIMOS Berhad and/or its subsidiaries and neither MIMOS Berhad nor its subsidiaries accepts responsibility for the same. All liability arising from or in connection with computer viruses and/or corrupted e-mails is excluded to the fullest extent permitted by law.
------------------------------------------------------------------
-
-
DISCLAIMER: 

This e-mail (including any attachments) is for the addressee(s) 
only and may contain confidential information. If you are not the 
intended recipient, please note that any dealing, review, 
distribution, printing, copying or use of this e-mail is strictly 
prohibited. If you have received this email in error, please notify 
the sender  immediately and delete the original message. 
MIMOS Berhad is a research and development institution under 
the purview of the Malaysian Ministry of Science, Technology and 
Innovation. Opinions, conclusions and other information in this e-
mail that do not relate to the official business of MIMOS Berhad 
and/or its subsidiaries shall be understood as neither given nor 
endorsed by MIMOS Berhad and/or its subsidiaries and neither 
MIMOS Berhad nor its subsidiaries accepts responsibility for the 
same. All liability arising from or in connection with computer 
viruses and/or corrupted e-mails is excluded to the fullest extent 
permitted by law.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140730/092c3066/attachment-0001.htm>