Databases
StackOverflow2013
Postsdbo
PODjango can't syncdb after drop/create database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango can't syncdb after drop/create database
    primarykey
    data
    text
    <p>I wanted to reset a database and issued a drop database followed by a create database on a postgresql server accessed through psycopg2 by a django app.</p> <p>When I do ./manage.py syncdb I get the following error:</p> <pre><code>(prod)root@ns204612:/home/someproject/prod/django-mingus/mingus# ./manage.py syncdb Traceback (most recent call last): File "./manage.py", line 16, in &lt;module&gt; execute_manager(settings) File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/__init__.py", line 362, in execute_manager utility.execute() File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/__init__.py", line 303, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/base.py", line 195, in run_from_argv self.execute(*args, **options.__dict__) File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/base.py", line 222, in execute output = self.handle(*args, **options) File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/base.py", line 351, in handle return self.handle_noargs(**options) File "/home/someproject/prod/lib/python2.6/site-packages/django/core/management/commands/syncdb.py", line 52, in handle_noargs tables = connection.introspection.table_names() File "/home/someproject/prod/lib/python2.6/site-packages/django/db/backends/__init__.py", line 491, in table_names return self.get_table_list(cursor) File "/home/someproject/prod/lib/python2.6/site-packages/django/db/backends/postgresql/introspection.py", line 30, in get_table_list AND pg_catalog.pg_table_is_visible(c.oid)""") File "/home/someproject/prod/lib/python2.6/site-packages/django/db/backends/util.py", line 19, in execute return self.cursor.execute(sql, params) psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block </code></pre> <p>and in the postgresql log I got the following error:</p> <pre><code>2010-01-24 01:08:02 CET ERROR: relation "django_site" does not exist 2010-01-24 01:08:02 CET STATEMENT: SELECT "django_site"."id", "django_site"."domain", "django_site"."name" FROM "django_site" WHERE "django_site"."id" = 1 ORDER BY "django_site"."domain" ASC 2010-01-24 01:08:02 CET ERROR: current transaction is aborted, commands ignored until end of transaction block 2010-01-24 01:08:02 CET STATEMENT: SELECT c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r', 'v', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) 2010-01-24 01:08:02 CET LOG: could not receive data from client: Connection reset by peer 2010-01-24 01:08:02 CET LOG: unexpected EOF on client connection </code></pre> <p>How can I fix that please ?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMilen A. Radev
    1. USuser234090
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODjango can't syncdb after drop/create database
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODjango can't syncdb after drop/create database
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODjango can't syncdb after drop/create database
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs it a remote or a local server? Have you tried to restart the PostgreSQL server?
      singulars
      1. PODjango can't syncdb after drop/create database
      1. USFelix Kling
    2. COIt's a local server and I tried to restart the PostgreSQL server without result.
      singulars
      1. PODjango can't syncdb after drop/create database
      1. USuser234090
    3. COI had a similar problem - it was caused by trying to be smart with __init__.py in my app. In there I imported my forms and tests (so that runserver and django-autotest would pick them up). By wrapping these in an if block that checked argv for the server commands I wanted, it got fixed.
      singulars
      1. PODjango can't syncdb after drop/create database
      1. USStuart Axon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload