在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 今天在我的IBM-T23(1.13CPU+512內存+30G/4200轉的硬盤) 紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,（大部分參數是參照sybase公司出的維護手冊） 1、依次安裝sybase-common\ase\openclient;也修改 了共享內存. 2、srvbuildres 是使用了sybase公司的例子(/opt/sybase-12.5/ASE-12.5/init/sample_resource_files) **在執行srvbuildres 過程中，build master時(100M)和temprocs(120M),大概用了兩個小時,極度鬱悶.有哪位兄弟知道是什麼問題? 3、都成功後,沒有擴tempdb.運行"startserver -f SERVER"服務器是可以起來的.然後配置了內存和CPU. 4、我沒有用裸設備,直接用文件系統建一個數據庫test,以下是具體操作： 1>;disk init 2>;name="DATA1", 3>;physname="/sybase/data1.dat", 4>;vdevno=2, 5>;size=1536000            /*意思是有3G的大小*/ 6>;go 同樣方法建了個LOG1 1>;disk init 2>;name="LOG1", 3>;physname="/sybase/log1.dat", 4>;vdevno=3, 5>;size=512000             /*意思是有1G的大小*/ 6>;go 然後在這上面建庫 1>;create database test 2>;on DATA1=2800         /*意思是有2800M的大小*/ 3>;log on LOG1=900       /*意思是有900M的大小*/ 4>;go 等了兩個小時，就報以下錯誤： create database :allocating 1433600 logical pages (2800.0 megabytes)on disk 'DATA1'. create database :allocating 460800 logical pages (900.0 megabytes)on disk 'LOG1'. Msg 3225,level 21, State 1: Server 'SYBASE', Line 1: I/O failed while attempting to clear pages starting at page0 of disk number 2. 請哪位清楚這問題的朋友解釋一下，謝謝 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 UP~ 請各位兄弟會的話,就指教一二.謝謝 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 檢測一下你的I/O速度，另最好貼出server運行日誌 檢查以下/sybase/data1.dat所在盤區是否有存儲問題 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 page0 of disk number 2 你這個問題是由於你的數據庫使用了磁盤設備的0快,但是操作系統可能佔用了. 我對linux不熟悉,象tru64 unix,對於磁盤的0塊,要做相應的處理的 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 我的「sybase/data1.dat」存儲應該沒有問題，因為我的系統只做了一個分區"/"，把所有東西都裝在一個分區下，有12G; 日誌明天回公司就貼出來。 [color=red]  另問：怎麼檢測我的I/O速度啊？[/color] 我從windows裝了sybase client，用sybase central 連過去建一個庫時，跳出這樣一個窗口。然後就中斷了。請問是怎麼一回事？ 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 你貼出的sybase central返回有I/O error，還是仔細檢查一下的好 I/O速度測試好像是用OS的辦法吧，比如vmstat,iostat等，如果有其他更方便的更好 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 你好,現在我把IO的情況和運行日誌發上來, 請會的DX幫一下忙,分析一下,謝謝! :em02: 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 倒，你沒用過vmstat和iostat啊？看來你還需要看點資料。 把你create database前後的日誌貼上來就好，不過90%的可能是I/O問題。 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 10:53:06.15 kernel Use license fileopt/sybase-12.5/SYSAM/licenses/license.dat.   10:53:06.26 kernel  Checked out license ASE_SERVER   10:53:06.26 kernel  Adaptive Server Enterprise Edition   10:53:06.92 kernel  Using config area from primary master device.   10:53:07.09 kernel  Internal run-time model set for Linux  - Native   10:53:07.09 kernel  Using 1024 file descriptors.   10:53:07.09 kernel  Adaptive Server Enterprise/12.5.0.1/EBF 10292 IR/P/Linux intel/Linux 2.4.7-10smp i686/rel12501/1781/32-bit/OPT/Thu Jun  6 14:14:09 2002   10:53:07.09 kernel  Confidential property of Sybase, Inc.   10:53:07.09 kernel  Copyright 1987, 2002   10:53:07.09 kernel  Sybase, Inc.  All rights reserved.   10:53:07.09 kernel  Unpublished rights reserved under U.S. copyright laws.   10:53:07.09 kernel     10:53:07.09 kernel  This software contains confidential and trade secret information of Sybase,   10:53:07.09 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by   10:53:07.09 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license   10:53:07.09 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written   10:53:07.09 kernel  agreement  specifying  the  Government's rights to use the software and any   10:53:07.09 kernel  applicable FAR provisions, for example, FAR 52.227-19.   10:53:07.09 kernel  Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA   10:53:07.09 kernel  Using '/opt/sybase-12.5/ASE/SYBASE.cfg' for configuration information.   10:53:07.09 kernel  Logging ASE messages in file '/opt/sybase-12.5/ASE/install/SYBASE.log'.   10:53:07.60 kernel  kdcl_sess_open: connectivity library supports master/query syntax.   10:53:07.63 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver   10:53:07.63 kernel  SSL Plus v3.0.8 security modules loaded successfully.   10:53:07.63 kernel  Network and device connection limit is 1014.   10:53:08.77 server  Number of blocks left for proc headers: 104808.   10:53:09.12 server  Proc header memory allocated 52404 pages for each per engine cache   10:53:09.15 server  Memory allocated for the default data cache cachelet 1: 8192 Kb   10:53:09.15 server  Size of the 2K memory pool: 8192 Kb   10:53:09.16 kernel  Loading [librt.so.1] for Async disk I/O support.   10:53:09.16 kernel   dblkIO_aio_init: mapped at 0x50248750   10:53:09.16 kernel   dblkIO_aio_read: mapped at 0x50248db4   10:53:09.16 kernel   dblkIO_aio_write: mapped at 0x50249304   10:53:09.16 kernel   dblkIO_aio_suspend: mapped at 0x50248e64   10:53:09.17 kernel   dblkIO_aio_return: mapped at 0x50248e34   10:53:09.17 kernel   dblkIO_aio_error: mapped at 0x50248e34   10:53:09.17 kernel  Enabling (RT) Posix asynchronous disk I/O strategy.   10:53:09.17 kernel  Initializing virtual device 0, '/opt/sybase-12.5/dev/rsyb_master' with dsync 'on'.   10:53:09.17 kernel  Virtual device 0 started using asynchronous i/o.   10:53:09.17 kernel  Worker Thread Manager is not enabled for use in SQL Server.   10:53:09.19 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.   10:53:09.19 kernel  Unix interval timer enabled for sysclk interrupts.   10:53:09.19 kernel  engine 0, os pid 1727  online   10:53:09.21 server  No active traceflags   10:53:09.59 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10292 IR/P/Linux Intel/Linux 2.4.7-10smp i686/rel12501/1781/32-bit/OPT/Thu Jun  6 14:14:09 2002'.   10:53:09.59 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF9963/DRV.12.5.0.1/Linux Intel/Linux 2.2.14-5.0smp i686/BUILD125-011/OPT/Mon Dec  3 15:14:08 2001'   10:53:09.59 server  Opening Master Database ...   10:53:10.00 server  Loading SQL Server's default sort order and character set   10:53:10.01 server  Loaded default Unilib conversion handle.   10:53:10.14 server  Recovering database 'master'.   10:53:10.49 server  Checking external objects.   10:53:10.63 server  Database 'master' is now online.   10:53:10.65 server  The transaction log in the database 'master' will use I/O size of 2 Kb.   10:53:10.66 server  Warning: ASE_HA has no valid license and therefore is not initialized.   10:53:10.66 server  server name is 'SYBASE'   10:53:10.72 server  Activating disk 'sysprocsdev' of size 146800640 KB.   10:53:10.72 kernel  Initializing virtual device 1, '/opt/sybase-12.5/dev/rsyb_proc' with dsync 'on'.   10:53:10.73 kernel  Virtual device 1 started using asynchronous i/o.   10:53:10.85 server  Recovering database 'sybsystemdb'.   10:53:11.05 server  Boot Count: 5   10:53:11.09 server  Checking external objects.   10:53:11.41 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.   10:53:11.42 server  Database 'sybsystemdb' is now online.   10:53:11.50 server  Recovering database 'model'.   10:53:11.53 server  Checking external objects.   10:53:11.57 server  The transaction log in the database 'model' will use I/O size of 2 Kb.   10:53:11.58 server  Database 'model' is now online.   10:53:11.58 server  The logical pagesize of the server is 2 Kb.   10:53:11.58 server  0 dump conditions detected at boot time   10:53:11.59 server  Resident Node id: 94f3252c5afd   10:53:11.59 server  Transaction coordinator initialized.   10:53:11.59 server  Clearing temp db   10:53:12.28 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.   10:53:12.29 server  Database 'tempdb' is now online.   10:53:12.39 server  Recovering database 'sybsystemprocs'.   10:53:12.45 server  Checking external objects.   10:53:12.54 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.   10:53:12.57 server  Database 'sybsystemprocs' is now online. 10:53:12.58 kernel  network name hgm, type ether, port 4100, filter NONE   10:53:12.62 server  Recovery complete.   10:53:12.62 server  SQL Server's default unicode sort order is 'binary'.   10:53:12.62 server  SQL Server's default sort order is:   10:53:12.62 server          'bin_iso_1' (ID = 50)   10:53:12.63 server  on top of default character set:   10:53:12.63 server          'iso_1' (ID = 1).   10:53:12.63 server  Master device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.) 10:57:06.51 kernel  dcreate: error creating db/sybsystem/sybsyntaxdev.dat.  System message is: No such file or directory 12:33:59.15 kernel  dcreate: error creating /opt/sybase-12.5/dev.  File already exists. 13:04:11.83 kernel  Initializing virtual device 2, '/opt/sybase-12.5/dev/data1.dat' with dsync 'on'.   13:04:11.83 kernel  Virtual device 2 started using asynchronous i/o.   13:04:11.84 kernel  Initializing device /opt/sybase-12.5/dev/data1.dat from offset 0 with zeros.   13:16:37.09 kernel  Finished initialization.   13:19:12.37 kernel  Initializing virtual device 3, '/opt/sybase-12.5/dev/log1.dat' with dsync 'on'.   13:19:12.37 kernel  Virtual device 3 started using asynchronous i/o.   13:19:12.37 kernel  Initializing device /opt/sybase-12.5/dev/log1.dat from offset 0 with zeros.   13:23:09.32 kernel  Finished initialization. 14:54:06.91 kernel  Cannot send, host process disconnected: ITC 1480 spid: 11   14:54:06.97 server  Error: 1608, Severity: 18, State: 4   14:54:06.97 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.   19:28:02.70 kernel  rt__dpoll aio_error returned 22   19:28:02.72 kernel  rt__dpoll set dberrcode 22, aio_return expected 16384, got 0   19:28:02.72 kernel  sddone: write error on virtual disk 2 block 1048576:   19:28:02.75 kernel  sddone: Invalid argument 19:28:02.77 server  Error: 3225, Severity: 21, State: 1 19:28:02.77 server  I/O failed while attempting to clear pages starting at page 0 of disk number 2.   20:19:56.41 kernel  rt__dpoll aio_error returned 22   20:19:56.41 kernel  rt__dpoll set dberrcode 22, aio_return expected 2048, got 0   20:19:56.41 kernel  sddone: write error on virtual disk 2 block 1048576:   20:19:56.41 kernel  sddone: Invalid argument   20:19:56.75 server  Error: 823, Severity: 24, State: 2   20:19:56.75 server  I/O error detected during wait for BUF pointer = '0x0x4feb1b78', MASS pointer = '0x0x4feb1b78', (Buf#: '0'), page ptr = '0x0x4fcfb000', dbid = '4', Mass virtpage = '34603008', Buffer page = '0', Mass status = '0x80908', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x(nil)', spid = '0'.   20:19:56.87 kernel  current process (0x150015) infected with 11   20:19:56.87 kernel  ************************************   20:19:56.87 kernel  SQL causing error : CREATE DATABASE postest ON DATA1 = 2900 LOG ON LOG1 = 900 FOR LOAD   20:19:56.87 kernel  ************************************   20:19:56.89 server  SQL Text: CREATE DATABASE postest ON DATA1 = 2900 LOG ON LOG1 = 900 FOR LOAD   20:19:56.89 kernel  curdb = 3 pstat = 0x14000 lasterror = 823   20:19:56.89 kernel  preverror = 0 transtate = 0   20:19:56.89 kernel  curcmd = 203 program = SC_ASE_Mgmt                     20:19:56.95 kernel  pc 0x862e2a9 ucbacktrace+0x89(0x0,0x1,0x8d4694c,0xb,0x4054a419)   20:19:56.95 kernel  pc 0x810b647 terminate_process+0xb13(0x0,0xffffffff,0xb,0x40070918,0x0)   20:19:56.95 kernel  pc 0x8646568 kisignal+0x48(0xb,0x40549130,0x405491b0,0x40065b0a,0x8d4694c)   20:19:56.96 kernel  pc 0x40065b53 init_dummy+0x3779d83f(0xb,0x40549130,0x405491b0,0xb,0x0)   20:19:56.96 kernel  pc 0x4009f950 init_dummy+0x377d763c(0x0,0x4054a419,0x4054a3fb,0x8d4694c,0x815257c)   20:19:56.98 kernel  pc 0x815328f sybformat+0x303(0x22,0x2,0x4054995c,0x4054a3d4,0x4054997c)   20:19:56.98 kernel  pc 0x815259c ex_stuffp+0x22c(0x2,0x4054a7f0,0x4054a5f0,0x24,0x40549fcc)   20:19:56.98 kernel  pc 0x814f82d ex_doprint+0xa2d(0x337,0x18,0x2,0x4054ab34,0x8d4694c)   20:19:56.98 kernel  pc 0x814edf5 ex_print+0x99(0x337,0x18,0x2,0x4054ab34,0x8d4694c)   20:19:56.98 kernel  pc 0x815411c hdl_default+0x3c(0x8,0x17,0x18,0x2,0x4054ab34)   20:19:56.99 kernel  pc 0x83ca70a s_handle+0xdca(0x8,0x17,0x18,0x2,0x4054ab34)   20:19:56.99 kernel  pc 0x8153b90 ex_raise+0x2f8(0x8,0x17,0x18,0x2,0x32d3)   20:19:56.99 kernel  pc 0x818f8a1 buf__writewait+0x1c9(0x4feb1b78,0x8d4694c,0xf04,0x2100000,0x4feb1a04)   20:19:56.99 kernel  pc 0x818e92d bufwrite+0x1a1(0x4feb1b78,0x0,0x8d4694c,0xf04,0x100000)   20:19:56.99 kernel  pc 0x82f3495 writepgs+0x2d(0x0,0x0,0x0,0x2100000,0x4feb1b78)   20:19:56.99 kernel  pc 0x82f2067 crdb_phys+0x4d7(0x4054add8,0x3ff,0x1dafff,0x4,0x4054ad8c)   20:19:56.99 kernel  pc 0x81860e3 ex_cleanup(0x42996dac,0x8d4694c,0x0,0x0,0x83c1129)   20:19:56.99 kernel  pc 0x81860e3 ex_cleanup(0x8d4694c,0x0,0x422cf800,0x4273e910,0x1)   20:19:56.99 kernel  pc 0x83c76fd sequencer+0xe51(0x429fe800,0x8d4694c,0x0,0x422cf800,0x811aaba)   20:19:56.99 kernel  pc 0x81860e3 ex_cleanup(0x0,0x0,0x0,0x0,0x0)   20:19:56.99 kernel  pc 0x813d829 conn_hdlr+0x2531(0xa,0x4054bac0,0x895eed31,0x0,0x0)   20:19:56.99 kernel  pc 0x82efa64 crdb_main+0xc84(0x0,0x0,0x0,0x403eb900,0x16)   20:19:56.99 kernel  pc 0x895eed31 init_dummy+0x80d26a1d(0x0,0x403eb900,0x16,0x1,0x5374616b)   20:19:56.99 kernel  end of stack trace, spid 16, kpid 1376277, suid 1   20:19:57.00 server  WARNING: Pss found with open sdes. pspid 8, psuid 1110243340, pcurdb 16, system table entry 1, sdesp 0x0x002, objid 8   20:19:57.03 server  Error: 6103, Severity: 17, State: 1 20:19:57.03 server  Unable to do cleanup for the killed process; received Msg 823. 20:34:35.18 server  SQL Server shutdown by request. 20:34:35.25 kernel  ueshutdown: exiting 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 嘿嘿，Error: 823，快檢查一下存儲吧，也可能是hobbylu說的page 0的問題，具體是存儲什麼問題，我就知道了 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 不會吧,你不知道,我那咋辦? 呵呵~ 我是用: 我沒有用裸設備,直接用文件系統建一個數據庫test,以下是具體操作： 1>;disk init 2>;name="DATA1", 3>;physname="/sybase/data1.dat", 4>;vdevno=2, 5>;size=1536000            /*意思是有3G的大小*/ 這樣做的設備,這樣會有問題嗎? 我用的是雙系統2000+RH2.1, 難道,我就只能用SQL2000? 我的tempdb只有120M,這個有關係嗎? 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 文件系統就永遠不壞？如果是設備本身有問題，無論是裸設備或文件系統，一概都完蛋。 當然，並不一定是存儲徹底無法用了，也許只是小毛病。你可以先檢查一下OS的日誌，看看有沒有進一步信息。OS的東西偶不太熟悉，嘿嘿，不好意思。 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 呵呵，偶也遇到了同樣的問題，不過，我是用sybase central建立的數據庫設備和數據庫，在安裝時一切正常。 我的步驟是： 1、安裝sybase12.5,這一步一切正常（我也是用的文件系統）。 2、啟動sybase server,能夠正常登陸。 3、用sybase central建立數據庫設備，在「指定位置」處我寫的是7003，因為用fdisk /dev/hda查看過，我的磁盤使用的最大是7002。 4、建立數據庫，出現如下錯誤。 00:00000:00008:2005/06/09 01:44:29.88 kernel  Initializing virtual device 4, '/moive/LINUX_JXC.dat' with dsync 'on'. 00:00000:00008:2005/06/09 01:44:29.88 kernel  Virtual device 4 started using asynchronous i/o. 00:00000:00008:2005/06/09 01:44:29.88 kernel  Initializing device /moive/LINUX_JXC.dat from offset 14342144 with zeros. 00:00000:00008:2005/06/09 01:46:24.84 kernel  Finished initialization. /*上面的日誌是建設備的，數據庫設備建立一切正常。   下面的是，在建立數據庫時的錯誤日誌。*/ 00:00000:00000:2005/06/09 01:55:03.65 kernel  rt__dpoll aio_error returned 22 00:00000:00000:2005/06/09 01:55:03.67 kernel  rt__dpoll set dberrcode 22, aio_return expected 16384, got -1243948860 00:00000:00000:2005/06/09 01:55:03.67 kernel  sddone: write error on virtual disk 4 block 1048579: 00:00000:00000:2005/06/09 01:55:03.70 kernel  sddone: Invalid argument 00:00000:00008:2005/06/09 01:55:03.72 server  Error: 3225, Severity: 21, State: 1 00:00000:00008:2005/06/09 01:55:03.74 server  I/O failed while attempting to clear pages starting at page 7003 of disk number 4. 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 偶懷疑是aio什麼地方需要調整吧，具體的不清楚 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 哈哈，昨天弄了一個晚上，終於把問題解決了. 我的辦法是用fdisk /dev/hda重新劃分/data分區，/date的啟始塊為1310，在創建數據庫設備時啟始塊中改為1311,創建了一個2000M的空間，數據庫設備建好後再創建數據庫 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 今晚一怒之下把系統做掉，重來，呵呵。做了裸設備。暈，上次文件系統還是不明白咋回事。 呵呵，現在一切都搞定了。 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 今天早上load一個企業的數據庫時，發生了以下錯誤，請各位指點一下： 1>; load database posba from "/opt/sybase-12.5/dump/posqt_dump.1" 2>; stripe on "opt/sybase-12.5/dump/posqt_dump.2" 3>; stripe on "opt/sybase-12.5/dump/posqt_dump.3" 4>; stripe on "opt/sybase-12.5/dump/posqt_dump.4" 5>; go 原以為出錯了，怎麼知道是我寫錯了路徑，慚愧，正確的路徑應該是： /opt/sybase-12.5/dump/posqt_dump.2 就差一個 /   搞了半小時，呵呵~ :em02: 太粗心了 在紅帽子AS2.1上(2.4.9)上安裝了sybase12.5,建庫時出了問題 有句真理「機器不會錯，錯的只會是人」，呵呵，說的很對呀。 [ 關閉窗口 ]