Date: 2016-12-22 15:52:32 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: Karan Kapoor <<95kkapoor>>
Version: 11.25.3 (Dec2016)
CC: 95kkapoor, khushikashyap123, webhostinguk

Last updated: 2019-01-24 14:55:21 +0100

Comment 24849

Date: 2016-12-22 15:52:32 +0100
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Build Identifier:

After installing MonetDB/SQL server (release v11.25.3 "Dec2016"), starting the server using M5server.bat, I get pop-up error msg:
The program can't start because python27.dll is missing from your computer. Try reinstalling the program to fix the program.

The server does not crash, but it is also not usable as it does not complete its initialisation steps and does not listen on the default port 50000.

Reproducible: Always

Steps to Reproduce:

1. Install MonetDB5-SQL-Installer-x86_64-20161217.msi or MonetDB5-SQL-Installer-i386-20161217.msi on a computer which does NOT have python installed.
2. Start server via: M5server.bat

Actual Results:

On the console window I get:
"HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore\2.7\InstallPath""" not found.
MonetDB/Python Disabled: Python 2.7 installation not found.
MonetDB 5 server v11.25.3 "Dec2016"
Serving database 'demo', using 4 threads
Compiled for i686-pc-winnt/32bit
Found 3.240 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
!SyntaxException:parseError:
!LoaderException:loadLibrary:Loading error failed to open library pyapi (from within file 'C:\Program Files\MonetDB5\2016Dec\lib\monetdb5\lib_pyapi.dll'): The specified module could not be found.
!SyntaxException:parseError:
! expected

Expected Results:

No pop-up error dialog message and succesfull start-up of mserver5.

The problem has been analysed and fixed in http//devmonetdborg/hg/MonetDB?cmd=changeset;node=87f38df2b46b
It will be part of the next release.

As a temporary workaround you can resolve the loadLibrary problem yourself by disabling the import of pyapi.
This is specified in file: lib/monetdb/autoload/50_pyapi.mal
Either edit the file and add a in front of the line: include pyapi;
or rename the file to 50_pyapi.mal.org such that it will no longer be loaded and executed anymore.

Alternatively you can also install python 2.7.

Comment 24850

Date: 2016-12-22 15:55:27 +0100
From: Martin van Dinther <<martin.van.dinther>>

The problem has been fixed in http//devmonetdborg/hg/MonetDB?cmd=changeset;node=87f38df2b46b
It will be part of the next release.

Comment 24911

Date: 2017-01-26 14:55:57 +0100
From: @kutsurak

Fixed in version Dec2016-SP1.