mh0 0 Posted August 16, 2022 Posted August 16, 2022 This just started happening to me on Friday where MySQL will sit there just fine but once the Inspect Server is launched, MySQL takes a and just shuts down. Two things I'm seeing in the MySQL logs: Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (227755f0620): UPDATE clients SET lastConnected = UTC_TIMESTAMP(), events = fnLaterTimestamp(events, '2022-08-12 17:36:36'), removed = 0 WHERE groupId = 1021 Connection ID (thread ID): 28 Status: NOT_KILLED 2022-08-16T13:26:55.345304Z 31 [ERROR] [MY-012869] [InnoDB] Record in index `idx_removed` of table `eidb`.`clients` was not found on update: TUPLE (info_bits=0, 2 n_cmp=2, fields): {[1] (0x10),[4] (0x80000696)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696e66696d756d00)} 2022-08-16T13:26:55.805783Z 30 [ERROR] [MY-012869] [InnoDB] Record in index `idx_removed` of table `eidb`.`clients` was not found on update: TUPLE (info_bits=0, 2 n_cmp=2, fields): {[1] (0x14),[4] 6(0x80000436)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696e66696d756d00)} 2022-08-16T13:26:56.206167Z 27 [ERROR] [MY-012869] [InnoDB] Record in index `idx_removed` of table `eidb`.`clients` was not found on update: TUPLE (info_bits=0, 2 n_cmp=2, fields): {[1] (0x07),[4] (0x800005ea)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696e66696d756d00)} I'm not skilled enough in MySQL to know what to do with this, or if I even can. And this may not even be the error I need to focus on for all I know. Are there any commands I can use to clean up/optimize the ESET Inspect db or anything?
Administrators Marcos 5,741 Posted August 16, 2022 Administrators Posted August 16, 2022 Please open a support ticket for further troubleshooting of the issue.
Recommended Posts