Skip to Content.
Sympa Menu

perfsonar-dev - Re: Problem with SQL-MA ( more problems ...)

Subject: perfsonar development work

List archive

Re: Problem with SQL-MA ( more problems ...)


Chronological Thread 
  • From: Roman Lapacz <>
  • To: maxim <>
  • Cc: "'Jeff W. Boote'" <>, "'Loukik Kudarimoti'" <>, "'Asif, Mohammad'" <>, "'Maciej Glowiak'" <>, , "'Li, Yee-Ting'" <>, "'Nicolas Simar'" <>
  • Subject: Re: Problem with SQL-MA ( more problems ...)
  • Date: Fri, 19 Jan 2007 12:16:05 +0100


Could you send the request you used?

Roman


maxim wrote:
one more problem I've encountered. I've compiled my XML file with MA store
request message inside and
tried to store it into the SQL MA DB ( I've configured it to place unix
timestamps).
then I run ant and in response I;ve got "success.ma.write". But in DB table
I;ve got some strange entries.
First of all, it seems like DB doesn't understand from what datum the info
came from ( means there is no way to query
for the part of the global link). Then one of my entries got status_admin
cut of, see:
+-----------------------+---------------------+-------------+---------------
--+--------------+----------+
| id | time | status_oper | status_admin
| alarm_id_set | comments |
+-----------------------+---------------------+-------------+---------------
--+--------------+----------+
| CERN-FERMI-LHCOPN-002 | 2007-01-18 17:46:45 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:46:45 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:46:45 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:46:45 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-002 | 2007-01-18 17:46:45 | Up | lOperation
| NULL | NULL |
| CERN-FERMI-LHCOPN-002 | 2007-01-18 17:50:01 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-002 | 2007-01-18 17:50:01 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:50:01 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:50:01 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-001 | 2007-01-18 17:50:01 | Up |
NormalOperation | NULL | NULL |
| CERN-FERMI-LHCOPN-002 | 2007-01-18 17:50:01 | Up | lOperation
| NULL | NULL |
+-----------------------+---------------------+-------------+---------------
--+--------------+----------+

Thanks,
Maxim.




--

// PSNC, Poland
// phone: (+48 61) 858 20 24
// http://www.man.poznan.pl




Archive powered by MHonArc 2.6.16.

Top of Page