LOG:  database system was shut down at 2018-06-21 11:58:12 GMT
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
LOG:  connection received: host=[local]
LOG:  connection authorized: user=postgres database=postgres
LOG:  connection received: host=192.168.124.81 port=46138
LOG:  connection authorized: user=neutron database=neutron
LOG:  statement: SET client_encoding TO 'UTF8'
LOG:  statement: BEGIN
LOG:  statement: SELECT t.oid, typarray
	FROM pg_type t JOIN pg_namespace ns
	    ON typnamespace = ns.oid
	WHERE typname = 'hstore';
	
LOG:  statement: ROLLBACK
LOG:  statement: BEGIN
LOG:  statement: select version()
LOG:  statement: select current_schema()
LOG:  statement: show transaction isolation level
LOG:  statement: SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
LOG:  statement: SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
LOG:  statement: SELECT 'x' AS some_label
LOG:  statement: ROLLBACK
LOG:  statement: BEGIN
LOG:  statement: show standard_conforming_strings
LOG:  statement: ROLLBACK
LOG:  statement: SET client_encoding TO 'UTF8'
LOG:  statement: BEGIN
LOG:  statement: SELECT 1
LOG:  statement: ROLLBACK
LOG:  statement: BEGIN
LOG:  statement: SELECT 1
LOG:  statement: select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname='aim_alembic_version'
LOG:  statement: select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname='aim_alembic_version'
LOG:  statement: 
	CREATE TABLE aim_alembic_version (
		version_num VARCHAR(32) NOT NULL
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_tenants (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_tenant_identity UNIQUE (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_tenant_identity ON aim_tenants (name)
LOG:  statement: 
	CREATE TABLE aim_bridge_domains (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		vrf_name VARCHAR(64), 
		enable_arp_flood BOOLEAN, 
		enable_routing BOOLEAN, 
		limit_ip_learn_to_subnets BOOLEAN, 
		l2_unknown_unicast_mode VARCHAR(16), 
		ep_move_detect_mode VARCHAR(16), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_bridge_domains_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_bd_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_bridge_domains_identity ON aim_bridge_domains (tenant_name, name)
LOG:  statement: INSERT INTO aim_alembic_version (version_num) VALUES ('40855b7eb958')
LOG:  statement: 
	CREATE TABLE aim_tenant_trees (
		tenant_rn VARCHAR(64) NOT NULL, 
		PRIMARY KEY (tenant_rn)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_config_tenant_trees (
		tenant_rn VARCHAR(64) NOT NULL, 
		root_full_hash VARCHAR(64), 
		tree BYTEA, 
		PRIMARY KEY (tenant_rn)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_operational_tenant_trees (
		tenant_rn VARCHAR(64) NOT NULL, 
		root_full_hash VARCHAR(64), 
		tree BYTEA, 
		PRIMARY KEY (tenant_rn)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_monitored_tenant_trees (
		tenant_rn VARCHAR(64) NOT NULL, 
		root_full_hash VARCHAR(64), 
		tree BYTEA, 
		PRIMARY KEY (tenant_rn)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='72fa5bce100b' WHERE aim_alembic_version.version_num = '40855b7eb958'
LOG:  statement: 
	CREATE TABLE aim_agents (
		id VARCHAR(255) NOT NULL, 
		agent_type VARCHAR(255) NOT NULL, 
		host VARCHAR(255) NOT NULL, 
		binary_file VARCHAR(255) NOT NULL, 
		admin_state_up BOOLEAN NOT NULL, 
		heartbeat_timestamp TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
		beat_count INTEGER, 
		description VARCHAR(255), 
		version VARCHAR(10), 
		PRIMARY KEY (id), 
		CONSTRAINT uniq_agents0agent_type1host UNIQUE (agent_type, host)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_agent_to_tree_associations (
		agent_id VARCHAR(255) NOT NULL, 
		tree_tenant_rn VARCHAR(64) NOT NULL, 
		PRIMARY KEY (agent_id, tree_tenant_rn), 
		FOREIGN KEY(tree_tenant_rn) REFERENCES aim_tenant_trees (tenant_rn) ON DELETE CASCADE, 
		FOREIGN KEY(agent_id) REFERENCES aim_agents (id) ON DELETE CASCADE
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='accfe645090a' WHERE aim_alembic_version.version_num = '72fa5bce100b'
LOG:  statement: 
	CREATE TABLE aim_subnets (
		aim_id SERIAL NOT NULL, 
		bd_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		gw_ip_mask VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		scope VARCHAR(16), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_subnets_identity UNIQUE (tenant_name, bd_name, gw_ip_mask), 
		CONSTRAINT fk_bd FOREIGN KEY(tenant_name, bd_name) REFERENCES aim_bridge_domains (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_subnets_identity ON aim_subnets (tenant_name, bd_name, gw_ip_mask)
LOG:  statement: 
	CREATE TABLE aim_vrfs (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		policy_enforcement_pref VARCHAR(16), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_vrfs_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_vrf_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_vrfs_identity ON aim_vrfs (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_app_profiles (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_app_profiles_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_ap_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_app_profiles_identity ON aim_app_profiles (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_endpoint_groups (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		app_profile_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		bd_name VARCHAR(64), 
		policy_enforcement_pref VARCHAR(16), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_endpoint_groups_identity UNIQUE (tenant_name, app_profile_name, name), 
		CONSTRAINT fk_app_profile FOREIGN KEY(tenant_name, app_profile_name) REFERENCES aim_app_profiles (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_endpoint_groups_identity ON aim_endpoint_groups (tenant_name, app_profile_name, name)
LOG:  statement: 
	CREATE TABLE aim_endpoint_group_contracts (
		epg_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		provides BOOLEAN NOT NULL, 
		PRIMARY KEY (epg_aim_id, name, provides), 
		FOREIGN KEY(epg_aim_id) REFERENCES aim_endpoint_groups (aim_id)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='7349fa0a2ad8' WHERE aim_alembic_version.version_num = 'accfe645090a'
LOG:  statement: 
	CREATE TABLE aim_statuses (
		id VARCHAR(255) NOT NULL, 
		resource_type VARCHAR(255) NOT NULL, 
		resource_id INTEGER NOT NULL, 
		sync_status VARCHAR(50), 
		sync_message TEXT, 
		health_score INTEGER, 
		PRIMARY KEY (id), 
		CONSTRAINT uniq_aim_statuses_identity UNIQUE (resource_type, resource_id)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_statuses_identity ON aim_statuses (resource_type, resource_id)
LOG:  statement: 
	CREATE TABLE aim_faults (
		status_id VARCHAR(255) NOT NULL, 
		fault_code VARCHAR(25) NOT NULL, 
		severity VARCHAR(25) NOT NULL, 
		description VARCHAR(255), 
		cause VARCHAR(255), 
		last_update_timestamp TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), 
		external_identifier VARCHAR(255) NOT NULL, 
		PRIMARY KEY (external_identifier), 
		FOREIGN KEY(status_id) REFERENCES aim_statuses (id) ON DELETE CASCADE
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_faults_status_id ON aim_faults (status_id)
LOG:  statement: UPDATE aim_alembic_version SET version_num='faade1155a0a' WHERE aim_alembic_version.version_num = '7349fa0a2ad8'
LOG:  statement: 
	CREATE TABLE aim_filters (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_filters_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_flt_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_filters_identity ON aim_filters (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_filter_entries (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		filter_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		arp_opcode VARCHAR(16), 
		ether_type VARCHAR(16), 
		ip_protocol VARCHAR(16), 
		icmpv4_type VARCHAR(16), 
		icmpv6_type VARCHAR(16), 
		source_from_port VARCHAR(16), 
		source_to_port VARCHAR(16), 
		dest_from_port VARCHAR(16), 
		dest_to_port VARCHAR(16), 
		tcp_flags VARCHAR(16), 
		stateful BOOLEAN, 
		fragment_only BOOLEAN, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_filter_entries_identity UNIQUE (tenant_name, filter_name, name), 
		CONSTRAINT fk_filter FOREIGN KEY(tenant_name, filter_name) REFERENCES aim_filters (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_filter_entries_identity ON aim_filter_entries (tenant_name, filter_name, name)
LOG:  statement: 
	CREATE TABLE aim_contracts (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		scope VARCHAR(24), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_contracts_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_brc_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_contracts_identity ON aim_contracts (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_contract_subjects (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		contract_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_contract_subjects_identity UNIQUE (tenant_name, contract_name, name), 
		CONSTRAINT fk_contract FOREIGN KEY(tenant_name, contract_name) REFERENCES aim_contracts (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_contract_subjects_identity ON aim_contract_subjects (tenant_name, contract_name, name)
LOG:  statement: CREATE TYPE subject_direction AS ENUM ('bi', 'in', 'out')
LOG:  statement: 
	CREATE TABLE aim_contract_subject_filters (
		subject_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		direction subject_direction NOT NULL, 
		PRIMARY KEY (subject_aim_id, name, direction), 
		FOREIGN KEY(subject_aim_id) REFERENCES aim_contract_subjects (aim_id)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='3ef7607a41b0' WHERE aim_alembic_version.version_num = 'faade1155a0a'
LOG:  statement: 
	CREATE TABLE aim_endpoints (
		uuid VARCHAR(36) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		epg_tenant_name VARCHAR(64), 
		epg_app_profile_name VARCHAR(64), 
		epg_name VARCHAR(64), 
		PRIMARY KEY (uuid), 
		CONSTRAINT fk_epg FOREIGN KEY(epg_tenant_name, epg_app_profile_name, epg_name) REFERENCES aim_endpoint_groups (tenant_name, app_profile_name, name)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='74f15b6aee51' WHERE aim_alembic_version.version_num = '3ef7607a41b0'
LOG:  statement: 
	CREATE TABLE aim_config (
		key VARCHAR(52) NOT NULL, 
		host VARCHAR(52) NOT NULL, 
		"group" VARCHAR(52) NOT NULL, 
		value VARCHAR(512), 
		version VARCHAR(36) NOT NULL, 
		PRIMARY KEY (key, host, "group")
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='ab9b4e196100' WHERE aim_alembic_version.version_num = '74f15b6aee51'
LOG:  statement: 
	CREATE TABLE aim_vmm_domains (
		type VARCHAR(64) NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		PRIMARY KEY (type, name)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_physical_domains (
		name VARCHAR(64) NOT NULL
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_endpoint_group_vmm_domains (
		epg_aim_id INTEGER NOT NULL, 
		vmm_type VARCHAR(64) NOT NULL, 
		vmm_name VARCHAR(64) NOT NULL, 
		PRIMARY KEY (epg_aim_id, vmm_type, vmm_name), 
		FOREIGN KEY(epg_aim_id) REFERENCES aim_endpoint_groups (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_endpoint_group_physical_domains (
		epg_aim_id INTEGER NOT NULL, 
		physdom_name VARCHAR(64) NOT NULL, 
		PRIMARY KEY (epg_aim_id, physdom_name), 
		FOREIGN KEY(epg_aim_id) REFERENCES aim_endpoint_groups (aim_id)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='1249face3348' WHERE aim_alembic_version.version_num = 'ab9b4e196100'
LOG:  statement: 
	CREATE TABLE aim_bridge_domain_l3outs (
		bd_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		PRIMARY KEY (bd_aim_id, name), 
		FOREIGN KEY(bd_aim_id) REFERENCES aim_bridge_domains (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_l3outsides (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		vrf_name VARCHAR(64), 
		l3_domain_dn VARCHAR(1024), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_l3outsides_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_l3o_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_l3outsides_identity ON aim_l3outsides (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_external_networks (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		l3out_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		nat_epg_dn VARCHAR(1024), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_external_networks_identity UNIQUE (tenant_name, l3out_name, name), 
		CONSTRAINT fk_l3out FOREIGN KEY(tenant_name, l3out_name) REFERENCES aim_l3outsides (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_external_networks_identity ON aim_external_networks (tenant_name, l3out_name, name)
LOG:  statement: 
	CREATE TABLE aim_external_network_contracts (
		ext_net_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		provides BOOLEAN NOT NULL, 
		PRIMARY KEY (ext_net_aim_id, name, provides), 
		FOREIGN KEY(ext_net_aim_id) REFERENCES aim_external_networks (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_external_subnets (
		aim_id SERIAL NOT NULL, 
		cidr VARCHAR(64) NOT NULL, 
		external_network_name VARCHAR(64) NOT NULL, 
		l3out_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_external_subnets_identity UNIQUE (tenant_name, l3out_name, external_network_name, cidr), 
		CONSTRAINT fk_ext_net FOREIGN KEY(tenant_name, l3out_name, external_network_name) REFERENCES aim_external_networks (tenant_name, l3out_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_external_subnets_identity ON aim_external_subnets (tenant_name, l3out_name, external_network_name, cidr)
LOG:  statement: UPDATE aim_alembic_version SET version_num='8e313fbeb93b' WHERE aim_alembic_version.version_num = '1249face3348'
LOG:  statement: 
	CREATE TABLE aim_lib_clone_l3out (
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		source_name VARCHAR(64) NOT NULL, 
		source_tenant_name VARCHAR(64) NOT NULL, 
		PRIMARY KEY (name, tenant_name), 
		CONSTRAINT fk_clone_l3out_l3out FOREIGN KEY(tenant_name, name) REFERENCES aim_l3outsides (tenant_name, name) ON DELETE CASCADE, 
		CONSTRAINT fk_clone_src_l3out_l3out FOREIGN KEY(source_tenant_name, source_name) REFERENCES aim_l3outsides (tenant_name, name)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='07113feba145' WHERE aim_alembic_version.version_num = '8e313fbeb93b'
LOG:  statement: 
	CREATE TABLE aim_endpoint_group_static_paths (
		epg_aim_id INTEGER NOT NULL, 
		path VARCHAR(512) NOT NULL, 
		encap VARCHAR(24), 
		PRIMARY KEY (epg_aim_id, path), 
		FOREIGN KEY(epg_aim_id) REFERENCES aim_endpoint_groups (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_host_links (
		host_name VARCHAR(128) NOT NULL, 
		interface_name VARCHAR(32) NOT NULL, 
		interface_mac VARCHAR(24), 
		switch_id VARCHAR(128), 
		module VARCHAR(128), 
		port VARCHAR(128), 
		path VARCHAR(512), 
		PRIMARY KEY (host_name, interface_name)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='d8abdb89ba66' WHERE aim_alembic_version.version_num = '07113feba145'
LOG:  statement: 
	CREATE TABLE aim_lib_save_l3out (
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		monitored BOOLEAN, 
		vrf_name VARCHAR(64), 
		PRIMARY KEY (name, tenant_name), 
		CONSTRAINT fk_save_l3out_l3out FOREIGN KEY(tenant_name, name) REFERENCES aim_l3outsides (tenant_name, name) ON DELETE CASCADE
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='d38c07b36c11' WHERE aim_alembic_version.version_num = 'd8abdb89ba66'
LOG:  statement: 
	CREATE TABLE aim_security_groups (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_sg_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_sg_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_sg_identity ON aim_security_groups (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_security_group_subjects (
		aim_id SERIAL NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		security_group_name VARCHAR(64) NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_sg_subjects_identity UNIQUE (tenant_name, security_group_name, name), 
		CONSTRAINT fk_sg_subject FOREIGN KEY(tenant_name, security_group_name) REFERENCES aim_security_groups (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_sg_subjects_identity ON aim_security_group_subjects (tenant_name, security_group_name, name)
LOG:  statement: 
	CREATE TABLE aim_security_group_rules (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		security_group_name VARCHAR(64) NOT NULL, 
		security_group_subject_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		ethertype VARCHAR(16), 
		direction VARCHAR(16), 
		ip_protocol VARCHAR(16), 
		from_port VARCHAR(16), 
		to_port VARCHAR(16), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_sg_rules_identity UNIQUE (tenant_name, security_group_name, security_group_subject_name, name), 
		CONSTRAINT fk_sg_rule FOREIGN KEY(tenant_name, security_group_name, security_group_subject_name) REFERENCES aim_security_group_subjects (tenant_name, security_group_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_sg_rules_identity ON aim_security_group_rules (tenant_name, security_group_name, security_group_subject_name, name)
LOG:  statement: 
	CREATE TABLE aim_security_group_rule_remote_ips (
		security_group_rule_aim_id INTEGER NOT NULL, 
		cidr VARCHAR(64) NOT NULL, 
		PRIMARY KEY (security_group_rule_aim_id, cidr), 
		FOREIGN KEY(security_group_rule_aim_id) REFERENCES aim_security_group_rules (aim_id)
	)
	
	
LOG:  statement: UPDATE aim_alembic_version SET version_num='abf7bb5a4100' WHERE aim_alembic_version.version_num = 'd38c07b36c11'
LOG:  statement: ALTER TABLE aim_security_group_rules ADD COLUMN conn_track VARCHAR(25) DEFAULT 'reflexive' NOT NULL
LOG:  statement: UPDATE aim_alembic_version SET version_num='babbefa38870' WHERE aim_alembic_version.version_num = 'abf7bb5a4100'
LOG:  statement: ALTER TABLE aim_contract_subjects ADD COLUMN service_graph_name VARCHAR(64) DEFAULT ''
LOG:  statement: CREATE TYPE device_type AS ENUM ('PHYSICAL', 'VIRTUAL')
LOG:  statement: CREATE TYPE service_type AS ENUM ('ADC', 'FW', 'OTHERS', 'IDSIPS', 'COPY')
LOG:  statement: CREATE TYPE context_aware AS ENUM ('single-Context', 'multi-Context')
LOG:  statement: 
	CREATE TABLE aim_device_clusters (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		device_type device_type, 
		service_type service_type, 
		context_aware context_aware, 
		managed BOOLEAN, 
		physical_domain_name VARCHAR(64), 
		encap VARCHAR(24), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_device_clusters_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_ldc_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_device_clusters_identity ON aim_device_clusters (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_device_cluster_devices (
		dc_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		path VARCHAR(512), 
		PRIMARY KEY (dc_aim_id, name), 
		FOREIGN KEY(dc_aim_id) REFERENCES aim_device_clusters (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_device_cluster_ifs (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		device_cluster_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		encap VARCHAR(24), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_device_cluster_ifs_identity UNIQUE (tenant_name, device_cluster_name, name), 
		CONSTRAINT fk_dci_dc FOREIGN KEY(tenant_name, device_cluster_name) REFERENCES aim_device_clusters (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_device_cluster_ifs_identity ON aim_device_cluster_ifs (tenant_name, device_cluster_name, name)
LOG:  statement: 
	CREATE TABLE aim_device_cluster_if_concrete_ifs (
		dci_aim_id INTEGER NOT NULL, 
		interface VARCHAR(64) NOT NULL, 
		PRIMARY KEY (dci_aim_id, interface), 
		FOREIGN KEY(dci_aim_id) REFERENCES aim_device_cluster_ifs (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_concrete_devices (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		device_cluster_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_concrete_device_identity UNIQUE (tenant_name, device_cluster_name, name), 
		CONSTRAINT fk_conc_dev_dc FOREIGN KEY(tenant_name, device_cluster_name) REFERENCES aim_device_clusters (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_concrete_device_identity ON aim_concrete_devices (tenant_name, device_cluster_name, name)
LOG:  statement: 
	CREATE TABLE aim_concrete_device_ifs (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		device_name VARCHAR(64) NOT NULL, 
		device_cluster_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		path VARCHAR(512), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_concrete_device_if_identity UNIQUE (tenant_name, device_cluster_name, device_name, name), 
		CONSTRAINT fk_conc_dev_if_conc_dev FOREIGN KEY(tenant_name, device_cluster_name, device_name) REFERENCES aim_concrete_devices (tenant_name, device_cluster_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_concrete_device_if_identity ON aim_concrete_device_ifs (tenant_name, device_cluster_name, device_name, name)
LOG:  statement: 
	CREATE TABLE aim_service_graphs (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_service_graph_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_svcgr_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_service_graph_identity ON aim_service_graphs (tenant_name, name)
LOG:  statement: CREATE TYPE adjacency_type AS ENUM ('L2', 'L3')
LOG:  statement: CREATE TYPE connector_dir AS ENUM ('consumer', 'provider')
LOG:  statement: CREATE TYPE connector_type AS ENUM ('internal', 'external')
LOG:  statement: 
	CREATE TABLE aim_service_graph_connections (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		service_graph_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		adjacency_type adjacency_type, 
		connector_direction connector_dir, 
		connector_type connector_type, 
		direct_connect BOOLEAN, 
		unicast_route BOOLEAN, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_sg_conn_identity UNIQUE (tenant_name, service_graph_name, name), 
		CONSTRAINT fk_sgc_sg FOREIGN KEY(tenant_name, service_graph_name) REFERENCES aim_service_graphs (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_sg_conn_identity ON aim_service_graph_connections (tenant_name, service_graph_name, name)
LOG:  statement: 
	CREATE TABLE aim_service_graph_connection_conns (
		sgc_aim_id INTEGER NOT NULL, 
		connector VARCHAR(512) NOT NULL, 
		PRIMARY KEY (sgc_aim_id, connector), 
		FOREIGN KEY(sgc_aim_id) REFERENCES aim_service_graph_connections (aim_id)
	)
	
	
LOG:  statement: CREATE TYPE function_type AS ENUM ('GoTo', 'GoThrough')
LOG:  statement: CREATE TYPE routing_mode AS ENUM ('unspecified', 'Redirect')
LOG:  statement: 
	CREATE TABLE aim_service_graph_nodes (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		service_graph_name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		function_type function_type, 
		managed BOOLEAN, 
		routing_mode routing_mode, 
		device_cluster_name VARCHAR(64), 
		device_cluster_tenant_name VARCHAR(64), 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_sg_node_identity UNIQUE (tenant_name, service_graph_name, name), 
		CONSTRAINT fk_sgn_sg FOREIGN KEY(tenant_name, service_graph_name) REFERENCES aim_service_graphs (tenant_name, name)
	)
	
	
LOG:  statement: CREATE INDEX idx_sg_node_identity ON aim_service_graph_nodes (tenant_name, service_graph_name, name)
LOG:  statement: 
	CREATE TABLE aim_service_graph_node_conns (
		sgn_aim_id INTEGER NOT NULL, 
		connector VARCHAR(512) NOT NULL, 
		PRIMARY KEY (sgn_aim_id, connector), 
		FOREIGN KEY(sgn_aim_id) REFERENCES aim_service_graph_nodes (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_service_graph_linear_chain_nodes (
		sg_aim_id INTEGER NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		device_cluster_name VARCHAR(64), 
		device_cluster_tenant_name VARCHAR(64), 
		PRIMARY KEY (sg_aim_id, name), 
		FOREIGN KEY(sg_aim_id) REFERENCES aim_service_graphs (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_service_redirect_policies (
		aim_id SERIAL NOT NULL, 
		name VARCHAR(64) NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_srp_identity UNIQUE (tenant_name, name), 
		CONSTRAINT fk_srp_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_srp_identity ON aim_service_redirect_policies (tenant_name, name)
LOG:  statement: 
	CREATE TABLE aim_service_redirect_policy_destinations (
		srp_aim_id INTEGER NOT NULL, 
		ip VARCHAR(64) NOT NULL, 
		mac VARCHAR(24), 
		PRIMARY KEY (srp_aim_id, ip), 
		FOREIGN KEY(srp_aim_id) REFERENCES aim_service_redirect_policies (aim_id)
	)
	
	
LOG:  statement: 
	CREATE TABLE aim_device_cluster_contexts (
		aim_id SERIAL NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		contract_name VARCHAR(64) NOT NULL, 
		service_graph_name VARCHAR(64) NOT NULL, 
		node_name VARCHAR(64) NOT NULL, 
		device_cluster_name VARCHAR(64), 
		device_cluster_tenant_name VARCHAR(64), 
		service_redirect_policy_name VARCHAR(64), 
		service_redirect_policy_tenant_name VARCHAR(64), 
		bridge_domain_name VARCHAR(64), 
		bridge_domain_tenant_name VARCHAR(64), 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_dcctx_identity UNIQUE (tenant_name, contract_name, service_graph_name, node_name), 
		CONSTRAINT fk_dcctx_tn FOREIGN KEY(tenant_name) REFERENCES aim_tenants (name)
	)
	
	
LOG:  statement: CREATE INDEX idx_dcctx_identity ON aim_device_cluster_contexts (tenant_name, contract_name, service_graph_name, node_name)
LOG:  statement: 
	CREATE TABLE aim_device_cluster_if_contexts (
		aim_id SERIAL NOT NULL, 
		tenant_name VARCHAR(64) NOT NULL, 
		contract_name VARCHAR(64) NOT NULL, 
		service_graph_name VARCHAR(64) NOT NULL, 
		node_name VARCHAR(64) NOT NULL, 
		connector_name VARCHAR(64) NOT NULL, 
		device_cluster_interface_dn VARCHAR(1024), 
		service_redirect_policy_dn VARCHAR(1024), 
		bridge_domain_dn VARCHAR(1024), 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_dc_if_ctx_identity UNIQUE (tenant_name, contract_name, service_graph_name, node_name, connector_name), 
		CONSTRAINT fk_dc_if_ctx_dcctx FOREIGN KEY(tenant_name, contract_name, service_graph_name, node_name) REFERENCES aim_device_cluster_contexts (tenant_name, contract_name, service_graph_name, node_name)
	)
	
	
LOG:  statement: CREATE INDEX idx_dc_if_ctx_identity ON aim_device_cluster_if_contexts (tenant_name, contract_name, service_graph_name, node_name, connector_name)
LOG:  statement: UPDATE aim_alembic_version SET version_num='dc598e78e318' WHERE aim_alembic_version.version_num = 'babbefa38870'
LOG:  statement: 
	CREATE TABLE aim_opflex_devices (
		aim_id SERIAL NOT NULL, 
		pod_id VARCHAR(36) NOT NULL, 
		node_id VARCHAR(36) NOT NULL, 
		bridge_interface VARCHAR(36) NOT NULL, 
		dev_id VARCHAR(36) NOT NULL, 
		host_name VARCHAR(128), 
		ip VARCHAR(64), 
		fabric_path_dn VARCHAR(512), 
		domain_name VARCHAR(64), 
		controller_name VARCHAR(64), 
		PRIMARY KEY (aim_id), 
		CONSTRAINT uniq_aim_odev_identity UNIQUE (pod_id, node_id, bridge_interface, dev_id)
	)
	
	
LOG:  statement: CREATE INDEX idx_aim_odev_identity ON aim_opflex_devices (pod_id, node_id, bridge_interface, dev_id)
LOG:  statement: UPDATE aim_alembic_version SET version_num='7838968744ce' WHERE aim_alembic_version.version_num = 'dc598e78e318'
LOG:  statement: 
	CREATE TABLE aim_vmm_policies (
		type VARCHAR(64) NOT NULL, 
		aim_id SERIAL NOT NULL, 
		display_name VARCHAR(256) NOT NULL, 
		monitored BOOLEAN NOT NULL, 
		PRIMARY KEY (aim_id)
	)
	
	
LOG:  connection received: host=192.168.124.81 port=46142
LOG:  connection authorized: user=neutron database=neutron
LOG:  statement: SET client_encoding TO 'UTF8'
LOG:  statement: BEGIN
LOG:  statement: SELECT 1
LOG:  statement: SELECT aim_vmm_domains.type AS aim_vmm_domains_type, aim_vmm_domains.name AS aim_vmm_domains_name 
	FROM aim_vmm_domains
ERROR:  relation "aim_vmm_domains" does not exist at character 105
STATEMENT:  SELECT aim_vmm_domains.type AS aim_vmm_domains_type, aim_vmm_domains.name AS aim_vmm_domains_name 
	FROM aim_vmm_domains
LOG:  statement: ROLLBACK
LOG:  statement: ROLLBACK
LOG:  connection received: host=[local]
LOG:  connection authorized: user=root database=postgres
FATAL:  role "root" does not exist
LOG:  connection received: host=[local]
LOG:  connection authorized: user=postgres database=postgres
LOG:  statement: SELECT d.datname as "Name",
	       pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
	       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
	       d.datcollate as "Collate",
	       d.datctype as "Ctype",
	       pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
	FROM pg_catalog.pg_database d
	ORDER BY 1;
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down