[Koha-devel] Major surprise - "automatic" upgrade

[Archives and Collections Society]

At 06:41 PM 4/30/2013 -0400, Ian Walls wrote:
[snip]
>This is definitely a confusing situation, and I'm sorry it's cause you 
>alarm.  Hopefully with more information we can get to the bottom of 
>exactly how it's happening, understand it, and prevent it from happening 
>to you (and anyone else) again.

Thanks to all for your patience, summary of my "reproducible upgrade" is 
that under some | [perhaps] exceptional conditions 'cleanup_database.pl' 
does upgrade the Koha version. Under what might be called "normal" 
conditions, absolutely everything is as expected with no problems.

You'll see from the notes below, that having a *koha owned* koha-3.08.10 at 
/ prompts a version upgrade [the *Important Note* below.] There is no 
"verbosity" using -v with './cleanup_database.pl'

Best - Paul

Update 6 May: Logged in as user=koha, no tarred|untarred Koha installation 
files on this box

koha at hardy:/$ cat /usr/share/koha/misc/koha-install-log | grep 
KOHA_INSTALLED_VERSION
KOHA_INSTALLED_VERSION=3.08.05.000

koha at hardy:/usr/share/koha/bin/cronjobs$ ./cleanup_database.pl --zebraqueue 
1 -v
Zebraqueue purge triggered for 1 days.
19847 records were deleted.
Done with zebraqueue purge.

cat /usr/share/koha/misc/koha-install-log | grep KOHA_INSTALLED_VERSION
KOHA_INSTALLED_VERSION=3.08.05.000

So far, so good; OPAC and staff-admin both functional.

To reproduce upgrade, restore db; sftp [...] koha-3.08.05.tar.gz and 
koha-3.08.10.tar.gz /home/paul; "untar" koha-3.08.10.tar.gz in /home/paul/; 
cp koha-3.08.10.tar.gz to /

koha at hardy:/$ ls -l /home/paul
/.../
-rwxrw-r-- 1 paul paul  48446365 Sep 22  2012 koha-3.08.05.tar.gz
-rwxrw-r-- 1 paul paul  50084604 Mar  2 19:34 koha-3.08.10.tar.gz
drwxrwxr-x  42 paul paul  4096 Feb 23 05:09 koha-3.08.10

koha at hardy:/$ ls -l /
/ ... /
-rw-r--r--   1 koha     koha     50084604 May  6 18:26 koha-3.08.10.tar.gz
drwxrwxr-x  42 koha     koha         4096 Feb 23 05:09 koha-3.08.10

[Important Note: if chown is either "me" or root, the following version 
upgrade does not happen.]

koha at hardy:/usr/share/koha/bin/cronjobs$ ./cleanup_database.pl --zebraqueue 
1 -v
Zebraqueue purge triggered for 1 days.
19847 records were deleted.
Done with zebraqueue purge.

cat /usr/share/koha/misc/koha-install-log | grep KOHA_INSTALLED_VERSION
KOHA_INSTALLED_VERSION=3.08.10.000

... and OPAC announces under "maintenance". Trying to staff-admin:

Web installer › Step 3

We are upgrading from Koha 3.08.05.000 to 3.08.10.000, you must update your 
database

Web installer › Step 3
Updating database structure

Update report :

     Upgrade to 3.08.06.000 (3.8.6 release) done
     Upgrade to 3.08.07.000 (3.8.7 release) done
     Upgrade to 3.08.08.000 (3.8.8 release) done
     Upgrade to 3.08.09.000 (3.8.9 release) done
     Upgrade to 3.08.10.000 (3.8.9 release) done

Everything went OK, update done.
Continue to log in to Koha