MySQL Bugs: #20190: Unixware 7.13 port and make test errors

Bug #20190	Unixware 7.13 port and make test errors
Submitted:	1 Jun 2006 10:08	Modified:	30 Aug 2006 19:34
Reporter:	cerber xx	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0.22	OS:	Unixware 7.13
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
Hello mysql team,

I would like to compile and install a mysql 5.0.x last stable version (5.0.22) on a Unixware 7.13 (and 7.14 too) box.

Until now, this version support SCO openserver but nothing for Unixware 7. 
I don't know if you plan a port for unixware 7 in the future, but the job is not a big issue. 
I made a small patch which modify only one file (see the "Suggested fix" section).

But, there is several problems when I launch test (see the "How to repeat" section).

Platform information:

uname -a: UnixWare uxw713 5 7.1.3 i386 x86at SCO UNIX_SVR5

This my firs bug reports, so if something is wrong, don't hesitate to tell me.

Keep me informed if is there any update on this issue.

Best Regards.

How to repeat:
Just type "make test" and wait from crash.

You should see the following error (witn mysql compiled in debug mode):

[snip]

rpl_deadlock                   [ fail ]

Errors are (from /dbs/32bits/mys/tmp/mysql-5.0.22/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 62: query 'insert into t2 values(22)' failed: 1205: Lock wait timeout exceeded; try restarting transaction
(the last lines may be the most important ones)

Suggested fix:
I have been able to compile MySQL with the following configure command on UnixWare 7.1.3:

CC="cc" CXX="CC" ./configure --prefix=$MYSQLDIR --enable-thread-safe-client --with-berkeley-db=./bdb --with-innodb --with-openssl --with-extra-charsets=complex --with-debug

And the following sources modification:

*** mysql-5.0.22/server-tools/instance-manager/portability.h    Thu May 25 10:56:42 2006
--- mysql-5.0.22-patched/server-tools/instance-manager/portability.h    Wed May 31 16:43:22 2006
***************
*** 1,7 ****
  #ifndef INCLUDES_MYSQL_INSTANCE_MANAGER_PORTABILITY_H
  #define INCLUDES_MYSQL_INSTANCE_MANAGER_PORTABILITY_H

! #if defined(_SCO_DS) && !defined(SHUT_RDWR)
  #define SHUT_RDWR 2
  #endif

--- 1,7 ----
  #ifndef INCLUDES_MYSQL_INSTANCE_MANAGER_PORTABILITY_H
  #define INCLUDES_MYSQL_INSTANCE_MANAGER_PORTABILITY_H

! #if (defined(_SCO_DS) || defined(UNIXWARE_7) ) && !defined(SHUT_RDWR)
  #define SHUT_RDWR 2
  #endif

***************
*** 24,28 ****
  #endif /* __WIN__ */

  #endif  /* INCLUDES_MYSQL_INSTANCE_MANAGER_PORTABILITY_H */
-
-
--- 24,26 ----

Patch for the unixware 7 port

Attachment: mysql-5.0.22-for-unixware7.patch (text/x-patch), 778 bytes.

Mysql tests output

Attachment: mysql-test-run (application/octet-stream, text), 62.81 KiB.

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/9596

Please report the rpl_deadlock problem as a separate bug if you still can repeat it.

Could there possibley be some more place that needs a conditional define for that test case to work?

I will open a new bugs for this issue. More information when it will be done ^^

Many Regards.

SHUT_* functions are defined only if "(defined(_XOPEN_SOURCE) && _XOPEN_SOURCE_EXTENDED - 0 >= 1)"
http://mail-archives.apache.org/mod_mbox/apr-dev/200212.mbox/%3C20021215204303.GA11180@man...

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/10016

ChangeSet@1.2238, 2006-08-03 17:29:35+02:00, msvensson@neptunus.(none) +1 -0
  Bug#20190 Unixware 7.13 port and make test errors
     - Thanks to cerber for the patch!

Available in 5.0.25 and soon in 5.1.12-beta.

Noted in 5.0.25, 5.1.12 changelogs.