Pages : 1
#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 
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
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
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 !!!! 
@+
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
Pages : 1