Nach update auf 19.02 Instanz startet nicht

Hallo Community,

nun sollte es bei auch soweit sein. Ich wollte meine 17.12 auf die 19.02 updaten.
Also wie in der Doku beschrieben eine neue VM erzeugt und die 19.02 dort installiert.
Als nächstes habe ich das Datenbankbackup der 17.12 hochgeladen und die Instanz startet nicht. Es kommt auch noch nach Stunden die Meldung “Telefonsystem startet”. Also update auf 19.02 abgebrochen und die 18.12 in die neue VM installiert. Dann habe ich hier das Backup hochgeladen und die Anlage funktioniert, wie erwartet. Als 2. Schritt habe ich dann die 18.12 auf 19.02 upgedatet. Mit dem selben Ergebnis, das die Instanz nicht mehr startet. Auch wenn ich beim Start der VM die 18.12 auswähle und hochfahre startet meine Instanz nicht mehr. Hat einer eine Idee, wie ich halbwegs tracen kann, warum die Instanz nicht startet.

LG Maik

Hallo Maik,

bitte Folgendes machen:

# Per ssh auf dem system einloggen
ssh admin@ip_meiner_anlage

# root werden
sudo -s

# lxc-container betreten. Containername = Instanzname
lxc-attach -n meineanlage

# Logfiles checken
cd /var/log/pascom/migration
ls -ltr

cd /var/log/jobs/
ls -ltr

Hier solltest Du dann logs mit Fehlermeldungen finden die Du hier posten kannst.

LG
Mathias

Hallo Mathias,
in /var/log/migration/1575728590_md-cmd.log

2019-12-07 15:23:10 sql info : Connecting to database
2019-12-07 15:23:10 migration info : Starting Migration for Package md-cmd
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71712_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71711_01.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71711_01.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71712_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_01.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_01.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_01.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_02.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_02.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_10.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_10.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_10.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_20.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_20.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_20.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_22.php]
2019-12-07 15:23:10 md_cmd_71800_22 info : Delete tables for cluster support
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_22.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_22.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_25.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_25.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_25.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_29.php]
2019-12-07 15:23:10 md_cmd_71800_29 info : Add system setting for transit networks
2019-12-07 15:23:10 md_cmd_71800_29 info : Add new device family for VPN Access
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_29.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_29.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_30.php]
2019-12-07 15:23:10 md_cmd_71800_30 info : Remove field from table role
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_30.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_30.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_31.php]
2019-12-07 15:23:10 md_cmd_71800_31 info : Delete tables of billing system
2019-12-07 15:23:10 md_cmd_71800_31 info : Remove roletype of billing system
2019-12-07 15:23:10 md_cmd_71800_31 info : Delete tables of reporting system
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_31.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_31.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_32.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_32.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_32.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_33.php]
2019-12-07 15:23:10 md_cmd_71800_33 info : current codecs: alaw ulaw gsm h264
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_33.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_33.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_34.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_34.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_34.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_35.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_35.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_35.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_36.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_36.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_36.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_37.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_37.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_37.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_40.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_40.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_40.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_45.php]
2019-12-07 15:23:11 md_cmd_71800_45 info : No beronet gateways found, nothing to do.
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_45.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_45.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_46.php]
2019-12-07 15:23:11 md_cmd_71800_46 info : Cleanup device families
2019-12-07 15:23:11 md_cmd_71800_46 info : Dropping patton table
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_46.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_46.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_50.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_50.php] was successfull (SKIPPED)
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_50.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_51.php]
2019-12-07 15:23:11 md_cmd_71800_51 info : extend table 072mobile
2019-12-07 15:23:11 md_cmd_71800_51 info : set gsm only mode to [f]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_51.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_51.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_55.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_55.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_55.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_56.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_56.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_56.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71800_57.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71800_57.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_57.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71801_01.php]
2019-12-07 15:23:11 md_cmd_71801_01 info : Remove all flex panels
2019-12-07 15:23:11 migration info : Step [md_cmd_71801_01.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71801_01.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71801_05.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71801_05.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71801_05.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71801_06.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71801_06.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71801_06.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71802_01.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71802_01.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71802_01.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71803_01.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71803_01.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71803_01.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71803_02.php]
2019-12-07 15:23:11 md_cmd_71803_02 info : Extending table 064role
2019-12-07 15:23:11 md_cmd_71803_02 info : Extending table 064role
2019-12-07 15:23:11 md_cmd_71803_02 info : Insert new “default” role
2019-12-07 15:23:11 md_cmd_71803_02 info : Make “All Users” role deletable
2019-12-07 15:23:11 migration info : Step [md_cmd_71803_02.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71803_02.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71803_10.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71803_10.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71803_10.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71803_11.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71803_11.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71803_11.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71805_01.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71805_01.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71805_01.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71805_02.php]
2019-12-07 15:23:11 migration info : Step [md_cmd_71805_02.php] was successfull
2019-12-07 15:23:11 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71805_02.php] (a)
2019-12-07 15:23:11 migration info : Next Step is [md_cmd_71806_01.php]
2019-12-07 15:23:10 sql info : Connecting to database
2019-12-07 15:23:10 migration info : Starting Migration for Package md-cmd
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71712_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71711_01.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71711_01.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71712_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_01.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_01.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_01.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_02.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_02.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_02.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_10.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_10.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_10.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_20.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_20.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_20.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_22.php]
2019-12-07 15:23:10 md_cmd_71800_22 info : Delete tables for cluster support
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_22.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_22.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_25.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_25.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_25.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_29.php]
2019-12-07 15:23:10 md_cmd_71800_29 info : Add system setting for transit networks
2019-12-07 15:23:10 md_cmd_71800_29 info : Add new device family for VPN Access
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_29.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_29.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_30.php]
2019-12-07 15:23:10 md_cmd_71800_30 info : Remove field from table role
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_30.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_30.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_31.php]
2019-12-07 15:23:10 md_cmd_71800_31 info : Delete tables of billing system
2019-12-07 15:23:10 md_cmd_71800_31 info : Remove roletype of billing system
2019-12-07 15:23:10 md_cmd_71800_31 info : Delete tables of reporting system
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_31.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_31.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_32.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_32.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_32.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_33.php]
2019-12-07 15:23:10 md_cmd_71800_33 info : current codecs: alaw ulaw gsm h264
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_33.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_33.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_34.php]
2019-12-07 15:23:10 migration info : Step [md_cmd_71800_34.php] was successfull
2019-12-07 15:23:10 migration info : Skipping ancient script [md_cmd_71107_01.php] because we started migration at [md_cmd_71800_34.php] (a)
2019-12-07 15:23:10 migration info : Next Step is [md_cmd_71800_35.php]
:

in /var/logs/jobs/… kommt folgende Meldung

2019-12-07 15:23:10 tsk050399 info : Migrate database
2019-12-07 15:23:10 tsk050399 info : . Starte [/var/www/mobydickcmd//script/mdc_migrate.php md-cmd]
2019-12-07 15:23:12 tsk050399 info : . Exit: [255]
2019-12-07 15:23:12 tsk050399 error : Migration failed: md-cmd

Ich hoffe dies hilft weiter…

LG Maik

Hallo @maik

leider sieht man nur, dass was falsch läuft aber nicht genau was. Kannst du uns das Backup zur Verfügung stellen? Z.B. per Wetransfer ?

LG
Mathias

Hallo @Mathias,

habe Dir eine PM (Forum) gesendet.

LG Maik

Hallo @maik,

eine der Avatar VCards ist kaputt. In 19 gibt es keine VCards mehr. Das Fehlerhandling bei der Migration ist lückenhaft und bricht in dieser Situation ab.

Wir werden das mit einer der nächsten 19er Versionen fixen, aber Du kannst das auch jetzt schon machen.

Logge Dich auf der laufenden Anlage ein und lösche in der DB die vcards (ich nehme an 18 im Moment):

# Per ssh auf dem system einloggen
ssh admin@ip_meiner_anlage

# root werden
sudo -s

# lxc-container betreten. Containername = Instanzname
lxc-attach -n meineanlage

# DB namen, user und passwort herausfinden: private.db.name, private.db.user, passtxt
cat /etc/pascom/settings.properties

# In Datenbak einloggen wobei Du name und user mit den ermittelten Werten ersetzt:
psql -h pg.lxc name user

# Query absetzen
delete from ofvcard

LG
Mathias

Hallo Mathias,

danke für deine Hilfe. Momentan läuft noch die 17.12. Kannst Du für die 17.12 den Datenbank delete query geben ?. Falls zu Aufwendig, migriere ich erst zur 18.12 und dann weiter.

Vielen Dank

Maik

Hallo Maik,

sollte die selbe sein.

LG
Mathias

@Mathias vielen Dank… Jetzt hat die Datenübernahme von 17.12 zu 19.02 funktioniert. Dann kann und werde ich am WE weiter ausgiebig testen.

LG Maik