[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:
> Hi,
>
> 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
neutron?

https://bugs.launchpad.net/neutron/+bug/1268423

>
> Cheers,
> NM 
>
> -- 
> 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
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators


-- 
1AE0 322E B8F7 4717 BDEA BF1D 44BB 1BA7 9F6C 6333

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20140311/60df5039/attachment.html>


More information about the OpenStack-operators mailing list