Bug 286852 – subversion svnadmin gives error, not usable anymore

• Product: Gentoo Linux
• Status: RESOLVED INVALID

[Description Chris Bruner 2009-09-28 21:36:03 UTC]

I seem to be digging myself further in. 
I was attempting to unlock a repositor, getting svn: Commit failed attempt to write a readonly database.
So in my attempts I tried to upgrade subversion to the latest. 1.6.5-r10
now running svnadmin help returns
svnadmin: Bad database version: compiled with 4.7.25, running against 4.8.24
I've since downgraded to 1.6.5 but have the same results.

Reproducible: Always

Steps to Reproduce:
1.emerge subversion
2.svnadmin help
3.watch in helpless horror as you realize you can't access a repostitory containing about a decade of work.

Actual Results:  
svnadmin: Bad database version: compiled with 4.7.25, running against 4.8.24



emerge --info                                           
Portage 2.1.6.13 (default/linux/amd64/2008.0, gcc-4.4.1, glibc-2.10.1-r0, 2.6.31-gentoomod x86_64)
=================================================================                                 
System uname: Linux-2.6.31-gentoomod-x86_64-Intel-R-_Core-TM-2_Quad_CPU_Q6700_@_2.66GHz-with-gentoo-2.0.1
Timestamp of tree: Mon, 28 Sep 2009 18:00:01 +0000                                                       
distcc 3.1 x86_64-pc-linux-gnu [disabled]                                                                
app-shells/bash:     4.0_p33                                                                             
dev-java/java-config: 1.3.7-r1, 2.1.9-r1                                                                 
dev-lang/python:     2.4.6, 2.5.4-r3, 2.6.2-r1, 3.1.1-r1                                                 
dev-python/pycrypto: 2.0.1-r6                                                                            
dev-util/cmake:      2.6.4-r2                                                                            
sys-apps/baselayout: 2.0.1                                                                               
sys-apps/openrc:     0.4.3-r3                                                                            
sys-apps/sandbox:    2.1                                                                                 
sys-devel/autoconf:  2.13, 2.63-r1                                                                       
sys-devel/automake:  1.5, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.2, 1.11                                     
sys-devel/binutils:  2.19.1-r1                                                                           
sys-devel/gcc-config: 1.4.1                                                                              
sys-devel/libtool:   2.2.6a                                                                              
virtual/os-headers:  2.6.30-r1                                                                           
ACCEPT_KEYWORDS="amd64 ~amd64"                                                                           
CBUILD="x86_64-pc-linux-gnu"                                                                             
CFLAGS="-mtune=nocona -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config /var/bind /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/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 /etc/udev/rules.d"
CXXFLAGS="-mtune=nocona -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks fixpackages metadata-transfer parallel-fetch protect-owned sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://gentoo.mirrors.tds.net/gentoo http://gentoo.netnitco.net http://mirror.csclub.uwaterloo.ca/gentoo-distfiles/ http://gentoo.mirrors.hoobly.com/ http://osmirrors.cerias.purdue.edu/pub/gentoo/"
LANG="en_CA"
LC_ALL="en_CA"
LDFLAGS="-Wl,-O1"
MAKEOPTS="-j16"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage/layman/kde-testing /usr/local/portage/layman/sunrise /usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="3dnow 3dnowex 3dnowext 3ds 7zip X Xaw3d aalib accessibility acl allegro alsa amarok amd64 ansi apache2 aqua_theme asterisk audacious audio automount avahi bash-completion berkdb bindist blender-game bochs-debugger boost bzip2 cairo cal3d cddb cdio cdparanoia cg cgi cli consolekit contrib cracklib crypt cscope ctype cups curl dba dbus debugger demo demos deprecated dga dillo discouraged dpms dri dvi embedded encode etwin examples expat fastbuild fax festival ffmpeg filter firefox3 fltk fluidsynth fmod fortran freetype fs ftp gcj gd gdb gdbm gif gimp gimpprint glade gnome gnuplot gpm grammar gtalk gtk hash haskell html iconv icu idl imagemagick ipv6 isdnlog jabber jack jack-tmpfs jadetex java java6 joystick jpeg jpeg2k jumpplay kcal kde kdebuild kdm kmid libv4l2 libwww lirc maps mbrola mdnsresponder-compat memlimit mikmod mmx mng modules mp2 mp3 mpeg4 mudflap multilib music mysql ncurses network nls nodrm nptl nptlonly nsplugin odbc ode offensive ofx ogg ogre openal openexr opengl openmp pam pascal pcre pda pdf pdo pear-db perl php pic pidgin player png portaudio povray pppd python qt3 qt3support quicktime quotes radeon readline reflection regex rtc ruby samba screen sdk server session simplexml slp sockets source spamassassin speech speex spl sql sse sse2 ssl stencil-buffer suexec svg sysfs sysvipc tcpd tetex theora threads tidy tiff timidity tinygui tk tokenizer tomsfastmath tools transcode tv type1 unicode v4l v4l2 vfat vhosts video videos vim vim-with-x visual visualization vlm voice vorbis webdav webkit wma wmp wordperfect wxgtk1 wxwin wxwindows xcb xext xfs xine xinerama xinetd xlockrc xmlwriter xorg xscreensaver xsl xulrunner yahoo zeroconf zip zlib" 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" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd 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 dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="nvidia nv"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 1 Chris Bruner 2009-09-28 21:39:16 UTC]

I found a link which might be useful.
http://svn.haxx.se/users/archive-2004-04/0601.shtml

[Comment 2 Chris Bruner 2009-09-28 21:43:21 UTC]

eix sys-libs/db shows

[U] sys-libs/db
     Available versions:  
        (1)     1.85-r3   
        (3)     3.2.9-r11 3.2.9_p2
        (4.2)   4.2.52_p4-r2 (~)4.2.52_p5 4.2.52_p5-r1
        (4.3)   4.3.29-r2 (~)4.3.29_p1 4.3.29_p1-r1   
        (4.4)   (~)4.4.20_p4 (~)4.4.20_p4-r1          
        (4.5)   4.5.20_p2 4.5.20_p2-r1                
        (4.6)   4.6.21_p4                             
        (4.7)   (~)4.7.25_p3 (~)4.7.25_p4             
        (4.8)   (~)4.8.24                             
        {doc elibc_FreeBSD java nocxx tcl test}       
     Installed versions:  1.85-r3(1)(11:24:49 AM 26/09/08) 3.2.9-r11(3)(11:24:49 AM 26/09/08)(-doc -test) 4.3.29_p1-r1(4.3)(03:39:27 PM 13/08/09)(java -doc -elibc_FreeBSD -nocxx -tcl -test) 4.5.20_p2-r1(4.5)(03:36:49 PM 13/08/09)(java -doc -elibc_FreeBSD -nocxx -tcl -test) 4.6.21_p4(4.6)(12:46:06 AM 25/03/09)(java -doc -elibc_FreeBSD -nocxx -tcl -test) 4.7.25_p4(4.7)(03:10:28 PM 16/07/09)(java -doc -elibc_FreeBSD -nocxx -tcl -test) 4.8.24(4.8)(03:19:22 AM 25/09/09)(java -doc -elibc_FreeBSD -nocxx -tcl -test)                                                                                                                                                
     Homepage:            http://www.oracle.com/technology/software/products/berkeley-db/index.html                                                                                                                        
     Description:         Oracle Berkeley DB      

So I have both versions installed. (although I don't remeber doing it).

[Comment 3 Rafał Mużyło 2009-09-28 22:32:32 UTC]

Well, either the shock will kill you or
the thrill will will make you feel young again.

But seriously, reading the notes in the ebuild,
I think try to rebuild dev-libs/apr-util.

Attach build.log of subversion, if that doesn't help.

[Comment 4 Rafał Mużyło 2009-09-28 22:33:35 UTC]

If it's not clear, that was "rebuild apr-util,
then rebuild subversion".

[Comment 5 Chris Bruner 2009-09-29 17:15:03 UTC]

Thank you! That got past this problem. I'm still getting the error about trying to write to a read only database though. Any ideas about that?

[Comment 6 Chris Bruner 2009-09-29 17:26:09 UTC]

Found it. I don't know how it happened other then using svnadmin as root, but some of the database files were owned by root:root instead of apache:svnusers

doing a chown -R apache:suvnusers in the directory fixed it for me.

Thanks for your help!  I'm marking this bug as invalid assuming that I did something to cause all this in the first place.