Contenu | Rechercher | Menus

Annonce

Si vous avez des soucis pour rester connecté, déconnectez-vous puis reconnectez-vous depuis ce lien en cochant la case
Me connecter automatiquement lors de mes prochaines visites.

À propos de l'équipe du forum.

#1 Le 22/04/2022, à 12:41

jajaX

[résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

hello,

suite à ce message, j'ai "enfin" réussi à comprendre la "méthode" de mise à jour de Airsonic vers Airsonic-Advanced !!!!

bon, maintenant, voilà que ça coince au niveau de la base de données embarquée....

ça me donne ça =>

/var/www/airsonic$ sudo systemctl status airsonic.service
● airsonic.service - Airsonic Media Server
     Loaded: loaded (/etc/systemd/system/airsonic.service; enabled; vendor preset: enabled)
     Active: failed (Result: signal) since Fri 2022-04-22 13:23:46 CEST; 4min 10s ago
    Process: 171851 ExecStart=/usr/bin/java $JAVA_OPTS -Dairsonic.home=${AIRSONIC_HOME} -Dserver.servlet.contextPath=${CONTEXT_PATH} -Dserver.port=${PORT} -jar ${JAVA_JAR} $JAVA_ARGS (code=killed, signal=SYS)
   Main PID: 171851 (code=killed, signal=SYS)

avril 22 13:23:45 Aspire-One-522 java[171851]:      /\   (_)                     (_)
avril 22 13:23:45 Aspire-One-522 java[171851]:     /  \   _ _ __  ___  ___  _ __  _  ___
avril 22 13:23:45 Aspire-One-522 java[171851]:    / /\ \ | | '__|/ __|/ _ \| '_ \| |/ __|
avril 22 13:23:45 Aspire-One-522 java[171851]:   / ____ \| | |   \__ \ (_) | | | | | (__
avril 22 13:23:45 Aspire-One-522 java[171851]:  /_/    \_\_|_|   |___/\___/|_| |_|_|\___|
avril 22 13:23:45 Aspire-One-522 java[171851]:                                                
avril 22 13:23:45 Aspire-One-522 java[171851]:                         11.0.0-SNAPSHOT
avril 22 13:23:46 Aspire-One-522 java[171851]: 2022-04-22 13:23:46.030  INFO --- o.a.p.u.LegacyHsqlMigrationUtil          : HSQLDB database upgrade needed, from version 1.8.0 to 2.5
avril 22 13:23:46 Aspire-One-522 systemd[1]: airsonic.service: Main process exited, code=killed, status=31/SYS
avril 22 13:23:46 Aspire-One-522 systemd[1]: airsonic.service: Failed with result 'signal'.

comme expliqué ici, il faut la version 2.5 de HyperSQLpour faire tourner les dernières versions du serveur.

je ne sais pas comment faire cette mise à jour.... j'ai regardé au niveau des versions de paquets pour ubuntu et je tombe toujours sur cette version 1.8 même pour la dernière version sortie pourtant hier (voir ici)....

je veux bien de l'aide car là, je sèche.....

merci wink

Dernière modification par jajaX (Le 03/05/2022, à 20:21)


@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#2 Le 22/04/2022, à 13:27

Vobul

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

Tu utilises quelle version de Ubuntu déjà pour commencer ?


Vobul
Utilisez le retour utilisable de commandes !!!
J'aime la langue française, mais je parle franglais, deal with it.
RTFM

Hors ligne

#3 Le 22/04/2022, à 15:02

jajaX

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

ah oui, effectivement, j'ai oublié ce détails !

je suis sous kubuntu 20.04 64 bits sur mon ASUS N53SN.


@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#4 Le 22/04/2022, à 15:35

Vobul

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

Donc 2.5 est dispo dans les repos de 22.04, mais 20.04 est sur 1.8. C'est le problème des distributions qui ne sont pas "rolling release" comme Ubuntu.

Donc sois tu tentes un PPA, soit tu upgrades à 22.04, soit tu compiles le truc toi-même wink


Vobul
Utilisez le retour utilisable de commandes !!!
J'aime la langue française, mais je parle franglais, deal with it.
RTFM

Hors ligne

#5 Le 22/04/2022, à 15:46

jajaX

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

ok, d'accord, merci wink

j'ai bien trouvé celui-là, qui ferait l'affaire mais je n'arrive pas à trouver la page d'infos pour le rajouter !!


@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#6 Le 22/04/2022, à 17:58

jajaX

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

ça n'avait rien à avoir avec la version de la database.... voir ici

si je lance avec la ligne indiqué dans le dernier post en l'adaptant à ma config, ça marche :

sudo /usr/bin/java -Xmx700m -Dairsonic.home=/var/www/airsonic -Dserver.servlet.contextPath=/airsonic -Dserver.port=4050 -Dserver.forward-headers-strategy=native -jar /var/www/airsonic/airsonic.war
           _                       _          
     /\   (_)                     (_)         
    /  \   _ _ __  ___  ___  _ __  _  ___     
   / /\ \ | | '__|/ __|/ _ \| '_ \| |/ __|    
  / ____ \| | |   \__ \ (_) | | | | | (__     
 /_/    \_\_|_|   |___/\___/|_| |_|_|\___|    
                                               
                        11.0.0-SNAPSHOT



2022-04-22 18:31:23.337  INFO --- o.a.p.u.LegacyHsqlMigrationUtil          : HSQLDB database upgrade needed, from version 1.8.0 to 2.5
2022-04-22 18:31:23.449  INFO --- o.a.p.u.LegacyHsqlMigrationUtil          : HSQLDB database backed up to /var/www/airsonic/backups/db.backup.20220422183123
2022-04-22 18:31:30.625  INFO --- o.a.p.u.LegacyHsqlMigrationUtil          : HSQLDB database has been upgraded
2022-04-22 18:31:30.628  INFO --- o.a.p.u.LegacyHsqlMigrationUtil          : HSQLDB database version is now 2.5.0
2022-04-22 18:31:30.635  INFO --- org.airsonic.player.Application          : Starting Application v11.0.0-SNAPSHOT using Java 11.0.14.1 on Aspire-One-522 with PID 198329 (/var/www/airsonic/airsonic.war started by root in /var/www/airsonic)
2022-04-22 18:31:30.636  INFO --- org.airsonic.player.Application          : No active profile set, falling back to 1 default profile: "default"
2022-04-22 18:31:37.454  INFO --- l.database.core.HsqlDatabase             : Set default schema name to PUBLIC
2022-04-22 18:31:37.760  INFO --- l.l.StandardLockService                  : Successfully acquired change log lock
2022-04-22 18:31:39.526  INFO --- l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.DATABASECHANGELOG
2022-04-22 18:31:40.562  INFO --- l.l.StandardLockService                  : Successfully released change log lock
2022-04-22 18:31:40.579  INFO --- l.l.StandardLockService                  : Successfully acquired change log lock
2022-04-22 18:31:40.615  INFO --- l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.DATABASECHANGELOG
2022-04-22 18:31:42.600  INFO --- liquibase.changelog.ChangeSet            : Columns duration(double) added to media_file
2022-04-22 18:31:44.586  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.368  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/10.6/expand-durations.xml::add-durations-to-mediafile::anon ran successfully in 4475ms
2022-04-22 18:31:45.449  INFO --- liquibase.changelog.ChangeSet            : Columns duration(double) added to album
2022-04-22 18:31:45.519  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.558  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/10.6/expand-durations.xml::add-durations-to-album::anon ran successfully in 183ms
2022-04-22 18:31:45.565  INFO --- liquibase.changelog.ChangeSet            : Columns duration(double) added to playlist
2022-04-22 18:31:45.576  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.576  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/10.6/expand-durations.xml::add-durations-to-playlist::anon ran successfully in 14ms
2022-04-22 18:31:45.614  INFO --- liquibase.changelog.ChangeSet            : Table user_credentials created
2022-04-22 18:31:45.617  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.620  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.623  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.623  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/10.6/user-credentials.xml::add-user-credentials::anon ran successfully in 32ms
2022-04-22 18:31:45.627  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:45.628  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/10.6/user-credentials.xml::trim-user-credentials-encoder::anon ran successfully in 2ms
2022-04-22 18:31:45.633  INFO --- liquibase.changelog.ChangeSet            : user_credentials.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.633  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::user-credentials-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.638  INFO --- liquibase.changelog.ChangeSet            : user_credentials.updated datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.638  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::user-credentials-timestamps-2::anon ran successfully in 2ms
2022-04-22 18:31:45.642  INFO --- liquibase.changelog.ChangeSet            : user_credentials.expiration datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.643  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::user-credentials-timestamps-3::anon ran successfully in 2ms
2022-04-22 18:31:45.647  INFO --- liquibase.changelog.ChangeSet            : music_file_info.last_played datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.648  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema26-timestamps-1::anon ran successfully in 1ms
2022-04-22 18:31:45.652  INFO --- liquibase.changelog.ChangeSet            : player.last_seen datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.652  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema26-timestamps-2::anon ran successfully in 2ms
2022-04-22 18:31:45.657  INFO --- liquibase.changelog.ChangeSet            : podcast_episode.publish_date datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.657  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema32-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.661  INFO --- liquibase.changelog.ChangeSet            : system_avatar.created_date datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.661  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema35-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.665  INFO --- liquibase.changelog.ChangeSet            : custom_avatar.created_date datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.666  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema35-timestamps-2::anon ran successfully in 1ms
2022-04-22 18:31:45.670  INFO --- liquibase.changelog.ChangeSet            : music_folder.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.670  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema37-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.674  INFO --- liquibase.changelog.ChangeSet            : internet_radio.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.675  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema37-timestamps-2::anon ran successfully in 1ms
2022-04-22 18:31:45.679  INFO --- liquibase.changelog.ChangeSet            : user_settings.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.679  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema37-timestamps-3::anon ran successfully in 2ms
2022-04-22 18:31:45.683  INFO --- liquibase.changelog.ChangeSet            : share.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.684  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema45-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.688  INFO --- liquibase.changelog.ChangeSet            : share.expires datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.688  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema45-timestamps-2::anon ran successfully in 2ms
2022-04-22 18:31:45.692  INFO --- liquibase.changelog.ChangeSet            : share.last_visited datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.693  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema45-timestamps-3::anon ran successfully in 1ms
2022-04-22 18:31:45.697  INFO --- liquibase.changelog.ChangeSet            : media_file.last_played datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.697  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-1::anon ran successfully in 2ms
2022-04-22 18:31:45.702  INFO --- liquibase.changelog.ChangeSet            : media_file.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.702  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-2::anon ran successfully in 2ms
2022-04-22 18:31:45.706  INFO --- liquibase.changelog.ChangeSet            : media_file.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.707  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-3::anon ran successfully in 2ms
2022-04-22 18:31:45.711  INFO --- liquibase.changelog.ChangeSet            : media_file.last_scanned datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.712  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-4::anon ran successfully in 1ms
2022-04-22 18:31:45.717  INFO --- liquibase.changelog.ChangeSet            : media_file.children_last_updated datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.717  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-5::anon ran successfully in 2ms
2022-04-22 18:31:45.722  INFO --- liquibase.changelog.ChangeSet            : artist.last_scanned datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.722  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-6::anon ran successfully in 2ms
2022-04-22 18:31:45.727  INFO --- liquibase.changelog.ChangeSet            : album.last_played datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.727  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-7::anon ran successfully in 2ms
2022-04-22 18:31:45.731  INFO --- liquibase.changelog.ChangeSet            : album.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.732  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-8::anon ran successfully in 2ms
2022-04-22 18:31:45.736  INFO --- liquibase.changelog.ChangeSet            : album.last_scanned datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.737  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-9::anon ran successfully in 1ms
2022-04-22 18:31:45.741  INFO --- liquibase.changelog.ChangeSet            : starred_media_file.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.741  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-10::anon ran successfully in 2ms
2022-04-22 18:31:45.745  INFO --- liquibase.changelog.ChangeSet            : starred_album.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.746  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-11::anon ran successfully in 1ms
2022-04-22 18:31:45.750  INFO --- liquibase.changelog.ChangeSet            : starred_artist.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.750  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-12::anon ran successfully in 2ms
2022-04-22 18:31:45.755  INFO --- liquibase.changelog.ChangeSet            : playlist.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.755  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-13::anon ran successfully in 2ms
2022-04-22 18:31:45.759  INFO --- liquibase.changelog.ChangeSet            : playlist.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.759  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-14::anon ran successfully in 1ms
2022-04-22 18:31:45.764  INFO --- liquibase.changelog.ChangeSet            : bookmark.created datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.764  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-15::anon ran successfully in 2ms
2022-04-22 18:31:45.768  INFO --- liquibase.changelog.ChangeSet            : bookmark.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.768  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema47-timestamps-16::anon ran successfully in 1ms
2022-04-22 18:31:45.772  INFO --- liquibase.changelog.ChangeSet            : play_queue.changed datatype was changed to java.sql.Types.TIMESTAMP(9)
2022-04-22 18:31:45.772  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/hsqldb-timestamp-precision.xml::legacy-schema52-timestamps-1::anon ran successfully in 1ms
2022-04-22 18:31:45.778  INFO --- liquibase.changelog.ChangeSet            : Column player.cover_art_scheme dropped
2022-04-22 18:31:45.778  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-player-columns.xml::drop-player-cover-art-scheme::anon ran successfully in 3ms
2022-04-22 18:31:45.784  INFO --- liquibase.changelog.ChangeSet            : Column player.client_side_playlist dropped
2022-04-22 18:31:45.784  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-player-columns.xml::drop-player-client-side-playlist::anon ran successfully in 3ms
2022-04-22 18:31:45.789  INFO --- liquibase.changelog.ChangeSet            : Column player.jukebox dropped
2022-04-22 18:31:45.789  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-player-columns.xml::drop-player-jukebox::anon ran successfully in 2ms
2022-04-22 18:31:45.794  INFO --- liquibase.changelog.ChangeSet            : Column play_queue.current renamed to current_media_file_id
2022-04-22 18:31:45.795  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/rename-play-queue-current-id.xml::rename-play-queue-current::anon ran successfully in 3ms
2022-04-22 18:31:45.803  INFO --- liquibase.changelog.ChangeSet            : Table player_transcoding dropped
2022-04-22 18:31:45.803  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-rename-transcoding.xml::drop-player-transcoding::anon ran successfully in 6ms
2022-04-22 18:31:45.822  INFO --- liquibase.changelog.ChangeSet            : Table player_transcoding2 renamed to player_transcoding
2022-04-22 18:31:45.823  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-rename-transcoding.xml::rename-player-transcoding2::anon ran successfully in 17ms
2022-04-22 18:31:45.828  INFO --- liquibase.changelog.ChangeSet            : Table transcoding dropped
2022-04-22 18:31:45.829  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-rename-transcoding.xml::drop-transcoding::anon ran successfully in 4ms
2022-04-22 18:31:45.845  INFO --- liquibase.changelog.ChangeSet            : Table transcoding2 renamed to transcoding
2022-04-22 18:31:45.845  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-rename-transcoding.xml::rename-transcoding2::anon ran successfully in 14ms
2022-04-22 18:31:47.490  INFO --- liquibase.changelog.ChangeSet            : Column media_file.duration_seconds dropped
2022-04-22 18:31:47.490  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-duration-seconds.xml::drop-duration-seconds-from-mediafile::anon ran successfully in 1642ms
2022-04-22 18:31:47.543  INFO --- liquibase.changelog.ChangeSet            : Column album.duration_seconds dropped
2022-04-22 18:31:47.543  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-duration-seconds.xml::drop-duration-seconds-from-album::anon ran successfully in 49ms
2022-04-22 18:31:47.548  INFO --- liquibase.changelog.ChangeSet            : Column playlist.duration_seconds dropped
2022-04-22 18:31:47.548  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/drop-duration-seconds.xml::drop-duration-seconds-from-playlist::anon ran successfully in 2ms
2022-04-22 18:31:47.556  INFO --- liquibase.changelog.ChangeSet            : Table user_settings2 created
2022-04-22 18:31:47.556  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-settings-json.xml::create-user-settings-json::anon ran successfully in 5ms
2022-04-22 18:31:47.708  INFO --- liquibase.changelog.ChangeSet            : Table user_settings2 (for json) populated from user_settings
2022-04-22 18:31:47.709  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-settings-json.xml::populate-user-settings-json::anon ran successfully in 150ms
2022-04-22 18:31:47.735  INFO --- liquibase.changelog.ChangeSet            : Table user_settings dropped
2022-04-22 18:31:47.735  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-settings-json.xml::drop-non-json-user-settings::anon ran successfully in 5ms
2022-04-22 18:31:47.756  INFO --- liquibase.changelog.ChangeSet            : Table user_settings2 renamed to user_settings
2022-04-22 18:31:47.756  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-settings-json.xml::rename-user-settings-json::anon ran successfully in 16ms
2022-04-22 18:31:47.765  INFO --- liquibase.changelog.ChangeSet            : Columns roles(clob) added to user
2022-04-22 18:31:47.765  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-roles-json.xml::create-user-roles-json::anon ran successfully in 4ms
2022-04-22 18:31:47.793  INFO --- liquibase.changelog.ChangeSet            : Column user.roles (for json) populated from user_role
2022-04-22 18:31:47.794  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-roles-json.xml::populate-user-roles-json::anon ran successfully in 25ms
2022-04-22 18:31:47.803  INFO --- liquibase.changelog.ChangeSet            : Table user_role dropped
2022-04-22 18:31:47.804  INFO --- liquibase.changelog.ChangeSet            : Table role dropped
2022-04-22 18:31:47.805  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/user-roles-json.xml::drop-non-json-user-roles::anon ran successfully in 7ms
2022-04-22 18:31:47.811  INFO --- liquibase.changelog.ChangeSet            : Column user.password dropped
2022-04-22 18:31:47.812  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/remove-password-column.xml::remove-user-password-column::anon ran successfully in 2ms
2022-04-22 18:31:47.829  INFO --- liquibase.changelog.ChangeSet            : Table sonoslink created
2022-04-22 18:31:47.830  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/add-sonos-table-link.xml::add-sonos-table-link::nacrylic ran successfully in 14ms
2022-04-22 18:31:47.835  INFO --- liquibase.changelog.ChangeSet            : podcast_channel.description datatype was changed to text
2022-04-22 18:31:47.836  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/podcast-description-text.xml::podcast-channel-description::anon ran successfully in 2ms
2022-04-22 18:31:47.841  INFO --- liquibase.changelog.ChangeSet            : podcast_episode.description datatype was changed to text
2022-04-22 18:31:47.841  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/podcast-description-text.xml::podcast-episode-description::anon ran successfully in 2ms
2022-04-22 18:31:47.847  INFO --- liquibase.changelog.ChangeSet            : New row inserted into transcoding
2022-04-22 18:31:47.847  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/insert-mod-transcoding.xml::insert-mod-transcoding::anon ran successfully in 3ms
2022-04-22 18:31:47.852  INFO --- liquibase.changelog.ChangeSet            : Auto-increment added to player.id
2022-04-22 18:31:47.852  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/add-player-id-autoincrement.xml::add-player-id-autoincrement::anon ran successfully in 2ms
2022-04-22 18:31:47.857  INFO --- liquibase.changelog.ChangeSet            : Column player.mixer dropped
2022-04-22 18:31:47.857  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/remove-java-jukebox.xml::remove-player-mixer::anon ran successfully in 2ms
2022-04-22 18:31:47.861  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:47.861  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/remove-java-jukebox.xml::convert-jukeboxes::anon ran successfully in 1ms
2022-04-22 18:31:47.879  INFO --- liquibase.changelog.ChangeSet            : Table podcast_channel_rules created
2022-04-22 18:31:47.879  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/podcast-channel-rules.xml::podcast-channel-rules::anon ran successfully in 15ms
2022-04-22 18:31:47.886  INFO --- liquibase.changelog.ChangeSet            : Columns path(varchar) added to system_avatar
2022-04-22 18:31:47.889  INFO --- liquibase.changelog.ChangeSet            : NOT NULL constraint has been added to system_avatar.path
2022-04-22 18:31:47.889  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/avatar-storage.xml::add-system-avatar-paths::anon ran successfully in 7ms
2022-04-22 18:31:47.894  INFO --- liquibase.changelog.ChangeSet            : Column system_avatar.data dropped
2022-04-22 18:31:47.894  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/avatar-storage.xml::drop-system-avatar-data::anon ran successfully in 2ms
2022-04-22 18:31:47.900  INFO --- liquibase.changelog.ChangeSet            : Columns path(varchar) added to custom_avatar
2022-04-22 18:31:47.901  INFO --- liquibase.changelog.ChangeSet            : NOT NULL constraint has been added to custom_avatar.path
2022-04-22 18:31:47.901  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/avatar-storage.xml::add-custom-avatar-paths::anon ran successfully in 4ms
2022-04-22 18:31:47.911  INFO --- liquibase.changelog.ChangeSet            : Extracted avatars from DB
2022-04-22 18:31:47.911  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/avatar-storage.xml::extract-custom-avatar::anon ran successfully in 7ms
2022-04-22 18:31:47.916  INFO --- liquibase.changelog.ChangeSet            : Column custom_avatar.data dropped
2022-04-22 18:31:47.916  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/avatar-storage.xml::drop-custom-avatar-data::anon ran successfully in 2ms
2022-04-22 18:31:47.932  INFO --- liquibase.changelog.ChangeSet            : Table user renamed to users
2022-04-22 18:31:47.932  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/move-user-table.xml::move-user-table::anon ran successfully in 13ms
2022-04-22 18:31:47.937  INFO --- liquibase.changelog.ChangeSet            : Data updated in transcoding
2022-04-22 18:31:47.937  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/add-wavpack.xml::add-wavpack::yetangitu ran successfully in 2ms
2022-04-22 18:31:47.942  INFO --- liquibase.changelog.ChangeSet            : Columns episode_guid(varchar) added to podcast_episode
2022-04-22 18:31:47.943  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/podcast-episode-guid.xml::podcast-episode-guid::anon ran successfully in 2ms
2022-04-22 18:31:47.948  INFO --- liquibase.changelog.ChangeSet            : Columns type(varchar) added to music_folder
2022-04-22 18:31:47.948  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-type-to-media-folder::anon ran successfully in 3ms
2022-04-22 18:31:47.952  INFO --- liquibase.changelog.ChangeSet            : New row inserted into music_folder
2022-04-22 18:31:47.955  INFO --- liquibase.changelog.ChangeSet            : Added podcast media folder users
2022-04-22 18:31:47.956  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-podcast-media-folder::anon ran successfully in 5ms
2022-04-22 18:31:48.069  INFO --- liquibase.changelog.ChangeSet            : Added unknown music folders
2022-04-22 18:31:48.069  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-unknown-media-folders::anon ran successfully in 110ms
2022-04-22 18:31:48.087  INFO --- liquibase.changelog.ChangeSet            : Media folder uniqueness established by path
2022-04-22 18:31:48.088  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::unique-media-folders::anon ran successfully in 15ms
2022-04-22 18:31:48.106  INFO --- liquibase.changelog.ChangeSet            : Index idx_music_folder_path created
2022-04-22 18:31:48.106  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-uniqueness-constraint-to-media-folders-path::anon ran successfully in 2ms
2022-04-22 18:31:48.113  INFO --- liquibase.changelog.ChangeSet            : Columns media_file_id(int) added to podcast_channel
2022-04-22 18:31:48.115  INFO --- liquibase.changelog.ChangeSet            : Foreign key constraint added to podcast_channel (media_file_id)
2022-04-22 18:31:48.116  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-media-file-id-to-podcast-channel::anon ran successfully in 5ms
2022-04-22 18:31:48.123  INFO --- liquibase.changelog.ChangeSet            : Added media file ids to podcast channels
2022-04-22 18:31:48.123  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::populate-podcast-channel-media-file-id::anon ran successfully in 2ms
2022-04-22 18:31:48.129  INFO --- liquibase.changelog.ChangeSet            : Columns media_file_id(int) added to podcast_episode
2022-04-22 18:31:48.131  INFO --- liquibase.changelog.ChangeSet            : Foreign key constraint added to podcast_episode (media_file_id)
2022-04-22 18:31:48.131  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-media-file-id-to-podcast-episode::anon ran successfully in 5ms
2022-04-22 18:31:48.136  INFO --- liquibase.changelog.ChangeSet            : Column podcast_episode.path dropped
2022-04-22 18:31:48.136  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-path-from-podcast-episode::anon ran successfully in 2ms
2022-04-22 18:31:48.141  INFO --- liquibase.changelog.ChangeSet            : Data deleted from user_rating
2022-04-22 18:31:48.141  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::clean-user-rating-for-absent-paths::anon ran successfully in 2ms
2022-04-22 18:31:48.171  INFO --- liquibase.changelog.ChangeSet            : Columns media_file_id(int) added to user_rating
2022-04-22 18:31:48.171  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-media-file-id-to-user-rating::anon ran successfully in 3ms
2022-04-22 18:31:48.175  INFO --- liquibase.changelog.ChangeSet            : Marking ChangeSet: liquibase/11.0/relative-media-file-paths.xml::populate-user-rating-media-file-id::anon ran despite precondition failure due to onFail='MARK_RAN': 
          liquibase/db-changelog.xml : Not precondition failed

2022-04-22 18:31:48.183  INFO --- liquibase.changelog.ChangeSet            : Foreign key constraint added to user_rating (media_file_id)
2022-04-22 18:31:48.183  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-user-rating-media-file-id-fk::anon ran successfully in 5ms
2022-04-22 18:31:48.193  INFO --- liquibase.changelog.ChangeSet            : Dropped constraint
2022-04-22 18:31:48.194  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-user-rating-user-fk::anon ran successfully in 8ms
2022-04-22 18:31:48.202  INFO --- liquibase.changelog.ChangeSet            : Primary key dropped from user_rating
2022-04-22 18:31:48.202  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-user-rating-path-pk::anon ran successfully in 5ms
2022-04-22 18:31:48.207  INFO --- liquibase.changelog.ChangeSet            : Column user_rating.path dropped
2022-04-22 18:31:48.207  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-path-from-user-rating::anon ran successfully in 1ms
2022-04-22 18:31:48.212  INFO --- liquibase.changelog.ChangeSet            : Data deleted from user_rating
2022-04-22 18:31:48.212  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::clean-user-rating-for-uniqueness::anon ran successfully in 2ms
2022-04-22 18:31:48.219  INFO --- liquibase.changelog.ChangeSet            : Foreign key constraint added to user_rating (username)
2022-04-22 18:31:48.219  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-user-rating-user-fk::anon ran successfully in 4ms
2022-04-22 18:31:48.255  INFO --- liquibase.changelog.ChangeSet            : Primary key added to user_rating (username,media_file_id)
2022-04-22 18:31:48.256  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-user-rating-pk::anon ran successfully in 34ms
2022-04-22 18:31:48.263  INFO --- liquibase.changelog.ChangeSet            : Data deleted from share_file
2022-04-22 18:31:48.264  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::clean-share-file-for-absent-paths::anon ran successfully in 3ms
2022-04-22 18:31:48.270  INFO --- liquibase.changelog.ChangeSet            : Columns media_file_id(int) added to share_file
2022-04-22 18:31:48.271  INFO --- liquibase.changelog.ChangeSet            : Foreign key constraint added to share_file (media_file_id)
2022-04-22 18:31:48.271  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-media-file-id-to-share-file::anon ran successfully in 4ms
2022-04-22 18:31:48.276  INFO --- liquibase.changelog.ChangeSet            : Column share_file.path dropped
2022-04-22 18:31:48.277  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-path-from-share-file::anon ran successfully in 2ms
2022-04-22 18:31:49.721  INFO --- liquibase.changelog.ChangeSet            : Columns folder_id(int) added to media_file
2022-04-22 18:31:49.721  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-folder-id-to-media-file::anon ran successfully in 1441ms
2022-04-22 18:31:49.726  INFO --- liquibase.changelog.ChangeSet            : Marking ChangeSet: liquibase/11.0/relative-media-file-paths.xml::populate-folder-id-in-media-file-for-mysql-mariadb::anon ran despite precondition failure due to onFail='MARK_RAN': 
          liquibase/db-changelog.xml : DBMS Precondition failed: expected mariadb,mysql, got hsqldb

2022-04-22 18:31:50.417  INFO --- liquibase.changelog.ChangeSet            : Marking ChangeSet: liquibase/11.0/relative-media-file-paths.xml::delete-case-sensitive-paths-in-media-file-for-not-mysql-mariadb::anon ran despite precondition failure due to onFail='MARK_RAN': 
          liquibase/db-changelog.xml : Not precondition failed

2022-04-22 18:31:52.469  INFO --- liquibase.changelog.ChangeSet            : Custom SQL executed
2022-04-22 18:31:53.074  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::populate-folder-id-in-media-file-for-not-mysql-mariadb::anon ran successfully in 2654ms
2022-04-22 18:31:54.390  INFO --- liquibase.changelog.ChangeSet            : Data deleted from media_file
2022-04-22 18:31:54.390  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::remove-media-files-with-non-existent-folders::anon ran successfully in 87ms
2022-04-22 18:31:54.445  INFO --- liquibase.changelog.ChangeSet            : Index idx_media_file_path dropped from table media_file
2022-04-22 18:31:54.446  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-uniqueness-constraint-to-media-file-path::anon ran successfully in 53ms
2022-04-22 18:31:54.451  INFO --- liquibase.changelog.ChangeSet            : Marking ChangeSet: liquibase/11.0/relative-media-file-paths.xml::drop-uniqueness-constraint-to-media-file-path-2::anon ran despite precondition failure due to onFail='MARK_RAN': 
          liquibase/db-changelog.xml : Not precondition failed

2022-04-22 18:31:56.298  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:31:57.727  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:31:58.761  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::relativize-media-file-path::anon ran successfully in 4307ms
2022-04-22 18:32:01.083  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:32:01.327  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:32:01.894  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::relativize-media-file-cover-art-path::anon ran successfully in 2169ms
2022-04-22 18:32:02.081  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:32:03.559  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:32:04.973  INFO --- liquibase.changelog.ChangeSet            : Data updated in media_file
2022-04-22 18:32:05.919  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::relativize-media-file-parent-path::anon ran successfully in 4021ms
2022-04-22 18:32:07.249  INFO --- liquibase.changelog.ChangeSet            : Index idx_media_file_folder_path created
2022-04-22 18:32:07.250  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::add-uniqueness-constraint-to-relative-media-file-path::anon ran successfully in 242ms
2022-04-22 18:32:08.578  INFO --- liquibase.changelog.ChangeSet            : Column media_file.folder dropped
2022-04-22 18:32:08.579  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::drop-folder-from-media-file::anon ran successfully in 1308ms
2022-04-22 18:32:08.586  INFO --- liquibase.changelog.ChangeSet            : Data deleted from album
2022-04-22 18:32:08.586  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::remove-albums-with-non-existent-folders::anon ran successfully in 5ms
2022-04-22 18:32:08.673  INFO --- liquibase.changelog.ChangeSet            : Data updated in album
2022-04-22 18:32:08.728  INFO --- liquibase.changelog.ChangeSet            : Data updated in album
2022-04-22 18:32:08.791  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::relativize-album-cover-art-path::anon ran successfully in 202ms
2022-04-22 18:32:08.863  INFO --- liquibase.changelog.ChangeSet            : Data updated in album
2022-04-22 18:32:08.919  INFO --- liquibase.changelog.ChangeSet            : Data updated in album
2022-04-22 18:32:08.978  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::relativize-album-path::anon ran successfully in 184ms
2022-04-22 18:32:08.984  INFO --- liquibase.changelog.ChangeSet            : Data deleted from artist
2022-04-22 18:32:08.984  INFO --- liquibase.changelog.ChangeSet            : ChangeSet liquibase/11.0/relative-media-file-paths.xml::remove-artists-with-non-existent-folders::anon ran successfully in 3ms
2022-04-22 18:32:08.989  INFO --- l.l.StandardLockService                  : Successfully released change log lock
2022-04-22 18:32:08.991  WARN --- ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'themeSource': Unsatisfied dependency expressed through method 'setSettingsService' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'settingsService': Unsatisfied dependency expressed through field 'internetRadioDao'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'internetRadioDao': Unsatisfied dependency expressed through field 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
2022-04-22 18:32:09.885 ERROR --- o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'themeSource': Unsatisfied dependency expressed through method 'setSettingsService' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'settingsService': Unsatisfied dependency expressed through field 'internetRadioDao'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'internetRadioDao': Unsatisfied dependency expressed through field 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.resolveMethodArguments(AutowiredAnnotationBeanPostProcessor.java:767) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:719) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.ui.context.support.UiApplicationContextUtils.initThemeSource(UiApplicationContextUtils.java:58) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.web.context.support.GenericWebApplicationContext.onRefresh(GenericWebApplicationContext.java:199) ~[spring-web-5.3.18.jar!/:5.3.18]
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:158) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:577) ~[spring-context-5.3.18.jar!/:5.3.18]
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:448) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:339) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:143) ~[spring-boot-2.5.12.jar!/:2.5.12]
        at org.airsonic.player.Application.main(Application.java:70) ~[classes!/:11.0.0-SNAPSHOT]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[airsonic.war:11.0.0-SNAPSHOT]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[airsonic.war:11.0.0-SNAPSHOT]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[airsonic.war:11.0.0-SNAPSHOT]
        at org.springframework.boot.loader.WarLauncher.main(WarLauncher.java:59) ~[airsonic.war:11.0.0-SNAPSHOT]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'settingsService': Unsatisfied dependency expressed through field 'internetRadioDao'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'internetRadioDao': Unsatisfied dependency expressed through field 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.resolveMethodArguments(AutowiredAnnotationBeanPostProcessor.java:759) ~[spring-beans-5.3.18.jar!/:5.3.18]
        ... 29 common frames omitted
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'internetRadioDao': Unsatisfied dependency expressed through field 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.18.jar!/:5.3.18]
        ... 43 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.18.jar!/:5.3.18]
        ... 57 common frames omitted
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:124) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Liquibase.lambda$null$0(Liquibase.java:265) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.lambda$child$0(Scope.java:177) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:186) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:176) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:155) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:240) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Liquibase.lambda$update$1(Liquibase.java:264) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.lambda$child$0(Scope.java:177) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:186) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:176) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:155) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Liquibase.runInScope(Liquibase.java:2404) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Liquibase.update(Liquibase.java:211) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Liquibase.update(Liquibase.java:197) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:314) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:269) ~[liquibase-core-4.6.2.jar!/:na]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.18.jar!/:5.3.18]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.18.jar!/:5.3.18]
        ... 69 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/11.0/relative-media-file-paths.xml::relativize-artist-cover-art-path::anon:
     Reason: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:695) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:49) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.lambda$child$0(Scope.java:177) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:186) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:176) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:155) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.lambda$child$0(Scope.java:177) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:186) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:176) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:155) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:240) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.lambda$child$0(Scope.java:177) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:186) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:176) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:155) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:240) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.Scope.child(Scope.java:244) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66) ~[liquibase-core-4.6.2.jar!/:na]
        ... 87 common frames omitted
Caused by: liquibase.exception.DatabaseException: General error [Failed SQL: (-458) UPDATE PUBLIC.artist SET cover_art_path = SUBSTR(cover_art_path, (SELECT LENGTH(music_folder.path) FROM music_folder WHERE music_folder.id = artist.folder_id) + 1) WHERE cover_art_path IS NOT NULL]
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:397) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:151) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261) ~[liquibase-core-4.6.2.jar!/:na]
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:660) ~[liquibase-core-4.6.2.jar!/:na]
        ... 107 common frames omitted
Caused by: java.sql.SQLException: General error
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar!/:na]
        at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar!/:na]
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393) ~[liquibase-core-4.6.2.jar!/:na]
        ... 112 common frames omitted
Caused by: org.hsqldb.HsqlException: General error
        at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.result.Result.newErrorResult(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.result.Result.newErrorResult(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.StatementDMQL.execute(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.Session.executeDirectStatement(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        at org.hsqldb.Session.execute(Unknown Source) ~[hsqldb-2.5.0.jar!/:2.5.0]
        ... 117 common frames omitted
 

ça recoince après mais bon !!!! lol


@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#7 Le 03/05/2022, à 20:20

jajaX

Re : [résolu] mise à jour de bdd HyperSQL de 1.8 à 2.5

résolu !!! voir ici.


@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne