Обсуждение: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

Поиск
Список
Период
Сортировка

PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
tuanhoanganh
Дата:
Hello all.

I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit. But my plpython function have "ERROR: ImportError: DLL load failed: A dynamic link library (DLL) initialization routine failed." after import pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc version is pyodbc-3.0.2.win-amd64-py3.2.
On windows 7 SP1 64bit everything run fine.
Please help me. Thanks in advance.

Tuan Hoang Anh

Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
John R Pierce
Дата:
On 9/26/2013 8:00 PM, tuanhoanganh wrote:
>
> I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64
> bit. But my plpython function have "ERROR: ImportError: DLL load
> failed: A dynamic link library (DLL) initialization routine failed."
> after import pyodbc
> My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc version
> is pyodbc-3.0.2.win-amd64-py3.2.
> On windows 7 SP1 64bit everything run fine.
> Please help me. Thanks in advance.

I just heard from a developer friend that a recent windows update broke
all KINDA dll-related things with Windows.   maybe thats what is
happening here.  maybe not.   he hasn't gotten to the bottom of it yet.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
tuanhoanganh
Дата:
If i run import pyodbc from python command and run pyodbc sql command, everything work well.
Please help me.

Tuan Hoang Anh


On Fri, Sep 27, 2013 at 10:05 AM, John R Pierce <pierce@hogranch.com> wrote:
On 9/26/2013 8:00 PM, tuanhoanganh wrote:

I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit. But my plpython function have "ERROR: ImportError: DLL load failed: A dynamic link library (DLL) initialization routine failed." after import pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc version is pyodbc-3.0.2.win-amd64-py3.2.
On windows 7 SP1 64bit everything run fine.
Please help me. Thanks in advance.

I just heard from a developer friend that a recent windows update broke all KINDA dll-related things with Windows.   maybe thats what is happening here.  maybe not.   he hasn't gotten to the bottom of it yet.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
tuanhoanganh
Дата:
I try install plpython on PostgreSQL 9.3, Ubuntu 12.04 64bit but it has error when CREATE EXTENSION plpython3u;
2013-09-27 22:09:26 ICT LOG:  database system was shut down at 2013-09-27 22:09:20 ICT
2013-09-27 22:09:26 ICT LOG:  database system is ready to accept connections
2013-09-27 22:09:26 ICT LOG:  autovacuum launcher started
Traceback (most recent call last):
  File "/usr/lib/python3.2/sysconfig.py", line 354, in _init_posix
    _parse_makefile(makefile, vars)
  File "/usr/lib/python3.2/sysconfig.py", line 240, in _parse_makefile
    with open(filename, errors="surrogateescape") as f:
IOError: [Errno 2] No such file or directory: '/usr/lib/python3.2/config-3.2m/Makefile'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3.2/site.py", line 549, in <module>
    main()
  File "/usr/lib/python3.2/site.py", line 537, in main
    known_paths = addusersitepackages(known_paths)
  File "/usr/lib/python3.2/site.py", line 269, in addusersitepackages
    user_site = getusersitepackages()
  File "/usr/lib/python3.2/site.py", line 244, in getusersitepackages
    user_base = getuserbase() # this will also set USER_BASE
  File "/usr/lib/python3.2/site.py", line 234, in getuserbase
    USER_BASE = get_config_var('userbase')
  File "/usr/lib/python3.2/sysconfig.py", line 597, in get_config_var
    return get_config_vars().get(name)
  File "/usr/lib/python3.2/sysconfig.py", line 494, in get_config_vars
    _init_posix(_CONFIG_VARS)
  File "/usr/lib/python3.2/sysconfig.py", line 359, in _init_posix
    raise IOError(msg)
IOError: invalid Python installation: unable to open /usr/lib/python3.2/config-3.2m/Makefile (No such file or directory)

My python 3.2 is

tuan@tuan-VirtualBox:/$ python3.2 --version
Python 3.2.3
tuan@tuan-VirtualBox:/$ python3.2 --version
Python 3.2.3
tuan@tuan-VirtualBox:/$ python3.2
Python 3.2.3 (default, Apr 10 2013, 06:11:55)
[GCC 4.6.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> exit()
tuan@tuan-VirtualBox:/$




On Fri, Sep 27, 2013 at 11:53 AM, tuanhoanganh <hatuan05@gmail.com> wrote:
If i run import pyodbc from python command and run pyodbc sql command, everything work well.
Please help me.

Tuan Hoang Anh


On Fri, Sep 27, 2013 at 10:05 AM, John R Pierce <pierce@hogranch.com> wrote:
On 9/26/2013 8:00 PM, tuanhoanganh wrote:

I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit. But my plpython function have "ERROR: ImportError: DLL load failed: A dynamic link library (DLL) initialization routine failed." after import pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc version is pyodbc-3.0.2.win-amd64-py3.2.
On windows 7 SP1 64bit everything run fine.
Please help me. Thanks in advance.

I just heard from a developer friend that a recent windows update broke all KINDA dll-related things with Windows.   maybe thats what is happening here.  maybe not.   he hasn't gotten to the bottom of it yet.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
Adrian Klaver
Дата:
On 09/27/2013 08:55 AM, tuanhoanganh wrote:
> I try install plpython on PostgreSQL 9.3, Ubuntu 12.04 64bit but it has
> error when CREATE EXTENSION plpython3u;
> 2013-09-27 22:09:26 ICT LOG:  database system was shut down at
> 2013-09-27 22:09:20 ICT
> 2013-09-27 22:09:26 ICT LOG:  database system is ready to accept connections
> 2013-09-27 22:09:26 ICT LOG:  autovacuum launcher started
> Traceback (most recent call last):
>    File "/usr/lib/python3.2/sysconfig.py", line 354, in _init_posix
>      _parse_makefile(makefile, vars)
>    File "/usr/lib/python3.2/sysconfig.py", line 240, in _parse_makefile
>      with open(filename, errors="surrogateescape") as f:
> IOError: [Errno 2] No such file or directory:
> '/usr/lib/python3.2/config-3.2m/Makefile'
>
> During handling of the above exception, another exception occurred:

At a guess you do not have the python3.2 devel package installed.


--
Adrian Klaver
adrian.klaver@gmail.com

Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

От
tuanhoanganh
Дата:
I installed pyodbc-3.0.7.win-amd64-py3.2.exe from http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc then it work well


On Fri, Sep 27, 2013 at 10:00 AM, tuanhoanganh <hatuan05@gmail.com> wrote:
Hello all.

I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit. But my plpython function have "ERROR: ImportError: DLL load failed: A dynamic link library (DLL) initialization routine failed." after import pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc version is pyodbc-3.0.2.win-amd64-py3.2.
On windows 7 SP1 64bit everything run fine.
Please help me. Thanks in advance.

Tuan Hoang Anh