title: MySQL / MariaDB: InnoDB: Fatal - how to fix it?
body: <p>it is friday but no weekend yet. :( My colleague is on vacation and I myself am not a MySQL Pro. </p>
  
  <p>So this morning today our pages stopped working and I am trying to fix for hours now but couldn't solve it myself.</p>
  
  <p>So, baseline error is:</p>
  
  <p>"Status: "InnoDB: Fatal: Trying to access page number 62087 in space 0 space name /var/lib/mysql/db/ibdata1, which is outside the tablespace bounds. Byte offset 0, len 16384 i/o type 10.Please check that the configuration matches the InnoDB system tablespace location (ibdata files)""</p>
  
  <p>I did find a quite similar problem here: <a href="https://dba.stackexchange.com/questions/183862/trying-to-solve-outside-tablespace-bounds-mysql-error-but-recovering-table-wi">https://dba.stackexchange.com/questions/183862/trying-to-solve-outside-tablespace-bounds-mysql-error-but-recovering-table-wi</a></p>
  
  <p>Sadly there is no solution provided.</p>
  
  <p>The command "mysqldump" from the post above won't work anyway, as the whole service is not starting up.</p>
  
  <p>I recreated the DB status from yesterday using snapper -> that is why I absolutely have no clue why it does not work now. Tried the timestamp from Wednesday - same issue. </p>
  
  <p>Configuration reads:</p>
  
  <pre><code>[mysqld]
  datadir=/var/lib/mysql/db
  socket=/var/lib/mysql/mysql.sock
  
  innodb_data_home_dir = /var/lib/mysql/db
  innodb_data_file_path = ibdata1:10M:autoextend
  
  # Disabling symbolic-links is recommended to prevent assorted security risks
  symbolic-links=0
  
  # include all files from the config directory
  #
  !includedir /etc/my.cnf.d
  
  
  innodb_force_recovery=4
  </code></pre>
  
  <p>Moving / renaming the original ibdata1 did not solve anything. The thought was that maybe letting the system recreate the file would solve the problem.</p>
  
  <p>Any input on this is highly appreciated. </p>
  
  <p><em>I do not much care about data loss as long as the service will be running again, which has the highest priority right now.</em></p>
  
  <p>Thanks a lot</p>
  
  <p>James</p>