[mapguide-users] mgservice at 100%

George McLean gmclean at gorge.net
Tue Mar 20 14:46:33 EDT 2007


Thanks Traian!

That did the trick. I tried to run db_recover by modifying the 
RepositoryAdmin.php but that sent the CPU into 100% with dbrecover.exe.

What are those files that you suggested I delete?

Thanks again

George


Traian Stanev wrote:
> Sometimes when I get problems with the repository, I manually delete all
> files named __db.00X (where X is a number) under the Repositories
> directory. This is a non-scientific suggestion though and is not
> guaranteed to work...
>
> Traian
>
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of George
> McLean
> Sent: Tuesday, March 20, 2007 1:04 PM
> To: MapGuide Users Mail List
> Subject: Re: [mapguide-users] mgservice at 100%
>
> Is there any way to know approximately how long the cold backup should 
> take? I am running backupofflinerepositories.bat and the CPU has been at
>
> 100% for about 20 minutes with the db_checkpoint.exe taking all the CPU.
>
> I see the backupRepositories folder and subfolders but there are no 
> files in them yet.
>
> Is it possible the repository database is in a state where the backup 
> does not work? Are there any tools to try and repair it? This is a 
> development system so if I had to rebuild it from scratch that would not
>
> be a huge loss but it would be good to learn how to fix this sort of 
> problem.
>
> Thanks
>
> George
>
> Steve Dang wrote:
>   
>> Hi George,
>>
>> I suggest you to perform a "cold" backup then a restore of the
>> repositories. The instruction should be under the MapGuide Server
>> installation directory:
>>
>> 	..\Server\RepositoryAdmin\RepositoryAdmin.pdf
>>
>> Steve.
>>
>> -----Original Message-----
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of George
>> McLean
>> Sent: Monday, March 19, 2007 6:26 PM
>> To: MapGuide Users Mail List
>> Subject: [mapguide-users] mgservice at 100%
>>
>> I am having problems with mgserver.exe running at 100% in Windows XP.
>>
>> I tried repair of mgserver and extensions but that did not solve it so
>>     
> I
>   
>> uninstalled extensions and server then reinstalled. This did not solve
>>     
>
>   
>> the problem either.
>>
>> I found the discussion below and have stopped the service in task 
>> manager and tried running as an application from the command line
>>     
> using 
>   
>> 'mgserver run'. After starting as an application my CPU is still
>>     
> pegged 
>   
>> at 100% with mgserver.exe as the process using all the CPU
>>
>> Before re-installing I made copy of all the files and folders under
>>     
> the 
>   
>> C:\Program Files\MapGuideOpenSource folder so I am assuming I have 
>> everything backed up.
>>
>> Should I uninstall and then delete all the repositories etc then 
>> re-install? Any other suggestions?
>>
>> Thanks
>>
>> George
>>
>>
>>
>> Subject:
>> RE: [mapguide-users] Site corrupt - MG Server fails to start
>> From:
>> "Bruce Dechant" <bruce.dechant at autodesk.com>
>> Date:
>> Mon, 20 Nov 2006 13:07:36 -0800
>> To:
>> <users at mapguide.osgeo.org>
>>
>> To:
>> <users at mapguide.osgeo.org>
>>
>>
>>   
>>     
>>> The files might not actually be corrupt, but may have not been closed
>>>       
>
>   
>>> properly (example: due to power outage). When the server starts it 
>>> tries to "clean up" the repositories using the generated log files. 
>>> Under certain circumstances this can take longer then the Windows 
>>> Service Control Manager allows for a service starting up. The thing
>>>       
> to
>   
>>>     
>>>       
>>   
>>     
>>> do in this case is to not run the server as a service and instead run
>>>       
>
>   
>>> it interactively as an application to give the server time to cleanup
>>>       
>
>   
>>> the repository. Once the repository has been cleaned up you can stop 
>>> the server application and restart it as a service. Note: that you 
>>> should not have to do this under normal operating conditions.
>>>
>>> Bruce
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Jason Birch [mailto:Jason.Birch at nanaimo.ca]
>>> *Sent:* November 18, 2006 9:41 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> Good cautionary tale.
>>>
>>> If anyone is not backing up their repositories, they should strongly 
>>> consider it. I haven't seen any problems yet, but the repositories
>>>       
> are
>   
>>>     
>>>       
>>   
>>     
>>> file-based and are subject to corruption in the case of interrupted 
>>> writes, etc.
>>>
>>> There is a RepositoryAdmin directory in the Server installation that 
>>> contains some utilities for doing this, and instructions. You can
>>>       
> find
>   
>>>     
>>>       
>>   
>>     
>>> a copy of the isntructions here:
>>>
>>>
>>>     
>>>       
> https://mapguide.osgeo.org/source/browse/*checkout*/mapguide/trunk/MgDev
>   
>> /Server/RepositoryAdmin/MgOpenSourceRepositoryAdmin.pdf
>>   
>>     
>>> Hmm. It would be nice if we could leverage an RDBMS data store to 
>>> store the repository info. This would kinda break the managed data 
>>> idea, but it would eliminate the load balancing problems around 
>>> session access. I don't really like storing my data with the site 
>>> configuration info anyway :)
>>>
>>> Jason
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Andy Morsell
>>> *Sent:* Sat 2006-11-18 12:14 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* [mapguide-users] Site corrupt - MG Server fails to start
>>>
>>> I have no idea how this happened, but it is rather disconcerting. 
>>> Luckily it was only the Site data that was a problem and that my 
>>> Library seems to be fine. Otherwise I would be reaching into my 
>>> backups to restore from.
>>>
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> Subject:
>>> RE: [mapguide-users] Site corrupt - MG Server fails to start
>>> From:
>>> "Andy Morsell" <amorsell at spatialgis.com>
>>> Date:
>>> Mon, 20 Nov 2006 13:13:05 -0800
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>>
>>> Thanks for the information Bruce, I'll try that next time I see these
>>>       
>
>   
>>> symptoms (hopefully never again). Dave Wilson also mentioned in the 
>>> MapGuide Enterprise discussion group that if the files under Site are
>>>       
>
>   
>>> deleted, then server will re-create them when started. I tested this 
>>> and it worked. You will end up losing any users and groups you setup 
>>> (and I'm sure other things, but I don't know exactly what), but I was
>>>       
>
>   
>>> pleasantly surprised to see that resource service paths were not 
>>> effected (my repository is not in the default location).
>>>
>>> Andy
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Bruce Dechant [mailto:bruce.dechant at autodesk.com]
>>> *Sent:* Monday, November 20, 2006 1:08 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> The files might not actually be corrupt, but may have not been closed
>>>       
>
>   
>>> properly (example: due to power outage). When the server starts it 
>>> tries to "clean up" the repositories using the generated log files. 
>>> Under certain circumstances this can take longer then the Windows 
>>> Service Control Manager allows for a service starting up. The thing
>>>       
> to
>   
>>>     
>>>       
>>   
>>     
>>> do in this case is to not run the server as a service and instead run
>>>       
>
>   
>>> it interactively as an application to give the server time to cleanup
>>>       
>
>   
>>> the repository. Once the repository has been cleaned up you can stop 
>>> the server application and restart it as a service. Note: that you 
>>> should not have to do this under normal operating conditions.
>>>
>>> Bruce
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Jason Birch [mailto:Jason.Birch at nanaimo.ca]
>>> *Sent:* November 18, 2006 9:41 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> Good cautionary tale.
>>>
>>> If anyone is not backing up their repositories, they should strongly 
>>> consider it. I haven't seen any problems yet, but the repositories
>>>       
> are
>   
>>>     
>>>       
>>   
>>     
>>> file-based and are subject to corruption in the case of interrupted 
>>> writes, etc.
>>>
>>> There is a RepositoryAdmin directory in the Server installation that 
>>> contains some utilities for doing this, and instructions. You can
>>>       
> find
>   
>>>     
>>>       
>>   
>>     
>>> a copy of the isntructions here:
>>>
>>>
>>>     
>>>       
> https://mapguide.osgeo.org/source/browse/*checkout*/mapguide/trunk/MgDev
>   
>> /Server/RepositoryAdmin/MgOpenSourceRepositoryAdmin.pdf
>>   
>>     
>>> Hmm. It would be nice if we could leverage an RDBMS data store to 
>>> store the repository info. This would kinda break the managed data 
>>> idea, but it would eliminate the load balancing problems around 
>>> session access. I don't really like storing my data with the site 
>>> configuration info anyway :)
>>>
>>> Jason
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Andy Morsell
>>> *Sent:* Sat 2006-11-18 12:14 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* [mapguide-users] Site corrupt - MG Server fails to start
>>>
>>> I have no idea how this happened, but it is rather disconcerting. 
>>> Luckily it was only the Site data that was a problem and that my 
>>> Library seems to be fine. Otherwise I would be reaching into my 
>>> backups to restore from.
>>>
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> Subject:
>>> RE: [mapguide-users] Site corrupt - MG Server fails to start
>>> From:
>>> "Jason Birch" <Jason.Birch at nanaimo.ca>
>>> Date:
>>> Mon, 20 Nov 2006 13:18:10 -0800
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>>
>>>  
>>> If you're talking about the same paths that I think you are, they are
>>>     
>>>       
>> stored in the serverconfig.ini file.  
>>   
>>     
>>>  
>>> Jason
>>>
>>> ________________________________
>>>
>>> From: Andy Morsell
>>> Sent: Mon 2006-11-20 1:13 PM
>>> To: users at mapguide.osgeo.org
>>> Subject: RE: [mapguide-users] Site corrupt - MG Server fails to start
>>>
>>>
>>> Thanks for the information Bruce, I'll try that next time I see these
>>>     
>>>       
>> symptoms (hopefully never again).  Dave Wilson also mentioned in the
>> MapGuide Enterprise discussion group that if the files under Site are
>> deleted, then server will re-create them when started.  I tested this
>> and it worked.  You will end up losing any users and groups you setup
>> (and I'm sure other things, but I don't know exactly what), but I was
>> pleasantly surprised to see that resource service paths were not
>> effected (my repository is not in the default location).
>>   
>>     
>>>  
>>>   
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> Subject:
>>> RE: [mapguide-users] Site corrupt - MG Server fails to start
>>> From:
>>> "Brad Nesom" <kidsmake6 at msn.com>
>>> Date:
>>> Mon, 20 Nov 2006 15:47:17 -0600
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>>
>>> Is there a service or application that could be checked to see if the
>>>       
>
>   
>>> cleanup is still running or completed?
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Bruce Dechant [mailto:bruce.dechant at autodesk.com]
>>> *Sent:* Monday, November 20, 2006 3:08 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> The files might not actually be corrupt, but may have not been closed
>>>       
>
>   
>>> properly (example: due to power outage). When the server starts it 
>>> tries to "clean up" the repositories using the generated log files. 
>>> Under certain circumstances this can take longer then the Windows 
>>> Service Control Manager allows for a service starting up. The thing
>>>       
> to
>   
>>>     
>>>       
>>   
>>     
>>> do in this case is to not run the server as a service and instead run
>>>       
>
>   
>>> it interactively as an application to give the server time to cleanup
>>>       
>
>   
>>> the repository. Once the repository has been cleaned up you can stop 
>>> the server application and restart it as a service. Note: that you 
>>> should not have to do this under normal operating conditions.
>>>
>>> Bruce
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Jason Birch [mailto:Jason.Birch at nanaimo.ca]
>>> *Sent:* November 18, 2006 9:41 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> Good cautionary tale.
>>>
>>> If anyone is not backing up their repositories, they should strongly 
>>> consider it. I haven't seen any problems yet, but the repositories
>>>       
> are
>   
>>>     
>>>       
>>   
>>     
>>> file-based and are subject to corruption in the case of interrupted 
>>> writes, etc.
>>>
>>> There is a RepositoryAdmin directory in the Server installation that 
>>> contains some utilities for doing this, and instructions. You can
>>>       
> find
>   
>>>     
>>>       
>>   
>>     
>>> a copy of the isntructions here:
>>>
>>>
>>>     
>>>       
> https://mapguide.osgeo.org/source/browse/*checkout*/mapguide/trunk/MgDev
>   
>> /Server/RepositoryAdmin/MgOpenSourceRepositoryAdmin.pdf
>>   
>>     
>>> Hmm. It would be nice if we could leverage an RDBMS data store to 
>>> store the repository info. This would kinda break the managed data 
>>> idea, but it would eliminate the load balancing problems around 
>>> session access. I don't really like storing my data with the site 
>>> configuration info anyway :)
>>>
>>> Jason
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Andy Morsell
>>> *Sent:* Sat 2006-11-18 12:14 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* [mapguide-users] Site corrupt - MG Server fails to start
>>>
>>> I have no idea how this happened, but it is rather disconcerting. 
>>> Luckily it was only the Site data that was a problem and that my 
>>> Library seems to be fine. Otherwise I would be reaching into my 
>>> backups to restore from.
>>>
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> Subject:
>>> RE: [mapguide-users] Site corrupt - MG Server fails to start
>>> From:
>>> "Steve Dang" <steve.dang at autodesk.com>
>>> Date:
>>> Mon, 20 Nov 2006 14:12:25 -0800
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>> To:
>>> <users at mapguide.osgeo.org>
>>>
>>>
>>> No, the server automatically runs this cleanup and completes it at 
>>> startup time. If there is a problem, the server will stop and throw
>>>       
> an
>   
>>>     
>>>       
>>   
>>     
>>> exception.
>>>
>>> Steve.
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Brad Nesom [mailto:kidsmake6 at msn.com]
>>> *Sent:* Monday, November 20, 2006 2:47 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> Is there a service or application that could be checked to see if the
>>>       
>
>   
>>> cleanup is still running or completed?
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Bruce Dechant [mailto:bruce.dechant at autodesk.com]
>>> *Sent:* Monday, November 20, 2006 3:08 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> The files might not actually be corrupt, but may have not been closed
>>>       
>
>   
>>> properly (example: due to power outage). When the server starts it 
>>> tries to "clean up" the repositories using the generated log files. 
>>> Under certain circumstances this can take longer then the Windows 
>>> Service Control Manager allows for a service starting up. The thing
>>>       
> to
>   
>>>     
>>>       
>>   
>>     
>>> do in this case is to not run the server as a service and instead run
>>>       
>
>   
>>> it interactively as an application to give the server time to cleanup
>>>       
>
>   
>>> the repository. Once the repository has been cleaned up you can stop 
>>> the server application and restart it as a service. Note: that you 
>>> should not have to do this under normal operating conditions.
>>>
>>> Bruce
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Jason Birch [mailto:Jason.Birch at nanaimo.ca]
>>> *Sent:* November 18, 2006 9:41 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* RE: [mapguide-users] Site corrupt - MG Server fails to
>>>     
>>>       
>> start
>>   
>>     
>>> Good cautionary tale.
>>>
>>> If anyone is not backing up their repositories, they should strongly 
>>> consider it. I haven't seen any problems yet, but the repositories
>>>       
> are
>   
>>>     
>>>       
>>   
>>     
>>> file-based and are subject to corruption in the case of interrupted 
>>> writes, etc.
>>>
>>> There is a RepositoryAdmin directory in the Server installation that 
>>> contains some utilities for doing this, and instructions. You can
>>>       
> find
>   
>>>     
>>>       
>>   
>>     
>>> a copy of the isntructions here:
>>>
>>>
>>>     
>>>       
> https://mapguide.osgeo.org/source/browse/*checkout*/mapguide/trunk/MgDev
>   
>> /Server/RepositoryAdmin/MgOpenSourceRepositoryAdmin.pdf
>>   
>>     
>>> Hmm. It would be nice if we could leverage an RDBMS data store to 
>>> store the repository info. This would kinda break the managed data 
>>> idea, but it would eliminate the load balancing problems around 
>>> session access. I don't really like storing my data with the site 
>>> configuration info anyway :)
>>>
>>> Jason
>>>
>>>
>>>     
>>>       
> ------------------------------------------------------------------------
>   
>>   
>>     
>>> *From:* Andy Morsell
>>> *Sent:* Sat 2006-11-18 12:14 PM
>>> *To:* users at mapguide.osgeo.org
>>> *Subject:* [mapguide-users] Site corrupt - MG Server fails to start
>>>
>>> I have no idea how this happened, but it is rather disconcerting. 
>>> Luckily it was only the Site data that was a problem and that my 
>>> Library seems to be fine. Otherwise I would be reaching into my 
>>> backups to restore from.
>>>
>>>     
>>>       
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>   
>>     
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>   



More information about the mapguide-users mailing list