Infected Process #3
Before I take the monumental step of logging a call with Sybase I thought I'd leverage the wisdom of the newsgroup experts first. Basically I'm getting a stack trace when executing a stored proc within a batch series of sp's, unfortunately that's all I get. There is no specific mention of an error and it isn't preceded by an error message. Can anyone give me a indication as to what it is crashing on in the sp. This is the version of Sybase we are using Adaptive Server Enterprise/12.5.4/EBF 16792 ESD#10/P/Linux Intel/Enterprise Linux/ase1254/2159/32-bit/OPT/Mon Nov 2 03:16:49 2009 intersting I don' encounter this error on another machine without ESD 10. Adaptive Server Enterprise/12.5.4/EBF 13388/P/Linux Intel/Enterprise Linux/ase1254/2006/32-bit/OPT/Fri May 19 23:17:01 2006 Adittidly the resources between these machines are different but not hugely, namely difference in RAM (2.7GB and 1.5GB) with the former encountering the error, and disk speed. Both are in VM enviornments. 00:00000:00030:2010/11/29 15:14:40.54 kernel Current process (0x38230014) infected with signal 11 (SIGSEGV) 00:00000:00030:2010/11/29 15:14:40.54 kernel Address 0x0x089114f4 (memhilo+0x20), siginfo (code, address) = (1, 0x(nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel ************************************ 00:00000:00030:2010/11/29 15:14:40.54 kernel SQL causing error : xxxx_xxx @batch_no = 37254 , @run_key = 66737 00:00000:00030:2010/11/29 15:14:40.54 kernel ************************************ 00:00000:00030:2010/11/29 15:14:40.54 server SQL Text: xxxx_xxx @batch_no = 37254 , @run_key = 66737 00:00000:00030:2010/11/29 15:14:40.54 kernel curdb = 6 tempdb = 2 pstat = 0x10100 00:00000:00030:2010/11/29 15:14:40.54 kernel lasterror = 0 preverror = 0 transtate = 0 00:00000:00030:2010/11/29 15:14:40.54 kernel curcmd = 197 program = isql 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088daa1b pcstkwalk+0x2b(0x5834b820, 0x5834b5dc, 0x0000270f, 0x00000002, 0x09301a58) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088da956 ucstkgentrace+0x1b6(0x38230014, 0x00000002, 0x0000270f, (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08875bc0 ucbacktrace+0xa0((nil), 0x00000001, 0x09301a58, 0x5834c0f8, (nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08183871 terminate_process+0xcb1((nil), 0xffffffff, 0x09301a58, 0x5bf32540, (nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088a53bf kisignal+0x1ff(0x0000000b, 0x5834e10c, 0x5834e18c, 0x0000000b, (nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0xb7f36440 init_dummy+0xaf2f8c90((nil), 0x00000001, 0x5bf32540, 0x00000001, 0x09301a58) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08576a16 bin__sqlhilo_X+0x33a(0x5819b100, (nil), 0x00000001, 0x5bf32540, 0x00000001) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x0861be9d run+0xfd5(0x5e407800, 0x5e40fc40, 0x09301a58, (nil), 0x5e40f8f0) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dd389 exec_eop+0xf89(0x5e407800, 0x5e40fc40, 0x583520a0, 0x09301a58, 0x583520a0) 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dca79 exec_eop+0x679(0x5e407800, 0x5e40f8f0, 0x583520a0, 0x5e407800, (nil)) 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x085e0c60 execerr installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x0875f3f8 jcsExHandler installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x085832ac sortmerr installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x085e0c60 execerr installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x085e0c60 execerr installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: 0x0x084e7cd4 aritherr installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dc0b8 execute+0x9ac(0x5a68e744, 0x5e407800, 0x000000c5, 0x583520a0, 0x09301a58) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08515c06 s_execute+0x2b1e(0x09301a58, 0x00001000, 0x00000020, (nil), 0x58fedac0) 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x081e3710 hdl_stack installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x085345ac s_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 sequencer+0x1065(0x5ae46000, 0x09301a58, 0x57f9e720, 0x57f9e720, 0x00000020) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 execproc+0x970(0x5bb4da80, 0x5bb4db28, (nil), (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), 0x5fd455d8) 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x081e3710 hdl_stack installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x085345ac s_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 sequencer+0x1065(0x5d6b1000, 0x09301a58, 0x57f9e720, 0x57f9e720, (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 execproc+0x970(0x5fd455d8, 0x5fd45680, (nil), (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), 0x5ad54d28) 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x081e3710 hdl_stack installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x085345ac s_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 sequencer+0x1065(0x5f600000, 0x09301a58, 0x57f9e720, 0x57f9e720, (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 execproc+0x970(0x5ad54d28, 0x5ad54dd0, (nil), (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), 0x203d2079) 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x081e3710 hdl_stack installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x085345ac s_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 sequencer+0x1065(0x5af8d800, 0x09301a58, (nil), (nil), 0x0819809a) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081b86b9 tdsrecv_language+0x2e5((nil), (nil), (nil), (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x081e3744 hdl_backout installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x08494880 ut_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: 0x0x08494880 ut_handle installed by the following function:-] 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081c8899 conn_hdlr+0x2c35(0x0000001b, 0x583542ac, 0x895eed31, (nil), (nil)) 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x088cac48 kpexit((nil), (nil), (nil), 0x581ef100, 0x00000015) 00:00000:00030:2010/11/29 15:14:40.56 kernel end of stack trace, spid 30, kpid 941817876, suid 15
|
0 |
|
Shane
11/29/2010 3:44:01 AM
sybase.ase.administration
7058 articles. 
2 followers.
2 Replies
672 Views
infected with 11 means the dataserver process received a signal 11 from the OS. Signal 11 means the process tried to access a memory address that doesn't belong to it. So the cause is a bad pointer value in a memory structure. I don't find any known 12.5.x bugs that are a good match. The only interesting function name on the stack is bin__sqlhilo_X, which is used in string comparison. Is either server using traceflag 1628? -bret On 11/28/2010 8:44 PM, Shane wrote: > Before I take the monumental step of logging a call with > Sybase I thought I'd leverage the wisdom of the newsgroup > experts first. > > Basically I'm getting a stack trace when executing a stored > proc within a batch series of sp's, unfortunately that's all > I get. There is no specific mention of an error and it > isn't preceded by an error message. Can anyone give me a > indication as to what it is crashing on in the sp. > > This is the version of Sybase we are using > Adaptive Server Enterprise/12.5.4/EBF 16792 ESD#10/P/Linux > Intel/Enterprise Linux/ase1254/2159/32-bit/OPT/Mon Nov 2 > 03:16:49 2009 > > intersting I don' encounter this error on another machine > without ESD 10. > Adaptive Server Enterprise/12.5.4/EBF 13388/P/Linux > Intel/Enterprise Linux/ase1254/2006/32-bit/OPT/Fri May 19 > 23:17:01 2006 > > Adittidly the resources between these machines are different > but not hugely, namely difference in RAM (2.7GB and 1.5GB) > with the former encountering the error, and disk speed. > Both are in VM enviornments. > > 00:00000:00030:2010/11/29 15:14:40.54 kernel Current > process (0x38230014) infected with signal 11 (SIGSEGV) > 00:00000:00030:2010/11/29 15:14:40.54 kernel Address > 0x0x089114f4 (memhilo+0x20), siginfo (code, address) = (1, > 0x(nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel > ************************************ > 00:00000:00030:2010/11/29 15:14:40.54 kernel SQL causing > error : xxxx_xxx @batch_no = 37254 , @run_key = 66737 > > 00:00000:00030:2010/11/29 15:14:40.54 kernel > ************************************ > 00:00000:00030:2010/11/29 15:14:40.54 server SQL Text: > xxxx_xxx @batch_no = 37254 , @run_key = 66737 > 00:00000:00030:2010/11/29 15:14:40.54 kernel curdb = 6 > tempdb = 2 pstat = 0x10100 > 00:00000:00030:2010/11/29 15:14:40.54 kernel lasterror = 0 > preverror = 0 transtate = 0 > 00:00000:00030:2010/11/29 15:14:40.54 kernel curcmd = 197 > program = isql > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088daa1b > pcstkwalk+0x2b(0x5834b820, 0x5834b5dc, 0x0000270f, > 0x00000002, 0x09301a58) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088da956 > ucstkgentrace+0x1b6(0x38230014, 0x00000002, 0x0000270f, > (nil), (nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08875bc0 > ucbacktrace+0xa0((nil), 0x00000001, 0x09301a58, 0x5834c0f8, > (nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08183871 > terminate_process+0xcb1((nil), 0xffffffff, 0x09301a58, > 0x5bf32540, (nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x088a53bf > kisignal+0x1ff(0x0000000b, 0x5834e10c, 0x5834e18c, > 0x0000000b, (nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0xb7f36440 > init_dummy+0xaf2f8c90((nil), 0x00000001, 0x5bf32540, > 0x00000001, 0x09301a58) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x08576a16 > bin__sqlhilo_X+0x33a(0x5819b100, (nil), 0x00000001, > 0x5bf32540, 0x00000001) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x0861be9d > run+0xfd5(0x5e407800, 0x5e40fc40, 0x09301a58, (nil), > 0x5e40f8f0) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dd389 > exec_eop+0xf89(0x5e407800, 0x5e40fc40, 0x583520a0, > 0x09301a58, 0x583520a0) > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dca79 > exec_eop+0x679(0x5e407800, 0x5e40f8f0, 0x583520a0, > 0x5e407800, (nil)) > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x085e0c60 execerr installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x0875f3f8 jcsExHandler installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x085832ac sortmerr installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x085e0c60 execerr installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x085e0c60 execerr installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel [Handler pc: > 0x0x084e7cd4 aritherr installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.54 kernel pc: 0x085dc0b8 > execute+0x9ac(0x5a68e744, 0x5e407800, 0x000000c5, > 0x583520a0, 0x09301a58) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08515c06 > s_execute+0x2b1e(0x09301a58, 0x00001000, 0x00000020, (nil), > 0x58fedac0) > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x081e3710 hdl_stack installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x085345ac s_handle installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 > sequencer+0x1065(0x5ae46000, 0x09301a58, 0x57f9e720, > 0x57f9e720, 0x00000020) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 > execproc+0x970(0x5bb4da80, 0x5bb4db28, (nil), (nil), (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 > s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), > 0x5fd455d8) > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x081e3710 hdl_stack installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x085345ac s_handle installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 > sequencer+0x1065(0x5d6b1000, 0x09301a58, 0x57f9e720, > 0x57f9e720, (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 > execproc+0x970(0x5fd455d8, 0x5fd45680, (nil), (nil), (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 > s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), > 0x5ad54d28) > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x081e3710 hdl_stack installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x085345ac s_handle installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 > sequencer+0x1065(0x5f600000, 0x09301a58, 0x57f9e720, > 0x57f9e720, (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x0851ce24 > execproc+0x970(0x5ad54d28, 0x5ad54dd0, (nil), (nil), (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08516061 > s_execute+0x2f79(0x09301a58, (nil), (nil), (nil), > 0x203d2079) > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x081e3710 hdl_stack installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x085345ac s_handle installed by the following function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x08531559 > sequencer+0x1065(0x5af8d800, 0x09301a58, (nil), (nil), > 0x0819809a) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081b86b9 > tdsrecv_language+0x2e5((nil), (nil), (nil), (nil), (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x081e3744 hdl_backout installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x08494880 ut_handle installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel [Handler pc: > 0x0x08494880 ut_handle installed by the following > function:-] > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x081c8899 > conn_hdlr+0x2c35(0x0000001b, 0x583542ac, 0x895eed31, (nil), > (nil)) > 00:00000:00030:2010/11/29 15:14:40.56 kernel pc: 0x088cac48 > kpexit((nil), (nil), (nil), 0x581ef100, 0x00000015) > 00:00000:00030:2010/11/29 15:14:40.56 kernel end of stack > trace, spid 30, kpid 941817876, suid 15
|
|
0 |
|
Bret
11/29/2010 4:41:25 PM
No. The only addition to the standard run file is export LD_POINTER_GUARD=0 Thanks though, that's two things I know now that I didn't know before. > infected with 11 means the dataserver process received > a signal 11 from the OS. Signal 11 means the process > tried to access a memory address that doesn't belong to > it. So the cause is a bad pointer value in a memory > structure. > > I don't find any known 12.5.x bugs that are a good match. > > The only interesting function name on the stack is > bin__sqlhilo_X, which is used in string comparison. > > > Is either server using traceflag 1628? > > -bret > > >
|
|
0 |
|
Shane
12/1/2010 1:14:22 AM
Similar Artilces:
ASE patch 12.5.0.3 ebf10980 but still meet "kernel timeslice -501, current process infected" error!
Hi all, kernel: 2.4.9-e.9,glibc:2.2.4-29.1,ASE 12.5.0.3 EBF10980. When ct try to create a talbe, dataserver meet "kernel timeslice -501, current process infected", and all the client cannot connect to server . I had ask ct to add -T1639 traceflag and increase 'cpu grace time' parameter. But the problem cannot be resolved. Any help will be appreciated 00:00000:00012:2003/06/25 10:30:42.40 kernel ************************************ 00:00000:00012:2003/06/25 10:30:42.40 kernel SQL causing error : create TABLE wzg_temp_tab ( D_JiZhang_Date datetime, ...
ASE 11.0.3.3 to ASE 12
We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 12. Are there any problems we should be aware of? ...
ASE 11.0.3.3 to ASE 12 #2
We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 12. Are there any problems we should be aware of? Anatoly, Check for datatype mismatches - int -> smallint, datetime->smalldatetime, etc.. (the P&T Guide has a section on this). Also make sure to run update statistics on all your user tables. Hope this helps, Eric Miner Sr. Engineer DST Engineering Optimizer Group Anatoly_Reznik wrote: > We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE > 12. Are there any problems we should be aware of? ...
ASE 11.0.3.3 and ASE 11.9.2 on same box
Hi evereyone, I would like to install 2 ASE servers with different versions on same linux box. Is this possible? Here is what I tried to do: I have a working ASE 11.9.2 on linux box tried to install ASE 11.0.3.3 on same box in different directory and it gave me an error. Wondering if this ispossible at all. Appreciate any help. TIA ar The 11.0.3.3 rpm tries to uninstall the 11.9.2 package. I shutdown the 11.9.2 server before install 11.0.3.3 and I do not keep the both versions running. The variables SYBASE, LD_LIBRARY_PATH ,PATH must be correctly set to point the...
[URGENT] current process (0xc000c) infected with 11 + timeslice -501, current process infected
Hi Sybase gurus, I would appreciate any feedback on this error?! This happens when I install Solaris 2.6 and afterwards sybase - it's systematic. It's on a Ultra 10. 00:00000:00000:2000/10/19 11:10:32.75 kernel Using config area from primary master device. 00:00000:00000:2000/10/19 11:10:32.78 kernel Configuration Error: Configuration file, '/opt/sybase/FREGNAVIS.cfg', does not exist. 00:00000:00000:2000/10/19 11:10:32.80 kernel Warning: A configuration file was not specified and the default file '/opt/sybase/FREGNAVIS.cfg' does not exist. SQL Server...
[URGENT] current process (0xc000c) infected with 11 + timeslice -501, current process infected
Hi Sybase gurus, I would appreciate any feedback on this error?! This happens when I install Solaris 2.6 and afterwards sybase - it's systematic. It's on a Ultra 10. 00:00000:00000:2000/10/19 11:10:32.75 kernel Using config area from primary master device. 00:00000:00000:2000/10/19 11:10:32.78 kernel Configuration Error: Configuration file, '/opt/sybase/FREGNAVIS.cfg', does not exist. 00:00000:00000:2000/10/19 11:10:32.80 kernel Warning: A configuration file was not specified and the default file '/opt/sybase/FREGNAVIS.cfg' does not exist. SQL Server...
Upgrading ASE 11.9.2 to ASE 12.5 on Aix 4.3.3
After migration from ASE 11.9.2 to ASE 12.5, the following error appears when I try to execute a strore procedure : Size of row in the worktable for grouped aggregate, 16542 bytes, exceeds the maximum row size (1962 bytes). Cannot run this query (return status = -6). Is it a bug on ASE 12.5? Why could I run correctly this procedure on the old version? Fabien DUBOIS Fabien DUBOIS wrote: > > After migration from ASE 11.9.2 to ASE 12.5, the following error appears > when I try to execute a strore procedure : > > Size of row in the worktable for grouped aggr...
Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3
Recently, Application Security, Inc. has run a vulnerability test on our ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we install the latest Sybase patch 12.5.3 ESD#3. I have some question on the recommendation. 1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3? 2. Is it practical to keep up with the latest releases or patches? Now if we upgrade to 12.5.4 and then rerun the vulnerability test, will the program suggest that newer version is better with respect to s...
Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...
Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...
Same machine: ASE 12.5.3 Linux vs ASE 12.5.3 Windows
We had a report from one of our clients recently that our Sybase ASE-based app was running slowly on their new Linux box. As we develop internally against ASE on Windows we thought it would be an interesting test to install both the Windows and Linux flavors of ASE 12.5.3 onto the same server and look at the relative performance. We used a Dell PowerEdge 1950 with 2 x Intel Xeon 3.73GHz dual core processors. On one drive we put SuSE Enterprise Linux Server 10 x86-64, and on the other we put Windows Server 2003 Std R2 64-bit edition. Both were fresh-off-the-CD OS installs. ...
ASE 11.9.3 performance compared to 11.0.3.3
At our site, we just upgraded from 11.0.3.3 to 11.9.3 - in the process we changed machines, so: old configuration: ASE 11.0.3.3 on a Sparc 10 running Solaris 2.5.1, 1 processor, 100 Mb allocated to sybase new configuration: ASE 11.9.3 on a Sun E250 running Solaris 7, 2 processors, 200 Mb allocated to sybase. I'm running in to two performance related problems: 1) High throughput inserts/updates of tables. We have a data feed that pumps data into the database at a high rate of speed. We have more memory and faster disks on the new system, but the rate at whic...
Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...
Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from 12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2. If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used during the upgrade. If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is new binary for 5.2. Other than backup the databases and load them to the new server, is there a supported how to upgrade? Thanks! ...
Hi all, kernel: 2.4.9-e.9,glibc:2.2.4-29.1,ASE 12.5.0.3 EBF10980. When ct try to create a talbe, dataserver meet "kernel timeslice -501, current process infected", and all the client cannot connect to server . I had ask ct to add -T1639 traceflag and increase 'cpu grace time' parameter. But the problem cannot be resolved. Any help will be appreciated 00:00000:00012:2003/06/25 10:30:42.40 kernel ************************************ 00:00000:00012:2003/06/25 10:30:42.40 kernel SQL causing error : create TABLE wzg_temp_tab ( D_JiZhang_Date datetime, ...
ASE 11.0.3.3 to ASE 12
We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 12. Are there any problems we should be aware of? ...
ASE 11.0.3.3 to ASE 12 #2
We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE 12. Are there any problems we should be aware of? Anatoly, Check for datatype mismatches - int -> smallint, datetime->smalldatetime, etc.. (the P&T Guide has a section on this). Also make sure to run update statistics on all your user tables. Hope this helps, Eric Miner Sr. Engineer DST Engineering Optimizer Group Anatoly_Reznik wrote: > We're planning to upgrade our existing environment from ASE 11.0.3.3 to ASE > 12. Are there any problems we should be aware of? ...
ASE 11.0.3.3 and ASE 11.9.2 on same box
Hi evereyone, I would like to install 2 ASE servers with different versions on same linux box. Is this possible? Here is what I tried to do: I have a working ASE 11.9.2 on linux box tried to install ASE 11.0.3.3 on same box in different directory and it gave me an error. Wondering if this ispossible at all. Appreciate any help. TIA ar The 11.0.3.3 rpm tries to uninstall the 11.9.2 package. I shutdown the 11.9.2 server before install 11.0.3.3 and I do not keep the both versions running. The variables SYBASE, LD_LIBRARY_PATH ,PATH must be correctly set to point the...
[URGENT] current process (0xc000c) infected with 11 + timeslice -501, current process infected
Hi Sybase gurus, I would appreciate any feedback on this error?! This happens when I install Solaris 2.6 and afterwards sybase - it's systematic. It's on a Ultra 10. 00:00000:00000:2000/10/19 11:10:32.75 kernel Using config area from primary master device. 00:00000:00000:2000/10/19 11:10:32.78 kernel Configuration Error: Configuration file, '/opt/sybase/FREGNAVIS.cfg', does not exist. 00:00000:00000:2000/10/19 11:10:32.80 kernel Warning: A configuration file was not specified and the default file '/opt/sybase/FREGNAVIS.cfg' does not exist. SQL Server...
[URGENT] current process (0xc000c) infected with 11 + timeslice -501, current process infected
Hi Sybase gurus, I would appreciate any feedback on this error?! This happens when I install Solaris 2.6 and afterwards sybase - it's systematic. It's on a Ultra 10. 00:00000:00000:2000/10/19 11:10:32.75 kernel Using config area from primary master device. 00:00000:00000:2000/10/19 11:10:32.78 kernel Configuration Error: Configuration file, '/opt/sybase/FREGNAVIS.cfg', does not exist. 00:00000:00000:2000/10/19 11:10:32.80 kernel Warning: A configuration file was not specified and the default file '/opt/sybase/FREGNAVIS.cfg' does not exist. SQL Server...
Upgrading ASE 11.9.2 to ASE 12.5 on Aix 4.3.3
After migration from ASE 11.9.2 to ASE 12.5, the following error appears when I try to execute a strore procedure : Size of row in the worktable for grouped aggregate, 16542 bytes, exceeds the maximum row size (1962 bytes). Cannot run this query (return status = -6). Is it a bug on ASE 12.5? Why could I run correctly this procedure on the old version? Fabien DUBOIS Fabien DUBOIS wrote: > > After migration from ASE 11.9.2 to ASE 12.5, the following error appears > when I try to execute a strore procedure : > > Size of row in the worktable for grouped aggr...
Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3
Recently, Application Security, Inc. has run a vulnerability test on our ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we install the latest Sybase patch 12.5.3 ESD#3. I have some question on the recommendation. 1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3? 2. Is it practical to keep up with the latest releases or patches? Now if we upgrade to 12.5.4 and then rerun the vulnerability test, will the program suggest that newer version is better with respect to s...
Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...
Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...
Same machine: ASE 12.5.3 Linux vs ASE 12.5.3 Windows
We had a report from one of our clients recently that our Sybase ASE-based app was running slowly on their new Linux box. As we develop internally against ASE on Windows we thought it would be an interesting test to install both the Windows and Linux flavors of ASE 12.5.3 onto the same server and look at the relative performance. We used a Dell PowerEdge 1950 with 2 x Intel Xeon 3.73GHz dual core processors. On one drive we put SuSE Enterprise Linux Server 10 x86-64, and on the other we put Windows Server 2003 Std R2 64-bit edition. Both were fresh-off-the-CD OS installs. ...
ASE 11.9.3 performance compared to 11.0.3.3
At our site, we just upgraded from 11.0.3.3 to 11.9.3 - in the process we changed machines, so: old configuration: ASE 11.0.3.3 on a Sparc 10 running Solaris 2.5.1, 1 processor, 100 Mb allocated to sybase new configuration: ASE 11.9.3 on a Sun E250 running Solaris 7, 2 processors, 200 Mb allocated to sybase. I'm running in to two performance related problems: 1) High throughput inserts/updates of tables. We have a data feed that pumps data into the database at a high rate of speed. We have more memory and faster disks on the new system, but the rate at whic...
Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...
Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from 12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2. If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used during the upgrade. If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is new binary for 5.2. Other than backup the databases and load them to the new server, is there a supported how to upgrade? Thanks! ...
Web resources about - Infected Process #3 - sybase.ase.administration
Infected Mushroom - Wikipedia, the free encyclopedia... sources, including acoustic guitars and complex synthesized basses, and their compositions often contain changes of drum beat and tempo . Infected ...
Trend Micro Will Make A HouseCall To Facebook Users Infected By Malware
Facebook users who have potentially been infected by malware may be prompted to download the free version of HouseCall to remove any existing ...
Facebook users who have potentially been infected by malware may be prompted to download the free version of HouseCall to remove any existing ...
HIV-infected cell - Flickr - Photo Sharing!http://www.plosone.org/article/info:doi/10.1371/journal.pone.0050026
Infected with Ebola in Atlanta Airport, 13 December - YouTubeAnother Ebola case has been discovered in Atlanta 13 December. Liberian citizen, arrived to the Hartsfield-Jackson Atlanta International Airport. ...
Doctors treating Emirati at Abu Dhabi hospital also infected with Mers virus... have been diagnosed in the UAE, local and international health officials announced. ABU DHABI // Four Abu Dhabi doctors treating a man infected ...
Ebola-infected patients on the run in LiberiaYoung men who believe the Ebola epidemic is a lie have attacked a clinic in Liberia, forcing infected patients to flee for their lives.
Spanish nurse may have been infected with Ebola by touching face with contaminated glovesA Spanish nurse, who is the first person to contract Ebola outside Africa, may have been infected by touching her face with gloves while she ...
Ekka E-coli video - Ekka showgoers infected with E-coli, BrisbaneA number of people contract the potentially "deadly illness" E-coli at the Ekka, prompting authorities to urge showgoers to "wash your hands" ...
Measles-infected tourist visits DreamworldQueensland Health has confirmed another interstate tourist was infected with measles while visiting the Sunshine State in early October.
Herpes-infected monkeys terrorise FloridaBEWARE of the monkeys!
Resources last updated: 12/8/2015 10:34:26 AM