[Spce-user] Upgrade from 6.5.12 to 7.5.9 fails

[Henk]

Hello,

I'm trying to upgrade to mr7.5.9 and  it fails with this message:

Applying revision script 
/usr/share/ngcp-db-schema/db_scripts/diff/15436.up: done
ERROR 1265 (01000) at line 1: Data truncated for column 'revision' at row 1

Following the error I find something goes wrong with 
/usr/sbin/ngcp-update-db-schema around here:

   rev="$1"
   revname="$(basename "$rev")"

   printf "Applying revision script %s: " "$rev"
   if mysql -usipwise -p"${SIPWISE_DB_PASSWORD}" < "$rev" ; then
     echo "done"
   else
     echo "failed. :(" >&2
     echo "Please resolve the problem and run ngcp-update-db-schema 
again." >&2
     exit 1
   fi

I don't understand what happens on line 131 where the mysql output is 
compared with the full path and filename ($rev), it seems to me this 
will always fail. When I check the db_schema values it reads:


MariaDB [provisioning]> select * from ngcp.db_schema order by id desc 
limit 1;
+-----+----------+------+---------------------+
| id  | revision | node | applied_at          |
+-----+----------+------+---------------------+
| 812 |    15580 | spce | 2020-06-01 09:28:28 |
+-----+----------+------+---------------------+

Can someone explain how this is supposed to work and why it's failing?

Henk

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0xB93552A43ACD585C.asc
Type: application/pgp-keys
Size: 2417 bytes
Desc: OpenPGP public key
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20211023/f3c909e5/attachment.asc>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 665 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20211023/f3c909e5/attachment.sig>