Bugs item #1681244, was opened at 2007-03-15 09:25 Message generated for change (Settings changed) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1681244&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: Mapi Group: MonetDB4 CVS Head >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Jan Rittinger (tsheyar) Assigned to: Stefan Manegold (stmane) Summary: Mapi ports and patfhinder/pftijah Initial Comment: When I have a Mserver (with module pathfinder loaded) running somewhere and want to start a complete unrelated Mserver (with pathfinder (and pftijah) I get the following Mserver crashes: Mserver --dbinit="module(pathfinder);" # Monet Database Server V4.17.1 # 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 (50000) failed !OS: Address already in use MonetDB>01/Jan/1970 01:00:00 shttpd_open_port: bind(50001): Address already in use Mserver --dbinit="module(pathfinder); module(pftijah);" # Monet Database Server V4.17.1 # 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 (50000) failed !OS: Address already in use !WARNING: TBL_M_directloaded: pftijah relative refcounts are wrong (2!=3)! !WARNING: TBL_M_directloaded: pftijah relative refcounts are wrong (2!=3)! Mserver: /local_tmp/MonetDB4/src/monet/monet_tbl.mx:1740: TBL_M_decref: Assertion `p' failed. Aborted ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-11-27 09:07 Message: Bug report and test are covered by ID: 1809586 "PF: busy port crashes Mserver" https://sourceforge.net/tracker/?func=detail&aid=1809586&group_id=56967&atid=482468 " 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: Stefan Manegold (stmane) Date: 2007-08-02 22:57 Message: Logged In: YES user_id=572415 Originator: NO ...as always a test in CVS could (have) answer(ed) the question... If nobody is faster, I'll try to add one tomorrow (CEST). ---------------------------------------------------------------------- Comment By: Peter Boncz (boncz) Date: 2007-08-02 22:45 Message: Logged In: YES user_id=591107 Originator: NO is this bug still reproducable, given the changes we made in tijah module loading before the .18 release? ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2007-03-15 10:54 Message: Logged In: YES user_id=43607 Originator: NO I agree with Jan, there is a genuine bug here. In one of my tries I even got a segfault. ---------------------------------------------------------------------- Comment By: Jan Rittinger (tsheyar) Date: 2007-03-15 10:32 Message: Logged In: YES user_id=993208 Originator: YES Stefan, with this feature I expect only an error message (like the one in the first line) and the side effect that the module is not loaded. However a Mserver crash (with a misleading error information) does not seem reasonable to me: Mserver # Monet Database Server V4.17.1 # 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>module(pathfinder); !ERROR: MAPIlisten:binding to stream socket (50000) failed !OS: Address already in use !WARNING: TBL_M_directloaded: _pftijah relative refcounts are wrong (1!=2)! 01/Jan/1970 01:00:00 shttpd_open_port: bind(50001): Address already in use ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2007-03-15 10:24 Message: Logged In: YES user_id=572415 Originator: NO Jan this is not a bug but a feature: Loading module pathfinder (just like loading module sql) implicitly triggers the start of the respective mapi listener so that clients can connect. The default port (mapi_port) used for these listeners is 50000. Obviously, starting two programs that (try to) claim the same port/socket does/can not work. If you want/need to run two (or more) Mservers with MAPI enabled (via module(pathfinder);, module(sql);, or module(mapi);mil_start();) on the same machine, you need to make sure that they use different mapi_port's by starting (at least) all but one with specifying a different mapi_port, e.g., via `Mserver --set mapi_port=<mapi_port_no>`; in case of pathfinder you might also want/need to set a different xrpc_port, i.e. `Mserver --set mapi_port=<mapi_port_no> --set xprc_port=<xrpc_port_no>`. Stefan ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1681244&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
