No data in _internal db

1

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:

[monitor]
  store-enabled = true
  store-database = "_internal"
  store-interval = "10s"
2

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.

3

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

4

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"
5 
{"results":[{"statement_id":0,"series":[{"name":"system","columns":["PID","currentTime","started","uptime"],"values":[[15729,"2017-03-25T00:54:17.731183262Z","2017-03-24T05:16:39.037905536Z","19h37m38.693278114s"]]}]},{"statement_id":1}]}
6

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.

7

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.

8

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

9

Done.

1 Like
10

Hello Andy,

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