[SERVICE DISRUPTION BUG] Internal database error: nextval: reached maximum value...(2147483647)

Anvil Q&A
1

When we run our app, we are getting the following error:

anvil.tables.TableError: Internal database error: ERROR: nextval: reached maximum value of sequence "app_storage_data_id_seq" (2147483647)

  • <running on the server>
  • called from /downlink/anvil/_server.py:44
  • called from ServerModule1, line 150
  • called from /downlink/anvil/_threaded_server.py:169
  • called from Form7, line 36
  • called from Form7, line 23

Is this a shared database problem? No way we’ve filled up 2 billion+

12 Likes
2

I have exactly the same problem in my own account and also on one of my clients.

2 Likes
3

We have the same issue… Seems to be a global problem

1 Like
4

Yup same problem for me too.

I’ve tried:

  • Adding a new row from the GUI. Gives a “Saved Failed: Could not save row: Unknown error”
  • Add a row from the server console
  • Add a row to an empty table.
  • Add a row to a table in a different app.
  • Changing data in a table works as expected.
  • Creating a new, blank app, adding a table and try to add a row in the GUI.
  • Tried both normal and Accelerated tables.
  • Checked I’m not exceeding my database quotas

Related post should be merged here.

5

I’ve got the same issue since a few minutes…

6

One of you who’s experiencing the problem should probably Email support@anvil.works with a link to this topic, if you haven’t already done so.

Edit: With this kind of error, they probably already know about it, but it doesn’t hurt to make sure.

1 Like
7

Same issue here, have been trying stuff like crazy and now I know is a global issue…

Hope Anvil staff is aware of this.

8

I have emailed them with the details.

2 Likes
9

getting same thing on untouched years old app that gets used all day
checked all my common tables to make sure they are gc’d and they are all ok, and account is below row quota (old style 50$/mo plan)

1 Like
10

Same issue with some of my apps as well.

11

Same here, it appears to be a global problem.

12

Same here as well. Looks like it’s a datatype issue in their database with that exact number in parenthesis being the limit until you move to BIG INT.

1 Like
13

yes, it is probably a limitation in the columns type or something else’s type that passes a value through a postgresql auto-incrementation function

14

We have this issue as well:

I thought maybe we reached the Database storage limit and emptied out rows but to no avail.

anvil.tables.TableError: Internal database error: ERROR: nextval: reached maximum value of sequence "app_storage_data_id_seq" (2147483647)

`<running on the server>`

called from /Users/admin/DY_DEV/Mia/venv_311/lib/python3.11/site-packages/anvil/tables/v2/_table.py, line 88

called from /Users/admin/DY_DEV/Mia/src/forms/pipeline/MetaMatteFix/MIA_MetaMatte_Fix.py, line 414

called from /Users/admin/DY_DEV/Mia/src/forms/pipeline/MetaMatteFix/MIA_MetaMatte_Fix.py, line 366

called from /Users/admin/DY_DEV/Mia/src/globals.py, line 390
15

Hi

I have the same issue: anvil.tables.TableError: Internal database error: ERROR: nextval: reached maximum value of sequence “app_storage_data_id_seq” (2147483647)

Many users of my app are complaining they can’t add information.

16

Same here. At least this problem made me clean up some old data which I should have cleaned anyhow.

But next time I better check the forum first.

1 Like
17

Same issue here, across multiple applications.

18

@meredydd We’re 2 hours into what my users consider a critical failure without even an acknowledgement on here from anvil staff. It would be great to hear from y’all, even if all you can say is you’re aware of the issue and investigating.

1 Like
19

hey @mapgar , can I ask if they responded at all yet?

20

The Anvil staff is based in the UK…so this happen their end of day. Also, I don’t think the messages here “@”'d anyone Anvil folks. I’ve gotten prompt responses for bugs in the past from @stucork, even on weekends.

1 Like