Webtop - issue creating task

jcampos · April 9, 2019, 12:33am

Hi,

I’m not sure if this issue has been reported or solved yet in other part of the community.

I have a practically fresh instalation of nethserver running other services like rspamd, nextcloud and webtop.

In webtop i have running without issues, calendars, contacts and email, but when I create new task i got an error!

I let you some images of the error notification and some logs, in this logs i see a problem in the database, but i don’t have idea how to solve it.

So, i’m really appreciate if someone help me to fix it.

Regards!

lucag · April 9, 2019, 7:33am

Hi @jcampos,
if you can show me what is written to the log when you access the Tasks I can try to help you.

You can also show me the output of this command:
su - postgres -c "psql webtop5 -c \"select value from core.settings where service_id='com.sonicle.webtop.tasks' and key='manifest.version'\""

jcampos · April 9, 2019, 6:12pm

Hi @lucag

I’ve updated the post, and here is the output of the command.

Thank you!

lucag · April 9, 2019, 6:58pm

Ok @jcampos,
the problem could be due to a failure of the update procedure on the tasks.tasks table during the installation of the last release.

If the problem is this you should resolve with a downgrade of the version in the manifest:

su - postgres -c "psql webtop5 -c \"update core.settings set value='5.2.2' where service_id='com.sonicle.webtop.tasks' and key='manifest.version'\""

and a restart of the application:

systemctl restart tomcat8@webtop

Let me know if you solve the problem

jcampos · April 9, 2019, 11:20pm

Sorry, but the same error appears again after the command execution and the tomcat service restart.

I execute the command

su - postgres -c “psql webtop5 -c “select value from core.settings where service_id=‘com.sonicle.webtop.tasks’ and key=‘manifest.version’””

and as you see, the output is 5.3.0

After that, I execute

su - postgres -c “psql webtop5 -c “update core.settings set value=‘5.2.2’ where service_id=‘com.sonicle.webtop.tasks’ and key=‘manifest.version’””

and the system go to “Maintenance mode”, and the version now is 5.2.2

But when I apply the tomcat restart command the system go out from Maintenance mode and the version again is 5.3

¿do you have another idea?

lucag · April 10, 2019, 7:54am

Hi @jcampos,
then it is likely that only some queries failed after the previous update.

Check what the “DB Upgrade” page you find on the WebTop admin panel shows:

It is probable that in your case there are queries that have not been executed regularly and that you have to advance manually.

Can you paste a screenshot of what you see on this page?

JamieLanger · April 10, 2019, 2:22pm

Details about what’s in the log would help people answer to solve your query

jcampos · April 10, 2019, 9:28pm

Here is the screenshot of the same db section in my webtop interface

lucag · April 11, 2019, 7:01pm

Ok @jcampos we found the problem and this would be the solution:

put in maintenance the application by clicking on the top left button “Maintenance not active”
select the line (the one that shows the first ERROR) and click on the “Skip” button at the top
select line 2 and click on the “Run” button to have the queries performed on hold
should stop at the next error on line 8
at this point you can “Skip” all the following queries since they are the replication of the previous ones
disables maintenance by clicking again on the left-hand top button

In this way you should solve the problem you are encountering on the Tasks.

Let me know

jcampos · April 11, 2019, 8:08pm

@lucag Sorry but it doesn’t work

I follow all the steps and the system still show me the error notification!

Here is the DB Upgrade section with the new outputs

jcampos · April 12, 2019, 12:16am

@lucag I’m going to mark this issue as solved.

Thank you very much for the support!

Here is the way to do it!

After that I follow the steps that you mention.