caravel db upgrade fails on postgres

[xrmx]

On 3ee9a68c09750317f20eedd3968e9f36f6da10a1 trying to apply migrations on a fresh project on postgresql with

caravel db upgrade

gives:

2016-06-03 17:58:05,386:ERROR:flask_appbuilder.base:
Add Permission on Menu Error: (psycopg2.ProgrammingError) can't adapt type '_LazyString'
[SQL: 'SELECT ab_view_menu.id AS ab_view_menu_id, ab_view_menu.name AS 
ab_view_menu_name \nFROM ab_view_menu \nWHERE ab_view_menu.name = %(name_1)s \n 
LIMIT %(param_1)s'] [parameters: {'param_1': 1, 'name_1': l'Sources'}]

[xrmx]

On a second look this looks really a fab issue, @dpgaspar any hint on what could be wrong here?

[mistercrunch]

@xrmx I think it's on our side and related to translations

[xrmx]

@mistercrunch so we should not use lazy_gettext when the string is going through sqlalchemy? Or better making it an actual unicode object before using it in sqlalchemy.

[xrmx]

@mistercrunch could you please reopen this since installation of postgres is still broken?

Even with the patch applied caravel db upgrade hang applying the migrations

INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 4e6a06bad7a8, Init

And the server logs

2016-06-06 14:37:14 CEST [6125-1] caravel@caravel LOG:  could not receive data from client: Connection reset by peer
2016-06-06 14:37:14 CEST [6125-2] caravel@caravel LOG:  unexpected EOF on client connection with an open transaction