Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Got error "file is not a database" when starting ekuiper #3492

Open
cherrycl opened this issue Jan 6, 2025 · 1 comment
Open

Got error "file is not a database" when starting ekuiper #3492

cherrycl opened this issue Jan 6, 2025 · 1 comment

Comments

@cherrycl
Copy link

cherrycl commented Jan 6, 2025

Environment:

  • eKuiper version (e.g. 1.3.0): 2.0.5
  • Hardware configuration (e.g. lscpu):
$ lscpu        
Architecture:            aarch64
  Byte Order:            Little Endian
CPU(s):                  4
  On-line CPU(s) list:   0-3
Vendor ID:               ARM
  Model name:            Cortex-A72
    Model:               3
    Thread(s) per core:  1
    Core(s) per cluster: 4
    Socket(s):           -
    Cluster(s):          1
    Stepping:            r0p3
    CPU(s) scaling MHz:  33%
    CPU max MHz:         1800.0000
    CPU min MHz:         600.0000
    BogoMIPS:            108.00
    Flags:               fp asimd evtstrm crc32 cpuid
Caches (sum of all):     
  L1d:                   128 KiB (4 instances)
  L1i:                   192 KiB (4 instances)
  L2:                    1 MiB (1 instance)
Vulnerabilities:         
  Gather data sampling:  Not affected
  Itlb multihit:         Not affected
  L1tf:                  Not affected
  Mds:                   Not affected
  Meltdown:              Not affected
  Mmio stale data:       Not affected
  Retbleed:              Not affected
  Spec rstack overflow:  Not affected
  Spec store bypass:     Vulnerable
  Spectre v1:            Mitigation; __user pointer sanitization
  Spectre v2:            Vulnerable
  Srbds:                 Not affected
  Tsx async abort:       Not affected
  • OS (e.g. cat /etc/os-release):
$ cat /etc/os-release
PRETTY_NAME="Raspbian GNU/Linux 12 (bookworm)"
NAME="Raspbian GNU/Linux"
VERSION_ID="12"
VERSION="12 (bookworm)"
VERSION_CODENAME=bookworm
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"
  • Others:

What happened and what you expected to happen:
ekuiper service startup failed and got error "file is not a database", full logs as below.

time="2025-01-06T02:54:55Z" level=info msg="register source neuron" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source websocket" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source simulator" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source edgex" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source httppull" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source file" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source memory" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source mqtt" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source httppush" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register source redisSub" file="server/server.go:148"
time="2025-01-06T02:54:55Z" level=info msg="register sink memory" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink file" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink log" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink logToMemory" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink mqtt" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink rest" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink nop" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink neuron" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink websocket" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink edgex" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink redis" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register sink redisPub" file="server/server.go:151"
time="2025-01-06T02:54:55Z" level=info msg="register lookup source httppull" file="server/server.go:154"
time="2025-01-06T02:54:55Z" level=info msg="register lookup source redis" file="server/server.go:154"
time="2025-01-06T02:54:55Z" level=info msg="register lookup source memory" file="server/server.go:154"
time="2025-01-06T02:54:55Z" level=info msg="register format binary" file="server/server.go:157"
time="2025-01-06T02:54:55Z" level=info msg="register format delimited" file="server/server.go:157"
time="2025-01-06T02:54:55Z" level=info msg="register format urlencoded" file="server/server.go:157"
time="2025-01-06T02:54:55Z" level=info msg="register format protobuf" file="server/server.go:157"
time="2025-01-06T02:54:55Z" level=info msg="register format json" file="server/server.go:157"
time="2025-01-06T02:54:55Z" level=info msg="maxprocs: Leaving GOMAXPROCS=4: CPU quota undefined" file="maxprocs/maxprocs.go:47"
time="2025-01-06T02:54:55Z" level=info msg="use cgo disabled sqlite as store sqliteKV.db" file="sqlite/database.go:38"
time="2025-01-06T02:54:55Z" level=info msg="use cgo disabled sqlite as store cache.db" file="sqlite/database.go:38"
time="2025-01-06T02:54:55Z" level=info msg="use cgo disabled sqlite as store extState.db" file="sqlite/database.go:38"
time="2025-01-06T02:54:55Z" level=info msg="use cgo disabled sqlite as store trace.db" file="sqlite/database.go:38"
time="2025-01-06T02:54:56Z" level=info msg="maxprocs: No GOMAXPROCS change to reset" file="maxprocs/maxprocs.go:47"
panic: file is not a database (26)

goroutine 1 [running]:
github.com/lf-edge/ekuiper/v2/internal/server.StartUp({0x2761c58, 0x5})
        github.com/lf-edge/ekuiper/v2/internal/server/server.go:182 +0x1f1c
github.com/lf-edge/ekuiper/v2/cmd.Main(...)
        github.com/lf-edge/ekuiper/v2/cmd/main.go:68
main.main()
        ./main.go:21 +0x30

How to reproduce it (as minimally and precisely as possible):
Run ekuiper by docker command docker run -p 9081:9081 -d --name ekuiper -e MQTT_SOURCE__DEFAULT__SERVER="tcp://broker.emqx.io:1883" lfedge/ekuiper:2.0-alpine

Anything else we need to know?:

@ngjaying
Copy link
Collaborator

ngjaying commented Jan 6, 2025

There was a problem in the sqlite driver. Please try v2.0.6. Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants