Invalid argument(s) 'pool_maxconn' sent to create_engine()

[Natim]

TypeError: Invalid argument(s) 'pool_maxconn' sent to create_engine(), using configuration PGDialect_psycopg2/QueuePoolWithMaxBacklog/Engine.  Please check that the keyword arguments are appropriate for this combination of components.

This error occured while deploying Kinto to stage. @leplatrem thoughts?

[almet]

What's the configuration that was used? How can we reproduce?

[Natim]

This: https://sentry.prod.mozaws.net/operations/kinto-stage/group/241579/

[almet]

Hmm, I don't have any access there. Can you copy and paste the stacktrace in this bug (I think that's something we might want to do for these issues anyway, because not all contributors have access to the sentry stack).

[Natim]

Usually I shared them publicly so it should work.

[Natim]

Stacktrace (appel le plus récent en dernier) : 

  File "app.wsgi", line 23, in <module>
    application = main(config.items('DEFAULT'), **dict(config.items('app:main')))
  File "kinto/__init__.py", line 43, in main
    default_settings=DEFAULT_SETTINGS)
  File "cliquet/initialization.py", line 530, in initialize
    config.include("cliquet", route_prefix=api_version)
  File "pyramid/config/__init__.py", line 798, in include
    c(configurator)
  File "cliquet/__init__.py", line 155, in includeme
    step_func(config)
  File "cliquet/initialization.py", line 190, in setup_storage
    backend = storage_mod.load_from_config(config)
  File "cliquet/storage/postgresql/__init__.py", line 743, in load_from_config
    client = create_from_config(config, prefix='storage_')
  File "cliquet/storage/postgresql/client.py", line 94, in create_from_config
    engine = sqlalchemy.engine_from_config(settings, prefix=prefix, url=url)
  File "sqlalchemy/engine/__init__.py", line 427, in engine_from_config
    return create_engine(url, **options)
  File "sqlalchemy/engine/__init__.py", line 386, in create_engine
    return strategy.create(*args, **kwargs)
  File "sqlalchemy/engine/strategies.py", line 144, in create
    engineclass.__name__))

[Natim]

I think it is because the config name is wrong, @phrawzty can you verify that it looks like this? http://kinto.readthedocs.org/en/latest/configuration/production.html#recommended-settings

Or paste the config here?

[leplatrem]

Please use this template for the configuration:
https://github.com/Kinto/kinto-dist/blob/master/config/kinto.ini

[phrawzty]

The ini deployed to stage is legacy - I assume that at one point those maxconn variables were valid. A simple s/maxconn/size/ caused those errors to disappear, as expected. 😄

[leplatrem]

Great! Closing this.