491248 - MDC is almost completely borken

Status: RESOLVED DUPLICATE of bug 491324

(mozilla.org Graveyard :: Server Operations, task)

Description

[Jeff Walden [:Waldo]]

Page content doesn't load, yellow error bar splashed across pages saying 500 Error, details expansion widget shows the following:

Request URI:
http://localhost:8081/deki/pages/24287/contents?dream.out.format=php&dream.in.host=developer.mozilla.org&dream.in.scheme=https&dream.in.origin=10.2.81.4&mode=view

Server response:
Array
(
    [exception] => Array
        (
            [message] => Could not find specified column in results
            [source] => MySql.Data
            [stacktrace] => Array
                (
                    [frame] => Array
                        (
                            [0] => MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal (System.String name) [0x00000]
                            [1] => MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000]
                            [2] => MindTouch.Deki.Title.FromDataReader (IDataReader dr, System.String nsFieldName, System.String titleFieldName, System.String displayFieldName, System.String filenameFieldName) [0x00000]
                            [3] => MindTouch.Deki.Title.FromDataReader (IDataReader dr, System.String nsFieldName, System.String titleFieldName, System.String displayFieldName) [0x00000]
                            [4] => MindTouch.Deki.DataAccess.LinksDA+<>c__DisplayClass4.<GetBrokenAndFromLinks>b__3 (IDataReader dr) [0x00000]
                            [5] => MindTouch.Data.DataCommand.Execute (System.Action`1 handler) [0x00000]
                        )

                )

            [type] => System.IndexOutOfRangeException
        )

)

I did get partial content for a page once, but a reload resulted in no content again, and thereafter as well.  The error message (why in the world are we publicly displaying error messages?) seems to suggest the failure isn't a got-unlucky thing, so not sure why I did get something that once.

Comment 1

[Benjamin Smedberg]

https://developer.mozilla.org/index.php?title=Special:Userlogin&returntotitle=Special%3AUserlogin seems to indicate that there are authentication problems.

Comment 2

[Eric Shepherd [:sheppy]]

Looks like the database might be munched.

Comment 3

[Samuel Sidler (old account; do not CC)]

This appears to be better now.

Comment 4

[Ian Neal]

Still does not seem to be working for me :(

Comment 5

[Eric Shepherd [:sheppy]]

There is mounting evidence that this is being caused by bug 491324. The database is timing out repeatedly due to these queries, causing bizarre problems in Deki. The Mindtouch guys are dismayed by how badly their code is handling these problems, and are looking into ways to resolve that, although it won't make the site work any better and won't likely happen right away either.

Comment 6

[Eric Shepherd [:sheppy]]

This is indeed being caused by 491324. Marking this as a duplicate of that one.