No data in _internal db

I’ve got an “internal” database which shows about 20 measurements. But I can find no keys or fields in the databases. It looks like “internal” database is not collecting any data. Is there something I need to do to turn this on??

Here’s the monitor section from influxdb.conf:

  store-enabled = true
  store-database = "_internal"
  store-interval = "10s"

Is that what’s in your config file? database is misspelled. If you’re running 1.2.0 or newer, I believe that should have caused a startup failure due to commit 5a24cb.

No - sorry that was a fat-finger typo. Fixed the misspelling.

The config looks right in that case. What do you see when you run:

curl -v http://localhost:8086/query --data-urlencode "q=SHOW DIAGNOSTICS FOR 'system'; SELECT last(req) FROM _internal..httpd"

So I solved this problem by deleting the _internal database, then re-creating it.

I guess it was corrupted somehow.

Now everything works as expected.

And 10-30 minutes after regenerating the database - it breaks again. I went thru this cycle 2 times and got the same behavior. I’ll assume this is a bug, turn it off and have a look again sometime in the future. FYI I’m using InfluxDB 1.2 on Ubuntu 16.04. Approx 8 databases with 500MB of data.

@andyl That does sound a lot like a bug. Can you could open an issue on InfluxDB?


1 Like

Hello Andy,

I am a new user, could you please help me to know how to re-create _internal DB manually. Thanks.