MySQL Bugs: #30329: main.information_schema

Bug #30329	main.information_schema_chmod test
Submitted:	9 Aug 2007 10:25	Modified:	19 Nov 2007 4:48
Reporter:	Jonathan Perkin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Embedded Library ( libmysqld )	Severity:	S2 (Serious)
Version:	5.2.5-alpha	OS:	Any
Assigned to:	Alexey Botchkov	CPU Architecture:	Any
Tags:	Contribution

Description:
The main.information_schema_chmod test attempts to change the permissions on the mysqltest directory, but the command to restore sane permissions fails.  This causes failure for every single subsequent test which is unable to use the test directory.

main.information_schema_chmod  [ fail ]

ERROR: mysqltest returned unexpected code 139, it has probably crashed

Stopping All Servers
Restoring snapshot of databases
Can't chdir to .../mysql-test/var/master-data/mysqltest (Permission denied) at ./mysql-test-run.pl line 3615

d---------  2 mysqldev users 4096 2007-08-02 04:11 mysqltest

How to repeat:
Run the test suite (mysql-test-run.pl)

Suggested fix:
===== information_schema_chmod.test 1.3 vs edited =====
--- 1.3/mysql-test/t/information_schema_chmod.test      2007-08-09 12:23:58 +02:00
+++ edited/information_schema_chmod.test        2007-08-09 12:23:49 +02:00
@@ -19,5 +19,5 @@ create database mysqltest;
 create table mysqltest.t1(a int);
 chmod 0000 $MYSQLTEST_VARDIR/master-data/mysqltest;
 select table_schema from information_schema.tables where table_schema='mysqltest';
-exec chmod 0777 $MYSQLTEST_VARDIR/master-data/mysqltest;
+chmod 0777 $MYSQLTEST_VARDIR/master-data/mysqltest;
 drop database mysqltest;

Thank you for the report.

I can not repeat described behaviour as regular user I guild sources as. Please indicate accurate version of OS where bug is repeatable and provide ouptut of `ls -la /PATH/TO/SOURCES/mysql-test`

s/guild/build/ in previous comment

Sorry, looks like this one is a red herring, the real problem is mysqltest_embedded segfaults on Linux 64bit and PPC machines, which is what causes this test to fail mid way through and break the permissions.

I'm currently trying to get more information from a debug build to track down the bug.

Running the following within gdb:

  $ MTR_BUILD_THREAD=auto /usr/bin/perl ./mysql-test-run.pl --comment=embedded --force --timer --embedded-server --skip-rpl --skip-ndbcluster

warning: linux_test_for_tracefork: unexpected result from waitpid (21882, status 0x117f)
[Thread debugging using libthread_db enabled]
[New Thread 182903849120 (LWP 21881)]
[New Thread 1084230000 (LWP 21884)]
mysql_embedded: Table 'general_log' is marked as crashed and should be repaired
[Thread 1084230000 (zombie) exited]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 182903849120 (LWP 21881)]
emb_read_query_result (mysql=0xe53520) at lib_sql.cc:238
238       thd->first_data= res->embedded_info->next;
Current language:  auto; currently c++
(gdb) bt
#0  emb_read_query_result (mysql=0xe53520) at lib_sql.cc:238
#1  0x000000000058eb8a in mysql_read_query_result (mysql=0xe53520)
    at libmysql.c:5209
#2  0x0000000000550fd2 in run_query_normal (cn=0xe53520, command=0xef2480,
    flags=3, query=0xed5080 "show databases", query_len=14, ds=0xe81120,
    ds_warnings=0x7fbfff93e0) at mysqltest.c:5275
#3  0x0000000000551e60 in run_query (cn=0xe53520, command=0xef2480, flags=3)
    at mysqltest.c:5937
#4  0x0000000000552c66 in main (argc=1, argv=0x1) at mysqltest.c:6450

Thank you for the feedback.

Verified as described on regular Linux.

To repeat `./mysql-test-run.pl --embedded-server information_schema_chmod` is enough

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/36007

ChangeSet@1.2616, 2007-10-22 12:01:39+05:00, holyfoot@mysql.com +1 -0
  bug #30329 main.information_schema_chmod test.
  
  the check_grant call was #ifdef-ed inproperly in check_table_access()
  what cause wrong return and crash of the embedded server.

ok to push

Pushed into 6.0.4-alpha

Noted in 6.0.4 changelog.

A table-access check was performed improperly by libmysqld, causing a crash.

Has this been resolved? I am having the same issues on a debian 5.0 64 bit machine.

main.information_schema_chmod            [ fail ]
        Test ended at 2009-12-29 23:21:14

CURRENT_TEST: main.information_schema_chmod
--- /usr/local/Source/MySQL/mysql-5.1.41/mysql-test/r/information_schema_chmod.result	2009-11-04 22:01:14.000000000 +0300
+++ /usr/local/Source/MySQL/mysql-5.1.41/mysql-test/r/information_schema_chmod.reject	2009-12-30 07:21:14.000000000 +0300
@@ -2,4 +2,5 @@
 create table mysqltest.t1(a int);
 select table_schema from information_schema.tables where table_schema='mysqltest';
 table_schema
+mysqltest
 drop database mysqltest;

mysqltest: Result length mismatch

 - saving '/usr/local/Source/MySQL/mysql-5.1.41/mysql-test/var/log/main.information_schema_chmod/' to '/usr/local/Source/MySQL/mysql-5.1.41/mysql-test/var/log/main.information_schema_chmod/'

Only  587  of 920 completed.
mysql-test-run: *** ERROR: Not all tests completed
make: *** [test-ns] Error 1

I'm also having same issue on OS X (10.6.2) machine.