[Spce-user] Upgrade from 6.5.12 to 7.5.9 fails
Henk
henkpls at hotmail.com
Sat Oct 23 12:17:07 EDT 2021
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>
More information about the Spce-user
mailing list