IceCactus Comments - Windmill

IceCactus

•Created by IceCactus on 11/29/2023 in #help

crash

Thx for the help

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

I cant verify it, but i think what is i had run the script without limiting the number of rows processed. So it ran for 30 seconds or so and generated huge output since i was debugging. I hit the cancel button and the browser crashed for a bit then came back. Im guessing the output was to big. The table size was 1.94mb and the TOAST size was 904mb. so something large in there. Went i looked at queue table, and saw the script in there, i just deleted the two rows since that script was just a test and not scheduled or anything.

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

I think i got it fixed, there was 4 records in the table, two of which were from the script we talked about. the log between the two was about 100mb. I just deleted the two records and all seems well now.

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

can i truncate that table?

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

well using pgadmin i cant view any rows on that table, i get bad request error.

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

Ill look at the table and see if i see anything

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

should be less then million

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

so like, console.log() many many times

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

ok, ill take a look, would a large logout cuase an issue when testing a script during editing?

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

so file from a shared folded on the vm, then written back out to a shared folder on the VM

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

it was read through a stream, modified then wrote back to a stream

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

so i was using javascript in bun to process a large csv file, it was using streams and got to about 230mb

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

ok

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

or filename, but its worked for days so not sure why it would cause issue now

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

nor was it input, the file was the input

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

well, it wasnt setup a a job

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

Its possible, i was parsing some very large csv files

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

if you look at the log output, it seems to be occuring with a listen event from the db

76 replies

•Created by IceCactus on 11/29/2023 in #help

crash

ive limited it to only 1 worker and 1 native at the moment

76 replies