Log InRegister
Quick Links : The Mindat ManualThe Rock H. Currier Digital LibraryMindat Newsletter [Free Download]
Home PageAbout MindatThe Mindat ManualHistory of MindatCopyright StatusWho We AreContact UsAdvertise on Mindat
Donate to MindatCorporate SponsorshipSponsor a PageSponsored PagesMindat AdvertisersAdvertise on Mindat
Learning CenterWhat is a mineral?The most common minerals on earthInformation for EducatorsMindat ArticlesThe ElementsThe Rock H. Currier Digital LibraryGeologic Time
Minerals by PropertiesMinerals by ChemistryAdvanced Locality SearchRandom MineralRandom LocalitySearch by minIDLocalities Near MeSearch ArticlesSearch GlossaryMore Search Options
Search For:
Mineral Name:
Locality Name:
Keyword(s):
 
The Mindat ManualAdd a New PhotoRate PhotosLocality Edit ReportCoordinate Completion ReportAdd Glossary Item
Mining CompaniesStatisticsUsersMineral MuseumsClubs & OrganizationsMineral Shows & EventsThe Mindat DirectoryDevice SettingsThe Mineral Quiz
Photo SearchPhoto GalleriesSearch by ColorNew Photos TodayNew Photos YesterdayMembers' Photo GalleriesPast Photo of the Day GalleryPhotography

Improving Mindat.orgAccess to locality pages

12th Sep 2017 18:04 UTCLarry Maltby Expert

Over the last couple days I have been having trouble pulling up locality pages when I am logged in. When I select a locality page nothing happens and I cannot move to any other pages. I must close Mindat and reopen. If I am not logged everything works fine. I hope someone can help.


Larry,

12th Sep 2017 19:36 UTCPaul Brandes 🌟 Manager

Larry,


I just ran through a bunch of different pages at 1:34 pm CDT and had no issues.

I am logged in (obviously) as well, so perhaps something on your end is buggered up??


Paul

13th Sep 2017 09:40 UTCDavid Von Bargen Manager

The server has been overloaded recently. I suspect that it has to do with the database engine getting bogged down doing some queries.

13th Sep 2017 13:06 UTCPaul Brandes 🌟 Manager

David Von Bargen Wrote:

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

> The server has been overloaded recently.


One of the pitfalls of operating such a successful website, I suppose... ;-)

13th Sep 2017 13:17 UTCVolker Betz 🌟 Expert

I observed this error message:


Fatal error: Call to a member function fetch_object() on a non-object in /home/mindat/www/loc.php on line 107


after a few minutes of waiting


Volker

13th Sep 2017 13:33 UTCLarry Maltby Expert

Everything is working again. I am a very happy guy!


Thanks for the help, Larry,

13th Sep 2017 16:15 UTCLarry Maltby Expert

Ouch, the problem is back.


Larry,

13th Sep 2017 18:50 UTCLarry Maltby Expert

Everything is now working again. This confirms Dave's point that It only happens during times of peak usage.

I have also found that I can work around it by uploading photos manually by pasting in the location in the space provided and doing the location check. Just a little more work.

14th Sep 2017 14:16 UTCRolf Luetcke Expert

I had those same problems yesterday and assumed it was the peak usage issue and seems that is the case.

With such a huge site as mindat now is, we are surprised it works as well as it does.

I had those "fatal error" issues a while back also but not recently.

Yesterday it was as Larry had said and I just waited and later it worked again, out again, worked again.

One has to work around those things and carry on.

All in all, things do work fairly well.

19th Sep 2017 13:50 UTCRolf Luetcke Expert

Had those same problem yesterday and today also.

Things seem to hang up and go nowhere and I finally found a way around this.

When I am not logged in things seem to go fine but logged in it won't go to locality pages, just hangs up.

I found that if I go to my page to add a photo and use my personal add photo it goes smoothly but if I try to go to the location it won't go there.

Fortunately I found a different way that seems to work normally.

Hope that this can be fixed since it is boring to sit and twiddle my thumbs waiting for a page to open and then nothing happens.

If anyone else is having this same problem, to add photos, try using your personal page to add photos.

Funny things do happen but when I thought it was due to heavy use I tried it again very early this morning and same thing so it is probably not that.

19th Sep 2017 14:23 UTCLarry Maltby Expert

Rolf,


I am still having the same problem; two hours ago I could not get into the locality pages while logged in. I just tried again and got right in.


Larry,

19th Sep 2017 16:08 UTCUwe Kolitsch Manager

There are still daily periods when the server is inaccessible.

19th Sep 2017 21:44 UTCRalph S Bottrill 🌟 Manager

Having the same problem again today, mostly when logged in.

20th Sep 2017 11:06 UTCJerry Cone 🌟 Expert

Rolf, thanks for the work-around. It seems strange to me that if the server is bogged down anything should work, but your method does.

20th Sep 2017 13:32 UTCLarry Maltby Expert

I just noticed that the start of this problem correlates very closely with the start of the live posting of the Denver Show Report. My first post above was on Sept 12 and the live posting of the show report started about Sept 10. I wonder if the WIFI at some Denver hotel was hacked while up loading the report.

20th Sep 2017 14:22 UTCDavid Von Bargen Manager

No, it's just some queries that are running for the new non-hierarchial localities that are taking a lot of time and locking the locality table and causing other programs that want to access it have to wait. It started when a couple of very large localities like this were added on the 8th .

20th Sep 2017 14:48 UTCUwe Kolitsch Manager

Is it possible to restrict such queries to not occupy more than, let's say, 5% of the bandwith?

20th Sep 2017 15:00 UTCJolyon Ralph Founder

I don't know of any way to do this.

21st Sep 2017 01:49 UTCDavid Von Bargen Manager

Its not a bandwidth problem, when the tables are locked by a query, no other query can use them, so they wait until the table is unlocked. This builds up a queue that will eventually use up connections to the database.

21st Sep 2017 15:19 UTCUwe Kolitsch Manager

I see - thanks David.
 
Mineral and/or Locality  
Mindat Discussions Facebook Logo Instagram Logo Discord Logo
Mindat.org is an outreach project of the Hudson Institute of Mineralogy, a 501(c)(3) not-for-profit organization.
Copyright © mindat.org and the Hudson Institute of Mineralogy 1993-2024, except where stated. Most political location boundaries are © OpenStreetMap contributors. Mindat.org relies on the contributions of thousands of members and supporters. Founded in 2000 by Jolyon Ralph.
Privacy Policy - Terms & Conditions - Contact Us / DMCA issues - Report a bug/vulnerability Current server date and time: April 23, 2024 13:23:00
Go to top of page