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> 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
>
>  ___________________________________________________________
> 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