Bugs item #1809586, was opened at 2007-10-08 18:23
Message generated for change (Comment added) made by stmane
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1809586&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: PF/runtime
Group: (zombie: Pathfinder 0.20)
Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Jan Rittinger (tsheyar)
Assigned to: Nobody/Anonymous (nobody)
Summary: PF: busy port crashes Mserver

Initial Comment:
Currently (probably not after a restart anymore) the port 50001 on my PC is in 
use.

This causes MonetDB to crash if I load 'module(pathfinder)' whereas loading 
only 'module(mapi)' does not kill the Mserver:

$> Mserver --set='mapi_port=50000' --dbinit='module(mapi);'
# MonetDB Server v4.21.0
# based on GDK   v1.21.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
MonetDB>
$> Mserver --set='mapi_port=50001' --dbinit='module(mapi);'
# MonetDB Server v4.21.0
# based on GDK   v1.21.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
!ERROR: MAPIlisten:binding to stream socket (50001) failed
!OS: Address already in use
MonetDB>
$> Mserver --set='mapi_port=50000' --dbinit='module(pathfinder);'
# MonetDB Server v4.21.0
# based on GDK   v1.21.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
# PF/Tijah module v0.3.0 loaded. http://dbappl.cs.utwente.nl/pftijah
# MonetDB/XQuery module v0.21.0 loaded
# XRPC administrative console at http://localhost:50001/admin
01/Jan/1970 01:00:00 shttpd_open_port: bind(50001): Address already in use
$> Mserver --set='mapi_port=50001' --dbinit='module(pathfinder);'
# MonetDB Server v4.21.0
# based on GDK   v1.21.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
# PF/Tijah module v0.3.0 loaded. http://dbappl.cs.utwente.nl/pftijah
!ERROR: MAPIlisten:binding to stream socket (50001) failed
!OS: Address already in use
$>

----------------------------------------------------------------------

>Comment By: Stefan Manegold (stmane)
Date: 2009-11-25 15:28

Message:
===================================================================
2009/11/25 - stmane: testing/src/Mfilter.py.in,1.5.4.3
        pathfinder/tests/BugTracker/Tests/port_busy.SF-1809586.py,1.2.6.3
       
pathfinder/tests/BugTracker/Tests/port_busy.SF-1809586.stable.err,1.2.6.1
       
pathfinder/tests/BugTracker/Tests/port_busy.SF-1809586.stable.out,1.2.6.1

slightly extended test and approved stable output for
ID: 1809586 "PF: busy port crashes Mserver"
https://sourceforge.net/tracker/?func=detail&aid=1809586&group_id=56967&atid=482468
and added extra Mfilter rule to cope with variable output
due to changing port numbers.

We accept the fact that starting a MonetDB/XQury server (`Mserver
--dbinit="module(pathfinder);"`)
quits instantly (with a proper error message)
in case either the MAPIPORT or the XQUERYPORT are not available
(the server does not make much sense without access to these ports).
The default ports can easily be overwritten on the server commandline:
--set mapi_port=<portno> --set xrpc_port=<portno>
===================================================================


----------------------------------------------------------------------

Comment By: Peter Boncz (boncz)
Date: 2009-11-12 10:35

Message:
requested to remove this test

----------------------------------------------------------------------

Comment By: Sjoerd Mullender (sjoerd)
Date: 2009-07-31 10:45

Message:
Added test in pathfinder/tests/BugTracker/Tests: port_busy.SF-1809586.
No correct stable output yet.

----------------------------------------------------------------------

Comment By: Stefan Manegold (stmane)
Date: 2007-10-08 18:33

Message:
Logged In: YES 
user_id=572415
Originator: NO

loading module sql_server also crashed the Msever instantly if the
requested mapi_port is busy:

$ Mserver --dbinit='module(sql_server);'
# MonetDB Server v4.20.0
# based on GDK   v1.20.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
!ERROR: MAPIlisten:binding to stream socket (50000) failed
!OS: Address already in use
$ 


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1809586&group_id=56967

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to