Поставил на сервак mariadb 10.5.8, все хорошо, но время от времени вылетает ошибка 150 Foreign key constraint is incorrectly formed
Причем даже на чистом битриксе, сейчас вот словил
<br><font color=#ff0000>MySQL Query Error: cre ate table `site_checker_b_iblock`
(
ID int(11) not null auto_increment,
TIMESTAMP_X timestamp not null default current_timestamp on update current_timestamp,
IBLOCK_TYPE_ID varchar(50) not null REFERENCES b_iblock_type(ID),
LID char(2) not null REFERENCES b_lang(LID),
CODE varchar(50) null,
API_CODE varchar(50) null,
REST_ON char(1) not null default 'N',
NAME varchar(255) not null,
ACTIVE char(1) not null DEFAULT 'Y',
SORT int(11) not null DEFAULT 500,
LIST_PAGE_URL varchar(255) null,
DETAIL_PAGE_URL varchar(255) null,
SECTION_PAGE_URL varchar(255) null,
CANONICAL_PAGE_URL varchar(255) null,
PICTURE int(18) null,
DESCRIPTION text null,
DESCRIPTION_TYPE char(4) not null DEFAULT 'text',
RSS_TTL int(11) not null default '24',
RSS_ACTIVE char(1) not null default 'Y',
RSS_FILE_ACTIVE char(1) not null default 'N',
RSS_FILE_LIMIT int null,
RSS_FILE_DAYS int null,
RSS_YANDEX_ACTIVE char(1) not null default 'N',
XML_ID varchar(255) null,
TMP_ID varchar(40) null,
INDEX_ELEMENT char(1) not null default 'Y',
INDEX_SECTION char(1) not null default 'N',
WORKFLOW char(1) not null default 'Y',
BIZPROC char(1) not null default 'N',
SECTION_CHOOSER char(1) null,
LIST_MODE char(1) null,
RIGHTS_MODE char(1) null,
SECTION_PROPERTY char(1) null,
PROPERTY_INDEX char(1) null,
VERSION int not null default 1,
LAST_CONV_ELEMENT int(11) not null default 0,
SOCNET_GROUP_ID int(18) NULL,
EDIT_FILE_BEFORE varchar(255) null,
EDIT_FILE_AFTER varchar(255) null,
SECTIONS_NAME varchar(100) null,
SECTION_NAME varchar(100) null,
ELEMENTS_NAME varchar(100) null,
ELEMENT_NAME varchar(100) null,
PRIMARY KEY(ID),
INDEX ix_iblock (IBLOCK_TYPE_ID, LID, ACTIVE),
UNIQUE INDEX ix_iblock_api_code (API_CODE)
)</font>[[1005] Can't cre ate table `ogonek2`.`site_checker_b_iblock` (errno: 150 "Foreign key constraint is incorrectly formed")]<br>MySQL Query Error!
Есть предположение что из-за какой то настройки. Никто не сталкивался?
Причем даже на чистом битриксе, сейчас вот словил
<br><font color=#ff0000>MySQL Query Error: cre ate table `site_checker_b_iblock`
(
ID int(11) not null auto_increment,
TIMESTAMP_X timestamp not null default current_timestamp on update current_timestamp,
IBLOCK_TYPE_ID varchar(50) not null REFERENCES b_iblock_type(ID),
LID char(2) not null REFERENCES b_lang(LID),
CODE varchar(50) null,
API_CODE varchar(50) null,
REST_ON char(1) not null default 'N',
NAME varchar(255) not null,
ACTIVE char(1) not null DEFAULT 'Y',
SORT int(11) not null DEFAULT 500,
LIST_PAGE_URL varchar(255) null,
DETAIL_PAGE_URL varchar(255) null,
SECTION_PAGE_URL varchar(255) null,
CANONICAL_PAGE_URL varchar(255) null,
PICTURE int(18) null,
DESCRIPTION text null,
DESCRIPTION_TYPE char(4) not null DEFAULT 'text',
RSS_TTL int(11) not null default '24',
RSS_ACTIVE char(1) not null default 'Y',
RSS_FILE_ACTIVE char(1) not null default 'N',
RSS_FILE_LIMIT int null,
RSS_FILE_DAYS int null,
RSS_YANDEX_ACTIVE char(1) not null default 'N',
XML_ID varchar(255) null,
TMP_ID varchar(40) null,
INDEX_ELEMENT char(1) not null default 'Y',
INDEX_SECTION char(1) not null default 'N',
WORKFLOW char(1) not null default 'Y',
BIZPROC char(1) not null default 'N',
SECTION_CHOOSER char(1) null,
LIST_MODE char(1) null,
RIGHTS_MODE char(1) null,
SECTION_PROPERTY char(1) null,
PROPERTY_INDEX char(1) null,
VERSION int not null default 1,
LAST_CONV_ELEMENT int(11) not null default 0,
SOCNET_GROUP_ID int(18) NULL,
EDIT_FILE_BEFORE varchar(255) null,
EDIT_FILE_AFTER varchar(255) null,
SECTIONS_NAME varchar(100) null,
SECTION_NAME varchar(100) null,
ELEMENTS_NAME varchar(100) null,
ELEMENT_NAME varchar(100) null,
PRIMARY KEY(ID),
INDEX ix_iblock (IBLOCK_TYPE_ID, LID, ACTIVE),
UNIQUE INDEX ix_iblock_api_code (API_CODE)
)</font>[[1005] Can't cre ate table `ogonek2`.`site_checker_b_iblock` (errno: 150 "Foreign key constraint is incorrectly formed")]<br>MySQL Query Error!
Есть предположение что из-за какой то настройки. Никто не сталкивался?