|
From: Josep M. A. M. <ja...@im...> - 2018-01-24 13:34:10
|
Hi Olivier, Thanks for the contribution. I am testing the images and running them as a stack in docker swarm mode. I had also copied https://raw.githubusercontent.com/netdisco/netdisco/d64d2f2023c2dfbaa931952090be9ff899ea5b7b/share/environments/deployment.yml to the config directory to avoid errors. I have also problems running netdisco-do (Attempting to create directory /home/netdisco/perl5) deploy@dock-test01:/nfs/netdisco-official$ docker service logs -f netdisco_netdisco-postgresql netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: starting pg privately to container netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | pg_ctl: another server might be running; trying to start server anyway netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | waiting for server to start....LOG: could not bind IPv6 socket: Address not available netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: database system was interrupted; last known up at 2018-01-24 11:23:32 UTC netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: the database system is starting up netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | .FATAL: the database system is starting up netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | .FATAL: the database system is starting up netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | .LOG: database system was not properly shut down; automatic recovery in progress netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: invalid record length at 0/1923CF0: wanted 24, got 0 netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: redo is not required netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: MultiXact member wraparound protections are now enabled netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: database system is ready to accept connections netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: autovacuum launcher started netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | done netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | server started netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: bringing schema up-to-date netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | BEGIN netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "admin" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE admin ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | job serial, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | entered TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | started TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | finished TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | device inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | action text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | subaction text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | username text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | userip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | log text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | debug boolean netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:19: ERROR: relation "admin" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_admin_entered" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_admin_entered ON admin(entered); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:21: ERROR: relation "idx_admin_entered" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_admin_status" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_admin_status ON admin(status); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:22: ERROR: relation "idx_admin_status" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_admin_action" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_admin_action ON admin(action); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:23: ERROR: relation "idx_admin_action" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | dns text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | description text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | uptime bigint, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | contact text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:56: ERROR: relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | name text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | location text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | layers varchar(8), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ports integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | serial text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | model text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ps1_type text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ps2_type text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ps1_status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ps2_status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | fan text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | slots integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vendor text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | os text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | os_ver text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | log text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | snmp_ver integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | snmp_comm text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | snmp_class text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vtp_domain text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_macsuck TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_arpnip TIMESTAMP netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_dns" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_dns ON device(dns); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:59: ERROR: relation "idx_device_dns" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_layers" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_layers ON device(layers); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:60: ERROR: relation "idx_device_layers" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_vendor" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_vendor ON device(vendor); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:61: ERROR: relation "idx_device_vendor" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_model" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_model ON device(model); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:62: ERROR: relation "idx_device_model" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_ip ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | alias inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | subnet cidr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | dns text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(ip,alias) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:72: ERROR: relation "device_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_ip_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_ip_ip ON device_ip(ip); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:75: ERROR: relation "idx_device_ip_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_ip_alias" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_ip_alias ON device_ip(alias); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:76: ERROR: relation "idx_device_ip_alias" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_ip_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_ip_ip_port ON device_ip(ip,port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:77: ERROR: relation "idx_device_ip_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_module" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_module ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | index integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | description text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | type text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | parent integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | name text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | class text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | pos integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | hw_ver text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | fw_ver text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | sw_ver text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | serial text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | model text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | fru boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(ip,index) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:97: ERROR: relation "device_module" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | descr text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | up text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | up_admin text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | type text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | duplex text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | duplex_admin text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | speed text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | name text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mtu integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | stp text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | remote_ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | remote_port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | remote_type text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | remote_id text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vlan text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | pvid integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | lastchange bigint, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(port,ip) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:122: ERROR: relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_ip ON device_port(ip); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:124: ERROR: relation "idx_device_port_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_remote_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_remote_ip ON device_port(remote_ip); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:125: ERROR: relation "idx_device_port_remote_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_ip_port_duplex" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_ip_port_duplex ON device_port(ip,port,duplex); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:127: ERROR: relation "idx_device_port_ip_port_duplex" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_ip_up_admin" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_ip_up_admin ON device_port(ip,up_admin); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:128: ERROR: relation "idx_device_port_ip_up_admin" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_mac ON device_port(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:129: ERROR: relation "idx_device_port_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_log ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | id serial, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | reason text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | log text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | username text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | userip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | action text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:141: ERROR: relation "device_port_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_log_1" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_log_1 ON device_port_log(ip,port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:143: ERROR: relation "idx_device_port_log_1" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_log_user" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_log_user ON device_port_log(username); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:144: ERROR: relation "idx_device_port_log_user" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_power" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_power ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | module integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | admin text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | class text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | power integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(port,ip) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:155: ERROR: relation "device_port_power" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_ssid ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ssid text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | broadcast boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | bssid macaddr netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:163: ERROR: relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_ssid_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_ssid_ip_port ON device_port_ssid(ip,port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:165: ERROR: relation "idx_device_port_ssid_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_vlan ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vlan integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | native boolean not null default false, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vlantype text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(ip,port,vlan) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:176: ERROR: relation "device_port_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_wireless ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | channel integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | power integer netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:183: ERROR: relation "device_port_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_device_port_wireless_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_device_port_wireless_ip_port ON device_port_wireless(ip,port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:185: ERROR: relation "idx_device_port_wireless_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_power" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_power ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | module integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | power integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(ip,module) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:193: ERROR: relation "device_power" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_vlan ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vlan integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | description text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(ip,vlan) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:202: ERROR: relation "device_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE log ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | id serial, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | class text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | entry text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | logfile text netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:211: ERROR: relation "log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | switch inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | vlan text default '0', netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | oui varchar(8), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_first timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_recent timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(mac,switch,port,vlan) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:224: ERROR: relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_switch_port_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_switch_port_active ON node(switch,port,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:227: ERROR: relation "idx_node_switch_port_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:228: ERROR: relation "idx_node_switch_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_switch_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_switch_port ON node(switch,port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:229: ERROR: relation "idx_node_switch" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_switch" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_switch ON node(switch); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_mac ON node(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:230: ERROR: relation "idx_node_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_mac_active ON node(mac,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:231: ERROR: relation "idx_node_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_ip ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_first timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(mac,ip) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:241: ERROR: relation "node_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_ip_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_ip_ip ON node_ip(ip); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:244: ERROR: relation "idx_node_ip_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_ip_ip_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_ip_ip_active ON node_ip(ip,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:245: ERROR: relation "idx_node_ip_ip_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_ip_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_ip_mac ON node_ip(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:246: ERROR: relation "idx_node_ip_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_ip_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_ip_mac_active ON node_ip(mac,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:247: ERROR: relation "idx_node_ip_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_monitor" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_monitor ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | why text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | cc text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | date TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(mac) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:256: ERROR: relation "node_monitor" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_nbt ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbname text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | domain text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | server boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbuser text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_first timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:270: ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac ON node_nbt(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:273: ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_nbname ON node_nbt(nbname); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:274: ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_domain ON node_nbt(domain); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:275: ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac_active ON node_nbt(mac,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:276: ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ALTER TABLE netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ALTER TABLE netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:298: ERROR: relation "node_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_wireless ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ssid text default '', netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | uptime integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | maxrate integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | txrate integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | sigstrength integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | sigqual integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | rxpkt integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | txpkt integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | rxbyte bigint, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | txbyte bigint, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(mac,ssid) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ALTER TABLE netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ALTER TABLE netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "oui" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE oui ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | oui varchar(8) PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | company text netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:312: ERROR: relation "oui" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "process" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE process ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | controller integer not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | device inet not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | action text not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | status text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | count integer, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:324: ERROR: relation "process" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "sessions" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE sessions ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | id char(32) NOT NULL PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | a_session text netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:330: ERROR: relation "sessions" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "subnets" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE subnets ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | net cidr NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(net) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:337: ERROR: relation "subnets" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "topology" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE topology ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | dev1 inet not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port1 text not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | dev2 inet not null, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port2 text not null netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:345: ERROR: relation "topology" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "user_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE user_log ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | entry serial, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | username varchar(50), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | userip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | event text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | details text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:358: ERROR: relation "user_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE users ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | username varchar(50) PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | password text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_on TIMESTAMP, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port_control boolean DEFAULT false, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ldap boolean DEFAULT false, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | admin boolean DEFAULT false, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | fullname text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | note text netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-1-2-PostgreSQL.sql:370: ERROR: relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | COMMIT netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | BEGIN netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "remote_type" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN remote_type text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:5: ERROR: column "remote_type" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "remote_id" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN remote_id text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:6: ERROR: column "remote_id" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "vlan" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN vlan text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:7: ERROR: column "vlan" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "vtp_domain" of relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device ADD COLUMN vtp_domain text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:9: ERROR: column "vtp_domain" of relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "fullname" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE users ADD COLUMN fullname text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:11: ERROR: column "fullname" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "note" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE users ADD COLUMN note text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-2-3-PostgreSQL.sql:12: ERROR: column "note" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | COMMIT netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | BEGIN netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "lastchange" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN lastchange bigint; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:7: ERROR: column "lastchange" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "logfile" of relation "log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE log ADD COLUMN logfile text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:9: ERROR: column "logfile" of relation "log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "user_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE user_log ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | entry serial, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | username varchar(50), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | userip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | event text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | details text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation TIMESTAMP DEFAULT now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:18: ERROR: relation "user_log" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_nbt ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbname text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | domain text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | server boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbuser text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_first timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:30: ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac ON node_nbt(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:33: ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_nbname ON node_nbt(nbname); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:34: ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_domain ON node_nbt(domain); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:35: ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac_active ON node_nbt(mac,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-3-4-PostgreSQL.sql:36: ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | COMMIT netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | BEGIN netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:12: ERROR: relation "subnets" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "subnets" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE subnets ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | net cidr NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | creation timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | last_discover timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY(net) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE node_nbt ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | mac macaddr PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbname text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | domain text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | server boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | nbuser text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | active boolean, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_first timestamp default now(), netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | time_last timestamp default now() netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:29: ERROR: relation "node_nbt" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac ON node_nbt(mac); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:32: ERROR: relation "idx_node_nbt_mac" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_nbname ON node_nbt(nbname); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:33: ERROR: relation "idx_node_nbt_nbname" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_domain ON node_nbt(domain); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:34: ERROR: relation "idx_node_nbt_domain" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX idx_node_nbt_mac_active ON node_nbt(mac,active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:35: ERROR: relation "idx_node_nbt_mac_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "time_recent" of relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node ADD time_recent timestamp; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:39: ERROR: column "time_recent" of relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ALTER TABLE netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | UPDATE 0 netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE device_port_ssid ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ip inet, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | port text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ssid text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | broadcast boolean, netdisco_netdisco-post... [truncated message content] |