You've got a database error lurking somewhere.

I usually encounter this when syncdb needs to be run (to whit, ./manage.py syncdb).

Have you added anything to installed apps that is not managed with South?

If that's a dead end, see if you can enable SQL logging in the database (in PostgreSQL, the configuration directive is log_statement: http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html#GUC-LOG-STATEMENT). Then you can watch the log while you execute the migrate command to see what's missing.

Just be careful that doing this on a live system can cause downtime and chew up disk space if your logs aren't being rotated and you forget to disable logging.

On 6/12/12 11:25 AM, Daniel França wrote:
Hi all,
I'm using South and it was working fine,
but suddenly I start to get this error on the server that's driving me crazy:

*(virtualenv)[root@localhost]# ./manage.py migrate accounts*
*Traceback (most recent call last):*
*  File "./manage.py", line 35, in <module>*
*    execute_manager(settings)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/core/management/__init__.py", line 459, in execute_manager*
*    utility.execute()*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute*
*    self.fetch_command(subcommand).run_from_argv(self.argv)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv*
*    self.execute(*args, **options.__dict__)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute*
*    output = self.handle(*args, **options)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/south/management/commands/migrate.py", line 107, in handle*
*    ignore_ghosts = ignore_ghosts,*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/south/migration/__init__.py", line 199, in migrate_app* * applied_all = check_migration_histories(applied_all, delete_ghosts, ignore_ghosts)* * File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/south/migration/__init__.py", line 72, in check_migration_histories*
*    for h in histories:*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/models/query.py", line 118, in _result_iter*
*    self._fill_cache()*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/models/query.py", line 875, in _fill_cache*
*    self._result_cache.append(self._iter.next())*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator*
*    for row in compiler.results_iter():*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter*
*    for rows in self.execute_sql(MULTI):*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql*
*    cursor.execute(sql, params)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/backends/util.py", line 40, in execute*
*    return self.cursor.execute(sql, params)*
* File "/home/gemini/workspace/gemini_virtualenv/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 52, in execute*
*    return self.cursor.execute(query, args)*
*django.db.utils.DatabaseError: current transaction is aborted, commands ignored until end of transaction block*

It's happening for every application that I try to migrate and I can't figure out why,
I can't see anything clear in the error messages.
Anyone has any idea about what's happening and how can I solve that??

Best Regards,
Daniel França
--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

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

Reply via email to