It sounds like when you upgraded the "[data] dir=" setting was no longer /var/influxdb/db, which is where the files were actually located.
On Tue, Jul 5, 2016 at 3:03 PM, Peter Gusev <[email protected]> wrote: > Copying database subfolder from "db" to "data" helped. > Thanks, > > On 5 July 2016 at 12:29, Peter Gusev <[email protected]> wrote: > >> that was the output: >> >> Using metastore snapshot: /var/lib/influxdb/backup/meta.00 >> >> ls for "data" folder doesn't show many TSM's (only for internal): >> >> $ sudo ls -lR /var/influxdb/data >> >> /var/influxdb/data: >> >> total 4 >> >> drwx------ 3 root root 4096 Jul 5 19:03 _internal >> >> >> /var/influxdb/data/_internal: >> >> total 4 >> >> drwx------ 3 root root 4096 Jul 5 19:03 monitor >> >> >> /var/influxdb/data/_internal/monitor: >> >> total 4 >> >> drwxr-xr-x 2 root root 4096 Jul 5 19:03 180 >> >> >> /var/influxdb/data/_internal/monitor/180: >> >> total 0 >> >> but ls for "db" folder still shows db_resources database: >> >> $ sudo ls -lR /var/influxdb/db/ >> >> /var/influxdb/db/: >> >> total 8 >> >> drwx------ 3 root root 4096 Mar 2 04:14 db_resources >> >> drwx------ 3 root root 4096 Mar 2 03:42 _internal >> >> /var/influxdb/db/db_resources: >> >> total 4 >> >> drwx------ 9 root root 4096 Jul 1 00:29 resources >> >> /var/influxdb/db/db_resources/resources: >> >> total 28 >> >> drwxr-xr-x 2 root root 4096 Jun 14 00:13 151 >> >> drwxr-xr-x 2 root root 4096 Jun 14 21:49 153 >> >> drwxr-xr-x 2 root root 4096 Jun 22 00:55 161 >> >> drwxr-xr-x 2 root root 4096 Jun 23 21:48 163 >> >> drwxr-xr-x 2 root root 4096 Jun 26 00:00 166 >> >> drwxr-xr-x 2 root root 4096 Jun 25 01:40 168 >> >> drwxr-xr-x 2 root root 4096 Jul 1 03:43 176 >> >> /var/influxdb/db/db_resources/resources/151: >> >> total 10356 >> >> -rw-r--r-- 1 root root 10602904 Jun 14 00:13 000000002-000000002.tsm >> >> /var/influxdb/db/db_resources/resources/153: >> >> total 2548 >> >> -rw-r--r-- 1 root root 2607994 Jun 14 21:49 000000001-000000001.tsm >> >> /var/influxdb/db/db_resources/resources/161: >> >> total 3400 >> >> -rw-r--r-- 1 root root 3479987 Jun 22 00:55 000000001-000000001.tsm >> >> /var/influxdb/db/db_resources/resources/163: >> >> total 66008 >> >> -rw-r--r-- 1 root root 67589986 Jun 23 21:48 000000008-000000004.tsm >> >> >> /var/influxdb/db/db_resources/resources/166: >> >> total 77912 >> >> -rw-r--r-- 1 root root 79777469 Jun 26 00:00 000000010-000000003.tsm >> >> >> /var/influxdb/db/db_resources/resources/168: >> >> total 108 >> >> -rw-r--r-- 1 root root 106839 Jun 25 01:40 000000001-000000001.tsm >> >> >> /var/influxdb/db/db_resources/resources/176: >> >> total 128660 >> >> -rw-r--r-- 1 root root 131741627 Jul 1 03:43 000000016-000000004.tsm >> >> >> /var/influxdb/db/_internal: >> >> total 4 >> >> drwx------ 10 root root 4096 Jul 5 00:14 monitor >> >> >> /var/influxdb/db/_internal/monitor: >> >> total 32 >> >> drwxr-xr-x 2 root root 4096 Jun 29 00:59 172 >> >> drwxr-xr-x 2 root root 4096 Jun 30 00:59 173 >> >> drwxr-xr-x 2 root root 4096 Jul 1 00:59 174 >> >> drwxr-xr-x 2 root root 4096 Jul 2 00:59 175 >> >> drwxr-xr-x 2 root root 4096 Jul 3 00:59 177 >> >> drwxr-xr-x 2 root root 4096 Jul 4 00:59 178 >> >> drwxr-xr-x 2 root root 4096 Jul 5 00:59 179 >> >> drwxr-xr-x 2 root root 4096 Jul 5 00:00 180 >> >> >> /var/influxdb/db/_internal/monitor/172: >> >> total 384 >> >> -rw-r--r-- 1 root root 391858 Jun 29 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/173: >> >> total 388 >> >> -rw-r--r-- 1 root root 395807 Jun 30 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/174: >> >> total 396 >> >> -rw-r--r-- 1 root root 402252 Jul 1 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/175: >> >> total 416 >> >> -rw-r--r-- 1 root root 422238 Jul 2 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/177: >> >> total 396 >> >> -rw-r--r-- 1 root root 402971 Jul 3 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/178: >> >> total 408 >> >> -rw-r--r-- 1 root root 416120 Jul 4 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/179: >> >> total 412 >> >> -rw-r--r-- 1 root root 419049 Jul 5 00:59 000000002-000000002.tsm >> >> >> /var/influxdb/db/_internal/monitor/180: >> >> total 0 >> >> >> should I transfer those to "data" folder? >> >> thanks! >> >> On 5 July 2016 at 12:22, Sean Beckett <[email protected]> wrote: >> >>> Do you have the output from the command that restored the metastore from >>> backup (step 4)? >>> >>> Are the data files still present on disk? E.g. does >>> >>> $ ls -lR /var/lib/influxdb/data * >>> >>> still show lots of TSM files? >>> >>> On Tue, Jul 5, 2016 at 1:17 PM, Peter Gusev <[email protected]> wrote: >>> >>>> I performed upgrade from v0.11 to v0.13 according to >>>> https://docs.influxdata.com/influxdb/v0.12/administration/upgrading/ >>>> Everything went smoothly, and I can see users and databases in "SHOW >>>> USERS" and "SHOW DATABASES" outputs. However, I no longer have any data in >>>> my database. When I switch to it and run SHOW MEASUREMENTS - results are >>>> empty. >>>> Is there anything I'm missing here? >>>> >>>> -- >>>> Remember to include the InfluxDB version number with all issue reports >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "InfluxDB" 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/0b86824f-ff40-4f35-ba3b-68fdf831cce7%40googlegroups.com >>>> <https://groups.google.com/d/msgid/influxdb/0b86824f-ff40-4f35-ba3b-68fdf831cce7%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Sean Beckett >>> Director of Support and Professional Services >>> InfluxDB >>> >>> -- >>> Remember to include the InfluxDB version number with all issue reports >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "InfluxDB" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/influxdb/ukpNMNdNNyc/unsubscribe. >>> To unsubscribe from this group and all its topics, 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/CALGqCvMoeDzq9_7XmHsv6UE3uzL7BWa4ya8hyzSLWCtSxPgG_w%40mail.gmail.com >>> <https://groups.google.com/d/msgid/influxdb/CALGqCvMoeDzq9_7XmHsv6UE3uzL7BWa4ya8hyzSLWCtSxPgG_w%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Peter Gusev >> *[email protected] <[email protected]>* >> *+1 213 5872748 <%2B1%20213%205872748>* >> *peetonn_ (skype)* >> >> *work smart. party hard. live easy.* >> > > > > -- > Peter Gusev > *[email protected] <[email protected]>* > *+1 213 5872748 <%2B1%20213%205872748>* > *peetonn_ (skype)* > > *work smart. party hard. live easy.* > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/CAMxZbOEpwWzF8nQ7RV44g2VYu4dVhuV%2B1F1FrigMabmROniA0A%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAMxZbOEpwWzF8nQ7RV44g2VYu4dVhuV%2B1F1FrigMabmROniA0A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvM8-oMdiL_xE09figm8h%3D_D7-yvnKgUv_%2BWJjmBy_6TDQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
