Hello mysql,
mysql 3.23.32 + BDB 3.2.3h
mysql> select * from layers_la00.g03last_hit;
+----------------+------------+---------+----------------+------------+
| updated | counter_id | stat_id | lasthit_ts | lasthit_id |
+----------------+------------+---------+----------------+------------+
| 20010206162625 | 110912 | 1 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 2 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 3 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 6 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 7 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 8 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 9 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 10 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 11 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 12 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 15 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 16 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 18 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 19 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 20 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 21 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 24 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 26 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 27 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 29 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 30 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 31 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 32 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 33 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 34 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 35 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 36 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 39 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 42 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 43 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 45 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 46 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 47 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 49 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 101 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 102 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 103 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 104 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 105 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 106 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 107 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 108 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 109 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 110 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 111 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 112 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 113 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 114 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 115 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 116 | 20010103141348 | 25 |
+----------------+------------+---------+----------------+------------+
50 rows in set (0.00 sec)
mysql> select * from layers_la00.g03last_hit where counter_id=110912;
+----------------+------------+---------+----------------+------------+
| updated | counter_id | stat_id | lasthit_ts | lasthit_id |
+----------------+------------+---------+----------------+------------+
| 20010206155808 | 110912 | 35 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 36 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 39 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 42 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 43 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 45 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 46 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 47 | 20010103141348 | 25 |
| 20010206162624 | 110912 | 49 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 101 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 102 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 103 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 104 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 105 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 106 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 107 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 108 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 109 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 110 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 111 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 112 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 113 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 114 | 20010103141348 | 25 |
| 20010206162625 | 110912 | 115 | 20010103141348 | 25 |
| 20010206155808 | 110912 | 116 | 20010103141348 | 25 |
+----------------+------------+---------+----------------+------------+
25 rows in set (0.00 sec)
As you see "where clause" removes 25 records from result,there they
has to be there.
I've done mysqladmin "flush logs" and then copied the .frm and .db
files into other database directory - and the bug was unable to be
repaired.
also I find one of mysql processes hanged - it took 100% of one of the
processors.
I've connected to the process and made BT several times:
0x8137b17 in _mi_get_binary_pack_key (keyinfo=0x0, nod_flag=0, page_pos=0x0, key=0x0)
at mi_search.c:1035
1035 *page_pos= page+length-tmp;
(gdb) 13098 root 13 0 1148 1148 912 R 0 5.8 0.1 0:01 top
Undefined command: "13098". Try "help".
(gdb) 24025 root 1 0 388 192 120 S 0 0.5 0.0 0:05 sshd
Undefined command: "24025". Try "help".
(gdb) quit
The program is running. Quit anyway (and detach it)? (y or n) t
Please answer y or n.
The program is running. Quit anyway (and detach it)? (y or n) y
Detaching from program: /usr/local/mysql/libexec/mysqld, Thread 17446
onyx:/spylog/db # gdb /usr/local/mysql/libexec/mysqld 17446
GNU gdb 4.18
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-suse-linux"...
/spylog/db/17446: No such file or directory.
Attaching to program: /usr/local/mysql/libexec/mysqld, Thread 17446
0x8191653 in memcpy (dstpp=0x7adfd1ec, srcpp=0x3902cc9d, len=7) at
../sysdeps/generic/memcpy.c:61
61 ../sysdeps/generic/memcpy.c: No such file or directory.
(gdb) bt
#0 0x8191653 in memcpy (dstpp=0x7adfd1ec, srcpp=0x3902cc9d, len=7) at
../sysdeps/generic/memcpy.c:61
#1 0x8137b4b in _mi_get_binary_pack_key (keyinfo=0x0, nod_flag=0, page_pos=0x0,
key=0x0) at mi_search.c:1045
#2 0xd4935d10 in ?? ()
Cannot access memory at address 0x816dc600.
(gdb) quit
The program is running. Quit anyway (and detach it)? (y or n) y
Detaching from program: /usr/local/mysql/libexec/mysqld, Thread 17446
onyx:/spylog/db # gdb /usr/local/mysql/libexec/mysqld 17446
GNU gdb 4.18
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-suse-linux"...
/spylog/db/17446: No such file or directory.
Attaching to program: /usr/local/mysql/libexec/mysqld, Thread 17446
memcpy (dstpp=0x7adfd1f0, srcpp=0x7adfcf18, len=8) at ../sysdeps/generic/memcpy.c:55
55 ../sysdeps/generic/memcpy.c: No such file or directory.
(gdb) bt
#0 memcpy (dstpp=0x7adfd1f0, srcpp=0x7adfcf18, len=8) at
../sysdeps/generic/memcpy.c:55
Current language: auto; currently c
(gdb) bt
#0 memcpy (dstpp=0x7adfd1f0, srcpp=0x7adfcf18, len=8) at
../sysdeps/generic/memcpy.c:55
(gdb) quiy
Undefined command: "quiy". Try "help".
(gdb) quit
The program is running. Quit anyway (and detach it)? (y or n) y
Detaching from program: /usr/local/mysql/libexec/mysqld, Thread 17446
onyx:/spylog/db # gdb /usr/local/mysql/libexec/mysqld 17446
GNU gdb 4.18
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-suse-linux"...
/spylog/db/17446: No such file or directory.
Attaching to program: /usr/local/mysql/libexec/mysqld, Thread 17446
0x819164a in memcpy (dstpp=0x7adfd4c0, srcpp=0x7adfd1e8, len=8) at
../sysdeps/generic/memcpy.c:55
55 ../sysdeps/generic/memcpy.c: No such file or directory.
(gdb) bt
#0 0x819164a in memcpy (dstpp=0x7adfd4c0, srcpp=0x7adfd1e8, len=8) at
../sysdeps/generic/memcpy.c:55
#1 0x81391b3 in _mi_seq_search (info=Cannot access memory at address 0x293.
) at mi_search.c:249
Cannot access memory at address 0x3.
(gdb)
I tried to do "n" in GDB but it hanged...
After I've restarted mysqld the problem removed itself
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
