Jump to content

MySQL 8.0 crashes when Inspect Server starts


Recommended Posts

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...