0
Welcome Guest! Login
0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

Unpredictable MySQL Database Errors

Last Post
Search Topic

  • Unpredictable MySQL Database Errors

    Posted 16 years 6 months ago
    • I have two sites that are beginning to go down at least twice a day with Database/MySQL errors. One site is www.eilmccc.org/cmsccc2 (in development). The other site at www.increasecdc.org which is a live site and thereby not good.


      >>> My host is BlueHost.
      >>> The sites are using different templates installed via RocketLaunch.
      >>> One site is located under the primary domain; one under an add-on domain.
      >>> The sites are using different MySQL databases.
      >>> The installs went perfectly (so I thought) and I have been working customizing the templates.
      >>> When one site goes down, the other does also.
      >>> The last two crashes, I was not working in them; they were simply being displayed as tabs in my browser.
      >>> Sometimes, within about 45 mintues, they may come back up; however, normally, I repair the jos_session table on one DB and BOTH sites work again!

      The first error a few days ago was:
      jtablesession::Store Failed
      DB function failed with error number 145
      Table './eilmccco_cmsicdc/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ca7331cb8a008d79e24df425257229ea','1227636484','','0','1','0' )
      >>>> I repaired the table and the sites worked for about 1.5 days.

      Second error a couple of days later:
      Error 1062: Duplicate Entry …
      >>>> I repaired the jos_session table again and the sites worked for almost 24 hours.

      Third error a few hours ago:
      Database Error: Unable to connect to the database: Could not connect to MySQL.
      >>>> Again, I repaired the jos_session table about two hours prior to this posting. Currently, they are still up.

      Can someone please enlighten me? It is not acceptable to keep repairing the table and, of course, I can have no idea when it might happen and one of the sites is live, so this is not good.

      Thanks much, Josepha
    • “You were born to win, but to be a winner, you must plan to win, prepare to win, and expect to win.” - Zig Ziglar
    #249599

Time to create page: 0.072 seconds