Notices by cassidyclown (cassidyclown@clubcyberia.co), page 14

@Kirino holy shit the sequence was lower than the max object id yet somehow it didn't trigger an error every single time - my eyes literally added a zero when I said it was higher which wouldn't make any sense anyway since it's supposed to be the same value

cassidyclown (cassidyclown@clubcyberia.co)'s status on Wednesday, 06-Sep-2023 00:28:37 JST

cassidyclown

in reply to

Kirino Kousaka

@Kirino the primary key is the id and it only increments by one each time there's a new object which as far as I can tell is determined by objects_id_seq sequence. The current value for the sequence is a bit higher than the max id in the objects table. If it was lower than the max id I think it would trigger a unique violation error every single time it attempts to insert an object. But this error only occurs sometimes - like once ever half-hour to an hour or sometimes longer going by logs. That's the really weird part.

cassidyclown (cassidyclown@clubcyberia.co)'s status on Tuesday, 05-Sep-2023 19:53:29 JST

cassidyclown

in reply to

@mint why would that randomly fuck with people trying to make a post though

cassidyclown (cassidyclown@clubcyberia.co)'s status on Tuesday, 05-Sep-2023 19:45:02 JST

cassidyclown

in reply to

@mint I only did objects and not activities. I did a database reindex and it didn't affect it. I'm going to try putting back activities too now since there's nothing else to try but I'm worried that would double the amount of errors if it just messes with activities in the same way. The full error is:

[error] Task #PID<0.13844.0> started from #PID<0.13774.0> terminating
** (Ecto.ConstraintError) constraint error when attempting to insert struct:

* "objects_pkey" (unique_constraint)

If you would like to stop this constraint violation from raising an
exception and instead add it as an error to your changeset, please
call `unique_constraint/3` on your changeset with the constraint
`:name` as an option.

The changeset defined the following constraints:

* "objects_unique_apid_index" (unique_constraint)

(ecto 3.10.2) lib/ecto/repo/schema.ex:804: anonymous fn/4 in Ecto.Repo.Schema.constraints_to_errors/3
(elixir 1.14.0) lib/enum.ex:1658: Enum."-map/2-lists^map/1-0-"/2
(ecto 3.10.2) lib/ecto/repo/schema.ex:788: Ecto.Repo.Schema.constraints_to_errors/3
(ecto 3.10.2) lib/ecto/repo/schema.ex:769: Ecto.Repo.Schema.apply/4
(ecto 3.10.2) lib/ecto/repo/schema.ex:377: anonymous fn/15 in Ecto.Repo.Schema.do_insert/4
(pleroma 2.5.54-321-g17c336de-develop) lib/pleroma/web/activity_pub/activity_pub.ex:102: Pleroma.Web.ActivityPub.ActivityPub.persist/2
(pleroma 2.5.54-321-g17c336de-develop) lib/pleroma/web/activity_pub/pipeline.ex:49: Pleroma.Web.ActivityPub.Pipeline.do_common_pipeline/2
(ecto_sql 3.10.1) lib/ecto/adapters/sql.ex:1203: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
Function: #Function<7.11561101/0 in Pleroma.Web.ActivityPub.ActivityPub.make_user_from_ap_id/2>
Args: []

cassidyclown (cassidyclown@clubcyberia.co)'s status on Tuesday, 05-Sep-2023 19:39:32 JST

cassidyclown

maybe it'll never happen again (delusional)

cassidyclown (cassidyclown@clubcyberia.co)'s status on Tuesday, 05-Sep-2023 19:30:25 JST

cassidyclown

we're back but it's over

cassidyclown (cassidyclown@clubcyberia.co)'s status on Tuesday, 05-Sep-2023 19:17:29 JST

cassidyclown

in reply to

@mint @Cassidy @lina I rerolled it like 20 times I got it wrong every time

cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:19:37 JST

cassidyclown

We need to get some crawlers on cyberia, need to fatten up my database I'm feeling self-conscious. Need to get this instance on a 100% ironized yeast and lard diet.