Bugs item #2693363, was opened at 2009-03-19 04:27 Message generated for change (Comment added) made by sjoerd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2693363&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: Pathfinder "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: winston (wwinston) Assigned to: Nobody/Anonymous (nobody) Summary: PF: mserver does not start with pathfinder option on Windows Initial Comment: mserver appears to start OK. However, the pathfinder option does not appear to start. The start up process exits after the PF/Tijah module v0.9.0 is loaded; the start up exits to the DOS command prompt. This is shown below under the heading: ACTUAL CONSOLE OUTPUT. According the Tijah documentation, these following two steps should appear last and the command prompt should appear as shown here, and are thus missing: # MonetDB/XQuery module v0.20.0 loaded # XRPC administrative console at http://localhost:50001/admin MonetDB> =x=x=x=x=x= ACTUAL CONSOLE OUTPUT: C:\MonetDB\MonetDB4>mserver # MonetDB Server v4.28.0 # based on GDK v1.28.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB>Terminate batch job (Y/N)? y C:\MonetDB\MonetDB4>mserver --dbinit="module(pathfinder);" # MonetDB Server v4.28.0 # based on GDK v1.28.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah C:\MonetDB\MonetDB4> ---------------------------------------------------------------------- >Comment By: Sjoerd Mullender (sjoerd) Date: 2009-05-07 15:21 Message: Winston, I have a couple of questions for you: - which older version of MonetDB did you replace with the new installation? - the default location of older versions of MonetDB was C:\Program Files\CWI\MonetDB4, whereas now it is C:\Program Files\MonetDB\MonetDB4. In which location did you install, and are there any files left over in the old location? - still older versions of MonetDB installed a few files in C:\Windows\system32 (files matching the pattern lib*.dll). We don't do that anymore. Do you have any of those files still lying around? - the default database location is %APPDATA%\MonetDB4. Did you remove that folder? - older versions of MonetDB used %APPDATA%\MonetDB (note the missing 4) as the location of the database. The Mserver.bat script has code to use that folder if the MonetDB4 folder does not exist. Did you have the MonetDB folder? The installers are built on a Windows XP Professional SP3 system and have also been tested on such a system. I was able to start the server from the Start menu and do a simple query. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-05-07 06:49 Message: Winston, thanks for the update! Do I understand correctly, that on the WinXP SP2 starting the MonetDB/XQuery server via the start menu entry and/or via MXQserver.bat works fine, while it fails on the WinXP SP3 machine? The hardware should not make a difference, so I expect the problems to be related to WinXP SP2 vs. SP3. Are both of your Windows 32-bit? Alex (who posted ID: 2787535), which version of Windows XP are you using? SP2 or SP3? 32-bit or 64-bit? Stefan ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-07 04:41 Message: The installation that I am having trouble with is a Dell laptop with Windows XP SP3, Intel Core 2. ACTION TAKEN: I installed MonetDB on one of my older HP PCs with Win XP SP2, Intel Pentium 4. RESULTS: The WinXP SP2 installation seems to be working OK. The problems I am encountering are all on the WinXP SP3 on the Dell. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-05-05 23:49 Message: Same problem has also been reported in ID: 2787535 "XQuery Server doesn't start in Windows XP" https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787535&group_id=56967 ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-05-03 08:12 Message: Winston, thanks for the update! However, if only my work-around of loading all modules by hand works, but using MXQserver.bat or `Mserver.bat --dbinit="module(pathfinder);" does not, this bug report should stay open, and we should (try to) find out what is going wrong and (preferably) fit it (provided it is a problem inside MonetDB). Stefan ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-02 23:31 Message: Stefan, I followed your procedure one more time, making sure to delete the %APPDATA%\MonetDB4\* files followed by the set of server commands that you gave me on 2009-03-25 08:18. This time I was able to get the server started and I was able to load documents through the client interface. I was able to load several documents except for one that was >1GB in size, so I opened a separate bug ticket for this problem. Thank you for your assistance. You may close this bug. ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-02 22:45 Message: Stefan This appears to have worked OK, but when I try to load documents from the client it fails: xquery>pf:add-doc("C:\data\XMarkStandard\f0.xml","f0.xml","f0") more><> MAPI = mone...@localhost:50000 QUERY = pf:add-doc("C:\data\XMarkStandard\f0.xml","f0.xml","f0") ERROR = !ERROR: interpret: no matching MIL operator to 'ws_create(int)'. xquery> ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-04-29 06:56 Message: Winston, is there any news regarding your problem? Did you test my latest suggestions? Stefan ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-03-25 13:18 Message: Winston, with removed or empty %APPDATA%\MonetDB4\dbfarm & %APPDATA%\MonetDB4\xquery_logs --- and in case starting MXQserver.bat still does not work, could you please try to start a plain Mserver.bat, give the following commands in the given order on its "MonetDB>" console prompt, and check/report whether/which work without errors? module(mapi); module(pf_support); module(logger); module(mkey); module(xrpc_server); module(xrpc_client); module(pf_standoff); module(pathfinder); Stefan ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-03-25 07:17 Message: Next to %APPDATA%\MonetDB did you also remove %APPDATA%\MonetDB4 ^ ? If not, please remove %APPDATA%\MonetDB4\dbfarm & %APPDATA%\MonetDB4\xquery_logs and try again --- otherwise, I'll try to think of some more debugging options and come back to you later ... ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-03-25 04:43 Message: I deleted the %APPDATA%/MonetDB directory and all files. I reran the MonetDB4-XQuery-Installer-i386-20090227.msi and selected remove MonetDB. I reran the MonetDB4-XQuery-Installer-i386-20090227.msi and reinstalled MonetDB. The same exact problem is occuring. Is there any way to get more debug detail on the startup of MonetDB4? ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-03-23 09:18 Message: Thanks. In [ 2687825 ] Installation problem - MonetDB will not startup https://sourceforge.net/tracker/index.php?func=detail&aid=2687825&group_id=56967&atid=482468 you say "After installing a clean version of MoneyDB4 in a new directory, ..." ^^^^^^^^^^^^^^^^^^ Are you sure that there are no remains of a previous installation of MonetDB left on your system? Did you next to %APPDATA%\MonetDB4\dbfarm also clean/remove %APPDATA%\MonetDB4\xquery_logs? Could you possibly consider uninstalling all versions of MonetDB from your system, remove all leftover remains of previous installation and their database (dbfarm) and logs (xquery_logs, sql_logs) and the re-install the latest installer from scratch? ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-03-22 22:27 Message: Windows XP Pro, SP3 Yes, Installed MonetDB4-XQuery-Installer-i386-20090227.msi Replaced a previous version of MonetDB and I had troubles doing so: see Ticket# 2687825 for more information. Yes, the directories are writable. MonetDB did create the demo directory. Yes, networking is enabled. XQuery never started. It failed on the first and all subsequent attempts. I tried switching the ports to 50505 and 55555, but I get the same results. Is there anyway to debug the start up process? ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-03-22 10:01 Message: Winston, here are a couple of questions for information that we'd need to analyse/debug your problem: - Which version of Windows are you using? - May we assume you installed http://monetdb.cwi.nl/downloads/Windows/Feb2009/MonetDB4-XQuery-Installer-i386-20090227.msi and no problems occured during installation? - Is this your first and only installation of MonetDB/XQuery, or did you upgrade/replace a previous version of MonetDB/XQuery? If the latter, which version of MonetDB/XQuery did you use before, and do you still have database created by that version on your machine? - Are the following directories writeable for you on your machine? %APPDATA%\MonetDB4 %APPDATA%\MonetDB4\dbfarm %APPDATA%\MonetDB4\xquery_logs - Is general networking enabled or disabled on your machine? - Did you once manage to successfully start MonetDB with XQuery/pathfinder module, or did already the first attempt fail? - In case you once managed, what did you do/experience since between the last successful start-up and the first failing one? (Load & query documents? Encouter errors? If the latter, which ones?) - Do you happen to have any other servers/services running on your machine that use/block ports 50000 and/or 50001? You might try to start MonetDB/XQuery with alternative ports, e.g., MXQserver.bat --mapi_port=50505 MXQserver.bat --xrpc_port=55555 MXQserver.bat --mapi_port=50505 --xrpc_port=55555 Stefan ---------------------------------------------------------------------- Comment By: Henning Rode (hrode) Date: 2009-03-22 08:46 Message: Can someone else take over here? This is so far not a PF/Tijah related problem. Since the XQuery server does not even start correctly, I am in fact not sure, if we should handle this as a bug. It seems to fall more in the category "installation problems". And if there is anyone else able to help you, we need to know also your system details: what kind of machine and windows version you are using. ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-03-21 15:40 Message: I still have the same problem. Your recommendation does not address the issue. I have the same problem when executing the mxqserver command or from windows menu pick. I merely showed you the command string so that you would see the problem in the MS-DOS command window. Essentially, I can't get the XQuery part started. The database startup exits without any error message and without giving me a command prompt. Below, please observe the mxqserver output as contrasted to the mserver output; mserver starts OK and gives a MonetDB command prompt, but mxqserver does not start and does not give a MonetDB command prompt, instead exiting to a MS-DOS command prompt. C:\MonetDB\MonetDB4>mserver # MonetDB Server v4.28.0 # based on GDK v1.28.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB> MonetDB>Terminate batch job (Y/N)? y C:\MonetDB\MonetDB4>mxqserver # MonetDB Server v4.28.0 # based on GDK v1.28.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah C:\MonetDB\MonetDB4> ---------------------------------------------------------------------- Comment By: Henning Rode (hrode) Date: 2009-03-19 09:04 Message: The PF/Tijah documentation was already pointing to MonetDB/XQuery pages here, but I added another direct link to the very helpful "first steps" page, Stefan suggested below. Does this solve the problem? Or do you still face problems to starting the Mserver with PF/Tijah? ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-03-19 07:39 Message: I am not sure, which Tijah documentation you refer to, but the MonetDB/XQuery documentation tells clearly how to start a MonetDB/XQuery server *on Windows*; http://monetdb.cwi.nl/XQuery/QuickTour/HelloWorld/index.html says " Starting Mserver The first task is to start the MonetDB Server. On Windows platforms this is done by clicking: Start -> Programs -> MonetDB -> MonetDB XQuery Server If you are a Linux user, you should type something like: Mserver --dbinit="module(pathfinder);" " Alternatively, on Windows, you can also call "MXQserver.bat" to start the MonetDB/XQuery server. Maybe, you want to inform the maintainers of the Tijah documentation that you refer to to update their Windows-specific documentation accordingly. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2693363&group_id=56967 ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
