暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

安装华为GaussDB 100 报错GS-00028:[SPACE] failed to build datafile

原创 章芋文 2019-11-01
1924

执行python install.py安装华为GaussDB 100 时报错Error: Failed to execute sql file,create_database.sample.sql

[root@pr7 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /opt/gaussdb/app -D /opt/gaussdb/data -C LSNR_ADDR=127.0.0.1,192.168.56.102 -C LSNR_PORT=1888 -C DATA_BUFFER_SIZE=200M -C SHARED_POOL_SIZE=100M -C TEMP_BUFFER_SIZE=100M Checking runner. Checking parameters. End check parameters. Checking user. End check user. Checking old install. End check old install. Checking kernel parameters. Checking directory. Checking integrality of run file... Decompressing run file. Setting user env. Checking data dir and config file Initialize db instance. Creating database. Error: Failed to execute sql file /opt/gaussdb/app/admin/scripts/create_database.sample.sql, output: connected.

查看日志,发现报错GS-00028, Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file

SQL> GS-00028, Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file SQL> Please refer to install log "/home/omm/zengineinstall.log" for more detailed information. UTC+8 2019-10-16 10:15:15.571|ZENGINE|00053|4891|INFO>[LOG] file '/opt/gaussdb/data/log/audit/zengine.aud' is added [cm_log.c:643] UTC+8 2019-10-16 10:16:09.556|ZENGINE|00053|139775415685915|INFO>[SPACE] succeed to create tablespace SYSTEM [knl_space.c:2085] UTC+8 2019-10-16 10:16:10.935|ZENGINE|00053|139775415685915|INFO>[SPACE] succeed to create tablespace TEMP [knl_space.c:2085] UTC+8 2019-10-16 10:16:14.605|ZENGINE|00053|139775415685915|INFO>[SPACE] succeed to create tablespace UNDO [knl_space.c:2085] UTC+8 2019-10-16 10:16:35.214|ZENGINE|00053|139775415685915|INFO>[SPACE] succeed to create tablespace USERS [knl_space.c:2085] UTC+8 2019-10-16 10:16:36.933|ZENGINE|00053|139775415685915|INFO>[SPACE] succeed to create tablespace TEMP2 [knl_space.c:2085] UTC+8 2019-10-16 10:16:39.636|ZENGINE|00053|4891|ERROR>GS-00028:[SPACE] failed to build datafile /opt/gaussdb/data/data/temp2_undo,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [knl_space.c:849] UTC+8 2019-10-16 10:16:39.772|ZENGINE|00053|4891|INFO>GS-00028:begin to shutdown, mode abort,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_instance.c:1693] UTC+8 2019-10-16 10:16:39.772|ZENGINE|00053|4891|INFO>GS-00028:begin to pause all listener,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_instance.c:1695] UTC+8 2019-10-16 10:16:39.868|ZENGINE|00053|4891|INFO>GS-00028:begin to pause reactor,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_instance.c:1699] UTC+8 2019-10-16 10:16:39.898|ZENGINE|00053|4891|INFO>GS-00028:begin to stop all session,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_instance.c:1704] UTC+8 2019-10-16 10:16:39.898|ZENGINE|00053|4891|INFO>GS-00028:start close jobmaster thread,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_session.c:1785] UTC+8 2019-10-16 10:16:39.898|ZENGINE|00053|4891|INFO>GS-00028:jobmaster thread closed,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_session.c:1789] UTC+8 2019-10-16 10:16:39.898|ZENGINE|00053|4891|INFO>GS-00028:start close synctimer thread,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_session.c:1798] UTC+8 2019-10-16 10:16:39.898|ZENGINE|00053|4891|INFO>GS-00028:synctimer thread closed,Write size 1970176, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file [srv_session.c:1802]

在创建temp2_undo时,也就是空间不够。

将目录空间扩大到25G后数据库创建成功。

[omm@pr7 gaussdb]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rhel-root 38G 18G 21G 47% / devtmpfs 991M 0 991M 0% /dev tmpfs 2.0G 0 2.0G 0% /dev/shm tmpfs 1001M 8.5M 993M 1% /run tmpfs 1001M 0 1001M 0% /sys/fs/cgroup /dev/sda1 497M 107M 390M 22% /boot tmpfs 201M 0 201M 0% /run/user/0 [root@pr7 oradata]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rhel-root 38G 14G 25G 35% / devtmpfs 991M 0 991M 0% /dev tmpfs 2.0G 0 2.0G 0% /dev/shm tmpfs 1001M 8.5M 993M 1% /run tmpfs 1001M 0 1001M 0% /sys/fs/cgroup /dev/sda1 497M 107M 390M 22% /boot tmpfs 201M 0 201M 0% /run/user/0
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论