Table blocks always returns "no rows found" even data already exist

[thanhpd56]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: k8s
  • Budibase v2.8.10
  • App Version: v2.8.10
  • Tenant ID: self hosted

Describe the bug
Try to display data of mysql table by table block component, but it always shows "no rows found"

To Reproduce
Steps to reproduce the behavior:

1. In the data connect 1 table of mysql
2. Click create new screen with list view (table block default)
3. Watch the data

Expected behavior
The table always show "no rows found". I have tried to connect several tables but the results are the same.
Screenshots
Banner table:

Banner screen:

App Export

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context
If I change to grid view component, then data is show up as nornal.

[thanhpd56]

@melohagan please help.

[aptkingston]

@thanhpd56 are you sure you don't have a filter set on your table block?

There are no differences between how the table block and grid block fetch data from a table. If one works, the other will work too, unless you have other settings which are interfering.

Please share screenshots of the settings of your table block.

[thanhpd56]

@aptkingston just default one. I don't customize anything.

[thanhpd56]

[thanhpd56]

Grid is working well.

[thanhpd56]

@aptkingston Sorry for bothering you, but I really need your help.

[aptkingston]

Does the internal DB work? For example the sample data?

[thanhpd56]

[error] 2023-07-25T10:19:48.732496Z couchdb@couchdb-couchdb-0.couchdb-couchdb.database.svc.cluster.local <0.4941.0> -------- ** 'couchdb@couchdb-couchdb-0.couchdb-couchdb.database.svc.cluster.local': Connection attempt to node 'clouseau@127.0.0.1' aborted since it cannot handle ["BIG_CREATION"].**
When I create new app from sample data, I got this error. I deployed Budibase to K8S cluster by helmchart. :(

[aptkingston]

Going to convert this to a discussion since it seems like an environment issue.

[thanhpd56]

Screen.Recording.2023-07-26.at.09.35.35.mov

@aptkingston I recreated Budibase with couchdb cluster size = 1 then be able to create new app from sample data successfully. However, table block still shows empty even data already existed.
Beside that, as you can see from screen, I see that Budibase call 2 search requests to get data, first request returns rows, second request returns no data. Is that the cause of problem?

[thanhpd56]

Hi, I guess I found where is the problem come from. Instead of using ingress of k8s (contour) with domain, I try to port-forward and access with localhost:10000 then the data is show-up. Is there any special ingress configuration that I need to aware?

[thanhpd56]

Seem like websocket problem - pending forever.

[thanhpd56]

apiVersion: projectcontour.io/v1
kind: HTTPProxy
metadata:
  labels:
    app.kubernetes.io/instance: budibase
    app.kubernetes.io/version: 1.0.0
  name: budibase
  namespace: budibase
spec:
  routes:
    - conditions:
        - prefix: /
      enableWebsockets: true # Setting this to true enables websocket for all paths that match /
      services:
        - name: proxy-service
          port: 10000
      timeoutPolicy:
        response: 500m
        idle: 100m
      responseHeadersPolicy:
        set:
          - name: Content-Security-Policy
            value: "default-src 'self' 'unsafe-inline' js.intercomcdn.com widget.intercom.io s3.ap-southeast-1.amazonaws.com *.budibase.net *.budi.live js.intercomcdn.widget.intercom.io *.amazonaws.com *.posthog.com *.c-group.global; frame-ancestors 'self' http://localhost:3000"
          - name: Strict-Transport-Security
            value: max-age=31536000; includeSubDomains
  virtualhost:
    corsPolicy:
      allowCredentials: true
      allowHeaders:
        - '*'
      allowMethods:
        - '*'
      allowOrigin:
        - '*'
      maxAge: 1h
    fqdn: ***
    tls:
      secretName: ***

[imadal1n]

I have the same problem running on docker with Traefik proxy. Working well when I comment out ContentSecurityPolicy: default-src 'self' 'unsafe-inline' from Traefik middleware.

[thanhpd56]

@imadal1n thank you so much. I'ts working now. I spent about 2 weeks just about this issue. :(

[ZimM-LostPolygon]

I'm having the same issue, however, this only happens for a single PostgreSQL table. I can see the data is fetched just fine in network requests in browser devtools, however the table doesn't actually display any rows. Not using Traefik or anything like that. Any ideas?..

Update: Grid works fine, the Table doesn't. There aren't any filters or other customizations on the Table.

[melohagan]

Hey @ZimM-LostPolygon Would you be able to share the SQL schema of your Postgres table that isn't loading correctly in a table please?
To clarify is it a Table block that the data wont load for?

Does your postgres table have any of the following defined within Budibase?

• User columns
• Relationship columns
• Formulas

[ZimM-LostPolygon]

Both the Table block and the Table component (after ejecting the Table block) show no rows. Repeater doesn't seems to work either... So I guess the problem is in DataProvider, not Table? Grid does work. The PostgreSQL table is as simple as it gets, this is all of it, no user columns, relationships, formulas etc:

CREATE TABLE "KeyValuePair" (
    "key" TEXT NOT NULL,
    "value" TEXT NOT NULL,
    "isPublic" BOOLEAN NOT NULL,

    CONSTRAINT "KeyValuePair_pkey" PRIMARY KEY ("key")
);

[melohagan]

Thanks @ZimM-LostPolygon I'll try to recreate

[melohagan]

@ZimM-LostPolygon Gave this a quick test and I am not seeing the issue.

Would you be able to share an app export? Also have you definitely selected the Dataprovider as the source of your table?

Also what version of Budibase are you running?