Hi,

This happened multiple times after deleting a huge table (2GB) yesterday:

2005-04-07 05:35:17     0     12847 DBSTATE  Kernel exited without core and 
exit status 0x9
2005-04-07 05:35:17     0     12850 DBSTATE  Kernel exited due to signal 
9(SIGKILL)
2005-04-07 05:35:18     0     12808 DBSTATE  Flushing knltrace pages
2005-04-07 05:35:31     0     11987 dump_rte rtedump written to file 'rtedump'


section from rtedump:


Task Stacks:
task T1
    type         Timer                state        Vsleep        
    stack start  0x71edf000           stack end    0x71ef8000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71ef7cf8           stack maxuse 0x71ef7cf8
    command max         0              total max         0
task T2
    type         ALogwr.              state        Vsuspend      
    stack start  0x71a70000           stack end    0x71a89000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71a88c38           stack maxuse 0x71a88c38
    command max         0              total max         0
task T3
    type         Tracewr.             state        Vsuspend      
    stack start  0x719f6000           stack end    0x71a0f000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71a0ec98           stack maxuse 0x71a0ec98
    command max         0              total max         0
task T4
    type         Datawr.              state        Vsuspend      
    stack start  0x71ef8000           stack end    0x71f11000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f10a38           stack maxuse 0x71f10a38
    command max         0              total max         0
task T5
    type         Datawr.              state        Vsuspend      
    stack start  0x71f11000           stack end    0x71f2a000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f29a38           stack maxuse 0x71f29a38
    command max         0              total max         0
task T6
    type         Datawr.              state        Vsuspend      
    stack start  0x71f2a000           stack end    0x71f43000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f42a38           stack maxuse 0x71f42a38
    command max         0              total max         0
task T7
    type         Datawr.              state        Vsuspend      
    stack start  0x71f43000           stack end    0x71f5c000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f5ba38           stack maxuse 0x71f5ba38
    command max         0              total max         0
task T8
    type         Datawr.              state        Vsuspend      
    stack start  0x71f5c000           stack end    0x71f75000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f74a38           stack maxuse 0x71f74a38
    command max         0              total max         0
task T9
    type         Datawr.              state        Vsuspend      
    stack start  0x71f75000           stack end    0x71f8e000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71f8da38           stack maxuse 0x71f8da38
    command max         0              total max         0
task T10
    type         Datawr.              state        Vsuspend      
    stack start  0x71f8e000           stack end    0x71fa7000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71fa6a38           stack maxuse 0x71fa6a38
    command max         0              total max         0
task T11
    type         Datawr.              state        Vsuspend      
    stack start  0x71fa7000           stack end    0x71fc0000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71fbfa38           stack maxuse 0x71fbfa38
    command max         0              total max         0
task T12
    type         Datawr.              state        Vsuspend      
    stack start  0x71fc0000           stack end    0x71fd9000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71fd8a38           stack maxuse 0x71fd8a38
    command max         0              total max         0
task T13
    type         Datawr.              state        Vsuspend      
    stack start  0x71fd9000           stack end    0x71ff2000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71ff1a38           stack maxuse 0x71ff1a38
    command max         0              total max         0
task T14
    type         Datawr.              state        Vsuspend      
    stack start  0x71ff2000           stack end    0x7200b000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7200aa38           stack maxuse 0x7200aa38
    command max         0              total max         0
task T15
    type         Datawr.              state        Vsuspend      
    stack start  0x7200b000           stack end    0x72024000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72023a38           stack maxuse 0x72023a38
    command max         0              total max         0
task T16
    type         Datawr.              state        Vsuspend      
    stack start  0x72024000           stack end    0x7203d000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7203ca38           stack maxuse 0x7203ca38
    command max         0              total max         0
task T17
    type         Datawr.              state        Vsuspend      
    stack start  0x7203d000           stack end    0x72056000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72055a38           stack maxuse 0x72055a38
    command max         0              total max         0
task T18
    type         Datawr.              state        Vsuspend      
    stack start  0x72056000           stack end    0x7206f000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7206ea38           stack maxuse 0x7206ea38
    command max         0              total max         0
task T19
    type         Datawr.              state        Vsuspend      
    stack start  0x7206f000           stack end    0x72088000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72087a38           stack maxuse 0x72087a38
    command max         0              total max         0
task T20
    type         Datawr.              state        Vsuspend      
    stack start  0x72088000           stack end    0x720a1000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x720a0a38           stack maxuse 0x720a0a38
    command max         0              total max         0
task T21
    type         Datawr.              state        Vsuspend      
    stack start  0x720a1000           stack end    0x720ba000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x720b9a38           stack maxuse 0x720b9a38
    command max         0              total max         0
task T22
    type         Datawr.              state        Vsuspend      
    stack start  0x720ba000           stack end    0x720d3000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x720d2a38           stack maxuse 0x720d2a38
    command max         0              total max         0
task T23
    type         Datawr.              state        Vsuspend      
    stack start  0x720d3000           stack end    0x720ec000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x720eba38           stack maxuse 0x720eba38
    command max         0              total max         0
task T24
    type         Datawr.              state        Vsuspend      
    stack start  0x720ec000           stack end    0x72105000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72104a38           stack maxuse 0x72104a38
    command max         0              total max         0
task T25
    type         Datawr.              state        Vsuspend      
    stack start  0x72105000           stack end    0x7211e000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7211da38           stack maxuse 0x7211da38
    command max         0              total max         0
task T26
    type         Datawr.              state        Vsuspend      
    stack start  0x7211e000           stack end    0x72137000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72136a38           stack maxuse 0x72136a38
    command max         0              total max         0
task T27
    type         Datawr.              state        Vsuspend      
    stack start  0x72137000           stack end    0x72150000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7214fa38           stack maxuse 0x7214fa38
    command max         0              total max         0
task T28
    type         Datawr.              state        Vsuspend      
    stack start  0x72150000           stack end    0x72169000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72168a38           stack maxuse 0x72168a38
    command max         0              total max         0
task T29
    type         Datawr.              state        Vsuspend      
    stack start  0x72169000           stack end    0x72182000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72181a38           stack maxuse 0x72181a38
    command max         0              total max         0
task T30
    type         Datawr.              state        Vsuspend      
    stack start  0x72182000           stack end    0x7219b000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7219aa38           stack maxuse 0x7219aa38
    command max         0              total max         0
task T31
    type         Datawr.              state        Vsuspend      
    stack start  0x7219b000           stack end    0x721b4000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x721b3a38           stack maxuse 0x721b3a38
    command max         0              total max         0
task T32
    type         Datawr.              state        Vsuspend      
    stack start  0x721b4000           stack end    0x721cd000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x721cca38           stack maxuse 0x721cca38
    command max         0              total max         0
task T33
    type         Datawr.              state        Vsuspend      
    stack start  0x721cd000           stack end    0x721e6000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x721e5a38           stack maxuse 0x721e5a38
    command max         0              total max         0
task T34
    type         Datawr.              state        Vsuspend      
    stack start  0x721e6000           stack end    0x721ff000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x721fea38           stack maxuse 0x721fea38
    command max         0              total max         0
task T35
    type         Datawr.              state        Vsuspend      
    stack start  0x721ff000           stack end    0x72218000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x72217a38           stack maxuse 0x72217a38
    command max         0              total max         0
task T36
    type         EventTsk             state        Connect wait  
    stack start  0x71e3b000           stack end    0x71e54000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71e53aa8           stack maxuse 0x71e53aa8
    command max         0              total max         0
task T37
    type         Server               state        Vsuspend      
    stack start  0x71bcd000           stack end    0x71be6000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71be5ae8           stack maxuse 0x71be5ae8
    command max         0              total max         0
task T38
    type         Server               state        Vsuspend      
    stack start  0x71be6000           stack end    0x71bff000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71bfeae8           stack maxuse 0x71bfeae8
    command max         0              total max         0
task T39
    type         Server               state        Vsuspend      
    stack start  0x71bff000           stack end    0x71c18000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c17ae8           stack maxuse 0x71c17ae8
    command max         0              total max         0
task T40
    type         Server               state        Vsuspend      
    stack start  0x71c18000           stack end    0x71c31000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c30ae8           stack maxuse 0x71c30ae8
    command max         0              total max         0
task T41
    type         Server               state        Vsuspend      
    stack start  0x71c31000           stack end    0x71c4a000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c49ae8           stack maxuse 0x71c49ae8
    command max         0              total max         0
task T42
    type         Server               state        Vsuspend      
    stack start  0x71c4a000           stack end    0x71c63000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c62ae8           stack maxuse 0x71c62b78
    command max         0              total max         0
task T43
    type         Server               state        Vsuspend      
    stack start  0x71c63000           stack end    0x71c7c000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c7bae8           stack maxuse 0x71c7bb78
    command max         0              total max         0
task T44
    type         Server               state        Vsuspend      
    stack start  0x71c7c000           stack end    0x71c95000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71c94ae8           stack maxuse 0x71c94b78
    command max         0              total max         0
task T45
    type         Server               state        Vsuspend      
    stack start  0x71c95000           stack end    0x71cae000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71cadae8           stack maxuse 0x71cadb78
    command max         0              total max         0
task T46
    type         Server               state        Vsuspend      
    stack start  0x71cae000           stack end    0x71cc7000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71cc6ae8           stack maxuse 0x71cc6b78
    command max         0              total max         0
task T47
    type         Server               state        Vsuspend      
    stack start  0x71cc7000           stack end    0x71ce0000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71cdfae8           stack maxuse 0x71cdfae8
    command max         0              total max         0
task T48
    type         Server               state        Vsuspend      
    stack start  0x71ce0000           stack end    0x71cf9000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71cf8ae8           stack maxuse 0x71cf8ae8
    command max         0              total max         0
task T49
    type         Server               state        Vsuspend      
    stack start  0x71cf9000           stack end    0x71d12000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d11ae8           stack maxuse 0x71d11ae8
    command max         0              total max         0
task T50
    type         Server               state        Vsuspend      
    stack start  0x71d12000           stack end    0x71d2b000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d2aae8           stack maxuse 0x71d2ab78
    command max         0              total max         0
task T51
    type         Server               state        Vsuspend      
    stack start  0x71d2b000           stack end    0x71d44000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d43ae8           stack maxuse 0x71d43b78
    command max         0              total max         0
task T52
    type         Server               state        Vsuspend      
    stack start  0x71d44000           stack end    0x71d5d000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d5cae8           stack maxuse 0x71d5cb78
    command max         0              total max         0
task T53
    type         Server               state        Vsuspend      
    stack start  0x71d5d000           stack end    0x71d76000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d75ae8           stack maxuse 0x71d75b78
    command max         0              total max         0
task T54
    type         Server               state        Vsuspend      
    stack start  0x71d76000           stack end    0x71d8f000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71d8eae8           stack maxuse 0x71d8eb78
    command max         0              total max         0
task T55
    type         Server               state        Vsuspend      
    stack start  0x71d8f000           stack end    0x71da8000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71da7ae8           stack maxuse 0x71da7b78
    command max         0              total max         0
task T56
    type         Server               state        Vsuspend      
    stack start  0x71da8000           stack end    0x71dc1000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71dc0ae8           stack maxuse 0x71dc0b78
    command max         0              total max         0
task T57
    type         Server               state        Vsuspend      
    stack start  0x71dc1000           stack end    0x71dda000
    stack size   0x00019000 (102400)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71dd9ae8           stack maxuse 0x71dd9b78
    command max         0              total max         0
task T58
    type         Utility              state        Connect wait  
    stack start  0x71aea000           stack end    0x71b4e000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x71b4c478           stack maxuse 0x71b4c478
    command max         0              total max         0
task T59
    type         User                 state        Command wait  
    stack start  0x722aa000           stack end    0x7230e000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7230c3c8           stack maxuse 0x7230c4b8
    command max    108216              total max    108216
task T60
    type         User                 state        Command wait  
    stack start  0x7230e000           stack end    0x72372000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x723703c8           stack maxuse 0x723704b8
    command max    108216              total max    108216
task T61
    type         User                 state        Command wait  
    stack start  0x72372000           stack end    0x723d6000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x723d43c8           stack maxuse 0x723d44b8
    command max    108472              total max    108472
task T62
    type         User                 state        Command wait  
    stack start  0x723d6000           stack end    0x7243a000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x724383c8           stack maxuse 0x724384b8
    command max    108216              total max    108216
task T63
    type         User                 state        Command wait  
    stack start  0x7243a000           stack end    0x7249e000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7249c3c8           stack maxuse 0x7249c4b8
    command max    108216              total max    108216
task T64
    type         User                 state        Command wait  
    stack start  0x7249e000           stack end    0x72502000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x725003c8           stack maxuse 0x725004b8
    command max    108472              total max    108472
task T65
    type         User                 state        Command wait  
    stack start  0x72502000           stack end    0x72566000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x725643c8           stack maxuse 0x725644b8
    command max    108472              total max    108472
task T66
    type         User                 state        Command wait  
    stack start  0x72566000           stack end    0x725ca000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x725c83c8           stack maxuse 0x725c84b8
    command max    108216              total max    108216
task T67
    type         User                 state        Command wait  
    stack start  0x725ca000           stack end    0x7262e000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7262c3c8           stack maxuse 0x7262c4b8
    command max    108216              total max    108216
task T68
    type         User                 state        Command wait  
    stack start  0x7262e000           stack end    0x72692000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x726903c8           stack maxuse 0x726904b8
    command max    108216              total max    108216
task T69
    type         User                 state        Command wait  
    stack start  0x72692000           stack end    0x726f6000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x726f43c8           stack maxuse 0x726f44b8
    command max    108216              total max    108216
task T70
    type         User                 state        Command wait  
    stack start  0x726f6000           stack end    0x7275a000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x727583c8           stack maxuse 0x727584b8
    command max    108216              total max    108216
task T71
    type         User                 state        Command wait  
    stack start  0x7275a000           stack end    0x727be000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x727bc3c8           stack maxuse 0x727bc4b8
    command max    108472              total max    108472
task T72
    type         User                 state        Command wait  
    stack start  0x727be000           stack end    0x72822000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x728203c8           stack maxuse 0x728204b8
    command max    176728              total max    176728
task T73
    type         User                 state        Command wait  
    stack start  0x72822000           stack end    0x72886000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x728843c8           stack maxuse 0x728844b8
    command max    108216              total max    108216
task T74
    type         User                 state        Connect wait  
    stack start  0x72886000           stack end    0x728ea000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x728e84b8           stack maxuse 0x728e84b8
    command max    108216              total max    108216
task T75
    type         User                 state        Connect wait  
    stack start  0x728ea000           stack end    0x7294e000
    stack size   0x00064000 (409600)
    guard begin  0x00000000           guard end    0x00000000
    stack actual 0x7294c4b8           stack maxuse 0x7294c4b8
    command max    108216              total max    108216
...

List of suspend-reasons:
========================

Total Suspends: 7060

TableRootShare :       3 (   0.04% ) bd13GetNode                             
IOWait(R)(041) :     371 (   5.25% ) b13get_node: await read              :-(
Vsuspend (054) :       4 (   0.06% ) Pager_Controller::WaitForDwReply        
Vsuspend (212) :       1 (   0.01% ) kb90parent_wait                         
Vsuspend (217) :    1224 (  17.34% ) kb51new_trans (all trans entries used)  
Vsuspend (228) :       1 (   0.01% ) RedoReader waits for end of all RedoTask
NoRedoJob(231) :      48 (   0.68% ) Rst_RedoTrafficControl::ExecuteJobs()   
SyncRedo (232) :    2328 (  32.97% ) Rst_RedoTrafficControl::WaitForIoSeq()  
LogIOwait(234) :    1441 (  20.41% ) Log_Queue::UserTaskEOTReady             
SVP-wait (243) :       1 (   0.01% ) Log_Savepoint::StartSavepointAndWait    
No-Work  (255) :    1638 (  23.20% ) Task is waiting for work                
Index  Region      Get-Cnt       avg_time   tot_time

J�rgen


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to