Error in Deleting Data in Prod Environment

[kausik10]

Hi, I added a new field yesterday in my existing project

notes = c.oneHasOne(Note, "file");
in my File.ts and

file = c.oneHasOneInverse(File, "notes");
in my Note.ts

I have a prod where project is deployed and I have same dataset in my prod and my locally running project.

If I try to upload and delete or simply delete an existing file locally, it is working fine. However, if I try to perform same set of operation in my prod (same codebase), I get an error saying

Could you help me identify why this issue persists in prod and not locally. Thank you!

This is the page where I am getting the error client-detail.tsx for reference:

<FileRepeaterField
                    field="files[folder.id=null]"
             ....
                    hookChildren={<FileUploadTrigger onSuccess={updateFiles} />}
                />
                <TableWrapper className="bg-gray-50/50 max-w border rounded-md">
             ......
                            <HasMany
                                field="files[folder.id=null]"
                                orderBy="meta.fileName asc"
                            >
                              .....
                                    <TableCell className="flex gap-4 justify-end">
                                    ...
                                        <DropdownMenu>
                                           ......
                                            <DropdownMenuContent className="flex flex-col gap-1">
                                               ...
                                    
                                                <DeleteEntityDialog
                                                    trigger={
                                                        <Button
                                                            variant="destructive"
                                                            size="xs"
                                                            className="w-full"
                                                        >
                                                            <div className="w-20 flex items-center">
                                                                <Trash2 className="h-3" />
                                                                Smazat
                                                            </div>
                                                        </Button>
                                                    }
                                                />
                                      .......
                </TableWrapper>

which is being referenced from another file clientDetail.tsx as:

<Binding>
             
                        <EntitySubTree
                            entity="Client(id=$id)"
                            isCreating={false}
                        >
                         .....
                            <ClientDetail updateFiles={updateFiles} />
                        </EntitySubTree>
                    </div>
                </div>
            </Binding>

The updateFiles is working correctly as intended. Only problem lies in deletion.

Could you help me identify what went wrong here in prod and local and why am I getting error only in prod. Thank you!

[jonasnobile]

Hi, are you trying both production and local action with same role?

[kausik10]

Yes, I have the same role in both the local and production environment. I am accessing via 'admin' role.

…

On Mon, 24 Mar 2025, 6:35 pm jonasnobile, ***@***.***> wrote: Hi, are you trying both production and local action with same role? — Reply to this email directly, view it on GitHub <#756 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AXHQMXFY2I5CKLY2Q7FDOO32V75QXAVCNFSM6AAAAABZNWN3W2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRQGE4TINQ> . You are receiving this because you authored the thread.Message ID: ***@***.*** .com>

[jonasnobile]

Your issue arises because of the difference between the local and production engine versions:

• Locally, you're running Contember engine v1.4.
• In production, you're running Contember engine v2.

The engine system behaves slightly differently between these two versions. Specifically, Contember v2 introduced different events handling during execution of generated query, causing your current setup (two different entity trees referencing the same entity but with different ordering or filtering conditions) to throw errors when attempting deletion.

Why the issue is occurring:

In your code, you're referencing:

field="files[folder.id=null]"

in multiple places but with different conditions or ordering, which the new engine interprets as distinct entity trees. When you try to delete a file in one tree, it conflicts with references in the other tree, as the engine expects them to match exactly.

Solution:

To resolve this, ensure your entity trees are aligned. The conditions and ordering should be identical wherever you reference the same entity list.

For example, ensure all your entity bindings referencing the file are consistent like this:

<HasMany
    field="files[folder.id=null]"
    orderBy="meta.fileName asc"
>

Make sure everywhere you reference this list, the filtering and ordering ([folder.id=null] and orderBy="meta.fileName asc") match precisely. Any mismatch will cause errors in the new engine.

Recommended steps to fix in your case:

1. Align your entity trees (make sure all instances of field="files[folder.id=null]" have the exact same ordering or filtering).

2. Update your local engine to v2 (recommended), ensuring that you catch these types of issues earlier, matching the production environment behavior.

3. After alignment, re-deploy the corrected code to production, and your deletion issue will be resolved.

This alignment will resolve the inconsistency causing your error.

[kausik10]

Hi, when I imported the data from one prod environment to another prod environment the email and user roles were not imported. I checked on with the settings inside the repository and saw that there were many different API keys setup. So it might be the role issue. I checked the codebase and don't see any real connection where I could say those API_KEYS have been used for the current prod. I don't have any migrations that affect the codebase or the user roles. So I was wondering if I push it to current prod, it should not tamper and this issue should not persists. Am I right in thinking so?

…

On Mon, 24 Mar 2025, 6:59 pm Kausik Paudel, ***@***.***> wrote: Yes, I have the same role in both the local and production environment. I am accessing via 'admin' role. On Mon, 24 Mar 2025, 6:35 pm jonasnobile, ***@***.***> wrote: > Hi, are you trying both production and local action with same role? > > — > Reply to this email directly, view it on GitHub > <#756 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AXHQMXFY2I5CKLY2Q7FDOO32V75QXAVCNFSM6AAAAABZNWN3W2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRQGE4TINQ> > . > You are receiving this because you authored the thread.Message ID: > <contember/interface-archive/repo-discussions/756/comments/12601946@ > github.com> >

[jonasnobile]

Hi, user emails and roles are most probably stored in the tenant database (the best practices), not the content database. The CLI commands export, import and transfer only handle data in the content database. This means user emails and roles won't move between projects when you perform these operations.