Peter Zaitsev writes:
> 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]
Hi!
Can you send a dump of your table to the directory you already know
too well ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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