Package: libdbd-sqlite3
Version: 0.8.2-1-4.1+b1
Severity: important
Tags: upstream
The version of libdbi-drivers (and, ultimately, libdbi) that is in Debian is
very old. Recently rrdtool released addon support for using dbi to query a
sql database rather than RRD files to generate a graph.
The following shell script demonstrates the problem. Under libdbi and
libdbi-drivers v0.8.2/0.8.2-1, this segfaults, but if the package is rebuilt
with v0.8.3 of those libraries/drivers, the graph is generated correctly.
#!/bin/sh
DB=test.db
echo 'create table foo_measures (tstamp int, value decimal(10,3));' | sqlite3
$DB
cmds=<<EOF
insert into foo_measures values (strftime('%s','now'),100.7);
insert into foo_measures values (strftime('%s','now'),100.7);
insert into foo_measures values (strftime('%s','now'),100.7);
insert into foo_measures values (strftime('%s','now') - 300,105.3);
insert into foo_measures values (strftime('%s','now') - 300,105.3);
insert into foo_measures values (strftime('%s','now') - 300,105.3);
EOF
echo $cmds | sqlite3 $DB
DS_BASE="sql//sqlite3/dbname=$DB//RRDValue/tstamp/value/1=1"
rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000
--height=600 \
"DEF:min=$DS_BASE:min:AVERAGE" \
"LINE1:min#FF0000:value" \
"DEF:avg=$DS_BASE:avg:AVERAGE" \
"LINE1:avg#00FF00:average" \
"DEF:max=$DS_BASE:max:AVERAGE" \
"LINE1:max#FF0000:max" \
"DEF:sigma=$DS_BASE:sigma:AVERAGE" \
"CDEF:upper=avg,4,sigma,*,+" \
"LINE1:upper#0000FF:+4 sigma" \
"CDEF:lower=avg,4,sigma,*,-" \
"LINE1:lower#0000FF:-4 sigma"
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-trunk-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages libdbd-sqlite3 depends on:
ii libc6 2.11.2-2 Embedded GNU C Library: Shared lib
ii libdbi0 0.8.2-3 Database Independent Abstraction L
ii libsqlite3-0 3.6.23.1-4 SQLite 3 shared library
libdbd-sqlite3 recommends no packages.
libdbd-sqlite3 suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
