Page 1 of 5 123 ... LastLast
Results 1 to 10 of 44

Thread: <4.5.2 Upgrade Notice

  1. #1
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Exclamation <4.5.2 Upgrade Notice

    It has been discovered that due to a MySQL bug (#23669), that an upgrade from 4.0.4 or higher can fail when you upgrade to 4.5.

    It appears that somewhere during the upgrade, that the proc table can disappear. Because the installer script takes a look at the table, it will fail when it doesn't find it.

    We believe that this will only affect users that did their initial install withZCS 4.0.4 or greater and may affect customers regardless of platform.

    We are currently investigating a workaround, and when it is ready, we will post it here. Additionally, we will include this in future release notes.

    Additional information can be found here: http://bugzilla.zimbra.com/show_bug.cgi?id=14146

    Thanks to Brian and Sean who helped us track this down!

    This thread will be updated/edited as needed.

  2. #2
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default Workaround

    For those users concerned with their current installs, please be aware that this only affects upgrades.

    We have a workaround for this problem. This work around should be done *PRIOR* to the 4.5 upgrade.

    Log in as the zimbra user.

    Code:
    mysql -f -Dmysql -u root --password=`zmlocalconfig -s -m nokey
    mysql_root_password` < /opt/zimbra/mysql/share/mysql/mysql_fix_privilege_tables.sql 
    
    After that finishes, execute the following and make sure you have an entry for "proc"
    
    mysql -f -Dmysql -u root --password=`zmlocalconfig -s -m nokey
    We plan on automating the above check script on the 4.5.2 release. It will also be included in the release notes.

    As always, we encourage our users to keep current backups of their system on a regular basis. . .even if its just a copy.

  3. #3
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    If you have any problems with the upgrade in relation to the proc table mysql bug, please post them here.

  4. #4
    easytouch's Avatar
    easytouch is offline Senior Member
    Join Date
    Nov 2006
    Location
    Vienna, Austria (Europe)
    Posts
    59
    Rep Power
    8

    Default ERROR 1060 Duplicate column name 'file_priv'

    Initial installation was a zcs-4.0.4_GA_457.FC4.tgz on Fedora Core 4.

    I tried the workaround on zcs-4.0.4_GA_457.FC4.tgz (OS Version on Fedora Core4)
    then I upgraded to zcs-4.0.5_GA_518.FC4.tgz (OS Version on Fedora Core4)
    and tried again.

    Both times the following results, and I see no proc table after running the .sql.
    So I am unsure if i should try the Upgrade to zcs-4.5.0_GA_612.FC4.tgz?
    What else can I try to create the proc table as needed, or patch the 4.5.0 install scripts?

    step 1 list tables
    [root@aws]$ su zimbra
    [zimbra@aws]$ zmlocalconfig -s | grep mysql (to fetch the mysql root-password ********)
    [zimbra@aws]$ mysql -f -Dmysql -u root --password=******** -e "show tables"
    Code:
    +---------------------------+
    | Tables_in_mysql           |
    +---------------------------+
    | columns_priv              |
    | db                        |
    | func                      |
    | help_category             |
    | help_keyword              |
    | help_relation             |
    | help_topic                |
    | host                      |
    | tables_priv               |
    | time_zone                 |
    | time_zone_leap_second     |
    | time_zone_name            |
    | time_zone_transition      |
    | time_zone_transition_type |
    | user                      |
    +---------------------------+
    step 2 run .sql
    [zimbra@aws]$ mysql -f -Dmysql -u root --password=************ < /opt/zimbra/mysql/share/mysql/mysql_fix_privilege_tables.sql

    Code:
    ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
    @hadGrantPriv:=1
    1
    1
    1
    1
    1
    1
    1
    1
    ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
    ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
    ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
    @hadShowDbPriv:=1
    1
    1
    1
    1
    1
    1
    1
    1
    ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
    ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
    ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
    step 3 list tables again - brings the sameresult as in step 1 - no proc table
    [zimbra@aws]$mysql -f -Dmysql -u root --password=***** -e "show tables"
    Code:
    +---------------------------+
    | Tables_in_mysql           |
    +---------------------------+
    | columns_priv              |
    | db                        |
    | func                      |
    | help_category             |
    | help_keyword              |
    | help_relation             |
    | help_topic                |
    | host                      |
    | tables_priv               |
    | time_zone                 |
    | time_zone_leap_second     |
    | time_zone_name            |
    | time_zone_transition      |
    | time_zone_transition_type |
    | user                      |
    +---------------------------+
    Last edited by easytouch; 02-02-2007 at 09:16 AM.

  5. #5
    easytouch's Avatar
    easytouch is offline Senior Member
    Join Date
    Nov 2006
    Location
    Vienna, Austria (Europe)
    Posts
    59
    Rep Power
    8

    Default Upgrade 4.0.5 to 4.5.0 (OS) on Fedora Core 4 OK

    I just wanted to add, that besides the error messages above, the upgrade from 4.0.5 to 4.5.0 now was OK (I ran the .sql injection as described above BEFORE the Upgrade to 4.5.0).

    Can I perform any further troubleshooting before I try this Update procedure on a production server?
    Last edited by easytouch; 02-02-2007 at 09:38 AM.

  6. #6
    brained is offline Loyal Member
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default

    I've can duplicate easytouch's results. Glancing through the mysql_fix_privilege_tables.sql nowhere do I see a CREATE TABLE for the proc table.

    I did run the mysql_fix_privilege_tables.sql from the 4.5.0 which did create the missing proc table, however attempting to upgrade after that results in:

    Code:
    ERROR 1051 (42S02) at line 10368: Unknown table 'open_conversation,appointment,mail_item,tombstone'
    mysql invication failed, exit code = 1:  at /opt/zimbra/libexec/scripts/migrate20060911-MailboxGroup.pl line 84,  line 117.
    Thu Feb  1 23:05:20 2007: Script failed with code 1 - exiting
    UPGRADE FAILED - exiting

  7. #7
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    I got similar results (but different line)

    ERROR 1146 (42S02) at line 31: Table 'mysql.proc' doesn't exist
    mysql invication failed, exit code = 1: at /opt/zimbra/libexec/scripts/migrate20060911-MailboxGroup.pl line 84, line 43.
    Fri Feb 2 20:03:15 2007: Script failed with code 1 - exiting
    UPGRADE FAILED - exiting

  8. #8
    su_A_ve is offline Advanced Member
    Join Date
    Dec 2006
    Posts
    184
    Rep Power
    8

    Default no Proc table before or after upgrade...?

    Our small test box (32bit) was at 4.04. We upgraded that to 4.5.0. No problems. BTW, this is Network edition...

    We are ready to upgrade production (64bit) from a 4.05 to 4.5.1 as well as upgrade our 4.5.0 test to 4.5.1 and today I found this thread.

    The thing is that I'm looking at the tables in both 4.5.0 (test) and 4.0.5 (prod) and I do not see any 'proc' table:

    Code:
    +---------------------------+
    | Tables_in_mysql           |
    +---------------------------+
    | columns_priv              |
    | db                        |
    | func                      |
    | help_category             |
    | help_keyword              |
    | help_relation             |
    | help_topic                |
    | host                      |
    | tables_priv               |
    | time_zone                 |
    | time_zone_leap_second     |
    | time_zone_name            |
    | time_zone_transition      |
    | time_zone_transition_type |
    | user                      |
    +---------------------------+
    So the thing is, should I worry about this before our 4.0.5 to 4.5.1 upgrade or what ?

    TIA...

  9. #9
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    No, we're going to fix the proc table issue in 4.5.2

    It can fail on some, but not on others, so it's a good idea to run these commands before upgrading just in case.

  10. #10
    su_A_ve is offline Advanced Member
    Join Date
    Dec 2006
    Posts
    184
    Rep Power
    8

    Default

    Quote Originally Posted by wannabetenor View Post
    No, we're going to fix the proc table issue in 4.5.2

    It can fail on some, but not on others, so it's a good idea to run these commands before upgrading just in case.
    I'm still not clear - should I have a 'proc table' on 4.0.x prior to the upgrade? On our prod. box, I don't have one...

    Should I have a 'proc table' on 4.5.x AFTER the upgrade ? On our dev. box which was upgraded, I don't have one either...

    TIA...

Page 1 of 5 123 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Upgrade 4.5.4 to 4.5.5 questions
    By dlochart in forum Zimbra Connector for Outlook
    Replies: 11
    Last Post: 05-14-2007, 02:44 AM
  2. Replies: 5
    Last Post: 03-01-2007, 03:20 AM
  3. Backup directory deleted during upgrade!
    By dlochart in forum Installation
    Replies: 2
    Last Post: 02-25-2007, 07:38 AM
  4. 4.01 to 4.02 upgrade problem (with solution)
    By criley in forum Migration
    Replies: 2
    Last Post: 09-28-2006, 11:36 PM
  5. M1 -> M2 Upgrade Scripts
    By KevinH in forum Announcements
    Replies: 57
    Last Post: 12-15-2005, 10:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •