sathyay2k
Contributor
Contributor

vpostgres.log

2017-12-15 01:34:30.751 UTC 5a332683.1759 7491543 VCDB vc ERROR:  duplicate key value violates unique constraint "pk_vpx_vm_virtual_device"

2017-12-15 01:34:30.751 UTC 5a332683.1759 7491543 VCDB vc DETAIL:  Key (id, device_key)=(260, 8000) already exists.

2017-12-15 01:34:30.751 UTC 5a332683.1759 7491543 VCDB vc STATEMENT:  INSERT INTO VPX_VM_VIRTUAL_DEVICE (ID, DEVICE_KEY, CONN_AL_GU_CONTROL_FLAG, CONN_CONNECTED_FLAG, CONN_START_CONNECTED_FLAG, CONN_STATUS, DEVICE_INFO_SUMMARY, DEVICE_IN

FO_LABEL, DEVICE_CONTROLLER_KEY, DEVICE_UNIT_NUMBER, DEVICE_TYPE, DEVICE_TEXT) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)

2017-12-15 01:34:42.862 UTC 5a332683.1759 7491554 VCDB vc LOG:  could not receive data from client: Connection reset by peer

2017-12-15 01:34:42.863 UTC 5a332683.1759 7491554 VCDB vc LOG:  unexpected EOF on client connection with an open transaction

2017-12-15 01:35:13.349 UTC 5a3325e0.acf 0   LOG:  Updating instance status...

Resolution

DELETE FROM vpx_vm_virtual_device where id=’260’ and device_key=’8000’;

Reply
0 Kudos