db_sync is not properly creating tables and missing few tables and data

this is inconsistent behavior:

1) db_sync is not populating all tables required and missing tables,columns data;

root@controller01:~# keystone user-list
Authorization Failed: An unexpected error prevented the server from fulfilling your request. (OperationalError) (1054, "Unknown column 'user.default_project_id' in 'field list'") 'SELECT user.id AS user_id, user.name AS user_name, user.domain_id AS user_domain_id, user.password AS user_password, user.enabled AS user_enabled, user.extra AS user_extra, user.default_project_id AS user_default_project_id \nFROM user \nWHERE user.name = %s AND user.domain_id = %s' ('admin', 'default') (HTTP 500)

Work around:
1) drop the tables
2) run the db_sync manually.