zombodb loads every minute?

[Jeff Ross]

Hi,

We're just starting to look into ZomboDB.  I added the extension to 10.5 and built an index on a table--everything works fine, including being able to access from Kibana.

Just out of curiosity, though--in my logs I see the following every minute:

2018-11-18 23:57:01 EST [36687]: [1-1] db=[unknown],user=[unknown],app=[unknown],client=[local] LOG:  connection received: host=[local]
2018-11-18 23:57:01 EST [36687]: [2-1] db=cargotel_dev,user=nobody,app=[unknown],client=[local] LOG:  connection authorized: user=nobody database=cargotel_dev
2018-11-18 23:57:01 EST [36687]: [3-1] db=cargotel_dev,user=nobody,app=[unknown],client=[local] LOG:  ZomboDB Loaded
2018-11-18 23:57:01 EST [36687]: [4-1] db=cargotel_dev,user=nobody,app=[unknown],client=[local] LOG:  disconnection: session time: 0:00:00.010 user=nobody database=cargotel_dev host=[local]

The nobody user is in no way connected to the schema in which I built the zombodb index--why does zombodb use that user to connect?

Is the extension reloading itself every minute and is that normal?

Thanks,

Jeff Ross

[Eric Ridge]

Hi Jeff!

First, thanks for checking out ZomboDB.  I think you'll like it.  Just remember that right now the PG 10x support is still beta...

That said, ZomboDB is just a shared library that's configured to automatically loaded the .so into each new Postgres backend that connects to a database that has the extension.  And for no particularly good reason, ZDB just spits out a log message indicated that the library successfully loaded.

So I suspect that's what happening here is that your "cargotel_dev" database, which I assume is the one in which you ran CREATE EXTENSION zombodb, is being pinged every minute by some external process.  And by "pinged", I mean, there's some other process opening/closing a connection to that database every minute.  Perhaps a connection pooler or a watchdog-type thing.  In my experience, the user "nobody" (at least the Unix system user) is typically used by apache.

Anyways, this isn't a thing to worry about from ZDB's perspective.  Again, the log message just indicates that the shard library successfully loaded.  It's not doing any additional work.

eric

--
You received this message because you are subscribed to the Google Groups "ZomboDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to zombodb+u...@googlegroups.com.
To post to this group, send email to zom...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/zombodb/beca2d41-c30a-4cbe-9b24-1f636179b10f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.