Created
July 21, 2014 22:57
-
-
Save wroscoe/b3896ce1cf5def87c516 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
``` | |
wroscoe@wroscoe-Dell-System-XPS-L322X:~/code/lever/lever$ ../ve/bin/alembic -c alembic_local.ini upgrade head | |
INFO [alembic.migration] Context impl PostgresqlImpl. | |
INFO [alembic.migration] Will assume transactional DDL. | |
INFO [alembic.migration] Running upgrade 214199e187a -> 2a16dd91d8a, google_id | |
INFO [alembic.migration] Running upgrade 2a16dd91d8a -> e172a02f06, Normalize email addreses. | |
INFO [alembic.migration] Running upgrade e172a02f06 -> 3b9047833e2, Prop search api. | |
INFO [alembic.migration] Running upgrade 3b9047833e2 -> 1641e6ea352, Denormalize note text for search. | |
INFO [alembic.migration] Running upgrade 1641e6ea352 -> c20337db8c, add tag source | |
INFO [alembic.migration] Running upgrade c20337db8c -> 2ab3f9b513, Add contact import date. | |
INFO [alembic.migration] Running upgrade 2ab3f9b513 -> 592ae9316a6, invite constraint | |
INFO [alembic.migration] Running upgrade 592ae9316a6 -> 41710996966, lower case property names | |
INFO [alembic.migration] Running upgrade 41710996966 -> a995bef5cc, tag description | |
INFO [alembic.migration] Running upgrade a995bef5cc -> a4aa50c551, Add template id. | |
INFO [alembic.migration] Running upgrade a4aa50c551 -> 24ecb4d7610, Remove implicit tags. | |
INFO [alembic.migration] Running upgrade 24ecb4d7610 -> 3ea66415ce4, Sharing update. | |
Traceback (most recent call last): | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context | |
context) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute | |
cursor.execute(statement, parameters) | |
psycopg2.ProgrammingError: can't adapt type 'BindParameter' | |
The above exception was the direct cause of the following exception: | |
Traceback (most recent call last): | |
File "../ve/bin/alembic", line 11, in <module> | |
sys.exit(main()) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 298, in main | |
CommandLine(prog=prog).main(argv=argv) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 293, in main | |
self.run_cmd(cfg, options) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 279, in run_cmd | |
**dict((k, getattr(options, k)) for k in kwarg) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/command.py", line 124, in upgrade | |
script.run_env() | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/script.py", line 199, in run_env | |
util.load_python_file(self.dir, 'env.py') | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/util.py", line 205, in load_python_file | |
module = load_module_py(module_id, path) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/compat.py", line 49, in load_module_py | |
return machinery.SourceFileLoader(module_id, path).load_module(module_id) | |
File "<frozen importlib._bootstrap>", line 584, in _check_name_wrapper | |
File "<frozen importlib._bootstrap>", line 1022, in load_module | |
File "<frozen importlib._bootstrap>", line 1003, in load_module | |
File "<frozen importlib._bootstrap>", line 560, in module_for_loader_wrapper | |
File "<frozen importlib._bootstrap>", line 868, in _load_module | |
File "<frozen importlib._bootstrap>", line 313, in _call_with_frames_removed | |
File "./alembic/env.py", line 72, in <module> | |
run_migrations_online() | |
File "./alembic/env.py", line 65, in run_migrations_online | |
context.run_migrations() | |
File "<string>", line 7, in run_migrations | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/environment.py", line 681, in run_migrations | |
self.get_context().run_migrations(**kw) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/migration.py", line 225, in run_migrations | |
change(**kw) | |
File "./alembic/versions/3ea66415ce4_sharing_update.py", line 84, in upgrade | |
tag_user_rows) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 717, in execute | |
return meth(self, multiparams, params) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection | |
return connection._execute_clauseelement(self, multiparams, params) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 814, in _execute_clauseelement | |
compiled_sql, distilled_params | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context | |
context) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception | |
exc_info | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 174, in raise_from_cause | |
reraise(type(exception), exception, tb=exc_tb, cause=exc_value) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 167, in reraise | |
raise value.with_traceback(tb) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context | |
context) | |
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute | |
cursor.execute(statement, parameters) | |
sqlalchemy.exc.ProgrammingError: (ProgrammingError) can't adapt type 'BindParameter' 'INSERT INTO tags_users (created_on, modified_on, tag_id, user_id, collab_user_id) VALUES (NOW(), NOW(), %(tag_id)s, %(user_id)s, %(collab_user_id)s)' {'user_id': BindParameter('user_id', None, type_=NullType()), 'collab_user_id': BindParameter('collab_user_id', None, type_=NullType()), 'tag_id': BindParameter('tag_id', None, type_=NullType())} | |
wroscoe@wroscoe-Dell-System-XPS-L322X:~/code/lever/lever$ | |
``` |
psql -Ulever lever_local
pg_dump -Ulever lever_local > lever_local.sql
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Can you open the psql console and try these out?
User is not set for tag user.
SELECT COUNT(*) FROM tags_users WHERE user_id IS NULL;
Tag has no tag users.
SELECT COUNT(*) FROM tags LEFT OUTER JOIN tags_users ON tags.id = tags_users.tag_id WHERE tags_users.tag_id IS NULL;
I tested it on the production data and the migration runs but I still want to be sure bad data is this problem and not something else.