[Nextcloud] A cloud for personal or group use

Limezy · January 12, 2024, 7:38am

Nope, still not good
https://paste.yunohost.org/raw/uweqoqufac

I confirm that I have a database “Nextcloud” in PostgreSQL

root@myuser:/# sudo -u postgres psql -d nextcloud
psql (13.13 (Debian 13.13-0+deb11u1))
Type "help" for help.

nextcloud=# \l
                                     List of databases
   Name    |   Owner   | Encoding |   Collate   |    Ctype    |     Access privileges      
-----------+-----------+----------+-------------+-------------+----------------------------
 nextcloud | nextcloud | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/nextcloud             +
           |           |          |             |             | nextcloud=C*T*c*/nextcloud
 outline   | outline   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/outline               +
           |           |          |             |             | outline=C*T*c*/outline
 postgres  | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres               +
           |           |          |             |             | postgres=CTc/postgres
 template1 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres     +
           |           |          |             |             | =c/postgres
(5 rows)

I believe there is a problem with that test : https://github.com/YunoHost-Apps/nextcloud_ynh/blob/c39600e756f190ab734876871e804900e14096c8/scripts/upgrade#L77

Lapineige · January 12, 2024, 7:45am

If we upgrade to PostgreSQL branch, will we be able to retrieve the next upgrades from master ? Would it go back to MySQL ?

Limezy · January 12, 2024, 7:52am

@ericg is very regularly updating the PosgreSQL branch in parallel to the MySQL branch. You may have to wait a little bit more than master before updating, and you may also bump into a few crashed upgrades like I just did ! But it’s now more than one year that I upgrade my PostgreSQL version from that branch without any major issues.

However, if I’m not wrong there are no scripts to migrate back to MySQL. You would have to do all manually which could be quite messy… You can’t “just” upgrade back to a master branch commit.

rodinux · January 12, 2024, 1:21pm

Ok, I found this solution, if someone have the same issue… remove the old logs
sudo -u nextcloud truncate /home/yunohost.app/nextcloud/data/nextcloud.log --size 0

see this here: Clear logfile NOT logrotate [SOLVED] - ℹ️ Support - Nextcloud community

Mamie · January 12, 2024, 1:21pm

I upgraded today from 27 stable to 28 stable, and as already reported, MANY errors in the admin overview (without any details)

Then, I tried to access the logs, to bee greeted by a message : « Could not load log entries »

After some time, the logs load.
If I ignore the errors that are my fault (some mount point changed), here are the remaining errors :

Could not find resource files_external/js/public_key.js to load
Could not find resource files_external/js/oauth2.js to load
Could not find resource files_external/js/oauth1.js to load

jarod5001 · January 12, 2024, 2:20pm

After 28 update, collabora stopped working.
In
Allow list for WOPI requests
I changed it from 0.0.0.0/0 to ::1

Aleks · January 12, 2024, 5:38pm

So what does this returns: sudo -u postgres psql -d nextcloud <<< "\dt" ?

JfmbLinux · January 12, 2024, 8:05pm

I have the same problem…

ericg · January 12, 2024, 8:36pm

having errors displays seems more a feature that a problem. What is interesting is what king of errors do you have.

jarod5001 · January 12, 2024, 9:23pm

I had it too. I checked the logs in NC admin and searched for the error message and it was about an outdated app.
Check the logs for error messages

Limezy · January 13, 2024, 5:12am

It returns :

                    List of relations
 Schema |            Name             | Type  |   Owner   
--------+-----------------------------+-------+-----------
 public | oc_accounts                 | table | nextcloud
 public | oc_accounts_data            | table | nextcloud
 public | oc_activity                 | table | nextcloud
 public | oc_activity_mq              | table | nextcloud
 public | oc_addressbookchanges       | table | nextcloud
 public | oc_addressbooks             | table | nextcloud
 public | oc_appconfig                | table | nextcloud
 public | oc_authorized_groups        | table | nextcloud
 public | oc_authtoken                | table | nextcloud
 public | oc_bruteforce_attempts      | table | nextcloud
 public | oc_calendar_appt_bookings   | table | nextcloud
 public | oc_calendar_appt_configs    | table | nextcloud
 public | oc_calendar_invitations     | table | nextcloud
 public | oc_calendar_reminders       | table | nextcloud
 public | oc_calendar_resources       | table | nextcloud
 public | oc_calendar_resources_md    | table | nextcloud
 public | oc_calendar_rooms           | table | nextcloud
 public | oc_calendar_rooms_md        | table | nextcloud
 public | oc_calendarchanges          | table | nextcloud

… and a lot of other similar lines

That’s why I’m little bit confused about what is bugging here. Maybe my PostgreSQL database is somehow removed earlier in the process ?
Has someone already migrated to PosgreSQL tried the upgrade ?

JfmbLinux · January 13, 2024, 12:04pm

Exactly, I’m looking!

JfmbLinux · January 13, 2024, 12:06pm

Which app did you deactivate?
Finally, if it is not indiscreet…

jarod5001 · January 13, 2024, 12:31pm

“Activities for shared file downloads” if I’m not wrong. It used to send me email if someone downloads a shared file.

rodinux · January 13, 2024, 7:36pm

Sur un nouveau serveur, encore un paquet d’erreurs 441 erreurs dans les journaux depuis 6 janvier 2024 !
je comprends qu’il faut attendre quelques jours, une semaine pour que le message disparaisse sur ce topic:

cichy1173 · January 13, 2024, 8:13pm

If someone relays on News app - Do not update. It works bad inside NC 28.

JfmbLinux · January 13, 2024, 9:52pm

Thank, I don’t use this app.

jarod5001 · January 13, 2024, 9:55pm

Avez vous vérifié le log dans l’administration de nextcloud ? J’ai eu un tas d’erreurs qui en cherchant c’est avéré qu’une application qui n’est plus supportée.

jarod5001 · January 13, 2024, 9:56pm

I think before running the upgrade, everyone should update all the nextcloud apps and check if any of them has problems with the next version of NC.

rodinux · January 13, 2024, 10:19pm

Ok, j’ai du enlever Mind Maps, et aussi un peu un bug avec Ownpad, en fait les pads fonctionnent, mais je ne vois plus dans le menu la possibilité d’ajouter un pad, un private pad ou ou calc, mais les ceux existant fonctionnent toujours, je vais attendre et ouvre une issue sur le dépôt de l’extension, mais je voudrai la garder activée…
Ensuite j’ai des erreurs de ce type

Error while running background job (class: OCA\\GroupFolders\\BackgroundJob\\ExpireGroupVersions, arguments: )","exception":{},"CustomMessage":"Error while running background job (class: OCA\\GroupFolders\\BackgroundJob\\ExpireGroupVersions, arguments: )"}}