{"action":"created","issue":{"url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/289","labels_url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/289/labels{/name}","comments_url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/289/comments","events_url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/289/events","html_url":"https://github.com/MyEssentials/MyTown2/issues/289","id":101660711,"number":289,"title":"Some users are unable to make towns.","user":{"login":"Flenix","id":856762,"avatar_url":"https://avatars.githubusercontent.com/u/856762?v=3","gravatar_id":"","url":"https://api.github.com/users/Flenix","html_url":"https://github.com/Flenix","followers_url":"https://api.github.com/users/Flenix/followers","following_url":"https://api.github.com/users/Flenix/following{/other_user}","gists_url":"https://api.github.com/users/Flenix/gists{/gist_id}","starred_url":"https://api.github.com/users/Flenix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Flenix/subscriptions","organizations_url":"https://api.github.com/users/Flenix/orgs","repos_url":"https://api.github.com/users/Flenix/repos","events_url":"https://api.github.com/users/Flenix/events{/privacy}","received_events_url":"https://api.github.com/users/Flenix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-08-18T13:53:05Z","updated_at":"2015-08-18T15:00:44Z","closed_at":null,"body":"Hello.\r\n\r\nThis has been an ongoing issue for me - for a few months now. Recently I've really been trying to get it sorted though as it is having an impact on my new players.\r\n\r\nI was originally using Sqlite for my data storage, and noticed every time someone tried to make a town it would spam the console with database locks issues. The town would be created but under the name SERVER ADMINS, and the resident wouldn't own the town. The resident would get a message stating the plot they were in was already claimed - /t map shows no areas nearby claimed at all.\r\n\r\nI asked on IRC and AfterWind told me it was a TPS related issue. However, I logged the TPS for a while and it stayed at a flat 20, until someone did a town command where the DB would lock and the TPS would fall to around 12 for a few minutes, then return to normal.\r\n\r\nAfter more discussion on IRC, I was told that switching to MySQL would solve the issue. I attempted to convert my database but couldn't get it working (Not very good with DB stuff), so ended up just creating an entirely new MySQL and recreating towns.\r\n\r\nThis didn't fix my issue at all - newbies who try and make town still often get the same issue. However, there's nothing in the console about a database lock, and the TPS is totally unaffected. Been trying to ask on IRC for a few days but haven't got a reply.\r\n\r\n\r\nTL;DR. Users can't make towns sometimes, Using MySQL, TPS is fine\r\nhttp://ctrlv.in/622153\r\n\r\n(Note I deleted most of the SERVER ADMINS towns just left that as an example.)"},"comment":{"url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/comments/132240665","html_url":"https://github.com/MyEssentials/MyTown2/issues/289#issuecomment-132240665","issue_url":"https://api.github.com/repos/MyEssentials/MyTown2/issues/289","id":132240665,"user":{"login":"Flenix","id":856762,"avatar_url":"https://avatars.githubusercontent.com/u/856762?v=3","gravatar_id":"","url":"https://api.github.com/users/Flenix","html_url":"https://github.com/Flenix","followers_url":"https://api.github.com/users/Flenix/followers","following_url":"https://api.github.com/users/Flenix/following{/other_user}","gists_url":"https://api.github.com/users/Flenix/gists{/gist_id}","starred_url":"https://api.github.com/users/Flenix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Flenix/subscriptions","organizations_url":"https://api.github.com/users/Flenix/orgs","repos_url":"https://api.github.com/users/Flenix/repos","events_url":"https://api.github.com/users/Flenix/events{/privacy}","received_events_url":"https://api.github.com/users/Flenix/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T15:00:44Z","updated_at":"2015-08-18T15:00:44Z","body":"Alright, let me know if you need anything more from me\r\n"}}