For some reason the tables BDB corrupt.
Last night it leaves running programs (implemented in C) that consults and
modifies these tables and in morning one of the indexes was corrupt.
All the programs use mysql_close to close the connection to the database.
Look the query i did today of morning :
mysql> describe sist_adm; (BDB TABLE)
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-------------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment
|
| nombre | varchar(30) | YES | MUL | NULL |
|
| so | varchar(30) | YES | | NULL |
|
| descripcion | varchar(50) | YES | | NULL |
|
+-------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from sist_adm;
+----+----------+-------------+-------------------------------+
| id | nombre | so | descripcion |
+----+----------+-------------+-------------------------------+
| 1 | master | AIX 4.2 | Equipo de comunicaciones |
| 2 | zeus | Solaris 2.6 | Sistema de pruebas. |
| 3 | donald | Solaris 2.6 | Sistema de desarrollo |
| 4 | apserver | Solaris 2.6 | Sistema standby de produccion |
+----+----------+-------------+-------------------------------+
4 rows in set (0.00 sec)
mysql> select * from sist_adm where id>1;
Empty set (0.00 sec)
The command resolve_stack_dump reports:
0x40077552 _end + 9374242427
0x811815d berkeley_cmp_packed_key__FP4__dbPC8__db_dbtT1 + 81
0x816222a __bam_cmp + 138
0x81a8da8 __bam_search + 856
0x819ea50 __bam_c_search + 1628
0x819c6ac __bam_c_get + 1288
0x8175751 __db_c_get + 841
0x8115a4f index_read__11ha_berkeleyPcPCcUi16ha_rkey_function + 395
0x8108e8a get_next__12QUICK_SELECT + 282
0x810af5f rr_quick__FP14st_read_record + 23
0x80f7fac
mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemUl15enum_duplicate
s13thr_lock_type + 2316
0x80cd3f1 mysql_execute_command__Fv + 5173
0x80d02c3 mysql_parse__FP3THDPcUi + 199
0x80cb6d9 do_command__FP3THD + 1305
0x80cac06 handle_one_connection__FPv + 578
mysqld died in the query:
UPDATE alarmas SET status=0,fechahora=SYSDATE() WHERE id=-125
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 41 min 0 sec
Threads: 1 Questions: 73 Slow queries: 0 Opens: 71 Flush tables:
1 Open tables: 64 Queries per second avg: 0.030
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux centinela 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS=''
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 30 21:12
/lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000
/lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000
/usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000
/usr/lib/libc.so
� Any idea ?
Sorry for my english.
Regards,
Diego.-
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
