6 Replies Latest reply on Apr 29, 2017 12:41 AM by wroot

    openfire.lobs file size

    Tomasz

      Our small Openfire + Spark setup with 30 users and embedded db produces this huge openfire.lobs file.

      I've tried searching for lobs file on the forum but cannot fine any suggestions what is it for and why is it so big comparing to the openfire.script file.

       

      Can anyone shed some light on this matter ?

       

      C:\Program Files (x86)\Openfire\embedded-db>dir

      Volume in drive C is System

      Volume Serial Number is C4E5-A493

       

      Directory of C:\Program Files (x86)\Openfire\embedded-db

       

      19/04/2017  00:03    <DIR>          .

      19/04/2017  00:03    <DIR>          ..

      19/04/2017  00:35                16 openfire.lck

      18/04/2017  22:03    19,970,326,528 openfire.lobs

      19/04/2017  12:45           465,552 openfire.log

      19/04/2017  00:03               105 openfire.properties

      19/04/2017  00:00        56,809,981 openfire.script

      19/04/2017  00:02    <DIR>          openfire.tmp

                     5 File(s) 20,027,602,182 bytes

                     3 Dir(s)   7,667,118,080 bytes free

        • Re: openfire.lobs file size
          Tomasz

          No reply after 10 days ? What is the purpose of this forum ?!

            • Re: openfire.lobs file size
              wroot

              This is not a commercial software and there is no official support. Everyone here is volunteer helping the community if possible. I have seen your question, but i have no clue what this file is. Maybe you can stop Openfire and try moving it out and then see if Openfire works correctly (maybe do full backup first).

                • Re: openfire.lobs file size
                  Tomasz

                  Hi,

                   

                  I'm sorry for sounding rude. I've searched for any info about this file format and its only mentioned on Oracle's website that its just another format of database and that it can hold anything, including multimedia files.

              • Re: openfire.lobs file size
                Guus der Kinderen

                I'm guessing that this file contains binary data of sorts, or perhaps the RRD tool database that's used in the monitoring plugin. I'm not aware of any problems related to this - keep an eye on the file size, but unless it exponentially starts growing, there's nothing to worry about.

                  • Re: openfire.lobs file size
                    Tomasz

                    10 days later and the files are still pretty much the same - LOBS file still sitting at 20 Gigabytes while main DB is 59 Megabytes.

                     

                    C:\Program Files (x86)\Openfire\embedded-db>dir

                    Volume in drive C is System

                    Volume Serial Number is C4E5-A493

                     

                    Directory of C:\Program Files (x86)\Openfire\embedded-db

                     

                    28/04/2017  00:03    <DIR>          .

                    28/04/2017  00:03    <DIR>          ..

                    28/04/2017  00:35                16 openfire.lck

                    18/04/2017  22:03    19,970,326,528 openfire.lobs

                    28/04/2017  11:13           273,676 openfire.log

                    28/04/2017  00:03               105 openfire.properties

                    28/04/2017  00:00        59,324,404 openfire.script

                    28/04/2017  00:02    <DIR>          openfire.tmp

                                   5 File(s) 20,029,924,729 bytes

                                   3 Dir(s)  23,633,252,352 bytes free

                      • Re: openfire.lobs file size
                        wroot

                        I have Monitoring plugin installed and enabled logging on my test server, which is used very rarely to send a few test messages. In the embedded-db folder i don't have openfire.lobs, but i do have openfire.log which seems to contain messages. When server is offline it starts with

                         

                        COMMIT

                        /*C8*/SET SCHEMA PUBLIC

                        DELETE FROM OFRRDS WHERE ID='sessions'

                        INSERT INTO OFRRDS VALUES('sessions',1

                         

                        So it does look like RRD table to save conversations. I have installed Monitoring plugin not so long ago, so maybe lobs was some extension in the past. Mine logs file is at 10 MB with a very rare usage. So i can see how this can grow to gigs on a production server (that's why we don't have it enabled on our production server).