Problems upgrading database from 4.4.3 to 5.0.3 on Debian 10.12 (MariaDB 10.3.31, Apache 2)

plast · August 22, 2022, 9:29pm

Hi,

We have upgraded from RT 4.4.3 to 5.0.3 on Debian 10.12 (MariaDB 10.3.31, Apache 2, postfix ) but ran into a problem whilst upgrading the database.

We proceeded as follows:
Fresh installation of RT 5 in /opt/rt5:
./configure … --with-db-database=rt4 # The old database/ still named rt4
make install
make upgrade-database

We received the error below at the upgrading 4.5.2. stage.

Has anyone experienced the same problem or did I maybe miss something out?

Regards,
Patrick

Enter RT version you’re upgrading from: 4.4.3

Going to apply following upgrades:

4.4.5
4.4.6
4.5.0
4.5.1
4.5.2
4.5.3
4.5.4
4.5.5
4.5.6
4.5.7
4.5.8
5.0.2
5.0.3

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 4.4.5
Now inserting data.
Processing 4.4.6
Now inserting database indexes.
Processing 4.5.0
Now populating database schema.
Processing 4.5.1
Now populating database schema.
Processing 4.5.2
Now populating database schema.
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 136
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 244
RT::Record::FirstAttribute(RT::System=HASH(0x562399264520), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 310
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 137
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 244
RT::Record::FirstAttribute(RT::System=HASH(0x562399264520), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 310
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 136
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 205
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 137
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 205
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET LastUpdated=? WHERE id=? ", “2022-08-22 17:04:04”, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “Table”, “Attributes”, “Value”, “2022-08-22 17:04:04”, “IsSQLFunction”, undef, “PrimaryKeys”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “LastUpdated”, “Value”, “2022-08-22 17:04:04”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “LastUpdated”, “Value”, “2022-08-22 17:04:04”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 506
RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x56239c956120)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 458
RT::Record::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Description”, “Value”, undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Description”, “Value”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 439
DBIx::SearchBuilder::Record::ANON(RT::Attribute=HASH(0x56239c956120), undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 211
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET LastUpdated=? WHERE id=? ", “2022-08-22 17:04:04”, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “Value”, “2022-08-22 17:04:04”, “Table”, “Attributes”, “Column”, “LastUpdated”, “PrimaryKeys”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “LastUpdated”, “Value”, “2022-08-22 17:04:04”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “LastUpdated”, “Value”, “2022-08-22 17:04:04”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 506
RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x56239c956120)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 458
RT::Record::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 317
RT::Attribute::SetContent(RT::Attribute=HASH(0x56239c956120), HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 212
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 17:04:04 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET Content=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET Content=? WHERE id=? ", “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “IsSQLFunction”, undef, “PrimaryKeys”, HASH(0x56239caa19f8), “Column”, “Content”, “Value”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 744
DBIx::SearchBuilder::Record::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 462
RT::Record::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x56239c956120), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA8AQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 317
RT::Attribute::SetContent(RT::Attribute=HASH(0x56239c956120), HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 212
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239caa6700)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“action”, “upgrade”, “datadir”, “./etc/upgrade/4.5.2”, “prompt-for-dba-password”, 1, “datafile”, undef, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)

plast · August 22, 2022, 9:39pm

A second error occurred at the upgrading 4.5.4. stage, see below.

RT 5 can be started afterwards.
But in the System Configuration the following messages can be found in the RT upgrade history:
Upgrade from 4.5.1 to 4.5.2 2022-08-22 17:55:02 69 minutes 5.0.3
Schema updates from /usr/local/src/rt-5.0.3/etc/upgrade/4.5.2 (Incomplete) 2022-08-22 17:55:02 5.0.3
Upgrade from 4.5.2 to 4.5.3 2022-08-22 19:04:04 4 minutes 5.0.3
Schema updates from /usr/local/src/rt-5.0.3/etc/upgrade/4.5.3 2022-08-22 19:04:04 4 minutes 5.0.3
Upgrade from 4.5.3 to 4.5.4 2022-08-22 19:08:07 78 minutes 5.0.3
Schema updates from /usr/local/src/rt-5.0.3/etc/upgrade/4.5.4 (Incomplete) 2022-08-22 19:08:07 5.0.3

Regards

Patrick

Processing 4.5.3
Now populating database schema.
Processing 4.5.4
Now populating database schema.
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 136
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 244
RT::Record::FirstAttribute(RT::System=HASH(0x562399264520), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 310
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 137
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 244
RT::Record::FirstAttribute(RT::System=HASH(0x562399264520), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 310
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 136
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 205
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?) AND (main.ObjectType = ?) ORDER BY main.id ASC ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), “SELECT main.* FROM Attributes main WHERE (main.ObjectId = ?)”…, 1, “RT::System”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder.pm line 244
DBIx::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/SearchBuilder.pm line 1062
RT::SearchBuilder::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 80
RT::Attributes::_DoSearch(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 105
RT::Attributes::_AttrHash(RT::Attributes=HASH(0x5623994bb380)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm line 137
RT::Attributes::Named(RT::Attributes=HASH(0x5623994bb380), “UpgradeHistory”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 205
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET LastUpdated=? WHERE id=? ", “2022-08-22 18:26:23”, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “PrimaryKeys”, HASH(0x56239cab7380), “IsSQLFunction”, undef, “Column”, “LastUpdated”, “Value”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “LastUpdated”, “Value”, “2022-08-22 18:26:23”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “LastUpdated”, “Value”, “2022-08-22 18:26:23”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 506
RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x5623992649b8)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 458
RT::Record::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Description”, “Value”, undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Description”, “Value”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 439
DBIx::SearchBuilder::Record::ANON(RT::Attribute=HASH(0x5623992649b8), undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 211
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET LastUpdated=? WHERE id=? ", “2022-08-22 18:26:23”, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “Value”, “2022-08-22 18:26:23”, “Table”, “Attributes”, “Column”, “LastUpdated”, “PrimaryKeys”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “LastUpdated”, “Value”, “2022-08-22 18:26:23”) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “LastUpdated”, “Value”, “2022-08-22 18:26:23”) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 506
RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x5623992649b8)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 458
RT::Record::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 317
RT::Attribute::SetContent(RT::Attribute=HASH(0x5623992649b8), HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 212
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm:622)
[3011] [Mon Aug 22 18:26:23 2022] [warning]: RT::Handle=HASH(0x5623992456f0) couldn’t execute the query 'UPDATE Attributes SET Content=? WHERE id=? ’ at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 635.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x5623992456f0), "UPDATE Attributes SET Content=? WHERE id=? ", “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, 24969) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Handle.pm line 487
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x5623992456f0), “Column”, “Content”, “PrimaryKeys”, HASH(0x56239cada550), “IsSQLFunction”, undef, “Table”, …) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/share/perl/5.24.1/DBIx/SearchBuilder/Record.pm line 744
DBIx::SearchBuilder::Record::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…, “IsSQL”, undef) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 462
RT::Record::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 501
RT::Attribute::_Set(RT::Attribute=HASH(0x5623992649b8), “Field”, “Content”, “Value”, “BQoDAAAABAQCAAAA9wQDAAAACgoHdXBncmFkZQAAAAZhY3Rpb24KBjQuMC4xO”…) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attribute.pm line 317
RT::Attribute::SetContent(RT::Attribute=HASH(0x5623992649b8), HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/Record.pm line 212
RT::Record::SetAttribute(RT::System=HASH(0x562399264520), “Name”, “UpgradeHistory”, “Content”, HASH(0x56239ca90960)) called at /usr/local/src/rt-5.0.3/sbin/…/lib/RT/System.pm line 315
RT::System::AddUpgradeHistory(RT::System=HASH(0x562399264520), “RT”, HASH(0x562392a4d418)) called at sbin/rt-setup-database line 269
main::action_schema(“prompt-for-dba-password”, 1, “backcompat”, ARRAY(0x5623927e7aa8), “datafile”, undef, “datadir”, “./etc/upgrade/4.5.4”, …) called at sbin/rt-setup-database line 562
main::action_upgrade(“package”, “RT”, “prompt-for-dba-password”, 1, “action”, “upgrade”) called at sbin/rt-setup-database line 210 (/usr/share/perl/5.24/Carp.pm:170)
Processing 4.5.5
Now inserting data.
Processing 4.5.6
Now inserting data.
Processing 4.5.7
Now populating database schema.
Processing 4.5.8
Now inserting data.
Processing 5.0.2
Now inserting data.
[3011] [Mon Aug 22 18:46:32 2022] [info]: Found scrip condition ‘On Create Via Email’, skipping (/usr/local/src/rt-5.0.3/etc/upgrade/5.0.2/content:56)
[3011] [Mon Aug 22 18:46:32 2022] [info]: Found scrip condition ‘On Create Via Web’, skipping (/usr/local/src/rt-5.0.3/etc/upgrade/5.0.2/content:56)
Processing 5.0.3
Now inserting database indexes.
Done.

GreenJimll · August 23, 2022, 10:33am

Not hit that myself, but it looks like your MySQL/MariaDB connection died (“server has gone away”) so is there anything in the logs from the database server? My only “off the top of my head” thought is did the old database have the right charsets configured in it? ISTR that was one of the many changes between 4.x and 5.x. Details from Best Practical for MariaDB are here.

plast · August 23, 2022, 3:57pm

Thank you GreenJimll for your quick answer.

Regarding the interrupted connection to the MySQL server:
That was also my first thought about the possible causes (RT and MariaDB run on different (virtual) servers). In the logs from the database server I did not find any hints. I will test here again with another log level.

However, I wonder why the upgrade was able to run to the end at all.
Especially since the following critical error occurred:
[3011] [Mon Aug 22 17:04:04 2022] [critical]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildAccessTable (/usr/local/src/rt-5.0.3/sbin/…/lib/RT/Attributes.pm:84)

About the database charset:
Following the instructions you mentioned, I added the following entries to our MariaDB conf:
/etc/mysql/my.cnf
[mysqld]
character-set-server = utf8mb4

[client]
default-character-set = utf8mb4

and restart the DB:
systemctl restart mariadb.service

Is there anything else that needs to be taken into account here? Have I overlooked something?

Regards
Patrick

plast · September 20, 2022, 8:28am

Hi GreenJimll,

your assumption was correct. It was due to the MariaDB settings. In /etc/mysql/my.cnf the value for wait_timeout was set to 600, which is obviously too low.

I had initially only looked at the settings in /etc/mysql/conf.d/local.cnf.

Regards
Patrick