Bug 624934 – manage.py syncdb barfs when the default table type is innodb

After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.

Bug 624934 - manage.py syncdb barfs when the default table type is innodb


Summary:	manage.py syncdb barfs when the default table type is innodb


Status:	RESOLVED FIXED

Product:	snowy
Classification:	Deprecated
Component:	Tomboy Online
Version:	git master
Hardware:	Other Linux

Importance:	Normal normal
Target Milestone:	0.2
Assigned To:	snowy-maint
QA Contact:	snowy-maint

URL:
Whiteboard:

Depends on:
Blocks:

Reported:	2010-07-21 15:17 UTC by Jeff Schroeder
Modified:	2010-07-21 20:53 UTC

See Also:
GNOME target:	---
GNOME version:	---

Description Jeff Schroeder 2010-07-21 15:17:01 UTC

[jschroeder@snowy snowy]$ grep ^default-storage-engine /etc/my.cnf
default-storage-engine=InnoDB

[jschroeder@snowy snowy]$ ./manage.py syncdb
Syncing...
Creating table django_openid_auth_useropenid
Traceback (most recent call last):

+ Trace 222949

File "./manage.py", line 11 in <module>
```
execute_manager(settings)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/__init__.py", line 362 in execute_manager
```
utility.execute()
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/__init__.py", line 303 in execute
```
self.fetch_command(subcommand).run_from_argv(self.argv)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/base.py", line 195 in run_from_argv
```
self.execute(*args, **options.__dict__)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/base.py", line 222 in execute
```
output = self.handle(*args, **options)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/base.py", line 351 in handle
```
return self.handle_noargs(**options)
```
File "/srv/www/edge.tomboy-online.org/snowy/lib/south/management/commands/syncdb.py", line 52 in handle_noargs
```
syncdb.Command().execute(**options)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/base.py", line 222 in execute
```
output = self.handle(*args, **options)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/base.py", line 351 in handle
```
return self.handle_noargs(**options)
```
File "/usr/local/www/gnomeweb/pythonpath/django/core/management/commands/syncdb.py", line 78 in handle_noargs
```
cursor.execute(statement)
```
File "/usr/local/www/gnomeweb/pythonpath/django/db/backends/util.py", line 19 in execute
```
return self.cursor.execute(sql, params)
```
File "/usr/local/www/gnomeweb/pythonpath/django/db/backends/mysql/base.py", line 84 in execute
```
return self.cursor.execute(query, args)
```
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173 in execute
```
self.errorhandler(self, exc, value)
```
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36 in defaulterrorhandler
```
raise errorclass, errorvalue
```

_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'claimed_id' used in key specification without a key length")

ectly 

I tried to force the table type to MyISAM via:
DATABASE_OPTIONS = {
   "init_command": "SET storage_engine=MYISAM",
}

It didn't seem to help any unfortunately.

Comment 1 Sandy Armstrong 2010-07-21 19:53:11 UTC

Let's apply the fix from here:

https://code.launchpad.net/~wligtenberg/django-openid-auth/mysql_fix/+merge/22726

We'll wait for bug reports on not accepting long URLs before worrying about the consequences.

Comment 2 Sandy Armstrong 2010-07-21 20:53:02 UTC

Fix applied, feel free to re-open if there are other incompatibilities with mysql, or if we should modify the fix.