4.2.1 SQL error (upgrade-history) on upgrade wizard

[Kappauf]

The upload of upgrades is possible. But I cannot install the upbrade, as following error messages appears.

The following upgrades are ready to be installed:
Query Failed:SELECT id FROM upgrade_history where md5sum = 'b54c30739c3e0d50286e1b87xxxxxx'::MySQL error 2006: MySQL server has gone away

The upgrade_history table has no records.

Thanks for any help.

[kbrill]

do a google search for "error 2006: MySQL server has gone away" and you will find about 10-12 sites explaining fixes. It looks like it has to do with a setting in your mysql.cnf file.

[Kappauf]

kbrill, thanks for your hints.
I had contact to my webhoster, he explained, that the query does not find any records, it keeps searching until time out (several seconds). If I run the querey in mysqladmin, it takes 0.004 seconds with result 0 records found.
Is there a way to fix the update_history table?
Thanks.

[kbrill]

kbrill, thanks for your hints.
I had contact to my webhoster, he explained, that the query does not find any records, it keeps searching until time out (several seconds). If I run the querey in mysqladmin, it takes 0.004 seconds with result 0 records found.
Is there a way to fix the update_history table?
Thanks.

I am afraid that you seem to have gotten ahold of someone at your hosting service that likes to pull your leg. If SQL does not find any records, it returns zero records, it does not (and would be nearly unusable if it did) continue searching until some arbitrary time out. This problem has nothing to do with the table itself, it is (from what I can gather from reading) a settings issue in the mysql.cnf file.

[Kappauf]

excellent, now it works.
My webhoster changed some timeouts in the mysql.cnf file.
Thank you, kbril

[kbrill]

excellent, now it works.
My webhoster changed some timeouts in the mysql.cnf file.
Thank you, kbril

Glad to help and that you had a webhoster that was willing to work with you.