Wow, guys, I don't know what did you do, but the pages now are loading
extremely fast. action=purge, editing, it doesn't matter, the load is
inmediate.

Maybe the fact that the last 3 weeks the pages took eternities to load
increases the feeling of speed, but they're really fast.

Many thanks for working on it. I hope the bug doesn't come again.

Greetings!


2008/1/5, Jesús Martínez wrote:
> Today, loading concurrently this tho pages:
> <http://es.pokemon.wikia.com/index.php?title=Ho-Oh&action=edit> and
> <http://es.pokemon.wikia.com/index.php?title=Ho-Oh&action=edit&oldid=18425>,
> the latter one gave me a "MediaWiki White screen of death" saying a
> database error occurred, (hidden SQL) inside the function
> "Database::replace". The error reported was "1205: Lock wait timeout
> exceeded; try restarting transaction (216.151.156.9)".
>
> The pages are the ones which tooks an eternity to load.
>
> Also, I noticed that sometimes, when is loading a page that takes a
> long time to load, and simultaneously I try to load other pages like
> Special:Recentchanges or others which are normally fast to load, all
> pages say "loading" a long time until one of them gets loaded, and
> then the others start to render. Maybe there's a concurrency problem.
>
> Any idea of when the problem will get solved?
>
> I installed exactly the current version of the wiki from SVN (svn
> checkout -r 26409 http://svn.wikimedia...) in my computer, downloaded
> the last database dump (pages_current) of the es.pokemon wiki,
> imported the dump with the import script, and imported those small
> images of the page with the importimages script, and the pages that
> here takes very long to load, for me loaded acceptably fast. Wikia is
> supposed to have fast dedicated servers so here the load would be
> really faster. Maybe the problem is one of the extensions, or the
> internal database architecture of wikia, but not MediaWiki itself.
>
> Maybe recreating the wiki in a similar web server with the same
> extensions, and then disabling each of the extensions could be a
> starting point to look into it.
>
> Hope it helps to find the problem.
>
> 2007/12/31, Artur Bergman wrote:
> > No, I don't think so.
> >
> > I was seeing it happening, and then suddenly -- without any changes
> > -- it jumped down to 0.4 seconds and I couldn't reproduce.
> >
> > Still digging into it.
> >
> > Artur
> >
> > On Dec 31, 2007, at 10:45 AM, Jesús Martínez wrote:
> >
> > > On MW 1.10 all pages loaded very fast. The problem appeared on MW1.12.
> > > Maybe the most recent version of MW1.12 solved the problem?
> > >
> > > 2007/12/30, Artur Bergman <[EMAIL PROTECTED]>:
> > >> Hi,
> > >>
> > >> I am trying to debug this problem, thanks for the data.
> > >>
> > >> What I cannot figure out why this is loading so slow on the first
> > >> page, and then really fast. IMS still requires a rework of the
> > >> backend page.
> > >>
> > >> Did this at all happen with MW1.10?
> > >>
> > >> Artur
> > >>
> > >>
> > >> On Dec 30, 2007, at 8:50 PM, Jesús Martínez wrote:
> > >>
> > >>> At least on WikiDex <http://es.pokemon.wikia.com/> we're having
> > >>> problems now for some pages.
> > >>>
> > >>> For example, I try to open the page
> > >>> <http://es.pokemon.wikia.com/wiki/Farfetch%27d> on Internet
> > >>> Explorer,
> > >>> where I'm not logged in, and record all the process with a packet
> > >>> sniffer.
> > >>>
> > >>> This is what I got:
> > >>> <http://img252.imageshack.us/my.php?
> > >>> image=etherealscreenshotwikiamp5.png>
> > >>> It tooks 319 seconds to give a response. It's definitively not
> > >>> acceptable. Ignore the packets 6 to 9 because is the result to
> > >>> hit the
> > >>> "stop" button in firefox.
> > >>>
> > >>> Then, I reloaded the same page on IE and it loaded really fast,
> > >>> with a
> > >>> 304 (Not Modified) response. Then i did the same with Firefox, where
> > >>> I'm logged in.
> > >>>
> > >>> This is the result.
> > >>> <http://img252.imageshack.us/my.php?
> > >>> image=etherealscreenshotwikiamh5.png>.
> > >>> 375 seconds!!. Now, a next load in firefox tooks really few to load
> > >>>
> > >>> I had the same problem with
> > >>> <http://es.pokemon.wikia.com/wiki/Usuario:Ciencia_Al_Poder/Altillo/
> > >>> Problema_con_im%C3%A1genes>,
> > >>> where I bugged the links to images so the images aren't displayed,
> > >>> just to test if the problem were the images, but it took 137 seconds
> > >>> to load. <http://img167.imageshack.us/my.php?
> > >>> image=etherealscreenshotwikiaxh5.png>
> > >>>
> > >>> Please, fix this ASAP, or rollback to MW1.10.
> > >>>
> > >>> It's really frustrating to our new (and not so new) visitors.
> > >>>
> > >>>
> > >>> 2007/12/26, Artur Bergman wrote:
> > >>>> Hi,
> > >>>>
> > >>>> Some people are experiencing a ~45 second delay the first time you
> > >>>> access a wiki. (It just says loading.) I am trying to figure out
> > >>>> why
> > >>>> and I am trying to collect data. If anyone is experiencing this,
> > >>>> can
> > >>>> you please post what browsers you are on, and any detail you might
> > >>>> think is relevant.
> > >>>>
> > >>>> Thanks
> > >>>> Artur
> > >>>> _______________________________________________
> > >>>> Wikia-l mailing list
> > >>>> [email protected]
> > >>>> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>>>
> > >>> _______________________________________________
> > >>> Wikia-l mailing list
> > >>> [email protected]
> > >>> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>
> > >> _______________________________________________
> > >> Wikia-l mailing list
> > >> [email protected]
> > >> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>
> > > _______________________________________________
> > > Wikia-l mailing list
> > > [email protected]
> > > http://lists.wikia.com/mailman/listinfo/wikia-l
> >
> > _______________________________________________
> > Wikia-l mailing list
> > [email protected]
> > http://lists.wikia.com/mailman/listinfo/wikia-l
> >
>
_______________________________________________
Wikia-l mailing list
[email protected]
http://lists.wikia.com/mailman/listinfo/wikia-l

Reply via email to