Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Master snapshot: dcache database update errors #7755

Open
onnozweers opened this issue Mar 4, 2025 · 4 comments
Open

Master snapshot: dcache database update errors #7755

onnozweers opened this issue Mar 4, 2025 · 4 comments
Assignees
@kofemann
Labels
bug master-only

Comments

@onnozweers
Copy link
Contributor

onnozweers commented Mar 4, 2025 •
edited
Loading

Dear dCache devs,

I just did an upgrade on our test server to the latest master snapshot (building from source). After upgrading the package, I ran the usual dcache database update but I got some errors. It's not urgent, but I thought it best to bring it up, I hope this info may be useful.

[root@hedgehog14 ~/dcache]# dcache database update
PnfsManager@namespaceDomain: 
Starting Liquibase at 09:32:52 using Java 17.0.6-ea (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
Running Changeset: org/dcache/chimera/changelog/00-liquibase-fixes.xml::0.1::tigran
 
UPDATE SUMMARY
Run:                          1
Previously run:               0
Filtered out:                 0
-------------------------------
Total change sets:            1
 
Liquibase: Update has been successful. Rows affected: 43
Liquibase command 'update' was executed successfully.
Starting Liquibase at 09:32:54 using Java 17.0.6-ea (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.8.0.xml::1::tigran from 7:17fde3a5dced499d37d7e113c3bf14a2 to 9:9c0e7d86bc2646de61cf90032b8c423c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.8.0.xml::1.1::tigran from 7:46d244d19a742044ed69e1747eb28f55 to 9:c4746c8661b444c5c8036b029aa9c601.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.8.0.xml::2::tigran from 7:6990d2ef332cd12effa4b8e870047a5e to 9:b892dfafc07b5044b5b20046ceca0900.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.8.0.xml::3::tigran from 7:297f2f5432210942b43b820a7c49006e to 9:63818b05ac67c626ae567c1ab33b0b80.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.2.xml::4::tigran from 7:009b5be6d6f424a8d4ffc26023180832 to 9:8824fb21ad3ceb8c0331fbeef3deb15e.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.3.xml::5::tigran from 7:22588d4ccaa29b0e1f8958feda20d713 to 9:05273767f894a8d7a834d75eaf26e861.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.3.xml::6::tigran from 7:16d2e4e79f53afadad377b82b1338da1 to 9:78d828183c7900933ad953b6a73242b6.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.12.xml::7.3::tigran from 7:cfa6167e61fdbbea4d9a580079b655d7 to 9:8f0e42ddef576f1660d76df5f3128b8b.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.12.xml::8::tigran from 7:11e2237ac7a2571351a0142d8e592c49 to 9:3c16b952fbe2b5b462501e5a1f83011c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-1.9.13.xml::9::tigran from 7:63673bb823281f204e16ea055d7fc773 to 9:ca233a54aaf962738bf486a658b429fb.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.3.xml::10::litvinse from 7:da6e72eda0500b2297060186def0ff79 to 9:b9ade3ac0d625a16ab12275bcc203ba6.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.3.xml::11::litvinse from 7:a066c975825e87cba5a8ff0a0d545742 to 9:4cb472df329bf9632d84f13811780955.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.3.xml::12::tigran from 7:d267f5e8cade9dece6586970b456bed8 to 9:ce24819d3cc82da15a7ac0936cd267d9.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.8.xml::15.2::behrmann from 7:f86c109273986bc6bf4d251682e20bd7 to 9:a7dfd23ade9f3811e986491c36f54df5.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.8.xml::15.3::tigran from 7:7c8447bfc38b82b3332ed31c72e735ae to 9:469fd850e25e9f4dbdcaf47e04b5b465.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.8.xml::15.4::tigran from 7:3721c0dd3c79f626d985ae8747b64f7f to 9:77a3af927051d1ed64b79187b21734fe.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.8.xml::17.1::litvinse from 7:ad9dc5aefb279fb9eeba204b7f530c5d to 9:8840ed1d8648e2a6c0fc9dd57a923d3c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.9.xml::18.1::litvinse from 7:1694f852b51ff02fbd77dbdd9696e6c6 to 9:4157fb574da47116c5af2ab60cddb821.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.9.xml::19.1::tigran from 7:4224472fd6ff7dded41e436de866355b to 9:a3b3fc6f43c9dbdc3c1c739c758d9935.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.10.xml::1::behrmann from 7:3a65d05523bb357ed29d49ecb7d098f9 to 9:b542f4043fe060ded346faea613bee99.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.10.xml::2::behrmann from 7:34f6e1e7f5a45ef9ae509b21006ffe7e to 9:1cf44fe9798db511d295d205356c9ad6.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.13.xml::1.1::behrmann from 7:b2bf26fc059e19de1de1885bb7c6f69d to 9:c81bc016f9adc56c34ef2243e96fed70.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.13.xml::3::behrmann from 7:f6c8aceed07de36b10d13bb437fd8b74 to 9:5ae676361dd0d1a19fcfc001a4245fc7.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.13.xml::4::behrmann from 7:4850fb9e27b6eeb94026f1475ce21046 to 9:0ad84ca373c43c634affbe2b2cfd9ec1.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::2.2::behrmann from 7:c26ad33e589eb3cb7c66cc1f02031475 to 9:36c553e2b43960eca3b33f8e0ee33b55.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::3.1::behrmann from 7:a674bbf828e6f099cac519dd19c24bd0 to 9:df2eb0a1115e018eb45485195e686b57.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::23.1::tigran from 7:0f67820d9acd11c92788482623f6f695 to 9:01fb374dcfa48c6e18099536f486b704.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::23.2::tigran from 7:48477e9913f8dfbbf430eff0e3fedaab to 9:558ac9f70b04ba157b10434a7a37b5d6.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::23.3::tigran from 7:3721c0dd3c79f626d985ae8747b64f7f to 9:77a3af927051d1ed64b79187b21734fe.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::21::tigran from 7:42e485d362cc55eb1ad844bfa793347a to 9:a6933fe91c4ecaca1a01a4c666626893.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::24.1::litvinse from 7:56a6b277ee4f7412dd6fe37d4c8caf42 to 9:8dc12cc57051f05f58c8ef644f5b532d.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::4.1::behrmann from 7:8b55165b04c65c4cb8ccf7f93fde9faa to 9:618caef33db30d1c5c6ec95686cbd52c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::5::behrmann from 7:5fdeb9b27b034c454d4b7290dbd4a496 to 9:0150786897ff773d3710ff73f079e0b4.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::6.1::behrmann from 7:b7d435508913f6378ce145a93205cb29 to 9:ea458df47b47e09435cd0acb934ae0d8.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::7::behrmann from 7:a7f81c8063cabff046bc73d764f359da to 9:d54cfa27d1fcbb65a9cbc3a8a78d9819.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.14.xml::8::behrmann from 7:ca1d1206b2f3d25f96040115e0f148ec to 9:e797ccce5f3b87d1b0dcf6564101f9f2.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::1.2::behrmann from 7:2db9e833ae19148780e5d1acc517eaa8 to 9:d04e6c9f98fc9fc1c3bb40394af57708.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::2.3::behrmann from 7:488b677497845d9fdccc2b4735c955fa to 9:717929863c421081949be3851b706b42.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::4.2::behrmann from 7:21ed1ac81363f72ec5be2170ce036724 to 9:fff5a28379ca2c2a0960506bdc12981a.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::5.1::behrmann from 7:d541022e08ac308078ab824a740bb062 to 9:d81058feeddeba7115a3b0a37b5f6017.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::6::behrmann from 7:baa9b2ae6dbe27f5188485d2cb3b404a to 9:06654e1f0e4619aa6eb6039119dae04c.
Running Changeset: org/dcache/chimera/changelog/changeset-2.15.xml::7.1::behrmann
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::8.1::behrmann from 7:e303e36cdcbe213f479edb598925d775 to 9:bc0905a0d130b1e3183a73fed4fab3a5.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::9::behrmann from 7:73f1f1fc065fba417a14d775ccdfd294 to 9:c86ced1ef96450e57840326120134879.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::10::behrmann from 7:53ebb0055ff1ffe98b8db3603b2ef3a8 to 9:6913b71a82bba0c5ad0bbadf7c5c29e0.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::11::behrmann from 7:e4d33c563df93e5ff1ae8ecd5da9b580 to 9:85664923f4a68a1f7acbd8ba5e434d73.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::11.1::litvinse from 7:25edbdaaba3176e673ec2998f320152c to 9:17061ecf34e23f393dffe4a385604140.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::12::behrmann from 7:4e12375b560365cf7e08d0073e17d891 to 9:b666a09261c30a3016eb8226828c201c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::13::behrmann from 7:ac1f2432f90cbc0e26283b4659dc29e2 to 9:7558a51b16ca99f61227af89108649a5.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::15::behrmann from 7:96b0bfae3af90c9ffad9d0ded811f649 to 9:5eb4cc31e4185f99041494c782c1ce2e.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::16::behrmann from 7:bf04aa90cf10d3c7d45f53a261d9d068 to 9:33c08177719423e23218fbd4b44e7ccf.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::17::behrmann from 7:f6edddc3206e3c4cf969dd2ec5f0519c to 9:f0edd7cfa51243ad6721d5bf793b7806.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::18::behrmann from 7:3f20884c35f64037f350d5009ad7f96d to 9:5a8ad944156448b6eb92992ace1574eb.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::19::behrmann from 7:ea390d7581aac2e346b6a737c188473b to 9:3ea09c1f3ee53b2ab3d8ae9eb18f2b45.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::20::behrmann from 7:2ccfdb189f429dc6100f718d271c3584 to 9:8c17e44c222f717cfd46b24e32b97725.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::21::behrmann from 7:217ec92208dff4a295b71510d11b7f76 to 9:865d7d179ee0100c5d71655f6ec95257.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::22::behrmann from 7:1d31f4dd435e7edb1ac1c7fafaa3c6e2 to 9:bdfcbbc9c914eecac3e544e902edabe4.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::23::behrmann from 7:159acd52b9aafb7d3f9f64aa260ec166 to 9:ed8350609371a9631e009d52f9e268bc.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::24.2::litvinse from 7:f8dc45ef1c6a5d2b8bbba9151096697a to 9:1609ba14fb7b82b8cb79f6399c5f0a1a.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::25::behrmann from 7:f2b4f1268cebeb5237c05275ad6ee716 to 9:beda4e179fdd606371af8a18ecf0cd99.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-2.15.xml::26::paul from 7:795db2c80719423d65229cca1187f64c to 9:49615b9758445e23f026f8c60a004ff9.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-3.1.xml::26::tigran from 7:c6f37894dee567e0efa2cc7fe6afa804 to 9:ddbafe016c3c2ca5372ac89913c19259.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-5.2.xml::27::tigran from 7:cba821b535ee0ff5564d10600a887f73 to 9:3a3e51e23a7050357a21aa28b018e999.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-6.0.xml::28::litvinse from 7:6be54278cca6c1a4f596e2d96cda7125 to 9:ac5f62f5713942c6a2d2900b906aedd1.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-6.2.xml::29::tigran from 7:d48f1eec40c3a2859afb772617434152 to 9:d991c4ad6a1c442bebd92486af0dd10f.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-6.2.xml::30::tigran from 7:b08d667e01804794ca7d691f67349d07 to 9:568ca1586e57db80d5cf73bd5ad3d8ee.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-7.1.xml::31::tigran from 7:7cdca4cc2a10f6e29b7e55c01a625ebc to 9:cefebfcd251e711a520792a9b40966cf.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-7.2.xml::32::litvinse from 7:c88f91e58c691813b2ba6a3f3feb395d to 9:bbfbe6be4685216f6640ce0e6bb4512c.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-7.2.xml::33::litvinse from 7:9bb19b43b4f3b39ab33f0832049331f3 to 9:11e6588074335f3a6a48cc2df85631e8.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-7.2.xml::33::marina from 7:3f028381ee1cd5da4060a1bc767dfb01 to 9:c4ba0cc8df15011c17fd988fcceaa4d7.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-8.2.xml::34::arossi from 7:de72da59594baac6480826e9e0b56115 to 9:bc2ff5ac3d8ac2c63a89e23e1bc175cb.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-8.2.xml::34.1::arossi from 7:c7092d089bbad634e509d55ed4a74747 to 9:43c71a76a96209d30cb7c4672f64e347.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-9.1.xml::34::tigran from 7:16ba8ba2f34e2831835106b9528a6c72 to 9:5b706c0cb3d4ea9eb0d8acf913772ace.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-9.2.xml::35.1::arossi from 7:538197d1f0b93e8a3f990e9bb3155351 to 9:924d863c9210c5229c29cf7894333762.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-9.2.xml::35.2::arossi from 7:f421794dd4ce845f59b2b56858e0b519 to 9:ff868b7231b758737e71ec2714fe540e.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-9.2.xml::35.3::arossi from 7:c06bfe53f8b94f0118580e87c7ec9d2f to 9:cd305dbdbda98192803d3e86f99ff55d.
Upgrading checksum for Changeset org/dcache/chimera/changelog/changeset-10.xml::36::litvinse from 7:fd12ef3ccb2e23e914344d5b2cb86bc2 to 9:1410d61df3bd56a664f543e311e7c8c6.
 
UPDATE SUMMARY
Run:                          1
Previously run:              76
Filtered out:                 3
-------------------------------
Total change sets:           80
 
 
FILTERED CHANGE SETS SUMMARY
DBMS mismatch:                3
 
Liquibase: Update has been successful. Rows affected: 77
Liquibase command 'update' was executed successfully.
NFS-hedgehog14@namespaceDomain: 
Starting Liquibase at 09:32:56 using Java 17.0.6-ea (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
 
UPDATE SUMMARY
Run:                          0
Previously run:               1
Filtered out:                 0
-------------------------------
Total change sets:            1
 
Liquibase: Update has been successful. Rows affected: 0
Liquibase command 'update' was executed successfully.
Starting Liquibase at 09:32:57 using Java 17.0.6-ea (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
 
UPDATE SUMMARY
Run:                          0
Previously run:              77
Filtered out:                 3
-------------------------------
Total change sets:           80
 
 
FILTERED CHANGE SETS SUMMARY
DBMS mismatch:                3
 
Liquibase: Update has been successful. Rows affected: 0
Liquibase command 'update' was executed successfully.
SrmManager@srmDomain: 
Starting Liquibase at 09:32:58 using Java 17.0.6-ea (version 4.29.2 #3683 built at 2024-08-29 16:45+0000)
Liquibase Version: 4.29.2
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
ERROR: Exception Details
ERROR: Exception Primary Class:  ValidationFailedException
ERROR: Exception Primary Reason:  Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
ERROR: Exception Primary Source:  4.29.2
[2025-03-04 09:32:59] SEVERE [liquibase.integration] Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
liquibase.exception.CommandExecutionException: liquibase.exception.ValidationFailedException: Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
    at liquibase.command.CommandScope.execute(CommandScope.java:258)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2045)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2465)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2457)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2419)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2421)
    at picocli.CommandLine.execute(CommandLine.java:2174)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:404)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:379)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:376)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:97)
Caused by: liquibase.exception.ValidationFailedException: Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
    at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:398)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:92)
    at liquibase.command.CommandScope.execute(CommandScope.java:220)
    ... 18 more
 
 
Unexpected error running Liquibase: Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
liquibase.exception.CommandExecutionException: liquibase.exception.ValidationFailedException: Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
    at liquibase.command.CommandScope.execute(CommandScope.java:258)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:51)
    at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:21)
    at picocli.CommandLine.executeUserObject(CommandLine.java:2045)
    at picocli.CommandLine.access$1500(CommandLine.java:148)
    at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2465)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2457)
    at picocli.CommandLine$RunLast.handle(CommandLine.java:2419)
    at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
    at picocli.CommandLine$RunLast.execute(CommandLine.java:2421)
    at picocli.CommandLine.execute(CommandLine.java:2174)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$2(LiquibaseCommandLine.java:404)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$3(LiquibaseCommandLine.java:379)
    at liquibase.Scope.child(Scope.java:200)
    at liquibase.Scope.child(Scope.java:176)
    at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:376)
    at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:97)
Caused by: liquibase.exception.ValidationFailedException: Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095
 
    at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:398)
    at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:92)
    at liquibase.command.CommandScope.execute(CommandScope.java:220)
    ... 18 more

I looked at recent commits and I noticed this:
68f7ffe

Could it have anything to do with the errors?

This is not urgent, since it's only our test server, things seem to work normally, and we can roll back to the previous build if we need to.

Cheers,
Onno
@onnozweers onnozweers changed the title Master snapshot: dcache database upgrade errors Master snapshot: dcache database update errors Mar 4, 2025
@onnozweers
Copy link
Contributor Author

I wrote that things seemed to work normally, but that's not quite true. The SrmManager has trouble starting.

04 Mar 2025 13:35:03 (SrmManager) [] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'srm-credential-store' defined in class path resource [diskCacheV111/srm/srmmanager.xml]: Cannot resolve reference to bean 'config' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [diskCacheV111/srm/srmmanager.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException; SQL state [null]; error code [0]; Schema migration failed; nested exception is java.sql.SQLException: Schema migration failed
04 Mar 2025 13:35:03 (System) [] Failure at startup: (666) URL [file:/usr/share/dcache/services/srmmanager.batch]: line 209: (3) Failed to create bean 'srm-credential-store' : Validation Failed:
     2 changesets check sum
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::4::behrmann was: 7:0e1c15013e23f1df41d4035279a1e832 but is now: 7:3cf94dc86efe2152925a739c69fd464d
          org/dcache/srm/request/sql/srm.changelog-2.14.xml::7::behrmann was: 7:6956b64fca6692e79e878e317715a628 but is now: 7:59f95bea151c12b6f158a7f5dc330095

@onnozweers
Copy link
Contributor Author

I re-created the srm and spacemanager databases:

psql -U dcache -d postgres -c "DROP DATABASE srm;"
psql -U dcache -d postgres -c "CREATE DATABASE srm;"
psql -U dcache -d postgres -c "DROP DATABASE spacemanager;"
psql -U dcache -d postgres -c "CREATE DATABASE spacemanager;"

Re-ran dcache database update to populate them, and now I have a running dCache.

Of course, this is a test server so I can mess around. I hope we don't have to do this in production with a future upgrade 😸

@kofemann kofemann added the bug label Mar 4, 2025
@kofemann kofemann self-assigned this Mar 4, 2025
@kofemann
Copy link
Member

kofemann commented Mar 4, 2025

Thanks Onno for reporting!

@onnozweers
Copy link
Contributor Author

Oh I forgot to mention that dcache database rollbackToDate $(date --date yesterday +%FT%T) did not work. That's why I re-created the databases.

Rolling Back Changeset: org/dcache/chimera/changelog/00-liquibase-fixes.xml::0.1::tigran
ERROR: Exception Details
ERROR: Exception Primary Class:  RollbackImpossibleException
ERROR: Exception Primary Reason:  No inverse to liquibase.change.core.RawSQLChange created
ERROR: Exception Primary Source:  4.29.2
...

kofemann added a commit that referenced this issue Mar 6, 2025
@kofemann
srm: fix liquibase checksum mismatch
10c49db 
Motivation:
The liquibase has new checksum calculation policy, which is not
compatible with existing checksums.

Modification:
add checksum transformation workaround.

Result:
the existing SRM database can be used with new dCache versions.

Issue: #7755
Acked-by: Lea Morschel
Target: master
Require-book: no
Require-notes: no
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kofemann kofemann

Labels
bug master-only
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kofemann @onnozweers