search

dmwm / PHEDEX

CMS data-placement suite
8 stars 18 forks source link

" ORA-01012: not logged on" error when uploading data to dmwmmon data service #988

Open nataliaratnikova opened 9 years ago

nataliaratnikova commented 9 years ago

MIT site reported error (1) while uploading data via spacecount. Found two entries in server logs (2) one today, and one 5 days earlier. Here is some explanation of the error : http://psoug.org/oraerror/ORA-01012.htm

(1)

total number of records: 21
Error from server 302(Found), output below:


302 Found


Found


The document has moved here.



exiting after failure

(2) -sh-4.1$ grep failed /build/srv-logs/_/dmwmmon/error_log__.txt /build/srv-logs/vocms0132/dmwmmon/error_log_20150422.txt: (in cleanup) DBD::Oracle::db DESTROY failed: ORA-01012: not logged on /build/srv-logs/vocms0132/dmwmmon/error_log_20150422.txt:'die' without explicit status for "DBD::Oracle::db prepare failed: ORA-01012: not logged on\nProcess ID: 111024\nSession ID: 1140 Serial number: 25767 (DBD ERROR: OCIStmtExecute/Describe) [for Statement "select name, id from t_adm_node where name not like 'X%'"] at /data/srv/beHG1504d/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp5/perl_lib/PHEDEX/Core/DB.pm line 257.\n (for select name, id from t_adm_node where name not like 'X%') at /data/srv/beHG1504d/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp5/perl_lib/PHEDEX/Core/DB.pm line 266.\n" at /data/srv/beHG1504d/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp5/perl_lib/PHEDEX/Web/Util.pm line 693. /build/srv-logs/vocms0133/dmwmmon/error_log_20150427.txt: (in cleanup) DBD::Oracle::db DESTROY failed: ORA-01012: not logged on /build/srv-logs/vocms0133/dmwmmon/error_log_20150427.txt:'die' without explicit status for "DBD::Oracle::db prepare failed: ORA-01012: not logged on\nProcess ID: 71596\nSession ID: 597 Serial number: 63881 (DBD ERROR: OCIStmtExecute/Describe) [for Statement "select name, id from t_adm_node where name not like 'X%'"] at /data/srv/beHG1505b/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp6/perl_lib/PHEDEX/Core/DB.pm line 257.\n (for select name, id from t_adm_node where name not like 'X%') at /data/srv/beHG1505b/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp6/perl_lib/PHEDEX/Core/DB.pm line 266.\n" at /data/srv/beHG1505b/sw.pre/slc6_amd64_gcc481/cms/DMWMMON-datasvc/1.0.2-comp6/perl_lib/PHEDEX/Web/Util.pm line 693.