Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Informix Новый топик    Ответить
 Сервер не может бекапить логические журналы  [new]
KyRo
Member

Откуда: г.Киев
Сообщений: 361
Добрый день.
Подскажите может кто сталкивался с проблемой. В какой то момент времени , сервер перестает бекапить логические журналы и уходит в чек поинт из за их нехватки.
При детальном анализе видно что сервер их правильно заполняет , но вот заархивировать почему то не может и пишет

Команда ontape -a выдает следующее

[root@onldb2 /]# ontape -a

Performing automatic backup of logical logs.

Please mount tape 1 on /usr/informix_log/log.bkp and press Return to continue ...


This tape contains no log data


При этом скрипт аларм шела начинает их писать но доходя до 32 к перестает, с выше названной ошибкой.

Сервер на котором это все происходит

IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line -- Up 03:09:25 -- 480744 Kbytes


конфиг

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /usr/informix_chunk/rootdbs
                                # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        2000000         # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         physfiledbs     #rootdbs        # Location (dbspace) of physical log
PHYSFILE        1900000         #2000           # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        218             # Number of logical log files
LOGSIZE         20000           # Logical log size (Kbytes)

# Tablespace Tablespace Configuration in Root Dbspace

TBLTBLFIRST     0               # First extent size (Kbytes) (0 = default)
TBLTBLNEXT      0               # Next extent size (Kbytes) (0 = default)

# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment DBCREATE_PERMISSON to
# limit database creation to a specific user. Add a new DBCREATE_PERMISSION
# line for each permitted user.

#DBCREATE_PERMISSION    informix

# DB_LIBRARY_PATH:
# When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that
# the user-specified path starts with one of the directory prefixes listed in
# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
# "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for
# extensibility and IBM supplied blades to work correctly.

# DB_LIBRARY_PATH $INFORMIXDIR/extend

# IFX_EXTEND_ROLE:
# 0 (or off) => Disable use of EXTEND role to control who can register
#               external routines.
# 1 (or on)  => Enable use of EXTEND role to control who can register
#               external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1               # To control the usage of EXTEND role.
# EILSEQ_COMPAT_MODE:
# When processing characters, IDS checks if the characters are valid
# for the locale and returns error -202 if they are not.  This causes
# problems in some applications.  This parameter preserves the old
# behavior and permits these characters.
# 0 =>  Disallow illegal characters. This is the default behavior.
# 1 =>  Allow illegal characters.
#
EILSEQ_COMPAT_MODE 0

#
# ADMIN_MODE_USERS
# This is a comma separated list of those users who can connect to the
# IDS server while it is in single user mode.  This list of users is in
# addition user informix.
#
# Example:
# ADMIN_MODE_USERS      usera,userb,userc
#

# ADMIN_MODE_USERS

# Diagnostics

MSGPATH         /usr/informix/online.log # System message log file path
CONSOLE         /dev/console    # System console message path

# To automatically backup logical logs, edit alarmprogram.sh and set
ALARMPROGRAM    /usr/informix/bin/alarm.sh # Alarm program path
ALRM_ALL_EVENTS 1               # Triggers ALARMPROGRAM for any event occur
TBLSPACE_STATS  1               # Maintain tblspace statistics

# System Archive Tape Device

TAPEDEV         /usr/informix_bkp/online.bkp # Tape device path
#TAPEDEV         /dev/null       # Tape device path
TAPEBLK         512             # Tape block size (Kbytes)
TAPESIZE       50000000       # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /usr/informix_log/log.bkp # Log tape device path
#LTAPEDEV        /dev/null       # Log tape device path
LTAPEBLK        32              # Log tape block size (Kbytes)
LTAPESIZE       30000          # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server staging area

# System Configuration

SERVERNUM       0               # Unique id corresponding to a OnLine instance
DBSERVERNAME    back_db         # Name of default database server
DBSERVERALIASES                 #
DBSERVERALIASES onldb2          # List of alternate dbservernames
DBSERVERALIASES onl_sec # List of alternate dbservernames
DEADLOCK_TIMEOUT 60              # Max time to wait of lock in distributed env.
RESIDENT        2               # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR  1               # 0 for single-processor, 1 for multi-processor
NUMCPUVPS       15              # Number of user (cpu) vps
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to one

NOAGE           0               # Process aging
AFF_SPROC       0               # Affinity start processor
AFF_NPROCS      0               # Affinity number of processors

# Shared Memory Parameters

LOCKS           2000000          # Maximum number of locks
NUMAIOVPS                       # Number of IO vps
PHYSBUFF        256             # Physical log buffer size (Kbytes)
LOGBUFF         64              # Logical log buffer size (Kbytes)
CLEANERS        8               # Number of buffer cleaner processes
SHMBASE         0x44000000        # Shared memory base address
SHMVIRTSIZE     65536           # initial virtual shared memory segment size
SHMADD          8192            # Size of new shared memory segments (Kbytes)
EXTSHMADD       8192            # Size of new extension shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
SHMVIRT_ALLOCSEG 0.000000        # Values between 0 and .99 are %, values > 1 are
                                # KB - when this much virtual memory is used we
                                # try to get a new segment. 0 means "off". 2nd
                                # parameter is alarm level
CKPTINTVL       300             # Check point interval (in sec)
TXTIMEOUT       0x12c             # Transaction timeout (in sec)
STACKSIZE       256             # Stack size (Kbytes)

# Dynamic Logging
# DYNAMIC_LOGS:
#    2 : server automatically add a new logical log when necessary. (ON)
#    1 : notify DBA to add new logical logs when necessary. (ON)
#    0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
#
# In case of system configured with CDR, the difference between LTXHWM and
# LTXEHWM should be atleast 30% so that we could minimize log overrun issue.

DYNAMIC_LOGS    2
LTXHWM          70
LTXEHWM         80

# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
#            To determine the page size used by OnLine on your platform
#            see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10              # Default number of offline worker threads
ON_RECVRY_THREADS 1               # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO          0              # DR automatic switchover
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRTIMEOUT       30              # DR network timeout (in sec)
DRLOSTFOUND     /usr/informix/etc/dr.lostfound # DR lost+found file path
DRIDXAUTO       0               # DR automatic index repair. 0=off, 1=on
LOG_INDEX_BUILDS 0               # logically log content of indexes

# CDR Variables
CDR_EVALTHREADS 1,2             # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)
CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL      0,0             # Serial Column Sequence
CDR_DBSPACE                     # dbspace for syscdr database
CDR_QHDR_DBSPACE                 # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE                 # List of CDR queue smart blob spaces

# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
#  0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.

CDR_MAX_DYNAMIC_LOGS 0               # Dynamic log addition disabled by default

# Backup/Restore variables
BAR_ACT_LOG     /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG   /usr/informix/bar_dbug.log
                                # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP  0
BAR_RETRY       1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES                        # Number of pages to attempt to read ahead
RA_THRESHOLD                    # Number of pages left before next group

# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP     tempdbs1        # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR         /tmp            # Preserve diagnostics in this directory
DUMPSHMEM       0               # Dump a copy of shared memory
DUMPGCORE       0               # Dump a core image using 'gcore'
DUMPCORE        0               # Dump a core image (Warning:this aborts OnLine)
DUMPCNT         1               # Number of shared memory or gcore dumps for
                                # a single user's session

FILLFACTOR      90              # Fill factor for building indexes

# method for OnLine to use when determining current time
USEOSTIME       0               # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100             # Maximum allowed pdqpriority
DS_MAX_QUERIES                  # Maximum number of decision support queries
DS_TOTAL_MEMORY                 # Decision support memory (Kbytes)
DS_MAX_SCANS    1048576         # Maximum number of decision support scans
DS_NONPDQ_QUERY_MEM 128             # Non PDQ query memory (Kbytes)
DATASKIP        off             # List of dbspaces to skip


# SDS Configuration Items
SDS_ENABLE      0               # SDS Activation 0 - no, 1 - yes
                    # Set this value in a SDS node after setting up the
                    # SDS primary.
                    # Warning: Always verify ROOTPATH before performing
                    #          disk initialization (oninit -i/-iy) to
                    #          avoid disk corruption of another instance
SDS_TIMEOUT     20              # Time Delay that Primary will wait for any ACK
                    # while perform page flushing before making
                    # SDS Server as down
                    # <dbspace Name>,<path>,<pagesize>,<offset>,<size>  ...
SDS_PAGING                      # Paging File Location
                    # <paging File 1 path>,<paging File 2 path>


# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
#      possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
#      "repeatable read", optimizer behaves as in (2)
#      below.  Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
#      mode.  Nested loop joins are not necessarily
#      preferred.  Optimizer bases its decision purely
#      on costs.
OPTCOMPIND      2               # To hint the optimizer
DIRECTIVES      1               # Optimizer DIRECTIVES ON (1/Default) or OFF (0)

ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX      0               # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT   0

SBSPACENAME                     # Default smartblob space name - this is where blobs
                       # go if no sbspace is specified when the smartblob is
                       # created. It is also used by some datablades as
                       # the location to put their smartblobs.
SYSSBSPACENAME                  # Default smartblob space for use by the Informix
                       # Server. This is used primarily for Informix Server
                       # system statistics collection.

BLOCKTIMEOUT    3600            # Default timeout for system block
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL        -1

ALLOW_NEWLINE   0               # embedded newlines(Yes = 1, No = 0 or anything but 1)


#Create Index Online Shared Memory usage limitation
ONLIDX_MAXMEM   5120            # Per pool per index (Kbytes)

#Timeout for client connection request
LISTEN_TIMEOUT  10              # Timeout (in Seconds)

#Following are the deprecated configuration parameters, instead of these
#use BUFFERPOOL configuration parameter
#BUFFERS, LRUS, LRU_MIN_DIRTY, LRU_MAX_DIRTY

IFX_FOLDVIEW    0               # fold multiple tables or union all view with ansi joins
EXPLAIN_STAT    0               # Enable Query Statistics in EXPLAIN file.

RTO_SERVER_RESTART 0               # Recovery Time Objective for IDS restart after
                        # a server crash; specified in seconds
                        # 0=OFF, (60-1800)
RAS_PLOG_SPEED  13888           # IDS RAS param; do not change; auto updated
RAS_LLOG_SPEED  513             # IDS RAS param; do not change; auto updated
AUTO_CKPTS      1               # Monitor critical resources and trigger
                        # checkpoints more frequently if there is a
                        # chance txn blocking might occur
AUTO_LRU_TUNING 1               # If unable to find low priority buffer for
                        # page fault, increase LRU flushing
AUTO_AIOVPS     1               # When using cooked file chunks, if AIO VPs
                        # too busy, increase number of flushers and
                        # AIO VPs
AUTO_REPREPARE  1               # Automatically re-optimize stored procedures and
                        # re-prepare prepared statements when tables
                        # referenced directly and indirectly by them change
                        # thereby minimizing the occurence of -710 error
# Last Committed Isolation usage as default
# None: Dont use LC as default
# Committed Read: Use LC as default for Committed Read isolation level
# Dirty Read: Use LC as default for Dirty Read isolation level
# All: Use LC as default for Committed Read and Dirty Read isolation levels
USELASTCOMMITTED NONE

DIRECT_IO       0               # Use direct I/O for chunks (Yes = 1, No = 0)

MAX_FILL_DATA_PAGES 0               # Fill data pages maximally (Yes = 1, No = 0)
#
# The following are default settings for enabling Java in the database.
# Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.

#VPCLASS        jvp,num=1       # Number of JVPs to start with

JVPJAVAHOME     /usr/informix/extend/krakatoa/jre
                                # JRE installation root directory
JVPHOME         /usr/informix/extend/krakatoa # Krakatoa installation directory

JVPPROPFILE     /usr/informix/extend/krakatoa/.jvpprops # JVP property file
JVPLOGFILE      /usr/informix/jvp.log # JVP log file.

JDKVERSION      1.3             # JDK version supported by this server

# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB      /bin

# The JRE libraries to use for the Java VM

JVPJAVAVM       jsig:hpi:jvm:java:net:zip:jpeg

# use JVPARGS to change Java VM configuration
#To display jni call
#JVPARGS        -verbose:jni

# Classpath to use upon Java VM start-up (use _g version for debugging)

#JVPCLASSPATH  /usr/informix/extend/krakatoa/krakatoa_g.jar:/usr/informix/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH    /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar

# The following parameters are related to the buffer pool
BUFFERPOOL      size=2K,buffers=5000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000




Все это начало происходить после следующего сообщения в логе

08:21:16  Logical Log 17532 Complete, timestamp: 0xa69ae82a.
08:21:18  Logical Log 17532 - Backup Started
08:21:18  Adjusting LRU for bufferpool - id 0 size 2k
08:21:18        Old max 60.0 min 50.0    New max 59.4 min 49.5
08:21:19  Logical Log 17532 - Backup Completed
08:21:19  Performance Advisory: Logical log file size might be too small for a
          checkpoint to complete.
08:21:19   Results: The size of individual logical log files is too small for
          the current workload, resulting in each log file filling very
          quickly. If log files fill in less than 30 seconds, the checkpoint
          might remain blocked because the last log file fills during the time
          needed to perform the checkpoint.
08:21:19   Action: Increase the size of the individual logical log files so
          that it takes at least 30 seconds to fill each one. Look at the
          online log to determine how quickly the log files are filling, and
          then increase the size of the files proportionately.
08:21:19  Logical Log 17533 - Backup Started
08:21:20  Logical Log 17533 Complete, timestamp: 0xa69c37b6.
08:21:22  Logical Log 17533 - Backup Completed
08:21:24  Logical Log 17534 Complete, timestamp: 0xa69cd5ba.
08:21:26  Logical Log 17535 Complete, timestamp: 0xa69d64ba.
08:21:28  Logical Log 17536 Complete, timestamp: 0xa69e0689.
08:21:32  Logical Log 17537 Complete, timestamp: 0xa69f03e0.
08:21:33  WARNING: Buffer pool size is too small for read ahead operation

08:21:34  Logical Log 17538 Complete, timestamp: 0xa69f7e06.
08:21:37  Logical Log 17539 Complete, timestamp: 0xa6a038e2.
08:21:39  Logical Log 17540 Complete, timestamp: 0xa6a0c9f8.
08:21:41  Logical Log 17541 Complete, timestamp: 0xa6a15aef.
08:21:44  Logical Log 17542 Complete, timestamp: 0xa6a21bc7.
08:21:47  Logical Log 17543 Complete, timestamp: 0xa6a2da36.
08:21:49  Logical Log 17544 Complete, timestamp: 0xa6a35771.
08:21:52  Logical Log 17545 Complete, timestamp: 0xa6a43912.
08:21:54  Logical Log 17546 Complete, timestamp: 0xa6a4d55e.
08:21:56  Logical Log 17547 Complete, timestamp: 0xa6a557c1.
08:21:58  Logical Log 17548 Complete, timestamp: 0xa6a5f473.
08:22:02  Logical Log 17549 Complete, timestamp: 0xa6a6c255.
08:22:04  Logical Log 17550 Complete, timestamp: 0xa6a75c4b.

Подскажите из за чего такое может быть ?
31 авг 09, 12:08    [7597030]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
АнатоЛой
Member

Откуда: Киев, Украина
Сообщений: 2897
Блог
KyRo, onstat -l контрольно покажите...
31 авг 09, 12:19    [7597133]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
KyRo
Member

Откуда: г.Киев
Сообщений: 361
Сервер сейчас работает после разварота бекапа, по этому пока что в онлайне .

[root@onldb2 logs]# onstat -l

IBM Informix Dynamic Server Version 11.10.UC1     -- On-Line -- Up 03:45:10 -- 480744 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-2  0        128      3170731    24977      126.95
      phybegin         physize    phypos     phyused    %used
      2:53             950000     592004     0          0.00

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-1  0        32       7173425    1860617    58737      3.9        31.7
        Subsystem    numrecs    Log Space used
        OLDRSAM      7173387    3756474324
        CLONE        38         1368

address  number   flags    uniqid   begin                size     used    %used
50bacca8 11       U------  17647    3:53                10000    10000   100.00
50baccf0 12       U------  17648    3:10053             10000    10000   100.00
50bacd38 13       U------  17649    3:20053             10000    10000   100.00
50bacd80 14       U------  17650    3:30053             10000    10000   100.00
50bacdc8 15       U------  17651    3:40053             10000    10000   100.00
50bace10 16       U------  17652    3:50053             10000    10000   100.00
50bace58 17       U------  17653    3:60053             10000    10000   100.00
50bacea0 18       U------  17654    3:70053             10000    10000   100.00
50bacee8 19       U------  17655    3:80053             10000    10000   100.00
50bacf30 20       U------  17656    3:90053             10000    10000   100.00
50bacf78 21       U------  17657    3:100053            10000    10000   100.00
50bacfc0 22       U------  17658    3:110053            10000    10000   100.00
50c60430 23       U------  17659    3:120053            10000    10000   100.00
50c60478 24       U------  17660    3:130053            10000    10000   100.00
50c604c0 25       U------  17661    3:140053            10000    10000   100.00
50c60508 26       U------  17662    3:150053            10000    10000   100.00
50c60550 27       U------  17663    3:160053            10000    10000   100.00
50c60598 28       U------  17664    3:170053            10000    10000   100.00
50c605e0 29       U------  17665    3:180053            10000    10000   100.00
50c60628 30       U------  17666    3:190053            10000    10000   100.00
50c60670 31       U------  17667    3:200053            10000    10000   100.00
50c606b8 32       U------  17668    3:210053            10000    10000   100.00
50c60700 33       U------  17669    3:220053            10000    10000   100.00
50c60748 34       U------  17670    3:230053            10000    10000   100.00
50c60790 35       U------  17671    3:240053            10000    10000   100.00
50c607d8 36       U------  17672    3:250053            10000    10000   100.00
50c60820 37       U------  17673    3:260053            10000    10000   100.00
50c60868 38       U------  17674    3:270053            10000    10000   100.00
50c608b0 39       U------  17675    3:280053            10000    10000   100.00
50c608f8 40       U------  17676    3:290053            10000    10000   100.00
50c60940 41       U------  17677    3:300053            10000    10000   100.00
50c60988 42       U------  17678    3:310053            10000    10000   100.00
50c609d0 43       U------  17679    3:320053            10000    10000   100.00
50c60a18 44       U------  17680    3:330053            10000    10000   100.00
50c60a60 45       U------  17681    3:340053            10000    10000   100.00
50c60aa8 46       U------  17682    3:350053            10000    10000   100.00
50c60af0 47       U------  17683    3:360053            10000    10000   100.00
50c60b38 48       U------  17684    3:370053            10000     9999    99.99
50c60b80 49       U------  17685    3:380053            10000    10000   100.00
50c60bc8 50       U------  17686    3:390053            10000    10000   100.00
50c60c10 51       U------  17687    3:400053            10000    10000   100.00
50c60c58 52       U------  17688    3:410053            10000    10000   100.00
50c60ca0 53       U------  17689    3:420053            10000    10000   100.00
50c60ce8 54       U------  17690    3:430053            10000    10000   100.00
50c60d30 55       U------  17691    3:440053            10000    10000   100.00
50c60d78 56       U------  17692    3:450053            10000    10000   100.00
50c60dc0 57       U------  17693    3:460053            10000    10000   100.00
50c60e08 58       U------  17694    3:470053            10000    10000   100.00
50c60e50 59       U------  17695    3:480053            10000    10000   100.00
50c60e98 60       U------  17696    3:490053            10000    10000   100.00
50c60ee0 61       U------  17697    3:500053            10000    10000   100.00
50c60f28 62       U------  17698    3:510053            10000    10000   100.00
50c60f70 63       U------  17699    3:520053            10000    10000   100.00
50c60fb8 64       U------  17700    3:530053            10000    10000   100.00
516aa018 65       U------  17701    3:540053            10000    10000   100.00
516aa060 66       U------  17702    3:550053            10000    10000   100.00
516aa0a8 67       U------  17703    3:560053            10000    10000   100.00
516aa0f0 68       U------  17704    3:570053            10000    10000   100.00
516aa138 69       U------  17705    3:580053            10000    10000   100.00
516aa180 70       U------  17706    3:590053            10000    10000   100.00
516aa1c8 71       U------  17707    3:600053            10000    10000   100.00
516aa210 72       U------  17708    3:610053            10000    10000   100.00
516aa258 73       U------  17709    3:620053            10000    10000   100.00
516aa2a0 74       U------  17710    3:630053            10000    10000   100.00
516aa2e8 75       U------  17711    3:640053            10000    10000   100.00
516aa330 76       U------  17712    3:650053            10000    10000   100.00
516aa378 77       U------  17713    3:660053            10000    10000   100.00
516aa3c0 78       U------  17714    3:670053            10000    10000   100.00
516aa408 79       U------  17715    3:680053            10000    10000   100.00
516aa450 80       U------  17716    3:690053            10000    10000   100.00
516aa498 81       U------  17717    3:700053            10000    10000   100.00
516aa4e0 82       U---C-L  17718    3:710053            10000     5001    50.01
516aa528 83       F------  0        3:720053            10000        0     0.00
516aa570 84       F------  0        3:730053            10000        0     0.00
516aa5b8 85       F------  0        3:740053            10000        0     0.00
516aa600 86       F------  0        3:750053            10000        0     0.00
516aa648 87       F------  0        3:760053            10000        0     0.00
516aa690 88       F------  0        3:770053            10000        0     0.00
516aa6d8 89       F------  0        3:780053            10000        0     0.00
516aa720 90       F------  0        3:790053            10000        0     0.00
516aa768 91       F------  0        3:800053            10000        0     0.00
516aa7b0 92       F------  0        3:810053            10000        0     0.00
516aa7f8 93       F------  0        3:820053            10000        0     0.00
516aa840 94       F------  0        3:830053            10000        0     0.00
516aa888 95       F------  0        3:840053            10000        0     0.00
516aa8d0 96       F------  0        3:850053            10000        0     0.00
516aa918 97       F------  0        3:860053            10000        0     0.00
516aa960 98       F------  0        3:870053            10000        0     0.00
516aa9a8 99       F------  0        3:880053            10000        0     0.00
516aa9f0 100      F------  0        3:890053            10000        0     0.00
516aaa38 101      F------  0        3:900053            10000        0     0.00
516aaa80 102      F------  0        3:910053            10000        0     0.00
516aaac8 103      F------  0        3:920053            10000        0     0.00
516aab10 104      F------  0        3:930053            10000        0     0.00
516aab58 105      F------  0        3:940053            10000        0     0.00
516aaba0 106      F------  0        3:950053            10000        0     0.00
516aabe8 107      F------  0        3:960053            10000        0     0.00
516aac30 108      F------  0        3:970053            10000        0     0.00
516aac78 109      F------  0        3:980053            10000        0     0.00
516aacc0 110      F------  0        3:990053            10000        0     0.00
516aad08 111      F------  0        3:1000053           10000        0     0.00
516aad50 112      F------  0        3:1010053           10000        0     0.00
516aad98 113      F------  0        3:1020053           10000        0     0.00
516aade0 114      U-B----  17532    3:1030053           10000    10000   100.00
516aae28 115      U-B----  17533    3:1040053           10000    10000   100.00
516aae70 116      U------  17534    3:1050053           10000    10000   100.00
516aaeb8 117      U------  17535    3:1060053           10000    10000   100.00
516aaf00 118      U------  17536    3:1070053           10000    10000   100.00
516aaf48 119      U------  17537    3:1080053           10000    10000   100.00
516aaf90 120      U------  17538    3:1090053           10000    10000   100.00
516ab018 121      U------  17539    3:1100053           10000    10000   100.00
516ab060 122      U------  17540    3:1110053           10000    10000   100.00
516ab0a8 123      U------  17541    3:1120053           10000    10000   100.00
516ab0f0 124      U------  17542    3:1130053           10000    10000   100.00
516ab138 125      U------  17543    3:1140053           10000    10000   100.00
516ab180 126      U------  17544    3:1150053           10000    10000   100.00
516ab1c8 127      U------  17545    3:1160053           10000    10000   100.00
516ab210 128      U------  17546    3:1170053           10000    10000   100.00
516ab258 129      U------  17547    3:1180053           10000    10000   100.00
516ab2a0 130      U------  17548    3:1190053           10000    10000   100.00
516ab2e8 131      U------  17549    3:1200053           10000    10000   100.00
516ab330 132      U------  17550    3:1210053           10000    10000   100.00
516ab378 133      U------  17551    3:1220053           10000    10000   100.00
516ab3c0 134      U------  17552    3:1230053           10000    10000   100.00
516ab408 135      U------  17553    3:1240053           10000    10000   100.00
516ab450 136      U------  17554    3:1250053           10000    10000   100.00
516ab498 137      U------  17555    3:1260053           10000    10000   100.00
516ab4e0 138      U------  17556    3:1270053           10000    10000   100.00
516ab528 139      U------  17557    3:1280053           10000    10000   100.00
516ab570 140      U------  17558    3:1290053           10000    10000   100.00
516ab5b8 141      U------  17559    3:1300053           10000    10000   100.00
516ab600 142      U------  17560    3:1310053           10000    10000   100.00
516ab648 143      U------  17561    3:1320053           10000    10000   100.00
516ab690 144      U------  17562    3:1330053           10000    10000   100.00
516ab6d8 145      U------  17563    3:1340053           10000    10000   100.00
516ab720 146      U------  17564    3:1350053           10000    10000   100.00
516ab768 147      U------  17565    3:1360053           10000    10000   100.00
516ab7b0 148      U------  17566    3:1370053           10000    10000   100.00
516ab7f8 149      U------  17567    3:1380053           10000    10000   100.00
516ab840 150      U------  17568    3:1390053           10000    10000   100.00
516ab888 151      U------  17569    3:1400053           10000    10000   100.00
516ab8d0 152      U------  17570    3:1410053           10000    10000   100.00
516ab918 153      U------  17571    3:1420053           10000    10000   100.00
516ab960 154      U------  17572    3:1430053           10000    10000   100.00
516ab9a8 155      U------  17573    3:1440053           10000    10000   100.00
516ab9f0 156      U------  17574    3:1450053           10000    10000   100.00
516aba38 157      U------  17575    3:1460053           10000    10000   100.00
516aba80 158      U------  17576    3:1470053           10000    10000   100.00
516abac8 159      U------  17577    3:1480053           10000    10000   100.00
516abb10 160      U------  17578    3:1490053           10000    10000   100.00
516abb58 161      U------  17579    3:1500053           10000    10000   100.00
516abba0 162      U------  17580    3:1510053           10000    10000   100.00
516abbe8 163      U------  17581    3:1520053           10000    10000   100.00
516abc30 164      U------  17582    3:1530053           10000    10000   100.00
516abc78 165      U------  17583    3:1540053           10000    10000   100.00
516abcc0 166      U------  17584    3:1550053           10000    10000   100.00
516abd08 167      U------  17585    3:1560053           10000    10000   100.00
516abd50 168      U------  17586    3:1570053           10000     9999    99.99
516abd98 169      U------  17587    3:1580053           10000    10000   100.00
516abde0 170      U------  17588    3:1590053           10000    10000   100.00
516abe28 171      U------  17589    3:1600053           10000    10000   100.00
516abe70 172      U------  17590    3:1610053           10000    10000   100.00
516abeb8 173      U------  17591    3:1620053           10000    10000   100.00
516abf00 174      U------  17592    3:1630053           10000    10000   100.00
516abf48 175      U------  17593    3:1640053           10000    10000   100.00
516abf90 176      U------  17594    3:1650053           10000    10000   100.00
516ac018 177      U------  17595    3:1660053           10000    10000   100.00
516ac060 178      U------  17596    3:1670053           10000    10000   100.00
516ac0a8 179      U------  17597    3:1680053           10000    10000   100.00
516ac0f0 180      U------  17598    3:1690053           10000    10000   100.00
516ac138 181      U------  17599    3:1700053           10000    10000   100.00
516ac180 182      U------  17600    3:1710053           10000    10000   100.00
516ac1c8 183      U------  17601    3:1720053           10000    10000   100.00
516ac210 184      U------  17602    3:1730053           10000    10000   100.00
516ac258 185      U------  17603    3:1740053           10000    10000   100.00
516ac2a0 186      U------  17604    3:1750053           10000    10000   100.00
516ac2e8 187      U------  17605    3:1760053           10000    10000   100.00
516ac330 188      U------  17606    3:1770053           10000    10000   100.00
516ac378 189      U------  17607    3:1780053           10000    10000   100.00
516ac3c0 190      U------  17608    3:1790053           10000    10000   100.00
516ac408 191      U------  17609    3:1800053           10000     9999    99.99
516ac450 192      U------  17610    3:1810053           10000    10000   100.00
516ac498 193      U------  17611    3:1820053           10000     9999    99.99
516ac4e0 194      U------  17612    3:1830053           10000    10000   100.00
516ac528 195      U------  17613    3:1840053           10000    10000   100.00
516ac570 196      U------  17614    3:1850053           10000    10000   100.00
516ac5b8 197      U------  17615    3:1860053           10000    10000   100.00
516ac600 198      U------  17616    3:1870053           10000    10000   100.00
516ac648 199      U------  17617    3:1880053           10000    10000   100.00
516ac690 200      U------  17618    3:1890053           10000    10000   100.00
516ac6d8 201      U------  17619    3:1900053           10000    10000   100.00
516ac720 202      U------  17620    3:1910053           10000    10000   100.00
516ac768 203      U------  17621    3:1920053           10000    10000   100.00
516ac7b0 204      U------  17622    3:1930053           10000    10000   100.00
516ac7f8 205      U------  17623    3:1940053           10000    10000   100.00
516ac840 206      U------  17624    3:1950053           10000    10000   100.00
516ac888 207      U------  17625    3:1960053           10000    10000   100.00
516ac8d0 208      U------  17626    3:1970053           10000    10000   100.00
516ac918 209      U------  17627    3:1980053           10000    10000   100.00
516ac960 1        U------  17628    10:8201749          10000    10000   100.00
516ac9a8 2        U------  17629    10:8211749          10000    10000   100.00
516ac9f0 3        U------  17630    10:8221749          10000    10000   100.00
516aca38 4        U------  17631    10:8231749          10000    10000   100.00
516aca80 5        U------  17632    10:8241749          10000    10000   100.00
516acac8 6        U------  17633    10:8251749          10000    10000   100.00
516acb10 7        U------  17634    10:8261749          10000    10000   100.00
516acb58 8        U------  17635    10:8271749          10000    10000   100.00
516acba0 9        U------  17636    10:8281749          10000    10000   100.00
516acbe8 10       U------  17637    10:8291749          10000    10000   100.00
516acc30 210      U------  17638    10:8301749          10000    10000   100.00
516acc78 211      U------  17639    10:8311749          10000    10000   100.00
516accc0 212      U------  17640    10:8321749          10000    10000   100.00
516acd08 213      U------  17641    10:8331749          10000    10000   100.00
516acd50 214      U------  17642    10:8341749          10000    10000   100.00
516acd98 215      U------  17643    10:8351749          10000    10000   100.00
516acde0 216      U------  17644    10:8361749          10000    10000   100.00
516ace28 217      U------  17645    10:8371749          10000    10000   100.00
516ace70 218      U------  17646    10:8381749          10000    10000   100.00
 218 active, 218 total
31 авг 09, 12:29    [7597225]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
vasilis
Member

Откуда: Украина, Киев
Сообщений: 2205
KyRo

IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line -- Up 03:09:25 -- 480744 Kbytes
LOGFILES        218             # Number of logical log files
LOGSIZE         20000           # Logical log size (Kbytes)

LTAPEDEV        /usr/informix_log/log.bkp # Log tape device path
LTAPEBLK        32              # Log tape block size (Kbytes)
LTAPESIZE       30000          # Max amount of data to put on log tape (Kbytes)

LOCKS           2000000          # Maximum number of locks
SHMVIRTSIZE     65536           # initial virtual shared memory segment size
SHMADD          8192            # Size of new shared memory segments (Kbytes)

BUFFERPOOL      size=2K,buffers=5000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000

08:21:19   Results: The size of individual logical log files is too small for
          the current workload, resulting in each log file filling very
          quickly. If log files fill in less than 30 seconds, the checkpoint
          might remain blocked because the last log file fills during the time
          needed to perform the checkpoint.
08:21:19   Action: Increase the size of the individual logical log files so
          that it takes at least 30 seconds to fill each one. Look at the
          online log to determine how quickly the log files are filling, and
          then increase the size of the files proportionately.
08:21:24  Logical Log 17534 Complete, timestamp: 0xa69cd5ba.
08:21:26  Logical Log 17535 Complete, timestamp: 0xa69d64ba.
08:21:28  Logical Log 17536 Complete, timestamp: 0xa69e0689.
08:21:32  Logical Log 17537 Complete, timestamp: 0xa69f03e0.
08:21:34  Logical Log 17538 Complete, timestamp: 0xa69f7e06.
Подскажите из за чего такое может быть ?

Посмотрите внимательно на выделенные мной моменты.
1) LTAPESIZE почему такой маленький ? Обязательно увеличить до гиговых размеров.
2) с вашими мелкими параметрами разделяемой памяти у вас сервер занимает 400М
Подозреваю, что огромное кол-во виртуальных сегментов.
Обязательно посмотреть onstat -g seg
Увеличить buffers и SHMVIRTSIZE (как вы вообще работаете с 10М буферного пула ??)
3) "чистым английским языком" сказано, что у вас очень маленький размер лога относительно активности системы - лог заполняется за 2 (ДВЕ) секунды. Этого недостаточно и скрипт просто не успеет все забекапить. И ясно сказано, что заполнение лога должно быть хотя бы 30сек.
4) вопросы ?

Сообщение было отредактировано: 1 сен 09, 11:33
31 авг 09, 12:38    [7597309]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
KyRo
Member

Откуда: г.Киев
Сообщений: 361
[root@onldb2 logs]# onstat -g seg

IBM Informix Dynamic Server Version 11.10.UC1     -- On-Line -- Up 03:59:40 -- 480744 Kbytes

Segment Summary:
id       key        addr     size       ovhd     class blkused  blkfree
950273   1381386241 44000000 211963904  1463492  R*    51747    2
983042   1381386242 50a25000 67108864   394320   V*    13939    2445
1015811  1381386243 54a25000 544768     4152     M     133      0
1048580  1381386244 54aaa000 9666560    57696    V     2359     1
1081349  1381386245 553e2000 9666560    57696    V     2359     1
1114118  1381386246 55d1a000 9666560    57696    V     2359     1
1146887  1381386247 56652000 9666560    57696    V     2359     1
1179656  1381386248 56f8a000 9666560    57696    V     2359     1
1212425  1381386249 578c2000 9666560    57696    V     2359     1
1245194  1381386250 581fa000 9666560    57696    V     2359     1
1277963  1381386251 58b32000 9666560    57696    V     2359     1
1310732  1381386252 5946a000 9666560    57696    V     2359     1
1343501  1381386253 59da2000 9666560    57696    V     2359     1
1376270  1381386254 5a6da000 9666560    57696    V     2359     1
1409039  1381386255 5b012000 9666560    57696    V     2359     1
1441808  1381386256 5b94a000 9666560    57696    V     2359     1
1474577  1381386257 5c282000 9666560    57696    V     2359     1
1507346  1381386258 5cbba000 9666560    57696    V     2359     1
1540115  1381386259 5d4f2000 9666560    57696    V     2359     1
1572884  1381386260 5de2a000 9666560    57696    V     2359     1
1605653  1381386261 5e762000 9666560    57696    V     2359     1
1638422  1381386262 5f09a000 9666560    57696    V     2359     1
1671191  1381386263 5f9d2000 9666560    57696    V     2359     1
1703960  1381386264 6030a000 9666560    57696    V     2359     1
1736729  1381386265 60c42000 9666560    57696    V     2359     1
Total:   -          -        492281856  -        -     117717   2469


автор
Посмотрите внимательно на выделенные мной моменты.
1) LTAPESIZE почему такой маленький ? Обязательно увеличить до гиговых размеров.
2) с вашими мелкими параметрами разделяемой памяти у вас сервер занимает 400М
Подозреваю, что огромное кол-во виртуальных сегментов.
Обязательно посмотреть onstat -g seg
Увеличить buffers и SHMVIRTSIZE (как вы вообще работаете с 10М буферного пула ??)
3) "чистым английским языком" сказано, что у вас очень маленький размер лога относительно активности системы - лог заполняется за 2 (ДВЕ) секунды. Этого недостаточно и скрипт просто не успеет все забекапить. И ясно сказано, что заполнение лога должно быть хотя бы 30сек.
4) вопросы ?


Спасибо, все пока что понятно.
31 авг 09, 12:45    [7597404]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
victor16
Member

Откуда:
Сообщений: 591
Если у Вас архивирование идет не на ленту, достаточно указать название каталога.
TAPEDEV         /usr/informix_bkp/
LTAPEDEV        /usr/informix_bkp/
Название файлов архивов в этом случае регулируются переменной IFX_ONTAPE_FILE_PREFIX
31 авг 09, 13:34    [7597756]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
bk0010
Member

Откуда:
Сообщений: 4999
victor16
Если у Вас архивирование идет не на ленту, достаточно указать название каталога.
Название файлов архивов в этом случае регулируются переменной IFX_ONTAPE_FILE_PREFIX

А под Windows это тоже работает? Если да, то с какой версии? На 9.3 мне пришлось указывать именно файл.
31 авг 09, 23:20    [7600573]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
victor16
Member

Откуда:
Сообщений: 591
Да, под виндой это тоже работает, фича появилась начиная с 11 версии.
1 сен 09, 13:04    [7602700]     Ответить | Цитировать Сообщить модератору
 Re: Сервер не может бекапить логические журналы  [new]
bk0010
Member

Откуда:
Сообщений: 4999
victor16
Да, под виндой это тоже работает, фича появилась начиная с 11 версии.

Спасибо
1 сен 09, 23:00    [7605762]     Ответить | Цитировать Сообщить модератору
Все форумы / Informix Ответить