· 8 years ago · Jun 15, 2018, 07:52 AM
1June 15, 2018, 10:49 a.m.
2
3 Running migrations for bio:
4 - Migrating forwards to 0001_initial.
5 > bio:0001_initial
6FATAL ERROR - The following SQL query failed: CREATE TABLE "bio_bio" ("id" integer NOT NULL PRIMARY KEY, "first_name" varchar(50) NOT NULL, "last_name" varchar(50) NOT NULL, "date_of_birth" date NOT NULL, "bio" text NOT NULL, "email" varchar(75) NOT NULL, "jabber" varchar(253) NOT NULL, "skype" varchar(253) NOT NULL, "other_contacts" text NOT NULL, "created_at" datetime NOT NULL)
7The error was: table "bio_bio" already exists
8 ! Error found during real run of migration! Aborting.
9
10 ! Since you have a database that does not support running
11 ! schema-altering statements in transactions, we have had
12 ! to leave it in an interim state between migrations.
13
14! You *might* be able to recover with: = DROP TABLE "bio_bio"; []
15
16 ! The South developers regret this has happened, and would
17 ! like to gently persuade you to consider a slightly
18 ! easier-to-deal-with DBMS (one that supports DDL transactions)
19 ! NOTE: The error which caused the migration to fail is further up.
20Error in migration: bio:0001_initial
21Traceback (most recent call last):
22 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/bin/django-admin.py", line 8, in <module>
23 management.execute_from_command_line()
24 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
25 utility.execute()
26 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 392, in execute
27 self.fetch_command(subcommand).run_from_argv(self.argv)
28 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/core/management/base.py", line 242, in run_from_argv
29 self.execute(*args, **options.__dict__)
30 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/core/management/base.py", line 285, in execute
31 output = self.handle(*args, **options)
32 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/management/commands/migrate.py", line 111, in handle
33 ignore_ghosts = ignore_ghosts,
34 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/__init__.py", line 220, in migrate_app
35 success = migrator.migrate_many(target, workplan, database)
36 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/migrators.py", line 331, in migrate_many
37 result = self.migrate(migration, database)
38 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/migrators.py", line 133, in migrate
39 result = self.run(migration, database)
40 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/migrators.py", line 114, in run
41 return self.run_migration(migration, database)
42 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/migrators.py", line 84, in run_migration
43 migration_function()
44 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/migration/migrators.py", line 60, in <lambda>
45 return (lambda: direction(orm))
46 File "/d/skrypnykdmytro.fortytwotesttask-537/083766acefc961f75728532c5fc62d7b5cb36ee9/apps/bio/migrations/0001_initial.py", line 22, in forwards
47 ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
48 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/db/generic.py", line 47, in _cache_clear
49 return func(self, table, *args, **opts)
50 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/db/generic.py", line 361, in create_table
51 "columns": ', '.join([col for col in columns if col]),
52 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/south/db/generic.py", line 282, in execute
53 cursor.execute(sql, params)
54 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/db/backends/util.py", line 69, in execute
55 return super(CursorDebugWrapper, self).execute(sql, params)
56 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
57 return self.cursor.execute(sql, params)
58 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__
59 six.reraise(dj_exc_type, dj_exc_value, traceback)
60 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
61 return self.cursor.execute(sql, params)
62 File "/d/skrypnykdmytro.fortytwotesttask-537/env/abf7c236fa91d7e086adfd4e0b4c55e8ff9f10cb.180615.101323/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 452, in execute
63 return Database.Cursor.execute(self, query, params)
64django.db.utils.OperationalError: table "bio_bio" already exists