)]}'
{"neutron/db/migration/alembic_migrations/versions/f489cf14a79c_lbaas_havana.py":[{"author":{"_account_id":6731,"name":"Jay Buffington","email":"me@jaybuff.com","username":"jaybuff"},"change_message_id":"2de7745571589ca796280bd6acc69b07c2137fb3","unresolved":false,"context_lines":[{"line_number":62,"context_line":"        u\u0027poolmonitorassociations\u0027,"},{"line_number":63,"context_line":"        sa.Column(u\u0027pool_id\u0027, sa.String(36), nullable\u003dFalse),"},{"line_number":64,"context_line":"        sa.Column(u\u0027monitor_id\u0027, sa.String(36), nullable\u003dFalse),"},{"line_number":65,"context_line":"        sa.ForeignKeyConstraint([\u0027monitor_id\u0027], [u\u0027healthmonitors.id\u0027], ),"},{"line_number":66,"context_line":"        sa.ForeignKeyConstraint([\u0027pool_id\u0027], [u\u0027pools.id\u0027], ),"},{"line_number":67,"context_line":"        sa.PrimaryKeyConstraint(u\u0027pool_id\u0027, u\u0027monitor_id\u0027)"},{"line_number":68,"context_line":"    )"}],"source_content_type":"text/x-python","patch_set":4,"id":"AAAAQn%2F%2FYjY%3D","line":65,"updated":"2013-08-01 01:34:10.000000000","message":"The foreign key this references doesn\u0027t exist yet because the healthmonitors table isn\u0027t created until line 104.  \n\nWhen I tried to use this upgrade script I got this error:\nsqlalchemy.exc.OperationalError: (OperationalError) (1005, \"Can\u0027t create table \u0027quantum.poolmonitorassociations\u0027 (errno: 150)\") \u0027\\nCREATE TABLE poolmonitorassociations (\\n\\tpool_id VARCHAR(36) NOT NULL, \\n\\tmonitor_id VARCHAR(36) NOT NULL, \\n\\tPRIMARY KEY (pool_id, monitor_id), \\n\\tFOREIGN KEY(monitor_id) REFERENCES healthmonitors (id), \\n\\tFOREIGN KEY(pool_id) REFERENCES pools (id)\\n)\\n\\n\u0027 ()","commit_id":"e1244639ff8d32002cee2761596c8def5699d1a8"},{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"65beaa034806bcf85b12ba91301d948b3eff06ca","unresolved":false,"context_lines":[{"line_number":62,"context_line":"        u\u0027poolmonitorassociations\u0027,"},{"line_number":63,"context_line":"        sa.Column(u\u0027pool_id\u0027, sa.String(36), nullable\u003dFalse),"},{"line_number":64,"context_line":"        sa.Column(u\u0027monitor_id\u0027, sa.String(36), nullable\u003dFalse),"},{"line_number":65,"context_line":"        sa.ForeignKeyConstraint([\u0027monitor_id\u0027], [u\u0027healthmonitors.id\u0027], ),"},{"line_number":66,"context_line":"        sa.ForeignKeyConstraint([\u0027pool_id\u0027], [u\u0027pools.id\u0027], ),"},{"line_number":67,"context_line":"        sa.PrimaryKeyConstraint(u\u0027pool_id\u0027, u\u0027monitor_id\u0027)"},{"line_number":68,"context_line":"    )"}],"source_content_type":"text/x-python","patch_set":4,"id":"AAAAQn%2F%2FX6Q%3D","line":65,"in_reply_to":"AAAAQn%2F%2FYjY%3D","updated":"2013-08-01 07:36:47.000000000","message":"can\u0027t figure out why this migration worked fine for me while testing. Will fix.","commit_id":"e1244639ff8d32002cee2761596c8def5699d1a8"}]}