Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

fix "could not resize shared memory segment \"/PostgreSQL.3471707482\" to 25223168 bytes: No space left on device" error #23

Closed
xat opened this issue Aug 18, 2022 · 2 comments
Closed

fix "could not resize shared memory segment \"/PostgreSQL.3471707482\" to 25223168 bytes: No space left on device" error #23

xat opened this issue Aug 18, 2022 · 2 comments

Comments

@xat
Copy link
Contributor

xat commented Aug 18, 2022 •
edited
Loading

test query:

query SalesByToken($after: timestamptz!) {
                events(where: {implements: {_eq: "SALE"}, timestamp: {_gt: $after}, _or: [
{fa2_address: {_eq: "KT1TvkNHF6xoK8JGaftsbzpeydb3n2GoaBhN"}, token_id: {_eq: "4"}},
{fa2_address: {_eq: "KT1TvkNHF6xoK8JGaftsbzpeydb3n2GoaBhN"}, token_id: {_eq: "5"}},
{fa2_address: {_eq: "KT1TvkNHF6xoK8JGaftsbzpeydb3n2GoaBhN"}, token_id: {_eq: "6"}},
{fa2_address: {_eq: "KT1TvkNHF6xoK8JGaftsbzpeydb3n2GoaBhN"}, token_id: {_eq: "7"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "10"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "11"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "12"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "2"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "3"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "4"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "5"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "6"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "7"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "8"}},
{fa2_address: {_eq: "KT1Twm5U7DnDCG8ooshinW3yVp3YzkmrjesC"}, token_id: {_eq: "9"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "2"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "3"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "4"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "5"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "6"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "7"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "8"}},
{fa2_address: {_eq: "KT1Txh3akBfgTtxQL7wfb9ntpDszm4P9vg7y"}, token_id: {_eq: "9"}},
{fa2_address: {_eq: "KT1TxxqJZpTt5aQpZchKSi3k6Hs6u86nCxUt"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1TxxqJZpTt5aQpZchKSi3k6Hs6u86nCxUt"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1TxxqJZpTt5aQpZchKSi3k6Hs6u86nCxUt"}, token_id: {_eq: "2"}},
{fa2_address: {_eq: "KT1TxxqJZpTt5aQpZchKSi3k6Hs6u86nCxUt"}, token_id: {_eq: "3"}},
{fa2_address: {_eq: "KT1U2Tt3exPN8YRv9B9zCt5QFrisKv5sqDFX"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1U2Tt3exPN8YRv9B9zCt5QFrisKv5sqDFX"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1U2Tt3exPN8YRv9B9zCt5QFrisKv5sqDFX"}, token_id: {_eq: "2"}},
{fa2_address: {_eq: "KT1U2rvXaEmxRcSohMHRvSEwM92PX4F6eSRT"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1U2rvXaEmxRcSohMHRvSEwM92PX4F6eSRT"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1U2rvXaEmxRcSohMHRvSEwM92PX4F6eSRT"}, token_id: {_eq: "2"}},
{fa2_address: {_eq: "KT1U5o9YotTJGfF6H6yo4ZJwetPx1sLVSJzD"}, token_id: {_eq: "0"}},
{fa2_address: {_eq: "KT1U5o9YotTJGfF6H6yo4ZJwetPx1sLVSJzD"}, token_id: {_eq: "1"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1004958"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016185"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016208"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016321"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016719"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016907"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1016927"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1017050"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1017116"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1017123"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1018681"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1019000"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020388"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020393"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020458"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020459"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020469"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020529"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020530"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020577"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020587"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020589"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020598"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020600"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020602"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020603"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020620"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020632"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020635"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020645"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020673"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020684"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020707"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020709"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020717"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020722"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020727"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020741"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020744"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020745"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020766"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020770"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020781"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020783"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020786"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020793"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020814"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020818"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020819"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020821"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020830"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020831"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020844"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020905"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020911"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1020960"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021002"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021096"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021139"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021206"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021207"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021214"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021685"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1021687"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1022062"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1022251"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1050187"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1055675"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056500"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056512"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056538"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056643"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056650"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1056667"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1058338"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1058352"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1058482"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1058483"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1058637"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1060437"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1060860"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1060947"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1060980"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1061007"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1061410"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1061411"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1061444"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1061724"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062202"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062206"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062245"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062283"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062288"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062289"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062301"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062322"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062361"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1062375"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1066989"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1067152"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1092388"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1092395"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1092533"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1092717"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1092876"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093011"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093018"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093373"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093374"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093376"}},
{fa2_address: {_eq: "KT1U6EHmNxJTkvaWJ4ThczG4FSDaHC21ssvi"}, token_id: {_eq: "1093379"}}
                ]}) {
                            fa2_address
                            token_id
                            price
                            timestamp
                            type
                            buyer_address
                            seller_address
                            implements
                            ophash
                            opid
                          }
                        }

variables:

{
      "after" : "0001-01-01T00:00:00"
}

produces this error, every once in a while:

LIMIT 50000 ) AS \"_0_root.base\"      ) AS \"_2_root\"      ",
          "prepared": true,
          "error": {
            "exec_status": "FatalError",
            "hint": null,
            "message": "could not resize shared memory segment \"/PostgreSQL.3471707482\" to 25223168 bytes: No space left on device",
            "status_code": "53100",
            "description": null
          }
@xat
Copy link
Contributor Author

xat commented Aug 19, 2022

adjusting shm-size of the postgres container should solve this. see docker-library/postgres#416

@xat
Copy link
Contributor Author

xat commented Aug 22, 2022

shm-size is now set to 4GB. let's hope that is enough :)

@xat xat closed this as completed Aug 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@xat