Ticket #227 (closed defect: fixed)

Opened 8 years ago

Last modified 8 years ago

portal reservation status on SM not showing correct status

Reported by: anirban Owned by: prateek
Priority: major Milestone: Camano 3.1
Component: Don't Know Version: baseline
Keywords: Cc:

Description

The portal reservations' status for the service manager container has stopped working. It shows reservations in wrong states and doesn't show some. This must be an artifact of the recent checkin where I have seen bunch of changes in the velocity files. Snapshot of status page also attached. Prateek, you must look into this. The xmlrpc controller returns the correct state of the reservations, though.

Querying ORCA xml-rpc server for status of the sliver...

*************************************************************

[ Reservation UID: 6de7a266-3e7c-4a08-890e-bebc36ecf1b0 | Resource Type: acisrencivmsite.vm | Units: 4 | Status: Active ]
*************************************************************
[ Reservation UID: b95b9251-0915-4d9a-87cf-38d188accd33 | Resource Type: starlight.vlan | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: d1422cb8-3d0b-4fb6-a7d9-1be5a540051d | Resource Type: esnet.vlan | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: 92eb8805-ceb3-461c-a43b-5dc6cfc069ea | Resource Type: nerscvmsite.vm | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: 2009e3aa-7261-42c4-bf63-3eb7c3b4d179 | Resource Type: ben.vlan | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: 9b55591f-ae26-4679-bc96-ab079057f3e6 | Resource Type: nlr.vlan | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: 223db8bc-8209-4659-9d57-817806fd4ef0 | Resource Type: nerscNet.vlan | Units: 1 | Status: Active ]
*************************************************************
[ Reservation UID: 157e0db9-06b2-4fe2-872a-2e0cee1727b5 | Resource Type: acisrenciNet.vlan | Units: 1 | Status: Active ]
Overall Sliver Status: ready

Attachments

sm-snapshot.pdf (307.3 kB) - added by anirban 8 years ago.

Change History

Changed 8 years ago by anirban

Changed 8 years ago by ibaldin

  • milestone set to Camano 3.1

Changed 8 years ago by prateek

  • status changed from new to accepted

At first estimate it does not seem to be because of the abac related changes to the velocity files. This because firstly no changes were made to the status page or any of the related code and secondly the changes that were made to the frontend are not seen in the currently running version.

So, I feel http://geni.renci.org:11080/orca/ is still running the old code, at least the web portal part of it.

Changed 8 years ago by prateek

I think the best way to check the inconsistency would be to look at the actual status of the reservation in the database and then analyze the code to figure out the bug.

Changed 8 years ago by prateek

I checked the database on http://geni.renci.org:11080/orca/ for reservation with id 2009e3aa-7261-42c4-bf63-3eb7c3b4d179 and found the following properties that result in the state being "Obtaining Ticket"

ReservationState?=1
ReservationPending?=2

So the reservation status being displayed on the web portal is in sync with the database.

The next step is to look at how xmlrpc controller is calculating the state of a reservation.

Changed 8 years ago by prateek

Sorry in the earlier comment I meant the database on geni.renci.org

Changed 8 years ago by prateek

The xmlrpc controller gets the status from the in memory data structure, which I think has a different status. If that is the case then we need to figure out as to why the in memory data is not in sync with the database.

Changed 8 years ago by anirban

It seems to only manifest for reservations for only certain types of resources, for eg. the BEN vlan and the NLR vlan. Would cleaning up the database on geni.renci.org help ?

Changed 8 years ago by anirban

  • status changed from accepted to closed
  • resolution set to fixed

This was fixed by changing max_allowed_packet for mysqld . The query strings were too long.

Note: See TracTickets for help on using tickets.