Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After update to multicorn-1.3.2 and ubuntu14.04.4 I get TypeError: expected string or buffer #134

Closed
arag0rn2k3 opened this issue Feb 29, 2016 · 2 comments

Comments

@arag0rn2k3
Copy link

The Problem is only to MSSQL-DB...how can i fix it?

File "/usr/local/lib/python2.7/dist-packages/multicorn-1.3.2-py2.7-linux-x86_64.egg/multicorn/sqlalchemyfdw.py", line 356, in begin
self.transaction = self.connection.begin()

      File "/usr/local/lib/python2.7/dist-packages/multicorn-1.3.2-py2.7-linux-x86_64.egg/multicorn/sqlalchemyfdw.py", line 352, in connection
        self._connection = self.engine.connect()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1641, in connect
        return self._connection_cls(self, **kwargs)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 59, in __init__
        self.__connection = connection or engine.raw_connection()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1699, in raw_connection
        return self.pool.unique_connection()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 220, in unique_connection
        return _ConnectionFairy(self).checkout()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 431, in __init__
        rec = self._connection_record = pool._do_get()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 772, in _do_get
        return self._create_connection()

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 225, in _create_connection
        return _ConnectionRecord(self)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 322, in __init__
        exec_once(self.connection, self)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/event.py", line 392, in exec_once
        self(*args, **kw)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/event.py", line 409, in __call__
        fn(*args, **kw)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 1049, in go
        return once_fn(*arg, **kw)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 168, in first_connect
        dialect.initialize(c)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/mssql/base.py", line 1129, in initialize
        super(MSDialect, self).initialize(connection)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 170, in initialize
        self._get_server_version_info(connection)

      File "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/mssql/pymssql.py", line 72, in _get_server_version_info
        r"Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)

      File "/usr/lib/python2.7/re.py", line 137, in match
        return _compile(pattern, flags).match(string)

    TypeError: expected string or buffer
@arag0rn2k3
Copy link
Author

The problem is since an update of multicorn, ubuntu, sqlalchemy and all other packages and my update from Postgresql 9.3.5 to PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit

The MSSQL Database is completely untouched (no changes or updates)

I get the error if I Select something in MSSQL over my Postgresql with Multicorn Extension
TESTCASE:

create foreign table NAV_OPEN_VENDOR ( "vendor" varchar, "posting_date" date, "remamount" numeric ) server alchemy_srv options ( tablename 'open_vendor', db_url 'mssql+pymssql://user:pass@192.168.1.100/database' );

In PostgreSQL: SELECT * from NAV_OPEN_VENDOR; -> TypeError: expected string or buffer

@arag0rn2k3
Copy link
Author

it seem that not the correct version string is reported to the SQLAlchemy driver...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant