Results 1 to 5 of 5

Thread: zcs 7.2.0 on ubuntu 10 64-bit & Innodb

  1. #1
    SVD
    SVD is offline Starter Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    3

    Exclamation zcs 7.2.0 on ubuntu 10 64-bit & Innodb

    Hello,

    I created a new virtual machine on XenServer.
    I installed the recommended version of Ubuntu. (10 64-bit).
    I installed Zimbra Collaboration Suite - Open Source Edition (7.2).
    imapproxy is Disabled.
    memcached is Disabled.

    zmcontrol status return

    Code:
    zimbra@ZCS:~/log$ zmcontrol status
    Host zcs.vzletka.kcrm.local
            antispam                Running
            antivirus               Running
            ldap                    Running
            logger                  Running
            mailbox                 Stopped
                    zmmailboxdctl is not running.
            mta                     Running
            snmp                    Running
            spell                   Running
            stats                   Running
            zmconfigd               Running
    In mialbox.log
    Code:
            at org.mortbay.start.Main.start(Main.java:534)
            at org.mortbay.start.Main.start(Main.java:441)
            at org.mortbay.start.Main.main(Main.java:119)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table engine 'InnoDB'
    
    Query being executed when exception was thrown:
    SELECT * FROM config
    In mysql_error.log
    Code:
    120607 13:16:15 [Note] Event Scheduler: Purging the queue. 0 events
    120607 13:16:15 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    120607 13:16:15 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
    120607 13:17:23 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3.3
    120607 13:17:23  InnoDB: Initializing buffer pool, size = 614.0M
    120607 13:17:23  InnoDB: Completed initialization of buffer pool
    120607 13:17:23  InnoDB: highest supported file format is Barracuda.
    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
    120607 13:17:23 [ERROR] Plugin 'InnoDB' init function returned error.
    120607 13:17:23 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    120607 13:17:23 [Note] Event Scheduler: Loaded 0 events
    120607 13:17:23 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.1.58-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    I try this instructions
    Performance Tuning Guidelines for Large Deployments - Zimbra :: Wiki

    result is not obtained.

    this is my first installation of Zimbra, tell me what wrong in the settings of InnoDB

  2. #2
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,374
    Rep Power
    10

    Default

    What specifically did you change in /opt/zimbra/conf/my.cnf?

    Mark

  3. #3
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,580
    Rep Power
    57

    Default

    ..... and how much RAM is on this VM?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    SVD
    SVD is offline Starter Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    3

    Default

    my.cnf

    RAM is 5GB

    Code:
    [mysqld]
    
    basedir        = /opt/zimbra/mysql
    datadir        = /opt/zimbra/db/data
    socket         = /opt/zimbra/db/mysql.sock
    pid-file       = /opt/zimbra/db/mysql.pid
    bind-address   = localhost
    port           = 7306
    user           = zimbra
    tmpdir         = /opt/zimbra/data/tmp
    
    external-locking
    slow_query_log = 1
    slow_query_log_file = /opt/zimbra/log/myslow.log
    ignore-builtin-innodb
    
    plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
    
    long-query-time  = 1
    log-queries-not-using-indexes
    
    thread_cache_size = 110
    max_connections   = 110
    
    # We do a lot of writes, query cache turns out to be not useful.
    query_cache_type = 0
    
    sort_buffer_size = 1048576
    read_buffer_size = 1048576
    
    # (Num mailbox groups * Num tables in each group) + padding
    table_cache = 1200
    
    # innodb_buffer_pool_size        = 313312051
    innodb_buffer_pool_size        = 644245094
    innodb_log_file_size           = 524288000
    innodb_log_buffer_size         = 8388608
    innodb_file_per_table
    
    # Value is: 200 + max_connections + 2 * table_cache
    innodb_open_files              = 2710
    
    innodb_max_dirty_pages_pct     = 10
    innodb_flush_method            = O_DIRECT
    innodb_flush_log_at_trx_commit = 0
    max_allowed_packet             = 16777216
    
    [mysqld_safe]
    
    err-log      = /opt/zimbra/log/mysqld.log
    pid-file     = /opt/zimbra/db/mysql.pid
    Changed value:
    innodb_max_dirty_pages_pct = 10
    innodb_buffer_pool_size = 644245094

  5. #5
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,374
    Rep Power
    10

    Default

    If it were me I'd first revert all the changes and see if Zimbra starts. 5GB of RAM is well below that typically found in large server deployments.

    FWIW The InnoDB buffer pool should be set to be a little larger than the actual InnoDB database size, understanding that the database will increase over time. Setting it much larger just wastes RAM.

    Keep us posted!

    Mark

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. restarts in mysql_error log
    By jbaskew in forum Administrators
    Replies: 8
    Last Post: 05-25-2012, 09:22 AM
  2. [SOLVED] I broke my server trying to optimize... HELP!
    By myriad in forum Administrators
    Replies: 9
    Last Post: 09-17-2011, 06:46 AM
  3. System crash leads to major MySQL corruption
    By Glider Guider in forum Administrators
    Replies: 1
    Last Post: 08-01-2011, 11:03 AM
  4. Replies: 7
    Last Post: 02-27-2008, 05:17 PM
  5. Upgrade 4.5.1 -> 4.5.2 Network Edition on RH Failed
    By CJ.deb in forum Installation
    Replies: 7
    Last Post: 03-01-2007, 07:05 AM

Tags for this Thread

Posting Permissions

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