on 10-04-2016 12:19 PM
Dear ASE experts,
I am getting error like this while taking backups or my abaper activating table EKKO :
I/O error detected during read
for BUF pointer = '0xd1942200', MASS pointer =
I have found a solution in SAP note
https://launchpad.support.sap.com/#/notes/1955596/E
But i dont no how to increase tempdb in sysbase 15.7 on Linux.
Please help me with the syntax to extend tempdb and saptools in sybase
Regards
Hi Jamil,
But the resolution which specified in the SAP Note is:
Resolution
Can you clarify the below things:
1. You got any 1105 Space shortage issues in the tempdb ?
2. Are you hitting Error 823 ?
3. Is the device removed from File system or File system memory got full ?
Regards
Kiran K Adharapuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thans Dear Kiran,
Let me share you whole problem:
Its Sybase ASE 15.7 on SUSE Linux 12.
Actually i am facing two different issues:
1) I am unable to Backup Sybase with Dump database command. I/O Write error.
2) when our abaper try to activate TABLE EKKO his session disconnected with error 823 in sm21 and st22 logs. (This issue is critical for me, want to solve this first)
I am attaching all logs and screenshot of problem to you: See below screenshots of Error Logs and SYBASE DEV.log from SYBASE folder
SE14>EKKO>Activate
SM21
ST22
/usr/sap/DEV/sybase/DEV.log (error point)
same error that is defined in SAPnote 1955596
After finding the solution in SAPnote 1955596
i have try to extend tempdb and resetart DB as mentioned in below screenshot:
No luck so far Please help i am new to SYBASE.
Also attaching tail of DEV.log as well.
00:0004:00000:00103:2016/10/06 09:45:00.63 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0011:00000:00159:2016/10/06 09:45:00.64 server Error: 1105, Severity: 17, State: 2
00:0011:00000:00159:2016/10/06 09:45:00.64 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0017:00000:00147:2016/10/06 09:45:00.65 server Error: 1105, Severity: 17, State: 2
00:0017:00000:00147:2016/10/06 09:45:00.65 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0026:00000:00000:2016/10/06 09:47:20.81 kernel sddone: read error on virtual disk 9 block 5415424:
00:0026:00000:00000:2016/10/06 09:47:20.81 kernel sddone: Input/output error
00:0016:00000:00039:2016/10/06 09:47:20.81 server Error: 823, Severity: 24, State: 1
00:0016:00000:00039:2016/10/06 09:47:20.81 server I/O error detected during read for BUF=0x0x0000000adc329558, MASS=0x0x0000000adc329558, Buf#=0, page=0x0x00000008f3850000, dbid=4, Mass vdevno=9, vpage=5415424, Buf lpage=1332288, Mass stat=0x4000100, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel ************************************
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel SQL causing error : × 20161006 094720 CL_CMM_IDX_SERVICE_PURCH_DOC==CP A 20161006 20161006 0947206 094720 %_CCNM1 A 20161006 20161006 094720 = ?
/* R3:/bas/742_REL/src/k
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel Current statement number: 1 Current line number: 1
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel ************************************
00:0016:00000:00039:2016/10/06 09:47:20.81 server SQL Text: UPDATE "REPOSRC" SET "SDATE" = ? ,"STIME" = ? WHERE "PROGNAME" = ? AND "R3STATE" = ? AND ( "SDATE" < ? OR ( "SDATE" = ? AND "STIME" < ? ) ) /* R3:REP1:0 T:REPOSRC M:100 */
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel curdb = 4 tempdb = 6 pstat = 0x10100 p2stat = 0x20101000
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x0 p7stat = 0x10000
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel lasterror = 823 preverror = 0 transtate = 0
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel curcmd = 197 program = R3D006 10 comm rd ODBC
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel extended error information: hostname: devqas login: SAPSR3
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x000000000161b2db pcstkwalk+0x3a3()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x000000000161adb3 ucstkgentrace+0x263()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000001616d1e ucbacktrace+0x50()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000789c34 terminate_process+0x1144()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x000000000126412d hdl_default+0x3b()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000011f9e19 s_handle+0x3c9()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000001262a85 exc__raise+0x325()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000012626ec exc_raise+0x10c()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000d76cba bufread+0x1e1a()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000ad3648 getpage_with_validation+0x828()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000b4ce8c dol_bt_getnext+0x43c()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000ac7593 getnext+0x413()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000008512d8 LeScanOp::_LeOpNext(ExeCtxt&)+0x108()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000018a880b LeRestrictOp::_LeOpNext(ExeCtxt&)+0x22b()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000018b7802 LeUpdateOp::_LeOpNext(ExeCtxt&)+0x132()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000001878f48 LeEmitNoSndOp::_LeOpNext(ExeCtxt&)+0x1b8()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000000800e48 LePlanNext+0x278()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel [Handler pc: 0x0x0000000000ff7930 le_execerr installed by the following function:-]
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000001003a4a exec_lava+0x28a()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x0000000001252785 s_xoltp_dml+0x1752()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel [Handler pc: 0x0x0000000001262f90 hdl_stack installed by the following function:-]
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel [Handler pc: 0x0x00000000011f9a50 s_handle installed by the following function:-]
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000011fd7d1 sequencer+0x16d1()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000007d48de tdsrecv__dynexec_xoltp+0x377()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000007d175c tdsrecv__dynexec+0x2e4()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000007cfbb7 tdsrecv_dynamic+0x35a()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel [Handler pc: 0x0x0000000001570660 ut_handle installed by the following function:-]
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel pc: 0x00000000007ef926 conn_hdlr+0x2f76()
00:0016:00000:00039:2016/10/06 09:47:20.81 kernel end of stack trace, spid 39, kpid 5570603, suid 6
00:0004:00000:00087:2016/10/06 09:50:00.64 server Error: 1105, Severity: 17, State: 2
00:0004:00000:00087:2016/10/06 09:50:00.64 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0004:00000:00087:2016/10/06 09:55:00.62 server Error: 1105, Severity: 17, State: 2
00:0004:00000:00087:2016/10/06 09:55:00.62 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0012:00000:00045:2016/10/06 10:00:01.02 server Error: 1105, Severity: 17, State: 2
00:0012:00000:00045:2016/10/06 10:00:01.02 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0003:00000:00188:2016/10/06 10:00:01.02 server Error: 1105, Severity: 17, State: 2
00:0003:00000:00188:2016/10/06 10:00:01.02 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0017:00000:00124:2016/10/06 10:00:01.03 server Error: 1105, Severity: 17, State: 2
00:0017:00000:00124:2016/10/06 10:00:01.03 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0012:00000:00086:2016/10/06 10:00:01.04 server Error: 1105, Severity: 17, State: 2
00:0012:00000:00086:2016/10/06 10:00:01.04 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0006:00000:00095:2016/10/06 10:00:03.15 server Error: 1105, Severity: 17, State: 2
00:0006:00000:00095:2016/10/06 10:00:03.15 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0007:00000:00121:2016/10/06 10:00:03.15 server Error: 1105, Severity: 17, State: 2
00:0007:00000:00121:2016/10/06 10:00:03.15 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0017:00000:00194:2016/10/06 10:00:03.16 server Error: 1105, Severity: 17, State: 2
00:0017:00000:00194:2016/10/06 10:00:03.16 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0009:00000:00173:2016/10/06 10:00:03.16 server Error: 1105, Severity: 17, State: 2
00:0009:00000:00173:2016/10/06 10:00:03.16 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0007:00000:00250:2016/10/06 10:00:05.23 server Error: 1105, Severity: 17, State: 2
00:0007:00000:00250:2016/10/06 10:00:05.23 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0019:00000:00171:2016/10/06 10:00:05.24 server Error: 1105, Severity: 17, State: 2
00:0019:00000:00171:2016/10/06 10:00:05.24 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0018:00000:00187:2016/10/06 10:00:05.25 server Error: 1105, Severity: 17, State: 2
00:0018:00000:00187:2016/10/06 10:00:05.25 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0012:00000:00251:2016/10/06 10:00:05.25 server Error: 1105, Severity: 17, State: 2
00:0012:00000:00251:2016/10/06 10:00:05.25 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0003:00000:00263:2016/10/06 10:00:07.36 server Error: 1105, Severity: 17, State: 2
00:0003:00000:00263:2016/10/06 10:00:07.36 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0013:00000:00106:2016/10/06 10:00:07.36 server Error: 1105, Severity: 17, State: 2
00:0013:00000:00106:2016/10/06 10:00:07.36 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0009:00000:00211:2016/10/06 10:00:07.37 server Error: 1105, Severity: 17, State: 2
00:0009:00000:00211:2016/10/06 10:00:07.37 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0003:00000:00156:2016/10/06 10:00:07.38 server Error: 1105, Severity: 17, State: 2
00:0003:00000:00156:2016/10/06 10:00:07.38 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0009:00000:00260:2016/10/06 10:00:09.41 server Error: 1105, Severity: 17, State: 2
00:0009:00000:00260:2016/10/06 10:00:09.41 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0020:00000:00190:2016/10/06 10:00:09.42 server Error: 1105, Severity: 17, State: 2
00:0020:00000:00190:2016/10/06 10:00:09.42 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0010:00000:00257:2016/10/06 10:00:09.42 server Error: 1105, Severity: 17, State: 2
00:0010:00000:00257:2016/10/06 10:00:09.42 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0009:00000:00081:2016/10/06 10:05:00.43 server Error: 1105, Severity: 17, State: 2
00:0009:00000:00081:2016/10/06 10:05:00.43 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0009:00000:00182:2016/10/06 10:10:00.43 server Error: 1105, Severity: 17, State: 2
00:0009:00000:00182:2016/10/06 10:10:00.43 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0026:00000:00000:2016/10/06 10:12:26.19 kernel sddone: read error on virtual disk 9 block 5415424:
00:0026:00000:00000:2016/10/06 10:12:26.19 kernel sddone: Input/output error
00:0004:00000:00051:2016/10/06 10:12:26.19 server Error: 823, Severity: 24, State: 1
00:0004:00000:00051:2016/10/06 10:12:26.19 server I/O error detected during read for BUF=0x0x0000000adc325a70, MASS=0x0x0000000adc325a70, Buf#=0, page=0x0x00000008f374c000, dbid=4, Mass vdevno=9, vpage=5415424, Buf lpage=1332288, Mass stat=0x4000100, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel ************************************
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel SQL causing error : × 20161006 101226 CL_CMM_IDX_SERVICE_PURCH_DOC==CP A 20161006 20161006 1012266 101225 %_CCNM1 A 20161006 20161006 101225= ?
/* R3:/bas/742_REL/src/kr
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel Current statement number: 1 Current line number: 1
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel ************************************
00:0004:00000:00051:2016/10/06 10:12:26.19 server SQL Text: UPDATE "REPOSRC" SET "SDATE" = ? ,"STIME" = ? WHERE "PROGNAME" = ? AND "R3STATE" = ? AND ( "SDATE" < ? OR ( "SDATE" = ? AND "STIME" < ? ) ) /* R3:REP1:0 T:REPOSRC M:100 */
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel curdb = 4 tempdb = 6 pstat = 0x10100 p2stat = 0x20101000
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x0 p7stat = 0x10000
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel lasterror = 823 preverror = 0 transtate = 0
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel curcmd = 197 program = R3D009 10 comm rd ODBC
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel extended error information: hostname: devqas login: SAPSR3
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x000000000161b2db pcstkwalk+0x3a3()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x000000000161adb3 ucstkgentrace+0x263()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000001616d1e ucbacktrace+0x50()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000789c34 terminate_process+0x1144()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x000000000126412d hdl_default+0x3b()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000011f9e19 s_handle+0x3c9()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000001262a85 exc__raise+0x325()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000012626ec exc_raise+0x10c()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000d76cba bufread+0x1e1a()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000ad3648 getpage_with_validation+0x828()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000b4ce8c dol_bt_getnext+0x43c()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000ac7593 getnext+0x413()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000008512d8 LeScanOp::_LeOpNext(ExeCtxt&)+0x108()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000018a880b LeRestrictOp::_LeOpNext(ExeCtxt&)+0x22b()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000018b7802 LeUpdateOp::_LeOpNext(ExeCtxt&)+0x132()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000001878f48 LeEmitNoSndOp::_LeOpNext(ExeCtxt&)+0x1b8()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000000800e48 LePlanNext+0x278()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel [Handler pc: 0x0x0000000000ff7930 le_execerr installed by the following function:-]
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000001003a4a exec_lava+0x28a()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x0000000001252785 s_xoltp_dml+0x1752()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel [Handler pc: 0x0x0000000001262f90 hdl_stack installed by the following function:-]
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel [Handler pc: 0x0x00000000011f9a50 s_handle installed by the following function:-]
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000011fd7d1 sequencer+0x16d1()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000007d48de tdsrecv__dynexec_xoltp+0x377()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000007d175c tdsrecv__dynexec+0x2e4()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000007cfbb7 tdsrecv_dynamic+0x35a()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel [Handler pc: 0x0x0000000001570660 ut_handle installed by the following function:-]
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel pc: 0x00000000007ef926 conn_hdlr+0x2f76()
00:0004:00000:00051:2016/10/06 10:12:26.19 kernel end of stack trace, spid 51, kpid 7274552, suid 6
00:0002:00000:00051:2016/10/06 10:15:00.51 server Error: 1105, Severity: 17, State: 2
00:0002:00000:00051:2016/10/06 10:15:00.51 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0005:00000:00232:2016/10/06 10:15:00.52 server Error: 1105, Severity: 17, State: 2
00:0005:00000:00232:2016/10/06 10:15:00.52 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0004:00000:00087:2016/10/06 10:15:00.52 server Error: 1105, Severity: 17, State: 2
00:0004:00000:00087:2016/10/06 10:15:00.52 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0015:00000:00125:2016/10/06 10:15:00.53 server Error: 1105, Severity: 17, State: 2
00:0015:00000:00125:2016/10/06 10:15:00.53 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0004:00000:00215:2016/10/06 10:20:00.52 server Error: 1105, Severity: 17, State: 2
00:0004:00000:00215:2016/10/06 10:20:00.52 server Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
Please help for solution
Best Regards,
Qazi Jamil
HI Jamil,
Login to isql:
$isql -S<SID> -Usapsa -X
1> use master
2> go
1> disk init name = '<device_name>' , physname = '<path/filename>' , size = '<size in MB>M'
2> go
1> alter database <DB_name> on <device_name>= <size>
2> go
or
if you want to use the existing image run the "disk resize"
1> use master
2> go
1> disk resize name = "<device_name>", size = "1024M"
2> go
1> alter database <DB_name> on <device_name>= <size>
2> go
Regards
Kiran K Adharapuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.