Problem

eucalyptus-logo

Every six months our Eucalyptus Cloud has this problem: https://eucalyptus.atlassian.net/browse/EUCA-7376

We were on 4.0.1 and now 4.0.2. I had posted this issue to the Eucalyptus Users Google Groups Back in October of 2014 https://groups.google.com/a/eucalyptus.com/forum/#!searchin/euca-users/EUCA-7376/euca-users/nHM6BXPRoOo/yXnlwDEh1SwJ

The first time we solved the issue by just reformatting everything and reinstall. (That worked but we didn’t know why…) The first symptom of this is that the Eucaconsole (installed locally on the CLC) would not receive login requests – nothing would happen upon login. This was our first hint that it was a service problem. Then we started seeing these errors in the Postgress logs:

ERROR: update or delete on table "metadata_extant_network" violates foreign key constraint "fkbdc151865dab4005" on table "metadata_network_indices" DETAIL: Key (id)=(8a1f98a840b2dcf20140be92918a0f8e) is still referenced from table "metadata_network_indices". STATEMENT: delete from metadata_extant_network where id=$1 and version=$2 ERROR: update or delete on table "metadata_extant_network" violates foreign key constraint "fkbdc151865dab4005" on table "metadata_network_indices" DETAIL: Key (id)=(8a1f98a840b2dcf20140be5722140f59) is still referenced from table "metadata_network_indices". STATEMENT: delete from metadata_extant_network where id=$1 and version=$2 ERROR: update or delete on table "metadata_extant_network" violates foreign key constraint "fkbdc151865dab4005" on table "metadata_network_indices" DETAIL: Key (id)=(8a1f98a840b2dcf20140bde9407c0ed6) is still referenced from table "metadata_network_indices". STATEMENT: delete from metadata_extant_network where id=$1 and version=$2 ERROR: update or delete on table "metadata_extant_network" violates foreign key constraint "fkbdc151865dab4005" on table "metadata_network_indices" DETAIL: Key (id)=(8a1f98a840b2dcf20140bd7b64b60e5d) is still referenced from table "metadata_network_indices". STATEMENT: delete from metadata_extant_network where id=$1 and version=$2 ERROR: update or delete on table "metadata_extant_network" violates foreign key constraint "fkbdc151865dab4005" on table "metadata_network_indices" DETAIL: Key (id)=(8a1f98a840b2dcf20140bf6e4c1a107c) is still referenced from table "metadata_network_indices". STATEMENT: delete from metadata_extant_network where id=$1 and version=$2

So we made like DigDug found out what may have been causing this.

Solution:

We noticed that the dhcp service failed to start on the CC. Not dhpcd but dnsmasq and these 3 steps fixed our problem.

  1. The postgres is caused by DHCP. That needs to be fixed. We need to restart dhcp and then the restart the CC to fix the dhcp.
  2. Restart the CLC to get rid of the metadata.
  3. nginx service on CLC service needs to be manually started after the dhcp is fixed and the CLC is rebooted
  4. In addition the SC went to state broken during this time - I believe because of the postgress errors and process breaking communication Logs available upon request.