Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-810

Process critical database errors even when debug mode is off

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.2-B1
    • Fix Version/s: 5.1.2-RC1
    • Component/s: Database
    • Labels:
      None

      Description

      If any error will happen during database query execution, then:

      • in debug mode: fatal error will be raised and script execution stops
      • in non-debug mode: warning is raised and script continues to execute

      It works pretty well actually, since (as we thought before) no MySQL error could be important enough to stop script execution for regular users (not developers).

      We was wrong actually, since these errors require reconnecting to MySQL server to fix them:

      • #2006 - MySQL server has gone away
      • #2013 - Lost connection to MySQL server during query

      In case on of these errors will happen during database query execution, then we should:
      1. disconnect and connect to MySQL again
      2. try to run database query that raised an error
      3. do 3 retries and if we still got an error, then

      • act the same as before
        OR
      • die?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: