[I] [Bug]: Using Insert/Update transform is causing sudden burst in oracle memory usage(in my case 50 GB's). I doubt if there are any memory leakage on hop transform which is leading to this. (hop)

Thu, 22 Aug 2024 02:29:19 -0700 


pramodgsable opened a new issue, #4234:
URL: https://github.com/apache/hop/issues/4234

   ### Apache Hop version?
   
   2.8.0
   
   ### Java version?
   
   11
   
   ### Operating system
   
   macOS
   
   ### What happened?
   
   I was using insert/update transform to insert data into our RDS 
database(Oracle 19.0). Input we have taken as 2 to 3 rows from the data grid 
transform and tried to insert it in RDS database table. It gave same column 
datatype cast errors something like unable to cast Long to BigInteger. Though 
it inserted the records but after few trial and error we suddenly found that 
out database storage utilization has increased way beyond the data we were 
inserting into the table. 
   
![storageissue](https://github.com/user-attachments/assets/f14c5b6c-200f-4f8c-a068-e15fe2f56fef)
   
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Database, Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to