On 09.02.2021 at 17:07, Nick-T wrote:
> Is there any way for me to make sure that this whole space is in fact a
> temporary blob? if so how do I trace the source of the problem?
Just a wild guess (and has nothing to do with blobs, so sorry for a
digression), as I've experienced something like that in the past. Does
your code by any chance execute queries doing insert ... select ...? Or
maybe you've done it by hand? Some time ago I wanted to copy data in a
table from one year to another, something like:
insert into T (some fields, year)
select some fields, 2021
from T where year = 2020
only to make a stupid mistake:
insert into T (some fields, year)
select some fields, 2020
from T where year = 2020
and the query looped infinitely (selecting records that have just been
inserted and re-inserting them again), causing the database to keep
growing until I realized what I had done and killed the client .
Maybe it has nothing to do with your case, but I'd try to rule out the
simple causes first (and human mistake is always on top of my list).
cheers
Tomasz
________________________________
Ta wiadomość zawiera poufne informacje przeznaczone tylko dla adresata. Jeżeli nie jesteście Państwo jej adresatem, bądź otrzymaliście ją przez pomyłkę, prosimy o powiadomienie o tym nadawcy oraz trwałe jej usunięcie.