Hello @all
I followed this doc (https://docs.centreon.com/docs/upgrade/upgrade-from-21-10/) for upgrade centreon 21.10.6 to 22.04 and I have this message that keeps looping
any help would be welcome
Cordially
Best answer by Kriko
View original
Upgrade problem 21.10.6 to 22.04
+3
Page 1 / 2
+3
UP?
Userlevel 6
+19
Anything showing up in the brower debug console?
+3
Userlevel 6
+19
I meant browser console, not tty. You can display it with F12 and hit refresh.
+3
oups sorry
here:
Userlevel 6
+19
What do you have in the Network tab?
+3
nothing
+3
fuck
It seem to be a reinstall of Centreon :(
+3
Still have the issue
I would reinstall only if I had no choice.
It annoys me because these are situations that could be avoided
Being an sysadmin, I don't want to start all over again.
Ok, in the network tab, if you click on upgrade.php ? What did you have in the detail response pannel ?
Here an example:
+3
It seem to be I have not the same information on Vivaldi :
On firefox:
Got it!
And on step4.php or process_step4.php ?
What did you get in the response ?
Did you something in the upgrade.log in /var/log/centreon/ ?
+3
I see this on the last upgrade process :
Detail:
{ "result" : "1", "current" : "21.10.6", "next" : "22.04.0-beta.1", "msg" : "UPGRADE - 22.04.0-beta.1: Impossible to add \\"login_attempts\\" and \\"blocking_time\\" columns to \\"contact\\" table" }
and this:
Detail:
Error: [object Event] msg.js:143:38
Uncaught SyntaxError: JSON.parse: expected ',' or '}' after property value in object at line 5 column 65 of the JSON data
nextStep http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:37
jQuery 6
doProcess http://172.23.62.214/centreon/install/upgrade.php:40
nextStep http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:32
<anonymous> http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:13
jQuery 11
<anonymous> http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:8
jQuery 14
<anonymous> http://172.23.62.214/centreon/install/upgrade.php:17
jQuery 13
upgrade.php line 2 > injectedScript:37:35
Ok so it’s sql request that failed.
Could you check in /var/log/centreon/sql-error.log or /var/log/centreon/upgrade.log if you successed to catch the request ? (should be a INSERT)
And you connect to your database and return me the output of:
use centreon;
desc contact;
+3
On /var/log/centreon/upgrade.log
2022-05-25 09:02|0|0|UPGRADE - 22.04.0-beta.1: Impossible to add "login_attempts" and "blocking_time" columns to "contact" table - Code : 42000 - Error : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.1.php(77): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')
#3 {main}On /var/log/centreon/sql-error.log
2022-05-25 09:02|0|0|SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE contact
ADD login_attempts INT(11) UNSIGNED DEFAULT NULL,
ADD blocking_time BIGINT(20) UNSIGNED DEFAULT NULLAnd the result of contact table:
MariaDB [centreon]> use centreon;
Database changed
MariaDB [centreon]> desc contact;
+--------------------------------------+--------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------------+--------------------------+------+-----+---------+----------------+
| contact_id | int(11) | NO | PRI | NULL | auto_increment |
| timeperiod_tp_id | int(11) | YES | MUL | NULL | |
| timeperiod_tp_id2 | int(11) | YES | MUL | NULL | |
| contact_name | varchar(200) | YES | MUL | NULL | |
| contact_alias | varchar(200) | YES | MUL | NULL | |
| contact_passwd | varchar(255) | YES | | NULL | |
| contact_lang | varchar(255) | YES | | browser | |
| contact_host_notification_options | varchar(200) | YES | | NULL | |
| contact_service_notification_options | varchar(200) | YES | | NULL | |
| contact_email | varchar(200) | YES | | NULL | |
| contact_pager | varchar(200) | YES | | NULL | |
| contact_address1 | varchar(200) | YES | | NULL | |
| contact_address2 | varchar(200) | YES | | NULL | |
| contact_address3 | varchar(200) | YES | | NULL | |
| contact_address4 | varchar(200) | YES | | NULL | |
| contact_address5 | varchar(200) | YES | | NULL | |
| contact_address6 | varchar(200) | YES | | NULL | |
| contact_comment | text | YES | | NULL | |
| contact_js_effects | enum('0','1') | YES | | 0 | |
| contact_location | int(11) | YES | | 0 | |
| contact_oreon | enum('0','1') | YES | | NULL | |
| reach_api | int(11) | YES | | 0 | |
| reach_api_rt | int(1) | YES | | 0 | |
| contact_enable_notifications | enum('0','1','2') | YES | | 2 | |
| contact_template_id | int(11) | YES | MUL | NULL | |
| contact_admin | enum('0','1') | YES | | 0 | |
| contact_type_msg | enum('txt','html','pdf') | YES | | txt | |
| contact_activate | enum('0','1') | YES | | NULL | |
| contact_auth_type | varchar(255) | YES | | | |
| contact_ldap_dn | text | YES | | NULL | |
| ar_id | int(11) | YES | MUL | NULL | |
| contact_acl_group_list | varchar(255) | YES | | NULL | |
| contact_autologin_key | varchar(255) | YES | | NULL | |
| default_page | int(11) | YES | | NULL | |
| show_deprecated_pages | enum('0','1') | YES | | 0 | |
| contact_charset | varchar(255) | YES | | NULL | |
| contact_register | tinyint(6) | NO | | 1 | |
| contact_ldap_last_sync | int(11) | NO | | 0 | |
| contact_ldap_required_sync | enum('0','1') | NO | | 0 | |
| enable_one_click_export | enum('0','1') | YES | | 0 | |
+--------------------------------------+--------------------------+------+-----+---------+----------------+
40 rows in set (0.003 sec)
Could you execute the following request on your database:
ALTER TABLE centreon.contact ROW_FORMAT=DYNAMIC;and try again the upgrade ?
+3
I have this
2022-05-25 09:48|0|0|UPGRADE - 22.04.0-beta.2: Unable to remove log_archive_path,log_rotation_method,daemon_dumps_core from cfg_nagios table - Code : 42000 - Error : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.2.php(39): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')2022-05-25 09:48|0|0|SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE cfg_nagios
DROP COLUMN log_archive_path,
DROP COLUMN log_rotation_method,
DROP COLUMN daemon_dumps_core
This just keeps getting better :’)
In the log upgrade.log and sql-error.log what did we get now ?
+3
yes it’s better
2022-05-25 09:48|0|0|UPGRADE - 22.04.0-beta.2: Unable to remove log_archive_path,log_rotation_method,daemon_dumps_core from cfg_nagios table - Code : 42000 - Error : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.2.php(39): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')
2022-05-25 09:48|0|0|SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE cfg_nagios
DROP COLUMN log_archive_path,
DROP COLUMN log_rotation_method,
DROP COLUMN daemon_dumps_core
Ok we need to do the same request as previously :
ALTER TABLE centreon.cfg_nagios ROW_FORMAT=DYNAMIC;
+3
Damn you save my life :)
Many Thanks 😗😀
Other questions if I can abuse your time? :
1- I have this odd status details, normal ?
2- With the switch to Gorgone can I remove the cencore service?
3- Can I contact you again if I have other problems?
4- Why this problem ??? Very odd...
And many thanks again !!!
You are my super heros today 😄
- you can.
- you can post an another question on thewatch, maybe I will answer, maybe someone else :)
- I don’t know. By default the tables are in dynamic mode, here I don’t know why these 2 tables weren’t in dynamic mode
You’re welcome :)
+3
I edit my questions can you see the new first with screenshot ?
Not normal.
Could you create a new post about this one ?
Page 1 / 2
Reply
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.