From: Rich Bonfoey (Rich.Bonfoey@mail.tribnet.com)
Date: Thu Nov 20 2003 - 20:45:32 EST
I recently posted a query to the group and I apologize for not providing
enough information.
I'll try to give as much as possible
We are using Veritas 3.2 ( VxVM ), running on E3500 with Solaris 8. We
have 2 A5100 attached to the E3500 and a LSI SANs. All of the storage,
with the exception of 142 gig is use by our data base engine. We are using
Sybase ASE 12.0.5 as the data base engine.
I have attached apportion of the errorlog that shows the error. I have also
attached a sample of the log file from the data base.
When we try to grow one of the data base ( the one being expanded is
rop_ads_data10 ) we get a series of errors.
We think the problem is with the data base engine. If anyone has any ideas
or a pointer to location to do more research on the problem.
Thanks again for your help
Richard Bonfoey
The News Tribune
Information Systems
Successfully Meeting the Business Needs of
The News Tribune through Information Technology
MessageFrom: Mark Devlin
Sent: Thursday, November 20, 2003 1:24 PM
To: Rich Bonfoey
Subject: Sybase error
current process (0x59a30109) infected with 11
Address 0x00177934 (bufsearch+0x8c), siginfo (code, address) = (1, 0x00000000)
************************************
SQL causing error : alter database rop_ads on rop_ads_data10 = 16384
************************************
SQL Text: alter database rop_ads on rop_ads_data10 = 16384
curdb = 4 pstat = 0x10000 lasterror = 0
preverror = 0 transtate = 0
curcmd = 215 program = sqsh
pc: 0x00657470 pcstkwalk+0x24(0x9c8dcf70, 0x00000000, 0x0000270f, 0x00000002, 0xfffffff8)
pc: 0x0065737c ucstkgentrace+0x194(0x59a30109, 0x9fe06f98, 0x9fe06f98, 0x9d53ffc8, 0x00000000)
pc: 0x00624780 ucbacktrace+0xa8(0x9d53ffc8, 0x00000001, 0x59a30109, 0x9f5d1788, 0x00000000)
pc: 0x000f65b4 terminate_process+0xd80(0x00bfc988, 0x000054e8, 0x000054e4, 0x00005000, 0x00006800)
pc: 0x0063a018 kisignal+0x1e0(0x9c8dda54, 0x9c8dd7bc, 0x0000000b, 0x9c8dd790, 0x9c8dda48)
pc: 0xff354cc8 setitimer+0xfc(0x0000000b, 0x9c8dda48, 0x9c8dd790, 0x00639e38, 0x00000000)
pc: 0xff34fb00 sema_post+0x510(0xff3675a8, 0x00000001, 0xff3678e0, 0x9c8dd790, 0x9c8dda48)
pc: 0xff34fccc sema_post+0x6dc(0xff3675a8, 0x9c8dda48, 0x9c8dd790, 0xff366000, 0x9c8dda48)
pc: 0x0064c814 upsleepgeneric+0x268(0xffffffff, 0xfffe7234, 0x00000000, 0x00000000, 0x00000000)
pc: 0x0028c2fc getpage_with_validation+0xdc(0x9fe0750c, 0x00000000, 0x9fe075a0, 0x00000000, 0x00000000)
pc: 0x0028dd6c getpage_noscan_with_validation+0x78(0x000070d4, 0x9c8dddfc, 0x9fe06f98, 0x00000000, 0x000
pc: 0x001ae478 pg__gam_extend+0x68(0x9c8dddfc, 0x9fe0750c, 0x9c8dddfc, 0x9fe080d0, 0xfbdbfe38)
[Handler pc: 0x0013ddb0 hdl_backout_msg installed by the following function:-]
pc: 0x001ada48 pg_gamalloc+0x48c(0x00000000, 0x00a9bb58, 0x0000000b, 0xab39781c, 0xab397800)
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
pc: 0x002cb498 altdb_extend+0xbc0(0x00bee000, 0x00000000, 0x02680000, 0x0000000a, 0x01e80000)
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
pc: 0x002ca718 alterdb+0x900(0x00bfd800, 0x00bfc800, 0x00000004, 0x00000000, 0x00000001)
pc: 0x00390aa4 s_execute+0x351c(0x000000d7, 0x000000d7, 0xaab68430, 0x00005393, 0x00001000)
[Handler pc: 0x003aa544 s_handle installed by the following function:-]
pc: 0x003a742c sequencer+0x10e8(0x00bee000, 0x00bfc800, 0x9bc17f00, 0x00005388, 0x9fe06f98)
pc: 0x0011d2f8 tdsrecv_language+0xb4(0x00bee000, 0x00bfd800, 0x00000001, 0x00005000, 0x00005400)
[Handler pc: 0x0013dd90 hdl_backout installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
[Handler pc: 0x00344428 ut_handle installed by the following function:-]
pc: 0x0012cab0 conn_hdlr+0x2120(0x00bfd800, 0x00bee000, 0x00000000, 0x000054e4, 0x00007000)
pc: 0x0066a20c _coldstart(0x00000006, 0x0012a990, 0x00000000, 0x00000000, 0x00000000)
end of stack trace, spid 278, kpid 1503854857, suid 1
From: Super-User [root@snoqualmie.tacomanews.com]
Sent: Thursday, November 20, 2003 6:02 AM
To: DTISysAdmin@mail.tribnet.com
Subject: dbspace(ROP_ADS)
dbspace.pl starting rop_ads at Thu Nov 20 06:00:33 2003.
==========================================================
19258 kb 18.81 mb 0.03% Space used in Ad
8660 kb 8.46 mb 0.01% Space used in AdAdditions
49254 kb 48.10 mb 0.09% Space used in AdEditionsPattern
7222 kb 7.05 mb 0.01% Space used in AdHistory
4758 kb 4.65 mb 0.01% Space used in AdOverflow
65550 kb 64.01 mb 0.11% Space used in AuditAd
5520 kb 5.39 mb 0.01% Space used in AuditAdAdditions
43347994 kb 42332.03 mb 74.96% Space used in AuditCoreData
4318 kb 4.22 mb 0.01% Space used in BaseBreak
13773832 kb 13451.01 mb 23.82% Space used in CoreData
13190 kb 12.88 mb 0.02% Space used in Customer
29464 kb 28.77 mb 0.05% Space used in CustomerContractRates
123392 kb 120.50 mb 0.21% Space used in CustomerHistory
1830 kb 1.79 mb 0.00% Space used in CustomerReps
2992 kb 2.92 mb 0.01% Space used in Folio
1722 kb 1.68 mb 0.00% Space used in LogicalPage
3488 kb 3.41 mb 0.01% Space used in Orders
5678 kb 5.54 mb 0.01% Space used in PagePosition
2796 kb 2.73 mb 0.00% Space used in Pages
3520 kb 3.44 mb 0.01% Space used in PayHistory
1946 kb 1.90 mb 0.00% Space used in PbGrids
11022 kb 10.76 mb 0.02% Space used in Pricing
8886 kb 8.68 mb 0.02% Space used in Production
1332 kb 1.30 mb 0.00% Space used in QueryList
1806 kb 1.76 mb 0.00% Space used in SectOrClassContracts
1166 kb 1.14 mb 0.00% Space used in SectOrClassMapping
3592 kb 3.51 mb 0.01% Space used in SectOrClassRates
3764 kb 3.68 mb 0.01% Space used in statusAudit
1572 kb 1.54 mb 0.00% Space used in syscolumns
4214 kb 4.12 mb 0.01% Space used in syscomments
36634 kb 35.78 mb 0.06% Space used in sysprocedures
1308 kb 1.28 mb 0.00% Space used in TearSheets
2802 kb 2.74 mb 0.00% Space used in VersionControl
1888 kb 1.84 mb 0.00% Space used in WebTransfer
rop_ads_data01: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data01: Freespace: 112 kb 0.11 mb 0.00 gb
rop_ads_data02: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data02: Freespace: 112 kb 0.11 mb 0.00 gb
rop_ads_data03: Size: 8388608 kb 4096.00 mb 4.00 gb
rop_ads_data03: Freespace: 28 kb 0.03 mb 0.00 gb
rop_ads_data04: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data04: Freespace: 182 kb 0.18 mb 0.00 gb
rop_ads_data05: Size: 8388608 kb 4096.00 mb 4.00 gb
rop_ads_data05: Freespace: 294 kb 0.29 mb 0.00 gb
rop_ads_data06: Size: 8388608 kb 4096.00 mb 4.00 gb
rop_ads_data06: Freespace: 98 kb 0.10 mb 0.00 gb
rop_ads_data07: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data07: Freespace: 0 kb 0.00 mb 0.00 gb
rop_ads_data08: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data08: Freespace: 1684496 kb 1645.02 mb 1.61 gb
rop_ads_data09: Size: 16777216 kb 8192.00 mb 8.00 gb
rop_ads_data09: Freespace: 3402256 kb 3322.52 mb 3.24 gb
Total size = 62914560 kb 61440.00 mb 60.00 gb
Total used = 57826982 kb 56471.66 mb 55.15 gb
Total freespace = 5087578 kb 4968.34 mb 4.85 gb
SUMMARY: rop_ads database is filled to 91.91% 55.15gb of 60.00gb
SUMMARY: ---WARNING--- rop_ads is nearly full 91.91% 55.15gb of 60.00gb
==========================================================
dbspace.pl finished rop_ads at Thu Nov 20 06:02:19 2003.
==========================================================
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:27:32 EDT