Re: [h2] DELETE statement causes the database to multiply in size and stuck.

2022-11-21 Thread Noel Grandin
HI There probably is something wrong with our execution of that query, but I'm afraid it's too complex to be debuggable just from the overview. Unless you can prepare us a self-contained test-case, that won't be much we can do, sorry. Regards, Noel. -- You received this message because you

Re: [h2] DELETE statement causes the database to multiply in size and stuck.

2022-11-21 Thread Vojtěch Jaroš
I found an issue with the SQL command, the second table has a where clause which is always true: *where T3_T1_FID = T3_T1_FID * The redacted file with the exception has it wrong, I made a mistake when renaming the tables for sending here. Sorry for that. I will run my application again with the c

Re: [h2] DELETE statement causes the database to multiply in size and stuck.

2022-11-19 Thread Noel Grandin
What does EXPLAIN PLAN show? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visi

[h2] DELETE statement causes the database to multiply in size and stuck.

2022-11-19 Thread Vojtěch Jaroš
Hello, we are using a H2 database that is normally ~20 GB in size. It was created from scratch with the current version of H2 (2.1.214). Every time when it reaches some size which was not exactly determined, but something over 20 GB, the cleanup DELETE query that normally takes just a few minute