Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

PR #19048 breaks PDO backed session storage on PGSQL 9.5 #19057

Copy link
Copy link
Closed
@aashley

Description

@aashley
Issue body actions

Testing the upgrade from Symfony 3.0 to 3.1 with our code base that uses the session.handler.pdo with the stock config as recommended by http://symfony.com/doc/current/cookbook/doctrine/pdo_session_storage.html.

Our config snippets:

framework:
    session:
        handler_id:  session.handler.pdo
services:
    session.handler.pdo:
        class: Symfony\Component\HttpFoundation\Session\Storage\Handler\PdoSessionHandler
        public: false
        arguments:
            - 'pgsql:host=%database_host%;dbname=%database_name%'
            - { db_username: '%database_user%', db_password: '%database_password%' }

When attempting to resume an existing session get the follow error:
SQLSTATE[42702]: Ambiguous column: 7 ERROR: column reference "sess_id" is ambiguous
LINE 1: ...a, sess_lifetime, sess_time) = ($2, $3, $4) WHERE sess_id = ...

triggered by line 336 in vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/PdoSessionHandler.php

This is using the Ubuntu 16.04 package postgresql-9.5 package version 9.5.3-0ubuntu0.16.04, with php 7.0.7-4+deb.sury.org~xenial+1.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.