search

OCSInventory-NG / OCSInventory-Server

Communication server of OCS Inventory
http://www.ocsinventory-ng.org/
GNU General Public License v2.0
344 stars 139 forks source link

Update 2.8 to 2.9 #327

Closed nohnaimer closed 3 years ago

nohnaimer commented 3 years ago

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : CentOS Linux 8 x64

Server informations

Perl version : v5.26.3 Percona version : 8.0.21-12

OCS Inventory informations

Ocs server version : 2.9

Problem's description

Installed OCS Inventory Server from repo. After update from 2.8 to 2.9 inventory won't work. In error_log apache:

DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.
DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.

In activity.log:

Wed Jun  2 16:32:24 2021;8251;100;M1SSS63-2021-05-19-13-27-02;10.128.16.113;OCS-NG_WINDOWS_AGENT_v2.8.0.0;prolog;accepted
Wed Jun  2 16:32:24 2021;8251;315;M1SSS63-2021-05-19-13-27-02;10.128.16.113;OCS-NG_WINDOWS_AGENT_v2.8.0.0;session;already handled
Wed Jun  2 16:32:24 2021;8251;525;M1SSS63-2021-05-19-13-27-02;10.128.16.113;OCS-NG_WINDOWS_AGENT_v2.8.0.0;session;failed

Any ideas? Update passed without errors...

nohnaimer commented 3 years ago

Fixed this error:

DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.

Change software ID from int to bigint.

charleneauger commented 3 years ago

Hi @nohnaimer ,

This error : Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179. has been fixed in nightly version :
http://download.ocsinventory-ng.org/nightly/

I recommend you to install the latest nightly version to fix it.

And for DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59., clean table conntrack and prolog_conntrack should resolve this error.

Regards, Charlene

nohnaimer commented 3 years ago

Hi, @charleneauger Fix this error:

Use of uninitialized value in pattern match (m//) at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 179.

Replace Software.pm from repo and restart server.

And for DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59., clean table conntrack and prolog_conntrack should resolve this error.

Try - same error.

Errors remained:

DBD::mysql::db do failed: Column 'DATE' cannot be null at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Duplicate.pm line 276.
DBD::mysql::db do failed: Duplicate entry 'SESSION-CLEAN' for key 'engine_mutex.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Communication/Session.pm line 59.
DBD::mysql::st execute failed: Table 'ocsweb.DEVICE' doesn't exist at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm line 146.
nohnaimer commented 3 years ago

One more question: How to from console merge duplicates? Same hostname and serial like example. Because in web I get Gateway Timeout

The gateway did not receive a timely response from the upstream server or application.

nohnaimer commented 3 years ago

After merge duplicates - no errors any more. Ave Me!