Good question, the database was completely empty before the installation, I have dropped and created again just before starting "rhqctl install"

The log fragment of psql:
grep -i rhq_storage /var/log/postgresql/postgresql-9.2-main.log
...
2013-11-12 10:33:54 CET ERROR:  table "rhq_storage_node" does not exist
2013-11-12 10:33:54 CET STATEMENT:  DROP TABLE RHQ_STORAGE_NODE
2013-11-12 10:33:54 CET ERROR:  sequence "rhq_storage_node_id_seq" does not exist
2013-11-12 10:33:54 CET STATEMENT:  DROP SEQUENCE RHQ_STORAGE_NODE_ID_SEQ
2013-11-12 10:39:41 CET ERROR:  duplicate key value violates unique constraint "rhq_storage_node_unique"
...

in those 6 minutes something has happened...

This is the very first "insert into RHQ_STORAGE_NODE ..." statement in the log, and already breaks the uniqueness!


Attila


2013/11/12 Thomas Segismont <tsegismo@redhat.com>
That's good news. But how come you had a storage node entity already stored in the database?