Issues when using mysql with galaxy
Hi I am using python 2.6.4 and the latest version of galaxy. I am attempting to install galaxy on my local ubuntu desktop. I can upload files and the history is updated correctly with sqlite In order to use mysql I get the schema from sqlite using sqlite3 universe.sqlite .dump > ./temp.sql I edited temp.sql to replace some quote around column names with `` . I also moved the lone insert statement to the bottom.(file attached) I use this sql script to initialize the mysql d/b named galaxy. I use this line for the database connection in universe_wsgi.ini database_connection = mysql://{username}:{password}@localhost/galaxy?unix_socket=/var/run/mysqld/mysqld.sock When i start galaxy it seems ok until i try uploading a file when i get |a RuntimeError: maximum recursion depth exceeded in the history pane on the right. Traceback attached. |When I actually upload a file in sqlite and them dump out the schema it generates additional inserts for event etc. When I apply those inserts and then start up galaxy, I don't get this error on uploading the file. However the file upload never completes even for a really small file. I get the animated upload sign forever. Thanks Sriram
participants (1)
-
Sriram Raghuraman