Reminder : upgrade Debian 9 (Stretch) to Debian 11 (Bulleyes)

This is an update to my previous post. I had old system still in Debian 9 version.To upgrade this system, I made two steps : first, I upgraded Debian 9 to Debian 10 then I upgraded Debian 10 to 11.In my mind it's more secure.

Note : to upgrade Debian 9 to Debian 10, I used the following command :

apt-get update && apt-get upgrade && apt-get dist-upgrade
sed -i 's/stretch/buster/g' /etc/apt/sources.list
apt-get update
apt-get upgrade
apt-get dist-upgrade
reboot

WARNING : If you have a POSTGRESQL database, you need to launch the reinxdb command :

su - postgres
reindexdb --all

See https://www.debian.org/releases/buster/amd64/release-notes/ch-information.en.html#postgresql-reindex
See https://wiki.postgresql.org/wiki/Locale_data_changes

The command to upgrade Debian 10 to Debian 11 are quite the same ( See my previous post )

ERROR : value too long for the type ... character varying(255) : resolved !

This is an error very annoying with talend and in the most case, you have too wait a long times to see the error message and you don't know which column is responsible of the error. A simple way to avoid this error is to check the schema compliance with a tSchemaComplianceCheck.

It doesn't solve the problem but it permits to filter incorrect results and to know the reason of the error with the tLogRow component (REJECT_SCHEMA_COMPLIANCE) :

.---------+---------+-------+----+-----+-----+-----+----+---------+------------.

|                           REJECT_SCHEMA_COMPLIANCE                           |

|=--------+---------+-------+----+-----+-----+-----+----+---------+-----------=|

|JSON_DATE|JSON_RNSR|journal|type|orcId|idHal|idRef|code|errorCode|errorMessage|

|=--------+---------+-------+----+-----+-----+-----+----+---------+-----------=|

'---------+---------+-------+----+-----+-----+-----+----+---------+------------'

Now, in my case, I can insert in database only good results and filter bad results.

See more on  https://help.talend.com/r/en-US/7.2/validation/tschemacompliancecheck-tlogrow-tfileinputdelimited-tfileinputdelimited-setting-up-job-standard-component-enterprise-drop

Reminder Upgrade Debian 10 (Buster) to Debian 11 (Bullseye)

A simple reminder to upgrade  Debian 10 (Buster)  to Debian 11 (Bullseye) 

• apt update & apt upgrade
• Change source list :

vi /etc/apt/sources.list

deb http://deb.debian.org/debian bullseye main contrib non-free
deb-src http://deb.debian.org/debian bullseye main contrib non-free
deb http://deb.debian.org/debian-security/ bullseye-security main contrib non-free
deb-src http://deb.debian.org/debian-security/ bullseye-security main contrib non-free
deb http://deb.debian.org/debian bullseye-updates main contrib non-free
deb-src http://deb.debian.org/debian bullseye-updates main contrib non-free

Note : comment other source like Docker.

• apt update
• apt upgrade --without-new-pkgs
• apt full-upgrade
• cat /etc/debian_version

@todo : postgresql migration

Tela botanica : MOOC botanique gratuit en ligne

Pour ceux qui ne connaissent pas, Tela Botanica propose un MOOC gratuit en ligne de botanique sur le thème des "mauvaises" herbes. J'ai déjà suivi un de leur MOOC et je peux dire que je n'ai pas été déçu. Ce MOOC ,proposé par l'Université de Paris SARCLAY, fait intervenir 6 pédagogues et 7 experts.

Plus d'information :https://www.tela-botanica.org/2021/08/mooc-herbes-folles-programme-de-la-formation/