Is there a way to compact the youtrack database (~/teamsysdata/)

I have a personal issue tracker on my development machine. I have maybe +/- 200 issues in there with only text (no attachements). All in all, I think the actual user content must be no more than 500kb. However over time my youtrack database has grown to almost 600mb. Aw. :-§

So that's like 99.99% overhead. That is inconvenient, especially to keep data backed up on line and such. So I wonder, is there a way to get rid of the cruft?

Also, I tried the backup function on the administration page of youtrack, but that fails with an error (so I have no idea of how big that would be):

java.lang.RuntimeException: java.lang.IllegalStateException: There's no current session to attach transient entity to.
    at jetbrains.charisma.main.AsyncBackupBean$1.run(AsyncBackupBean.java:28)
    at jetbrains.charisma.persistent.UserActionJob.execute(UserActionJob.java:28)
    at jetbrains.exodus.core.execution.Job.run(Job.java:99)
    at jetbrains.exodus.core.execution.ThreadJobProcessor.executeJob(ThreadJobProcessor.java:132)
    at jetbrains.exodus.core.execution.JobProcessorQueueAdapter.doExecuteJob(JobProcessorQueueAdapter.java:254)
    at jetbrains.exodus.core.execution.JobProcessorQueueAdapter.doJobs(JobProcessorQueueAdapter.java:167)
    at jetbrains.exodus.core.execution.ThreadJobProcessor.run(ThreadJobProcessor.java:110)
    at jetbrains.exodus.core.execution.ThreadJobProcessor$1.run(ThreadJobProcessor.java:43)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: There's no current session to attach transient entity to.
    at com.jetbrains.teamsys.dnq.database.TransientStoreUtil.reattach(TransientStoreUtil.java:74)
    at com.jetbrains.teamsys.dnq.association.PrimitiveAssociationSemantics.get(PrimitiveAssociationSemantics.java:31)
    at com.jetbrains.teamsys.dnq.association.PrimitiveAssociationSemantics.get(PrimitiveAssociationSemantics.java:71)
    at jetbrains.youtrack.ring.settings.RingConfigImpl.isEnabled(RingConfigImpl.java:44)
    at jetbrains.youtrack.ring.maintenance.HubReadOnlyManager.isReadOnly(HubReadOnlyManager.java:17)
    at jetbrains.youtrack.ring.maintenance.EmbeddedHubBackupable$EmbeddedHubBackupStrategy.beforeBackup(EmbeddedHubBackupable.java:37)
    at jetbrains.exodus.util.BackupBean$1.beforeBackup(BackupBean.java:119)
    at jetbrains.exodus.util.CompressBackupUtil.backup(CompressBackupUtil.java:51)
    at jetbrains.charisma.main.AsyncBackupBean$1.run(AsyncBackupBean.java:26)
    ... 8 more

 

1 comment
Comment actions Permalink
Official comment

Hello,

There seems to be a bug, could you please submit a support request https://youtrack-support.jetbrains.com/hc/en-us/requests/new?ticket_form_id=66282 , we'll investigate the issue deeper and could safely work with the sensitive database information.

Please sign in to leave a comment.