Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
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()
 
Regular B*TREE ERR NOT ftsTemp IN filetype : 0

Regular B*TREE ERR NOT ftsTemp IN filetype : 0

2006-10-23       - By Florian Schmitz

 Back
Reply:     1     2  

Hello List,

our 7.5.00.34 instance suffers from regular B*TREE Errors.
The diagnosis file database errors show the following :

2006-10-23 10:27:55 15657 ERR 53173 B*TREE   NOT ftsTemp IN filetype: 0
2006-10-23 10:27:55 15657 ERR 53000 B*TREE   230DAB00000000001B20000000000000
2006-10-23 10:27:55 15657 ERR 53000 B*TREE   Root  1115698208
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   ----> Emergency Stack Back Trace <
----
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (0):0xab6efe
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (1):0xab5e7d
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (2):0xab5fc8
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (3):0x80d396
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (4):0x5dbc0e
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (5):0x720df5
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (6):0x71f370
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (7):0x54c586
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (8):0x54c62a
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (9):0x54c6d2
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (10):0x8fcd86
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (11):0x54c680
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (12):0xaf33a0
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (13):0xaf3206
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   (14):0x2b069c4d8da0
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   ----> Module List <----
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |.text Start       |.text End    
   | Module File Name
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x0000000000400000
|0x0000000000b81000|
/opt/sdb/7500/pgm/kernel
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002aaacd424000
|0x00002aaacd4d1000|
/opt/sdb/7500/lib/liboms.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069bc19000
|0x00002b069bc34000| /lib64/ld-2.4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069bd36000
|0x00002b069bd47000|
/lib64/libpthread-2 (See http://ead-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069be4c000
|0x00002b069be4e000| /lib64/libdl-2 (See http://bdl-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069bf50000
|0x00002b069bf58000| /lib64/librt-2 (See http://brt-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069c05a000
|0x00002b069c11d000|
/usr/lib64/libstdc++.so.5.0.7
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069c236000
|0x00002b069c28a000| /lib64/libm-2 (See http://ibm-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069c38b000
|0x00002b069c398000|
/lib64/libgcc_s.so.1
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069c499000
|0x00002b069c5bf000| /lib64/libc-2 (See http://ibc-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   |0x00002b069c6bf000
|0x00002b069c6c2000| /lib64/libc-2 (See http://ibc-2.ora-code.com).4.so
2006-10-23 10:27:55 15657 ERR 11599 BTRACE
2006-10-23 10:27:55 15657 ERR 11599 BTRACE   ----> Symbolic Stack Back Trace <-
---
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      0: 0x0000000000ab700f eo670
_UnixTraceStack +0x02ed
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      1: 0x0000000000ab5e7d eo670
_CTraceContextStackOCB
+0x0009
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      2: 0x0000000000ab5fc8
vtracestack +0x004b
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      3: 0x000000000080d396
b01destroy_file +0x00cb
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      4: 0x00000000005dbc0e
a262execute_trigger +0x08f0
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      5: 0x0000000000720df5 ak93one
_command +0x0ab0
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      6: 0x000000000071f370 a93_user
_commands +0x04f0
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      7: 0x000000000054c586 ak91run
_sql_process +0x007a
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      8: 0x000000000054c62a ak91run
_user_process +0x0074
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE      9: 0x000000000054c6d2
a91mainprogam_with_allocator
+0x003b
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE     10: 0x00000000008fcd86
gg941CreateAllocatorAndCallMainprog +0x01a4
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE     11: 0x000000000054c680
a91mainprogram +0x0036
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE     12: 0x0000000000af33a0
_Z23en88_CallKernelTaskMainP9TASK_TYPE +0x0194
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE     13: 0x0000000000af3206
en88_CallCoroutineKernelTaskMain +0x001a
2006-10-23 10:27:56 15657 ERR 11599 BTRACE          /opt/sdb/7500/pgm/kernel
2006-10-23 10:27:56 15657 ERR 11599 BTRACE         Frameinfo [0x0]
2006-10-23 10:27:56 15657 ERR 11599 BTRACE   ----> End of Stack Back Trace <----


The instance is running and is up fine but once a day we get this error ...

Any clues?

Flo

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