questdb / questdb

QuestDB is an open source time-series database for fast ingest and SQL queries
https://questdb.io
Apache License 2.0
14.58k stars 1.18k forks source link

docker-compose issue with inserting data into WAL tables #5124

Open nwoolmer opened 1 week ago

nwoolmer commented 1 week ago

To reproduce

Set up docker.

Take this docker-compose.yml:

services:
  historic-data:
    image: questdb/questdb:8.1.4
    ports:
      - "9000:9000"
      - "9009:9009"
      - "8812:8812"
      - "9003:9003"
    volumes:
      - "P:/volume/questdb:/var/lib/questdb"

Change the volume to something appropriate on your machine.

Start the database.

Create a table:

create table foo (
  symbol symbol,
  tenant symbol,
  source symbol,
  ask double,
  bid double,
  value double,
  state long,
  entity long,
  timestamp timestamp
) timestamp(timestamp) partition by day wal;

Insert data:

insert into foo values ('USD', 'examp', 'api', 1, 2, 3, 4, 5, now())

Observe that the numeric values have become 0:

image

Not reproducible in 8.0.3 down to 8.0.0.

QuestDB version:

8.1.0+

OS, in case of Docker specify Docker and the Host OS:

Docker Windows 11 WSL2

File System, in case of Docker specify Host File System:

NTFS and ReFS

Full Name:

Nick Woolmer

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

Additional context

No response

bluestreak01 commented 1 week ago

this is an unsupported platform for now, we will investigate this problem when we can