Repair/Optimize Tables weird error

[LaBella]

Repair / Optimize Tables

Please Wait...

Results

Table

Action

Message

searchcore

Optimize

Note: Table does not support optimize, doing recreate + analyze instead

searchcore

Optimize

Error: Duplicate entry '1778803' for key 'PRIMARY'

searchcore

Optimize

Status: Operation failed

[Wayne Luke]

Why are you running this? This isn't a general maintenance tool and should not just be run without purpose.

The error above indicates the table is an INNODB table and repair does not work on INNODB tables. Don't know why there is a duplicate entry but you can simply truncate the search* tables and rebuild the search index to eliminate any such issues.

[LaBella]

I am trying to get to the bottom of a very long lag when posting, looking around for any possible help...I eventually ended up at Repair & Optimize tables. I posted here because I am almost at my wit's end with my server company.

[Wayne Luke]

Repair / Optimize does not provide any noticeable performance benefits. Optimize doesn't even really optimize anything. What it does is remove previously deleted data from the tables and is only useful if you bulk delete threads, users, or attachments.


Please answer the questions in this thread:

http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4005557-getting-your-questions-answered-quickly

[LaBella]

OK, I will not use repair/optimize ever again. I thought it was included in the software because it worked, sorry about that.

1. vBulletin Version (I am in the queue for an update, but currently 4.2.3 Beta)
2. PHP Version 5.5.20
3. MySQL Version 5.6.23
4. Any Addons installed PhotoPost Pro Gallery & vbadvanced v4.2.1
5. Does the issue occur in a default style? No
6. Error message on the screen' No
7. Browser and Browser version used. All
8. A list of steps that can be used to recreate the issue. Hit reply to thread and it posts immediately, but it takes sometimes up to 30 seconds for the browser to return to full functionality.

[AusPhotography]

Repair/Optimize does work. It should only be used when needed and only when the site is offline. You need to read up on MySQL as to why.when you should use this tool. In the right circumstances it is very useful

[LaBella]

Been a while, anyone? Anything? :/

[kh99]

What do you have for Email Options > Use Mailqueue System? The sending of subscription emails could cause a delay if you're not using the mail queue.

[LaBella]

Use Mailqueue System = Yes. Should I change it? What do you suggest?

[kh99]

'Yes' is good. I guess that's not the problem.

[kh99]

You said you ended up at Repair and Optimize tables, is that because you narrowed it down to being a database issue?

[LaBella]

I was looking for possible causes, and went over many different things with my server company. I still cannot figure it out

[kh99]

Yeah, that is a pretty good guess. Did you temporarily turn off plugins just to make sure it isn't an add-on that's causing the problem?

I was going to suggest that you turn on debug mode, which lets you see a display of all the queries that were done for a page and how long they took. But then I realized that after you post you get redirected to the thread page so you never get a chance to see the debug info from the post. You;d have to hack the code in some way to see it, I guess.

[LaBella]

Man, as always I am thankful for your guidance first & foremost. You are always helpful, so for that I thank you.

I use Firefox, so I will hit reply, and open another tab to my forum and see the post already there. The 1st tab has the little spinning (Working) icon and the 2nd tab is locked up until the 1st one goes through. Sometimes it is instant, other times it can take up to 30 seconds.

[kh99]

I see. Well, I can't think of anything else right now. Hopefully someone else will have a suggestion.

[Mark.B]

Please try the following:

1. To disable the plugin/hook system completely, edit includes/config.php and add the following code:
Just below

<?php

enter

define('DISABLE_HOOKS', true);

2. Now go to AdminCP > Style Manager
and create a new style with no parent.
Now browse your forum using this new style.

Do you still have the same problem?