[MacPorts] #73977: p5-dbd-mariadb fails testing because of default initialisation of MariaDB
MacPorts
noreply at macports.org
Wed May 6 13:24:52 UTC 2026
#73977: p5-dbd-mariadb fails testing because of default initialisation of MariaDB
-----------------------------+--------------------
Reporter: ballapete | Owner: (none)
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version: 2.12.5
Resolution: | Keywords:
Port: p5-dbd-mariadb |
-----------------------------+--------------------
Comment (by ballapete):
The db log file contains:
{{{
2026-05-06 14:25:56 0 [Note] Starting MariaDB 10.11.13-MariaDB source
revision 8fb09426b98583916ccfd4f8c49741adc115bac3 server_uid
9oNSHNQyuXuFiJZiKuhKfWlJVTQ= as process 36043
2026-05-06 14:25:56 0 [Note] InnoDB: Compressed tables use zlib 1.3.2
2026-05-06 14:25:56 0 [Note] InnoDB: Number of transaction pools: 1
2026-05-06 14:25:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2026-05-06 14:25:56 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m,
innodb_buffer_pool_size=128m
2026-05-06 14:25:56 0 [Note] InnoDB: Completed initialization of buffer
pool
2026-05-06 14:25:56 0 [Note] InnoDB: End of log at LSN=46846
2026-05-06 14:25:56 0 [Note] InnoDB: 128 rollback segments are active.
2026-05-06 14:25:56 0 [Note] InnoDB: Setting file './ibtmp1' size to
12.000MiB. Physically writing the file full; Please wait ...
2026-05-06 14:25:56 0 [Note] InnoDB: File './ibtmp1' size is now
12.000MiB.
2026-05-06 14:25:56 0 [Note] InnoDB: log sequence number 46846;
transaction id 14
2026-05-06 14:25:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2026-05-06 14:25:56 0 [Note] InnoDB: Loading buffer pool(s) from
/opt/local/var/db/mariadb-10.11/ib_buffer_pool
2026-05-06 14:25:56 0 [Note] InnoDB: Buffer pool(s) load completed at
260506 14:25:56
2026-05-06 14:25:57 0 [Note] /opt/local/lib/mariadb-10.11/bin/mysqld:
ready for connections.
Version: '10.11.13-MariaDB' socket:
'/opt/local/var/run/mariadb-10.11/mysqld.sock' port: 0 Source
distribution
2026-05-06 14:26:09 5 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 14:26:09 6 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 14:26:34 11 [Warning] Aborted connection 11 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 14:26:37 22 [Warning] Aborted connection 22 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 14:26:38 25 [Warning] Aborted connection 25 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 14:26:43 28 [Warning] Aborted connection 28 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 14:26:44 31 [Warning] Aborted connection 31 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 14:26:49 35 [Warning] Aborted connection 35 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 14:27:18 97 [Warning] Aborted connection 97 to db: 'test' user:
'root' host: 'localhost' (Got an error writing communication packets)
2026-05-06 14:27:20 117 [Warning] Aborted connection 117 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:27:20 118 [Warning] Aborted connection 118 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:27:20 124 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 14:27:20 125 [Warning] Aborted connection 125 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:27:20 126 [Warning] Aborted connection 126 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:28:34 144 [Warning] Aborted connection 144 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:28:34 147 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 14:29:01 203 [Warning] Aborted connection 203 to db: 'test'
user: 'root' host: 'localhost' (Got an error reading communication
packets)
2026-05-06 14:29:21 219 [Warning] Aborted connection 219 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:29:21 220 [Warning] Aborted connection 220 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:29:21 225 [Warning] Aborted connection 225 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:29:21 226 [Warning] Aborted connection 226 to db:
'unconnected' user: 'unauthenticated' host: 'localhost' (This connection
closed normally without authentication)
2026-05-06 14:29:30 237 [Warning] Aborted connection 237 to db: 'test'
user: 'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 14:35:48 0 [Note] /opt/local/lib/mariadb-10.11/bin/mysqld
(initiated by: unknown): Normal shutdown
2026-05-06 14:35:48 0 [Note] InnoDB: FTS optimize thread exiting.
2026-05-06 14:35:48 0 [Note] InnoDB: Starting shutdown...
2026-05-06 14:35:48 0 [Note] InnoDB: Dumping buffer pool(s) to
/opt/local/var/db/mariadb-10.11/ib_buffer_pool
2026-05-06 14:35:48 0 [Note] InnoDB: Buffer pool(s) dump completed at
260506 14:35:48
2026-05-06 14:35:48 0 [Note] InnoDB: Removed temporary tablespace data
file: "./ibtmp1"
2026-05-06 14:35:48 0 [Note] InnoDB: Shutdown completed; log sequence
number 1406127; transaction id 1694
2026-05-06 14:35:48 0 [Note] /opt/local/lib/mariadb-10.11/bin/mysqld:
Shutdown complete
}}}
Initialising the db with
{{{
sudo -u _mysql /opt/local/lib/mariadb-11.4/bin/mariadb-install-db --auth-
root-authentication-method=normal
}}}
testing looks different:
{{{
---> Testing p5.34-dbd-mariadb
Executing: cd "/opt/local/var/macports/build/p5.34-dbd-mariadb-
3cbed0d0/work/DBD-MariaDB-1.24" && /usr/bin/make test
"/opt/local/bin/perl5.34" -MExtUtils::Command::MM -e 'cp_nonempty' --
MariaDB.bs blib/arch/auto/DBD/MariaDB/MariaDB.bs 644
PERL_DL_NONLAZY=1 "/opt/local/bin/perl5.34" "-MExtUtils::Command::MM"
"-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
# Perl version is v5.34.3
# DBI version is 1.647
# Driver version is 1.24
t/00base.t .............................. ok
# Connected to 'test' database on
'DBI:MariaDB:test;mariadb_connect_timeout=120;mariadb_read_timeout=120;mariadb_write_timeout=120'
server
# Database 'test' has charset 'latin1'
# Changed charset for 'test' database to 'utf8mb4'
# Database 'test' has collation 'utf8mb4_general_ci'
# Changed collation for 'test' database to 'utf8mb4_unicode_ci'
t/05dbcreate.t .......................... ok
# mariadb_clientinfo is: 3.4.6
# mariadb_clientversion is: 110407
# mariadb_serverversion is: 110407
# mariadb_hostinfo is: Localhost via UNIX socket
# mariadb_serverinfo is: 11.4.7-MariaDB
# mariadb_stat is: Uptime: 61 Threads: 1 Questions: 16 Slow queries: 0
Opens: 17 Open tables: 10 Queries per second avg: 0.262
# mariadb_protoinfo is: 10
# SQL_DBMS_NAME is MariaDB
# SQL_DBMS_VER is 11.04.0700
# SQL_SERVER_NAME is Localhost via UNIX socket
# SQL_DRIVER_VER is 01.24.0000
# Default storage engine is: InnoDB
# @@character_set_client is: utf8mb4
# @@character_set_connection is: utf8mb4
# @@character_set_database is: utf8mb4
# @@character_set_results is: utf8mb4
# @@character_set_server is: utf8mb4
# @@collation_connection is: utf8mb4_unicode_ci
# @@collation_database is: utf8mb4_unicode_ci
# @@collation_server is: utf8mb4_unicode_ci
# auto_reconnects_failed is: 0
# auto_reconnects_ok is: 0
t/10connect.t ........................... ok
t/60leaks.t ............................. skipped: Skip
$ENV{EXTENDED_TESTING} is not set
t/87async.t ............................. ok
t/rt75353-innodb-lock-timeout.t ......... ok
t/rt85919-fetch-lost-connection.t ....... ok
t/11data_sources.t ...................... ok
t/12embedded.t .......................... skipped: Connection error:
Embedded server is not supported
t/13disconnect.t ........................ ok
t/14destruct.t .......................... ok
t/15reconnect.t ......................... ok
t/16dbi-get_info.t ...................... ok
t/17close_on_exec.t ..................... ok
t/18begin_work_without_raise_error.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/40blobslarge.t ........................ ok
t/40catalog.t ........................... ok
t/40invalid_attributes.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/40sth_attr.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/44call_placeholder.t .................. ok
t/44limit_placeholder.t ................. ok
t/45bind_no_backslash_escapes.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/55unicode.t ........................... ok
t/55utf8.t .............................. ok
t/55utf8_jp.t ........................... ok
t/55utf8mb4.t ........................... ok
t/56connattr.t .......................... skipped: performance schema not
enabled
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/77max_allowed_packet.t ................ ok
t/78use_result.t ........................ ok
t/80procs.t ............................. ok
t/81procs.t ............................. ok
t/85init_command.t ...................... ok
t/86_bug_36972.t ........................ ok
t/88async-multi-stmts.t ................. ok
t/89async-method-check.t ................ ok
t/90utf8_params.t ....................... ok
t/91errcheck.t .......................... ok
t/92ssl_backronym_vulnerability.t ....... skipped: Server supports SSL
connections, cannot test false-positive enforcement
# mariadb_ssl_cipher is: TLS_AES_256_GCM_SHA384
t/92ssl_connection.t .................... ok
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/93net_ssleay.t ........................ ok
t/99_bug_server_prepare_blob_null.t ..... ok
t/cve-2017-3302.t ....................... ok
t/magic.t ............................... ok
t/manifest.t ............................ skipped: these tests are for
release testing
t/pod.t ................................. ok
t/rt110983-valid-mysqlfd.t .............. ok
t/rt118977-zerofill.t ................... ok
t/rt122541-decimals.t ................... ok
t/rt25389-bin-case.t .................... ok
t/rt50304-column_info_parentheses.t ..... ok
t/rt61849-bind-param-buffer-overflow.t .. ok
t/rt83494-quotes-comments.t ............. ok
t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING}
is not set
t/rt88006-bit-prepare.t ................. ok
t/rt91715.t ............................. ok
All tests successful.
Files=94, Tests=4140, 74 wallclock secs ( 0.53 usr 0.20 sys + 10.00 cusr
2.00 csys = 12.73 CPU)
Result: PASS
}}}
Db log file now contains:
{{{
2026-05-06 15:19:46 0 [Note] Starting MariaDB 11.4.7-MariaDB source
revision 118cfcf82107188f2295631193658b2ef94f4f3f server_uid
9oNSHNQyuXuFiJZiKuhKfWlJVTQ= as process 41585
2026-05-06 15:19:46 0 [Note] InnoDB: Compressed tables use zlib 1.3.2
2026-05-06 15:19:46 0 [Note] InnoDB: Number of transaction pools: 1
2026-05-06 15:19:46 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2026-05-06 15:19:46 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m,
innodb_buffer_pool_size=128m
2026-05-06 15:19:46 0 [Note] InnoDB: Completed initialization of buffer
pool
2026-05-06 15:19:46 0 [Note] InnoDB: End of log at LSN=47629
2026-05-06 15:19:46 0 [Note] InnoDB: Opened 3 undo tablespaces
2026-05-06 15:19:46 0 [Note] InnoDB: 128 rollback segments in 3 undo
tablespaces are active.
2026-05-06 15:19:46 0 [Note] InnoDB: Setting file './ibtmp1' size to
12.000MiB. Physically writing the file full; Please wait ...
2026-05-06 15:19:46 0 [Note] InnoDB: File './ibtmp1' size is now
12.000MiB.
2026-05-06 15:19:46 0 [Note] InnoDB: log sequence number 47629;
transaction id 14
2026-05-06 15:19:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2026-05-06 15:19:46 0 [Note] InnoDB: Loading buffer pool(s) from
/opt/local/var/db/mariadb-11.4/ib_buffer_pool
2026-05-06 15:19:46 0 [Note] Plugin 'wsrep-provider' is disabled.
2026-05-06 15:19:46 0 [Note] InnoDB: Buffer pool(s) load completed at
260506 15:19:46
2026-05-06 15:19:47 0 [Note] mysqld: Event Scheduler: Loaded 0 events
2026-05-06 15:19:47 0 [Note] /opt/local/lib/mariadb-11.4/bin/mysqld: ready
for connections.
Version: '11.4.7-MariaDB' socket:
'/opt/local/var/run/mariadb-11.4/mysqld.sock' port: 0 Source
distribution
2026-05-06 15:20:47 5 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 15:20:47 6 [Warning] Access denied for user
'4yZ73s9qeECdWi'@'localhost' (using password: YES)
2026-05-06 15:21:12 11 [Warning] Aborted connection 11 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 15:21:15 22 [Warning] Aborted connection 22 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 15:21:16 25 [Warning] Aborted connection 25 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 15:21:21 28 [Warning] Aborted connection 28 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 15:21:22 31 [Warning] Aborted connection 31 to db: 'test' user:
'root' host: 'localhost' (Got timeout reading communication packets)
2026-05-06 15:21:27 35 [Warning] Aborted connection 35 to db: 'test' user:
'root' host: 'localhost' (Got an error reading communication packets)
2026-05-06 15:21:55 97 [Warning] Aborted connection 97 to db: 'test' user:
'root' host: 'localhost' (Got an error writing communication packets)
2026-05-06 15:23:55 0 [Note] /opt/local/lib/mariadb-11.4/bin/mysqld
(initiated by: unknown): Normal shutdown
2026-05-06 15:23:55 0 [Note] InnoDB: FTS optimize thread exiting.
2026-05-06 15:23:55 0 [Note] InnoDB: Starting shutdown...
2026-05-06 15:23:55 0 [Note] InnoDB: Dumping buffer pool(s) to
/opt/local/var/db/mariadb-11.4/ib_buffer_pool
2026-05-06 15:23:55 0 [Note] InnoDB: Buffer pool(s) dump completed at
260506 15:23:55
2026-05-06 15:23:56 0 [Note] InnoDB: Removed temporary tablespace data
file: "./ibtmp1"
2026-05-06 15:23:56 0 [Note] InnoDB: Shutdown completed; log sequence
number 929912; transaction id 873
2026-05-06 15:23:56 0 [Note] /opt/local/lib/mariadb-11.4/bin/mysqld:
Shutdown complete
}}}
--
Ticket URL: <https://trac.macports.org/ticket/73977#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list