"Failed to add entry to queue" on adding a label to a page

[Andrew Barnes]

Hi,

We've been running Confluence 6.9.1 for a few weeks with out this issue.

Since yesterday we can no longer create new pages from any template that includes a label by default. Such as 'Product Requirements' template will include 'requirements' label.

The page can be created, but it can not be saved until the label is removed. The error I see from users perspective is:

Unable to communicate with server. Saving is not possible at the moment.

on removing the label/s, the page saves OK.

Similarly, for an existing page I can no longer add a label, in the label window I can select existing labels but on clicking "ADD" I get the following error:

com.atlassian.confluence.api.service.exceptions.ServiceException: Failed to add entry to queue

Thus I believe the issue I have here is within the labels.

I do not know what has changed. I have recently installed the Multi-vote plugin, and as part of problem solving have since disabled that plugin - which made no difference.

I have checked the database configuration as per:

https://confluence.atlassian.com/conf69/database-setup-for-sql-server-950285437.html

which looks correct.

I do not use collaborative editing (stuck on IIS 6.0).

Any thoughts or suggestions?

Thanks,

EDIT: Confluence logs, from the point of clicking "ADD" in the label dialog.

https://paste.fedoraproject.org/paste/PeZAhaUXsC5zjxuG1yYOjA

[R. Fuerst · Accepted solution]

Hi Andrew, 

Thanks for attaching those logs - they were super helpful! It looks like this is the error that's causing the issue:

Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed to read id for journal 'main_index': For input string: "      "; nested exception is java.lang.NumberFormatException: For input string: " 

This can be caused by a corrupt index and ‘main_index’ file which can happen sometimes after an upgrade. To fix it, please follow the guide below:

• https://confluence.atlassian.com/confkb/exception-when-creating-or-deleting-page-683181903.html

Hope it helps! 

Rachel

[Andrew Barnes]

Thank you Rachel for your help, and for highlighting the key information in the logs.

I followed the how-to linked in your link:

https://confluence.atlassian.com/confkb/how-to-rebuild-the-content-indexes-from-scratch-on-confluence-server-110035351.html

I've removed those index and journal directories and re-index confluence - the problem is now resolved.

Thank you.

[Fabian Rapetti]

This guide also worked for us.

Thanks for sharing. 

Fabian

[Stefan Feldmann]

I had the same issues and could solve them with this guide.

Thank you for this guide.

Stefan