Hi, I'm trying to drop my database and create a new one through the command line. I login using I get the error 'database databasename is being accessed by other users'. I shutdown apache and tried this and am still getting this error. Am I doing something wrong? Thanks EDIT: Traceback (most recent call last): File "drop.py", line 4, in <module> server.delete_db(session_id, 'abcd', 'postgresql') File "/usr/local/lib/python2.7/xmlrpclib.py", line 1224, in call return self.send(self.name, args) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1570, in request verbose=self.verbose File "/usr/local/lib/python2.7/xmlrpclib.py", line 1264, in request return self.single_request(host, handler, request_body, verbose) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1297, in single_request return self.parse_response(response) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1468, in parse_response return u.close() File "/usr/local/lib/python2.7/xmlrpclib.py", line 793, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: <fault 1:="" 'database="" "abcd"="" is="" being="" accessed="" by="" other="" usersklzzwxh:0002'=""> asked 15 Aug '11, 23:42 iman453
showing 5 of 8
show 3 more comments
|
Dropping and creating tables through the Creating and deleting databases using our API is quite simple; please see the syntax reference. In Python, this would be as simple as something like this (for mysql, similar for postgresql):
Hope that helps! answered 16 Aug '11, 00:10 ryans ♦♦ Thanks for your reply ryans. I get the same database is being accessed by other users error when I try and drop my database using the api. (I've edited my question to have the stacktrace)
(16 Aug '11, 00:16)
iman453
|
Can you try deleting the database from the panel as described here?
http://docs.webfaction.com/user-guide/databases.html#delete-a-database
Thanks for your reply. I am not able to. Once I click on the delete button it takes me to an error page.
Did you also comment out the crontab for your app that restarts it?
If not, can you try doing that using "crontab -e"?
I forgot that, but I'm still getting that error after commenting it out, stopping apache and running the api commands.
Also when I try to kill the running processes through phppgadmin, I get the error "SQL error:
ERROR: must be superuser to signal other server processes"
Can you file a support ticket so that we can take an further look into this problem?
Do I do that through the contact us page? http://www.webfaction.com/contact
You can do that through our ticketing system at:
https://help.webfaction.com/