Date: Fri, 19 Apr 2013 09:53:01 +0300 (EEST) From: Sayetsky Anton <vsjcfm@gmail.com> To: FreeBSD-gnats-submit@freebsd.org Subject: ports/177982: databases/sqlite3 is broken when sql log enabled Message-ID: <201304190653.r3J6r1wT084679@jw.lds.net.ua> Resent-Message-ID: <201304191810.r3JIA20Q087735@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 177982
>Category: ports
>Synopsis: databases/sqlite3 is broken when sql log enabled
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Fri Apr 19 18:10:02 UTC 2013
>Closed-Date:
>Last-Modified:
>Originator: Sayetsky Anton
>Release: FreeBSD 9.1-RELEASE-p2 amd64
>Organization:
>Environment:
System: FreeBSD jw.local 9.1-RELEASE-p2 FreeBSD 9.1-RELEASE-p2 #0 r249040: Wed Apr 3 14:32:47 EEST 2013 root@jw.local:/usr/obj/media/dvlfiles/build/src/sys/JASONW amd64
>Description:
sqlite3 doesn't works anymore if you enable SQLLOG option.
root@jw:/usr/ports/databases/sqlite3# make showconfig
===> The following configuration options are available for sqlite3-3.7.16.1:
DIRECT_READ=off: File is read directly from disk
EXTENSION=on: Allow loadable extensions
FTS3=on: Enable FTS3/4 (Full Text Search) module
ICU=on: Enable built with ICU
MEMMAN=on: Allows it to release unused memory
METADATA=on: Enable column metadata
RAMTABLE=on: Store temporary tables in RAM = 2
RTREE=on: Enable R*Tree module ("float")
SECURE_DELETE=on: Overwrite deleted information with zeros
SOUNDEX=on: Enables the soundex() SQL function
SQLLOG=on: Allow logging operations
STAT3=on: Help SQLite to chose a better query plan
THREADSAFE=on: Build thread-safe library
UNLOCK_NOTIFY=on: Enable notification on unlocking
UPD_DEL_LIMIT=on: ORDER BY and LIMIT on UPDATE and DELETE
URI=on: Enable use the URI filename
===> Use 'make config' to modify these settings
root@jw:/usr/ports/databases/sqlite3# pkg_info | egrep "sqlite3|subversion"
linux-f10-sqlite3-3.5.9_1 The library that implements an embeddable SQL database engi
sqlite3-3.7.16.1 An SQL database engine in a C library
subversion-1.7.9_1 Version control system
root@jw:/usr/ports/databases/sqlite3# svn log -l 2
/usr/local/lib/libsqlite3.so.8: Undefined symbol "sqlite3_init_sqllog"
root@jw:/usr/ports/databases/sqlite3# portupgrade -fcv subversion
---> Session started at: Fri, 19 Apr 2013 09:47:05 +0300
[Gathering depends for devel/subversion ......(devel/apr1)......(converters/libiconv).===> No options to configure
(devel/libtool)===> No options to configure
(textproc/expat2)===> No options to configure
(devel/automake)...===> No options to configure
(devel/automake-wrapper)===> No options to configure
(devel/autoconf).....(misc/help2man)....===> No options to configure
(devel/gmake).===> No options to configure
(devel/gettext)..===> No options to configure
(devel/p5-Locale-gettext)..(lang/perl5.14)(devel/m4)===> No options to configure
(devel/autoconf-wrapper)(lang/python27).(www/neon29)...(databases/sqlite3)..===> No options to configure
(devel/pkgconf)(devel/icu). done]
---> Reinstallation of devel/subversion started at: Fri, 19 Apr 2013 09:47:09 +0300
---> Reinstalling 'subversion-1.7.9_1' (devel/subversion)
---> Build of devel/subversion started at: Fri, 19 Apr 2013 09:47:09 +0300
---> Building '/usr/ports/devel/subversion'
===> Cleaning for subversion-1.7.9_1
WebDAV/Delta-V repository access module enabled.
Berkeley DB (4 or 5) repository backend disabled.
You can enable the mod_dav_svn module for Apache 2.X
You can enable the mod_dontdothat module for Apache 2.X
You can have the repository created for you by defining
WITH_REPOSITORY_CREATION.
Make sure that:
* all your svn users are members of a common group
* this group is the group id of the db/ and locks/
subdirectories of your repository
* the above subdirectories are writable by this group
Many useful scripts will be installed into /usr/local/share/subversion
===> License AL2 accepted by the user
===> Found saved configuration for subversion-1.7.6
===> Fetching all distfiles required by subversion-1.7.9_1 for building
===> Extracting for subversion-1.7.9_1
=> SHA256 Checksum OK for subversion17/subversion-1.7.9.tar.bz2.
===> Patching for subversion-1.7.9_1
===> Applying extra patch /media/dvlfiles/build/ports/devel/subversion/files/extra-patch-3way-conflict-markers
===> Applying extra patch /media/dvlfiles/build/ports/devel/subversion/files/extra-patch-enhanced-keyword
===> Applying extra patch /media/dvlfiles/build/ports/devel/subversion/files/extra-patch-fbsd-template
===> Applying extra patch /media/dvlfiles/build/ports/devel/subversion/files/extra-patch-Makefile.in
===> Applying FreeBSD patches for subversion-1.7.9_1
===> subversion-1.7.9_1 depends on package: libtool>=2.4 - found
===> subversion-1.7.9_1 depends on shared library: sqlite3.8 - found
===> subversion-1.7.9_1 depends on shared library: expat - found
===> subversion-1.7.9_1 depends on shared library: neon.27 - found
===> subversion-1.7.9_1 depends on shared library: apr-1 - found
===> subversion-1.7.9_1 depends on shared library: intl - found
===> Configuring for subversion-1.7.9_1
configure: Configuring Subversion 1.7.9
configure: creating config.nice
checking for gcc... cc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking whether we are using the GNU C++ compiler... yes
checking whether c++ accepts -g... yes
checking how to run the C preprocessor... cpp
checking for a sed that does not truncate output... /usr/bin/sed
checking build system type... amd64-portbld-freebsd9.1
checking host system type... amd64-portbld-freebsd9.1
checking target system type... amd64-portbld-freebsd9.1
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking whether ln -s works... yes
checking for a BSD-compatible install... /usr/bin/install -c -o root -g wheel
configure: Apache Portable Runtime (APR) library configuration
checking for APR... yes
checking APR version... 1.4.6
configure: Apache Portable Runtime Utility (APRUTIL) library configuration
checking for APR-util... yes
checking APR-UTIL version... 1.4.1
checking for pkg-config... /usr/local/bin/pkg-config
configure: checking neon library
checking for neon-config... /usr/local/bin/neon-config
checking neon library version... 0.29.6
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking whether to look for GSSAPI (Kerberos)... no
configure: looking for apr_memcache as part of apr-util
checking apr_memcache.h usability... yes
checking apr_memcache.h presence... yes
checking for apr_memcache.h... yes
checking for apr_memcache_create in -laprutil-1... yes
checking for Apache module support via DSO through APXS... no
==================================================================
WARNING: skipping the build of mod_dav_svn
try using --with-apxs
==================================================================
configure: checking sqlite library
checking sqlite3.h usability... yes
checking sqlite3.h presence... yes
checking for sqlite3.h... yes
checking sqlite library version (via header)... okay
checking for sqlite3_close in -lsqlite3... no
configure: WARNING: no suitable sqlite found in /usr/local
An appropriate version of sqlite could not be found. We recommmend
3.7.6.3, but require at least 3.6.18.
Please either install a newer sqlite on this system
or
get the sqlite 3.7.6.3 amalgamation from:
http://www.sqlite.org/sqlite-amalgamation-3.7.6.3.tar.gz
unpack the archive using tar/gunzip and copy sqlite3.c from the
resulting directory to:
/usr/obj/media/dvlfiles/build/ports/devel/subversion/work/subversion-1.7.9/sqlite-amalgamation/sqlite3.c
configure: error: Subversion requires SQLite
===> Script "configure" failed unexpectedly.
Please report the problem to lev@FreeBSD.org [maintainer] and attach the
"/usr/obj/media/dvlfiles/build/ports/devel/subversion/work/subversion-1.7.9/config.log"
including the output of the failure of your make command. Also, it might be
a good idea to provide an overview of all packages installed on your system
(e.g. a /usr/sbin/pkg_info -Ea).
*** [do-configure] Error code 1
Stop in /media/dvlfiles/build/ports/devel/subversion.
*** [build] Error code 1
Stop in /media/dvlfiles/build/ports/devel/subversion.
** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade20130419-82862-1sbo3ft-0 env UPGRADE_TOOL=portupgrade UPGRADE_PORT=subversion-1.7.9_1 UPGRADE_PORT_VER=1.7.9_1 make
** Fix the problem and try again.
---> Build of devel/subversion ended at: Fri, 19 Apr 2013 09:47:13 +0300 (consumed 00:00:04)
---> Reinstallation of devel/subversion ended at: Fri, 19 Apr 2013 09:47:13 +0300 (consumed 00:00:04)
---> ** Upgrade tasks 1: 0 done, 0 ignored, 0 skipped and 1 failed
---> Listing the results (+:done / -:ignored / *:skipped / !:failed)
! devel/subversion (subversion-1.7.9_1) (configure error)
---> Packages processed: 0 done, 0 ignored, 0 skipped and 1 failed
---> Session ended at: Fri, 19 Apr 2013 09:47:13 +0300 (consumed 00:00:08)
So I can't use or even rebuild Subversion.
>How-To-Repeat:
Update SQLlite to latest version with SQLLOG=on & try to sun svn for example.
>Fix:
Turning SQLLOG off and rebuilding SQLlite helps. I don't know is this a proper way, but maybe BROKEN= must be set?
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201304190653.r3J6r1wT084679>