Yii Framework Forum: Integrity Constraint Violation Db Schema Cache - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Integrity Constraint Violation Db Schema Cache Rate Topic: -----

#1 User is offline   egor 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 7
  • Joined: 09-March 11
  • Location:TomskSoft

Posted 23 November 2012 - 04:54 AM

Привет,

Использую кеширование схемы БД (и не только), вот мой /config/main.php:

'cache' => array(
    'class' => 'system.caching.CDbCache',
    'cacheTableName' => 'cache',
    'connectionID' => 'db',
    //'autoCreateCacheTable' => true,
),
'db' => array(
    'connectionString' => 'mysql:host=***;dbname=***',
    'username' => '****',
    'password' => '***',
    'charset' => 'utf8',
    'schemaCachingDuration' => 3600,
    'enableParamLogging' => true,
    'enableProfiling' => true,
    'emulatePrepare' => true,
),


Иногда (раз в месяц) на продакшне возникает ошибка:

Spoiler


Таблица cache:

CREATE TABLE `cache` (
	`id` CHAR(128) NOT NULL,
	`expire` INT(11) NULL DEFAULT NULL,
	`value` LONGBLOB NULL,
	PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM;


PHP 5.3.18, yii 1.1.12, MySQL 5.0.77

Подскажите, в чем причина ошибки.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users