Bug 257721 - databases/p5-DBD-mysql: tests fail when OpenSSL package is installed, databases/mysql80-client
Summary: databases/p5-DBD-mysql: tests fail when OpenSSL package is installed, databas...
Status: Closed Overcome By Events
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: amd64 Any
: --- Affects Some People
Assignee: freebsd-perl (Nobody)
URL: https://www.freshports.org/databases/...
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-09 21:02 UTC by cmh
Modified: 2023-10-16 14:56 UTC (History)
2 users (show)

See Also:
bugzilla: maintainer-feedback? (perl)


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description cmh 2021-08-09 21:02:50 UTC
With a plain freebsd install (Freebsd 11 AMI on AWS):

- pkg install openssl
- pkg install mysql80-server
- echo "DEFAULT_VERSIONS+= ssl=openssl"  >> /etc/make.conf
- portsnap fetch extract
- cd /usr/ports/databases/p5-DBD-mysql
- make test (accepting all default options)

issue:
- test fails (t/10connect.t - SEGV)
- (note t/rt85919-fetch-lost-connection.t also fails, but this appears to be an unrelated upstream issue: https://github.com/perl5-dbi/DBD-mysql/issues/329)


result:

t/00base.t .............................. 1/6 # Driver version is 4.050
t/00base.t .............................. ok   
t/05dbcreate.t .......................... 1/2 # Database 'test' accessible
t/05dbcreate.t .......................... ok   
t/10connect.t ........................... 1/? # mysql_clientinfo is: 8.0.25
# mysql_clientversion is: 80025
# mysql_serverversion is: 80025
# mysql_hostinfo is: Localhost via UNIX socket
# mysql_serverinfo is: 8.0.25
# mysql_stat is: Uptime: 243  Threads: 2  Questions: 13  Slow queries: 0  Opens: 152  Flush tables: 3  Open tables: 68  Queries per second avg: 0.053
# mysql_protoinfo is: 10
# SQL_DBMS_VER is 8.0.25
# Default storage engine is: InnoDB
t/10connect.t ........................... All 12 subtests passed 
t/15reconnect.t ......................... ok     
t/16dbi-get_info.t ...................... ok   
t/20createdrop.t ........................ ok   
t/25lockunlock.t ........................ ok     
t/29warnings.t .......................... ok     
t/30insertfetch.t ....................... ok    
t/31insertid.t .......................... ok     
t/32insert_error.t ...................... ok   
t/35limit.t ............................. ok       
t/35prepare.t ........................... ok     
t/40bindparam.t ......................... ok     
t/40bindparam2.t ........................ ok     
t/40bit.t ............................... ok     
t/40blobs.t ............................. ok     
t/40catalog.t ........................... ok     
t/40keyinfo.t ........................... ok   
t/40listfields.t ........................ ok     
t/40nulls.t ............................. ok     
t/40nulls_prepare.t ..................... ok    
t/40numrows.t ........................... ok     
t/40server_prepare.t .................... ok     
t/40server_prepare_crash.t .............. ok     
t/40server_prepare_error.t .............. ok   
t/40types.t ............................. ok     
t/41bindparam.t ......................... ok     
t/41blobs_prepare.t ..................... ok     
t/41int_min_max.t ....................... ok       
t/42bindparam.t ......................... ok     
t/43count_params.t ...................... ok     
t/50chopblanks.t ........................ ok     
t/50commit.t ............................ ok     
t/51bind_type_guessing.t ................ ok     
t/52comment.t ........................... ok     
t/53comment.t ........................... ok    
t/55utf8.t .............................. ok     
t/55utf8mb4.t ........................... ok   
t/56connattr.t .......................... skipped: no permission on performance_schema tables
t/60leaks.t ............................. skipped: Skip $ENV{EXTENDED_TESTING} is not set
t/65segfault.t .......................... ok   
t/65types.t ............................. ok     
t/70takeimp.t ........................... ok     
t/71impdata.t ........................... ok     
t/75supported_sql.t ..................... ok     
t/76multi_statement.t ................... ok     
t/80procs.t ............................. ok     
t/81procs.t ............................. ok     
t/85init_command.t ...................... ok   
t/86_bug_36972.t ........................ ok     
t/87async.t ............................. ok     
t/88async-multi-stmts.t ................. ok   
t/89async-method-check.t ................ ok       
t/91errcheck.t .......................... ok   
t/92ssl_backronym_vulnerability.t ....... skipped: Server supports SSL connections, cannot test false-positive enforcement
t/92ssl_optional.t ...................... skipped: Server supports SSL connections, cannot test fallback to plain text
t/92ssl_riddle_vulnerability.t .......... skipped: Server supports SSL connections, cannot test false-positive enforcement
t/99_bug_server_prepare_blob_null.t ..... ok     
t/manifest.t ............................ skipped: these tests are for release testing
t/pod.t ................................. skipped: Test::Pod 1.00 required for testing POD
t/rt110983-valid-mysqlfd.t .............. ok   
t/rt118977-zerofill.t ................... ok   
t/rt25389-bin-case.t .................... ok   
t/rt50304-column_info_parentheses.t ..... ok    
t/rt61849-bind-param-buffer-overflow.t .. ok   
t/rt75353-innodb-lock-timeout.t ......... ok   
t/rt83494-quotes-comments.t ............. ok   
t/rt85919-fetch-lost-connection.t ....... 2/? 
#   Failed test 'Should return error 2006 or 2013'
#   at t/rt85919-fetch-lost-connection.t line 47.
# Looks like you failed 1 test of 3.
t/rt85919-fetch-lost-connection.t ....... Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/3 subtests 
t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING} is not set
t/rt88006-bit-prepare.t ................. ok    
t/rt91715.t ............................. ok   
t/version.t ............................. ok   

Test Summary Report
-------------------
t/10connect.t                         (Wstat: 139 Tests: 12 Failed: 0)
  Non-zero wait status: 139
  Parse errors: No plan found in TAP output
t/rt85919-fetch-lost-connection.t     (Wstat: 256 Tests: 3 Failed: 1)
  Failed test:  3
  Non-zero exit status: 1
Files=73, Tests=2301, 45 wallclock secs ( 0.48 usr  0.23 sys +  6.79 cusr  1.73 csys =  9.23 CPU)
Result: FAIL
Failed 2/73 test programs. 1/2301 subtests failed.
*** Error code 255
Comment 1 Jochen Neumeister freebsd_committer freebsd_triage 2023-10-16 05:49:39 UTC
is this still relevant?
Comment 2 cmh 2023-10-16 12:44:34 UTC
I no longer have system to reproduce this issue. On FBSD 13 with the new default mysql version and building with synth this no longer reproduces.