GBase 8s
运维管理
问答
服务器断电后gbase服务启动报错
发表于2024-09-18 11:45:10518次浏览20个评论
为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【GBase版本】: V8.8
【操作系统】: ubantu
【CPU】:
【问题描述】*: 服务器断电后重启gbase服务启动报错，报错信息
[root@localhost gbase]# onstat -m
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Message Log File: /opt/GBASE/gbase/tmp/online_gbaseserver.log
09/18/24 11:36:12 Your evaluation license will expire on 2025-06-07 00:00:00
09/18/24 11:36:14 GBase Database Server Initialized -- Shared Memory Initialized.
09/18/24 11:36:14 Started 1 B-tree scanners.
09/18/24 11:36:14 B-tree scanner threshold set at 5000.
09/18/24 11:36:14 B-tree scanner range scan size set to -1.
09/18/24 11:36:14 B-tree scanner ALICE mode set to 6.
09/18/24 11:36:14 B-tree scanner index compression level set to med.
09/18/24 11:36:14 Physical Recovery Started at Page (3:1035097).
09/18/24 11:36:14 Physical Recovery Complete: 152 Pages Examined, 19 Pages Restored.
09/18/24 11:36:14 Logical Recovery Started.
09/18/24 11:36:14 96 recovery worker threads will be started.
09/18/24 11:36:14 Checkpoint Record not Found in Logical Log.
09/18/24 11:36:15 Cannot Rollforward from Checkpoint.
09/18/24 11:36:16 oninit: Fatal error in shared memory initialization
09/18/24 11:36:16 GBase Database Server Stopped.
11:36:16 mt_shm_remove: WARNING: may not have removed all/correct segments
[root@localhost gbase]# onstat -
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[root@localhost gbase]# onclean -ky
Your evaluation license will expire on 2025-06-07 00:00:00
onclean: Cleaning up processes and resources for 'gbaseserver'...
- Looking for the shmem key: 52e84803
- Looking for the shmem key: 52e84804
- Looking for semaphore ID: 42
- Looking for the shmem key: 52e84801
- Looking for the shmem key: 52e84802
[root@localhost gbase]# ipcs -m
------------ 共享内存段 --------------
键 shmid 拥有者 权限 字节 nattch 状态
0x00000000 0 postgres 600 56 6 目标
评论
登录后才可以发表评论
琳大大发表于 1年前
onclean后再用oninit -vy起下试试
GBase用户16900发表于 1年前
@琳大大：onclean后，在启动还是一样的报错：
onclean
Your evaluation license will expire on 2025-06-07 00:00:00
onclean: Cleaning up processes and resources for 'gbaseserver'...
Do you wish to continue (y/n)? y
- Looking for the shmem key: 52e84803
- Looking for the shmem key: 52e84804
- Looking for semaphore ID: 14
- Looking for the shmem key: 52e84801
- Looking for the shmem key: 52e84802
[gbasedbt@localhost ~]$ onstat -m
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Message Log File: /opt/GBASE/gbase/tmp/online_gbaseserver.log
09/18/24 14:22:06 GBase Database Server Version 12.10.FC4G1TL Software Serial Number AAA#B000000
09/18/24 14:22:06 Your evaluation license will expire on 2025-06-07 00:00:00
09/18/24 14:22:07 (4) connection rejected - no calls allowed for sqlexec
09/18/24 14:22:08 (5) connection rejected - no calls allowed for sqlexec
09/18/24 14:22:09 GBase Database Server Initialized -- Shared Memory Initialized.
09/18/24 14:22:09 Started 1 B-tree scanners.
09/18/24 14:22:09 B-tree scanner threshold set at 5000.
09/18/24 14:22:09 B-tree scanner range scan size set to -1.
09/18/24 14:22:09 B-tree scanner ALICE mode set to 6.
09/18/24 14:22:09 B-tree scanner index compression level set to med.
09/18/24 14:22:09 Physical Recovery Started at Page (3:1035097).
09/18/24 14:22:09 Physical Recovery Complete: 152 Pages Examined, 19 Pages Restored.
09/18/24 14:22:09 Logical Recovery Started.
09/18/24 14:22:09 96 recovery worker threads will be started.
09/18/24 14:22:09 Checkpoint Record not Found in Logical Log.
09/18/24 14:22:10 Cannot Rollforward from Checkpoint.
09/18/24 14:22:11 oninit: Fatal error in shared memory initialization
onclean
Your evaluation license will expire on 2025-06-07 00:00:00
onclean: Cleaning up processes and resources for 'gbaseserver'...
Do you wish to continue (y/n)? y
- Looking for the shmem key: 52e84803
- Looking for the shmem key: 52e84804
- Looking for semaphore ID: 14
- Looking for the shmem key: 52e84801
- Looking for the shmem key: 52e84802
[gbasedbt@localhost ~]$ onstat -m
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Message Log File: /opt/GBASE/gbase/tmp/online_gbaseserver.log
09/18/24 14:22:06 GBase Database Server Version 12.10.FC4G1TL Software Serial Number AAA#B000000
09/18/24 14:22:06 Your evaluation license will expire on 2025-06-07 00:00:00
09/18/24 14:22:07 (4) connection rejected - no calls allowed for sqlexec
09/18/24 14:22:08 (5) connection rejected - no calls allowed for sqlexec
09/18/24 14:22:09 GBase Database Server Initialized -- Shared Memory Initialized.
09/18/24 14:22:09 Started 1 B-tree scanners.
09/18/24 14:22:09 B-tree scanner threshold set at 5000.
09/18/24 14:22:09 B-tree scanner range scan size set to -1.
09/18/24 14:22:09 B-tree scanner ALICE mode set to 6.
09/18/24 14:22:09 B-tree scanner index compression level set to med.
09/18/24 14:22:09 Physical Recovery Started at Page (3:1035097).
09/18/24 14:22:09 Physical Recovery Complete: 152 Pages Examined, 19 Pages Restored.
09/18/24 14:22:09 Logical Recovery Started.
09/18/24 14:22:09 96 recovery worker threads will be started.
09/18/24 14:22:09 Checkpoint Record not Found in Logical Log.
09/18/24 14:22:10 Cannot Rollforward from Checkpoint.
09/18/24 14:22:11 oninit: Fatal error in shared memory initialization
9527发表于 1年前
估计是有进程占用了没释放。可以通过重启服务器或者杀掉oninit 相关进程后重启
GBase用户16900发表于 1年前
@9527：服务器重启过了也不行
9527发表于 1年前
@GBase用户16900：看日志，像逻辑日志损坏了。可以通过截日志的方式重新启动数据库。
9527发表于 1年前
@GBase用户16900：
export IFX_ASKEY=ZEXPGHDK
oncheck -S 截日志
方法1：
oncheck -S zero -y
oninit -v
该命令将日志截断到最后checkpoint，并且将open的事务回滚。
回滚过程中可能仍然失败导致起不来。
方法2：
oncheck -S zero -n -y
oninit -v
该命令将日志截断到最后checkpoint，并且不会回滚事务，因此可能会导致数据不一致。
如果方法1失败，可以尝试该方法。
export IFX_ASKEY=ZEXPGHDK
oncheck -S 截日志
方法1：
oncheck -S zero -y
oninit -v
该命令将日志截断到最后checkpoint，并且将open的事务回滚。
回滚过程中可能仍然失败导致起不来。
方法2：
oncheck -S zero -n -y
oninit -v
该命令将日志截断到最后checkpoint，并且不会回滚事务，因此可能会导致数据不一致。
如果方法1失败，可以尝试该方法。
GBase用户16900发表于 1年前
@9527：你说的两个方法我都试了，数据库还是启动不了
oncheck -S zero -y
Your evaluation license will expire on 2025-06-07 00:00:00
GBASEDBT ENVIRONMENT:
GBASEDBTDIR ................ /opt/GBASE/gbase
GBASEDBTSERVER ............. gbaseserver
ONCONFIG ................... onconfig.gbaseserver
ROOTPATH ................... /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET ................. 0
MIRROR ..................... 0
MIRROR IS TURNED OFF.
Checkpoint at Loguniq 71 Logpos 0x4923018
ERROR: Log page has wrong log info
[root@localhost gbasedbt]# oninit -v
Your evaluation license will expire on 2025-06-07 00:00:00
Reading configuration file '/opt/GBASE/gbase/etc/onconfig.gbaseserver'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 131486 kbytes...succeeded
Creating infos file "/opt/GBASE/gbase/etc/.infos.gbaseserver"...succeeded
Linking conf file "/opt/GBASE/gbase/etc/.conf.gbaseserver"...succeeded
Initializing rhead structure...rhlock_t 131072 (4096K)... rlock_t (119531K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
oninit: Fatal error in shared memory initialization
WARNING: server initialization failed or timed out.
Check the message log, online.log, for errors.
oncheck -S zero -n -y
Your evaluation license will expire on 2025-06-07 00:00:00
GBASEDBT ENVIRONMENT:
GBASEDBTDIR ................ /opt/GBASE/gbase
GBASEDBTSERVER ............. gbaseserver
ONCONFIG ................... onconfig.gbaseserver
ROOTPATH ................... /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET ................. 0
MIRROR ..................... 0
MIRROR IS TURNED OFF.
Checkpoint at Loguniq 71 Logpos 0x4923018
ERROR: Log page has wrong log info
[root@localhost gbasedbt]# oninit -v
Your evaluation license will expire on 2025-06-07 00:00:00
Reading configuration file '/opt/GBASE/gbase/etc/onconfig.gbaseserver'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 131486 kbytes...succeeded
Creating infos file "/opt/GBASE/gbase/etc/.infos.gbaseserver"...succeeded
Linking conf file "/opt/GBASE/gbase/etc/.conf.gbaseserver"...succeeded
Initializing rhead structure...rhlock_t 131072 (4096K)... rlock_t (119531K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
oninit: Fatal error in shared memory initialization
WARNING: server initialization failed or timed out.
Check the message log, online.log, for errors.
[root@localhost gbasedbt]# onstat -m
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Message Log File: /opt/GBASE/gbase/tmp/online_gbaseserver.log
09/18/24 15:42:12 SQL_DEF_CTRL value set to 0x4b0
09/18/24 15:42:12 Event notification facility epoll enabled.
09/18/24 15:42:12 GBase Database Server Version 12.10.FC4G1TL Software Serial Number AAA#B000000
09/18/24 15:42:12 Your evaluation license will expire on 2025-06-07 00:00:00
09/18/24 15:42:14 GBase Database Server Initialized -- Shared Memory Initialized.
09/18/24 15:42:14 Started 1 B-tree scanners.
09/18/24 15:42:14 B-tree scanner threshold set at 5000.
09/18/24 15:42:14 B-tree scanner range scan size set to -1.
09/18/24 15:42:14 B-tree scanner ALICE mode set to 6.
09/18/24 15:42:14 B-tree scanner index compression level set to med.
09/18/24 15:42:14 Physical Recovery Started at Page (3:1035097).
09/18/24 15:42:14 Physical Recovery Complete: 152 Pages Examined, 19 Pages Restored.
09/18/24 15:42:14 Logical Recovery Started.
09/18/24 15:42:14 96 recovery worker threads will be started.
09/18/24 15:42:14 Checkpoint Record not Found in Logical Log.
09/18/24 15:42:15 Cannot Rollforward from Checkpoint.
09/18/24 15:42:16 oninit: Fatal error in shared memory initialization
oncheck -S zero -y
Your evaluation license will expire on 2025-06-07 00:00:00
GBASEDBT ENVIRONMENT:
GBASEDBTDIR ................ /opt/GBASE/gbase
GBASEDBTSERVER ............. gbaseserver
ONCONFIG ................... onconfig.gbaseserver
ROOTPATH ................... /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET ................. 0
MIRROR ..................... 0
MIRROR IS TURNED OFF.
Checkpoint at Loguniq 71 Logpos 0x4923018
ERROR: Log page has wrong log info
[root@localhost gbasedbt]# oninit -v
Your evaluation license will expire on 2025-06-07 00:00:00
Reading configuration file '/opt/GBASE/gbase/etc/onconfig.gbaseserver'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 131486 kbytes...succeeded
Creating infos file "/opt/GBASE/gbase/etc/.infos.gbaseserver"...succeeded
Linking conf file "/opt/GBASE/gbase/etc/.conf.gbaseserver"...succeeded
Initializing rhead structure...rhlock_t 131072 (4096K)... rlock_t (119531K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
oninit: Fatal error in shared memory initialization
WARNING: server initialization failed or timed out.
Check the message log, online.log, for errors.
oncheck -S zero -n -y
Your evaluation license will expire on 2025-06-07 00:00:00
GBASEDBT ENVIRONMENT:
GBASEDBTDIR ................ /opt/GBASE/gbase
GBASEDBTSERVER ............. gbaseserver
ONCONFIG ................... onconfig.gbaseserver
ROOTPATH ................... /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET ................. 0
MIRROR ..................... 0
MIRROR IS TURNED OFF.
Checkpoint at Loguniq 71 Logpos 0x4923018
ERROR: Log page has wrong log info
[root@localhost gbasedbt]# oninit -v
Your evaluation license will expire on 2025-06-07 00:00:00
Reading configuration file '/opt/GBASE/gbase/etc/onconfig.gbaseserver'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 131486 kbytes...succeeded
Creating infos file "/opt/GBASE/gbase/etc/.infos.gbaseserver"...succeeded
Linking conf file "/opt/GBASE/gbase/etc/.conf.gbaseserver"...succeeded
Initializing rhead structure...rhlock_t 131072 (4096K)... rlock_t (119531K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
oninit: Fatal error in shared memory initialization
WARNING: server initialization failed or timed out.
Check the message log, online.log, for errors.
[root@localhost gbasedbt]# onstat -m
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Message Log File: /opt/GBASE/gbase/tmp/online_gbaseserver.log
09/18/24 15:42:12 SQL_DEF_CTRL value set to 0x4b0
09/18/24 15:42:12 Event notification facility epoll enabled.
09/18/24 15:42:12 GBase Database Server Version 12.10.FC4G1TL Software Serial Number AAA#B000000
09/18/24 15:42:12 Your evaluation license will expire on 2025-06-07 00:00:00
09/18/24 15:42:14 GBase Database Server Initialized -- Shared Memory Initialized.
09/18/24 15:42:14 Started 1 B-tree scanners.
09/18/24 15:42:14 B-tree scanner threshold set at 5000.
09/18/24 15:42:14 B-tree scanner range scan size set to -1.
09/18/24 15:42:14 B-tree scanner ALICE mode set to 6.
09/18/24 15:42:14 B-tree scanner index compression level set to med.
09/18/24 15:42:14 Physical Recovery Started at Page (3:1035097).
09/18/24 15:42:14 Physical Recovery Complete: 152 Pages Examined, 19 Pages Restored.
09/18/24 15:42:14 Logical Recovery Started.
09/18/24 15:42:14 96 recovery worker threads will be started.
09/18/24 15:42:14 Checkpoint Record not Found in Logical Log.
09/18/24 15:42:15 Cannot Rollforward from Checkpoint.
09/18/24 15:42:16 oninit: Fatal error in shared memory initialization
liaosnet发表于 1年前
@GBase用户16900：这个需要root用户来操作，使用gbasedbt用户环境变量。。
BTW：export IFX_ASKEY 这个安全码起决于你的操作系统时间。
BTW：export IFX_ASKEY 这个安全码起决于你的操作系统时间。
liaosnet发表于 1年前
@GBase用户16900：先oncheck -pr 看一下检查点部分信息 CKPT信息。
类似于：
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_1CKPT.
Time stamp of checkpoint 0x4959e07
Time of checkpoint 09/18/2024 16:42:06
Physical log begin address 2:53
Physical log size 500000 (p)
Physical log position at Ckpt 360501
Logical log unique identifier 45
Logical log position at Ckpt 0x56fc018 (Page 22268, byte 24)
Checkpoint Interval 7561
DBspace descriptor page 1:4
Chunk descriptor page 1:7
Mirror chunk descriptor page 1:8
类似于：
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_1CKPT.
Time stamp of checkpoint 0x4959e07
Time of checkpoint 09/18/2024 16:42:06
Physical log begin address 2:53
Physical log size 500000 (p)
Physical log position at Ckpt 360501
Logical log unique identifier 45
Logical log position at Ckpt 0x56fc018 (Page 22268, byte 24)
Checkpoint Interval 7561
DBspace descriptor page 1:4
Chunk descriptor page 1:7
Mirror chunk descriptor page 1:8
liaosnet发表于 1年前
这是单机？还是集群环境？
09/18/24 11:36:14 Checkpoint Record not Found in Logical Log.
09/18/24 11:36:15 Cannot Rollforward from Checkpoint.
这个看起来是逻辑日志文件上没有相应的检查点记录，是突然断电了？
09/18/24 11:36:14 Checkpoint Record not Found in Logical Log.
09/18/24 11:36:15 Cannot Rollforward from Checkpoint.
这个看起来是逻辑日志文件上没有相应的检查点记录，是突然断电了？
GBase用户16900发表于 1年前
@liaosnet：单机版 ，是突然断电的
liaosnet发表于 1年前
@GBase用户16900：看情景存在逻辑日志记录在操作系统缓存中，没刷回到碰盘的情况。
GBase用户16900发表于 1年前
@liaosnet：这种情况数据库还能启动吗？该如何设置才能启动？
liaosnet发表于 1年前
@GBase用户16900：oncheck -pr 输出 Validating PAGE_1CKPT & PAGE_2CKPT... 这部分看一下。考虑重建一个检查点。
最佳回答
GBase用户16900发表于 1年前
@liaosnet：oncheck -pr
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Validating GBase Database Server reserved pages
Validating PAGE_PZERO...
Identity GBase Database Server Co
pyright 2001, 2023 Gene
ral Data Corporation
Database system state 0
Database system flags 0x3
Page Size 2048 (b)
Date/Time created 06/07/2024 17:19:06
Version number of creator 33
Last modified time stamp 0
UID of rootdbs creator 1001
Index Page Logging ON since 06/07/2024 17:19:06
HA Disk Owner
Validating PAGE_CONFIG...
ROOTNAME rootdbs
ROOTPATH /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET 0 (k)
ROOTSIZE 204800 (k)
MIRROR 0
MIRRORPATH /opt/GBASE/gbase/tmp/demo_on.root_mirror
MIRROROFFSET 0 (k)
DBSERVERNAME gbaseserver
SERVERNUM 146
MSGPATH /opt/GBASE/gbase/tmp/online_gbaseserver.log
TAPEDEV /dev/null
TAPESIZE 0 (k)
TAPEBLK 32 (k)
LTAPEDEV /dev/null
LTAPESIZE 0 (k)
LTAPEBLK 32 (k)
PHYSFILE 3280200 (k)
PHYSBUFF 2048 (k)
LOGFILES 40
LOGSIZE 10000 (k)
LOGBUFF 1024 (k)
DYNAMIC_LOGS 2
LTXHWM 70 (%)
LTXEHWM 80 (%)
RESIDENT 0
CLEANERS 32
SHMBASE 0x44000000
CKPTINTVL 120 (s)
DBSPACETEMP tmpdbs1,tmpdbs2
PLOG_OVERFLOW_PATH /opt/GBASE/gbase/tmp
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=med
RTO_SERVER_RESTART 0 (s)
RAS_PLOG_SPEED 1020911
RAS_LLOG_SPEED 0
AUTO_TUNE_SERVER_SIZE OFF
AUTO_LLOG 0
AUTO_LRU_TUNING 1
AUTO_CKPTS 0
AUTO_AIOVPS 1
BACKUP_FILTER
RESTORE_FILTER
STORAGE_FULL_ALARM 600,3
CONVERSION_GUARD 2
RESTORE_POINT_DIR /opt/GBASE/gbase/tmp
SP_AUTOEXPAND 1
SP_THRESHOLD 0
FULL_DISK_INIT 0
AUTO_READAHEAD 1,128
UNSECURE_ONSTAT 0
SHMVIRTSIZE 435200 (k)
STACKSIZE 128 (k)
SHMADD 435200
SHMTOTAL 0 (k)
ALARMPROGRAM /opt/GBASE/gbase/etc/alarmprogram.sh
VP_MEMORY_CACHE_KB 0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
SBSPACENAME sbspace1
SYSSBSPACENAME sbspace1
SBSPACETEMP
DS_MAX_QUERIES 4
DS_TOTAL_MEMORY 4096000
DS_MAX_SCANS 1048576
OPTCOMPIND 2
MAX_PDQPRIORITY 100
DIRECTIVES 1
OPT_GOAL -1
AUTO_REPREPARE 1
JVPLOGFILE /opt/GBASE/gbase/tmp/jvp.log
ENCRYPT_CIPHERS
ENCRYPT_MAC medium
ENCRYPT_CDR 0
ENCRYPT_HDR 0
ENCRYPT_SWITCH
ENCRYPT_SMX 0
SYSSYNCCACH 0
CONSOLE /opt/GBASE/gbase/tmp/online.con
DEADLOCK_TIMEOUT 60 (s)
LOCKS 900000
ONDBSPACEDOWN 2
TXTIMEOUT 300 (s)
RA_PAGES
FILLFACTOR 90 (%)
OFF_RECVRY_THREADS 96
ON_RECVRY_THREADS 16
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Time stamp of checkpoint 0x1bd00cf
Time of checkpoint 09/16/2024 01:26:00
Physical log begin address 3:53
Physical log size 1640100 (p)
Physical log position at Ckpt 1035044
Logical log unique identifier 71
Logical log position at Ckpt 0x4923018 (Page 18723, byte 24)
Checkpoint Interval 5766
DBspace descriptor page 1:5
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
Log file number 4
Unique identifier 47
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:53
Log size 41000 (p)
Number pages used 40999
Date/Time file filled 09/03/2024 18:50:34
Time stamp 0x114ec62
Log file number 5
Unique identifier 48
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:41053
Log size 41000 (p)
Number pages used 40998
Date/Time file filled 09/03/2024 19:16:52
Time stamp 0x116cac2
Log file number 6
Unique identifier 49
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:82053
Log size 41000 (p)
Number pages used 40996
Date/Time file filled 09/03/2024 19:21:11
Time stamp 0x117b71d
Log file number 7
Unique identifier 50
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:123053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/05/2024 11:34:38
Time stamp 0x11b691e
Log file number 8
Unique identifier 51
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:164053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/05/2024 11:34:57
Time stamp 0x122efeb
Log file number 9
Unique identifier 52
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:205053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/10/2024 15:54:43
Time stamp 0x12f4d8e
Log file number 10
Unique identifier 53
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:246053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/10/2024 15:54:56
Time stamp 0x1373ef3
Log file number 11
Unique identifier 54
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:287053
Log size 41000 (p)
Number pages used 40996
Date/Time file filled 09/10/2024 16:14:50
Time stamp 0x13931ec
Log file number 12
Unique identifier 55
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:328053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/12/2024 16:25:47
Time stamp 0x1413b7c
Log file number 13
Unique identifier 56
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:369053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:21
Time stamp 0x14d5e07
Log file number 14
Unique identifier 57
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:410053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:32
Time stamp 0x1538e92
Log file number 15
Unique identifier 58
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:451053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:42
Time stamp 0x159bfae
Log file number 16
Unique identifier 59
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:492053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:53
Time stamp 0x15ff5bb
Log file number 17
Unique identifier 60
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:533053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:03
Time stamp 0x16636f0
Log file number 18
Unique identifier 61
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:574053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:21
Time stamp 0x16c7bf5
Log file number 19
Unique identifier 62
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:615053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:33
Time stamp 0x171d4ea
Log file number 20
Unique identifier 63
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:656053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:41
Time stamp 0x17532b3
Log file number 21
Unique identifier 64
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:697053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:51
Time stamp 0x17a154c
Log file number 22
Unique identifier 65
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:738053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:58
Time stamp 0x17cb026
Log file number 23
Unique identifier 66
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:779053
Log size 41000 (p)
Number pages used 40999
Date/Time file filled 09/13/2024 17:21:06
Time stamp 0x17f73dd
Log file number 24
Unique identifier 67
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:820053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:21:23
Time stamp 0x182680f
Log file number 25
Unique identifier 68
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:861053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:21:34
Time stamp 0x18849b8
Log file number 26
Unique identifier 69
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:902053
Log size 41000 (p)
Number pages used 40995
Date/Time file filled 09/13/2024 17:33:39
Time stamp 0x18d3c61
Log file number 27
Unique identifier 70
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:943053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/15/2024 15:30:02
Time stamp 0x1ac2b6c
Log file number 28
Unique identifier 71
Log contains last checkpoint: Page 18723, byte 24
Log file flags 0x3 Log file in use
& Current log file
Physical location 2:984053
Log size 41000 (p)
Number pages used 18724
Date/Time file filled -
Time stamp -
Log file number 29
Unique identifier 32
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1025053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:31:59
Time stamp 0x9e7b9e
Log file number 30
Unique identifier 33
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1066053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:07
Time stamp 0xa4f0c2
Log file number 31
Unique identifier 34
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1107053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:21
Time stamp 0xae24e1
Log file number 32
Unique identifier 35
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1148053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:31
Time stamp 0xbb2b66
Log file number 33
Unique identifier 36
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1189053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:40
Time stamp 0xc89097
Log file number 34
Unique identifier 37
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1230053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:52
Time stamp 0xd47140
Log file number 35
Unique identifier 38
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1271053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:06
Time stamp 0xdeda90
Log file number 36
Unique identifier 39
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1312053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:20
Time stamp 0xe8d702
Log file number 37
Unique identifier 40
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1353053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:34
Time stamp 0xf0cf8b
Log file number 38
Unique identifier 41
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1394053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:51
Time stamp 0xf9df19
Log file number 39
Unique identifier 42
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1435053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:10
Time stamp 0xfe34b1
Log file number 40
Unique identifier 43
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1476053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:30
Time stamp 0x10289f5
Log file number 41
Unique identifier 44
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1517053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:49
Time stamp 0x106ddcb
Log file number 42
Unique identifier 45
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1558053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:35:06
Time stamp 0x10b14ed
Log file number 43
Unique identifier 46
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1599053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:35:19
Time stamp 0x1125eba
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_2DBSP.
DBspace number 1
DBspace name rootdbs
Flags 0x70001 No mirror chunks
& Physical/logical log changed
Number of chunks 1
First chunk 1
Date/Time created 06/07/2024 17:19:06
Partition table page number 14
Pagesize (k) 2
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 2
DBspace name llogdbs
Flags 0x60001 No mirror chunks
Number of chunks 1
First chunk 2
Date/Time created 06/07/2024 17:19:36
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x128e148
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 3
DBspace name plogdbs
Flags 0x70001 No mirror chunks
& Physical/logical log changed
Number of chunks 1
First chunk 3
Date/Time created 06/07/2024 17:19:39
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x1290088
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 4
DBspace name sbspace1
Flags 0x68001 No mirror chunks
& sbspace
Number of chunks 1
First chunk 4
Date/Time created 06/07/2024 17:19:42
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x1293050
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 0.0%
DBspace archive status No archives have occurred.
DBspace number 5
DBspace name tmpdbs1
Flags 0x42001 No mirror chunks
& Temporary DBspace
Number of chunks 1
First chunk 5
Date/Time created 06/07/2024 17:19:44
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 4
Logical Log Position 0x56334
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 6
DBspace name tmpdbs2
Flags 0x42001 No mirror chunks
& Temporary DBspace
Number of chunks 1
First chunk 6
Date/Time created 06/07/2024 17:19:45
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 4
Logical Log Position 0xbfa078
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 7
DBspace name datadbs1
Flags 0x60001 No mirror chunks
Number of chunks 1
First chunk 7
Date/Time created 06/07/2024 17:19:53
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 5
Logical Log Position 0xe1a0c0
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_1PCHUNK.
Chunk number 1
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
Chunk offset 0 (p)
Chunk size 102400 (p)
Number of free pages 84153
DBspace number 1
Chunk number 2
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/llogdbs
Chunk offset 0 (p)
Chunk size 1689600 (p)
Number of free pages 49547
DBspace number 2
Chunk number 3
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/plogdbs
Chunk offset 0 (p)
Chunk size 1689600 (p)
Number of free pages 49447
DBspace number 3
Chunk number 4
Flags 0x34040 Chunk is online
& Part of an sbspace
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/sbspace1
Chunk offset 0 (p)
Chunk size 2560000 (p)
Number of free pages 128230
DBspace number 4
Chunk number 5
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/tmpdbs1
Chunk offset 0 (p)
Chunk size 128000 (p)
Number of free pages 127947
DBspace number 5
Chunk number 6
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/tmpdbs2
Chunk offset 0 (p)
Chunk size 128000 (p)
Number of free pages 127947
DBspace number 6
Chunk number 7
Flags 0x32040 Chunk is online
& Chunk is extendable
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/datadbs1_1
Chunk offset 0 (p)
Chunk size 640000 (p)
Number of free pages 501765
DBspace number 7
Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_1ARCH.
No archives have occurred.
DR has not been initialized.
Your evaluation license will expire on 2025-06-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
Validating GBase Database Server reserved pages
Validating PAGE_PZERO...
Identity GBase Database Server Co
pyright 2001, 2023 Gene
ral Data Corporation
Database system state 0
Database system flags 0x3
Page Size 2048 (b)
Date/Time created 06/07/2024 17:19:06
Version number of creator 33
Last modified time stamp 0
UID of rootdbs creator 1001
Index Page Logging ON since 06/07/2024 17:19:06
HA Disk Owner
Validating PAGE_CONFIG...
ROOTNAME rootdbs
ROOTPATH /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
ROOTOFFSET 0 (k)
ROOTSIZE 204800 (k)
MIRROR 0
MIRRORPATH /opt/GBASE/gbase/tmp/demo_on.root_mirror
MIRROROFFSET 0 (k)
DBSERVERNAME gbaseserver
SERVERNUM 146
MSGPATH /opt/GBASE/gbase/tmp/online_gbaseserver.log
TAPEDEV /dev/null
TAPESIZE 0 (k)
TAPEBLK 32 (k)
LTAPEDEV /dev/null
LTAPESIZE 0 (k)
LTAPEBLK 32 (k)
PHYSFILE 3280200 (k)
PHYSBUFF 2048 (k)
LOGFILES 40
LOGSIZE 10000 (k)
LOGBUFF 1024 (k)
DYNAMIC_LOGS 2
LTXHWM 70 (%)
LTXEHWM 80 (%)
RESIDENT 0
CLEANERS 32
SHMBASE 0x44000000
CKPTINTVL 120 (s)
DBSPACETEMP tmpdbs1,tmpdbs2
PLOG_OVERFLOW_PATH /opt/GBASE/gbase/tmp
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=med
RTO_SERVER_RESTART 0 (s)
RAS_PLOG_SPEED 1020911
RAS_LLOG_SPEED 0
AUTO_TUNE_SERVER_SIZE OFF
AUTO_LLOG 0
AUTO_LRU_TUNING 1
AUTO_CKPTS 0
AUTO_AIOVPS 1
BACKUP_FILTER
RESTORE_FILTER
STORAGE_FULL_ALARM 600,3
CONVERSION_GUARD 2
RESTORE_POINT_DIR /opt/GBASE/gbase/tmp
SP_AUTOEXPAND 1
SP_THRESHOLD 0
FULL_DISK_INIT 0
AUTO_READAHEAD 1,128
UNSECURE_ONSTAT 0
SHMVIRTSIZE 435200 (k)
STACKSIZE 128 (k)
SHMADD 435200
SHMTOTAL 0 (k)
ALARMPROGRAM /opt/GBASE/gbase/etc/alarmprogram.sh
VP_MEMORY_CACHE_KB 0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
SBSPACENAME sbspace1
SYSSBSPACENAME sbspace1
SBSPACETEMP
DS_MAX_QUERIES 4
DS_TOTAL_MEMORY 4096000
DS_MAX_SCANS 1048576
OPTCOMPIND 2
MAX_PDQPRIORITY 100
DIRECTIVES 1
OPT_GOAL -1
AUTO_REPREPARE 1
JVPLOGFILE /opt/GBASE/gbase/tmp/jvp.log
ENCRYPT_CIPHERS
ENCRYPT_MAC medium
ENCRYPT_CDR 0
ENCRYPT_HDR 0
ENCRYPT_SWITCH
ENCRYPT_SMX 0
SYSSYNCCACH 0
CONSOLE /opt/GBASE/gbase/tmp/online.con
DEADLOCK_TIMEOUT 60 (s)
LOCKS 900000
ONDBSPACEDOWN 2
TXTIMEOUT 300 (s)
RA_PAGES
FILLFACTOR 90 (%)
OFF_RECVRY_THREADS 96
ON_RECVRY_THREADS 16
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Time stamp of checkpoint 0x1bd00cf
Time of checkpoint 09/16/2024 01:26:00
Physical log begin address 3:53
Physical log size 1640100 (p)
Physical log position at Ckpt 1035044
Logical log unique identifier 71
Logical log position at Ckpt 0x4923018 (Page 18723, byte 24)
Checkpoint Interval 5766
DBspace descriptor page 1:5
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
Log file number 4
Unique identifier 47
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:53
Log size 41000 (p)
Number pages used 40999
Date/Time file filled 09/03/2024 18:50:34
Time stamp 0x114ec62
Log file number 5
Unique identifier 48
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:41053
Log size 41000 (p)
Number pages used 40998
Date/Time file filled 09/03/2024 19:16:52
Time stamp 0x116cac2
Log file number 6
Unique identifier 49
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:82053
Log size 41000 (p)
Number pages used 40996
Date/Time file filled 09/03/2024 19:21:11
Time stamp 0x117b71d
Log file number 7
Unique identifier 50
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:123053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/05/2024 11:34:38
Time stamp 0x11b691e
Log file number 8
Unique identifier 51
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:164053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/05/2024 11:34:57
Time stamp 0x122efeb
Log file number 9
Unique identifier 52
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:205053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/10/2024 15:54:43
Time stamp 0x12f4d8e
Log file number 10
Unique identifier 53
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:246053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/10/2024 15:54:56
Time stamp 0x1373ef3
Log file number 11
Unique identifier 54
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:287053
Log size 41000 (p)
Number pages used 40996
Date/Time file filled 09/10/2024 16:14:50
Time stamp 0x13931ec
Log file number 12
Unique identifier 55
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:328053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/12/2024 16:25:47
Time stamp 0x1413b7c
Log file number 13
Unique identifier 56
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:369053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:21
Time stamp 0x14d5e07
Log file number 14
Unique identifier 57
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:410053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:32
Time stamp 0x1538e92
Log file number 15
Unique identifier 58
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:451053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:42
Time stamp 0x159bfae
Log file number 16
Unique identifier 59
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:492053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:19:53
Time stamp 0x15ff5bb
Log file number 17
Unique identifier 60
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:533053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:03
Time stamp 0x16636f0
Log file number 18
Unique identifier 61
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:574053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:21
Time stamp 0x16c7bf5
Log file number 19
Unique identifier 62
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:615053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:33
Time stamp 0x171d4ea
Log file number 20
Unique identifier 63
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:656053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:41
Time stamp 0x17532b3
Log file number 21
Unique identifier 64
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:697053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:51
Time stamp 0x17a154c
Log file number 22
Unique identifier 65
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:738053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:20:58
Time stamp 0x17cb026
Log file number 23
Unique identifier 66
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:779053
Log size 41000 (p)
Number pages used 40999
Date/Time file filled 09/13/2024 17:21:06
Time stamp 0x17f73dd
Log file number 24
Unique identifier 67
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:820053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:21:23
Time stamp 0x182680f
Log file number 25
Unique identifier 68
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:861053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/13/2024 17:21:34
Time stamp 0x18849b8
Log file number 26
Unique identifier 69
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:902053
Log size 41000 (p)
Number pages used 40995
Date/Time file filled 09/13/2024 17:33:39
Time stamp 0x18d3c61
Log file number 27
Unique identifier 70
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:943053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/15/2024 15:30:02
Time stamp 0x1ac2b6c
Log file number 28
Unique identifier 71
Log contains last checkpoint: Page 18723, byte 24
Log file flags 0x3 Log file in use
& Current log file
Physical location 2:984053
Log size 41000 (p)
Number pages used 18724
Date/Time file filled -
Time stamp -
Log file number 29
Unique identifier 32
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1025053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:31:59
Time stamp 0x9e7b9e
Log file number 30
Unique identifier 33
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1066053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:07
Time stamp 0xa4f0c2
Log file number 31
Unique identifier 34
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1107053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:21
Time stamp 0xae24e1
Log file number 32
Unique identifier 35
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1148053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:31
Time stamp 0xbb2b66
Log file number 33
Unique identifier 36
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1189053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:40
Time stamp 0xc89097
Log file number 34
Unique identifier 37
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1230053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:32:52
Time stamp 0xd47140
Log file number 35
Unique identifier 38
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1271053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:06
Time stamp 0xdeda90
Log file number 36
Unique identifier 39
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1312053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:20
Time stamp 0xe8d702
Log file number 37
Unique identifier 40
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1353053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:34
Time stamp 0xf0cf8b
Log file number 38
Unique identifier 41
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1394053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:33:51
Time stamp 0xf9df19
Log file number 39
Unique identifier 42
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1435053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:10
Time stamp 0xfe34b1
Log file number 40
Unique identifier 43
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1476053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:30
Time stamp 0x10289f5
Log file number 41
Unique identifier 44
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1517053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:34:49
Time stamp 0x106ddcb
Log file number 42
Unique identifier 45
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1558053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:35:06
Time stamp 0x10b14ed
Log file number 43
Unique identifier 46
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 2:1599053
Log size 41000 (p)
Number pages used 41000
Date/Time file filled 09/03/2024 18:35:19
Time stamp 0x1125eba
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_2DBSP.
DBspace number 1
DBspace name rootdbs
Flags 0x70001 No mirror chunks
& Physical/logical log changed
Number of chunks 1
First chunk 1
Date/Time created 06/07/2024 17:19:06
Partition table page number 14
Pagesize (k) 2
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 2
DBspace name llogdbs
Flags 0x60001 No mirror chunks
Number of chunks 1
First chunk 2
Date/Time created 06/07/2024 17:19:36
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x128e148
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 3
DBspace name plogdbs
Flags 0x70001 No mirror chunks
& Physical/logical log changed
Number of chunks 1
First chunk 3
Date/Time created 06/07/2024 17:19:39
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x1290088
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 4
DBspace name sbspace1
Flags 0x68001 No mirror chunks
& sbspace
Number of chunks 1
First chunk 4
Date/Time created 06/07/2024 17:19:42
Partition table page number 4
Pagesize (k) 2
Logical Log Unique Id 3
Logical Log Position 0x1293050
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 0.0%
DBspace archive status No archives have occurred.
DBspace number 5
DBspace name tmpdbs1
Flags 0x42001 No mirror chunks
& Temporary DBspace
Number of chunks 1
First chunk 5
Date/Time created 06/07/2024 17:19:44
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 4
Logical Log Position 0x56334
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 6
DBspace name tmpdbs2
Flags 0x42001 No mirror chunks
& Temporary DBspace
Number of chunks 1
First chunk 6
Date/Time created 06/07/2024 17:19:45
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 4
Logical Log Position 0xbfa078
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 7
DBspace name datadbs1
Flags 0x60001 No mirror chunks
Number of chunks 1
First chunk 7
Date/Time created 06/07/2024 17:19:53
Partition table page number 32
Pagesize (k) 16
Logical Log Unique Id 5
Logical Log Position 0xe1a0c0
Oldest Logical Log Unique Id 71
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_1PCHUNK.
Chunk number 1
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/rootdbs
Chunk offset 0 (p)
Chunk size 102400 (p)
Number of free pages 84153
DBspace number 1
Chunk number 2
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/llogdbs
Chunk offset 0 (p)
Chunk size 1689600 (p)
Number of free pages 49547
DBspace number 2
Chunk number 3
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/plogdbs
Chunk offset 0 (p)
Chunk size 1689600 (p)
Number of free pages 49447
DBspace number 3
Chunk number 4
Flags 0x34040 Chunk is online
& Part of an sbspace
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/sbspace1
Chunk offset 0 (p)
Chunk size 2560000 (p)
Number of free pages 128230
DBspace number 4
Chunk number 5
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/tmpdbs1
Chunk offset 0 (p)
Chunk size 128000 (p)
Number of free pages 127947
DBspace number 5
Chunk number 6
Flags 0x30040 Chunk is online
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/tmpdbs2
Chunk offset 0 (p)
Chunk size 128000 (p)
Number of free pages 127947
DBspace number 6
Chunk number 7
Flags 0x32040 Chunk is online
& Chunk is extendable
Chunk path /opt/GBASE/gbase/gbaseserver_dbs/datadbs1_1
Chunk offset 0 (p)
Chunk size 640000 (p)
Number of free pages 501765
DBspace number 7
Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_1ARCH.
No archives have occurred.
DR has not been initialized.
liaosnet发表于 1年前
@GBase用户16900：只要这部分就好：
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Time stamp of checkpoint 0x1bd00cf
Time of checkpoint 09/16/2024 01:26:00
Physical log begin address 3:53
Physical log size 1640100 (p)
Physical log position at Ckpt 1035044
Logical log unique identifier 71
Logical log position at Ckpt 0x4923018 (Page 18723, byte 24)
Checkpoint Interval 5766
DBspace descriptor page 1:5
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
使用root用户权限，使用gbasedbt用户的环境变量
export IFX_ASKEY=ZEXPGHDK （注：仅限今天）
oncheck -S zero -n -H -l 71 -p 0x4923018 -y
然后再正常启动数据库。
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Time stamp of checkpoint 0x1bd00cf
Time of checkpoint 09/16/2024 01:26:00
Physical log begin address 3:53
Physical log size 1640100 (p)
Physical log position at Ckpt 1035044
Logical log unique identifier 71
Logical log position at Ckpt 0x4923018 (Page 18723, byte 24)
Checkpoint Interval 5766
DBspace descriptor page 1:5
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
使用root用户权限，使用gbasedbt用户的环境变量
export IFX_ASKEY=ZEXPGHDK （注：仅限今天）
oncheck -S zero -n -H -l 71 -p 0x4923018 -y
然后再正常启动数据库。
GBase用户16900发表于 1年前
@liaosnet：已经启动好了，感谢！感谢！感谢！
曾阿牛发表于 1年前
@liaosnet：点赞
崔哥发表于 9个月前
嗯，只能说不错！
levvel发表于 6个月前
来报个到
热门帖子
- 12025-12-01浏览数：182759
- 22023-05-09浏览数：25044
- 42023-09-25浏览数：18519
- 52020-05-11浏览数：17526