Announcement

Collapse
No announcement yet.

Database errors out of the blue on 4.2.0

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

  • [Forum] Database errors out of the blue on 4.2.0

    Hello!

    Since yesterday I keep getting database errors out of the blue. I didn't do any upgrade now, nor installed any mod, basically I haven't done any upgrade for more than 2 months.

    I repaired/optimized all tables, but there were no problems.

    I'm using vBulletin 4.2.0

    These are the errors I get, each time it's a different error, then the forum works again and after a few minutes, the error shows again.
    Warning: require_once([path]/includes/class_dm_user.php) [function.require-once]: failed to open stream: Too many open files in system in [path]/includes/functions.php on line 501


    Fatal error: require_once() [function.require]: Failed opening required '/var/www/mysite.com/httpdocs/forums/includes/class_dm_user.php' (include_path='.:') in /var/www/mysite.com/httpdocs/forums/includes/functions.php on line 501
    Another error:
    Warning: require_once([path]/dbtech/spotlight/hooks/cache_templates.php) [function.require-once]: failed to open stream: Too many open files in system in [path]/includes/class_bootstrap.php(1419) : eval()'d code on line 171


    Fatal error: require_once() [function.require]: Failed opening required '/var/www/mysite.com/httpdocs/forums/dbtech/spotlight/hooks/cache_templates.php' (include_path='.:') in /var/www/mysite.com/httpdocs/forums/includes/class_bootstrap.php(1419) : eval()'d code on line 171
    Another one:
    Warning: require_once([path]/includes/class_bootstrap_framework.php) [function.require-once]: failed to open stream: Too many open files in system in [path]/includes/functions.php on line 8223


    Fatal error: require_once() [function.require]: Failed opening required '/var/www/mysite.com/httpdocs/forums/includes/class_bootstrap_framework.php' (include_path='.:') in /var/www/mysite.com/httpdocs/forums/includes/functions.php on line 8223
    Warning: require_once([path]/dbtech/status/hooks/init_startup.php) [function.require-once]: failed to open stream: Too many open files in system in [path]/includes/init.php(336) : eval()'d code on line 3

    Fatal error: require_once() [function.require]: Failed opening required '/var/www/mysite.com/httpdocs/forums/dbtech/status/hooks/init_startup.php' (include_path='.:') in/var/www/mysite.com/httpdocs/forums/includes/init.php(336) : eval()'d code on line 3
    The only unusual thing last days were many spam bots registering even if I use image verification, which was effective for more than half a year.

    What could be that causes these errors?
    Last edited by Ianno; Fri 24 Aug '12, 8:43am.

  • #2
    These are not database errors and come from PHP.

    Has anything changed at this level?
    How's you disk space?
    Are you on a shared hosting plan or on VPS/dedicated server?

    Sent from my iPhone using Forum Runner.

    Comment


    • #3
      After I get those errors, if I refresh the page I sometimes get a Database error, sometimes, after I refresh the error changes in a new one, as I posted above or it just disappears and the forum works well for a few minutes again.
      Click image for larger version

Name:	databaseer.jpg
Views:	1
Size:	47.0 KB
ID:	3689967

      No, I haven't changed absolutely anything, I didn't add anything new, nor updated anything for more than 2 months.

      The disk space is fine, still 30GB free and I'm not on shared hosting. Also the RAM isn't a problem.

      - - - Updated - - -

      It just got worse all of a sudden. I get database error each time when I try to access a users profile or when I try to work in the Admin CP.
      I get this error:
      Database error in vBulletin 4.2.0:


      Invalid SQL:
      SELECT block.*,
      blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
      blocktype.description as blocktypedescription, blocktype.allowcache
      FROM block AS block
      LEFT JOIN blocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
      WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','credits','dsl','pointmarket','post_thanks','forcewww','marco1_hide','dbtech_ status','v3arcade','_vboptimise_dbtech','vbtube','')
      ORDER BY block.displayorder, block.title;


      MySQL Error : Can't create/write to file '/tmp/#sql_213_0.MYD' (Errcode: 17)
      Error Number : 1
      Request Date : Friday, August 24th 2012 @ 11:52:10 AM
      Error Date : Friday, August 24th 2012 @ 11:52:11 AM
      Script : http://www.mysite.com/forums/admincp/plugin.php?do=productdisable&productid=dbtech_spotlight&s=
      Referrer : http://www.mysite.com/forums/admincp/plugin.php?do=product
      IP Address : y
      Username : X
      Classname : vB_Database
      MySQL Version : 5.0.51a-24+lenny5
      I don't know why it's getting even worse when I didn't do anything. Is my site hacked or something?

      - - - Updated - - -

      I disabled all modifications from config.php (but the strange this is that even if in Manage Plugins it says Plugins are currently globally disabled via config.php., some of them are still working on the forum) and it's still the same, actually even worse, now I can't even access the Inbox or users profiles
      Last edited by Ianno; Fri 24 Aug '12, 8:49am.

      Comment


      • #4
        Are you using persistent database connections? If so, try turning that off, or get your tech support people to do it for you.
        Psychlinks Web Services Affordable Web Design & Site Management
        Specializing in Small Businesses and vBulletin/Xenforo Forums

        Comment


        • #5
          In case someone else will have this problem, I managed to fix it. It was from the permissions of the tmp file system on the server.

          Thanks to all who replied and tried to help!

          Comment


          • #6
            Originally posted by Ianno View Post
            In case someone else will have this problem, I managed to fix it. It was from the permissions of the tmp file system on the server.

            Thanks to all who replied and tried to help!
            Can you elaborate on this please? Exact same thing is happening to me.

            EDIT: Actually I just went to admincp > Maintenance and ran diagnostics - found that a postparsed table was corrupted (it said in the comments), then I repaired the table (unchecked optimize and closed the forum) and it worked.
            Last edited by ncaross; Sun 7 Oct '12, 10:37pm. Reason: Found answer

            Comment

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