DearDiary Logo
Public DiariesHomeLogin

Database Errors
Fri Nov 16 2001

Some of you have noticed, and alerted us, of occasional error screens when trying to access the site. I have caught a couple of these in mid-session so to speak and believe it is being caused by a database lock. What appears to be happening is that MySQL is generally pretty clever about how it accesses the database tables, and it doesn't apply a lock to the tables UNLESS it gets an insert or update command. If it receives an insert or update, it applies a lock to the table and any SUBSEQUENT requests are blocked until the update is complete. What appears to be happening is that an update is placed into the queue, and for some reason sometimes the system is taking a long time to send data to a client, resulting in an update request coming in and locking everything up until the first, and hanging, connection is cleared.

I've applied a quick change that may help fix it, but until I can bottom out why some connections are taking a huge time to receive their data, I can't be too sure its fixed... I'll keep you posted.

Steve.

3 Comments
  • From:
    Salamander (Legacy)
    On:
    Fri Nov 16 2001
    Does this tie into Jade's problem where here DD address doesn't seem to be functional?
  • From:
    Jade (Legacy)
    On:
    Sat Nov 17 2001
    But what about the email problem I've been having??? Matt tried to fix it but it's still not working. Whenever someone sends an email to [email protected] I don't receive it. I would like to see it fixed if possible... Many people have said they've sent me emails to that address and I never received any of them.
  • From:
    Sparkler (Legacy)
    On:
    Mon Nov 19 2001
    YAY! I thought I lost some readers. Im sure they were 2 of the emails that were bouncing since one was an old email addy of a friend on my list who signed up the new name.

    Need to tell Darren that, we were all whining people didnt love us any longer. :)~

    By the way, I wrote u guys an email to make my diary entries private. :::Anxiously awaiting::: So my diary is totally private from everyone till this is done. Hurrryyy :)