Hello,

When expires happen, sometimes Cache causes:

user warning: Table 'd6.site_1252959365' doesn't exist query: DELETE FROM site_1252959365 WHERE expire != 0 AND expire < 1252963004 in /sites/all/modules/cache/engines /database.inc on line 69

Sometimes watchdog says "line 280" also.

"$this" seems to be confused somehow.

Just reporting.

Tx.

D6.13
PHP 5.2.10
MySQL (5.1.36)
Centos 5.3

Comments

jannalexx’s picture

Title: database.inc complains with $this » database.inc table with random number name doesn't exist query

same here!

* user warning: Table 'xyz.xyz_1252994772' doesn't exist query: DELETE FROM xyz_1252994772 WHERE expire != 0 AND expire < 1252999189 in /home/.../sites/all/modules/cache/engines/database.inc on line 69.

xyz.xyz_1252994772 (random number)
using...

/** CACHE ALTERNATIVE work??? */
    $conf['cache_inc'] = './sites/all/modules/cache/cache.inc';
    $conf['session_inc'] = './sites/all/modules/cache/session.inc';
    $conf['cache_settings'] = array(
      'engines' => array(
        'db' => array(
          'engine' => 'database',
          'server' => array(),
          'shared' => TRUE,
          'prefix' => '',
        ),
        'xc' => array(
          'engine' => 'xcache',
          'server' => array(),
          'shared' => TRUE,
          'prefix' => '',
        ),
      ),
	  
      'schemas' => array(
        'db' => array(
          // Engines:
          'db',
        ),
        'xc' => array(
          // Engines:
          'xc',
        ),
      ),

      'bins' => array(
        // Bin name     => Schema name.
        'default'       => 'db',
        'cache'         => 'xc',
        'cache_form'    => 'xc',
        'cache_page'    => 'xc',
        'cache_filter'  => 'xc',
      ),
    );

doq’s picture

Status: Active » Needs review

In cache/cache.inc please try to change line ~55 from

    $this->flush($cache_flush);

to

    $this->flush($table);
chawl’s picture

Title: database.inc table with random number name doesn't exist query » database.inc complains with $this
Status: Needs review » Active

Yes, error disappeared now.

Plus, I have wondered why caches look to be quite static and monotonously growing before. Now they look naturally dynamic that garbage collection seems to be fixed also.

Thank you.

chawl’s picture

Title: database.inc complains with $this » database.inc table with random number name doesn't exist query
Status: Active » Reviewed & tested by the community

Oops, sorry.

jannalexx’s picture

error disappeared also here

doq’s picture

Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.