Skip to content

Instantly share code, notes, and snippets.

@sergeibelov113

sergeibelov113/gist:9a9cdd2f3a1d673fc5d6fea3db66aa0e Secret

Created December 13, 2023 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sergeibelov113/9a9cdd2f3a1d673fc5d6fea3db66aa0e to your computer and use it in GitHub Desktop.
Save sergeibelov113/9a9cdd2f3a1d673fc5d6fea3db66aa0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
liquibase update --changelog-file=dev.sql
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 14:08:49 (version 4.25.0 #3966 built at 2023-11-10 23:07:29 UTC)
Liquibase Version: 4.25.0
Liquibase Open Source 4.25.0 by Liquibase
Running Changeset: dev.sql::1702472324189-1::lightsaber
Running Changeset: dev.sql::1702472324189-2::lightsaber
Running Changeset: dev.sql::1702472324189-3::lightsaber
Running Changeset: dev.sql::1702472324189-4::lightsaber
UPDATE SUMMARY
Run: 5
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 5
Unexpected error running Liquibase: Migration failed for changeset dev.sql::1702472324189-4::lightsaber:
Reason: liquibase.exception.DatabaseException: ERROR: relation "core.ausschlusszeit_allgemein" does not exist
Position: 337 [Failed SQL: (0) CREATE VIEW "audit"."tabellen_stats_core" AS SELECT combined_data.name,
combined_data.anzahl_zeilen,
combined_data.letzte_aenderung
FROM ( SELECT 'core.ausschlusszeit_allgemein'::text AS name,
count(*) AS anzahl_zeilen,
max(ausschlusszeit_allgemein.load_timestamp) AS letzte_aenderung
FROM core.ausschlusszeit_allgemein
WHERE ((ausschlusszeit_allgemein.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.bridge_lehrgang_fachsemester'::text AS name,
count(*) AS anzahl_zeilen,
max(bridge_lehrgang_fachsemester.load_timestamp) AS letzte_aenderung
FROM core.bridge_lehrgang_fachsemester
UNION ALL
SELECT 'core.fachsemester'::text AS name,
count(*) AS anzahl_zeilen,
max(fachsemester.load_timestamp) AS letzte_aenderung
FROM core.fachsemester
UNION ALL
SELECT 'core.growslots'::text AS name,
count(*) AS anzahl_zeilen,
max(growslots.load_timestamp) AS letzte_aenderung
FROM core.growslots
UNION ALL
SELECT 'core.hochschulbereich'::text AS name,
count(*) AS anzahl_zeilen,
max(hochschulbereich.load_timestamp) AS letzte_aenderung
FROM core.hochschulbereich
UNION ALL
SELECT 'core.hochschulzentrum'::text AS name,
count(*) AS anzahl_zeilen,
max(hochschulzentrum.load_timestamp) AS letzte_aenderung
FROM core.hochschulzentrum
UNION ALL
SELECT 'core.institut'::text AS name,
count(*) AS anzahl_zeilen,
max(institut.load_timestamp) AS letzte_aenderung
FROM core.institut
UNION ALL
SELECT 'core.kalender'::text AS name,
count(*) AS anzahl_zeilen,
max(kalender.load_timestamp) AS letzte_aenderung
FROM core.kalender
UNION ALL
SELECT 'core.lehrende_zeiten_temp'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrende_zeiten_temp.load_timestamp) AS letzte_aenderung
FROM core.lehrende_zeiten_temp
UNION ALL
SELECT 'core.lehrender'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrender.load_timestamp) AS letzte_aenderung
FROM core.lehrender
WHERE ((lehrender.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrender_abwesenheit'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrender_abwesenheit.load_timestamp) AS letzte_aenderung
FROM core.lehrender_abwesenheit
WHERE ((lehrender_abwesenheit.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrender_ausschluss'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrender_ausschluss.load_timestamp) AS letzte_aenderung
FROM core.lehrender_ausschluss
WHERE ((lehrender_ausschluss.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrender_einsatz'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrender_einsatz.load_timestamp) AS letzte_aenderung
FROM core.lehrender_einsatz
WHERE ((lehrender_einsatz.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrender_faecher'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrender_faecher.load_timestamp) AS letzte_aenderung
FROM core.lehrender_faecher
WHERE ((lehrender_faecher.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrgaenge_zeiten_temp'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgaenge_zeiten_temp.load_timestamp) AS letzte_aenderung
FROM core.lehrgaenge_zeiten_temp
UNION ALL
SELECT 'core.lehrgang'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang.load_timestamp) AS letzte_aenderung
FROM core.lehrgang
WHERE ((lehrgang.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrgang_kooperationspartner'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_kooperationspartner.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_kooperationspartner
UNION ALL
SELECT 'core.lehrgang_planungsregeln'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_planungsregeln.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_planungsregeln
WHERE ((lehrgang_planungsregeln.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.lehrgang_produktart'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_produktart.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_produktart
UNION ALL
SELECT 'core.lehrgang_produktgruppe'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_produktgruppe.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_produktgruppe
UNION ALL
SELECT 'core.lehrgang_produktkuerzel'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_produktkuerzel.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_produktkuerzel
UNION ALL
SELECT 'core.lehrgang_produkttyp'::text AS name,
count(*) AS anzahl_zeilen,
max(lehrgang_produkttyp.load_timestamp) AS letzte_aenderung
FROM core.lehrgang_produkttyp
UNION ALL
SELECT 'core.modul'::text AS name,
count(*) AS anzahl_zeilen,
max(modul.load_timestamp) AS letzte_aenderung
FROM core.modul
WHERE ((modul.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.semester'::text AS name,
count(*) AS anzahl_zeilen,
max(semester.load_timestamp) AS letzte_aenderung
FROM core.semester
UNION ALL
SELECT 'core.studiengang'::text AS name,
count(*) AS anzahl_zeilen,
max(studiengang.load_timestamp) AS letzte_aenderung
FROM core.studiengang
UNION ALL
SELECT 'core.tageszeitinfo'::text AS name,
count(*) AS anzahl_zeilen,
max(tageszeitinfo.load_timestamp) AS letzte_aenderung
FROM core.tageszeitinfo
UNION ALL
SELECT 'core.verlaufsplan'::text AS name,
count(*) AS anzahl_zeilen,
max(verlaufsplan.load_timestamp) AS letzte_aenderung
FROM core.verlaufsplan
WHERE ((verlaufsplan.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.zeitmodell_allgemein'::text AS name,
count(*) AS anzahl_zeilen,
max(zeitmodell_allgemein.load_timestamp) AS letzte_aenderung
FROM core.zeitmodell_allgemein
UNION ALL
SELECT 'core.zeitmodell_blockzeiten'::text AS name,
count(*) AS anzahl_zeilen,
max(zeitmodell_blockzeiten.load_timestamp) AS letzte_aenderung
FROM core.zeitmodell_blockzeiten
WHERE ((zeitmodell_blockzeiten.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.zeitmodell_time_slots'::text AS name,
count(*) AS anzahl_zeilen,
max(zeitmodell_time_slots.load_timestamp) AS letzte_aenderung
FROM core.zeitmodell_time_slots
WHERE ((zeitmodell_time_slots.transfer_operation_name)::text <> 'Delete'::text)
UNION ALL
SELECT 'core.zentrale_virtuelle_produkte'::text AS name,
count(*) AS anzahl_zeilen,
max(zentrale_virtuelle_produkte.load_timestamp) AS letzte_aenderung
FROM core.zentrale_virtuelle_produkte) combined_data
ORDER BY combined_data.name]
For more information, please use the --log-level flag
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment