/bundles/itninjaweb/img/Breadcrumb_cap_w.png

Trying to upgrade our Kbox1000 and i get the following error msg below when i try to upgrade to 5.4.  I read the requirements and it states the DB cant be bigger then 150mb and ours is currently 160mb and that might be the problem but i have no idea how to reduce that size, not sure if there is a server clean up etc.

 

 

 

[Wed Dec 19 14:19:09 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 14:19:09 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 14:19:09 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 14:19:09 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 14:19:09 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 14:19:09 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Wed Dec 19 13:21:02 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 13:21:02 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 13:21:02 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 13:21:02 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 13:21:02 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 13:21:02 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Wed Dec 19 13:14:05 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 13:14:05 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 13:14:05 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 13:14:05 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 13:14:05 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 13:14:05 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Wed Dec 19 11:55:17 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 11:55:17 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 11:55:17 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 11:55:17 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 11:55:17 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 11:55:17 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Wed Dec 19 11:50:05 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 11:50:05 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 11:50:05 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 11:50:05 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 11:50:05 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 11:50:05 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Wed Dec 19 11:11:02 PST 2012] [notice] A condition was detected that is not optimal for an upgrade.
[Wed Dec 19 11:11:02 PST 2012] [notice] The upgrade was stopped.  Please contact technical support
[Wed Dec 19 11:11:02 PST 2012] [notice] (http://www.kace.com/support/customer/tech-support) to remedy
[Wed Dec 19 11:11:02 PST 2012] [notice] the issue so that an upgrade can be completed.  In the meantime
[Wed Dec 19 11:11:02 PST 2012] [notice] the K1000 will remain fully functional at the current version.
[Wed Dec 19 11:11:02 PST 2012] [notice]    - kbox_dbdata.gz is too large (168404911)
[Thu Jan 26 12:08:38 PST 2012] [notice] Preparing to restart the K1000 Server.
[Thu Jan 26 12:08:38 PST 2012] [notice] K1000 Server Update 5.3.47927 Complete.
[Thu Jan 26 12:08:38 PST 2012] [notice] Applying DB privileges...
[Thu Jan 26 12:08:38 PST 2012] [notice] Refreshing mysql system help tables...
[Thu Jan 26 12:08:37 PST 2012] [notice] Syncing mysql system tables for mysql version...

There are no differences detected.
second db: two
first db: one

Answer Summary:
There is a blog article here talking about this issue that should help you out. http://www.itninja.com/blog/view/kace-k1000-5-4-upgrade-fails-due-to-large-ibdata-file
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Community Chosen Answer


Answers

5

There is a blog article here talking about this issue that should help you out.

http://www.itninja.com/blog/view/kace-k1000-5-4-upgrade-fails-due-to-large-ibdata-file

 

Answered 12/19/2012 by: darkhawktman
Green Belt

  • omg thank you that link worked perfectly!
Please log in to comment
Answer this question or Comment on this question for clarity

Answers

0

This link is not working? Any idea why not? What is the actual fix?

Thanks!

 

http://www.itninja.com/blog/view/kace-k1000-5-4-upgrade-fails-due-to-large-ibdata-file

Answered 01/15/2013 by: rreinsch
Senior Yellow Belt

  • I turned off agent log retention. Doing so reduced my database size from 156 MB to 24 MB.
Please log in to comment