• Joined on 2022-05-06
xeruf commented on issue vikunja/vikunja#1199 2022-07-18 12:21:39 +00:00
Postgresql ssequences not updated correctly upon dump import

Just noticed I am not quite at latest, but includes your commits anyways:

Frontend Version: 0.18.1+1972-d462d56202

API Version: v0.18.1+283-8023674adf
xeruf commented on issue vikunja/vikunja#1199 2022-07-18 12:16:49 +00:00
Postgresql ssequences not updated correctly upon dump import

This is really bad because we wanted to use Vikunja productively today :/

I tried an older backup and the import worked, but I still cannot create new lists:

│ 2022-07-18T12:15:44.63537…
xeruf commented on issue vikunja/vikunja#1199 2022-07-18 12:05:58 +00:00
Postgresql ssequences not updated correctly upon dump import
2022-07-18T12:05:13.623784645Z: INFO	▶ [DATABASE] 0d0 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [notifications public] - 2.45637ms
2022-07-18T1…
xeruf commented on issue vikunja/vikunja#1212 2022-07-18 12:01:09 +00:00
Option to return detailed error messages

Yes, so users can say more than "I got an internal server error", because currently I have to either reproduce it or ask for a timestamp and plow through the logs. With a proper error message I…

xeruf commented on issue vikunja/vikunja#1199 2022-07-18 11:55:19 +00:00
Postgresql ssequences not updated correctly upon dump import

I now upgraded to unstable and reimported to apply the fixes, but whenever I login I find everything empty...

xeruf opened issue vikunja/vikunja#1212 2022-07-17 21:42:11 +00:00
Option to return detailed error messages
xeruf commented on issue vikunja/frontend#2106 2022-07-15 17:25:42 +00:00
<500 when get issue>

I did set the frontendurl and it seems all fine now :)

xeruf commented on issue vikunja/vikunja#1199 2022-07-13 20:38:47 +00:00
Postgresql ssequences not updated correctly upon dump import

Yes, new namespaces, new users, all fine :)

But nevertheless this should be fixed in the importer ;)

xeruf commented on issue vikunja/frontend#811 2022-07-13 20:34:11 +00:00
<500 when get issue>

Also, when assigning a task color, and re-editing the task, the task color is visible nowhere, both on stable and on try, which confused me. I was looking at the list and the task and thought the…

xeruf commented on issue vikunja/frontend#868 2022-07-13 20:30:32 +00:00
<500 when get issue>

Are these resolved?

xeruf commented on issue vikunja/vikunja#1199 2022-07-13 20:11:40 +00:00
Postgresql ssequences not updated correctly upon dump import

Fixed it with the following query derived from the aforementioned SO post:

SELECT setval('namespaces_id_seq', 9) FROM namespaces;

Found the correct sequence to use in:

\d+…
xeruf commented on issue vikunja/vikunja#1199 2022-07-13 20:03:32 +00:00
Postgresql ssequences not updated correctly upon dump import

Here is the output:

2022-07-13T20:02:06.138389003Z: INFO    ▶ [DATABASE] 1fd [SQL] INSERT INTO "namespaces" ("title","description","owner_id","hex_color","is_archived","created","updated"
xeruf commented on issue vikunja/vikunja#1199 2022-07-13 19:55:40 +00:00
Postgresql ssequences not updated correctly upon dump import

No, I can't create new namespaces at all actually.

I'll set the debug parameters and report back.

xeruf commented on issue vikunja/vikunja#1199 2022-07-13 16:47:22 +00:00
Postgresql ssequences not updated correctly upon dump import
vikunja=> \d+ namespaces
                                                             Table "public.namespaces"
   Column    
xeruf commented on issue vikunja/vikunja#1158 2022-07-13 16:28:02 +00:00
New version

it is very usable but there's a higher chance encountering bugs

Considering the number of bugs I already encountered on stable, I am questioning this :P I guess I'll try it, I'm just a…

xeruf commented on issue vikunja/vikunja#1199 2022-07-13 11:53:57 +00:00
Postgresql ssequences not updated correctly upon dump import

Now new users can't sign up via OIDC, the reimport probably screwed up the provider info:

2022-07-13T11:48:17.287756418Z: ERROR   ▶ openid/HandleCallback 18a1 Error creating new user…
xeruf commented on issue vikunja/vikunja#950 2022-07-13 11:21:09 +00:00
[Feature Request] Assign teams from OpenID Connect claims

Yes please! I now have to prompt all people to log in so I can assign them to the team, which is rather annoying.

An option to share something for everyone on the instance would be handy here, too.

xeruf commented on issue vikunja/vikunja#1158 2022-07-13 11:15:27 +00:00
New version

Is unstable usable, so I do not have to fear corruption or something, are you yourself using it productively?

Can I run two instances, unstable and stable, on the same database?

xeruf commented on issue vikunja/vikunja#1199 2022-07-13 11:10:42 +00:00
Postgresql ssequences not updated correctly upon dump import

Managed to work around the issue by trimming notifications.json to [], rezipping and reimporting :)