Mysql ibdata Problem

mahdy_sharifi

• November 21, 2014 01:14

Hello : When we restart mysql, we see in log some error like this :
141121 10:39:43 InnoDB: Error: table 'atlassar_peresta/ps_scene_lang' InnoDB: in InnoDB data dictionary has tablespace id 94115, InnoDB: but tablespace with that id or name does not exist. Have InnoDB: you deleted or moved .ibd files? InnoDB: This may also be a table created with CREATE TEMPORARY TABLE InnoDB: whose .ibd and .frm files MySQL automatically removed, but the InnoDB: table still exists in the InnoDB internal data dictionary. InnoDB: Please refer to^Z InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue.
This error related innodb crash, but this issue that database : atlassar_peresta not exist on server and remove few weeks/months ago. How can resolve this issue ? Regards

• 

  24x7ss

  • November 21, 2014 12:21

  Hello :) It seems the database directory do exist under your MySQL datadir which has some files related to tables. I would suggest remove the database directory if the database was previously removed.

  0
• 

  mahdy_sharifi

  • November 21, 2014 13:53

  ]Hello :) It seems the database directory do exist under your MySQL datadir which has some files related to tables. I would suggest remove the database directory if the database was previously removed.

  
  Not exist in that dir

  0
• 

  cPanelMichael

  • November 21, 2014 15:06

  Hello :) Please see: [url=http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html]MySQL :: MySQL 5.5 Reference Manual :: 14.21.3 Troubleshooting InnoDB Data Dictionary Operations In particular, this issue is addressed under the "Problem with Missing Tablespace" section with potential solutions. Thank you.

  0

Please sign in to leave a comment.