Queries for most-recent records returns random null fields

2

Having the exact same issue in a production application. I’ve recreated the issue with a Node client as well with a simple example, using influx v1.8.2. I’ve reproduced in Ubuntu 18.04.1 and Windows 10.

The frequency of requests and size of data seems to increase the frequency of receiving the null values. I generally have to let it run for a few minutes for the issue to occur. If I run 3 or 4 instances of the below code simultaneously, it starts happening frequently.

Any insight or solution is appreciated.

Code to Reproduce:

`const { InfluxDB } = require("influx");

const influx = new InfluxDB({
  host: "localhost",
  database: "testDb",
});

const createDb = async () => {
  await influx.createDatabase("testDb");
};

const read = async () => {
  const res = await influx.query(`
  select * from livedata
  ORDER BY time desc
  limit 1
`);


    console.log(res[0]);

};

const write = async () => {
  await influx.writeMeasurement("livedata", [
    {
      tags: {
        id: "site",
      },
      fields: {
        site1: Math.random() * 1000,
        site2: Math.random() * 1000,
        site3: Math.random() * 1000,
        site4: Math.random() * 1000,
        site5: Math.random() * 1000,
        site6: Math.random() * 1000,
        site7: Math.random() * 1000,
        site8: Math.random() * 1000,
      },
    },
  ]);
};

createDb();

setInterval(() => {
  write();
  read();
}, 300);

Example output:

  [
    '2021-01-07T21:40:11.4031559Z',
    'site',
    830.4042230769617,
    522.1830877694142,
    698.8789904008146,
    678.305459618109,
    118.82269436309988,
    631.6295948279627,
    376.3112870744887,
    830.4872612882643
  ]
]
[
  [
    '2021-01-07T21:40:11.7034901Z',
    'site',
    null,
    null,
    null,
    65.3968316403697,
    680.7946463560837,
    330.7338852317838,
    872.7936919556367,
    145.03057994702618
  ]
]
[
  [
    '2021-01-07T21:40:12.0036893Z',
    'site',
    901.031149970251,
    501.1825877093237,
    99.38758592260699,
    78.79549874505165,
    403.8558500935323,
    545.085784401504,
    969.637642068842,
    51.657735620841194
  ]
]