Cleaning up database errors, one left : concurrent OPTIMIZE (or ALTER etc) is running; UPDATE timed out; please retry

[James Crivellone]

Any thoughts? I doublechecked the configuration with the Sphinx implementation guide and its identical.

[James Crivellone]

Following up on this. I shut down Sphinx and went back to DB search, all DB errors went away, so its something with Sphinx

[James Crivellone]

Running Sphinx 3.2.1

Nothing in the Sphinx logs that are particular about optimization.

[Sun Apr 12 01:12:58.060 2020] [6560] rt: index r3vdb: ramchunk saved ok (mode=periodic,...

[James Crivellone]

Thank you, Wayne,

Not running anything to my knowledge (its been happening since we kicked up sphinx) Anything I could verify to see why it's trying to optimize?...

[James Crivellone]

After migration from 3.X to 5.X I've been cleaning up a decent amount of database errors and optimizing the forum as much as possible. I still see Cache Event issues occasionally which require a MySQL...

[James Crivellone]

Does anyone have any thoughts? Support has ignored every inquiry I've made, its happening every day and I'm running out of ideas....

[James Crivellone]

Update on the issue, did some testing and simply bumping MySQL free's it up (without clearing Cache). Still not sure what the issue is and Its happening about every 12 or so hours at this point....

[James Crivellone]

I am receiving a large amount of database errors around 24 hours after restarting the environment, this has happened since the 5.5.4 Patch Level 1 (on PL2 Now) Update. Only way to rectify the issue is...