Announcement

Collapse
No announcement yet.

A Whole Slew of Errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • A Whole Slew of Errors

    About two days ago our entire db went down. Not mysql issues or vb there was a root runaway process which they killed which stopped the slew of vb database errors we were getting. We thought whew!

    Tonight starting about 7pm CST till about 9pm CST we have been getting multiple errors. I checked the server we seem to be ok there for moment.

    Here is our top

    last pid: 87433; load averages: 2.43, 2.43, 2.41 up 5+06:49:21 02:21:22
    46 processes: 2 running, 44 sleeping
    CPU states: 46.4% user, 0.0% nice, 11.0% system, 0.4% interrupt, 42.2% idle
    Mem: 513M Active, 243M Inact, 163M Wired, 39M Cache, 112M Buf, 47M Free
    Swap: 1024M Total, 80M Used, 944M Free, 7% Inuse


    Here are some of the errors we are seeing.

    Database error in vBulletin :

    cannot use database forums
    mysql error: Lost connection to MySQL server during query

    _________________

    Invalid SQL: UPDATE session SET lastactivity=1034813144,location='/portal/forums/showthread.php?s=&postid=6036' WHERE sessionhash='b88dfb201b3cf585c3824c36a1504d78'
    mysql error: File '/usr/local/mysql-3.23.52/var/forums/session.MYD' not found (Errcode: 24)

    mysql error number: 1105


    ___________________________-

    Invalid SQL:
    SELECT
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    WHERE post.postid IN (0,171,173,214,255,964,992,993,995,1048,1049,1088,1134,1173,1201,2854,2944,3098,3104,3108, 3147,3158,3197,3413,3880,4118,4365,4474,4503,4519,4729,4865,4969,5022,5947,5963,5987,6036)
    ORDER BY dateline

    mysql error: Can't find file: './forums/userfield.frm' (errno: 24)

    mysql error number: 1017

    ________________________-

    The first one I get we are losing the connection to the db however mysql uptime is

    Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL license

    Server version 3.23.52
    Protocol version 10
    Connection Localhost via UNIX socket
    UNIX socket /tmp/mysql.sock
    Uptime: 23 hours 41 min 0 sec

    Threads: 33 Questions: 900034 Slow queries: 1889 Opens: 6981 Flush tables: 1
    Open tables: 64 Queries per second avg: 10.556

    Any help would be greatly appreciated.

    Chris

  • #2
    Error code 24: Too many open files

    I believe you'll need to either restart MySQl or increase the number of open files it allows.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Would that be in the my.cnf file?

      Currently I have this

      [safe_mysqld]
      open_files_limit=8192

      Comment


      • #4
        I think so but I'd wait for the real MySQl expert. (Paging eva2000!)
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X