select * from <table> without where clause does not show all rows in the table

[Nikolay Mihaylov]

This bug is similar to #340314, but is different.

At the time of the test, I made high load on the linux machine (copy some files) and made two concurrent connections on the MariaDB. I did not used transactions (BEGIN / COMMIT), but I also did not changed default isolation level. I can provide the table files and log, just tell me what files you want.

MariaDB [test]> select version();
+--------------------+
| version() |
+--------------------+
| 5.1.47-MariaDB-log |
+--------------------+
1 row in set (0.00 sec)

MariaDB [test]> create table b (a int primary key) engine=pbxt;
Query OK, 0 rows affected (3 min 43.59 sec)

MariaDB [test]> insert into b values(1);
Query OK, 1 row affected (8.08 sec)

MariaDB [test]> insert into b values(2);
Query OK, 1 row affected (8.08 sec)

MariaDB [test]> insert into b values(3);
Query OK, 1 row affected (1 min 21.43 sec)

MariaDB [test]> select * from b;
+---+
| a |
+---+
| 1 |
| 2 | <==== where is 3 ???
+---+
2 rows in set (0.00 sec)

MariaDB [test]> insert into b values(3);
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'

MariaDB [test]> select * from b where a = 3;
+---+
| a |
+---+
| 3 |
+---+
1 row in set (0.10 sec)

MariaDB [test]> select * from b order by a;
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)

MariaDB [test]> select * from b where 1;
+---+
| a |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)

[Paul McCullagh (paul-mccullagh)]

Hi Nikolay,

Thanks for the bug report. So far I have not been able to repeat the error.

I was wondering if:

1. You still have the database with this error?

2. You are able to repeat the error with an empty database?

Thanks for you help!

[Nikolay Mihaylov (nmmm)]

Hi,
I still have the data, raw dump is here:

74.55.155.154/root/x.tar.gz

I dont want to replicate because it may "break" the bug, but also when the bug happen, the server was on high load (made on purpose from me).

I can provide you root access on the machine if this can help you too.

[Paul McCullagh (paul-mccullagh)]

Hi Nikolay,

I cannot repeat the error with the copy of the database. This is probably because there is nothing wrong with the disk image of the database is OK.

So the reason for SELECT * not working appears to be the runtime state of the server. Possibly a memory overwrite.

It may indeed help if I had access to your machine, and could take a look directly.

Please contact me via e-mail, in this regard. My e-mail address is paul dot mccullagh at primebase dot org. Please put PBXT in the subject to avoid my spam filter.

Thanks!