network restart fails with postgresql 9

Bug #724503 reported by Dan Posey
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
New
Undecided
Unassigned

Bug Description

Running nova-network_2011.2~bzr728-0ubuntu0ppa1~lucid1_all.deb

On Linux ubuntu-dan0 2.6.32-28-server #55-Ubuntu SMP Mon Jan 10 23:57:16 UTC 2011 x86_64 GNU/Linux.

SQL connection is: --sql_connection=postgresql+psycopg2://chowner:<password>@192.168.1.8:5401/nova

Database initially built successfully.

The following occurs when doing: service nova-network restart; service nova-compute restart;

STATEMENT: update instances set deleted=1,deleted_at='2011-02-24T18:23:49.252463'::timestamp where id=1
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
ERROR: column "deleted" is of type boolean but expression is of type integer at character 30
HINT: You will need to rewrite or cast the expression.
STATEMENT: update instances set deleted=1,deleted_at='2011-02-24T18:23:50.243706'::timestamp where id=1

This goes on and on until I do:

nova-network stop
nova-compute stop

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.