[Openstack-operators] [neutron] running more than one api_worker while using postgres
gustavo panizzo <gfa>
gfa at zumbi.com.ar
Tue Mar 11 17:43:26 UTC 2014
On 03/11/2014 01:14 PM, Nick Maslov wrote:
> We are on postgres boat as well - and yes, UTF-8 is our default
> setting for all OpenStack databases.
going off topic here, were you able to run more than one api_worker in
> Nick Maslov
> Sent with Airmail
> On March 10, 2014 at 11:25:39 PM, gustavo panizzo (gfa at zumbi.com.ar
> <mailto:gfa at zumbi.com.ar>) wrote:
>> adding -operators, removing -dev
>> On 03/10/2014 02:24 PM, Chris Friesen wrote:
>> > Hi,
>> > I'm using havana and recent we ran into an issue with heat related to
>> > character sets.
>> > In heat/db/sqlalchemy/api.py in user_creds_get() we call
>> > _decrypt() on an encrypted password stored in the database and then
>> > try to convert the result to unicode. Today we hit a case where this
>> > errored out with the following message:
>> > UnicodeDecodeError: 'utf8' codec can't decode byte 0xf2 in position 0:
>> > invalid continuation byte
>> > We're using postgres and currently all the databases are using
>> > SQL_ASCII as the charset.
>> > I see that in icehouse heat will complain if you're using mysql and
>> > not using UTF-8. There doesn't seem to be any checks for other
>> > databases though.
>> > It looks like devstack creates most databases as UTF-8 but uses latin1
>> > for nova/nova_bm/nova_cell. I assume this is because nova expects to
>> > migrate the db to UTF-8 later. Given that those migrations specify a
>> > character set only for mysql, when using postgres should we explicitly
>> > default to UTF-8 for everything?
>> after running openstack with postgres for a year i can tell you. use
>> UTF-8 on your db.
>> our db were encoded SQL_ASCII on install time and sooner or later we had
>> issues, recreating db on UTF-8 fixed them
>> 1AE0 322E B8F7 4717 BDEA BF1D 44BB 1BA7 9F6C 6333
>> OpenStack-operators mailing list
>> OpenStack-operators at lists.openstack.org
1AE0 322E B8F7 4717 BDEA BF1D 44BB 1BA7 9F6C 6333
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the OpenStack-operators