Hi,
I followed
http://gitorious.org/gitorious/pages/DebianSqueezeInstallation as
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
