At 11:50 06/02/2001, Peter Zaitsev wrote:
Hi!
I have made the following table on Win2000 machine:
C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.30-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> use test;
Database changed
mysql> create table layers (
-> updated timestamp,
-> counter_id int,
-> stat_id int not null primary key,
-> lasthit_ts timestamp,
-> lasthit_id int) type=BDB;
Query OK, 0 rows affected (0.61 sec)
I have inserted 50 rows with the data you sent. I wasn't able to
repeat your result, see below. I am using 3.23.30 version, but
before I build a server with your same version, Can you send me
your table definition ?. Notice also that I change the name of
the table, because Windows doesn't permit the syntax that you
have used.
mysql> insert into layers values
("20010206155808",110912,116,"20010103141348",2
5);
Query OK, 1 row affected (0.03 sec)
mysql> select * from layers;
+----------------+------------+---------+----------------+------------+
| 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>
mysql> select * from layers where counter_id=110912;
+----------------+------------+---------+----------------+------------+
| 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>
Regards,
Miguel
>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
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development 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
