Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
AW: Signal 11 every five minutes or so

AW: Signal 11 every five minutes or so

2007-04-24       - By Auer, Wolfgang

 Back
Reply:     1     2     3  

Hi,

please increase the parameter MAXUSERTASKS of the database.
If the problem remains you should check if your triggers do a recursive call or
call other triggers.

regards
   Wolfgang


Wolfgang Auer
SAP AG

mailto:wolfgang.auer@(protected)
http://www.sap.com

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, L
?o Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Gesch?ftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrt?mlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielf?ltigung
oder Weitergabe der E-Mail ausdr?cklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen
Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or otherwise
confidential information. If you have received this e-mail in error, you are
hereby notified that any review, copying, or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original transmittal.
Thank you for your cooperation.


-- --Urspr?ngliche Nachricht-- --
Von: Ben [mailto:ben@(protected)]
Gesendet: Dienstag, 24. April 2007 11:13
An: maxdb@(protected)
Betreff: Signal 11 every five minutes or so

Hi, we have been using MaxDB version 7.5.00.05 for quite some time now and all
of a sudden we are getting Signal 11 messages every five minutes or so.

Attached is the knldiag.err with irrelevant parts chopped out, if anyone could
help, it would be appreciated. This is a live system that we have not been able
to fix.

2007-04-23 16:23:22                          --- Starting GMT 2007-04-23 06:23
:22           7.5.0    Build 005-121-054-885
2007-04-23 16:34:55     0 ERR 11330 COREHAND ABORTING due to signal 11
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ----> Emergency Stack Back Trace <
----
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (0):0x8365d7e [0x42759b74]
(0x427baf84,0x4476e108,0x4476e108,0xa)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (1):0x8366909 [0x42759b74]
(0x427baf84,0x4476e108,0x4476e108,0xa)
[ .. ]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (186):0x8144002 [0x427bc974]
(0x427bca0c,0x427bc9ac,0x427bc9c4,0x867dbc8)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (187):0x8686954 [0x427bca74]
(0x50020064,0x4022f858,0x4022f840,0x4002a01c)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (188):0x868702d [0x427bca94]
(0x50020064,0x4022f840,0x427bcac4,0x8687007)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (189):0x864732b [0x427bcac4]
(0x50020064,0x4022f840,0x427bcaf4,0x86472ab)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   (190):0x4002bae0 [0x427bcaf4]
(0x4022f808,0x0,0x427bccf8,0x0)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ----> Register Dump <----
2007-04-23 16:34:55     0 ERR 11599 BTRACE   -- ---- ---- ---- ---- ---- ---
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ds   es   0x0000002b 0x0000002b
2007-04-23 16:34:55     0 ERR 11599 BTRACE   fs   gs   0x00000000 0x00000000
2007-04-23 16:34:55     0 ERR 11599 BTRACE   trap err  0x0000000e 0x00000006
2007-04-23 16:34:55     0 ERR 11599 BTRACE   efl  ss   0x00010202 0x0000002b
2007-04-23 16:34:55     0 ERR 11599 BTRACE   edi  esi  0x4476e108 0x427baf84
2007-04-23 16:34:55     0 ERR 11599 BTRACE   eax  ebx  0x00000000
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ecx  edx  0x4476e108
2007-04-23 16:34:55     0 ERR 11599 BTRACE   esp  uesp 0x42756b4c 0x42756b4c
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ebp  eip  0x42759b74 0x08365d7e
2007-04-23 16:34:55     0 ERR 11599 BTRACE   cs   cr2  0x00000023 0x42758b64
2007-04-23 16:34:55     0 ERR 11599 BTRACE   -- ---- ---- ---- ---- ---- ---
2007-04-23 16:34:55     0 ERR 11599 BTRACE   cw - sw - tag   0xffff037f
0xffff4020 0xffffffff
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ipoff - cssel   0x083c705a
0x01c90023
2007-04-23 16:34:55     0 ERR 11599 BTRACE   dataoff-datasel 0x08967020
0x0000002b
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f00      [0xea00 0xb289 0xf68d
0xb355 - 0x4008]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f01      [0x3800 0xee0d 0x48bc
0xef1d - 0x4006]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f02      [0x0000 0x0000 0x0000
0xbdd8 - 0x400b]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f03      [0x0000 0x0000 0x0000
0x8000 - 0x3ffe]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f04      [0x0000 0x0000 0x0000
0xc000 - 0x4000]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f05      [0x0000 0x0000 0x0000
0xca80 - 0x400b]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f06      [0x0000 0x0000 0x2000
0xe31c - 0x4012]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   f07      [0x0000 0x0000 0x0000
0xc000 - 0x4003]
2007-04-23 16:34:55     0 ERR 11599 BTRACE   -- ---- ---- ---- ---- ---- ---
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ----> Module List <----
2007-04-23 16:34:55     0 ERR 11599 BTRACE   |.text Start |.text End   | Module
File Name
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x08048000 | 0x087c0000 | /var
/sdb/7500/pgm/kernel
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x40000000 | 0x40015000 | /lib
/ld-2.3.2.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x40025000 | 0x40034000 | /lib
/libpthread-0 (See http://ead-0.ora-code.com).10.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x40077000 | 0x40079000 | /lib
/libdl-2 (See http://bdl-2.ora-code.com).3.2.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x4007a000 | 0x400b1000 | /usr
/lib/libstdc++-3-libc6.2-2-2.10.0.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x400bc000 | 0x400dd000 | /lib
/libm-2 (See http://ibm-2.ora-code.com).3.2.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x400de000 | 0x40211000 | /lib
/libc-2 (See http://ibc-2.ora-code.com).3.2.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x40218000 | 0x4021f000 | /lib
/libgcc_s-3.2.2-20030225.so.1
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x40322000 | 0x4032d000 | /lib
/libnss_files-2 (See http://les-2.ora-code.com).3.2.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x449cd000 | 0x449db000 | /var
/sdb/7500/lib/libhsscopy.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE   | 0x460da000 | 0x4619a000 | /var
/sdb/7500/lib/liboms.so
2007-04-23 16:34:55     0 ERR 11599 BTRACE
2007-04-23 16:34:55     0 ERR 11599 BTRACE   ----> Symbolic Stack Back Trace <-
---
2007-04-23 16:34:55     0 ERR 11599 BTRACE      0: 0x08365d7e kb62build_trigger
_info +0x0072
2007-04-23 16:34:55     0 ERR 11599 BTRACE          /var/sdb/7500/pgm/kernel
2007-04-23 16:34:55     0 ERR 11599 BTRACE         Frameinfo [0x42759b74]
(0x427baf84,0x4476e108,0x4476e108,0xa)
2007-04-23 16:34:55     0 ERR 11599 BTRACE      1: 0x08366909 k62trigger
_handling +0x00d5
[ .. ]
2007-04-23 16:34:55     0 ERR 11599 BTRACE    187: 0x08686954 en88
_CallKernelTaskMain__FP9TASK_TYPE +0x0148
2007-04-23 16:34:55     0 ERR 11599 BTRACE          /var/sdb/7500/pgm/kernel
2007-04-23 16:34:55     0 ERR 11599 BTRACE         Frameinfo [0x427bca74]
(0x50020064,0x4022f858,0x4022f840,0x4002a01c)
2007-04-23 16:34:55     0 ERR 11599 BTRACE    188: 0x0868702d en88
_RunPthreadTask +0x0035
2007-04-23 16:34:55     0 ERR 11599 BTRACE          /var/sdb/7500/pgm/kernel
2007-04-23 16:34:55     0 ERR 11599 BTRACE         Frameinfo [0x427bca94]
(0x50020064,0x4022f840,0x427bcac4,0x8687007)
2007-04-23 16:34:55     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_1
2007-04-23 16:34:55     0 ERR 11599 BTRACE
2007-04-23 16:34:55     0 ERR 11599 BTRACE   no problems detected in LVCMem
_Allocator_1


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=wolfgang.auer@(protected)


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)