[Digikam-devel] [digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
uwe.haider at gmx.net
uwe.haider at gmx.net
Wed Sep 3 21:34:20 BST 2014
https://bugs.kde.org/show_bug.cgi?id=329091
uwe.haider at gmx.net changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|WAITINGFORINFO |---
Status|RESOLVED |UNCONFIRMED
--- Comment #4 from uwe.haider at gmx.net ---
ok, updated to digikam 4.2 and tested again...
First run of maintenance crashed again, but digikam was compiled without
USE=debug so there was not enough info for drkonqi. I compiled digikam again
with USE=debug and tested again -> no crash?!!
I have started digikam in terminal, so here is the last output:
digikam(21239)/digikam (core) Digikam::ThumbnailCreator::createThumbnail:
Cannot create thumbnail for
"/home/uhai/Fotos/Webseiten/backup_1_0_13/templates/rhuk_solarflare_ii/images/header_short.jpg"
digikam(21239)/digikam (core) Digikam::ThumbnailCreator::load: Thumbnail is
null for
"/home/uhai/Fotos/Webseiten/backup_1_0_13/templates/rhuk_solarflare_ii/images/header_short.jpg"
digikam(21239)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(21239)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"SELECT modificationDate, fileSize, uniqueHash FROM Images WHERE id=?;"
Error messages: "QMYSQL3: Anweisung kann nicht vorbereitet werden" "MySQL
server has gone away" 2006 2
Bound values: ()
digikam(21239)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(21239)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"SELECT id, type, modificationDate, orientationHint, data FROM UniqueHashes
INNER JOIN Thumbnails ON thumbId = id WHERE uniqueHash=? AND fileSize=?;"
Error messages: "QMYSQL3: Anweisung kann nicht vorbereitet werden" "MySQL
server has gone away" 2006 2
Bound values: ()
digikam(21239)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(21239)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"SELECT modificationDate, fileSize, uniqueHash FROM Images WHERE id=?;"
Error messages: "QMYSQL3: Anweisung kann nicht vorbereitet werden" "MySQL
server has gone away" 2006 2
Bound values: ()
digikam(21239)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(21239)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"SELECT id, type, modificationDate, orientationHint, data FROM UniqueHashes
INNER JOIN Thumbnails ON thumbId = id WHERE uniqueHash=? AND fileSize=?;"
Error messages: "QMYSQL3: Anweisung kann nicht vorbereitet werden" "MySQL
server has gone away" 2006 2
Bound values: ()
Digikam was still running after that and shows no more active jobs...
Two additional infos:
1) My collection is on an external USB-Drive with 320 GB with no space left. I
will try a new solution (NAS-Server)
2) Every maintenance-job is running a few hours... It tooks time to test -
please stand by :-)
------
This are the components after the update:
digiKam version 4.2.0
Exiv2 kann in JP2 speichern: Ja
Exiv2 kann in JPEG speichern: Ja
Exiv2 kann in PGF speichern: Ja
Exiv2 kann in PNG speichern: Ja
Exiv2 kann in TIFF speichern: Ja
Exiv2 unterstützt XMP-Metadaten: Ja
LibCImg: 130
LibEigen: 3.0.6
LibExiv2: 0.23
LibJPEG: 62
LibJasper: 1.900.1
LibKDE: 4.12.5
LibKExiv2: 2.3.1
LibKGeoMap: 2.0.0
LibKdcraw: 2.4.2
LibLCMS: 2050
LibLensFun: 0.2.8-0
LibPGF: 6.12.27 - Externe gemeinsame Bibliothek
LibPNG: 1.6.12
LibQt: 4.8.5
LibRaw: 0.15.4
LibTIFF: LIBTIFF, Version 4.0.3 Copyright (c) 1988-1996 Sam Leffler Copyright
(c) 1991-1996 Silicon Graphics, Inc.
Marble-Funktion: 0.17.0 (stable version)
Parallelisierte PGF-Codecs: Keine
Parallelisiertes Entfernen von Mosaikmustern: Unbekannt
Prozessorkerne: 4
Unterstützung für Demosaic GPL2: Unbekannt
Unterstützung für Demosaic GPL3: Unbekannt
Unterstützung von RawSpeed-Codec: Unbekannt
Datenbanktreiber: QMYSQL
Interner Datenbank-Server:: Keine
KIPI-Module: 3.5.0
LibGphoto2: 2.5.4
LibKface: 3.0.0
LibKipi: 2.1.0
LibOpenCV: 2.4.5
-----
Some more facts to my collections:
digiKam version 4.2.0
Bilder:
BMP: 20
GIF: 4036
JP2: 758
JPG: 45679
PCX: 5
PNG: 41745
PPM: 40
RAW-DNG: 2235
RAW-NEF: 8033
TIFF: 3496
XCF: 335
Gesamt: 106382
:
:
Videos:
3GP: 3
AVI: 130
MOV: 178
MP4: 6
MPEG: 26
Gesamt: 343
:
Audio:
MP3: 159
OGG: 39
WAV: 24
Gesamt: 222
:
Gesamtzahl der Einträge: 106947
Alben: 13094
Stichwörter: 656
Datenbanktreiber: QMYSQL
Interner Datenbank-Server:: Keine
-------
Some info to my gentoo (emerge -info)
Portage 2.2.8-r1 (default/linux/amd64/13.0/desktop, gcc-4.7.3, glibc-2.19-r1,
3.14.14-gentooy x86_64)
=================================================================
System uname:
Linux-3.14.14-gentooy-x86_64-AMD_Phenom-tm-_II_X4_945_Processor-with-gentoo-2.2
KiB Mem: 16435256 total, 2520984 free
KiB Swap: 17414456 total, 16775396 free
Timestamp of tree: Wed, 03 Sep 2014 18:45:01 +0000
ld GNU ld (GNU Binutils) 2.23.2
ccache version 3.1.9 [enabled]
app-shells/bash: 4.2_p45
dev-java/java-config: 2.2.0
dev-lang/python: 2.7.7, 3.3.5-r1
dev-util/ccache: 3.1.9-r3
dev-util/cmake: 2.8.12.2-r1
dev-util/pkgconfig: 0.28-r1
sys-apps/baselayout: 2.2
sys-apps/openrc: 0.12.4
sys-apps/sandbox: 2.6-r1
sys-devel/autoconf: 2.13, 2.69
sys-devel/automake: 1.11.6, 1.12.6, 1.14.1
sys-devel/binutils: 2.23.2
sys-devel/gcc: 4.6.4, 4.7.3-r1
sys-devel/gcc-config: 1.7.3
sys-devel/libtool: 2.4.2-r1
sys-devel/make: 3.82-r4
sys-kernel/linux-headers: 3.16 (virtual/os-headers)
sys-libs/glibc: 2.19-r1
Repositories: gentoo kde x-overlay
Installed sets: @kde-4.12
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="* - at EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe -ggdb"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib64/fax /usr/share/config
/usr/share/gnupg/qualified.txt /var/lib/hsqldb /var/spool/fax/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d
/etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release
/etc/php/apache2-php5.5/ext-active/ /etc/php/cgi-php5.5/ext-active/
/etc/php/cli-php5.5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d
/etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d
/etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-march=native -O2 -pipe -ggdb"
DISTDIR="/usr/portage/distfiles"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs ccache config-protect-if-modified
distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs
protect-owned sandbox sfperms splitdebug strict unknown-features-warn
unmerge-logs unmerge-orphans userpriv usersandbox usersync"
FFLAGS="-O2 -pipe"
GENTOO_MIRRORS="http://distfiles.gentoo.org/"
LANG="de_DE.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times
--omit-dir-times --compress --force --whole-file --delete --stats
--human-readable --timeout=180 --exclude=/distfiles --exclude=/local
--exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/var/lib/layman/kde /usr/local/portage/overlay"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="3dnow X a52 aac acl acpi akonadi alsa amd64 apache2 avi berkdb bluetooth
branding bzip2 cairo cdda cddb cdr cleartype cli corefonts cracklib crypt cups
cxx dbus dga divx dts dv dvd dvdr dvdread emboss encode exif fam fame ffmpeg
firefox flac fortran gdbm gif gphoto2 gpm gps gtk gudev iconv introspection
ipv6 java java6 javascript jpeg jpeg2k lcms ldap libnotify lm_sensors mad midi
mjpeg mmx mng modules mp3 mp4 mpeg msn multilib ncurses networkmanager nls nptl
nvidia ogg opengl openmp pam pango pcre pda pdf phonon png policykit ppds
python qt3support qt4 quicktime raw readline scanner sdl semantic-desktop
session smp spell sql sse sse2 ssl startup-notification subtitles svg syslog
systemd tcpd threads tiff timidity truetype type1 udev udisks unicode upower
usb v4l v4l2 vcd vorbis wavpack win32codecs wmf wxwidgets x264 xcb xine xml xpm
xv xvid zlib" ABI_X86="64" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem
bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel
intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci"
APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias
auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm
authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache
cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter
file_cache filter headers include info log_config logio mem_cache mime
mime_magic negotiation rewrite setenvif speling status unique_id userdir
usertrack vhost_alias" CALLIGRA_FEATURES="kexi words flow plan sheets stage
tables krita karbon braindump author" CAMERAS="ptp2" COLLECTD_PLUGINS="df
interface irq load memory rrdtool swap syslog" ELIBC="glibc"
GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock
itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3
sirf superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="evdev wacom"
KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001
mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console
presenter-minimizer" LINGUAS="de" OFFICE_IMPLEMENTATION="libreoffice"
PHP_TARGETS="php5-5" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7
python3_3" RUBY_TARGETS="ruby19 ruby20" USERLAND="GNU" VIDEO_CARDS="nvidia"
XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface
geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac
delude chaos account"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL,
PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS,
PORTAGE_RSYNC_EXTRA_OPTS, USE_PYTHON
BTW: I got some trouble with my perl-installation. Maybe??
--------
Got some trouble with kipi-plugins
blending to HDR opens many windows, every new blending starts more windows and
always with an error "could not safe". In fact the HDR is saved - just curios.
Making panoramas seems to start hugin but gets never to an end. After three
days for an panorama with 24 pictures (made with nodal adapter) I stopped it...
No idea what's the problem, starting hugin separately works fine.. for this I
used my HDD, not the external USB_Drive (without free space).
That's all. If you miss some more detailed infos please don't hesitate to ask.
I just don't know what to tell....
Next 10 days I'm on tour. After that I will try maintenance again.
Thanks so much for your help and patience
Uwe
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Digikam-devel
mailing list