暂无图片
openGauss关于\l列出数据库表功能的失败
我来答
返回问答列表
分享
阿霞
2023-11-14
openGauss关于\l列出数据库表功能的失败
opengaussdocker

openGauss版本：3.0.0

平台：Docker

bug发生处

111.png

日志部分

openGauss的日志：

貌似没有？参考文档说：在/var/log/gaussdb/用户名/pg_log”中。但是我/var/log目录下只有如下内容

222.png

Docker的日志：貌似只有启动相关的日志

openGauss Database directory appears to contain a database; Skipping initialization
0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: 7b0f648518c0 

0 LOG:  [Alarm Module]Host IP: 172.17.0.2 

0 LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!

0 LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

0 WARNING:  failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING:  failed to parse feature control file: gaussdb.version.
0 WARNING:  Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path is an invalid directory
2023-11-13 15:01:23.647 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: 7b0f648518c0 

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: 172.17.0.2 

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

2023-11-13 15:01:23.930 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2023-11-13 15:01:23.943 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-13 15:01:23.943 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 8135 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  shared memory 3292 Mbytes, memory context 8483 Mbytes, max process memory 12288 Mbytes
2023-11-13 15:01:24.028 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2023-11-13 15:01:24.040 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [CACHE] LOG:  set metadata cache  size(134217728)
2023-11-13 15:01:24.090 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [SEGMENT_PAGE] LOG:  Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-11-13 15:01:24.130 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/var/lib/opengauss/data/gaussdb.state.temp" success
2023-11-13 15:01:24.135 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2023-11-13 15:01:24.222 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 982, usable_fds = 1000, already_open = 8
The core dump path is an invalid directory
2023-11-13 15:01:24.240 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  the configure file /usr/local/opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-11-13 15:01:24.240 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
openGauss Database directory appears to contain a database; Skipping initialization
0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: 7b0f648518c0 

0 LOG:  [Alarm Module]Host IP: 172.17.0.2 

0 LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!

0 LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

0 WARNING:  failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING:  failed to parse feature control file: gaussdb.version.
0 WARNING:  Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path is an invalid directory
2023-11-13 15:01:23.647 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: 7b0f648518c0 

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: 172.17.0.2 

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!

2023-11-13 15:01:23.903 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

2023-11-13 15:01:23.930 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2023-11-13 15:01:23.943 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-13 15:01:23.943 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 8135 MB
2023-11-13 15:01:23.965 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  shared memory 3292 Mbytes, memory context 8483 Mbytes, max process memory 12288 Mbytes
2023-11-13 15:01:24.028 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2023-11-13 15:01:24.040 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [CACHE] LOG:  set metadata cache  size(134217728)
2023-11-13 15:01:24.090 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [SEGMENT_PAGE] LOG:  Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-11-13 15:01:24.130 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/var/lib/opengauss/data/gaussdb.state.temp" success
2023-11-13 15:01:24.135 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2023-11-13 15:01:24.222 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 982, usable_fds = 1000, already_open = 8
The core dump path is an invalid directory
2023-11-13 15:01:24.240 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  the configure file /usr/local/opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-11-13 15:01:24.240 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-11-13 15:01:24.257 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-11-13 15:01:24.266 [unknown] [unknown] localhost 140099012217920 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.

复制
我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
阿霞
上传附件：dokcer's logs.txt
暂无图片 评论
暂无图片 有用 8
打赏 0
阿霞
题主
2023-11-14
不好意思，没想到logs不方便看，重新传了下附件
彭冲

我本地arm架构虚拟机正常，我给您反馈一下研发

image.png

暂无图片 评论
暂无图片 有用 3
打赏 0
阿霞
题主
2023-11-17
貌似输入"\l"后，底层会去读取pg_roles表，但是我的这个表不存在？
阿霞
题主
2023-11-20
大佬请看下这个链接https://huaweicloud.csdn.net/638db45cdacf622b8df8c9f7.html，我是照着他的来的
阿霞

谢谢，
经过我的测试后，貌似是pg_user表或者pg_roles表不存在？
image.png

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
暂无图片墨值悬赏