Use of uninitialized value $effective_size in DatabaseManager.pm line 712

[Cyrille37]

Version

• Sympa 6.2.40
• Perl 5.30.0
• Ubuntu 20.04 LTS (focal)
• Mysql-server 8.0.26

Installation method

apt install sympa

Actual behavior

Running sympa --health_check throw warnings :

Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.
Use of uninitialized value $effective_size in numeric ge (>=) at /usr/share/sympa/lib/Sympa/DatabaseManager.pm line 712.

[ikedas]

Hi @Cyrille37 ,

• Which RDBMS are you using for Sympa? Please tell the name and the version.
• Can you show the dump of the table structures? E.g.
  • With MySQL: SHOW COLUMNS FROM logs_table;
  • With SQLite: SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'logs_table';
  • and so on.

[Cyrille37]

Hi @ikedas
Sorry, I forgot: Mysql-server 8.0.26

mysql> SHOW COLUMNS FROM logs_table;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| date_logs         | int          | YES  |     | NULL    |       |
| robot_logs        | varchar(80)  | YES  |     | NULL    |       |
| list_logs         | varchar(50)  | YES  |     | NULL    |       |
| action_logs       | varchar(50)  | NO   |     | NULL    |       |
| parameters_logs   | varchar(100) | YES  |     | NULL    |       |
| target_email_logs | varchar(100) | YES  |     | NULL    |       |
| user_email_logs   | varchar(100) | YES  |     | NULL    |       |
| msg_id_logs       | varchar(255) | YES  |     | NULL    |       |
| status_logs       | varchar(10)  | NO   |     | NULL    |       |
| error_type_logs   | varchar(150) | YES  |     | NULL    |       |
| client_logs       | varchar(100) | YES  |     | NULL    |       |
| daemon_logs       | varchar(10)  | NO   |     | NULL    |       |
| usec_logs         | int          | YES  |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+
13 rows in set (0.00 sec)

[ikedas]

@Cyrille37 , can you apply this patch to check if the problem will be solved?

[ikedas]

@Cyrille37 , I'll merge it for now, and it will be included in the next beta in the next week.

[Cyrille37]

Sorry @ikedas I did not get time to test.
Thanks for you patch & merge.
Best regards