Results 1 to 2 of 2

Thread: Problems with MariaDB

  1. #1

    Default Problems with MariaDB

    I upgraded my MySQL installation with MariaDB from obs://build.opensuse.org/server:database . InnoDB should be compiled as an internal part of the server, but all my InnoDB tables went corrupted.

    Code:
    zypper info mariadb
    Loading repository data...
    Reading installed packages...
    
    
    Information for package mariadb:
    
    Repository: @System
    Name: mariadb
    Version: 5.1.50-31.2
    Arch: i586
    Vendor: obs://build.opensuse.org/server:database
    Installed: Yes
    Status: up-to-date
    Installed Size: 27.0 MiB
    Summary: A True Multiuser, Multithreaded SQL Database Server
    Description: 
    MariaDB is a backward compatible, drop-in replacement branch of the MySQL
    Database Server. It includes all major open source storage engines, including
    the Maria storage engine.
    Code:
    MariaDB [(none)]> show engines;
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | EXAMPLE    | YES     | Example storage engine                                         | NO           | NO   | NO         |
    | MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
    | BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
    | MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
    | MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
    | ndbcluster | NO      | Clustered, fault-tolerant tables                               | NULL         | NULL | NULL       |
    | ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
    | CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
    | FEDERATED  | YES     | Federated MySQL storage engine                                 | NO           | NO   | NO         |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    9 rows in set (0.00 sec)
    Code:
    show table status\G
    *************************** 1. row ***************************
               Name: log
             Engine: NULL
            Version: NULL
         Row_format: NULL
               Rows: NULL
     Avg_row_length: NULL
        Data_length: NULL
    Max_data_length: NULL
       Index_length: NULL
          Data_free: NULL
     Auto_increment: NULL
        Create_time: NULL
        Update_time: NULL
         Check_time: NULL
          Collation: NULL
           Checksum: NULL
     Create_options: NULL
            Comment: Unknown table engine 'InnoDB'
    Have I missed something and what can I do to fix it?

  2. #2
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Problems with MariaDB

    I had a look at the package source and saw that they configure

    Code:
    --with-plugins=partition,csv,heap,myisam,ndbcluster
    which means that you installed a package without innobase support.

    You better install the package from the 11.3 standard distribution which includes innobase plugin. Or you have to rebuild the package with

    Code:
    --with-plugins=partition,csv,heap,myisam,ndbcluster,innobase
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

Posting Permissions

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