{"action":"closed","issue":{"url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/311","labels_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/311/labels{/name}","comments_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/311/comments","events_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/311/events","html_url":"https://github.com/openlink/virtuoso-opensource/issues/311","id":55375510,"number":311,"title":"Latest dev install: tsql2, tlubm and obackup fails + SQ200: No column t6.S.Query execution error","user":{"login":"fgiasson","id":216022,"avatar_url":"https://avatars.githubusercontent.com/u/216022?v=3","gravatar_id":"","url":"https://api.github.com/users/fgiasson","html_url":"https://github.com/fgiasson","followers_url":"https://api.github.com/users/fgiasson/followers","following_url":"https://api.github.com/users/fgiasson/following{/other_user}","gists_url":"https://api.github.com/users/fgiasson/gists{/gist_id}","starred_url":"https://api.github.com/users/fgiasson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fgiasson/subscriptions","organizations_url":"https://api.github.com/users/fgiasson/orgs","repos_url":"https://api.github.com/users/fgiasson/repos","events_url":"https://api.github.com/users/fgiasson/events{/privacy}","received_events_url":"https://api.github.com/users/fgiasson/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-01-24T16:01:23Z","updated_at":"2015-01-26T20:40:45Z","closed_at":"2015-01-26T20:40:45Z","body":"Hi @HughWilliams, @iv-an-ru,\r\n\r\nI just installed the latest code as of today and the following 3 tests suites are failing:\r\n\r\n * `tlubm`\r\n * `tsql2`\r\n * `obackup`\r\n\r\nYou can see the `.output` files of these suites for debugging purposes here: \r\n\r\n    https://gist.github.com/fgiasson/79132e7d5887c9dc66dc\r\n\r\nAlso, if I ignore them and run the OSF tests suites, I am eventually getting that error:\r\n\r\n```\r\n[unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso Server]VD032: remote prepare: SQ200: No column t6.S.Query execution error\r\n```\r\n\r\nfor the following SPARQL query: \r\n\r\n```\r\n                    prefix wsf: <http://purl.org/ontology/wsf#>\r\n                    select distinct ?dataset ?title ?description ?creator ?created ?modified ?holdOntology ?contributor\r\n                    from named <http://localhost/wsf/>\r\n                    from named <http://localhost/wsf/datasets/>\r\n                    where\r\n                    {\r\n                      graph <http://localhost/wsf/>\r\n                      {\r\n                        <http://localhost/wsf/users/1> a wsf:User ;\r\n                          wsf:hasGroup ?group .\r\n                          \r\n                        ?access wsf:groupAccess ?group ;\r\n                                wsf:datasetAccess ?dataset .                      \r\n                      }\r\n                      \r\n                      graph <http://localhost/wsf/datasets/>\r\n                      {\r\n                        ?dataset a <http://rdfs.org/ns/void#Dataset> ;\r\n                        <http://purl.org/dc/terms/created> ?created.\r\n                    \r\n                        OPTIONAL{?dataset <http://purl.org/dc/terms/title> ?title.}\r\n                        OPTIONAL{?dataset <http://purl.org/dc/terms/description> ?description.}\r\n                        OPTIONAL{?dataset <http://purl.org/dc/terms/modified> ?modified.}\r\n                        OPTIONAL{?dataset <http://purl.org/dc/terms/contributor> ?contributor.}\r\n                        OPTIONAL{?dataset <http://purl.org/dc/terms/creator> ?creator.}\r\n                        OPTIONAL{?dataset <http://purl.org/ontology/wsf#holdOntology> ?holdOntology.}\r\n                      }    \r\n                    } ORDER BY ?title\r\n```\r\n\r\nThe installation steps I used are:\r\n\r\n```\r\n# Step virtuoso to take care of the DB file\r\n/etc/init.d/virtuoso stop\r\n\r\n# wait 20 seconds\r\n\r\n# Backup db folder... just in case...\r\ncd /var/lib/virtuoso/\r\nzip -9 -r db.zip db\r\n\r\n# Get the latest sources\r\nmkdir /tmp/virtuoso\r\ncd /tmp/virtuoso\r\nwget https://github.com/openlink/virtuoso-opensource/archive/develop/7.zip\r\nunzip 7.zip\r\ncd /tmp/virtuoso/virtuoso-opensource-develop-7\r\n\r\n# Install prerequired packages\r\naptitude install dpkg-dev build-essential\r\napt-get install autoconf automake libtool flex bison gperf gawk m4 make libxml2-dev libssl-dev libreadline-dev\r\n\r\n\r\n# Compile the new Virtuoso\r\nCFLAGS=\"-O2 -m64\"\r\nexport CFLAGS\r\n./autogen.sh\r\n./configure --with-readline --program-transform-name=\"s/isql/isql-v/\"\r\nnice make\r\nnice make check\r\nnice make install\r\n```\r\n\r\nThis is a 64 bits servers running Ubuntu 14.04.1 LTS. All the packages are up to date.\r\n\r\n\r\n\r\n"}}