Skip to content Skip to sidebar Skip to footer

Office Source Engine Failed to Read Description

 Failed to read automobile-increment value from storage engine  [new]
sknzv
Fellow member

������:
���������: 4

������ ����!
���� �� 1�-�������.
������� ������:
File: /dwelling/bitrix/www/bitrix/modules/statistic/classes/general/ke�epstatistic.php
Line: 444
MySQL Query Error: INS ERT INTO b_stat_session(`GUEST_ID`, `NEW_GUEST`, `USER_ID`, `USER_AUTH`, `URL_FROM`, `URL_TO`, `URL_TO_404`, `URL_LAST`, `URL_LAST_404`, `USER_AGENT`, `DATE_STAT`, `DATE_FIRST`, `DATE_LAST`, `IP_FIRST`, `IP_FIRST_NUMBER`, `IP_LAST`, `IP_LAST_NUMBER`, `PHPSESSID`, `STOP_LIST_ID`, `COUNTRY_ID`, `CITY_ID`, `ADV_BACK`, `FIRST_SITE_ID`, `LAST_SITE_ID`, `HITS`) VALUES (600029, 'N', 0, 'Northward', '', 'http://site.kz:eighty/', 'Due north', 'http://site.kz:80/', 'Northward', 'Mozilla/v.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.125 Safari/537.36', CURRENT_DATE, now(), now(), '37.99.116.126', '627274878', '37.99.116.126', '627274878', '2sdld6nseca4sii5f3akkfkol5', '0', 'KZ', 2, nil, 's1', 's1', ane)[Failed to read motorcar-increment val ue from storage engine]
DB query mistake.
Please try later.

��� ��������� ������?

xxx ��� xv, 14:49����[17955385]     �������� | ���������� �������� ����������
 Re: Failed to read auto-increment value from storage engine  [new]
sknzv
Member

������:
���������: iv

Shahriyar.R,

mysql> show create table b_stat_session;
+----------------+-------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----+
| Table | Create Table |
+----------------+-------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----+
| b_stat_session | CREATE Tabular array `b_stat_session` (
`ID` int(18) Non NULL AUTO_INCREMENT,
`GUEST_ID` int(18) DEFAULT Cipher,
`NEW_GUEST` char(i) COLLATE utf8_unicode_ci NOT Zilch DEFAULT 'North',
`USER_ID` int(xviii) DEFAULT Aught,
`USER_AUTH` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`C_EVENTS` int(18) Non Zilch DEFAULT '0',
`HITS` int(eighteen) Non NULL DEFAULT '0',
`FAVORITES` char(1) COLLATE utf8_unicode_ci Non Nil DEFAULT 'N',
`URL_FROM` text COLLATE utf8_unicode_ci,
`URL_TO` text COLLATE utf8_unicode_ci,
`URL_TO_404` char(1) COLLATE utf8_unicode_ci NOT Cypher DEFAULT 'N',
`URL_LAST` text COLLATE utf8_unicode_ci,
`URL_LAST_404` char(1) COLLATE utf8_unicode_ci Non NULL DEFAULT 'North',
`USER_AGENT` text COLLATE utf8_unicode_ci,
`DATE_STAT` date DEFAULT Nix,
`DATE_FIRST` datetime DEFAULT NULL,
`DATE_LAST` datetime DEFAULT NULL,
`IP_FIRST` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`IP_FIRST_NUMBER` bigint(20) DEFAULT Cipher,
`IP_LAST` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`IP_LAST_NUMBER` bigint(20) DEFAULT Aught,
`FIRST_HIT_ID` int(xviii) DEFAULT NULL,
`LAST_HIT_ID` int(18) DEFAULT NULL,
`PHPSESSID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ADV_ID` int(eighteen) DEFAULT NULL,
`ADV_BACK` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`REFERER1` varchar(255) COLLATE utf8_unicode_ci DEFAULT Nil,
`REFERER2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`REFERER3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`STOP_LIST_ID` int(18) DEFAULT NULL,
`COUNTRY_ID` char(two) COLLATE utf8_unicode_ci DEFAULT NULL,
`CITY_ID` int(18) DEFAULT NULL,
`FIRST_SITE_ID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`LAST_SITE_ID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
Master KEY (`ID`),
KEY `IX_IP_FIRST_NUMBER_DATE_STAT` (`IP_FIRST_NUMBER`,`DATE_STAT`),
KEY `IX_B_STAT_SESSION_4` (`USER_ID`,`DATE_STAT`),
KEY `IX_DATE_STAT` (`DATE_STAT`),
KEY `IX_B_STAT_SESSION_5` (`DATE_LAST`),
KEY `IX_B_STAT_SESSION_6` (`GUEST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+----------------+-------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----+
1 row in set (0.00 sec)

31 ��� fifteen, 09:10����[17958366]     �������� | ���������� �������� ����������
 Re: Failed to read auto-increment value from storage engine  [new]
sknzv
Fellow member

������:
���������: 4

Shahriyar.R,

mysql> select max(id) from b_stat_session;
+---------+
| max(id) |
+---------+
| 671900 |
+---------+
1 row in set (0.05 sec)

31 ��� 15, 09:27����[17958423]     �������� | ���������� �������� ����������
 Re: Failed to read motorcar-increment value from storage engine  [new]
Shahriyar.R
Member

������:
���������: 144

sknzv
���� ������� ��������, �������, �������� ������ ������� ����� ������ http://SSMaker.ru/8810e01d/.
mysql ����������� ������ � ���������� innodb_force_recovery = five.

� � fault ���� ������ ����? ����� ���� ����� ���������?

����� ���� "problems regression":

#69907

����� ������ MySQL?

31 ��� 15, 09:30����[17958434]     �������� | ���������� �������� ����������
 Re: Failed to read motorcar-increment value from storage engine  [new]
tanglir
Member

������:
���������: 28966

sknzv
mysql ����������� ������ � ���������� innodb_force_recovery = 5
������ ������� ����� �������, � ����� ���� ����
����� ���� ���������� ��� � ���������, ��� ������ ������ ���������

Alex_Ustinov, �� ����� ���� � �������, ���� � ��� ���� ���������������... ��, �����, � �������, �������, �� ���-�� � ����������.

31 ��� 15, 13:07����[17959669]     �������� | ���������� �������� ����������
 Re: Failed to read machine-increment value from storage engine  [new]
Alex_Ustinov
Fellow member

������: Nickel
���������: 4097

tanglir,

��� ��� ��� � ������, ��� �� ���, � ����������� �������������� ��������� ������ ����� �����, ���� ���������� - ����� ��� ������ ������, ����� � ���� � �� ������� ���������� ���������...

31 ��� xv, 15:30����[17960663]     �������� | ���������� �������� ����������
 Re: Failed to read machine-increment value from storage engine  [new]
Shahriyar.R
Member

������:
���������: 144

����� ������ ��� MySQL �������� ����� � innodb_force_recovery = 5.
A ��� �������� � 5.5:

five (SRV_FORCE_NO_UNDO_LOG_SCAN)
Does not look at undo logs when starting the database: InnoDB treats even incomplete transactions as committed. This value tin permanently decadent data files.

5.6:

five (SRV_FORCE_NO_UNDO_LOG_SCAN)
Does not look at undo logs when starting the database: InnoDB treats even incomplete transactions as committed. This value tin permanently decadent data files. As of MySQL five.6.xv, sets InnoDB to read-only.

���� �� �� ����� ������...

����� � ����, Error-> Fault(1030): Got error -1 from storage engine

� ��� ��� �������� ����, �������� � 5.6.16 � 5.7.4:

Attempting to reset a replication slave while "innodb_force_recovery" is
greater than "0" would return a cryptic mistake message: "ERROR(1030) HY000:
Got error -1 from storage engine". The fault message has been changed to:
"Mistake HY000: Performance not allowed when innodb_force_recovery > 0".
Replication options such as "--relay-log-info-repository=TABLE" and
"--master-info-repository=Tabular array" shop information in tables in "InnoDB".
When "innodb_force_recovery" is greater than 0, replication tables cannot
be updated which may crusade replication administration commands to fail.

31 ��� 15, xvi:19����[17961002]     �������� | ���������� �������� ����������

jonesbuthent.blogspot.com

Source: https://www.sql.ru/forum/1168414/failed-to-read-auto-increment-value-from-storage-engine

Post a Comment for "Office Source Engine Failed to Read Description"