The default is to create an RP called "autogen", but the internal monitoring is hardcoded to go to the "monitor" RP, I believe.
On Fri, Nov 18, 2016 at 1:44 PM, <[email protected]> wrote: > 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. > -- 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/CALGqCvNZUAsZMdyTY8n6x1mPmDZ19v%2B75yNPDsf5%3DXQ5GjtgwQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
