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
Triage: D5 (Feature request)

[1 Jun 2006 10:08] cerber xx
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 ----
[1 Jun 2006 10:11] cerber xx
Patch for the unixware 7 port

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

[1 Jun 2006 10:11] cerber xx
Mysql tests output

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

[26 Jul 2006 15:00] Bugs System
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
[26 Jul 2006 15:02] Magnus Blåudd
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?
[2 Aug 2006 16:24] cerber xx
I will open a new bugs for this issue. More information when it will be done ^^

Many Regards.
[3 Aug 2006 13:05] Magnus Blåudd
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...
[3 Aug 2006 15:29] Bugs System
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!
[17 Aug 2006 16:23] Chad MILLER
Available in 5.0.25 and soon in 5.1.12-beta.
[30 Aug 2006 19:34] Paul Dubois
Noted in 5.0.25, 5.1.12 changelogs.