在创建数据库时报错 #19

AmethystTim · 2023-04-08T10:43:52Z

使用macOS，没有对原文件做任何修改，退出后重新进入出现错误，请问当出现如下报错该如何解决：

(base) [root@5a3ddd566468 dev]# ./scdbclient prompt --host=http://host.docker.internal:8080 --usersConfFileName=examples/docker-compose/client/users.json --sync
> switch root
root> show databases;
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x28 pc=0x7f4563]

goroutine 1 [running]:
main.runSql({0x0, 0x0}, {0xc000026470, 0xe}, 0xc56aa0, 0x1)
	/home/admin/dev/cmd/scdbclient/main.go:299 +0x483
main.executor({0xc000026470?, 0xf?})
	/home/admin/dev/cmd/scdbclient/main.go:179 +0x1f0
main.runPromptMode()
	/home/admin/dev/cmd/scdbclient/main.go:244 +0x150
main.glob..func3(0xc4ff60?, {0x8c1cdb?, 0x3?, 0x3?})
	/home/admin/dev/cmd/scdbclient/main.go:87 +0x17
github.com/spf13/cobra.(*Command).execute(0xc4ff60, {0xc000195d70, 0x3, 0x3})
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:920 +0x847
github.com/spf13/cobra.(*Command).ExecuteC(0xc4f9a0)
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:1044 +0x3bd
github.com/spf13/cobra.(*Command).Execute(...)
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:968
main.main()
	/home/admin/dev/cmd/scdbclient/main.go:348 +0x25

The text was updated successfully, but these errors were encountered:

tongke6 · 2023-04-08T14:21:38Z

@DINOREXNB 你好，请问这个问题可以复现吗？如果可以复现，麻烦在评论里描述下复现步骤，越详细对我们解决问题的帮助越大，谢谢^_^

AmethystTim · 2023-04-08T14:39:16Z

尝试重新搭建

删除docker中的docker-compose与scql
执行：

start dev container

docker run -d -it --name scql-dev-$(whoami)
--mount type=bind,source="$(pwd)",target=/home/admin/dev/
-w /home/admin/dev
--cap-add=SYS_PTRACE --security-opt seccomp=unconfined
--cap-add=NET_ADMIN
--privileged=true
secretflow/scql-ci:latest

attach to dev container

docker exec -it scql-dev-$(whoami) bash
Last login: Sat Apr 8 17:13:17 on ttys000
woodways@outekiMacBook-Pro ~ % cd /Users/woodways/Desktop/scql
woodways@outekiMacBook-Pro scql % docker run -d -it --name scql-dev-$(whoami)
--mount type=bind,source="$(pwd)",target=/home/admin/dev/
-w /home/admin/dev
--cap-add=SYS_PTRACE --security-opt seccomp=unconfined
--cap-add=NET_ADMIN
--privileged=true
secretflow/scql-ci:latest
0dc72fc19595cb0bc93dab738c66b06ef765547d2c2dbc6e88eb3b3051a95add

woodways@outekiMacBook-Pro scql % docker exec -it scql-dev-$(whoami) bash
(base) [root@0dc72fc19595 dev]# go build -o scdbclient cmd/scdbclient/main.go
go: downloading github.com/influxdata/go-prompt v0.2.8
go: downloading github.com/olekukonko/tablewriter v0.0.5
go: downloading github.com/spf13/cobra v1.6.1
go: downloading github.com/golang/mock v1.6.0
go: downloading google.golang.org/protobuf v1.28.1
go: downloading github.com/mattn/go-runewidth v0.0.13
go: downloading github.com/spf13/pflag v1.0.5
go: downloading golang.org/x/sys v0.5.0
go: downloading github.com/rivo/uniseg v0.2.0
go: downloading github.com/pkg/term v1.2.0-beta.2
(base) [root@0dc72fc19595 dev]# sh examples/docker-compose/register.sh
success register user and engine information
(base) [root@0dc72fc19595 docker-compose]# exit
exit
woodways@outekiMacBook-Pro scql % cd examples/docker-compose
woodways@outekiMacBook-Pro docker-compose % docker compose up -d
[+] Running 5/5
 ⠿ Network docker-compose_default           Created                        0.1s
 ⠿ Container docker-compose-engine_alice-1  Started                        1.4s
 ⠿ Container docker-compose-engine_bob-1    Started                        1.2s
 ⠿ Container docker-compose-scdb-1          Started                        1.3s
 ⠿ Container docker-compose-mysql-1         Started                        1.1s
woodways@outekiMacBook-Pro docker-compose % docker exec -it scql-dev-$(whoami) bash
(base) [root@0dc72fc19595 dev]# ./scdbclient prompt --host=http://host.docker.internal:8080 --usersConfFileName=examples/docker-compose/client/users.json --sync
> switch root
root> show databases;
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x28 pc=0x7f4563]
goroutine 1 [running]:
main.runSql({0x0, 0x0}, {0xc0001a8a00, 0xe}, 0xc56aa0, 0x1)
	/home/admin/dev/cmd/scdbclient/main.go:299 +0x483
main.executor({0xc0001a8a00?, 0xf?})
	/home/admin/dev/cmd/scdbclient/main.go:179 +0x1f0
main.runPromptMode()
	/home/admin/dev/cmd/scdbclient/main.go:244 +0x150
main.glob..func3(0xc4ff60?, {0x8c1cdb?, 0x3?, 0x3?})
	/home/admin/dev/cmd/scdbclient/main.go:87 +0x17
github.com/spf13/cobra.(*Command).execute(0xc4ff60, {0xc000195d70, 0x3, 0x3})
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:920 +0x847
github.com/spf13/cobra.(*Command).ExecuteC(0xc4f9a0)
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:1044 +0x3bd
github.com/spf13/cobra.(*Command).Execute(...)
	/usr/local/pkg/mod/github.com/spf13/[email protected]/command.go:968
main.main()
	/home/admin/dev/cmd/scdbclient/main.go:348 +0x25

anakinxc · 2023-04-09T06:23:28Z

Hi @DINOREXNB

方便提供一下您 macOS 的版本号和机型吗

AmethystTim · 2023-04-09T06:53:43Z

版本号：macOS Monterey 12.6.3
机型：MacBook Pro (Retina, 15-inch, Mid 2015)

jingshi-ant · 2023-04-10T02:06:21Z

go build -o scdbclient cmd/scdbclient/main.go
sh examples/docker-compose/register.sh
等这些部署的命令不在scql-dev-$(whoami)的container内部执行。这个container只建议在编译ci的时候用

tongke6 · 2023-04-10T02:06:42Z

@DINOREXNB 我在 macOS 上没能复现你遇到的问题。

麻烦提供下 scdb 的日志，可以通过在宿主机上 docker compose logs scdb 查看日志。

* secretflow#19

AmethystTim · 2023-04-10T14:48:09Z

2023-04-10 22:43:21.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:21.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:21.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:21.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:21.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:21.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:21.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:21.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:22.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:22.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:22.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:22.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:23.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:23.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:23.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:23.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:24.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:24.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:24.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:24.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:26.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:26.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:26.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:26.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:30.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:30.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:30.41010 INFO logger.go:147 /home/admin/dev/pkg/scdb/server/server.go:97
[error] failed to initialize database, got error dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:30.41010 FATAL main.go:102 Failed to connect to database and bootstrap it: dial tcp 172.22.0.3:3306: connect: connection refused
2023-04-10 22:43:37.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:43:37.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:43:37.41010 INFO main.go:122 Starting to serve request with http...
2023-04-10 22:45:25.41010 INFO main.go:85 Starting to read config file: /home/admin/configs/config.yml
2023-04-10 22:45:25.41010 INFO main.go:98 Starting to connect to database and do bootstrap if necessary...
2023-04-10 22:45:25.41010 INFO main.go:122 Starting to serve request with http...

tongke6 · 2023-04-10T14:53:55Z

@DINOREXNB 您好，上面的日志是在 scdbclient panic 之后查看的吗？目前从该日志上看不出什么异常。

麻烦尝试下从 #20 PR 里构建 scdbclient，试下此问题是否还存在

* fix #19

tongke6 · 2023-04-10T14:59:52Z

update，#20 已合入 main 分支，可以 pull 最新的代码构建试一下

AmethystTim · 2023-04-10T15:47:52Z

感谢，问题已解决

tongke6 self-assigned this Apr 8, 2023

tongke6 added a commit to tongke6/scql that referenced this issue Apr 10, 2023

fix scdbclient panic

87b3971

* secretflow#19

tongke6 mentioned this issue Apr 10, 2023

fix scdbclient panic #20

Merged

tongke6 linked a pull request Apr 10, 2023 that will close this issue

fix scdbclient panic #20

Merged

tongke6 closed this as completed in #20 Apr 10, 2023

tongke6 added a commit that referenced this issue Apr 10, 2023

fix scdbclient panic (#20)

a2ab58e

* fix #19

tongke6 reopened this Apr 10, 2023

AmethystTim closed this as completed Apr 10, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

在创建数据库时报错 #19

在创建数据库时报错 #19

AmethystTim commented Apr 8, 2023 •

edited

Loading

tongke6 commented Apr 8, 2023

AmethystTim commented Apr 8, 2023 •

edited

Loading

anakinxc commented Apr 9, 2023

AmethystTim commented Apr 9, 2023

jingshi-ant commented Apr 10, 2023

tongke6 commented Apr 10, 2023

AmethystTim commented Apr 10, 2023

tongke6 commented Apr 10, 2023

tongke6 commented Apr 10, 2023

AmethystTim commented Apr 10, 2023

在创建数据库时报错 #19

在创建数据库时报错 #19

Comments

AmethystTim commented Apr 8, 2023 • edited Loading

tongke6 commented Apr 8, 2023

AmethystTim commented Apr 8, 2023 • edited Loading

尝试重新搭建

start dev container

attach to dev container

anakinxc commented Apr 9, 2023

AmethystTim commented Apr 9, 2023

jingshi-ant commented Apr 10, 2023

tongke6 commented Apr 10, 2023

AmethystTim commented Apr 10, 2023

tongke6 commented Apr 10, 2023

tongke6 commented Apr 10, 2023

AmethystTim commented Apr 10, 2023

AmethystTim commented Apr 8, 2023 •

edited

Loading

AmethystTim commented Apr 8, 2023 •

edited

Loading