Hi,
We're upgrading one of our failover pairs from 9.6 CU6 to 9.6 CU23 and found some errors, but seems that the agents upgraded successfully.
From the Upgrade summary there are 3 errors and 14 notices:
I know that the 'TINYINT' error doesn't cause any issues, but what about the other error and the Notices?
172.30.64.138 Error Different column definition for 'elementinfo_dve.dve_enabled': Expected = 'TINYINT NULL DEFAULT 1' Was = 'tinyint'
172.30.64.138 Notice Failed to stop service 'slnet': The service cannot accept control messages at this time.
172.30.64.138 Notice 'net' Process exited with exit code 2
172.30.64.138 Notice 'net' Process exited with exit code 2
172.30.64.138 Notice 'net' Process exited with exit code 2
172.30.64.138 Notice 'net' Process exited with exit code 2
172.30.64.138 Notice 'net' Process exited with exit code 2
172.30.64.138 Notice [FAILED] Start Service slnet
172.30.64.139 Error Different column definition for 'elementinfo_dve.dve_enabled': Expected = 'TINYINT NULL DEFAULT 1' Was = 'tinyint'
172.30.64.139 Error Exception during unicode conversion for table rep_prefetch_severities : Invalid column name 'dmaid'.
172.30.64.139 Notice Failed to stop service 'slnet': The service cannot accept control messages at this time.
172.30.64.139 Notice 'net' Process exited with exit code 2
172.30.64.139 Notice 'net' Process exited with exit code 2
172.30.64.139 Notice 'net' Process exited with exit code 2
172.30.64.139 Notice 'net' Process exited with exit code 2
172.30.64.139 Notice 'net' Process exited with exit code 2
172.30.64.139 Notice [FAILED] Start Service slnet
Hi Carlos
Sorry for the delayed response.
I see 3 other messages, besides the TinyInt messages:
- "Notice 'net' Process exited with exit code 2"
+ "Notice [FAILED] Start Service slnet"
We've seen this in the past, but noticed no impact on the system. - Exception on the rep_prefetch_severities table
This table is used as a kind of cache for the reporter. It is optional and the only benefit is a small performance increase in the reporter (for severities).
In other words, these messages can be ignored.
However, please know that it's always useful for us to improve the software (even if it's removing non-helpful messages).
So you can always send the progress.log file of the upgrade to techsupport. Please also include some additional information like server OS, cluster or single agent,...