MySQL Bugs: #30329: main.information_schema

Bug #30329	main.information_schema_chmod test
Submitted:	9 Aug 2007 12:25	Modified:	19 Nov 2007 5:48
Reporter:	Jonathan Perkin
Status:	Closed
Category:	libmysqld	Severity:	S2 (Serious)
Version:	5.2.5-alpha	OS:	Any
Assigned to:	Alexey Botchkov	Target Version:
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.