Title
#users-public
a

Antonio Jimenez

11/25/2022, 3:34 PM
Hello again! I'm playing a little with questdb, and I think I've found a bug (or limitation with CentOs). I've downloaded the version: questdb-6.6.1-rt-linux-amd64.tgz. And started with:
./questdb.sh start -d /tmp
I've create several tables using the WebConsole, and the tables doesn't appears on the lateral menu, but the problem can be reproduce using the "curl" command. Just started no tables are retrieved:
curl -G --data-urlencode "query=show tables" http://localhost:9000/exp
"table"
curl -G --data-urlencode "query=CREATE TABLE IF NOT EXISTS Testing(id INT, name STRING)" http://localhost:9000/exec
{"ddl":"OK"} Not after create Testing.
curl -G --data-urlencode "query=show tables" http://localhost:9000/exp
"table" And no describing.
curl -G --data-urlencode "query=describe Testing" http://localhost:9000/exp
{"query":"describe Testing","error":"table does not exist [table=describe]","position":0} But the table seems to be created into the db folder:
-rw-r--r--. 1 0 nov 25 16:21 Testing.lock
-rw-r--r--. 1 4096 nov 25 16:21 _tab_index.d
drwxrwxr-x. 3 88 nov 25 16:21 Testing
All of this was executed in a CentOS Linux release 7.2.1511; and the starting log returns this suspicious trace. "A server-main - db root: [path=/tmp/db, magic=0x58465342] -> UNSUPPORTED (SYSTEM COULD BE UNSTABLE)" Sorry if this channel is not for that! 😅
Imre

Imre

11/25/2022, 5:19 PM
Hi Antonio, I think it is really just what it says and the file system is not supported. I suggest you try to set the root dir for the DB outside of /tmp. If that does not work either then you would probably need a mount with EXT file system.
a

Antonio Jimenez

11/25/2022, 5:29 PM
I've tested with ext4 and it works well. Thanks!