Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Query not returning any results in Data Output or messages #8339

Open
bam95899 opened this issue Jan 7, 2025 · 4 comments
Open

Query not returning any results in Data Output or messages #8339

bam95899 opened this issue Jan 7, 2025 · 4 comments
Assignees
@bam95899
Labels
Bug

Comments

@bam95899
Copy link

bam95899 commented Jan 7, 2025

Describe the bug

PgAdmin4 version: 8.13

I try to write and run a query but no results are populated. When query runs it opens messages tab and nothing is displayed in that tab or the data output tab.

To Reproduce

Honestly I don't know and this isn't going to make the problem any easier to solve. This seems to be an infrequent ongoing issue with pgadmin4. Other comments on threads I found suggested turning off autocompletion in preferences but mine was already off as well as resetting the layout which didn't work either.

Expected behavior

I expect the query to return the results. I can use View/Edit Data -> All Rows to see that the data exists and should be returned. I can also run the query directly in postgres and the data is returned.

Error message

No discernible error message

Screenshots

pgadmin4_dataoutput

pgadmin4_message

Desktop (please complete the following information):

  • OS: Linux
  • Version: Alpine v3.20
  • Mode: Server
  • Browser Chrome 131.0.0.0
  • Package type: Python

Additional context

N/A
@bam95899 bam95899 added the Bug label Jan 7, 2025
@khushboovashi
Copy link
Contributor

Hi @bam95899,

Did you get any Javascript errors (you can check in the browser's console) or anything in the pgAdmin log?

@bam95899
Copy link
Author

bam95899 commented Jan 8, 2025

Hi @khushboovashi

Totally didn't think to even look in console logs.

These errors show up when trying to generate a select script and then trying to execute the script and then trying to execute the query.

Forbidden gives me the impression that I am missing some sort of permissions, although the user I am using has the Administrator role which I would assume would give me permission to do anything.

Please let me know if this is a configuration error on my part or not

Thanks!

       POST url/settings/store 403 (Forbidden)

(anonymous) @ vendor.others.js?ver=81300:312

xhr @ vendor.others.js?ver=81300:312

at @ vendor.others.js?ver=81300:312

_request @ vendor.others.js?ver=81300:312

request @ vendor.others.js?ver=81300:312

(anonymous) @ vendor.others.js?ver=81300:312

push.86425.toString @ vendor.others.js?ver=81300:312

saveLayout @ app.bundle.js?ver=81300:1

onLayoutChange @ app.bundle.js?ver=81300:1

changeLayout @ vendor.others.js?ver=81300:312

dockMove @ vendor.others.js?ver=81300:312

openTab @ app.bundle.js?ver=81300:1

(anonymous) @ app.bundle.js?ver=81300:1

(anonymous) @ app.bundle.js?ver=81300:1

Promise.then

(anonymous) @ app.bundle.js?ver=81300:1

Promise.then

fireEvent @ app.bundle.js?ver=81300:1

trigger @ app.bundle.js?ver=81300:1

launch @ OneToManyLink.jsx:87

c @ OneToManyLink.jsx:87

d.83967.t.showQueryTool @ OneToManyLink.jsx:87

showQueryTool @ OneToManyLink.jsx:87

show_script @ pgadmin_commons.js?ver=81300:1

callback @ app.bundle.js?ver=81300:1

onClick @ app.bundle.js?ver=81300:1

a @ vendor.others.js?ver=81300:312

C @ vendor.others.js?ver=81300:312

Oe @ vendor.react.js?ver=81300:2

He @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

Nr @ vendor.react.js?ver=81300:2

Ar @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

ss @ vendor.react.js?ver=81300:2

Me @ vendor.react.js?ver=81300:2

Vr @ vendor.react.js?ver=81300:2

Qt @ vendor.react.js?ver=81300:2

Ut @ vendor.react.js?ver=81300:2Understand this errorAI

vendor.others.js?ver=81300:312

        

        

       POST url/sqleditor/query_tool/start/5778593 403 (Forbidden)

(anonymous) @ vendor.others.js?ver=81300:312

xhr @ vendor.others.js?ver=81300:312

at @ vendor.others.js?ver=81300:312

_request @ vendor.others.js?ver=81300:312

request @ vendor.others.js?ver=81300:312

(anonymous) @ vendor.others.js?ver=81300:312

push.86425.toString @ vendor.others.js?ver=81300:312

postExecutionApi @ sqleditor.js?ver=81300:1

startExecution @ sqleditor.js?ver=81300:1

(anonymous) @ sqleditor.js?ver=81300:1

h @ sqleditor.js?ver=81300:1

le @ sqleditor.js?ver=81300:1

(anonymous) @ sqleditor.js?ver=81300:1

Promise.then

(anonymous) @ sqleditor.js?ver=81300:1

Promise.then

fireEvent @ sqleditor.js?ver=81300:1

j @ sqleditor.js?ver=81300:1

(anonymous) @ sqleditor.js?ver=81300:1

Promise.then

(anonymous) @ sqleditor.js?ver=81300:1

Promise.then

fireEvent @ sqleditor.js?ver=81300:1

(anonymous) @ sqleditor.js?ver=81300:1

Oe @ vendor.react.js?ver=81300:2

He @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

Nr @ vendor.react.js?ver=81300:2

Ar @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

ss @ vendor.react.js?ver=81300:2

Me @ vendor.react.js?ver=81300:2

Vr @ vendor.react.js?ver=81300:2

Qt @ vendor.react.js?ver=81300:2

Ut @ vendor.react.js?ver=81300:2Understand this errorAI

vendor.others.js?ver=81300:312

        

        

       PUT url/preferences/update 403 (Forbidden)

(anonymous) @ vendor.others.js?ver=81300:312

xhr @ vendor.others.js?ver=81300:312

at @ vendor.others.js?ver=81300:312

_request @ vendor.others.js?ver=81300:312

request @ vendor.others.js?ver=81300:312

(anonymous) @ vendor.others.js?ver=81300:312

push.86425.toString @ vendor.others.js?ver=81300:312

setPreference @ sqleditor.js?ver=81300:1

onContinue @ sqleditor.js?ver=81300:1

onClick @ sqleditor.js?ver=81300:1

Oe @ vendor.react.js?ver=81300:2

He @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

Nr @ vendor.react.js?ver=81300:2

Ar @ vendor.react.js?ver=81300:2

(anonymous) @ vendor.react.js?ver=81300:2

ss @ vendor.react.js?ver=81300:2

Me @ vendor.react.js?ver=81300:2

Vr @ vendor.react.js?ver=81300:2

Qt @ vendor.react.js?ver=81300:2

Ut @ vendor.react.js?ver=81300:2Understand this errorAI

vendor.others.js?ver=81300:312 Uncaught (in promise) q {message: 'Request failed with status code 403', name: 'AxiosError', code: 'ERR_BAD_REQUEST', config: {…}, request: XMLHttpRequest, …}

@khushboovashi
Copy link
Contributor

@bam95899, please provide the pgAdmin logs too.

@bam95899
Copy link
Author

bam95899 commented Jan 9, 2025

@khushboovashi

These are the logs following the same steps above (select query -> run query -> execute query)

10.10.10.10 - - [09/Jan/2025:19:47:19 +0000] "GET / HTTP/1.1" 302 213 "-" "-"

10.10.10.10 - - [09/Jan/2025:19:47:20 +0000] "GET /sqleditor/status/4288684 HTTP/1.1" 200 156 "url/sqleditor/panel/4288684?is_query_tool=true&sgid=1&sid=1&did=24739&database_name=dev" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

10.10.10.10 - - [09/Jan/2025:19:47:22 +0000] "GET /sqleditor/status/4288684 HTTP/1.1" 200 156 "url/sqleditor/panel/4288684?is_query_tool=true&sgid=1&sid=1&did=24739&database_name=dev" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

10.10.10.10 - - [09/Jan/2025:19:47:22 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "url/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

10.10.10.10 - - [09/Jan/2025:19:47:24 +0000] "GET /sqleditor/status/4288684 HTTP/1.1" 200 156 "url/sqleditor/panel/4288684?is_query_tool=true&sgid=1&sid=1&did=24739&database_name=dev" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

10.10.10.10 - - [09/Jan/2025:19:47:26 +0000] "GET /sqleditor/status/4288684 HTTP/1.1" 200 156 "url/sqleditor/panel/4288684?is_query_tool=true&sgid=1&sid=1&did=24739&database_name=dev" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

10.10.10.10 - - [09/Jan/2025:19:47:28 +0000] "GET /sqleditor/status/4288684 HTTP/1.1" 200 156 "url/sqleditor/panel/4288684?is_query_tool=true&sgid=1&sid=1&did=24739&database_name=dev" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[131.0.0.0](http://131.0.0.0/) Safari/537.36"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@bam95899 bam95899

Labels
Bug
Projects
Not Refined
Status: No status
Milestone
No milestone
Development

No branches or pull requests
2 participants
@khushboovashi @bam95899