Loading...

Type: Story
Resolution: Won't Do
Priority: Major
Fix Version/s: None
Affects Version/s: None
Component/s: backend
Security Level: Public (Visbile by non-authn users.)
Labels:
None

REPORT

On date August 24th 2022 after the upgrade from StoRM 1.11.21 to StoRM 1.11.22.build27 (beta rpm) the BE started failing on restart, printing on .stderr log:

java.sql.SQLException: Zero date value prohibited
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:923)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:968)
at org.apache.commons.dbcp2.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:968)
at it.grid.storm.persistence.util.helper.StorageSpaceSQLHelper.makeStorageSpaceTO(StorageSpaceSQLHelper.java:232)
at it.grid.storm.persistence.impl.mysql.StorageSpaceDAOMySql.getStorageSpaceByAliasOnly(StorageSpaceDAOMySql.java:235)
at it.grid.storm.catalogs.ReservedSpaceCatalog.getSpaceTokensByAlias(ReservedSpaceCatalog.java:470)
at it.grid.storm.space.SpaceHelper.createVOSA_Token(SpaceHelper.java:211)
at it.grid.storm.namespace.config.xml.XMLNamespaceParser.updateSA(XMLNamespaceParser.java:374)
at it.grid.storm.namespace.config.xml.XMLNamespaceParser.refreshCache(XMLNamespaceParser.java:292)
at it.grid.storm.namespace.config.xml.XMLNamespaceParser.refreshCachedData(XMLNamespaceParser.java:191)
at it.grid.storm.namespace.config.xml.XMLNamespaceParser.<init>(XMLNamespaceParser.java:116)
at it.grid.storm.namespace.NamespaceDirector.initializeDirector(NamespaceDirector.java:71)
at it.grid.storm.StoRM.loadNamespaceConfiguration(StoRM.java:162)
at it.grid.storm.StoRM.init(StoRM.java:113)
at it.grid.storm.Main.main(Main.java:23)

There was a problem in the content of storage_space table.

MariaDB [storm_be_ISAM]> select * from storage_space;

+-------+-----------------------------------------+---------+------------------+--------------------------------------+---------------------+----------------+----------------+----------------+-----------------------------+--------------+----------+------------+---------------+---------------+------------------+----------------+---------------+---------------------+
| SS_ID | USERDN                                  | VOGROUP | ALIAS            | SPACE_TOKEN                          | CREATED             | TOTAL_SIZE     | GUAR_SIZE      | FREE_SIZE      | SPACE_FILE                  | STORAGE_INFO | LIFETIME | SPACE_TYPE | USED_SIZE     | BUSY_SIZE     | UNAVAILABLE_SIZE | AVAILABLE_SIZE | RESERVED_SIZE | UPDATE_TIME         |
+-------+-----------------------------------------+---------+------------------+--------------------------------------+---------------------+----------------+----------------+----------------+-----------------------------+--------------+----------+------------+---------------+---------------+------------------+----------------+---------------+---------------------+
|    11 | /DC=it/DC=infngrid/OU=Services/CN=storm | NO_VO   | INFOESCAPE_TOKEN | ED777C68-8501-6FBB-839A-816B77775204 | 2022-03-31 15:42:46 |     1000000000 |     1000000000 |             -1 | /storage/gpfs_escape/info   | NULL         |     NULL | VOSpace    |            -1 |            -1 |                0 |             -1 |             0 | 2022-03-31 15:42:46 |
|    12 | /DC=it/DC=infngrid/OU=Services/CN=storm | NO_VO   | ESCAPEDISK       | F3777C68-8501-7764-839A-816B3D3770A7 | 0000-00-00 00:00:00 | 25000002191360 | 25000002191360 | 23458278604800 | /storage/gpfs_escape/escape | NULL         |     NULL | VOSpace    | 1541723586560 | 1541723586560 |                0 | 23458278604800 |             0 | 2022-08-05 09:05:26 |
|    10 | /DC=it/DC=infngrid/OU=Services/CN=storm | NO_VO   | ESCAPETAPE       | E7777C68-8501-7FA1-839A-816B736C7B56 | 0000-00-00 00:00:00 | 34999298424832 | 34999298424832 | 34999292207104 | /storage/gpfs_escape/tape   | NULL         |     NULL | VOSpace    |       6217728 |       6217728 |                0 | 34999292207104 |             0 | 2022-08-05 09:05:10 |
|     9 | /DC=it/DC=infngrid/OU=Services/CN=storm | NO_VO   | DTEAM_TOKEN      | DB777C68-8501-8F84-839A-816B64371F00 | 2022-03-31 17:42:46 |     1000000000 |     1000000000 |      999999871 | /storage/gpfs_escape/test   | NULL         |     NULL | VOSpace    |           129 |           129 |                0 |      999999871 |             0 | 2022-03-31 15:42:46 |
+-------+-----------------------------------------+---------+------------------+--------------------------------------+---------------------+----------------+----------------+----------------+-----------------------------+--------------+----------+------------+---------------+---------------+------------------+----------------+---------------+---------------------+

4 rows in set (0.00 sec)

MariaDB [storm_be_ISAM]> select CREATED,ALIAS from storage_space;

+---------------------+------------------+
| CREATED             | ALIAS            |
+---------------------+------------------+
| 2022-03-31 15:42:46 | INFOESCAPE_TOKEN |
| 0000-00-00 00:00:00 | ESCAPEDISK       |
| 0000-00-00 00:00:00 | ESCAPETAPE       |
| 2022-03-31 17:42:46 | DTEAM_TOKEN      |
+---------------------+------------------+
4 rows in set (0.00 sec)

Those CREATED = 0000-00-00 00:00:00 were the problem.

I deleted rows and restarted BE. Things restarted working again.

We need to check the behaviour of updating StoRM to 1.11.22 with a dirty database.

blocks

STOR-1561 CREATE date in the future in table storage_space

Closed

Details

Description

Attachments

Issue Links

Activity

People

Dates