MonetDB problem with mserver.exe

older
Re: Could monetdb have a capacity...

Kaspar Burger

9 Jun 2014 9 Jun '14

2:28 p.m.

Hello, I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so... 1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/ 2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\) 3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\) 4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\). When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong? I would appreciate any hint. Thanks in advance. Kaspar Burger

Show replies by date

Martin Kersten

9 Jun 9 Jun

7:54 p.m.

On 09/06/14 16:28, Kaspar Burger wrote:

...

Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

...

2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Stefan Manegold

10:06 p.m.

...

On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.) Stefan

...

...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

Sjoerd Mullender

10 Jun 10 Jun

4:03 a.m.

On 2014-06-10 00:06, Stefan Manegold wrote:

...

...
On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)

You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.

...

Stefan

...
...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.

...

...
...
I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

-- Sjoerd Mullender

Kaspar Burger

6:32 a.m.

Thanks. I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code: batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE ) When I run the pid <- monetdb.server.start( batfile ) line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code? Kaspar

...

On 2014-06-10 00:06, Stefan Manegold wrote:

...
...
On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)

You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.

...
Stefan

...
...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.

...
...
...
I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

-- Sjoerd Mullender

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Hannes Mühleisen

6:42 a.m.

This seems to fall into my backyard... On 10.06.2014, at 08:32, Kaspar Burger wrote:

...

I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:

batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )

When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code? Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again.

Best, Hannes

...

...
On 2014-06-10 00:06, Stefan Manegold wrote:

...
...
On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)

You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.

...
Stefan

...
...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.

...
...
...
I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

-- Sjoerd Mullender

_______________________________________________ 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

Anthony Damico

6:50 a.m.

kaspar has something changed? when you and i screenshared to try to resolve this issue, mserver.exe was shutting down immediately before R ever came into the picture? what happens when you run this file independent of R? C:\Users\Kaspar Burger\MonetDB\test.bat On Tue, Jun 10, 2014 at 2:42 AM, Hannes Mühleisen wrote:

...

This seems to fall into my backyard...

On 10.06.2014, at 08:32, Kaspar Burger wrote:

...
I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:

batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )

When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see:

...
By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code? Would not be surprised if the space in the batfile path causes the

https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da... ). problem. Try setting up the DB into another directory without a space in it and try again.

Best,

Hannes

...
...
On 2014-06-10 00:06, Stefan Manegold wrote:

...
...
On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)

You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.

...
Stefan

...
...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.

...
...
...
I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

-- Sjoerd Mullender

_______________________________________________ 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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Kaspar Burger

7:04 a.m.

You are right, Anthony, when I run the file independent of R, mserver.exe shuts down immediately. De : users-list [mailto:users-list-bounces+kaspar.burger=iukb.ch@monetdb.org] De la part de Anthony Damico Envoyé : mardi 10 juin 2014 08:51 À : Communication channel for MonetDB users Objet : Re: MonetDB problem with mserver.exe kaspar has something changed? when you and i screenshared to try to resolve this issue, mserver.exe was shutting down immediately before R ever came into the picture? what happens when you run this file independent of R? C:\Users\Kaspar Burger\MonetDB\test.bat On Tue, Jun 10, 2014 at 2:42 AM, Hannes Mühleisen wrote: This seems to fall into my backyard... On 10.06.2014, at 08:32, Kaspar Burger wrote:

...

I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:

batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )

When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code?

Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again. Best, Hannes

...

...
On 2014-06-10 00:06, Stefan Manegold wrote:

...
...
On 09/06/14 16:28, Kaspar Burger wrote:

...
Hello,

I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...

1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/

Most likely, you need only 1 ODBC driver. Otherwise causing a clash.

For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)

You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.

...
Stefan

...
...
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver\)

3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver\)

4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5\).

When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?

Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.

...
...
...
I would appreciate any hint. Thanks in advance.

Kaspar Burger

_______________________________________________ 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

-- Sjoerd Mullender

_______________________________________________ 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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Kostis Kyzirakos

9 Jun 9 Jun

9:53 p.m.

When I open up mserver.exe, it shuts down immediately. Does anyone know

...

what could have gone wrong?

How exactly are you running mserver5.exe? Are you running the batch file C:\Program Files\MonetDB\MonetDB5\M5server.bat (assuming that you used the default installation paths), are you running C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe with your own arguments, or are you starting the server by clicking Start --> MonetDB5 --> MonetDB SQL Server?

3854

Age (days ago)

3855

Last active (days ago)

List overview

Download

8 comments

7 participants

participants (7)

Anthony Damico
Hannes Mühleisen
Kaspar Burger
Kostis Kyzirakos
Martin Kersten
Sjoerd Mullender
Stefan Manegold