weird mserver startup failure on windows
hi, i am trying to test something with this version of mserver on windows: http://monetdb.cwi.nl/testweb/web/63169:4438fea68169/MonetDB5-SQL-Installer-... it installed fine, but when i load up an mserver session, it says: # MonetDB 5 server v11.26.0 "default-4438fea68169" # Serving database 'demo', using 8 threads # Compiled for x86_64-pc-winnt/64bit # Found 15.914 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2017 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\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'): The specified module could not be found. !SyntaxException:parseError: !<identifier> expected
and then if i click on the window, it disappears. if i try to connect to an mserver session through MonetDB.R, the mserver window repeats these two lines forever: # SQL catalog created, loading sql scripts once # loading sql script: 09_like.sql here's a screenshot: http://tinypic.com/r/s6rtjd/9 any ideas about what i should try? maybe installing python? but i've never had to do so before, so maybe i'm doing something else dumb.. thanks!
sorry, just to confirm, when i revert to
https://www.monetdb.org/downloads/Windows/Dec2016-SP2/MonetDB5-SQL-Installer...
the installation, server startup, and connection to server all work fine
for me on windows. any ideas why the dev build would be stalling at
"09_like.sql" would be appreciated.. thanks all!
On Wed, Mar 15, 2017 at 1:08 PM, Anthony Damico
hi, i am trying to test something with this version of mserver on windows:
http://monetdb.cwi.nl/testweb/web/63169:4438fea68169/ MonetDB5-SQL-Installer-x86_64-4438fea68169.msi
it installed fine, but when i load up an mserver session, it says:
# MonetDB 5 server v11.26.0 "default-4438fea68169" # Serving database 'demo', using 8 threads # Compiled for x86_64-pc-winnt/64bit # Found 15.914 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2017 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\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'): The specified module could not be found. !SyntaxException:parseError: !<identifier> expected
and then if i click on the window, it disappears.
if i try to connect to an mserver session through MonetDB.R, the mserver window repeats these two lines forever:
# SQL catalog created, loading sql scripts once # loading sql script: 09_like.sql
here's a screenshot: http://tinypic.com/r/s6rtjd/9
any ideas about what i should try? maybe installing python? but i've never had to do so before, so maybe i'm doing something else dumb.. thanks!
Hey Anthony, There was a bug with Python UDFs on Windows in the initial release of Dec2016 which caused a similar issue when Python was not installed. That should have been resolved in the default branch already, though, but perhaps the bug has popped up again. I will have a look later. What you could try in the meantime is removing the “pyapi.mal” file in the mserver directory and see if that resolves the issue for you. Mark
On 16 Mar 2017, at 11:21, Anthony Damico
wrote: sorry, just to confirm, when i revert to https://www.monetdb.org/downloads/Windows/Dec2016-SP2/MonetDB5-SQL-Installer... https://www.monetdb.org/downloads/Windows/Dec2016-SP2/MonetDB5-SQL-Installer... the installation, server startup, and connection to server all work fine for me on windows. any ideas why the dev build would be stalling at "09_like.sql" would be appreciated.. thanks all!
On Wed, Mar 15, 2017 at 1:08 PM, Anthony Damico
mailto:ajdamico@gmail.com> wrote: hi, i am trying to test something with this version of mserver on windows: http://monetdb.cwi.nl/testweb/web/63169:4438fea68169/MonetDB5-SQL-Installer-... http://monetdb.cwi.nl/testweb/web/63169:4438fea68169/MonetDB5-SQL-Installer-...
it installed fine, but when i load up an mserver session, it says:
# MonetDB 5 server v11.26.0 "default-4438fea68169" # Serving database 'demo', using 8 threads # Compiled for x86_64-pc-winnt/64bit # Found 15.914 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ http://www.monetdb.org/ for further information !SyntaxException:parseError: !LoaderException:loadLibrary:Loading error failed to open library pyapi (from within file 'C:\Program Files\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'): The specified module could not be found. !SyntaxException:parseError: !<identifier> expected
and then if i click on the window, it disappears.
if i try to connect to an mserver session through MonetDB.R, the mserver window repeats these two lines forever:
# SQL catalog created, loading sql scripts once # loading sql script: 09_like.sql
here's a screenshot: http://tinypic.com/r/s6rtjd/9 http://tinypic.com/r/s6rtjd/9
any ideas about what i should try? maybe installing python? but i've never had to do so before, so maybe i'm doing something else dumb.. thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
hi, thank you, so i guess i am hitting two problems, and deleting this file
solves one of them? i guess the python issue snuck back in, but there's
also something going on with 09_like.sql?
C:\Program Files\MonetDB\MonetDB5\lib\monetdb5\pyapi.mal
now this mserver window text has disappeared:
!SyntaxException:parseError:
!LoaderException:loadLibrary:Loading error failed to open library pyapi
(from within file 'C:\Program
Files\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'):
The specified module could not be found.
!SyntaxException:parseError:
!<identifier> expected
but this problem still occurs on the dev branch on windows, and i am still
unable to connect to mserver with an mclient on windows. exact same
infinite message whether i connect via mclient (user/password: monetdb) or
through MonetDB.R
# SQL catalog created, loading sql scripts once
# loading sql script: 09_like.sql
here's a screenshot: http://tinypic.com/r/s6rtjd/9
thanks!
On Thu, Mar 16, 2017 at 6:30 AM, Mark Raasveldt
Hey Anthony,
There was a bug with Python UDFs on Windows in the initial release of Dec2016 which caused a similar issue when Python was not installed. That should have been resolved in the default branch already, though, but perhaps the bug has popped up again. I will have a look later. What you could try in the meantime is removing the “pyapi.mal” file in the mserver directory and see if that resolves the issue for you.
Mark
On 16 Mar 2017, at 11:21, Anthony Damico
wrote: sorry, just to confirm, when i revert to https://www.monetdb.org/ downloads/Windows/Dec2016-SP2/MonetDB5-SQL-Installer-x86_64-20170227.msi the installation, server startup, and connection to server all work fine for me on windows. any ideas why the dev build would be stalling at "09_like.sql" would be appreciated.. thanks all!
On Wed, Mar 15, 2017 at 1:08 PM, Anthony Damico
wrote: hi, i am trying to test something with this version of mserver on windows:
http://monetdb.cwi.nl/testweb/web/63169:4438fea68169/MonetDB 5-SQL-Installer-x86_64-4438fea68169.msi
it installed fine, but when i load up an mserver session, it says:
# MonetDB 5 server v11.26.0 "default-4438fea68169" # Serving database 'demo', using 8 threads # Compiled for x86_64-pc-winnt/64bit # Found 15.914 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2017 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\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'): The specified module could not be found. !SyntaxException:parseError: !<identifier> expected
and then if i click on the window, it disappears.
if i try to connect to an mserver session through MonetDB.R, the mserver window repeats these two lines forever:
# SQL catalog created, loading sql scripts once # loading sql script: 09_like.sql
here's a screenshot: http://tinypic.com/r/s6rtjd/9
any ideas about what i should try? maybe installing python? but i've never had to do so before, so maybe i'm doing something else dumb.. thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Anthony Damico
-
Mark Raasveldt