Yay, thank you so much Dannon! That was the jackpot! My user was also quite 
happy.

Remind me to buy you a beer at the next GCC ;)

Cheers
Christian

On 24/07/15 17:50, Dannon Baker wrote:
Hey Christian,

I used <galaxy_dir>/scripts/db_shell.py and something like 
https://gist.github.com/dannon/e71b7aa9546fcecf6e9e to reset problematic BAM 
metadata.  Basically, it selects all the large metadata and completely strips 
out the new overly large optional attributes, leaving required attributes 
alone.  Once this is done, you can redetect metadata if you'd like (with the 
limits we'd talked about set) and it should all work fine.

Let me know if you need more info, hopefully this helps!

-Dannon

On Fri, Jul 24, 2015 at 11:23 AM Christian Schudoma (TSL) 
<christian.schud...@sainsbury-laboratory.ac.uk<mailto:christian.schud...@sainsbury-laboratory.ac.uk>>
 wrote:
Hi Nate, all

I would like to add my own version of the problem to this.

I, or rather my (inherited) Galaxy instance (which should be running 15.05+, 
how do I find out?), have/s similar symptoms as Richard's did. In my case it 
only occurs to a single user and we are not able to execute the "Saved 
Histories" command any more. Galaxy will fail with


Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /history/list.


Reason: Error reading from remote server

Due to some problem with the psql-client I cannot find the potential 
perpetrators (my user has lots of bam files in various histories) and since he 
cannot switch histories, we cannot even update the metadata for his datasets. 
Is there a possibility to do that via the API?

Any insight/help would be greatly appreciated!

Cheers
Christian


On 08/07/15 21:04, Poole, Richard wrote:

I am having trouble right now with my own personal account on my production 
server. Grid refreshes are taking a huge amount of time (e.g. when viewing 
‘saved histories’ or even generating the dataset list for a single history). My 
account is very full of data (1TB), could it be this?

There are no obvious messages in the logs though so I am a bit stumped as to 
why.I do not have the same trouble when impersonating other users with fairly 
full accounts. Perhaps a database issue (I do not know how to ‘cleanup’ the 
database or indeed Galaxy user accounts). Any thoughts?



--
Dr. Christian Schudoma
Bioinformatics Support Officer

Bioinformatics Group
The Sainsbury Laboratory
Norwich Research Park
Norwich NR4 7UH
United Kingdom
******************************
+44 (0) 1603 450 601
christian.schud...@tsl.ac.uk<mailto:christian.schud...@tsl.ac.uk>

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

Reply via email to