Issues using the main search functionality. #7256

pyhtoncoder0 · 2024-05-18T10:01:19Z

pyhtoncoder0
May 18, 2024

I've been running Inventree for about 3 months now. I've had some hiccups along the way. However each time it turns out to be something simple. I'm hoping this is as well.

I can no longer search for anything. The box works fine and my users can attempt to search. However all fields return nothing. Literally nothing comes up for any search term I've tried. I do have the system set to search part and stock categories. I didn't notice the issue after an update so I don't believe this was update triggered. I have however been messing with the settings a bit as of recent. I've been making small changes to remove functionality we don't use from what my team sees. Build orders and such. Non of my users complained about the searching issue for seemingly some time so I have no real ETA on when this happened. Could have been me messing with the settings. Could have been something else. I have looked over my settings pages like 20 times now. I have no errors reporting. Everything seems to be as it should. Does anyone have an idea where I should start trouble shooting? Not sure if I'm allowed to dump a bunch of screen shots but I'm willing to share settings configurations if needed. I however am not sure what info would be best helpful. Shooting in the dark a little ATM.

---Edit to this. I am now receiving errors.---

Error object (23)
HISTORY

Type:
ProgrammingError
Path:
/api/part/
Info:
more than one row returned by a subquery used as an expression
When:
May 18, 2024, 3:02 p.m.
Data:
Traceback (most recent call last):

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 732, in execute
raise ex.with_traceback(None)

psycopg.errors.CardinalityViolation: more than one row returned by a subquery used as an expression

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/root/.local/lib/python3.11/site-packages/rest_framework/views.py", line 506, in dispatch
response = handler(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/InvenTree/api.py", line 414, in get
return super().get(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/rest_framework/generics.py", line 239, in get
return self.list(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/part/api.py", line 1224, in list
queryset = self.filter_queryset(self.get_queryset())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/part/api.py", line 1286, in filter_queryset
for prt in queryset:

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 398, in iter
self._fetch_all()

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 91, in iter
results = compiler.execute_sql(
^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
with self.db.wrap_database_errors:

File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 732, in execute
raise ex.with_traceback(None)

django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression

pyhtoncoder0 · 2024-05-18T23:43:16Z

pyhtoncoder0
May 18, 2024
Author

So, I came to the project this morning and now it works. I don't even know what to say. I left the project not being able to search but when I opened this up for the day everything is working as it should today. I didn't make any edits. No setting changes. I called a friend to get his help with the API errors, however when I went to demo the issue it had resolved itself.

1 reply

matmair May 27, 2024
Maintainer

@pyhtoncoder0 so can we close this?

SchrodingersGat · 2024-05-19T01:51:48Z

SchrodingersGat
May 19, 2024
Maintainer

@pyhtoncoder0 for reference what version of InvenTree are you running?

6 replies

SchrodingersGat May 20, 2024
Maintainer

What database backend are you using? sqlite or postgresql?

pyhtoncoder0 May 20, 2024
Author

postgresql

pyhtoncoder0 May 20, 2024
Author

I'm sorry for being a doof. I'm new to the admin world. I will include all requested info in my future posts.

pyhtoncoder0 May 20, 2024
Author

It might also be worth mentioning that I get the same exact error for /api/stock

SchrodingersGat May 20, 2024
Maintainer

@pyhtoncoder0 can you share the specific error message in this instance?

SchrodingersGat · 2024-05-20T06:35:13Z

SchrodingersGat
May 20, 2024
Maintainer

@pyhtoncoder0 no need to apologize, it looks like you may be seeing a real (novel) error message here. Certainly worth investigation.

3 replies

pyhtoncoder0 May 21, 2024
Author

I messed up a little bit. I was getting so many of the same or similar errors I deleted in batches. I no longer have a report for /api/stock. Only errors for /api/part now. If I can source one at a later time I will update in this thread.

I've been playing with some things slowly however I have been unable to source the issue. The only additional info I can think to give is the error seems to pop up any time someone logs in. I'm guessing each time someone logs in the system is doing a small search/update for that user and scans the DB. It finds the bad info and kicks the error. (This is all a guess tho) I am unsure what entries are not being liked. I'd be willing to remove all records for those entries if I knew what they where. I can go source those products and readd/reassign barcodes.

The system seems to be running fine. I have searchability back. Not sure why it wasn't working still. But happy to have it back TBH. I'm not sure the errors are stopping anything from running. And I haven't had any issues adding new parts/stock alike and or moving those assets in the system.

Things I've done to solve the issues/rebuild the broken data

Repulled images and redeployed InvenTree
Ran "invoke update" to update the database (I remember the docs mentioning this will rebuild and update the database)
searched manually for broken entries (I don't really know what I'm looking for I'm just trying all kinds of stuff at this point)
Removed "Stock Ownership Control" as I was having permission issues with this. I didn't realize other users could not update stock notes for an item owned by someone else. Ownership is not of huge issue to us so I turned it off. This was one of the settings I had been messing around with originally.

SchrodingersGat May 21, 2024
Maintainer

Not really enough information to go on here, but at least your setup is working, I suppose. If you do get any further error logs please share them here. Perhaps we can get to the bottom of it.

pyhtoncoder0 May 21, 2024
Author

This is the most recent error, still nothing from /api/stock all 100ish of the errors are /api/part now:

Type:
ProgrammingError
Path:
/api/part/
Info:
more than one row returned by a subquery used as an expression
When:
May 21, 2024, 2:51 p.m.
Data:
Traceback (most recent call last):

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 732, in execute
raise ex.with_traceback(None)

psycopg.errors.CardinalityViolation: more than one row returned by a subquery used as an expression


The above exception was the direct cause of the following exception:


Traceback (most recent call last):

File "/root/.local/lib/python3.11/site-packages/rest_framework/views.py", line 506, in dispatch
response = handler(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/InvenTree/api.py", line 414, in get
return super().get(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/rest_framework/generics.py", line 239, in get
return self.list(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/part/api.py", line 1224, in list
queryset = self.filter_queryset(self.get_queryset())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/home/inventree/src/backend/InvenTree/part/api.py", line 1286, in filter_queryset
for prt in queryset:

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 398, in __iter__
self._fetch_all()

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 91, in __iter__
results = compiler.execute_sql(
^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
with self.db.wrap_database_errors:

File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value

File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 732, in execute
raise ex.with_traceback(None)

django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression

pyhtoncoder0 · 2024-05-27T22:11:19Z

pyhtoncoder0
May 27, 2024
Author

I have not been able to solve the issue. Search ability is back but I’m still receiving error messages about extra entry’s. I already closed this once and someone reopened it. You can close it if you would like. However I’m still messing with the errors. Unfortunately I don’t get to work on it every day. Next Wednesday I’ll be on-site for that location to work on their systems. InvenTree is one of those systems. I’ll know more then. pyhton-coder

…

On Mon, May 27, 2024 at 2:02 PM Matthias Mair ***@***.***> wrote: @pyhtoncoder0 <https://github.com/pyhtoncoder0> so can we close this? — Reply to this email directly, view it on GitHub <#7256 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APBD7TO66TLCWNSARKRRKHTZEOGLVAVCNFSM6AAAAABH5KS3Y6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKNZTGUZDO> . You are receiving this because you were mentioned.Message ID: ***@***.***>

0 replies

pyhtoncoder0 · 2024-05-30T08:35:26Z

pyhtoncoder0
May 30, 2024
Author

I found examples of not being able to search today. I did find that the issue is not always for every user. I had issues on my local admin account. However when someone signed out and in to their account on the same machine search had returned. With this information I killed all my active connections to the server. Then signed back in. Again no search. I tried the demo (Amazing work by the way. My team is chanting for it). The search works in the new demo. I then opened a new tab into the production version and search had returned.

…

On Mon, May 27, 2024 at 4:11 PM pyhtoncoder ***@***.***> wrote: I have not been able to solve the issue. Search ability is back but I’m still receiving error messages about extra entry’s. I already closed this once and someone reopened it. You can close it if you would like. However I’m still messing with the errors. Unfortunately I don’t get to work on it every day. Next Wednesday I’ll be on-site for that location to work on their systems. InvenTree is one of those systems. I’ll know more then. pyhton-coder On Mon, May 27, 2024 at 2:02 PM Matthias Mair ***@***.***> wrote: > @pyhtoncoder0 <https://github.com/pyhtoncoder0> so can we close this? > > — > Reply to this email directly, view it on GitHub > <#7256 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/APBD7TO66TLCWNSARKRRKHTZEOGLVAVCNFSM6AAAAABH5KS3Y6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKNZTGUZDO> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

-- pyhton-coder

0 replies

SchrodingersGat · 2024-05-30T09:02:12Z

SchrodingersGat
May 30, 2024
Maintainer

One point which has not been covered yet - what version of InvenTree are you running?

0 replies

pyhtoncoder0 · 2024-05-30T17:57:56Z

pyhtoncoder0
May 30, 2024
Author

Versions: Python 3.11.9 Django 4.2.12 InvenTree 0.15.3 API 196 Node NA Yarn NA pyhton-coder

…

On Thu, May 30, 2024 at 3:02 AM Oliver ***@***.***> wrote: One point which has not been covered yet - what version of InvenTree are you running? — Reply to this email directly, view it on GitHub <#7256 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APBD7TKYYSCLL23D6ZCUN3DZE3TKVAVCNFSM6AAAAABH5KS3Y6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TMMBTGQYTM> . You are receiving this because you were mentioned.Message ID: ***@***.***>

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Issues using the main search functionality. #7256

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 7 comments 10 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Issues using the main search functionality. #7256

pyhtoncoder0 May 18, 2024

Replies: 7 comments · 10 replies

pyhtoncoder0 May 18, 2024 Author

matmair May 27, 2024 Maintainer

SchrodingersGat May 19, 2024 Maintainer

SchrodingersGat May 20, 2024 Maintainer

pyhtoncoder0 May 20, 2024 Author

pyhtoncoder0 May 20, 2024 Author

pyhtoncoder0 May 20, 2024 Author

SchrodingersGat May 20, 2024 Maintainer

SchrodingersGat May 20, 2024 Maintainer

pyhtoncoder0 May 21, 2024 Author

SchrodingersGat May 21, 2024 Maintainer

pyhtoncoder0 May 21, 2024 Author

pyhtoncoder0 May 27, 2024 Author

pyhtoncoder0 May 30, 2024 Author

SchrodingersGat May 30, 2024 Maintainer

pyhtoncoder0 May 30, 2024 Author

pyhtoncoder0
May 18, 2024

Replies: 7 comments 10 replies

pyhtoncoder0
May 18, 2024
Author

matmair May 27, 2024
Maintainer

SchrodingersGat
May 19, 2024
Maintainer

SchrodingersGat May 20, 2024
Maintainer

pyhtoncoder0 May 20, 2024
Author

pyhtoncoder0 May 20, 2024
Author

pyhtoncoder0 May 20, 2024
Author

SchrodingersGat May 20, 2024
Maintainer

SchrodingersGat
May 20, 2024
Maintainer

pyhtoncoder0 May 21, 2024
Author

SchrodingersGat May 21, 2024
Maintainer

pyhtoncoder0 May 21, 2024
Author

pyhtoncoder0
May 27, 2024
Author

pyhtoncoder0
May 30, 2024
Author

SchrodingersGat
May 30, 2024
Maintainer

pyhtoncoder0
May 30, 2024
Author