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   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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

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
Answer this question or Comment on this question for clarity