X
Xata•3w ago
November

Error: Out of Memory when creating a new sequence on pg-enabled DBs

I'm looking to create a new sequence, but it doesn't look like the pg instance is letting me create one- 
# When running then
CREATE SEQUENCE foo_bar_id_seq MINVALUE 20;

# Results in this error
ERROR:  out of memory
DETAIL:  Failed on request of size 8192.
CONTEXT:  SQL statement "SELECT COUNT(*)
            FROM pg_class C
            WHERE C.relnamespace = quote_ident(r_schema_name)::regnamespace::oid"
PL/pgSQL function xata_private.check_object_count() line 11 at SQL statement

# Or this error
ERROR:  out of memory
DETAIL:  Failed on request of size 8192.
CONTEXT:  SQL statement "SELECT COUNT(*)
            FROM pg_class C
            WHERE C.relnamespace = quote_ident(r_schema_name)::regnamespace::oid"
PL/pgSQL function xata_private.check_object_count() line 11 at SQL statement
# When running then
CREATE SEQUENCE foo_bar_id_seq MINVALUE 20;

# Results in this error
ERROR:  out of memory
DETAIL:  Failed on request of size 8192.
CONTEXT:  SQL statement "SELECT COUNT(*)
            FROM pg_class C
            WHERE C.relnamespace = quote_ident(r_schema_name)::regnamespace::oid"
PL/pgSQL function xata_private.check_object_count() line 11 at SQL statement

# Or this error
ERROR:  out of memory
DETAIL:  Failed on request of size 8192.
CONTEXT:  SQL statement "SELECT COUNT(*)
            FROM pg_class C
            WHERE C.relnamespace = quote_ident(r_schema_name)::regnamespace::oid"
PL/pgSQL function xata_private.check_object_count() line 11 at SQL statement
Given that my memory usage is still in the kilobytes (pic attached) and well below the cap, is this just a temporary issue because of some capacity issues of the shared host, or have I run into an implicit limit somewhere?
No description
1 Reply
November
NovemberOP•3w ago
For reference, I was able to create other sequences before I started getting this error (around 10pm est so maybe an internal-to-xata cron job kicked off that spiked mem usage?) This issue seems to have been transitory, I'm now able to create my sequence and do other operations just fine, so closing out this thread

Did you find this page helpful?