GBase 8s 安装完成后，创建数据库失败

发表于2025-07-11 16:53:31121次浏览6个评论

采用典型模式安装完成后，创建数据库失败，帮忙分析下原因：

[gbasedbt@node03 ~]$ dbaccess - -
Your evaluation license will expire on 2026-07-11 00:00:00
> create database test_cdb in datadbs01 with log;

908: Attempt to connect to database server (ol_gbasedbt1210) failed.

201: A syntax error has occurred.
Error in line 1
Near character position 1
> create database gbase8s with log;

908: Attempt to connect to database server (ol_gbasedbt1210) failed.

201: A syntax error has occurred.
Error in line 1
Near character position 1
>

[gbasedbt@node03 ~]$ ps -ef|grep oninit
gbasedbt 1826646 1 0 16:13 ? 00:00:01 oninit -vy
root 1826669 1826646 0 16:13 ? 00:00:00 oninit -vy
root 1826670 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826683 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826695 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826707 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826719 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826731 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826732 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826733 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826734 1826669 0 16:13 ? 00:00:00 oninit -vy
root 1826753 1826669 0 16:13 ? 00:00:00 oninit -vy
gbasedbt 1852125 1845877 0 16:52 pts/0 00:00:00 grep --color=auto oninit
[gbasedbt@node03 ~]$

登录后才可以发表评论

liaosnet发表于 1年前

onstat -m 看一下日志吧，看着应当没有初始化成功。

Tao发表于 1年前

@liaosnet：日志已上传，再帮看下吧

Tao发表于 1年前

[gbasedbt@node03 ~]$ onstat -m
Your evaluation license will expire on 2026-07-11 00:00:00
On-Line -- Up 4 days 00:04:13 -- 175748 Kbytes

Message Log File: /backup/GBASE/gbase/ol_gbasedbt1210.log
07/11/25 16:14:02 Maximum server connections 0
07/11/25 16:14:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 3, Llog used 2

07/11/25 16:14:03 Checkpoint Completed: duration was 0 seconds.
07/11/25 16:14:03 Fri Jul 11 - loguniq 2, logpos 0x13f018, timestamp: 0xd87a Interval: 14

07/11/25 16:14:03 Maximum server connections 0
07/11/25 16:14:03 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 2

07/11/25 16:14:04 Checkpoint Completed: duration was 0 seconds.
07/11/25 16:14:04 Fri Jul 11 - loguniq 2, logpos 0x141018, timestamp: 0xd883 Interval: 15

07/11/25 16:14:04 Maximum server connections 0
07/11/25 16:14:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 2

07/11/25 16:14:04 Error building 'sysmaster' database.
07/11/25 16:14:04 See '/tmp/buildsmi.1826646'.
07/11/25 16:14:05 SCHAPI: Started dbScheduler thread.
07/11/25 16:14:06 Defragmenter cleaner thread now running
07/11/25 16:14:06 Defragmenter cleaner thread cleaned:0 partitions

[gbasedbt@node03 ~]$

Tao发表于 1年前

@Tao：[gbasedbt@node03 ~]$ more /tmp/buildsmi.1826646
If sysmaster database exists, drop it.

dbaccess: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
This file is the output of the dbaccess command in the shell script,
$GBASEDBTDIR/etc/buildsmi. This script is run when GBase
is first initialized. It builds the database and
tables which support the System Monitoring Interface. If you were
directed to see this file, a problem probably occurred while building
the database and/or its tables and views. See below for more
information regarding any problems.

Problems may have occurred if IDS was shutdown after initialization
but before the entire database was created. If this was the case,
login as 'gbasedbt', rerun 'oninit', and wait for the message

"'sysmaster' database created successfully"

to appear in the IDS message log before shutting down. Once it is
created successfully, it should never need to be recreated.

dbaccess: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
Cleaning up whatever was successfully created
dbaccess: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
[gbasedbt@node03 ~]$
[gbasedbt@node03 ~]$

Tao发表于 1年前

[gbasedbt@node03 lib64]$ ll libncurses.so*
-rw-r--r-- 1 root root 31 6月 22 2024 libncurses.so
lrwxrwxrwx 1 root root 28 7月 11 16:18 libncurses.so.5 -> /usr/lib64/libncurses.so.6.3
lrwxrwxrwx. 1 root root 17 6月 22 2024 libncurses.so.6 -> libncurses.so.6.3
-rwxr-xr-x. 1 root root 174128 6月 22 2024 libncurses.so.6.3
[gbasedbt@node03 lib64]$
[gbasedbt@node03 lib64]$

liaosnet发表于 1年前

@Tao：这个链接是后建的吗？建好后重启数据库。

GBase 8s 安装完成后，创建数据库失败

评论

热门帖子