[MDEV-7077] Upgrade test fails in buildbot on Trusty Created: 2014-11-11  Updated: 2014-11-17  Resolved: 2014-11-17

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.15

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: buildbot, debian, tests, upgrade

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

It might be a duplicate of MDEV-5977, need to re-check.
Even if it is, maybe we should do something with the test itself since MDEV-5977 isn't moving anywhere.

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/584/steps/test_2/logs/stdio
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-x86/builds/502/steps/test_2/logs/stdio



 Comments   
Comment by Elena Stepanova [ 2014-11-12 ]

The cause of the failure is exactly MDEV-5977.
The test runs
apt-get install mariadb-server mariadb-server-10.0 mariadb-test libmariadbclient-dev mysql-common
and it fails with

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
 
The following packages have unmet dependencies:
 mariadb-server-10.0 : Depends: mariadb-server-core-10.0 (>= 10.0.15+maria-1~trusty) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

But if we run install for mariadb-server-core-10.0 separately, it works.

Comment by Elena Stepanova [ 2014-11-17 ]

Solved the buildbot failure by an ugly workaround:

 #-------------------------------------------------------------------------------
@@ -1921,9 +2029,10 @@
         command=["runvm", "--base-image=/kvm/vms/"+kvm_image+"-upgrade2.qcow2"] + args + ["--logfile=kernel_"+port+".log", "vm-tmp-"+port+".qcow2",
         "rm -Rf buildbot && mkdir buildbot",
         "= scp -r -P "+port+" "+kvm_scpopt+" debs buildbot@localhost:buildbot/",
-        "sudo rm -rf /tmp/VERSION",
+        "sudo rm -rf /tmp/VERSION /tmp/MAYBE_SERVER_CORE",
         WithProperties("sh -c \"echo '%(branch)s' | sed -e \\\"s/.*\\\\(5\\\\.[1-356]\\\\|10\\\\.0\\\\).*/\\\\1/\\\"\" > /tmp/VERSION"),
         WithProperties("case '%(branch)s' in *galera* | *5.5-hf* | 10.1) sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943
db ; sudo sh -c \"echo 'deb http://mirror2.hs-esslingen.de/mariadb/repo/$(cat /tmp/VERSION)/"+distro_name+" "+version_name+" main' > /etc/apt/sources.li
st.d/galera-test-repo.list\" ;; esac"),
+       "touch /tmp/MAYBE_SERVER_CORE; case $(cat /tmp/VERSION)-"+version_name+" in 10.0-trusty) echo mariadb-server-core-$(cat /tmp/VERSION) > /tmp/MAY
BE_SERVER_CORE ;; esac",
         WithProperties("""
 set -ex
 cd buildbot
@@ -1932,7 +2041,7 @@
 mysql -uroot -prootpass -e "use mytest; set global innodb_file_per_table=0; drop table if exists upgrade_test; create table upgrade_test (pk int primar
y key auto_increment, c char(64), v varchar(2048), d date, t time, dt datetime, ts timestamp) engine=InnoDB; begin; insert into upgrade_test values (nul
l, 'test', 'test', date(now()), time(now()), now(), now());  insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now(
) from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade
_test select null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(
now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now() from u
pgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test se
lect null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), 
time(now()), now(), now() from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_t
est; insert into upgrade_test select null, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test select nul
l, 'test', 'test', date(now()), time(now()), now(), now() from upgrade_test; insert into upgrade_test select null, 'test', 'test', date(now()), time(now
()), now(), now() from upgrade_test; commit" --force
 VER=$(echo '%(branch)s' | sed -e "s/.*\\\\(5\\\\.[1-356]\\\\|10\\\\.0\\\\).*/\\\\1/")
 GALERA=`case '%(branch)s' in *galera* | *5.5-hf*) echo galera- ;; esac`
-sudo sh -c "DEBIAN_FRONTEND=noninteractive MYSQLD_STARTUP_TIMEOUT=180 apt-get install --allow-unauthenticated -y mariadb-${GALERA}server mariadb-${GALE
RA}server-${VER} mariadb-${GALERA}test libmariadbclient-dev mysql-common"
+sudo sh -c "DEBIAN_FRONTEND=noninteractive MYSQLD_STARTUP_TIMEOUT=180 apt-get install --allow-unauthenticated -y mariadb-${GALERA}server mariadb-${GALE
RA}server-${VER} mariadb-${GALERA}test libmariadbclient-dev mysql-common $(cat /tmp/MAYBE_SERVER_CORE)"
 mysql -uroot -prootpass -e "use mytest; select * from t; select count(*) from upgrade_test"
 """),
         "! rm -f daemon.log; (sudo cat /var/log/daemon.log || sudo cat /var/log/syslog) >daemon.log",

The root cause, however, remains (MDEV-5977).

Generated at Thu Feb 08 07:16:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.