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

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general