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/CALGqCvMtXhKpSMLSdAwg2jZoVc1cbNpyUAEGhU%3DZvovwQn64%2Bg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
