Facing database query error

[ajselvan]

query MyQuery {
  events(
    where: {data: {_contains: {user_address: "0x829faddf57a5a6c9f1563e5e3c643f9942039486a9b030517187c7baebd4fc87"}}}
    order_by: {transaction_version: desc}
    limit: 2
  ) {
    transaction_version
    data
    type
  }
}

This is my query code to fetch the events. The default limit is 100, right?

When I provide a limit of 100, I get a database query error, even though I only have 2 event entries. If I set the limit to 2, it returns the response correctly.

However, if I set a limit greater than the available event data, it returns an error. The issue is that we don't know the exact length of the event data. Could you please help me resolve this? Thank you!

[robertjdominguez]

Hey there, thanks for sharing your query and the issue you're running into @ajselvan!

From what you've described, it sounds like the behavior you're experiencing might be tied to something happening at the database level rather than with the query itself. By default, Hasura does set a limit of 100 for queries if no limit parameter is specified, so your query should work even with higher limits—especially since you mentioned there are only 2 entries in the events table.

The fact that setting the limit to 2 works but anything higher causes an error is unusual and points to a potential database constraint or some other issue in the backend. If you haven’t already, you might want to:

1. Check for any constraints or settings in the database that could be affecting large queries. For example, are there triggers, row-level constraints, or other policies applied to the table?
2. Look at the actual database logs to see if there’s a specific error or limitation being hit.

If everything looks fine at the database level and the error persists, let us know the exact error message you’re seeing. That’ll help us dig a bit deeper into what might be going on.

Hope that helps! Keep us posted. 😊

PS — I'm going to close #10637 as this is a duplicate entry.

[robertjdominguez]

@ajselvan — I'm closing this due to inactivity.

If you're still having issues and would like some help, please re-open this 🙂