netdisco-users Digest, Vol 138, Issue 25

Mon, 29 Jan 2018 21:54:59 -0800 

Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."

Today's Topics:

   1. Re: Netdisco docker upgrade (Josep Manel Andr?s Moscard?)
--- Begin Message --- 
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-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-4-5-PostgreSQL.sql:51: ERROR: relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | channel integer 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
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-4-5-PostgreSQL.sql:53: ERROR: relation "idx_device_port_ssid_ip_port" already exists 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | UPDATE 23285
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 "snmp_class" of relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device ADD snmp_class text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:9: ERROR: column "snmp_class" of relation "device" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:13: ERROR: column "subnet" of relation "device_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "subnet" of relation "device_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_ip ADD subnet cidr; 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-5-6-PostgreSQL.sql:17: ERROR: relation "idx_admin_entered" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:18: ERROR: relation "idx_admin_status" 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 | 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-5-6-PostgreSQL.sql:19: ERROR: relation "idx_admin_action" 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    |        );
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:40: ERROR: relation "device_module" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: multiple primary keys for table "device_module" are not allowed netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_module ADD PRIMARY KEY(ip,index); 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-5-6-PostgreSQL.sql:44: ERROR: multiple primary keys for table "device_module" are not allowed netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:54: ERROR: relation "process" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:57: ERROR: column "creation" of relation "process" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "creation" of relation "process" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE process ADD creation TIMESTAMP DEFAULT now(); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:61: ERROR: column "ldap" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "ldap" of relation "users" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE users ADD ldap boolean; 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "pvid" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD pvid integer; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:66: ERROR: column "pvid" of relation "device_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 | 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-5-6-PostgreSQL.sql:78: ERROR: relation "device_port_vlan" 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-5-6-PostgreSQL.sql:89: ERROR: relation "device_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:99: ERROR: relation "device_power" 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 | 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 | 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-5-6-PostgreSQL.sql:111: ERROR: relation "device_port_power" 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-5-6-PostgreSQL.sql:118: 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-5-6-PostgreSQL.sql:120: ERROR: relation "idx_device_port_wireless_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "channel" does not exist at character 72 netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | HINT: There is a column named "channel" in table "device_port_wireless", but it cannot be referenced from this part of the query. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: INSERT INTO device_port_wireless ( ip,port,channel ) ( SELECT ip,port,channel FROM device_port_ssid WHERE channel IS NOT NULL ); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:126: ERROR: column "channel" does not exist netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LINE 1: ...rt_wireless ( ip,port,channel ) ( SELECT ip,port,channel FR... netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ^ netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | HINT: There is a column named "channel" in table "device_port_wireless", but it cannot be referenced from this part of the query. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:128: ERROR: column "channel" of relation "device_port_ssid" does not exist netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "channel" of relation "device_port_ssid" does not exist netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_ssid DROP channel; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:146: ERROR: relation "node_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-5-6-PostgreSQL.sql:157: ERROR: relation "node_monitor" 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 | 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) 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
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    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
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-6-7-PostgreSQL.sql:9: ERROR: relation "idx_node_ip_ip_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "power" of relation "device_port_power" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_power ADD power integer; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-6-7-PostgreSQL.sql:12: ERROR: column "power" of relation "device_port_power" 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 "vlantype" of relation "device_port_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_vlan ADD vlantype text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-7-8-PostgreSQL.sql:8: ERROR: column "vlantype" of relation "device_port_vlan" 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-7-8-PostgreSQL.sql:16: ERROR: relation "topology" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "bssid" of relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_ssid ADD bssid macaddr; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-7-8-PostgreSQL.sql:19: ERROR: column "bssid" of relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "vlan" of relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node ADD vlan text DEFAULT '0'; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-7-8-PostgreSQL.sql:22: ERROR: column "vlan" of relation "node" 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 | ERROR: column "ssid" of relation "node_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node_wireless ADD ssid text DEFAULT ''; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-7-8-PostgreSQL.sql:28: ERROR: column "ssid" of relation "node_wireless" 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    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
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-8-9-PostgreSQL.sql:8: ERROR: relation "topology" 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 "bssid" of relation "device_port_ssid" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_ssid ADD COLUMN bssid macaddr; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-9-10-PostgreSQL.sql:3: ERROR: column "bssid" of relation "device_port_ssid" 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 "vlantype" of relation "device_port_vlan" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port_vlan ADD COLUMN vlantype text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-10-11-PostgreSQL.sql:3: ERROR: column "vlantype" of relation "device_port_vlan" 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 "dns" of relation "node_ip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node_ip ADD COLUMN dns text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-11-12-PostgreSQL.sql:3: ERROR: column "dns" of relation "node_ip" 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    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
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 "vlan" of relation "node" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node ADD COLUMN vlan text DEFAULT '0' NOT NULL; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-14-15-PostgreSQL.sql:3: ERROR: column "vlan" of relation "node" 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 "ssid" of relation "node_wireless" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE node_wireless ADD COLUMN ssid text DEFAULT '' NOT NULL; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-15-16-PostgreSQL.sql:3: ERROR: column "ssid" of relation "node_wireless" 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: relation "device_port_power_idx_ip_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX device_port_power_idx_ip_port on device_port_power (ip, port); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-16-17-PostgreSQL.sql:3: ERROR: relation "device_port_power_idx_ip_port" 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    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | CREATE INDEX
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "topology_dev1_port1" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE topology ADD CONSTRAINT topology_dev1_port1 UNIQUE (dev1, port1); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-21-22-PostgreSQL.sql:3: ERROR: relation "topology_dev1_port1" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-21-22-PostgreSQL.sql:5: ERROR: relation "topology_dev2_port2" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "topology_dev2_port2" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE topology ADD CONSTRAINT topology_dev2_port2 UNIQUE (dev2, port2); 
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 "manual_topo" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN "manual_topo" bool DEFAULT false NOT NULL; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-22-23-PostgreSQL.sql:3: ERROR: column "manual_topo" of relation "device_port" 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-23-24-PostgreSQL.sql:3: ERROR: column "is_uplink" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "is_uplink" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN "is_uplink" bool; 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: constraint "device_ip_alias" of relation "device_ip" does not exist netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_ip DROP CONSTRAINT "device_ip_alias"; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-24-25-PostgreSQL.sql:3: ERROR: constraint "device_ip_alias" of relation "device_ip" does not exist 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "community" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE "community" ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "ip" inet NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "snmp_comm_rw" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY ("ip") 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-29-30-PostgreSQL.sql:7: ERROR: relation "community" 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    | ALTER TABLE
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    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | DROP INDEX
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | UPDATE 0
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "node_ip_idx_ip_active" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE INDEX node_ip_idx_ip_active ON node_ip (ip, active); netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-34-35-PostgreSQL.sql:3: ERROR: relation "node_ip_idx_ip_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    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | ALTER TABLE
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 "abbrev" of relation "oui" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE oui ADD COLUMN abbrev text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-36-37-PostgreSQL.sql:3: ERROR: column "abbrev" of relation "oui" 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    | ALTER TABLE
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "slave_of" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN "slave_of" text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-37-38-PostgreSQL.sql:4: ERROR: column "slave_of" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-37-38-PostgreSQL.sql:5: ERROR: column "is_master" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "is_master" of relation "device_port" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE device_port ADD COLUMN "is_master" bool DEFAULT false NOT NULL; 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | DELETE 0
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-40-41-PostgreSQL.sql:3: ERROR: column "snmp_auth_tag_read" of relation "community" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "snmp_auth_tag_read" of relation "community" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE community RENAME COLUMN snmp_auth_tag TO snmp_auth_tag_read; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "snmp_auth_tag_write" of relation "community" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE community ADD COLUMN snmp_auth_tag_write text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-40-41-PostgreSQL.sql:5: ERROR: column "snmp_auth_tag_write" of relation "community" 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-41-42-PostgreSQL.sql:9: ERROR: relation "device_skip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "device_skip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE "device_skip" ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "backend" text NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device" inet NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "actionset" text[] DEFAULT '{}', netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "deferrals" integer DEFAULT 0, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY ("backend", "device") 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
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 "last_defer" of relation "device_skip" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE "device_skip" ADD "last_defer" timestamp; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-42-43-PostgreSQL.sql:3: ERROR: column "last_defer" of relation "device_skip" 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: relation "statistics" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE "statistics" ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "day" date NOT NULL DEFAULT CURRENT_DATE, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_ip_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_link_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_port_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_port_up_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "ip_table_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "ip_active_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "node_table_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "node_active_count" integer NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "netdisco_ver" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "snmpinfo_ver" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "schema_ver" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "perl_ver" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "pg_ver" text, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | PRIMARY KEY ("day") 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-43-44-PostgreSQL.sql:23: ERROR: relation "statistics" already exists 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | BEGIN
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: column "device_key" of relation "admin" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: ALTER TABLE "admin" ADD "device_key" text; netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-44-45-PostgreSQL.sql:3: ERROR: column "device_key" of relation "admin" 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: relation "netmap_positions" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE "netmap_positions" ( netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "id" serial PRIMARY KEY, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "device_groups" text[] NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "vlan" integer NOT NULL DEFAULT 0, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | "positions" text NOT NULL, netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | UNIQUE ("device_groups", "vlan") 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |    );
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | psql:/var/lib/postgresql/netdisco-sql/App-Netdisco-DB-45-46-PostgreSQL.sql:9: ERROR: relation "netmap_positions" already exists 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | COMMIT
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: importing OUI netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: marking schema as up-to-date netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "dbix_class_schema_versions" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: CREATE TABLE dbix_class_schema_versions (version varchar(10) PRIMARY KEY, installed varchar(20) NOT NULL) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: relation "dbix_class_schema_versions" already exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: duplicate key value violates unique constraint "dbix_class_schema_versions_pkey" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Key (version)=(46) already exists. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | STATEMENT: INSERT INTO dbix_class_schema_versions VALUES ('46', 'v20180124_123043.000') netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | ERROR: duplicate key value violates unique constraint "dbix_class_schema_versions_pkey" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Key (version)=(46) already exists. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: adding admin user if none exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: adding session key if none exists netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: queueing stats job 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | INSERT 0 1
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | netdisco-db-entrypoint: shutting down pg (will restart, listening for clients) netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | waiting for server to shut down...LOG: received fast shutdown request netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: aborting any active transactions netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | .LOG: autovacuum launcher shutting down netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: shutting down netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | LOG: database system is shut down 
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    |  done
netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01    | server stopped
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 shut down at 2018-01-24 12:30:43 UTC 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 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password authentication failed for user "net-user" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | DETAIL: Role "net-user" does not exist. netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | Connection matched pg_hba.conf line 95: "host all all all md5" netdisco_netdisco-postgresql.1.mpgky297s3lk@dock-test01 | FATAL: password auth 

On 23/01/18 21:32, Oliver Gorwits wrote:

Hi Josep and Stephan (and others),

You can find initial docker images and instructions here:

https://store.docker.com/community/images/netdisco/netdisco

good luck! and please do let me know how you get on.
To those familiar with docker, I would appreciate feedback as well, as I'm new to this myself. 

regards,
oliver.

On 2018-01-19 12:26, Stephan Grund wrote:

Hi Oliver, hi Josep,

this is just a small 'me too' mail. Currently we doesn't use docker in
our environment. But I'm setting up a kubernetes cluster and one of the
first services, that we want to migrate is netdisco.
So, I'm looking forward to your development.

Stephan

On 19.01.2018 13:20, Josep Manel Andrés Moscardó wrote:

Hi Oliver,
I am glad to test your new development, since we are running it on a docker swarm mode (cluster) I will need to rearrange the docker-compose.yml 
Has anyone work on this already so I don't have to reinvent the wheel ?

Cheers.
------------------------------------------------------------------------------ 
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users


--
------------------------------------------------
Josep Manel Andrés Moscardó
System Administrator
IMIM-Hospital del Mar Research Institut

--- End Message ---
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to