Click here to register.
      
PBWG Banner


     Discuss > Install/Upgrade Help

Problem upgrading to 7.5 on WRE 0.8.3
User xootom
Date 3/9/2008 6:01 pm
Views 842
Rating 2    Rate [
|
]
Previous · Next
User Message
xootom
Date: 3/9/2008 6:01 pm   ·   Subject: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 2

I have two WebGUI sites running on an FC 4 server, on an old WRE, and they have been upgraded as far as 7.4.21.

We have a new server running Redhat Enterprise 5, I have installed the latest WRE, 0.8.3, and copied the existing sites to it. It's running ok with 7.4.21. But now I want to upgrade (beta branch).

So I've used the webgui updater to get 7.5.5-beta (also tried 7.5.0-beta) but every time I run the upgrade script, I get failures on the assetIndex table, see below. I have tried running repairs on the table and trying again but it complains there are duplicate keys. Has anyone else had this problem and found a solution?

[...]   Installing Photo asset...DONE!
    Create Event_relatedlink table.
    Converting Related Links from Event table to Event_relatedlink table
    Adding sequenceNumber to Event table.
DBD::mysql::st execute failed: Incorrect key file for table './www_site_com/assetIndex.MYI'; try to repair it at ../../lib/WebGUI/SQL/ResultSet.pm line 135.
<h1>Problem With Request</h1>
        We have encountered a problem with your request. Please use your back button and try again.
        If this problem persists, please contact us with what you were trying to do and the time and date of the problem.<br /><br />Site<br />info@site.com<br />http://www.site.com/fatal: Couldn't execute prepared statement: delete from assetIndex where assetId=? : With place holders: TimeTrackingTMPL000001.  Root cause: Incorrect key file for table './www_site_com/assetIndex.MYI'; try to repair it at ../../lib/WebGUI/Session/ErrorHandler.pm line 232.
    Processing upgrade executable failed!
The upgrade process failed and has stopped so you can either restore
from backup, or attempt to fix the problem and continue.
 

--- (Edited on 09-03-2008 23:01:55 [GMT+0000] by xootom) ---



Back to Top
Rate [
|
]
 
 
preaction
Date: 3/9/2008 8:42 pm   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 0

Looks like your MySQL tables are corrupt. You should run myisamchk and see if they can be fixed. 

You need to repair the database before you try to upgrade.

Otherwise, show us the error you get when it complains about duplicate keys. 

--- (Edited on 3/9/2008 8:42 pm [GMT-0500] by preaction) ---



Back to Top
Rate [
|
]
 
 
xootom
Date: 3/10/2008 6:19 am   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 2

I reverted to 7.4.21, did extended checks on the database and no problems found. Tried upgrading to 7.4.27 and it upgrades fine. So reverted back to 7.4.21. Checked databases again, fine, then tried 7.5.5. The upgrade to 7.5.0 failed with the error above. I ran the upgrade script again, it tried a 7.5.0 to 7.5.1 and errored with:

www_site_com 7.5.0-7.5.1
        Backing up www_site_com (7.5.0)...OK
        Updating packages.
DBD::mysql::st execute failed: Duplicate entry 'jME5BEDYVDlBZ8jIQA9-jQ' for key 1 at ../../lib/WebGUI/SQL/ResultSet.pm line 135.

I can keep running the upgrade script and it shows it upgrading to the next version, but with the duplicate key each time. (except 7.5.3 to 7.5.4 which succeeds in its steps).

Both sites hosted on the WRE fail with the exact same error messages. 

--- (Edited on 10-03-2008 11:19:57 [GMT+0000] by xootom) ---



Back to Top
Rate [
|
]
 
 
preaction
Date: 3/10/2008 9:43 am   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 0

It's trying to add some assets when the collision happens, could you paste the output of { select * from asset join assetData on asset.assetId = assetData.assetId where assetId = "..." }

--- (Edited on 3/10/2008 9:43 am [GMT-0500] by preaction) ---



Back to Top
Rate [
|
]
 
 
xootom
Date: 3/10/2008 10:59 am   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 5

This returns the default gallery search template, 1 row.

 

 | jME5BEDYVDlBZ8jIQA9-jQ | gI_TxK-5S4DNuv42wpImmw | 000001000001000104000001 | published | WebGUI::Asset::Template |   1197927169 | 3         | 997995720    | 3              | 3          |        0 | NULL           | jME5BEDYVDlBZ8jIQA9-jQ |   1197927169 | 3         | hWVNZCDmHvDR0_vo36QlmQ | pending | Default Gallery Search | Default Gallery Search | root/import/gallery-templates/default-gallery-search | 3           | 7           | 3           | NULL     |         0 |        1 |         0 |           0 |           0 |      3399 | NULL          |                0 |            1 |

--- (Edited on 10-03-2008 15:59:26 [GMT+0000] by xootom) ---



Back to Top
Rate [
|
]
 
 
preaction
Date: 3/10/2008 11:10 am   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: -4

Looks like the 7.5.0 upgrade didn't complete, so the assets never got committed, so when 7.5.1 tries to run, it doesn't see the template already exists and tries to create a new one, and then explodes.

I don't know what "key file incorrect" means, but it sounds bad. 

--- (Edited on 3/10/2008 11:10 am [GMT-0500] by preaction) ---



Back to Top
Rate [
|
]
 
 
xootom
Date: 3/10/2008 12:08 pm   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: -3

I've just tried this again after fixing a couple of other little errors, and now I get this: 

www_site_com 7.4.21-7.5.0
        Backing up www_site_com (7.4.21)...OK
        Adding isExportable flag for all assets (fine-grained export control)...DONE!
        Updating packages.
'jsonToObj' will be obsoleted. Please use 'from_json' instead. at ../../lib/WebGUI/AssetPackage.pm line 213
'jsonToObj' will be obsoleted. Please use 'from_json' instead. at ../../lib/WebGUI/AssetPackage.pm line 213
'jsonToObj' will be obsoleted. Please use 'from_json' instead. at ../../lib/WebGUI/AssetPackage.pm line 213
'jsonToObj' will be obsoleted. Please use 'from_json' instead. at ../../lib/WebGUI/AssetPackage.pm line 213
'objToJson' will be obsoleted. Please use 'to_json' instead. at ../../lib/WebGUI/Workflow/Instance.pm line 68
Can't locate object method "autoconv" via package "JSON" at /data/wre/prereqs/lib/perl5/site_perl/5.8.8/JSON.pm line 136.
        Processing upgrade executable failed!

--- (Edited on 10-03-2008 17:08:28 [GMT+0000] by xootom) ---



Back to Top
Rate [
|
]
 
 
xootom
Date: 3/11/2008 10:15 am   ·   Subject: Re: Problem upgrading to 7.5 on WRE 0.8.3  ·   Rating: 0

I have been able to successfully update the sites on their original server using the old pre-0.8.0 WRE it's using (making sure to update JSON and Config::JSON first.)

--- (Edited on 11-03-2008 15:15:59 [GMT+0000] by xootom) ---



Back to Top
Rate [
|
]
 
 
     Discuss > Install/Upgrade Help




Re: Connection charset, bugs and Russian translation by Vitkovsky - Sat @ 09:36am

Re: Connection charset, bugs and Russian translation by Vitkovsky - Sat @ 08:31am

Smoketest For nightly_2008-07-05 by Visitor - Sat @ 01:46am

Smoketest For nightly_2008-07-04 by Visitor - Fri @ 01:37am

Re: News Addon? by knowmad - Thu @ 06:04pm

Re: News Addon? by bepo - Thu @ 08:54am

Re: Book release dates and other dates. by JT - Thu @ 07:45am

Re: Book release dates and other dates. by bepo - Thu @ 06:32am

Re: News Addon? by bepo - Thu @ 03:35am

Smoketest For nightly_2008-07-03 by Visitor - Thu @ 01:37am

Thingy Reporting (pt 2) by knowmad - Wed @ 05:37pm

Re: News Addon? by knowmad - Wed @ 05:12pm

spell checker and tinymce by elnino - Wed @ 04:50pm

Re: WebGUI works on perl 5.10 by knowmad - Wed @ 04:41pm

Re: how the cost installing WebGUI ?? by baylink - Wed @ 12:19pm