Hi Sean,
it's not python client issue, schema has been changed i guess, below is the
format i use for old version.
can u please tell me how to write data in new format, which resembles the
way i want to write in old version.
db_str=[
{
"name": "vm_data",
"columns": ["running","stopped" ],
"points": [[1],[2]]
}
]
new version is uses some thing like below,
sb_str = [
{
"measurement": "cpu_load_short",
"tags": {
"host": "server01",
"region": "us-west"
},
"time": "2009-11-10T23:00:00Z",
"fields": {
"value": 0.64
}
}
]
Thank you very much.
On Sun, Aug 28, 2016 at 4:12 PM, related2blog <[email protected]>
wrote:
> Hi Sean,
>
> Sorry to bother you again, i felt happy because i fixed it, but now i have
> difficulty in writing into data base.
>
> I'm using python-influxdb client. which was working fine with old version,
> but not i upgraded my ubuntu 14.04 to 16.04 because of latest influx (no
> python-influxdb available for 14.01, i was using pip install which is not
> supported by latest influxdb) and grafana.
>
>
>
> I'm hitting below error.
>
>
=====================================================================================
>
> 2 ubuntu@ip-172-31-14-209:~/migrationā« python influx.py
>
> [{'points': [[1]], 'name': 'ionos-test', 'columns': [['large']]}]
>
> Traceback (most recent call last):
>
> File "influx.py", line 8, in <module>
>
> CustomModules.db(db_str,'subbu')
>
> File "/home/ubuntu/migration/mod.py", line 37, in db
>
> client.write_points(string)
>
> File "/usr/lib/python2.7/dist-packages/influxdb/client.py", line 391, in
> write_points
>
> tags=tags)
>
> File "/usr/lib/python2.7/dist-packages/influxdb/client.py", line 436, in
> _write_points
>
> expected_response_code=204
>
> File "/usr/lib/python2.7/dist-packages/influxdb/client.py", line 276, in
> write
>
> data=make_lines(data, precision).encode('utf-8'),
>
> File "/usr/lib/python2.7/dist-packages/influxdb/line_protocol.py", line
> 117, in make_lines
>
> for field_key in sorted(point['fields'].keys()):
>
> KeyError: u'fields'
>
>
==========================================================================================
>
> my code.
>
>
> ==============================
>
> from influxdb import InfluxDBClient
>
>
> def db(string, db, host='localhost', port=8086):
>
> user = 'root'
>
> password = 'ionos_123'
>
> dbname = db
>
> client = InfluxDBClient(host, port, user, password, dbname)
>
> client.write_points(string)
>
>
> db_str =[{"points": [[1]],
>
> "name": "ionos-test",
>
> "columns": [["large"]]}]
>
> db(db_str,'subbu')
>
>
> =============================
> thank you very much in advance.
>
> On Sat, Aug 27, 2016 at 1:34 AM, Sean Beckett <[email protected]> wrote:
>>
>> The query language is significantly different between 0.8 and 0.9+, so
>> you'll need to add the database to Grafana as an InfluxDB 0.9+ data
source.
>>
>> http://docs.grafana.org/datasources/influxdb/#adding-the-data-source
>>
>> On Fri, Aug 26, 2016 at 1:58 PM, related2blog <[email protected]>
>> wrote:
>>>
>>> Thank you very much, Sean
>>>
>>> White paper u sent me , awesome. I tested it and worked. Only one final
>>> question my grafana is old, what seen was grafana queries not working
with
>>> new version of influx. Is it expected ? Need my grafana to be upgraded
as
>>> well ?
>>>
>>> Manny.
>>>
>>>
>>> On Aug 26, 2016 12:22 AM, "Sean Beckett" <[email protected]> wrote:
>>>>
>>>> We have extensive documentation and webinars on how to upgrade from
>>>> 0.8.x to InfluxDB 0.13. There are a number of breaking changes to the
API,
>>>> write protocol, query language, storage engine, and administrative
tools. It
>>>> is not a trivial upgrade, and requires exporting all the data from
0.8.x and
>>>> re-importing it into InfluxDB 0.13.
>>>>
>>>> Please see the Migration white paper on
>>>> https://influxdata.com/technical-papers/ and the Migration webinar
video on
>>>> https://influxdata.com/videos-training/.
>>>>
>>>> On Thu, Aug 25, 2016 at 9:07 AM, <[email protected]> wrote:
>>>>>
>>>>> Hi Sean,
>>>>>
>>>>> I'm using influxdb for quite some time, Since my app working fine for
>>>>> long time i forgot to upgrade my db, lately i had an issue which
forces me
>>>>> to backup the db, i neither can backup or migrate. I dont see any info
>>>>> regarding the version 0.8.8.
>>>>>
>>>>> All i found was using curl command i can load all the data to a json
>>>>> file, but i dont see a way to write it to new version of db, i also
tried
>>>>> installing new version of influx and tried writing the info like below
>>>>>
>>>>> db_str =[{"points": [[2016,1,2,3]],
>>>>> "name": "ionos-test",
>>>>> "sequence_number": 2724430001,
>>>>> "columns": ["time","total", "val1", "val2"]}]
>>>>>
>>>>> but i hit below error, what l learnt from below error is , db is
>>>>> expecting time in diff format, but my json has only epoc
>>>>>
>>>>> "InfluxDBClientError: 400: json: error calling MarshalJSON for type
>>>>> time.Time: Time.MarshalJSON: year outside of range [0,9999]"
>>>>>
>>>>> i stuck very badly please let me know how to migrate to newer version
>>>>> which has backup option. At lease in worst case please suggest me how
can i
>>>>> back up and restore. I prefer upgrade becase its time series data.
>>>>>
>>>>> Thank you very much.
>>>>> manny
>>>>>
>>>>> On Thursday, March 17, 2016 at 12:04:10 AM UTC+5:30, Sean Beckett
>>>>> wrote:
>>>>> > On Wed, Mar 16, 2016 at 8:37 AM, <[email protected]> wrote:
>>>>> > I am performing zero-downtime upgrade using scenario #2 from this
>>>>> > presentation
>>>>> >
>>>>> > (slide #13,
>>>>> >
http://www.slideshare.net/SeanBeckett4/influxdb-upgrade-to-010-considerations
)
>>>>> >
>>>>> >
>>>>> >
>>>>> > My current config:
>>>>> >
>>>>> > running influxdb-0.10.3-1
>>>>> >
>>>>> > data files in bz1 format created by influxdb-0.9.6.1
>>>>> >
>>>>> >
>>>>> >
>>>>> > I have updated InfluxDB binary, started it and see that it continues
>>>>> > to write to existing data file in bz1 format.
>>>>> >
>>>>> >
>>>>> >
>>>>> > How do I start a new data file in tsm1?
>>>>> >
>>>>> > Or the only option is to wait until Influxdb desides to start a new
>>>>> > shard?
>>>>> >
>>>>> >
>>>>> >
>>>>> > Yes, when the shards roll over the new shard file will be TSM
format.
>>>>> >
>>>>> >
>>>>> >
>>>>> > I don't see option 'engine = tsm1' in a new configuration file and I
>>>>> > don't feel like trying to use this on new setup.
>>>>> >
>>>>> >
>>>>> >
>>>>> > There is no configuration option because there is no choice. All new
>>>>> > shard files will be TSM files. Existing b1/bz1 files will be
written to
>>>>> > until they go cold for writes, at which time you can convert them
to TSM.
>>>>> >
>>>>> >
>>>>> >
>>>>> > Thanks!
>>>>> >
>>>>> >
>>>>> >
>>>>> > --
>>>>> >
>>>>> > 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/b8454246-82d4-4ec5-babb-e1b96a7ef4ba%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 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/4fdfb344-9837-4d64-b763-8418d7216eaf%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 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/Zg9AVkSiYPs/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/CALGqCvNTTjc-%2Bmq-vvs_yt7DX2u9XQ1bSsYKB3NxL%2BaZYL8kjA%40mail.gmail.com
.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>> --
>>> 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/CAP6%2BsvR6z7kuCRdCWLHYi09mo%3D39LtvyKJ-gYx_ZWpj2%2BrpTDQ%40mail.gmail.com
.
>>>
>>> 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/Zg9AVkSiYPs/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/CALGqCvP%3DXGggetRLXaJKAebahVBi3iR8d3aXeD4Y1X53hSdFaw%40mail.gmail.com
.
>>
>> For more options, visit https://groups.google.com/d/optout.
>
>
--
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/CAP6%2BsvRLTWh6vMDPoVO%3DrTT2EsdLH533ctZdcGKNQyoWgKQ9jA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
