|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Версия Suse Linux - cat /etc/Suse-release version9 Информикс 10.00 при запуске (при чем под любым пользователем) команды dbimport появляется сообщение /opt/IBM/informix/bin/dbimport Segmentation fault Во время запуска этой команды в файле messages cat /var/log/messages появляется сообщение : informix kernel :dbimport [19718] :segfault at 00000000000008 rip 0000002a955f281 rsp 000000007fbffff ecf0 error 4 ... |
|||
:
Нравится:
Не нравится:
|
|||
14.09.2009, 12:37 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Сервер только поставили или он уже давно работает ? Приведите результат выполнения onstat и onstat -g seg ... |
|||
:
Нравится:
Не нравится:
|
|||
14.09.2009, 13:37 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Сервер работает уже давно Привожу результат выполнения onstat IBM Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up 28 days 02:07:47 -- 1946212 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 9c01e028 ---P--D 1 root - 0 0 0 4304 32435 9c01e780 ---P--F 0 root - 0 0 0 0 4281863 9c01eed8 ---P--F 0 root - 0 0 0 0 508447 9c01f630 ---P--F 0 root - 0 0 0 0 0 9c01fd88 ---P--F 0 root - 0 0 0 0 0 9c0204e0 ---P--F 0 root - 0 0 0 0 0 9c020c38 ---P--F 0 root - 0 0 0 0 0 9c021390 ---P--- 5 root - 0 0 0 0 14183 9c021ae8 ---P--B 6 root - 0 0 0 31245 2368 9c022240 Y--P--- 11996 informix BLADE3 9d00d328 0 1 224 224 9c022998 Y--P--D 12 root - 440fd9c8 0 0 0 0 9c0230f0 ---P--D 9 root - 0 0 0 0 0 9c023848 Y--P--- 11993 informix BLADE3 9d0e01a8 0 1 2952 2968 9c023fa0 Y--P--- 11982 informix BLADE3 9e171778 0 1 0 0 9c0246f8 Y--P--- 12014 informix BLADE3 9e831630 0 1 0 0 9c024e50 Y--P--- 11956 informix BLADE3 9f470ef0 0 1 0 0 9c0255a8 Y--P--- 11816 informix BLADE3 9e60f248 0 1 0 0 9c025d00 Y--P--- 12029 informix BLADE3 9f470e70 0 1 3361 3360 9c026bb0 Y--P--- 12018 informix BLADE3 9d00d628 0 1 682 5341 9c027308 Y--P--- 11983 informix BLADE3 9ece9990 0 1 0 3884 9c027a60 Y--P--- 12026 informix BLADE3 9dfc1340 0 1 0 0 9c028910 Y--P--- 12007 informix BLADE3 9ed0d4a8 0 1 0 0 9c029068 Y--P--- 11992 informix BLADE3 9ece9328 0 1 0 0 9c0297c0 Y--P--- 12004 informix BLADE3 9dda1e98 0 1 2 0 9c029f18 Y--P--- 11907 informix BLADE3 9ece9670 0 1 231 432 9c02a670 Y--P--- 12002 informix BLADE3 9ed0d528 0 1 2 0 9c02adc8 Y--P--- 11742 informix BLADE3 9e768ce0 0 1 0 0 9c02bc78 Y--P--- 11979 informix BLADE3 9ece9128 0 1 4 0 9c02cb28 Y--P--- 12027 informix BLADE3 9dc8e0a8 0 1 0 0 9c02d280 Y--P--- 12015 informix BLADE3 9cefb4a8 0 1 0 0 9c02d9d8 Y--P--- 12016 informix BLADE3 9d00d2a8 0 1 3679 5168 9c02e888 Y--P--- 12017 informix BLADE3 9dba37e0 0 1 0 0 9c02efe0 ---PR-- 12025 informix BLADE3 0 0 1 0 16 9c02f738 Y--P--- 11741 informix BLADE3 9d00dc58 0 1 676 1136 9c031498 Y--P--- 11978 informix BLADE3 9e5990a8 0 1 224 224 9c031bf0 Y--P--- 11740 informix BLADE3 9ed55960 0 1 0 0 9c032348 Y--P--- 11984 informix BLADE3 9d5b4808 0 1 0 0 9c0331f8 Y--P--- 11981 informix BLADE3 9eaf74c0 0 1 0 0 9c033950 Y--P--- 12023 informix BLADE3 9e5402e0 0 1 0 0 9c034800 Y--P--- 12022 informix BLADE3 9dc8e740 0 1 394 552 9c034f58 Y--P--- 12019 informix BLADE3 9ed0dd80 0 1 8 0 9c035e08 Y--P--- 12001 informix BLADE3 9ed0dd00 0 1 84 388 9c036560 Y--P--- 11980 informix BLADE3 9d605c20 0 1 4 3712 9c036cb8 Y--P--- 11990 informix BLADE3 9e112cb0 0 1 3 240 9c037b68 Y--P--- 11908 informix BLADE3 9dfc1640 0 1 1 0 9c038a18 Y--P--- 11877 informix BLADE3 9dfc12c0 0 1 2400 2400 9c039170 Y--P--- 11994 informix BLADE3 9e14ece8 0 1 4 0 9c0398c8 Y--P--- 12006 informix BLADE3 9d89e2c8 0 1 3 16 9c03a020 Y--P--- 12010 informix BLADE3 9d3e67a8 0 1 56 56 9c03a778 Y--P--- 12011 informix BLADE3 9e831b60 0 1 0 0 9c03aed0 Y--P--- 11781 informix BLADE3 9ed553c8 0 1 0 0 9c03b628 Y--P--- 11865 informix BLADE3 9dba3ce0 0 1 4 0 52 active, 128 total, 67 maximum concurrent Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1084061 5331308 27466378542 100.00 5353073 12441495 3601768380 99.86 isamtot open start read write rewrite delete commit rollbk 16691539626 16627074 1107184242 11420625123 1743967592 4836634 163328 800143 244 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 77497.17 1356.67 2499 16166 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 35777 174 35826208854 2 0 252 16441157 13157531 ixda-RA idx-RA da-RA RA-pgsused lchwaits 150819 1860 443363 595695 1338035 onstat -g seg IBM Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up 28 days 02:08:56 -- 1946212 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 851968 1381386241 44000000 1468633088 468736 R* 358550 3 2293804 1381386285 9b899000 524288000 16736 V 13686 114314 Total: - - 1992921088 - - 372236 114317 (* segment locked in memory) ... |
|||
:
Нравится:
Не нравится:
|
|||
15.09.2009, 09:32 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Покажите еще onconfig и перезагрузите целиком сервак при первой возможности.. ... |
|||
:
Нравится:
Не нравится:
|
|||
15.09.2009, 18:21 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
vasilisПокажите еще onconfig и перезагрузите целиком сервак при первой возможности..даю onconfig.ol_informix #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2005 All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /informix/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 30000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 1 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS physdbs # Location (dbspace) of physical log PHYSFILE 199894 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 49 # Number of logical log files LOGSIZE 2000 # Logical log size (Kbytes) LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT) # 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. # Diagnostics MSGPATH /home/informix/ol_informix.log # System message log file path CONSOLE /dev/console # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /opt/IBM/informix/etc/no_log.sh #alarmprogram.sh # Alarm program path ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/null # Tape device path TAPEBLK 32 # Tape block size (Kbytes) TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/null # Log tape device path LTAPEBLK 32 # Log tape block size (Kbytes) LTAPESIZE 10240 # 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 ol_informix # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE soctcp,1,100,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 1000000 # Maximum number of locks NUMAIOVPS 6 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 6 # Number of buffer cleaner processes SHMBASE 0x44000000L # Shared memory base address SHMVIRTSIZE 512000 # initial virtual shared memory segment size SHMADD 64000 # 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 CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64 # 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 # 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 # 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 /home/informix/bar_act.log # ON-Bar Log file - not in /tmp please BAR_DEBUG_LOG /home/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 128 # Number of pages to attempt to read ahead RA_THRESHOLD 64 # 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:tempdbs2:tempdbslog # 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 /home/informix/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 # List of dbspaces to skip # 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 /home/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 # The following parameters are related to the buffer pool BUFFERPOOL default,buffers=1000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000 BUFFERPOOL size=2K,buffers=600000,lrus=128,lru_min_dirty=50.000000,lru_max_dirty=60.000000 ... |
|||
:
Нравится:
Не нравится:
|
|||
16.09.2009, 10:55 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
vasilisПокажите еще onconfig и перезагрузите целиком сервак при первой возможности.. перегрузить через reboot ... |
|||
:
Нравится:
Не нравится:
|
|||
16.09.2009, 11:22 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
gogy1vasilisПокажите еще onconfig и перезагрузите целиком сервак при первой возможности.. перегрузить через reboot Это вопрос ? Тогда "Да". ... |
|||
:
Нравится:
Не нравится:
|
|||
16.09.2009, 17:15 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
gogy1при запуске (при чем под любым пользователем) команды dbimport появляется сообщение /opt/IBM/informix/bin/dbimport Segmentation fault Во время запуска этой команды в файле messages cat /var/log/messages появляется сообщение : informix kernel :dbimport [19718] :segfault at 00000000000008 rip 0000002a955f281 rsp 000000007fbffff ecf0 error 4 А как другие утилиты ? oncheck, например ... |
|||
:
Нравится:
Не нравится:
|
|||
16.09.2009, 17:19 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Reboot не помогло oncheck с какими ключами лучше запускать ?? ... |
|||
:
Нравится:
Не нравится:
|
|||
17.09.2009, 11:08 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
gogy1Reboot не помогло oncheck с какими ключами лучше запускать ?? С любыми, например так: oncheck -cRq dbschema -d имя_БД dbexport какой-нибудь-маленькой-БД Главное, это проверить работоспособность всех остальных утилит, которые работают с сервером по такому же механизму, как и dbimport P.S. Кстати, под Линухом же есть onmonior - он работает нормально во всех режимах ? ... |
|||
:
Нравится:
Не нравится:
|
|||
17.09.2009, 11:40 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Рекомендую внимательно почитать топик 3-х летеней давности, там была похожая проблема /topic/276805&pg=1&hl=segmentation+fault#2500412 ... |
|||
:
Нравится:
Не нравится:
|
|||
17.09.2009, 12:16 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
vasilisgogy1Reboot не помогло oncheck с какими ключами лучше запускать ?? С любыми, например так: oncheck -cRq dbschema -d имя_БД dbexport какой-нибудь-маленькой-БД - работает нормально Главное, это проверить работоспособность всех остальных утилит, которые работают с сервером по такому же механизму, как и dbimport P.S. Кстати, под Линухом же есть onmonior - он работает нормально во всех режимах ?- с onmonіtor пока не работал -- Это аналог dbacces под Линукс ?? С любыми, например так: oncheck -cRq dbschema -d имя_БД dbexport какой-нибудь-маленькой-БД - работает нормально ... |
|||
:
Нравится:
Не нравится:
|
|||
01.10.2009, 15:23 |
|
Dbimport под Suse Linux
|
|||
---|---|---|---|
#18+
Спасибо всем за помощь ! Вопрос решился следующим образом: с другого сервера идентичной конфигурации с каталога /opt/IBM/informix/ bin скопировал файл dbimport на сервер где была проблема с dbimport тоже в каталог opt/IBM/informix/ bin Существующий файл переименовал в dbimport1 для файла dbimport сменил владельца (сhown ) на информикс права доступа установил 755 (chmod) ... |
|||
:
Нравится:
Не нравится:
|
|||
19.10.2009, 10:16 |
|
|
start [/forum/topic.php?desktop=1&fid=44&tid=1607714]: |
0ms |
get settings: |
11ms |
get forum list: |
16ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
69ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
46ms |
get tp. blocked users: |
1ms |
others: | 353ms |
total: | 515ms |
0 / 0 |