Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-879

LP #1428385: innodb_data_file_path is not checked for duplicate file names | Percona Server 5.6.22-72.0 failed to start

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by chrisjob1021 last update 29-03-2016 15:40:42

      Server shut down normally without error. Upon restart, I encountered this error--

      2015-03-04 05:49:13 2b054eea2cf0 InnoDB: Error: tablespace size stored in header is 147013632 pages, but
      2015-03-04 05:49:13 2b054eea2cf0 InnoDB: the sum of data file sizes is only 147003840 pages

      I did not modify 'innodb_data_file_path' in any way. Data files were in tact and no known corruption. Checked XFS file system and found nothing. Was planning on restoring from backup when I decided to mess with 'innodb_data_file_path'--

      Original:
      innodb_data_file_path = /ssd/data/ibdata1:806578M;/mysql3/inno_db/data/ibdata2:390354M;/mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:50M:autoextend

      Made a typo and got the server online with this statement:
      innodb_data_file_path = /ssd/data/ibdata1:806578M;/mysql3/inno_db/data/ibdata2:390354M;/mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:370481M;/mysql5/inno_db/data/ibdata4:153M:autoextend

      Works consistently, although fallout is unclear. Tables all seem to be in tact without corruption. I'm envisioning problems will crop up eventually.

      I cannot modify that line really in any way, though. For example, adding additional files results in the error returning.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: