Crash is not very stable but it is possible to reproduce it.
The statement is
SELECT
users.USERNAME,ROLE,CONNECTMODE,MAXTIMEOUT,COSTWARNING,COSTLIMIT,timestamp(users.CREATEDATE,users.CREATETIME)
create ,timestamp(ALTERDATE,ALTERTIME)
alt,timestamp(PWCREADATE,PWCREATIME) pwd
FROM USERS,DOMAIN.ROLEPRIVILEGES
WHERE users.OWNER='DBADMIN' and users.USERMODE='STANDARD' and
GRANTEE=USERNAME
ORDER BY users.USERNAME
2006-06-13 11:53:12 0 ERR 11599 BTRACE ----> Symbolic Stack Back
Trace <----
2006-06-13 11:53:12 0 ERR 11599 BTRACE 0: 0x0825391e
a10rel_sysinfo +0x003e
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5ef7c4] (0x79a4c3fc,0x7d5efc1c,0x79a4c430,0x7d5ef800)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 1: 0x0836edf7
ak43dependant_roles +0x0117
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5ef7c4] (0x79a4c3fc,0x7d5efc1c,0x79a4c430,0x7d5ef800)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 2: 0x0836ee0d
ak43dependant_roles +0x012d
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5ef8d4] (0x7d60094c,0x7d5efc1c,0x79a4c178,0x7d5ef910)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 3: 0x0836efd2
ak43role_role_privileges +0x0162
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5ef9e4] (0x7d60094c,0x7d5efc1c,0x79a30158,0x7d5efa28)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 4: 0x0836f3ca
ak43privileges +0x035a
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5efaf4] (0x7d60094c,0x7d5efc1c,0x7ca3c230,0x1)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 5: 0x08370aac a43execute
+0x00cc
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5efb94] (0x7d60094c,0x7d5efc1c,0x79a2cefc,0x8f12a54)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 6: 0x0834eeac
a41execute_show +0x091c
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5efbb4] (0x7d60094c,0x7d5efc1c,0x7d5f35e8,0x79a2c0f4)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 7: 0x0824a31f
a06dml_send_mess_buf +0x007f
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f37b4] (0x7d60094c,0x7d600b4c,0x7d5f37e4,0x63f9)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 8: 0x083a072e
a505most_execute +0x0b9e
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f37e4] (0x7d60094c,0x7d600b4c,0x7d5f90ec,0x7d5f3a5a)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 9: 0x083a1bab
a505loop_most_execute +0x037b
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f3a74] (0x7d60094c,0x7d5f90ec,0x7d5f80dc,0x7d5f5f3c)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 10: 0x08394645
a501exec_with_change_rec +0x0645
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f3cc4] (0x7d60094c,0x7d5f90ec,0x7d5f80dc,0x7d5f5cdc)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 11: 0x083991db
a502complex_execution +0x03ab
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f5de4] (0x7d60094c,0x7d5f90ec,0x7d5f5f3c,0x7d5f80dc)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 12: 0x083945bd
a501exec_with_change_rec +0x05bd
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f5f74] (0x7d60094c,0x7d5f90ec,0x7d5f80dc,0x7d6000a0)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 13: 0x083958e7
a501execute +0x0707
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5f8094] (0x7d60094c,0x7d5f90ec,0x7d6000a0,0x7d5f80dc)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 14: 0x0846f4b2
ak92analyze_messagetype +0x0b62
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d5fff24] (0x7d60094c,0x7d60009c,0x1,0xc)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 15: 0x0846faee
a92_mode_analyzer +0x009e
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d600104] (0x7d60094c,0x0,0x0,0x0)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 16: 0x08470e42
ak93one_command +0x0592
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d600214] (0x7d60094c,0x0,0x0,0x7d6002a8)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 17: 0x08474336
a93_user_commands +0x0566
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d6003c4] (0x7d60094c,0x1,0x7d60044c,0x1)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 18: 0x08a82f66
_Z7SQLTaskR20tak_all_command_globRhb +0x0086
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d6004a4] (0x7d60094c,0x7d600942,0x7d6004c3,0x8b117d0)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 19: 0x08a832d8
_Z11Kernel_MainR13RTETask_ITask +0x02c8
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d6008f4] (0x500fe670,0x2,0x7d60094c,0x7bac3240)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 20: 0x08b1b957
RTETask_TaskMain +0x0047
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d601fa4] (0x500fe670,0x7d601fb4,0xb7dd23f8,0x8f12a54)
2006-06-13 11:53:12 0 ERR 11599 BTRACE 21: 0x08bebf59
en88_CallCoroutineKernelTaskMain +0x0099
2006-06-13 11:53:12 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel
2006-06-13 11:53:12 0 ERR 11599 BTRACE Frameinfo
[0x7d601fc4] (0x3281,0x3,0x8d67442,0x8d732ec)
2006-06-13 11:53:12 0 ERR 11599 BTRACE ----> End of Stack Back
Trace <----
2006-06-13 11:53:12 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001
2006-06-13 11:53:12 0 ERR 11599 BTRACE
2006-06-13 11:53:12 0 ERR 11599 BTRACE no problems detected in
LVCMem_Allocator_001
2006-06-13 11:53:12 0 ERR 11599 BTRACE analysing LVCMem_Allocator_002
2006-06-13 11:53:12 0 ERR 11599 BTRACE
2006-06-13 11:53:12 0 ERR 11599 BTRACE no problems detected in
LVCMem_Allocator_002
2006-06-13 11:53:12 0 ERR 12006 DBCRASH Kernel exited without core
and exit status 0x2f00
2006-06-13 11:53:12 0 ERR 12008 DBCRASH Kernel exited due to
reentered signal handler
2006-06-13 11:53:13 ___ Stopping GMT 2006-06-13
02:53:13 7.6.00 Build 027-121-124-939
2006-06-13 11:53:35 --- Starting GMT 2006-06-13
02:53:35 7.6.00 Build 027-121-124-939
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
