DB quota exceeded

From WebOS Internals
Revision as of 09:42, 4 June 2014 by RichT23 (talk | contribs) (a little more infomation, should be nicer looking!)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

A Problem often encountered after completeation of the MojoDB Partition Resize process is user notice (amongst other smptions) that they can not send Email or text messages.

In the messages log (via command line its /var/log/messages, this is a large file so might be troublesome to open via internals) or in Lumberjack you will see errors including the text "db: quota exceeded".

You will also notice that the db files them self's are large, you can check in /var/db/main via command line or via internals.


Here you see that my objects.db is over 60Mb

root@PigeonHawkPre:/# ls -al /var/db/main/
drwx------    2 root     root          4096 Jun  2 23:57 .
drwxr-xr-x    5 root     root          4096 Jun  3 02:24 ..
-rw-------    1 root     root         24576 Jun  3 09:42 UsageDbName
-rw-------    1 root     root             1 Dec 29  2011 _version
-rw-------    1 root     root         45056 Jun  3 02:24 indexIds.db
-rw-------    1 root     root      30490624 Jun  3 09:42 indexes.db
-rw-------    1 root     root         69632 Jun  3 02:24 kinds.db
-rw-------    1 root     root      71565312 Jun  3 09:42 objects.db
-rw-------    1 root     root         16384 Jun  3 08:37 sequences.db
root@PigeonHawkPre:/etc/palm# ls -lh /var/db/main/
-rw-------    1 root     root       24.0K Jun  3 09:42 UsageDbName
-rw-------    1 root     root           1 Dec 29  2011 _version
-rw-------    1 root     root       44.0K Jun  3 02:24 indexIds.db
-rw-------    1 root     root       29.1M Jun  3 09:42 indexes.db
-rw-------    1 root     root       68.0K Jun  3 02:24 kinds.db
-rw-------    1 root     root       68.3M Jun  3 09:42 objects.db
-rw-------    1 root     root       16.0K Jun  3 08:37 sequences.db


The size of the database is restricted

There is a quota on the size the database can reach its set in "/etc/palm/mojodb.conf"

  1. cat /etc/palm/mojodb.conf
...
  "quotas" : [
    {"owner":"*","size":20971520},
    {"owner":"com.palm.*","size":78643200}
  ],
...

I wanted to increase the size of mine to 128Mb 128*1024*1024 = '134217728'

Via a commandline edit the max size of your database:

I'm my case I changed the "78643200" to "134217728"


so my Quota now looks like this:

  1. cat /etc/palm/mojodb.conf
...
  "quotas" : [
    {"owner":"*","size":20971520},
    {"owner":"com.palm.*","size":134217728}
  ],
...

the just restart the mojodb (to be safe you should probably restart your device)

# Stop the MojoDB service
/sbin/stop mojodb
# Start the MojoDB service
/sbin/start mojodb