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

Anvil Q&A
21

Same issue here while trying to add rows to one of my data tables. I’m on the business plan.

22

I truly love Anvil and appreciate the effort the team puts in… But the frequent downtime feels hard to justify for the price…

3 Likes
23

I’m having the same issues and it is frustrating but FWIW I would say that 1) the Anvil staff are very responsive when there’s an issue, 2) they usually prioritize fixing the issue before they start posting about it.

Lots of people have emailed support so I’m sure they are aware and working on the issue.

I’m off to make a cup of tea…

1 Like
24

I think a couple of employees in a +12 to -7 UTC would probably be a good addition to cover their timezones with overlap in schedule. I’m -7 with little skill and a lot of heart, if @anvil would like to hire me! :joy:

1 Like
25

All my apps are also down, throwing the same error:
“anvil.tables.TableError: Internal database error: ERROR: nextval: reached maximum value of sequence “app_storage_data_id_seq” (2147483647)”

26

same problem. also emailed support

27

Update - we’re aware of the issue and investigating

6 Likes
28

Thanks Stu! We appreciate the team working on it and the update.

29

Hi folks,

Sorry about this, and thanks for your patience. The issue should now be resolved - please post here to let us know if you’re still seeing the problem.

This was affecting users on shared-hosting plans, specifically preventing new rows from being added to data tables. Users on the Dedicated plan, those with Extra Server Resources, and Enterprise users were unaffected.

We will obviously investigate to work out the root cause here, but in the meantime everything should be back up and running.

5 Likes
30

Thanks @daviesian! Standard row_add is working for us.
Batch add is still having problems:

“anvil.tables.TableError: Internal database error: Batch entry 0 UPDATE app_storage_media SET row_id = (‘2147490534’::int8) WHERE object_id = ANY(?) was aborted: ERROR: integer out of range Call getNextException to see other errors in the batch.”

31

Thanks @connor.colling - we’re looking into that now.

32

Thanks!
Correction it looks like it is still the standard add_row (using beta accelerated tables)

Tripping Line:
Product_Row = app_tables.created_products.add_row(**Row_Info)

Error:
anvil.tables.TableError: Internal database error: Batch entry 0 UPDATE app_storage_media SET row_id = (‘2147490534’::int8) WHERE object_id = ANY(?) was aborted: ERROR: integer out of range Call getNextException to see other errors in the batch.

33

@daviesian I deactivated accelerated tables and things look like they are processing normally.

EDIT: Status Updates
App ID: QAZ2O25MFSZVKEOZ still having trouble (no accelerated tables)
App ID: IKFRKPRSAQMLDHH2 still having trouble (using accelerated tables)
App ID: SMJJ6AB4XMKIHVKW working with accelerated tables off, not working when accelerated tables are active.

All have the same error:
anvil.tables.TableError: Internal database error: Batch entry 0 UPDATE app_storage_media SET row_id = (‘2147520056’::int8) WHERE object_id = (‘299737946’::int4) was aborted: ERROR: integer out of range Call getNextException to see other errors in the batch.
strong text

Update

APP ID: 6HNKDMY3LQ7LTI4R
(dedicated resource, business plan, accelerated tables)

Latest error as of 1-23-2025 6:06 PM CST
anvil.tables.TableError: Internal database error: ERROR: syntax error at or near “-”

34

I am still receiving the following error. “anvil.tables.TableError: Internal database error: Batch entry 0 UPDATE app_storage_media SET row_id = (‘2147528167’::int8) WHERE object_id = ANY(?) was aborted: ERROR: integer out of range Call getNextException to see other errors in the batch.” Even after disabling accelerated tables

35

UPDATE: Issue resolved for me just now.

I can use the GUI to manually add a row.
When using the server console I get an error

from anvil.tables import app_tables
app_tables.env.add_row(key='test')
anvil.tables.TableError: Internal database error: Batch entry 0 UPDATE app_storage_media SET row_id = ('2147538221'::int8) WHERE object_id = ANY(?) was aborted: ERROR: integer out of range Call getNextException to see other errors in the batch.

I’m using accelerated data tables.

36

Just a note: We are not using accelerated tables, and our app seems to be working so far

Edit: We are not able to edit data through the IDE similar to @racersmith issue below

37

Here everything works well with and without accelerated tables

Thank you

38

I’m trying to reproduce this with a simple example but I’m seeing this error in one app:

TableError: Internal database error: ERROR: syntax error at or near "-"  Position: 43
39

We are still facing this in some apps:

anvil.tables.TableError: Internal database error: ERROR: syntax error at or near “-” Position: 43
<running on the server>
called from /home/anvil/downlink/anvil/tables/v2/_row.py, line 772
called from /home/anvil/downlink/anvil/tables/v2/_row.py, line 717

40

Seeing the same here
anvil.tables.TableError: Internal database error: ERROR: syntax error at or near “-”