[galaxy-user] upgrade script
Hi, I'm trying to use the upgrade script given that the current schema is now version 90. I get the following error. Can anyone point me out, maybe there is something to do before upgrading? thanks in advance. Victor trying to start galaxy I get Traceback (most recent call last): File /opt/galaxy/galaxy-dist-original/lib/galaxy/web/buildapp.py, line 82, in app_factory app = UniverseApplication( global_conf = global_conf, **kwargs ) File /opt/galaxy/galaxy-dist-original/lib/galaxy/app.py, line 32, in __init__ create_or_verify_database( db_url, kwargs.get( 'global_conf', {} ).get( '__file__', None ), self.config.database_engine_options ) File /opt/galaxy/galaxy-dist-original/lib/galaxy/model/migrate/check.py, line 105, in create_or_verify_database % ( db_schema.version, migrate_repository.versions.latest, config_arg ) ) Exception: Your database has version '90' but this code expects version '79'. Please backup your database and then migrate the schema by running 'sh manage_db.sh -c ./universe_wsgi.runner.ini upgrade'. Removing PID file runner0.pid --trying to upgrade sh manage_db.sh -c ./universe_wsgi.runner.ini upgrade Traceback (most recent call last): File ./scripts/manage_db.py, line 63, in module main( repository=repo, url=db_url ) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/shell.py, line 150, in main ret = command_func(**kwargs) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py, line 221, in upgrade return _migrate(url, repository, version, upgrade=True, err=err, **opts) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py, line 327, in _migrate changeset = schema.changeset(version) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/schema.py, line 173, in changeset changeset = self.repository.changeset(database, start_ver, version) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py, line 170, in changeset changes = [self.version(v).script(database, op) for v in versions] File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py, line 145, in version return self.versions.version(*p, **k) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/version.py, line 125, in version return self.versions[VerNum(vernum)] KeyError: VerNum(90) ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
Re: [galaxy-user] upgrade script
Hello Victor, The following statement in your log is concerning because it looks like something in your environment got corrupted in some way. Exception: Your database has version '90' but this code expects version '79'. Clean database schema migration upgrades go from smaller to larger numbers (e.g., 89 - 90, 90 - 91, etc). Your migrate_versions.version database table column has a value of 90, but your ~/lib/galaxy/model/migrate/versions sub-directory has scripts only up to 0079... (or so it seems). Not sure how best to fix the problem... Greg Von Kuster On Feb 21, 2012, at 2:21 PM, Victor Ruotti wrote: Hi, I'm trying to use the upgrade script given that the current schema is now version 90. I get the following error. Can anyone point me out, maybe there is something to do before upgrading? thanks in advance. Victor trying to start galaxy I get Traceback (most recent call last): File /opt/galaxy/galaxy-dist-original/lib/galaxy/web/buildapp.py, line 82, in app_factory app = UniverseApplication( global_conf = global_conf, **kwargs ) File /opt/galaxy/galaxy-dist-original/lib/galaxy/app.py, line 32, in __init__ create_or_verify_database( db_url, kwargs.get( 'global_conf', {} ).get( '__file__', None ), self.config.database_engine_options ) File /opt/galaxy/galaxy-dist-original/lib/galaxy/model/migrate/check.py, line 105, in create_or_verify_database % ( db_schema.version, migrate_repository.versions.latest, config_arg ) ) Exception: Your database has version '90' but this code expects version '79'. Please backup your database and then migrate the schema by running 'sh manage_db.sh -c ./universe_wsgi.runner.ini upgrade'. Removing PID file runner0.pid --trying to upgrade sh manage_db.sh -c ./universe_wsgi.runner.ini upgrade Traceback (most recent call last): File ./scripts/manage_db.py, line 63, in module main( repository=repo, url=db_url ) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/shell.py, line 150, in main ret = command_func(**kwargs) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py, line 221, in upgrade return _migrate(url, repository, version, upgrade=True, err=err, **opts) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py, line 327, in _migrate changeset = schema.changeset(version) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/schema.py, line 173, in changeset changeset = self.repository.changeset(database, start_ver, version) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py, line 170, in changeset changes = [self.version(v).script(database, op) for v in versions] File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py, line 145, in version return self.versions.version(*p, **k) File /opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/version.py, line 125, in version return self.versions[VerNum(vernum)] KeyError: VerNum(90) ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
Re: [galaxy-user] ftp Server unavailable
Hello Florian, Hopefully you have noticed that the service is up now, but if not, please try your FTP load again and let us know if you continue to have problems. Best, Jen Galaxy team On 2/20/12 3:04 AM, Florian Peschke wrote: ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ -- Jennifer Jackson http://usegalaxy.org http://galaxyproject.org/wiki/Support ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
Re: [galaxy-user] about primer/adaptor removal?
Hello Arthur, The tool NGS: QC and manipulation - FASTX-Toolkit - Clip will remove specified 3' adapter sequence. Other Trim tools in the sections NGS: QC and manipulation - Generic FASTQ manipulation FASTX-Toolkit may be of interest, if you want to clip by length/quality. Hopefully this provides you with some options, Best, Jen Galaxy team On 2/20/12 7:32 AM, Hao Zheng wrote: Hi, Does galaxy provide primer/adaptor removal for NGS (illumina) reads? Thanks. Arthur ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ -- Jennifer Jackson http://usegalaxy.org http://galaxyproject.org/wiki/Support ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
[galaxy-user] Cufflinks related problem
Dear Noa, Can you please tell me the parameters that I should keep while mapping bacterial transcripts using cuffkins. I have kept the default parameters as in Cufflinks and used my custom genome annotation in gff3 format. The cufflinks seems to work Ok but all the FPKM values in these files are zero. As suggested by other users I have checked the correctness of my GFF3 files. The corresponding fasta file was used for mapping the transcripts using Bowtie. Are there any special trick for mapping bacterial transcriptome. regards, Bomba ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
Re: [galaxy-user] Megablast
Hello Scott, For #1, option -p: Here is a link to some megablast parameter documentation online: http://www.ncbi.nlm.nih.gov/staff/tao/URLAPI/megablast.html#3 (the primary paper for the Galaxy tool is noted at the bottom of the tool form, but this is convenient) Quote: Table 3.30 Parameter -p FunctionSpecifies the percentage identity cut-off Default 0 Input format[Real] Example To set percent id cutoff to 75%, use: -p 75 Note: The input value range is between 0 and 100, with 0 meaning no cutoff. It only works on the aligned region or individual HSPs. For #2, there are a few ways to interpret filter. If you mean will megablast consider the adapter part of the sequence in calculations, the answer is that it does for some and doesn't for others. The part of the sequence that is adapter wouldn't align to the genome, and percent identity is only based on HSPs (high scoring pairs - one part of the pair is the DNA query and the other is the genome target, for that alignment region only). So, adapter sequence wouldn't be involved in percent identify calculations (or be expected to!). But, these unaligned regions could become a problem if coverage or certain other statistics were part of your analysis. Learning about the statistics you choose to use, to see if query length is part of the calculation, will let you know if clipping is necessary. If important, removing adapters can be done with tools in NGS: QC and manipulation (perform a tool search on keywords trim or clip. Best, Jen Galaxy team On 2/20/12 4:59 PM, Scott Tighe wrote: Hi Galaxy users When Magablasting 1)what does the identity value -p mean ...is it percent identity? I want my megablast results to be reported form only a 100% match. I do not see a place for % alinement concordance. 2) form my Illumina Hiseq reads, are the adaptor sequences filtered during the filter step? Scott tighe --2 Scott Tighe Advanced Genome Technology Lab Vermont Cancer Center at the University of Vermont 149 Beaumont Avenue Health Science Research Bd RM 305 Burlington Vermont USA 05405 lab 802-656-AGTC (2482) cell 802-999- ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ -- Jennifer Jackson http://usegalaxy.org http://galaxyproject.org/wiki/Support ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
[galaxy-user] merging databases
Hi! Here's a really simple question, but I somehow can't find an easy answer in Galaxy. I want to merge two fastq files (they contain 2 sequencing runs of the same library, and I want to pool them). How do I do that in Galaxy? Thanks! Karel ___ The Galaxy User list should be used for the discussion of Galaxy analysis and other features on the public server at usegalaxy.org. Please keep all replies on the list by using reply all in your mail client. For discussion of local Galaxy instances and the Galaxy source code, please use the Galaxy Development list: http://lists.bx.psu.edu/listinfo/galaxy-dev To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/