Saturday, May 11, 2013

SyncDB w/ MySQL - Has anyone seen an error like this?

When running syncdb, I am getting an unusual error. I'm using Django 1.5.1 and a relatively recent version of MariaDB on Arch. I am using some pre-existing tables which I've built Models around. The error is:

DatabaseError: (1005, "Can't create table '<db name censored>.#sql-1e51_2be' (errno: 150)")

Running syncdb a second time seems to finish out the process without error.

Searching around hasn't really helped tremendously. At least, I'm not looking in the right place.

At first glance, I thought that maybe this was some weird table name. After some further thinking, does this hash symbol represent something in MySQL land? Perhaps an index? Perhaps literally implemented as a hash table? haha

I tried to debug it. I figured if I could get ahold of the SQL produced by syncdb and run it manually then the RDBMS might give me some more verbose output.

Unfortunately, I have my project broken up into quite a few modules (apps) and have no idea how the syncdb command goes about chaining the various "sqlall <appname>" dumps I can produce. I know with indexes in particular, order is important.

So, any clue as to what might be going on or how to dig in deeper? Thanks.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate