Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
После ребута сервера ASE перестал запускаться. 00:00000:00000:2005/09/20 12:09:16.48 kernel Adaptive Server Small Business Edition 00:00000:00000:2005/09/20 12:09:16.66 kernel Using config area from primary master device. 00:00000:00000:2005/09/20 12:09:16.71 kernel Detected 4 physical CPU's 00:00000:00000:2005/09/20 12:09:16.72 kernel Internal run-time model set for Linux - Native 00:00000:00000:2005/09/20 12:09:16.72 kernel Using 1024 file descriptors. 00:00000:00000:2005/09/20 12:09:16.73 kernel Adaptive Server Enterprise/12.5.0.3/EBF 11450 ESD#4/P/Linux Intel/Linux 2.4.18-18.7.xsmp i686/rel12503/1940/32-bit/OPT/Sun Sep 21 03:10:00 2003 00:00000:00000:2005/09/20 12:09:16.73 kernel Confidential property of Sybase, Inc. 00:00000:00000:2005/09/20 12:09:16.73 kernel Copyright 1987, 2003 00:00000:00000:2005/09/20 12:09:16.73 kernel Sybase, Inc. All rights reserved. 00:00000:00000:2005/09/20 12:09:16.73 kernel Unpublished rights reserved under U.S. copyright laws. 00:00000:00000:2005/09/20 12:09:16.73 kernel 00:00000:00000:2005/09/20 12:09:16.73 kernel This software contains confidential and trade secret information of Sybase, 00:00000:00000:2005/09/20 12:09:16.73 kernel Inc. Use, duplication or disclosure of the software and documentation by 00:00000:00000:2005/09/20 12:09:16.73 kernel the U.S. Government is subject to restrictions set forth in a license 00:00000:00000:2005/09/20 12:09:16.73 kernel agreement between the Government and Sybase, Inc. or other written 00:00000:00000:2005/09/20 12:09:16.73 kernel agreement specifying the Government's rights to use the software and any 00:00000:00000:2005/09/20 12:09:16.73 kernel applicable FAR provisions, for example, FAR 52.227-19. 00:00000:00000:2005/09/20 12:09:16.73 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA 00:00000:00000:2005/09/20 12:09:16.73 kernel Using '/opt/sybase-12.5/ASE/ipsoft.cfg' for configuration information. 00:00000:00000:2005/09/20 12:09:16.73 kernel Logging ASE messages in file '/var/log/sybase/ipsoft.log'. 00:00000:00000:2005/09/20 12:09:17.00 kernel kdcl_sess_open: connectivity library supports master/query syntax. 00:00000:00000:2005/09/20 12:09:17.00 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver 00:00000:00000:2005/09/20 12:09:17.00 kernel SQL Server booted with TCP_NODELAY enabled. 00:00000:00000:2005/09/20 12:09:17.01 kernel SSL Plus v3.0.8 security modules loaded successfully. 00:00000:00000:2005/09/20 12:09:17.01 kernel Network and device connection limit is 1014. 00:00000:00000:2005/09/20 12:09:17.35 server Number of blocks left for proc headers: 29952. 00:00000:00000:2005/09/20 12:09:17.37 server Proc header memory allocated 4992 pages for each per engine cache 00:00000:00000:2005/09/20 12:09:19.85 server Memory allocated for the default data cache cachelet 1: 262144 Kb 00:00000:00000:2005/09/20 12:09:19.87 server Size of the 2K memory pool: 262144 Kb 00:00000:00000:2005/09/20 12:09:19.87 server Memory allocated for the cache_data cachelet 1: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.88 server Size of the 2K memory pool: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.88 server Memory allocated for the cache_index cachelet 1: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.89 server Size of the 2K memory pool: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.89 server Memory allocated for the cashe_table1 cachelet 1: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.90 server Size of the 2K memory pool: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.90 server Memory allocated for the cashe_table2 cachelet 1: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.91 server Size of the 2K memory pool: 131072 Kb 00:00000:00000:2005/09/20 12:09:19.91 server Memory allocated for the TempDB cachelet 1: 225280 Kb 00:00000:00000:2005/09/20 12:09:19.92 server Size of the 2K memory pool: 225280 Kb 00:00000:00000:2005/09/20 12:09:19.92 kernel Enabling (RT) Posix asynchronous disk I/O strategy. 00:00000:00000:2005/09/20 12:09:19.92 kernel Initializing virtual device 0, '/opt/sybase-12.5/SystemDevice/master.dat' with dsync 'on'. 00:00000:00000:2005/09/20 12:09:19.92 kernel Virtual device 0 started using asynchronous i/o. 00:00000:00000:2005/09/20 12:09:19.92 kernel Worker Thread Manager is not enabled for use in SQL Server. 00:00000:00000:2005/09/20 12:09:19.94 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported. 00:00000:00000:2005/09/20 12:09:19.94 kernel Unix interval timer enabled for sysclk interrupts. 00:00000:00000:2005/09/20 12:09:19.94 kernel engine 0, os pid 676 online 00:00000:00000:2005/09/20 12:09:19.95 server No active traceflags 00:00000:00001:2005/09/20 12:09:20.05 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.3/EBF 11450 ESD#4/P/Linux Intel/Linux 2.4.18-18.7.xsmp i686/rel12503/1940/32-bit/OPT/Sun Sep 21 03:10:00 2003'. 00:00000:00001:2005/09/20 12:09:20.05 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10822 ESD#8-1/DRV.12.5.0.4/Linux Intel/Linux 2.2.14-5.0smp i686/BUILD125-016-1/OPT/Wed Dec 4 15:30:05 2002' 00:00000:00001:2005/09/20 12:09:20.06 server Opening Master Database ... 00:00000:00001:2005/09/20 12:09:20.24 server Loading SQL Server's default sort order and character set 00:00000:00001:2005/09/20 12:09:20.25 server Loaded default Unilib conversion handle. 00:00000:00001:2005/09/20 12:09:20.30 server Recovering database 'master'. 00:00000:00001:2005/09/20 12:09:20.75 server Checking external objects. 00:00000:00001:2005/09/20 12:09:20.80 server Database 'master' is now online. 00:00000:00001:2005/09/20 12:09:20.81 server The transaction log in the database 'master' will use I/O size of 2 Kb. 00:00000:00001:2005/09/20 12:09:20.82 server Warning: ASE_HA has no valid license and therefore is not initialized. 00:00000:00001:2005/09/20 12:09:20.82 server server name is 'ipsoft' 00:00000:00001:2005/09/20 12:09:20.84 server Activating disk 'bill_data' of size 2097152 KB. 00:00000:00001:2005/09/20 12:09:20.84 kernel Initializing virtual device 3, '/data/sybase/bill_data.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 3 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_data1' of size 2097152 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 7, '/data/sybase/bill_data1.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 7 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_data2' of size 2097152 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 10, '/data/sybase/bill_data2.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 10 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_log' of size 1572864 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 4, '/data/sybase/bill_log.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 4 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_traffic1' of size 2097152 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 5, '/data/sybase/bill_traffic1.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 5 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_traffic2' of size 2097152 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 6, '/data/sybase/bill_traffic2.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 6 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'bill_traffic3' of size 2621440 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 11, '/data/sybase/bill_traffic3.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 11 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'sales' of size 204800 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 8, '/data/sybase/sales.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 8 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'sysprocsdev' of size 122880 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 1, '/opt/sybase-12.5/SystemDevice/sybsystemprocs.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.86 kernel Virtual device 1 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.86 server Activating disk 'tempdb' of size 647168 KB. 00:00000:00001:2005/09/20 12:09:20.86 kernel Initializing virtual device 2, '/opt/sybase-12.5/SystemDevice/tempdb.dat' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.87 kernel Virtual device 2 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.87 server Activating disk 'tempdb1' of size 1228800 KB. 00:00000:00001:2005/09/20 12:09:20.87 kernel Initializing virtual device 9, '/opt/sybase-12.5/SystemDevice/tempdb.dat1' with dsync 'on'. 00:00000:00001:2005/09/20 12:09:20.87 kernel Virtual device 9 started using asynchronous i/o. 00:00000:00001:2005/09/20 12:09:20.96 server Recovering database 'sybsystemdb'. 00:00000:00001:2005/09/20 12:09:20.98 server Boot Count: 82 00:00000:00001:2005/09/20 12:09:20.99 server Checking external objects. 00:00000:00001:2005/09/20 12:09:20.99 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb. 00:00000:00001:2005/09/20 12:09:21.01 server Database 'sybsystemdb' is now online. 00:00000:00001:2005/09/20 12:09:21.05 server Recovering database 'model'. 00:00000:00001:2005/09/20 12:09:21.07 server Checking external objects. 00:00000:00001:2005/09/20 12:09:21.07 server The transaction log in the database 'model' will use I/O size of 2 Kb. 00:00000:00001:2005/09/20 12:09:21.09 server Database 'model' is now online. 00:00000:00001:2005/09/20 12:09:21.09 server The logical pagesize of the server is 2 Kb. 00:00000:00001:2005/09/20 12:09:21.09 server 0 dump conditions detected at boot time 00:00000:00001:2005/09/20 12:09:21.09 server Resident Node id: e0663f0ff1bd 00:00000:00001:2005/09/20 12:09:21.09 server Transaction coordinator initialized. 00:00000:00001:2005/09/20 12:09:21.10 server Clearing temp db 00:00000:00001:2005/09/20 12:10:01.10 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb. 00:00000:00001:2005/09/20 12:10:01.11 server Database 'tempdb' is now online. 00:00000:00001:2005/09/20 12:10:01.15 server Recovering database 'sybsystemprocs'. 00:00000:00001:2005/09/20 12:10:01.68 server Checking external objects. 00:00000:00001:2005/09/20 12:10:01.70 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb. 00:00000:00001:2005/09/20 12:10:01.72 server Database 'sybsystemprocs' is now online. 00:00000:00002:2005/09/20 12:10:01.72 kernel network name tagan, type ether, port 5000, filter NONE 00:00000:00001:2005/09/20 12:10:01.78 server Recovering database 'bill'. 00:00000:00001:2005/09/20 12:10:01.80 kernel current process (0x50005) infected with 11 00:00000:00001:2005/09/20 12:10:01.81 kernel ************************************ 00:00000:00001:2005/09/20 12:10:01.82 kernel curdb = 4 pstat = 0x1000 lasterror = 0 00:00000:00001:2005/09/20 12:10:01.82 kernel preverror = 0 transtate = 1 00:00000:00001:2005/09/20 12:10:01.82 kernel curcmd = 0 program = 00:00000:00001:2005/09/20 12:10:01.82 kernel pc 0x866b911 ucbacktrace+0x89(0x0,0x1,0x8d80dec,0xb,0xb) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x81104f5 terminate_process+0xa85(0x0,0xffffffff,0xb,0x4006bca4,0x0) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x8684358 kisignal+0x48(0xb,0x405c1620,0x405c16a0,0xffffffff,0xffffffff) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x40068f0a init_dummy+0x3775c5d6(0xb,0x405c1620,0x405c16a0,0xb,0x0) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x400d6980 init_dummy+0x377ca04c(0x10,0x405c1b28,0x8d80dec,0x405c1b28,0x405c1a30) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x83723dd add_xitem+0x6d(0x42fc3800,0x405c1b28,0x8d80dec,0x42d3cd18,0x56aef2f4) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x85edf95 analyze_beginxact+0x3d(0x405c1a3c,0x56aef2f4,0x405c1b1c,0x405c1b28,0x405c1a30) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x83516f1 rec_analyze_log+0x325(0x1,0x420b42e0,0x42fc3800,0x42fc5000,0x405c1bd4) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x8350189 recovery+0x645(0x1,0x0,0x8d80dec,0x0,0x0) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x834f1fd dorecover+0x2ed(0x1,0x420a4d40,0x8d80dec,0x405c1fec,0x40207c60) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x8112eef ds__recoverdbs+0x54b(0x0,0x0,0x0,0x0,0x0) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x810eb29 dsinit+0xecd(0x0,0x405c2180,0x895eed31,0x0,0x0) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x86a3c2c kpexit(0x0,0x0,0x0,0x40562100,0x6) 00:00000:00001:2005/09/20 12:10:01.83 kernel pc 0x895eed31 init_dummy+0x80ce23fd(0x0,0x40562100,0x6,0x1,0x5374616b) 00:00000:00001:2005/09/20 12:10:01.83 kernel end of stack trace, spid 1, kpid 327685, suid 0 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 10:19 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
ну чего ... упал при восстановлении базы bill я бы: 1) запустил сервак с ключом -T3608 (поднятие только мастера) 2) поставил в master..sysdatabases этой базе статус for load 3) остановил сервер, убрал ключ -Т3608 4) запустил сервер снова если всё поднимется, то взял бы дамп БД bill и поднял его на базу bill -- это если есть дамп и никаких серьезных проблем с сервером нет... в противном случае - разбираться дальше ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 10:43 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
Вроде master живой.. Пытаюсь загрузить из дампа базу bill, но сервак ругаеться Database 'bill' has not been recovered yet - please wait and try again. При этом сервер процесса востановления не делает. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 12:51 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
а поле status в master..sysdatabases для этой БД какое значение имеет? её в for load то перевели ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 13:09 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
а трейсфлаг 3608 убрали из строки запуска сервера ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 13:12 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
bill 4 4 580 1 1471494 15.03.2005 17:37:48.003 01.08.2005 4:02:02.873 48 0 0 0 0 [NULL] [NULL] 0 0 master 1 1 0 1 2481 17.11.2004 13:10:27.680 25.06.2005 4:02:43.583 -32768 0 0 0 0 [NULL] [NULL] 0 0 model 3 1 0 1 622 17.11.2004 13:10:27.680 14.03.2005 17:43:44.333 -32768 0 0 0 0 [NULL] [NULL] 0 0 sales 5 3 64 1 625 22.03.2005 17:37:44.903 22.03.2005 17:37:18.553 -32719 0 0 0 0 [NULL] [NULL] 0 0 sybsystemdb 31513 1 0 1 610 17.11.2004 13:10:27.680 14.03.2005 17:44:18.333 -32768 0 0 0 0 [NULL] [NULL] 0 0 sybsystemprocs 31514 1 8 1 29354 17.11.2004 13:10:46.063 21.09.2005 13:02:12.163 -32768 0 0 0 0 [NULL] [NULL] 0 0 tempdb 2 1 516 1 640 21.09.2005 12:22:12.753 21.09.2005 13:08:18.070 -32767 0 0 0 0 [NULL] [NULL] 0 0 P/S Флаг убран. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 13:20 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
Только не бейте тупой вопрос как сделать for load? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 13:26 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
выполнить скрипт -- use master go sp_configure 'allow updates',1 go update sysdatabases set status=32 where dbid=4 go sp_configure 'allow updates',0 go --- рестартовать сервер попробовать поднять дамп на базу ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 13:50 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
Огромынй респек... Поднял базу из дампа.. сейчас чекаю ее. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 15:15 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
ВигвамОгромынй респек... Поднял базу из дампа.. сейчас чекаю ее. гут :) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.09.2005, 16:53 |
|
||
|
Упал - ASE...ужассс....
|
|||
|---|---|---|---|
|
#18+
Была подобная ситуация, когда при recovery БД, ASE слетал в stacktrace c "infected with 11" . После увеличения параметра "cpu grace time" все нормально отрековерилось. Это вам на будущее. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 22.09.2005, 12:55 |
|
||
|
|

start [/forum/topic.php?fid=55&msg=33281039&tid=2013369]: |
0ms |
get settings: |
10ms |
get forum list: |
20ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
55ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
65ms |
get tp. blocked users: |
2ms |
| others: | 262ms |
| total: | 435ms |

| 0 / 0 |
