{"action":"created","issue":{"url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/1744","repository_url":"https://api.github.com/repos/timgrossmann/InstaPy","labels_url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/1744/labels{/name}","comments_url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/1744/comments","events_url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/1744/events","html_url":"https://github.com/timgrossmann/InstaPy/issues/1744","id":308338327,"number":1744,"title":"\"database is locked\"","user":{"login":"denisemenov","id":3636543,"avatar_url":"https://avatars2.githubusercontent.com/u/3636543?v=4","gravatar_id":"","url":"https://api.github.com/users/denisemenov","html_url":"https://github.com/denisemenov","followers_url":"https://api.github.com/users/denisemenov/followers","following_url":"https://api.github.com/users/denisemenov/following{/other_user}","gists_url":"https://api.github.com/users/denisemenov/gists{/gist_id}","starred_url":"https://api.github.com/users/denisemenov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denisemenov/subscriptions","organizations_url":"https://api.github.com/users/denisemenov/orgs","repos_url":"https://api.github.com/users/denisemenov/repos","events_url":"https://api.github.com/users/denisemenov/events{/privacy}","received_events_url":"https://api.github.com/users/denisemenov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-03-25T10:28:29Z","updated_at":"2018-05-11T09:17:24Z","closed_at":null,"author_association":"NONE","body":"I do not know why, but I always have such a mistake.\r\nI tried to run only 1 script on the server, but still have this error.\r\nThis error can appear both at the beginning of the script execution (example below), and after a few hours.\r\nI did not find any patterns in the appearance of this error.\r\n\r\n<!-- Is this a Feature Request ? Please, check out our Wiki first https://github.com/timgrossmann/InstaPy/wiki -->\r\n## Expected Behavior\r\n\r\n## Current Behavior\r\n\r\n```\r\nINFO [2018-03-25 12:29:04] [username]  Session started - 2018-03-25 12:29:04\r\nINFO [2018-03-25 12:29:22] [username]  Logged in successfully!\r\nINFO [2018-03-25 12:29:24] [username]  Tag [1/11]\r\nINFO [2018-03-25 12:29:24] [username]  --> hashtag\r\n...\r\nbla-bla-bla\r\n...\r\nINFO [2018-03-25 12:30:30] [username]  Session ended - 2018-03-25 12:30:30\r\nINFO [2018-03-25 12:30:30] [username]  --------------------\r\n\r\n\r\nTraceback (most recent call last):\r\n  File \"tags_ds.py\", line 30, in <module>\r\n    interact=True)\r\n  File \"/root/InstaPy/instapy/instapy.py\", line 871, in like_by_tags\r\n    skip_top_posts)\r\n  File \"/root/InstaPy/instapy/like_util.py\", line 178, in get_links_for_tag\r\n    update_activity()\r\n  File \"/root/InstaPy/instapy/util.py\", line 55, in update_activity\r\n    cur.execute(\"SELECT * FROM statistics WHERE created == date('now')\")\r\nsqlite3.OperationalError: database is locked\r\n```\r\n## Possible Solution (optional)\r\n\r\n## InstaPy configuration\r\n```\r\nfrom instapy import InstaPy\r\n\r\ninsta_username = ''\r\ninsta_password = ''\r\n\r\ntry:\r\n    session = InstaPy(username=insta_username,\r\n                    password=insta_password,\r\n                    headless_browser=True,\r\n                    nogui=True,\r\n                    multi_logs=True)\r\n    session.login()\r\n\r\n    # settings\r\n    \r\n    session.set_sleep_reduce(20)\r\n    session.set_upper_follower_count(limit=1814)\r\n    session.set_lower_follower_count(limit=54)\r\n    session.set_user_interact(amount=6,\r\n                              randomize=True,\r\n                              percentage=60,\r\n                              media='Photo')\r\n    session.set_dont_like(['hashtags'])\r\n    session.set_ignore_users(['username'])\r\n\r\n    # actions\r\n    session.like_by_tags(['hashtags'],\r\n                         amount=133,\r\n                         skip_top_posts=True,\r\n                         interact=True)\r\n    session.like_by_locations(['123456789'],\r\n                              amount=133,\r\n                              skip_top_posts=True,\r\n                              interact=True)\r\n\r\nfinally:\r\n    session.end()\r\n\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/comments/388309560","html_url":"https://github.com/timgrossmann/InstaPy/issues/1744#issuecomment-388309560","issue_url":"https://api.github.com/repos/timgrossmann/InstaPy/issues/1744","id":388309560,"user":{"login":"denisemenov","id":3636543,"avatar_url":"https://avatars2.githubusercontent.com/u/3636543?v=4","gravatar_id":"","url":"https://api.github.com/users/denisemenov","html_url":"https://github.com/denisemenov","followers_url":"https://api.github.com/users/denisemenov/followers","following_url":"https://api.github.com/users/denisemenov/following{/other_user}","gists_url":"https://api.github.com/users/denisemenov/gists{/gist_id}","starred_url":"https://api.github.com/users/denisemenov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denisemenov/subscriptions","organizations_url":"https://api.github.com/users/denisemenov/orgs","repos_url":"https://api.github.com/users/denisemenov/repos","events_url":"https://api.github.com/users/denisemenov/events{/privacy}","received_events_url":"https://api.github.com/users/denisemenov/received_events","type":"User","site_admin":false},"created_at":"2018-05-11T09:17:24Z","updated_at":"2018-05-11T09:17:24Z","author_association":"NONE","body":"Still have this error. :("}}
{"actor":{"display_login":"denisemenov"}}