Wednesday, December 26, 2012

mysql - error 1005 (hy000) at line ... can't create table

Creating the database:
 
$ mysql -uroot -pmysql < my_tester_createdb_2.sql

Returns:
ERROR 1005 (HY000) at line 202: Can't create table './tester/#sql-d2d_146.frm' (errno: 150)


Solution

Search for a foreign key reference mistake like:

 - incompatible types
 - unsigned (when it shouldn't )







No comments:

Post a Comment

Spark : Cancelling potential speculative or zombie tasks for this job

  >PROBLEM Running a long iteration, Spark was returning messages like these: [dag-scheduler-event-loop] INFO org.apache.spark.scheduler....