Just wanted to say that we just started encountering this issue as well. So far, nothing seems out of the ordinary about the server:
* All backend services are running * All DB connections are fine * There's plenty of disc space The issue appeared after a server restart. I'll let you know if we discover anything. On Jan 11, 3:51 am, Markus Fischer <[email protected]> wrote: > Hi, > > I know it's a bit frowned upon to bump such things on mailing list, it's > just I can't solve this and I really would like to give gitorious a > serious shot. So if anyone can spare some insights, it's gladly appreciated. > > thanks > > On 23.12.2011 15:39, Markus Fischer wrote: > > > > > > > > > Hi, > > > I followed > >http://gitorious.org/gitorious/pages/DebianSqueezeInstallationas > > closely as possible and I got it basically running, however when I want > > to create a new project as admin, I get this very strange "lock wait > > timeout exceeded" erorrs. > > > It is a very very strange behavior I've never encountered before. > > > When I create a new project, I enter title/description and hit the > > button. The browser starts loading, never returns; eventually I press > > ESC to stop loading, hit F5 and or try it again. What I get looks for > > example like this:https://gist.github.com/02a581565f6a60bb2b77. > > > When I take the included SQL statement and execute it, I can reproduce > > this timeout problem. > > > But now consider this: > > > Before I create a new project at all, write this SQL statement to the > > server (basically I only provide Title and slug): > > > INSERT INTO `gitorious_production`.`projects` ( > > `id` , > > `title` , > > `description` , > > `user_id` , > > `created_at` , > > `updated_at` , > > `slug` , > > `license` , > > `home_url` , > > `mailinglist_url` , > > `bugtracker_url` , > > `owner_id` , > > `owner_type` , > > `wiki_enabled` , > > `site_id` , > > `merge_requests_need_signoff` , > > `oauth_signoff_key` , > > `oauth_signoff_secret` , > > `oauth_signoff_site` , > > `oauth_path_prefix` , > > `merge_request_custom_states` , > > `suspended_at` > > ) > > VALUES ( > > NULL , 'Somethingsmells', NULL , NULL , NULL , NULL , 'somethingsmells', > > NULL , NULL , NULL , NULL , NULL , NULL , '1', NULL , '0', NULL , NULL , > > NULL , NULL , NULL , NULL > > ); > > > It executes absolutely perfectly fine! I truncate the projects table, go > > into gitorious, create a project named "Somethingsmells", hit the > > button: eventually after a long loading time, I get a 500 error and the > > log as above (I used another title in the logs then here; I do not > > always get email notification with these errors). > > > Now I re-execute the above SQL-Statement and this is what I get: > > > INSERT INTO `gitorious_production`.`projects` ( > > `id` , > > `title` , > > `description` , > > `user_id` , > > `created_at` , > > `updated_at` , > > `slug` , > > `license` , > > `home_url` , > > `mailinglist_url` , > > `bugtracker_url` , > > `owner_id` , > > `owner_type` , > > `wiki_enabled` , > > `site_id` , > > `merge_requests_need_signoff` , > > `oauth_signoff_key` , > > `oauth_signoff_secret` , > > `oauth_signoff_site` , > > `oauth_path_prefix` , > > `merge_request_custom_states` , > > `suspended_at` > > ) > > VALUES ( > > NULL , 'Somethingsmells', NULL , NULL , NULL , NULL , 'somethingsmells', > > NULL , NULL , NULL , NULL , NULL , NULL , '1', NULL , '0', NULL , NULL , > > NULL , NULL , NULL , NULL > > ) > > > MySQL said: Documentation > > #1205 - Lock wait timeout exceeded; try restarting transaction > > > The only difference: in the meantime, I tried to create this same named > > project via gitoriuos. > > > Strange? > > > When I stop/start the MySQL server and again execute the SQL statement > > it again works! > > > I'm completely lost as to what is going on here. I'm not a MySQL expert > > but neither a beginner, but this is really strange. MySQL is basically a > > pristine installation from the Debian package. > > > Any idea what is going on here? > > > thanks, > > - Markus -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected]
