IceCactus
IceCactus
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
Thx for the help
76 replies
WWindmill
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
WWindmill
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
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
can i truncate that table?
76 replies
WWindmill
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
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
Ill look at the table and see if i see anything
76 replies
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
should be less then million
76 replies
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
so like, console.log() many many times
76 replies
WWindmill
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
WWindmill
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
WWindmill
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
WWindmill
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
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
ok
76 replies
WWindmill
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
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
nor was it input, the file was the input
76 replies
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
well, it wasnt setup a a job
76 replies
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
Its possible, i was parsing some very large csv files
76 replies
WWindmill
Created by IceCactus on 11/29/2023 in #help
crash
76 replies
WWindmill
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
WWindmill
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