{
  "_class" : "hudson.matrix.MatrixBuild",
  "actions" : [
    {
      "_class" : "hudson.model.CauseAction",
      "causes" : [
        {
          "_class" : "hudson.triggers.SCMTrigger$SCMTriggerCause",
          "shortDescription" : "Started by an SCM change"
        }
      ]
    },
    {
      
    },
    {
      "_class" : "hudson.model.ParametersAction",
      "parameters" : [
        {
          "_class" : "hudson.model.StringParameterValue",
          "name" : "BRANCH",
          "value" : "master"
        },
        {
          "_class" : "hudson.model.StringParameterValue",
          "name" : "EMAIL_NOTIFICATIONS",
          "value" : "jenkins-notifications@lists.osmocom.org laforge@gnumonks.org"
        }
      ]
    },
    {
      "_class" : "jenkins.metrics.impl.TimeInQueueAction",
      "blockedDurationMillis" : 0,
      "blockedTimeMillis" : 0,
      "buildableDurationMillis" : 0,
      "buildableTimeMillis" : 0,
      "buildingDurationMillis" : 125199,
      "executingTimeMillis" : 125199,
      "executorUtilization" : 1.0,
      "subTaskCount" : 0,
      "waitingDurationMillis" : 9094,
      "waitingTimeMillis" : 9094
    },
    {
      
    },
    {
      "_class" : "hudson.plugins.git.util.BuildData",
      "buildsByBranchName" : {
        "origin/master" : {
          "_class" : "hudson.plugins.git.util.Build",
          "buildNumber" : 13484,
          "buildResult" : None,
          "marked" : {
            "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
            "branch" : [
              {
                "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
                "name" : "origin/master"
              }
            ]
          },
          "revision" : {
            "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
            "branch" : [
              {
                "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
                "name" : "origin/master"
              }
            ]
          }
        },
        "refs/remotes/origin/master" : {
          "_class" : "hudson.plugins.git.util.Build",
          "buildNumber" : 8893,
          "buildResult" : None,
          "marked" : {
            "SHA1" : "63eefabdde87df4dac9ed071df6535eed4f748c3",
            "branch" : [
              {
                "SHA1" : "63eefabdde87df4dac9ed071df6535eed4f748c3",
                "name" : "refs/remotes/origin/master"
              }
            ]
          },
          "revision" : {
            "SHA1" : "63eefabdde87df4dac9ed071df6535eed4f748c3",
            "branch" : [
              {
                "SHA1" : "63eefabdde87df4dac9ed071df6535eed4f748c3",
                "name" : "refs/remotes/origin/master"
              }
            ]
          }
        }
      },
      "lastBuiltRevision" : {
        "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
        "branch" : [
          {
            "SHA1" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
            "name" : "origin/master"
          }
        ]
      },
      "remoteUrls" : [
        "https://gerrit.osmocom.org/osmo-hlr"
      ],
      "scmName" : ""
    },
    {
      
    },
    {
      
    },
    {
      
    },
    {
      "_class" : "org.jenkinsci.plugins.displayurlapi.actions.RunDisplayAction"
    }
  ],
  "artifacts" : [
    
  ],
  "building" : False,
  "description" : None,
  "displayName" : "#13484",
  "duration" : 125199,
  "estimatedDuration" : 119887,
  "executor" : None,
  "fullDisplayName" : "master-osmo-hlr #13484",
  "id" : "13484",
  "inProgress" : False,
  "keepLog" : False,
  "number" : 13484,
  "queueId" : 169525,
  "result" : "SUCCESS",
  "timestamp" : 1784118249540,
  "url" : "https://jenkins.osmocom.org/jenkins/view/no-generated/job/master-osmo-hlr/13484/",
  "builtOn" : "",
  "changeSet" : {
    "_class" : "hudson.plugins.git.GitChangeSetList",
    "items" : [
      {
        "_class" : "hudson.plugins.git.GitChangeSet",
        "affectedPaths" : [
          "debian/postinst",
          "contrib/osmo-hlr-post-upgrade.sh",
          "contrib/systemd/osmo-hlr.service",
          "debian/osmo-hlr.install",
          "contrib/osmo-hlr-db-upgrade.sh",
          "contrib/Makefile.am"
        ],
        "commitId" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
        "timestamp" : 1784109296000,
        "author" : {
          "absoluteUrl" : "https://jenkins.osmocom.org/jenkins/user/osmith",
          "fullName" : "Oliver Smith"
        },
        "authorEmail" : "osmith@sysmocom.de",
        "comment" : "systemd: run db-upgrade script in ExecStartPre\u000a\u000aWe have seen in CI jobs that calling the DB upgrade script from\u000adebian/postinst does not work reliably.\u000a\u000aWhen doing a fresh install of osmo-hlr, it usually works as expected:\u000a\u000a  Setting up osmo-hlr (1.9.2) ...\u000a  osmo-hlr-post-upgrade: nothing to do (no existing database)\u000a\u000aBut sometimes:\u000a\u000a  Setting up osmo-hlr (1.9.2) ...\u000a  osmo-hlr-post-upgrade: database upgrade is required\u000a  osmo-hlr-post-upgrade: stopping osmo-hlr service\u000a  osmo-hlr-post-upgrade: creating backup: /var/lib/osmocom/hlr.db.20260706135658.bak\u000a  osmo-hlr-post-upgrade: performing database upgrade\u000a  <0001> db.c:600 using database: /var/lib/osmocom/hlr.db\u000a  <0001> db.c:103 (283) recovered 4 frames from WAL file /var/lib/osmocom/hlr.db-wal\u000a  <0001> db.c:679 Database '/var/lib/osmocom/hlr.db' has HLR DB schema version 0\u000a  <0001> db.c:103 (1) duplicate column name: last_lu_seen in \"ALTER TABLE subscriber ADD COLUMN last_lu_seen TIMESTAMP default NULL\"\u000a  <0001> db.c:248 Unable to prepare SQL statement 'ALTER TABLE subscriber ADD COLUMN last_lu_seen TIMESTAMP default NULL'\u000a  <0001> db.c:318 Unable to update HLR database schema to version 1\u000a  <0001> db.c:685 Failed to upgrade HLR DB schema to version 1: (rc=1) duplicate column name: last_lu_seen\u000a  <0000> hlr_db_tool.c:509 Error opening database\u000a\u000aIt seems that osmo-hlr can get started before the osmo-hlr-post-upgrade\u000ascript runs, then starts to create the database with the current schema,\u000aand gets stopped before it is done, leading to the failure above.\u000a\u000aRename the script to osmo-hlr-db-upgrade.sh, remove logic for stopping\u000aand starting the service and let systemd call it in ExecStartPre. That\u000away we are sure that it runs *before* osmo-hlr starts up.\u000a\u000aRelated: SYS#8125\u000aChange-Id: If13f4c8b49397e6630956e92a7825843c7d55ebd\u000a",
        "date" : "2026-07-15 11:54:56 +0200",
        "id" : "2ef24d62ab9c1489eb87ac3aaeece084676e76b5",
        "msg" : "systemd: run db-upgrade script in ExecStartPre",
        "paths" : [
          {
            "editType" : "edit",
            "file" : "contrib/Makefile.am"
          },
          {
            "editType" : "edit",
            "file" : "contrib/systemd/osmo-hlr.service"
          },
          {
            "editType" : "edit",
            "file" : "debian/osmo-hlr.install"
          },
          {
            "editType" : "edit",
            "file" : "debian/postinst"
          },
          {
            "editType" : "delete",
            "file" : "contrib/osmo-hlr-post-upgrade.sh"
          },
          {
            "editType" : "add",
            "file" : "contrib/osmo-hlr-db-upgrade.sh"
          }
        ]
      }
    ],
    "kind" : "git"
  },
  "culprits" : [
    {
      "absoluteUrl" : "https://jenkins.osmocom.org/jenkins/user/osmith",
      "fullName" : "Oliver Smith"
    }
  ],
  "runs" : [
    {
      "number" : 13484,
      "url" : "https://jenkins.osmocom.org/jenkins/view/no-generated/job/master-osmo-hlr/a1=default,a2=default,a3=default,a4=default,label=osmocom-master/13484/"
    }
  ]
}