Thanks Sean, specifying the retention policy while creating the db was important. Without the retention policy specified, the db was created but no data written to it.
Bernard On Thursday, November 17, 2016 at 3:42:03 PM UTC-8, Sean Beckett wrote: > Simplest would be to drop and recreate it: > > > DROP DATABASE _internal; > CREATE DATABASE _internal WITH DURATION 1w NAME "monitor" > > > On Thu, Nov 17, 2016 at 2:46 PM, <[email protected]> wrote: > Unfortunately not. > > InfluxDB shell version: 1.0.2 > > > use _internal > > Using database _internal > > > show measurements > > > > > > > > > > I suspect something is wrong with the metadata. > > Is there a clean way to "reset" the _internal db? > > > > > > > > On Thursday, November 17, 2016 at 11:41:13 AM UTC-8, Sean Beckett wrote: > > > The last line shows the database being created, I believe. Does it have > > stats now? > > > > > > > > > > > On Thu, Nov 17, 2016 at 12:00 PM, <[email protected]> wrote: > > > v1.0 > > > > > > > > > > > > Other than my queries, I see the activity regarding when I dropped > > _internal and restarted influxdb: > > > > > > [query] 2016/11/17 11:47:10 DROP DATABASE _internal > > > > > > [subscriber] 2016/11/17 11:47:10 deleted old subscription for _internal > > monitor > > > > > > [httpd] ::1 - - [17/Nov/2016:11:47:10 -0500] "POST > > /query?chunked=true&db=&epoch=ns&q=drop+database+_internal HTTP/1.1" 200 51 > > "-" "InfluxDBShell/1.0.2" 7b785653-ace5-11e6-8879-000000000000 221715 > > > > > > [monitor] 2016/11/17 11:47:20 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:47:30 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:47:40 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:47:50 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:48:00 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:48:10 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:48:20 failed to store statistics: database not > > found: _internal > > > > > > [monitor] 2016/11/17 11:52:13 Storing statistics in database '_internal' > > retention policy 'monitor', at interval 10s > > > > > > > > > > > > On Thursday, November 17, 2016 at 10:49:00 AM UTC-8, Sean Beckett wrote: > > > > > > > What version of InfluxDB? > > > > > > > > > > > > > > > > > > > > > What's in the logs regarding _internal? > > > > > > > > > > > > > > > > > > > > > On Thu, Nov 17, 2016 at 10:21 AM, <[email protected]> wrote: > > > > > > > Hi, > > > > > > > > > > > > > > > > > > > > > > > > > > > > I had to perform a restore of an influxdb instance recently. I restored > > > all db's including the _internal. The restore probably didn't go well as > > > I saw no measurements in the _internal db. > > > > > > > > > > > > > > That's a separate issue. > > > > > > > > > > > > > > > > > > > > > > > > > > > > I tried simply dropping the _internal database and restarted influxdb > > > service. I see that the _internal database was recreated (show > > > databases) but there's still no measurements for it. > > > > > > > > > > > > > > I'm ok with losing historical _internal data, I just want to have it > > > cleanly created so that new data can be written for monitoring. > > > > > > > > > > > > > > > > > > > > > > > > > > > > Any suggestions? > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > Bernard > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > Remember to include the version number! > > > > > > > > > > > > > > --- > > > > > > > > > > > > > > You received this message because you are subscribed to the Google Groups > > > "InfluxData" group. > > > > > > > > > > > > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to [email protected]. > > > > > > > > > > > > > > To post to this group, send email to [email protected]. > > > > > > > > > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > > > > > > > > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/influxdb/6b27bcd3-03f9-45c9-a016-669f6445210f%40googlegroups.com. > > > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > > > > Sean Beckett > > > > > > > Director of Support and Professional Services > > > > > > > InfluxDB > > > > > > > > > > > > -- > > > > > > Remember to include the version number! > > > > > > --- > > > > > > You received this message because you are subscribed to the Google Groups > > "InfluxData" group. > > > > > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [email protected]. > > > > > > To post to this group, send email to [email protected]. > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/influxdb/5c64cd1b-5030-4add-aa31-b631ac474230%40googlegroups.com. > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > -- > > Remember to include the version number! > > --- > > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To post to this group, send email to [email protected]. > > Visit this group at https://groups.google.com/group/influxdb. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/9663cac3-72cc-42ec-9aff-bac21d622cfb%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/a5653579-d01e-4802-9557-eef5deb7ec58%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
