Skip to content

Instantly share code, notes, and snippets.

@Analect
Created May 20, 2014 23:26
Show Gist options
  • Save Analect/9dc4f7825212fd6e7a0e to your computer and use it in GitHub Desktop.
Save Analect/9dc4f7825212fd6e7a0e to your computer and use it in GitHub Desktop.
Error trace ... when I run alembic upgrade head
Successfully installed pymongo dnspython requests pyzmq
Cleaning up...
Obtaining file:///media/psf/vagrant/src
Running setup.py egg_info for package from file:///media/psf/vagrant/src
Installing collected packages: inbox
Running setup.py develop for inbox
Creating /usr/local/lib/python2.7/dist-packages/inbox.egg-link (link to .)
inbox 0.1 is already the active version in easy-install.pth
Installed /media/psf/vagrant/src
Successfully installed inbox
Cleaning up...
Finished installing dependencies.
140521 00:21:46 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect.
140521 00:21:46 mysqld_safe Logging to '/var/log/mysql/error.log'.
140521 00:21:46 mysqld_safe A mysqld process already exists
Creating databases...
Creating database: test
Creating database: inbox
Already revisioned by alembic 2c313b6ddd9b
Finished setting up database
Cleaning up...
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
build-essential*
0 upgraded, 0 newly installed, 1 to remove and 36 not upgraded.
After this operation, 37.9 kB disk space will be freed.
(Reading database ... 83376 files and directories currently installed.)
Removing build-essential ...
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 36 not upgraded.
Done!.
vagrant@precise64:/vagrant$ ./inbox start
Removing pyc files...
inbox.server.general [I 2014-05-21 00:22:11,056 config :43 ] Loaded configuration from config.cfg
inbox.server.general [I 2014-05-21 00:22:11,113 config :43 ] Loaded configuration from config.cfg
inbox.server.general [I 2014-05-21 00:22:11,171 inbox :262 ] Head database revision: 1b6ceae51b43
inbox.server.general [I 2014-05-21 00:22:11,171 inbox :263 ] Current database revision: 2c313b6ddd9b
Outdated database! Migrate using `alembic upgrade head`
vagrant@precise64:/vagrant$ alembic upgrade head
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade 2c313b6ddd9b -> 4e04f752b7ad, Tighten nullable constraints on ImapUids.
Deleting imapuid objects with NULL message_id...
Tightening NULL constraints...
INFO [alembic.migration] Running upgrade 4e04f752b7ad -> 4c1eb89f6bed, more folder names, separate remote folders and inbox tags
Creating new tables and columns...
Traceback (most recent call last):
File "/usr/local/bin/alembic", line 9, in <module>
load_entry_point('alembic==0.6.4', 'console_scripts', 'alembic')()
File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 298, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 293, in main
self.run_cmd(cfg, options)
File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 279, in run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 125, in upgrade
script.run_env()
File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "migrations/env.py", line 80, in <module>
run_migrations_online()
File "migrations/env.py", line 73, in run_migrations_online
context.run_migrations()
File "<string>", line 7, in run_migrations
File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 681, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 225, in run_migrations
change(**kw)
File "migrations/versions/024_remote_folders_and_inbox_tags_split.py", line 49, in upgrade
sa.UniqueConstraint('account_id', 'name')
File "<string>", line 7, in create_table
File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 713, in create_table
self._table(name, *columns, **kw)
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 149, in create_table
self._exec(schema.CreateTable(table))
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec
conn.execute(construct, *multiparams, **params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 720, in _execute_ddl
compiled
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 132, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 271, in _query
conn.query(q)
File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 726, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 861, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1064, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 826, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 370, in check_error
raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 116, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
raise InternalError(errno, errorvalue)
sqlalchemy.exc.InternalError: (InternalError) (1050, u"Table 'folder' already exists") '\nCREATE TABLE folder (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\taccount_id INTEGER NOT NULL, \n\tname VARCHAR(191) COLLATE utf8mb4_general_ci, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(account_id) REFERENCES account (id) ON DELETE CASCADE, \n\tUNIQUE (account_id, name)\n)\n\n' ()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment