126 words

impossible to drop a table with 50 million objects

2017-06-28 05:49

when trying to execute in explorer (max heap size 1GByte)

delete from LogEntry l

it comes up with a Java heap error after 20 minutes of executing.

How to empty such a table ?



hgzwicker's picture
Joined on 2014-04-09
User Post #32
2017-06-28 07:48

This may be because the transaction size is limited by the heap size.

You can try deleting these objects in batches, using several transactions, each transaction will delete the results of a query on the LogEntry instances that returns part of the LogEntry instances in the database.

Alternatively you may try using the undocumented setting of temporary page file, which increases the maximum transaction size above the heap size. See #10 in that issue thread for the requires setting. Accordingly you can try running the Explorer with this setting (-Dobjectdb.temp.page-file=true).

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support's picture
Joined on 2010-05-03
User Post #2,766

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Maximum file size: 32 MB