Out of sort memory in Data Browser

Bug
1

Application ID: 66C2DBD4-189A-7377-FF95-915D98235700

Out of sort memory, consider increasing server sort buffer size

Problem description

I want to add 1:n relations to a table entry in Data Browser

Steps to reproduce

  1. Click on “Add/Remove related Objects”
  2. Error message appears “Out of sort memory, consider increasing server sort buffer size”

Please look into it. Thank you in advance.

Regards, Joerg

2

Hi @Jorg_Beyer ,

Sorry for inconvenience. Could you please provide names of the parent and child tables with relation name?

Regards, Andriy

3

Parent table: Idea
Relation Name: constituents

The affected record is in the column “name” with the value “Value”

4

Is that sufficient?

5

Hello @Jorg_Beyer,

yes, thank you.
I’ve created an internal ticket to fix this issue.

7

Hi again,

Could you try adding an index to the column name?

8

It already has an index

9

Do you have any sorting in the related table?

10

Sorry, for the late reply.
No, there is no sorting in the related table. Any sorting in the related table leads to the same error in that table, so I avoid sorting.

11

Any chance to have a deeper look into this topic?

Thanks, Joerg

12

Sorry for the long reply, we looking into it right now.

13

@Jorg_Beyer

I have tried to add relation after disabling all sorting in the related table - and it works as expected.

Could you please go to related table, and manually enable sorting for the first column, and after that disable it. It will help us to be sure, that there are no sorting in any other column.

Does error still appear after this actions?

Regards, Dima.

14

What do you mean by enabling/disabling sorting? I have manually done sorting by clicking on the sorting button of the column in the related table. And did that until no sorting.
The error still appears.

15

Enabled:
image
image

Disabled:
image

Go to StockMRQEvaluationData table and enable sorting for first column, and after that disable it.

After that try to add relation again.

16

That’s what I have done.

17

And as I understand the error still appear.

Ok, lets try to investigate what the difference between your and my cases.

Please do the next steps:

  1. go to the Idea table
  2. open browser devtools(F12 or Right Mouse Click → Inspect)
  3. Choose network tab(1)
  4. Clear all request using button(2)
  5. Try to add relations

And for every “find” request(3) repeat next:

  • choose payload tab(4)
  • Right Mouse Click on request payload(5)
  • Click “Copy object”
  • Paste it here

image
image1227×739 124 KB

18

Hi, the difference is, that my request contains a sort. But why?

image
image955×240 13.3 KB

I checked every single table - not only the related one, biut all tables - and disabled sorting.
But without any effect.

19

I can see that every table view of the related objects is by default sorted! I cannot disable sorting here.

image
image1708×922 72.5 KB

This must be set by the backendless. What do you think?

20

Hello @Jorg_Beyer

We have added an internal task to remove default sorting.

Regards

21

cannot await it. :wink: