Hallo,
nach einem Update versuch mit apt-get update und apt-get upgrade kommt nun beim Liveconfig start folgender Fehler:
Starting LiveConfig Server: liveconfig - /usr/sbin/liveconfig: Database connection failed: database disk image is malformed
Hallo,
nach einem Update versuch mit apt-get update und apt-get upgrade kommt nun beim Liveconfig start folgender Fehler:
Starting LiveConfig Server: liveconfig - /usr/sbin/liveconfig: Database connection failed: database disk image is malformed
- welche LiveConfig-Version? (liveconfig -v)
- welche Distribution & Version?
- was steht in /var/log/liveconfig/liveconfig.log?
Häufigster Fehler ist, dass man beim Upgrade die Konfigurationsdatei (liveconfig.conf) überschreiben lässt und somit z.B. alte/falsche Datenbankdaten gelten - prüfen Sie also bitte, ob die Einstellungen in /etc/liveconfig/liveconfig.conf noch korrekt sind.
Bei SQLite als Backend wird die Datenbank vor dem Upgrade immer gesichert (/var/lib/liveconfig/liveconfig.db.*)
Viele Grüße
-Klaus Keppler
Hallo,
Version:
Version: 1.6.4
Platform: i686-pc-linux-gnu
Revision: 2488
___________________
Debian 6 - 2.6.32-5-686-bigmem
Das ganze läuft noch über SQLite.
Woher bekomme ich die Orginale Konfigurationsdatei?
Ein Auszug der Log folgt sofort
Log:
ZitatAlles anzeigen2013/07/23 21:54:23.372139] [2085|2085] Client child process 2088 terminated; return code: 0
[2013/07/23 21:54:23.372155] [2085|2085] Resource usage statistics:
[2013/07/23 21:54:23.372160] [2085|2085] Uptime: 27411 sec.
[2013/07/23 21:54:23.372164] [2085|2085] User time: 1.0256
[2013/07/23 21:54:23.372168] [2085|2085] System time: 0.0492
[2013/07/23 21:54:23.399842] [2087|2087] Closing log file
[2013/07/23 21:54:23.400419] [2085|2085] Server child process 2087 terminated; return code: 0
[2013/07/23 21:54:23.400432] [2085|2085] Resource usage statistics:
[2013/07/23 21:54:23.400437] [2085|2085] Uptime: 27411 sec.
[2013/07/23 21:54:23.400441] [2085|2085] User time: 103.0858
[2013/07/23 21:54:23.400445] [2085|2085] System time: 4.0116
[2013/07/23 21:54:23.400451] [2085|2085] LiveConfig terminated.
[2013/07/23 21:54:23.400634] [2085|2085] Closing log file
[2013/07/23 21:54:28.870110] [3773|3773] LiveConfig 1.6.4-2488 starting...
[2013/07/23 21:54:28.870179] [3773|3773] Database driver loaded: SQLite (3.8.0)
[2013/07/23 21:54:28.875034] [3773|3773] Upgrading database schema (r2358 -> r2388)
[2013/07/23 21:54:28.885487] [3773|3773] Upgrading database schema (r2388 -> r2389)
[2013/07/23 21:54:28.888421] [3773|3773] Upgrading database schema (r2389 -> r2425)
[2013/07/23 21:54:28.891788] [3773|3773] Upgrading database schema (r2425 -> r2451)
[2013/07/23 21:54:28.895655] [3773|3773] Upgrading database schema (r2451 -> r2454)
[2013/07/23 21:54:28.898455] [3773|3773] Upgrading database schema (r2454 -> r2455)
[2013/07/23 21:54:28.995994] [3773|3773] Database connection failed: database disk image is malformed
[2013/07/23 21:54:28.996058] [3773|3773] Closing log file
[2013/07/23 21:54:58.314932] [3903|3903] LiveConfig 1.6.4-2488 starting...
[2013/07/23 21:54:58.319033] [3903|3903] Database driver loaded: SQLite (3.8.0)
[2013/07/23 21:54:58.327807] [3903|3903] Upgrading database schema (r2454 -> r2455)
[2013/07/23 21:54:58.530330] [3903|3903] Database connection failed: database disk image is malformed
[2013/07/23 21:54:58.530386] [3903|3903] Closing log file
[2013/07/23 21:58:07.510613] [4588|4588] LiveConfig 1.6.4-2488 starting...
[2013/07/23 21:58:07.510687] [4588|4588] Database driver loaded: SQLite (3.8.0)
[2013/07/23 21:58:07.521667] [4588|4588] Upgrading database schema (r2454 -> r2455)
[2013/07/23 21:58:07.659863] [4588|4588] Database connection failed: database disk image is malformed
[2013/07/23 21:58:07.659925] [4588|4588] Closing log file
[2013/07/23 21:58:50.520179] [4788|4788] LiveConfig 1.6.4-2488 starting...
[2013/07/23 21:58:50.520253] [4788|4788] Database driver loaded: SQLite (3.8.0)
[2013/07/23 21:58:50.525030] [4788|4788] Upgrading database schema (r2454 -> r2455)
[2013/07/23 21:58:50.624672] [4788|4788] Database connection failed: database disk image is malformed
[2013/07/23 21:58:50.624734] [4788|4788] Closing log file
[2013/07/23 21:59:35.908179] [4959|4959] LiveConfig 1.6.4-2488 starting...
[2013/07/23 21:59:35.908250] [4959|4959] Database driver loaded: SQLite (3.8.0)
[2013/07/23 21:59:35.913038] [4959|4959] Upgrading database schema (r2454 -> r2455)
[2013/07/23 21:59:36.011818] [4959|4959] Database connection failed: database disk image is malformed
[2013/07/23 21:59:36.011874] [4959|4959] Closing log file
[2013/07/23 22:07:49.269273] [6569|6569] LiveConfig 1.6.4-2488 starting...
[2013/07/23 22:07:49.269357] [6569|6569] Database driver loaded: SQLite (3.8.0)
[2013/07/23 22:07:49.274421] [6569|6569] Upgrading database schema (r2454 -> r2455)
[2013/07/23 22:07:49.373494] [6569|6569] Database connection failed: database disk image is malformed
[2013/07/23 22:07:49.373559] [6569|6569] Closing log file
[2013/07/23 22:15:46.177150] [7757|7757] LiveConfig 1.6.4-2488 starting...
[2013/07/23 22:15:46.177255] [7757|7757] Database driver loaded: SQLite (3.8.0)
[2013/07/23 22:15:46.182431] [7757|7757] Upgrading database schema (r2454 -> r2455)
[2013/07/23 22:15:46.283381] [7757|7757] Database connection failed: database disk image is malformed
[2013/07/23 22:15:46.283450] [7757|7757] Closing log file
[2013/07/23 22:18:35.289216] [8114|8114] LiveConfig 1.6.4-2488 starting...
[2013/07/23 22:18:35.289326] [8114|8114] Database driver loaded: SQLite (3.8.0)
[2013/07/23 22:18:35.294461] [8114|8114] Upgrading database schema (r2454 -> r2455)
[2013/07/23 22:18:35.395559] [8114|8114] Database connection failed: database disk image is malformed
[2013/07/23 22:18:35.395627] [8114|8114] Closing log file
Die Config ist denke ich mal auch richtig:
# SQLite example:
db_driver = sqlite
db_name = /var/lib/liveconfig/liveconfig.db
Ich habe eben mal nachgesehen was beim Upgrade auf r2455 passiert - da wird lediglich der Befehl "ANALYZE" auf der SQLite-Datenbank ausgeführt.
In Ihrem Fall ist also offenbar die SQLite-Datenbank korrupt (wurde der Server evtl. mal irgendwann "ausgeschaltet"? Stromverlust? Festplatte voll?)
Zum Reparieren gehen Sie bitte wie folgt vor:
root@xxx:/root# [B]sqlite3 /var/lib/liveconfig/liveconfig.db
[/B]SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> [B].mode insert[/B]
sqlite> [B].output /root/liveconfig.dump.sql[/B]
sqlite> [B].dump[/B]
sqlite> [B].exit[/B]
root@xxx:/root#
cd /var/lib/liveconfig
mv liveconfig.db liveconfig.db.OLD
sqlite3 liveconfig.db </root/liveconfig.dump.sql
Viele Grüße
-Klaus Keppler
Hallo,
zuerst einmal BESTEN DANK! Es hat funktioniert. Jedoch ist Liveconfig also xxxx.de:8443 nicht erreichbar. Satrten tut er jedoch vernünftig den Liveconfig Server.
Im Log steht:
[2013/07/23 23:11:09.106527] [16554|16554] ERROR: Releasing db connection, but still have open statements
[2013/07/23 23:11:46.379085] [17653|17653] Error while creating server child process - aborting...
Im Log müsste noch ein bisschen mehr stehen als diese zwei Zeilen... bitte geben Sie alles an, was ab dem LiveConfig-Start ins Log geschrieben wird.
Hallo,
hier der Auszug
ZitatAlles anzeigen[2013/07/23 23:42:14.101593] [22620|22620] LiveConfig 1.6.4-2488 starting...
[2013/07/23 23:42:14.101677] [22620|22620] Database driver loaded: SQLite (3.8.0)
[2013/07/23 23:42:14.107468] [22620|22620] License is valid.
[2013/07/23 23:42:14.110824] [22625|22625] Client child started...
[2013/07/23 23:42:14.112492] [22624|22624] Server child started...
[2013/07/23 23:42:14.129922] [22624|22624] ERROR: Releasing db connection, but still have open statements
[2013/07/23 23:42:14.129947] [22624|22624] aborting SQL: 'UPDATE SERVERS SET SRV_CONNECTTS= NULL'
[2013/07/23 23:42:14.129964] [22624|22624] UNCAUGHT DATABASE EXCEPTION: 'attempt to write a readonly database'
[2013/07/23 23:42:14.129976] [22624|22624] euid=111, egid=114
[2013/07/23 23:42:14.143054] [22621|22621] Server child process 22624 terminated; return code: 77
[2013/07/23 23:42:14.143074] [22621|22621] Resource usage statistics:
[2013/07/23 23:42:14.143079] [22621|22621] Uptime: 0 sec.
[2013/07/23 23:42:14.143083] [22621|22621] User time: 0.0008
[2013/07/23 23:42:14.143087] [22621|22621] System time: 0.0000
[2013/07/23 23:42:14.143091] [22621|22621] Error while creating server child process - aborting...
[2013/07/23 23:42:14.204664] [22625|22628] [LUA] Detected 'Debian GNU/Linux 6.0.7 (squeeze)'
[2013/07/23 23:42:14.334472] [22625|22625] Client child terminating... (shutdown=0, exitcode=0)
[2013/07/23 23:42:14.334748] [22625|22625] LiveConfig terminated.
[2013/07/23 23:42:14.334805] [22625|22625] Closing log file
[2013/07/23 23:42:14.335299] [22621|22621] Client child process 22625 terminated; return code: 0
[2013/07/23 23:42:14.335314] [22621|22621] Resource usage statistics:
[2013/07/23 23:42:14.335318] [22621|22621] Uptime: 0 sec.
[2013/07/23 23:42:14.335322] [22621|22621] User time: 0.0160
[2013/07/23 23:42:14.335326] [22621|22621] System time: 0.0036
[2013/07/23 23:42:14.335336] [22621|22621] LiveConfig terminated.
[2013/07/23 23:42:14.335549] [22621|22621] Closing log file
Habe schon versucht: http://www.liveconfig.com/de/h…oubleshooting.server.html
Jedoch erscheint bei liveconfig -s leider
ZitatCan't get shared memory segment: No such file or directory
Server not running?
chown liveconfig:liveconfig /var/lib/liveconfig/liveconfig.db
chmod 600 /var/lib/liveconfig/liveconfig.db
Wahnsinn! Klappt! Herzlichen Dank für den späten Support. Da weiß man, warum man als Verwaltungspanel Liveconfig einsetzt!
DICKES DANKESCHÖN!
Hallo,
manchmal sind keine Dienste erreichbar, in der Konsole erscheint dann folgendes:
INFO: task php-cgi:21954 blocked for more than 120 seconds.
"echo 0 > /proc/sys/kernel/hung_task_timeout_secs" disables this message.
Nach einem Restart geht alles wieder. Das passiert mindestens 3 mal in der Woche.
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!