Ticket #208 (new defect)

Opened 9 years ago

Last modified 6 years ago

wave_serverV bug on exact time select

Reported by: Hal Simpson Owned by: somebody
Priority: major Milestone:
Component: wave_serverV Version: 7.6
Keywords: Cc:

Description

Hi Paul and Stefan

So we ran into a problem with the waveservers that I was hoping you could look into. Whenever I ask for a time range that ends at exactly the same time as the data in the waveserver, the query times out. We are using GeomagEW, and asking for the previous 24 hours of data. Everything was working fine, until we decided to subtract 5 minutes off the current time, and align it with the closest minute, in order to minimize the amount of blank data at the end. As it turns out, that was randomly lining up with the end of some of the channels, and everytime that happens, the waveserver times out.

I was hoping you could look into this, and see if its an easy fix or not.

Thanks

Hal Simpson IT Specialist USGS Geomagnetism Program Office:303-273-8485 Email:hasimpson@usgs.gov

more:

I'm not certain you can recreate it. It looks like this is happening with one waveserver I'm using, but not another. But it IS most definitely happening.

If you can't recreate it, we can get you hooked up to the waveserver where it's happening.

As a work around, I'm just adding 30 seconds to the end time. But that's a poor patch, if you don't think you can get to it soon, I'll go ahead and compare the end times from the menu, and then add 30 seconds if needed.

Thanks

Change History

comment:1 Changed 9 years ago by stefan

Hal says about OS: igskcicgusboldt redhat uname is returning 2.6.32-220.4.2.el6.x86_64

comment:2 Changed 6 years ago by et

I tried to reproduce this by using 'waveman2disk' to query a 'wave_serverV' (populated by running a "memphis" test), but was unable make any delays or unresponsiveness occur. Is this issue still seen out there? Any ideas on how to reproduce it?

In the code it looks like request parameters go into an SQL query in the 'tbdb_get_all_packets()' function in "tb_packet_db.c".

--ET

Note: See TracTickets for help on using tickets.