Title
#users-public
x

Xavier Lu

10/21/2022, 1:22 AM
hey guys, not sure why but i can’t drop or truncate this table. I am also getting this error
No space left [size=16777216, fd=162]
for some INSERT statements
Bolek Ziobrowski

Bolek Ziobrowski

10/21/2022, 6:38 AM
Hi @Xavier Lu . It seems that create table is either still running or failed but didn't take the lock on the table . "No space left" error most likely that means filesystem on which data files reside is full .
Nicolas Hourcard

Nicolas Hourcard

10/21/2022, 7:41 AM
@Bolek Ziobrowski do you have recommendations on what Xavier could do ?
Bolek Ziobrowski

Bolek Ziobrowski

10/21/2022, 7:44 AM
Restarting instance should remove the lock but if filesystem is full then things won't work . If qdb is still running then fd number from error message could be translated to filesystem path with :
lsof -p $QDB _PID | grep 162
Nicolas Hourcard

Nicolas Hourcard

10/21/2022, 11:02 AM
@Xavier Lu let us know if this solves your problem
x

Xavier Lu

10/21/2022, 5:39 PM
restarting the instance fixed the issue, thanks @Bolek Ziobrowski @Nicolas Hourcard
Nicolas Hourcard

Nicolas Hourcard

10/24/2022, 11:58 AM
Great to hear
11:58 AM
@Xavier Lu which dashboard do you now use for vizualisations?
x

Xavier Lu

10/24/2022, 5:42 PM
we are still on mysql for some of our data and we use superset for that @Nicolas Hourcard
Nicolas Hourcard

Nicolas Hourcard

10/24/2022, 5:46 PM
ok - QuestDB prime use case is dashboard so real shame that we dont support Superset out of the box… If we did, would you take stuff from mysql into QDB?