• autopkgtest in mariadb-connector-python

    From Mechtilde Stehmann@21:1/5 to All on Sun Mar 16 18:00:02 2025
    This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------k0iRrbTMr0pzhoI6gPXqsput
    Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64

    SGVsbG8NCg0KSSdtIGxvb2tpbmcgZm9yIGhlbHAgdG8gZml4IGF1dG9wa2d0ZXN0IG9mIHRo ZSBwYWNrYWdlIA0KbWFyaWFkYi1jb25uZWN0b3ItcHl0aG9uDQoNCklzIGl0IGEgcHJvcGVy IHdheSB0byByZW1vdmUgdGhlIHRlc3Qgd2hpY2ggbmVlZCBhIHJ1bm5pbmcgDQptYXJpYWRi LXNlcnZlciBhdCB0ZXN0IHRpbWU/DQoNClRoYW5rcyBmb3IgYW55IGhla3ANCg0KUmVnYXJk cw0KDQoNCi0tIA0KTWVjaHRpbGRlIFN0ZWhtYW5uDQojIyBQR1AgZW5jcnlwdGlvbiB3ZWxj b21lDQojIyBGMEUzIDdGM0QgQzg3QSA0OTk4IDI4OTkgIDM5RTcgRjI4NyA3QkJBIDE0MUEg QUQ3Rg0KDQo=

    --------------k0iRrbTMr0pzhoI6gPXqsput--

    -----BEGIN PGP SIGNATURE-----

    iQIzBAEBCgAdFiEE8ON/Pch6SZgomTnn8od7uhQarX8FAmfW+nUACgkQ8od7uhQa rX/SCQ/7BmTBAZ+2/fdMWVamxJsJhoTX6EpSiKMZKZU0zs/QC7nAjeYkt/Nfpycf pXZhnMQIRP0KopJFQIjf6NDefJmRNi+8J7aL0lp2yUsbPDscc5ABdWwet+zKwP2M 0nON06IQfVr7K71B9DnnNwZIFp87D5LYz7l9lpDmdPi9JKP8AAt1g3zxgOmsWs9k j3SLvPLcBjx4q5fjj2opEer0V+NKU+a/l2zh6KdfDRWsc4Fvj17pZwsfiLte7O99 JGsSSMYPQTtxpusX19GV621CbOZsluuoprKpxy1fAlg4dt9Hu/aWOn8jApWCWsvk 6TaVHggBa98k6b9QiHN8ACRfGxaeGa6iKAqs1aXgJOBiaW0V5sqY5tueIsxXME/u 98a8UIqxdv63t/ylnDCygyvqoBenWGy3dXbvrFYvAV5TtJwzBRWxZSzTfoRSkFCG 8nineDcUQWVg7kbaVNgQ9ohPDyWeYzDAjUGvj9LWiPBil4GXpZtasdpoFsqW8Uv/ xSYK08mwO1pB/vvUdGgEpRq8ZQCaK/V6HCDxGxj4aVHNnA+wETScoOaIHVElntvy 70B10KlT0xgLWp7iI0Ya3YkG2KYzzbDiQnUTPYL6U47cD56YuKz9rjv63oNQATVA VlrnjHZlzhouaGwyhTiIk06woi/+4dpEQNcQtaMO6I5QhRJzU2o=
    =ObHE
    -----END PGP SIGNATURE-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Carsten Schoenert@21:1/5 to All on Mon Mar 17 18:00:02 2025
    Hello Mechtilde,

    Am 16.03.25 um 18:21 schrieb Mechtilde Stehmann:
    Hello

    I'm looking for help to fix autopkgtest of the package mariadb-connector-python

    can you be a bit more precise what you are dealing with?

    What I can see from the output your MariaDB server can't get started as
    the default port 3306 is already used.

    Salsa CI
    2024-11-26 0:03:58 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-11-26 0:03:58 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
    2024-11-26 0:03:58 0 [ERROR] Do you already have another server running on port: 3306 ?
    2024-11-26 0:03:58 0 [ERROR] Aborting

    Debian CI
    40s 2025-02-24 9:14:17 0 [Note] Plugin 'wsrep-provider' is disabled.
    40s 2025-02-24 9:14:17 0 [Note] InnoDB: Buffer pool(s) load completed at 250224 9:14:17
    40s 2025-02-24 9:14:17 0 [Note] Server socket created on IP: '0.0.0.0'.
    40s 2025-02-24 9:14:17 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
    40s 2025-02-24 9:14:17 0 [ERROR] Do you already have another server running on port: 3306 ?
    40s 2025-02-24 9:14:17 0 [ERROR] Aborting

    Can you use another port in your setup?

    Is it a proper way to remove the test which need a running
    mariadb-server at test time?

    I'd say, that would make the whole testing obsolete for a connector
    package. :-)
    That would be the last option to do.

    --
    Regards
    Carsten

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mechtilde Stehmann@21:1/5 to All on Mon Mar 17 18:20:01 2025
    This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------NsIRoBAN4t8sBDIEBEokk77L
    Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64

    aGVsbG8gQ2Fyc3Rlbg0KDQpBbSAxNy4wMy4yNSB1bSAxNzo1NCBzY2hyaWViIENhcnN0ZW4g U2Nob2VuZXJ0Og0KPiBIZWxsbyBNZWNodGlsZGUsDQo+IA0KPiBBbSAxNi4wMy4yNSB1bSAx ODoyMSBzY2hyaWViIE1lY2h0aWxkZSBTdGVobWFubjoNCj4+IEhlbGxvDQo+Pg0KPj4gSSdt IGxvb2tpbmcgZm9yIGhlbHAgdG8gZml4IGF1dG9wa2d0ZXN0IG9mIHRoZSBwYWNrYWdlDQo+ PiBtYXJpYWRiLWNvbm5lY3Rvci1weXRob24NCj4gDQo+IGNhbiB5b3UgYmUgYSBiaXQgbW9y ZSBwcmVjaXNlIHdoYXQgeW91IGFyZSBkZWFsaW5nIHdpdGg/DQoNCmkgd2FudCB0byBnZXQg dGhpcyBwYWNrYWdlIGludG8gdGhlIG5leHQgc3RhYmxlIHJlbGVhc2UuDQo+IA0KPiBXaGF0 IEkgY2FuIHNlZSBmcm9tIHRoZSBvdXRwdXQgeW91ciBNYXJpYURCIHNlcnZlciBjYW4ndCBn ZXQgc3RhcnRlZCBhcyANCj4gdGhlIGRlZmF1bHQgcG9ydCAzMzA2IGlzIGFscmVhZHkgdXNl ZC4NCj4gDQo+IFNhbHNhIENJDQo+PiAyMDI0LTExLTI2wqAgMDowMzo1OCAwIFtOb3RlXSBT ZXJ2ZXIgc29ja2V0IGNyZWF0ZWQgb24gSVA6ICcwLjAuMC4wJy4NCj4+IDIwMjQtMTEtMjbC oCAwOjAzOjU4IDAgW0VSUk9SXSBDYW4ndCBzdGFydCBzZXJ2ZXI6IEJpbmQgb24gVENQL0lQ IHBvcnQuIA0KPj4gR290IGVycm9yOiA5ODogQWRkcmVzcyBhbHJlYWR5IGluIHVzZQ0KPj4g MjAyNC0xMS0yNsKgIDA6MDM6NTggMCBbRVJST1JdIERvIHlvdSBhbHJlYWR5IGhhdmUgYW5v dGhlciBzZXJ2ZXIgDQo+PiBydW5uaW5nIG9uIHBvcnQ6IDMzMDYgPw0KPj4gMjAyNC0xMS0y NsKgIDA6MDM6NTggMCBbRVJST1JdIEFib3J0aW5nDQo+IA0KPiBEZWJpYW4gQ0kNCj4+IMKg NDBzIDIwMjUtMDItMjTCoCA5OjE0OjE3IDAgW05vdGVdIFBsdWdpbiAnd3NyZXAtcHJvdmlk ZXInIGlzIGRpc2FibGVkLg0KPj4gwqA0MHMgMjAyNS0wMi0yNMKgIDk6MTQ6MTcgMCBbTm90 ZV0gSW5ub0RCOiBCdWZmZXIgcG9vbChzKSBsb2FkIA0KPj4gY29tcGxldGVkIGF0IDI1MDIy NMKgIDk6MTQ6MTcNCj4+IMKgNDBzIDIwMjUtMDItMjTCoCA5OjE0OjE3IDAgW05vdGVdIFNl cnZlciBzb2NrZXQgY3JlYXRlZCBvbiBJUDogJzAuMC4wLjAnLg0KPj4gwqA0MHMgMjAyNS0w Mi0yNMKgIDk6MTQ6MTcgMCBbRVJST1JdIENhbid0IHN0YXJ0IHNlcnZlcjogQmluZCBvbiBU Q1AvSVAgDQo+PiBwb3J0LiBHb3QgZXJyb3I6IDk4OiBBZGRyZXNzIGFscmVhZHkgaW4gdXNl DQo+PiDCoDQwcyAyMDI1LTAyLTI0wqAgOToxNDoxNyAwIFtFUlJPUl0gRG8geW91IGFscmVh ZHkgaGF2ZSBhbm90aGVyIHNlcnZlciANCj4+IHJ1bm5pbmcgb24gcG9ydDogMzMwNiA/DQo+ PiDCoDQwcyAyMDI1LTAyLTI0wqAgOToxNDoxNyAwIFtFUlJPUl0gQWJvcnRpbmcNCj4gDQo+ IENhbiB5b3UgdXNlIGFub3RoZXIgcG9ydCBpbiB5b3VyIHNldHVwPw0KDQpJIGhhdmUgbm8g aWRlYSBhYm91dCB0aGUgc2V0dXAgY29uZmlndXJhdGlvbi4gSSBkaWRuJ3QgYW55IGNvZGUg cmV2aWV3Lg0KPiANCj4+IElzIGl0IGEgcHJvcGVyIHdheSB0byByZW1vdmUgdGhlIHRlc3Qg d2hpY2ggbmVlZCBhIHJ1bm5pbmcNCj4+IG1hcmlhZGItc2VydmVyIGF0IHRlc3QgdGltZT8N Cj4gDQo+IEknZCBzYXksIHRoYXQgd291bGQgbWFrZSB0aGUgd2hvbGUgdGVzdGluZyBvYnNv bGV0ZSBmb3IgYSBjb25uZWN0b3IgDQo+IHBhY2thZ2UuIDotKQ0KPiBUaGF0IHdvdWxkIGJl IHRoZSBsYXN0IG9wdGlvbiB0byBkby4NCg0KS2luZCByZWdhcmRzDQoNCg0KLS0gDQpNZWNo dGlsZGUgU3RlaG1hbm4NCiMjIERlYmlhbiBEZXZlbG9wZXINCiMjIFBHUCBlbmNyeXB0aW9u IHdlbGNvbWUNCiMjIEYwRTMgN0YzRCBDODdBIDQ5OTggMjg5OSAgMzlFNyBGMjg3IDdCQkEg MTQxQSBBRDdGDQoNCg==

    --------------NsIRoBAN4t8sBDIEBEokk77L--

    -----BEGIN PGP SIGNATURE-----

    iQIzBAEBCgAdFiEE8ON/Pch6SZgomTnn8od7uhQarX8FAmfYWM0ACgkQ8od7uhQa rX9cixAApA2dgv+PBcgy7z+pppK2mzoKLsiB/TTg6S5/+zx0EwL22AcPUY4jNiYh 23wW0WoeyZyIYHpI2i549sSd75crXZ1d+5srCE05TkykmaVc9/kNAqNpqi/kf67B YlK8LVDETNkKL+u/bIKeefAsCs66Mdr1U087gKW39QADYU2pqkhWXVOdkNwNskqH PTMFLSzHlO3gbO6lvhAAclgP/S+FnPMpwSV/PNYOZe9bCtGGikwKVFyxo7peT1ER dKzTJovFVs5iMqCcnO5JSy+f5gGsG6pNl8RCd/HIrN5AGXZlRwj/T+4MRTuGhx4Y lo2NBPQkNDD9YLvUn+ps1VTN92AYrqHl5lVRxeJtX9LpDJ9sSZ8znGe5JjEfFV2v Un3hq32u+4jGT7YBg/pLO/Z51DODpJCrHRqX+jGVU8UEUjpYto/bUbk2RrmhHK3Q uVB065Hw0miBl9YNfvORlnRIuZ/ghqKQlLsMXzBXbp7TkLW/7cF2YhDO72+FXsbi s11UJS8CwDDBG7ARUuby0Gxqz5EVmtT8GpMkmjIiPkxi1M8xv7HJRwYfNkoXN92F VrFxgEL8JNTayK5HoeeGEBbNdkkPIoNOD8gsP0oaJACjEGV1GLxhwg4f4SXS0piB He1DCaZwVzTn1JoQI4rJjv0EiDnDw8uNqkpAshKFVB8rhW/F8bE=
    =WktR
    -----END PGP SIGNATURE-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Carsten Schoenert@21:1/5 to All on Fri Mar 21 08:40:01 2025
    Hello Mechtilde,

    I had a rather quick look into the details of the failing test.

    Am 17.03.25 um 19:15 schrieb Mechtilde Stehmann:

    Debian CI
     40s 2025-02-24  9:14:17 0 [Note] Plugin 'wsrep-provider' is disabled. >>>  40s 2025-02-24  9:14:17 0 [Note] InnoDB: Buffer pool(s) load
    completed at 250224  9:14:17
     40s 2025-02-24  9:14:17 0 [Note] Server socket created on IP: '0.0.0.0'.
     40s 2025-02-24  9:14:17 0 [ERROR] Can't start server: Bind on TCP/IP >>> port. Got error: 98: Address already in use
     40s 2025-02-24  9:14:17 0 [ERROR] Do you already have another server >>> running on port: 3306 ?
     40s 2025-02-24  9:14:17 0 [ERROR] Aborting

    Can you use another port in your setup?

    I have no idea about the setup configuration. I didn't any code review.

    I'm getting the test running if I simply set a dedicated port as
    obviously on the default port 3306 is already some other process is running.

    --- a/debian/tests/setup
    +++ b/debian/tests/setup
    @@ -5,7 +5,7 @@ set -ex

    /usr/bin/mariadb-install-db --no-defaults --datadir=${MARIADB_DIR} --force --skip-name-resolve --explicit_defaults_for_timestamp 2>&1

    -/usr/sbin/mysqld --no-defaults --user=${MARIADB_USER} --socket=${MARIADB_UNIX_PORT} --datadir=${MARIADB_DIR} --pid-file=${MARIADB_PIDFILE} --explicit_defaults_for_timestamp 2>&1 &
    +/usr/sbin/mysqld --no-defaults --user=${MARIADB_USER} --socket=${MARIADB_UNIX_PORT} -P 10010 --datadir=${MARIADB_DIR} --pid-file=${MARIADB_PIDFILE} --explicit_defaults_for_timestamp 2>&1 &

    attempts=0
    while ! /usr/bin/mariadb-admin --user=${MARIADB_USER} --socket=${MARIADB_UNIX_PORT} ping 2>&1 ; do

    So I think adding some "-P xxxxx" argument to the mysqld start should do
    the trick. Maybe it can be done a bit more elegant than hard code it
    into d/t/setup.
    Also you could also add a check before to test if port 3306 is used and
    the -P option is needed.

    --
    Regards
    Carsten

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)