Fixing what I sad, in development environment faban is still getting
"Succeeded in creating user" message errors ...
1. dbloader.sh populates DB with 50 users
2. Erased development.log
3. Set to 50 concurrent users in faban's benchmark. Selected "NO" for
"Reload Database". Set "Steady State" to 60 sec.
4. Tested
5. Faban's log still outputs "Succeeded in creating user" message errors
6. And then I checked the log from app server...*
r...@k2:/var/www/olio/webapp/rails/trunk/log# grep -A 30 "Processing
UsersController#create" development.log
Processing UsersController#create (for 192.168.1.13 at 2010-05-25 23:15:31)
[POST]
Parameters: {"address"=>{"city"=>"vvkrm", "zip"=>"61239",
"country"=>"Jmbtprllmwsveye", "street1"=>"18037 Q", "street2"=>"",
"state"=>"ZQ"}, "user"=>{"password_confirmation"=>"5038",
"username"=>"jveqbie71", "timezone"=>"Africa/Nairobi",
"lastname"=>"Dkxphvcasd", "firstname"=>"Usiyllpo",
"summary"=>"9y5K757FpEWiWGg0vO9zJQIzbknUdsmFapTPvmFqLmUjVgXv92I1twSHtUjGOueDqfb5HBQuAxwVfSUpyHveo2z7i9ttfh0xq9tcz2zDtlZKiNqvzPGbUlD1ggiviq76mnrlKwRxMbnueR0Jak04NIuMNn9dg6hJWMOaMxg2VpZ9Yx9wWS25YahIfbZVP00CfCzLR8zrWzyIzJds9d1wk4WXMauGbzlQqHXcn2Lua7KB1QGYNGpl9rbiYpuGjIjBZeZR7wIDDyAQ2KrIrLoKzXgrDQpeOsY3oAZD4z02TiZfKuLAJjXaWPuIjI5YmrBaZtjYqisJNGNEGXIlmxVJT2djEECm1iHUaPCX3yZ6HqqxulhSAULARvET4clePIXhqvzX1bkFKbc0qq5bJf5WeDwA8737T81IARYUhCNlOU47bf6XyhAF6P04JrBhFTbVayq83gQqFQsnXuVWDZRNXACQeFtvJA4hSfaJRirGquWclIhW4guqJiAkd5RuK87hcHmHedizXjcl0YEJKOpy5y20O4KIQUXfxjBtZwB1rOH91tFl7ejqIagMu35f4783i2MwMsIiUjLMi2kYBIRoueei99tHSzXu7X36XoHgEBC8FQsSfGF1DVRhPtsgoHu9Ky3wjD0HiDYAqS8FvRkh68mUlZQUz0Kk1MbqeFarCuaPjVO3SAtPBJkhIeFxtv8uxUV4qpelc9bvGJJlyPdhc6TRmcGsdnutYfXGJk9nrxUnhFjLhXosikYmy8abnjPVQEEKMXhFMzPHngBbw8ms7VNGHOiUf0DgisLZ8fMD8KcBTdM7B9gqkiv14JFPYuJU4O5jBSp9wd8rTnnTfAj6Dj5N1e7wU6YjpvWv1xPpV2an1jc6WeWxM8pmdn2n5zGF4s7UQOJLgOZ9OohLIG31iVgtu0e2k6YbuVzCvCXiGYX5Yh6Ockzu1MseUafGpy5dv9inynN0G7I0lcrEQ5Bu7uwQCPIlKgXSPz7VHABHEe8U6E216JFnfABU68mcidxbMmq0pK3twzxjntujpTtPq5NmkSPEeoYAUJ0Jvi1o6vfrKdIW13k0Jn7ILI67IKS9lrLnb5NmDiLEYLji6M1FpXe7vB4T65dWtXsABjJtxt2KjQ33B3GkNi2EG0r2cuQFJxspMN9Hy2lHQcI3AnUPM3SXJEMssSc542lakHQhrcgYpWbDAVcEtR316c3E0AsqWfI9VkpnZgksIULRtot15mvAKsZ2gPFsFhCA9k308xTRQhtp3HNkIrEYrPJwdM9bqz4JXt65eqGkZ1M9FuyPUgbRXY5UoiOnF0OZOZa2al2HxpkVrIJQD11PF6Wsu3NsANkaWx4XyT3uBoXrwyXGudLY32XCnELsOoRBbXNnEG0LWma9QBRfZAnSaDWADcwbjQKDTXO9diNUgL2UNYJPWMxVE0B6hiftNv58xyHJ7kl2vOvNMmCwD9RCJpbaCfhZFitgLaBGCRlTtf4oVYzIooa9orvVrsAVNzpXtKJ2HfHsixnwaG0xSXsl3jitVEDX2rbr6JxJ6KykbtnV4BTLY5pR6UTlzw5FqHITXZ83P1FJRWlVJ5DT5I7vR5W6MjWrLnhOMia4ZqkL4Ljw5S1YTxv7TDflVVsVeiMutThiL4QUCLmdB3zui1be7bJHHXG7v24QDoC9x98kvt34gBm03f3aBclCkUvSIoMa4k5KnVI4uInMKw9u8uF0bzr1Kd2sIkIs2CiRt3I6Y8QvpQJCnKKmwci7H96XF7OGLWP5Ukbp5UAqn4i2BIv1E89ekDT45E5s221PyiMNzT6z2O0RMMDNZu6pTwhR9Om4sUT3dpM3ECRmcXS31JaWoHIUOixY4uG5ZcN9Ucm1JedszD9nwbOUxC8TceOvWmV7HRz8Jl81uq5SaAIETd2miw4X4XgtXHHG4RVB9piEBL6WguXKvctG0mvKkwikM5U0PhmCafn6v8Gtm7lA4htHqgpPui79jvdXYpG60WWUb",
"telephone"=>"0011054451031", "password"=>"5038", "email"=>"
[email protected]"},
"user_image"=>#<File:/tmp/RackMultipart2865-1>}
User Columns (1.1ms) SHOW FIELDS FROM `users`
Address Columns (1.0ms) SHOW FIELDS FROM `addresses`
SQL (0.6ms) BEGIN
Image Columns (1.1ms) SHOW FIELDS FROM `images`
Image Exists (0.9ms) SELECT `images`.id FROM `images` WHERE
(`images`.`filename` = BINARY '179117574person.jpg') LIMIT 1
Image Create (2.2ms) INSERT INTO `images` (`size`, `content_type`,
`thumbnail`, `filename`, `height`, `parent_id`, `width`) VALUES(671520,
'image/jpeg; charset=ISO-8859-1', NULL, '179117574person.jpg', NULL, NULL,
NULL)
Address Create (0.9ms) INSERT INTO `addresses` (`city`, `zip`,
`latitude`, `country`, `street1`, `street2`, `longitude`, `state`)
VALUES('vvkrm', '61239', 33.0, 'Jmbtprllmwsveye', '18037 Q', '', -177.0,
'ZQ')
User Exists (0.6ms) SELECT `users`.id FROM `users` WHERE
(`users`.`username` = BINARY 'jveqbie71') LIMIT 1
SQL (23.3ms) ROLLBACK
Rendering template within layouts/site
Rendering users/new
Rendered users/_form (4.5ms)
Rendered addresses/_form (2.9ms)
Rendered users/_change (8.1ms)
Rendered users/_login (0.5ms)
Rendered layouts/_messages (0.1ms)
Rendered events/_calendar (15.3ms)
Completed in 187ms (View: 27, DB: 32) | 200 OK [http://192.168.1.12/users]
SQL (0.6ms) SET SQL_AUTO_IS_NULL=0
--
Processing UsersController#create (for 192.168.1.13 at 2010-05-25 23:15:33)
[POST]
Parameters: {"address"=>{"city"=>"jlxybt", "zip"=>"64239",
"country"=>"USA", "street1"=>"3287 M", "street2"=>"", "state"=>"WN"},
"user"=>{"password_confirmation"=>"5045", "username"=>"dtx7k_c5_",
"timezone"=>"America/New_York", "lastname"=>"Zromqmpogm",
"firstname"=>"Pjaxbjtmicwg",
"summary"=>"9WvAeYjGUyTFZN0Di9xxGGJKugVa4o13UyS0Cbv6O13FlU3nzsnhaoiTmrTsnHVfEHOjfyQ4SD5fgS5owXGDreDHXbFlsKgx8UkUKRTlvAhAqDtxTIKoxsDezGKWfXJZ5tXmeVKSW7LLtZsnl9VrAFKSk0WUPxtaEyxjpKbsZ5lTAQJJRMCnl9mGiIvmlUrkllMGwv6kyIFGYzfu7boIjj7a76JNFRqhPKOCooWxGfDbkEfLoeB3lFZ37ZnSBK5xgRuS5qpkiCGf2tHafxliIm0wKpD2L6AARW5VbEpPnTxJU4lOiOkWueMgutxzA9ldJ8ZTvdhX4acsQFBUYFx1BeeyHrWwCKtDOZOdMCxqdp7fYv0VmP7wgeVfpK55vHSlryMJ9XgfssZPcXkm2IcqGhlcAk68UhABwe4AQRmc8VoOshJc2cAa2HkRyOrKEUUCip5WVqzEipM5uKUsD53bcdT5gMVS7dwRMNOeoEcsyIYWAsWVETGfObic1Lgk3q9zmRKlp93yLXmxb9ZBwnTNSLbQ3TgaTFVBDCGcOXLZUl45QV5PQIGYmzBKcKhDzyYUcyP2boQvpHfpAm7ZMqCDgpqfOycvDRb7VI4Jm6oD2Onh1IfdoO3Bl8m5gRYVLrUai2QS5bYBoO7bOk589uaJuTsE4uNCi62wC4L9txYudaPCbqjJueumuyCfMcjVsLjOP6LjVhIB3FFm4jYqzcAVrwv693QHSAvRhsmW63TGkHk29ITylOcH2RTw061XPcbgGqz66FMXZHKexjUZ9uGO1bEIPBh2olnyjQ7j13MjH7L0iEzHtns1NKvDfQco1jveM3YS0H7OWluzkh8hEJLt34CY3JW6SoRdmhkpIxnfShk04CElLxM1z7iGBWBM3hUgML7CI9qfpjhtx6N5SI2wiUPQrJxYqKjPxK6wYYUxd6ZmJmvlXkzRsRnUSbnjRu0XF64NYY6w66uEpMxylFWh2FxZfOiMa019qNGMeLGRSoSlIDK4BZPqnX1hbvibnum0YDVMylcXJPM2kpgOIamhj9rF559QuM2LzGYXqya3DPH43aVgTRYgjfkvRMG2oSsZzJ4tS6fXKkzSk8ANYI9B8fGLPKtbuq4hTMcBQNb2eO6HAmXUxHP3gBnV2ciaXNWJIjD5upEDhpSSEmoWDnOrUey6zTAUxw4qfwbsDgJJiue9Ptp4Js9pSWLWGnVMsLXd2hoja5JLMcbB3X9ZJ8NThrHwqRgpxZtJWYeSkk0Ki3l6Ybr8mFouCz6pETp67AQ7LjC3Bh0ZwSoIFNNzzQ80Pq6z4bGAHkzyBw",
"telephone"=>"0012598221661", "password"=>"5045", "email"=>"
[email protected]"},
"user_image"=>#<File:/tmp/RackMultipart2865-1>}
User Columns (1.1ms) SHOW FIELDS FROM `users`
Address Columns (0.9ms) SHOW FIELDS FROM `addresses`
SQL (0.6ms) BEGIN
Image Columns (1.1ms) SHOW FIELDS FROM `images`
Image Exists (0.8ms) SELECT `images`.id FROM `images` WHERE
(`images`.`filename` = BINARY '1098975094person.jpg') LIMIT 1
Image Create (0.8ms) INSERT INTO `images` (`size`, `content_type`,
`thumbnail`, `filename`, `height`, `parent_id`, `width`) VALUES(671520,
'image/jpeg; charset=ISO-8859-1', NULL, '1098975094person.jpg', NULL, NULL,
NULL)
Address Create (0.8ms) INSERT INTO `addresses` (`city`, `zip`,
`latitude`, `country`, `street1`, `street2`, `longitude`, `state`)
VALUES('jlxybt', '64239', 33.0, 'USA', '3287 M', '', -177.0, 'WN')
User Exists (0.9ms) SELECT `users`.id FROM `users` WHERE
(`users`.`username` = BINARY 'dtx7k_c5_') LIMIT 1
SQL (3.3ms) ROLLBACK
Rendering template within layouts/site
Rendering users/new
Rendered users/_form (4.6ms)
Rendered addresses/_form (2.9ms)
Rendered users/_change (8.3ms)
Rendered users/_login (0.5ms)
Rendered layouts/_messages (0.1ms)
Rendered events/_calendar (15.4ms)
Completed in 153ms (View: 28, DB: 11) | 200 OK [http://192.168.1.12/users]
SQL (0.6ms) SET SQL_AUTO_IS_NULL=0
--
Processing UsersController#create (for 192.168.1.13 at 2010-05-25 23:16:57)
[POST]
Parameters: {"address"=>{"city"=>"tjbyvtnbdxjkc", "zip"=>"15314",
"country"=>"USA", "street1"=>"760 Zcitkzgt Ave", "street2"=>"rbelueeukdzsp",
"state"=>"SE"}, "user"=>{"password_confirmation"=>"5037",
"username"=>"b8l8xgl0dt", "timezone"=>"Pacific/Galapagos",
"lastname"=>"Hechp", "firstname"=>"Xouhraredqbm",
"summary"=>"sWg15w2Psan1w3eGQIi1oQ83jJQlFmaT4MZw2T6lf8S7DYS0o9trvVoXzxTuDKc5MYuBKcw1Df671l7c0pBVwsckrwhbnj7R1TVuZhX2u4qfQtOVrVJ7ndNL0E4oLfnGN6Qn1L8rusVPQhBJ7WbbINUekxF4ZMMrh1iMWQvQLzGLNSvv9uyxDoujLawQoPPWBG4fqCxOtTS0ZuHJvJeL6oSTgUf4ZeJIc2bagOXckjZjMbqkXSp3sOGxGD9DoZsJsLj6UeM0Qvukwr7VPdPpZcrhLtP8KJtwET36hO5GwJL02cvgDyVAh1n6KGgjNPoaUeM5WzHFOqJcOGtCN0HBu7d117ZoBkTRLRN5x1HqIKAWaVlO7JSzyaVoQd2TEVyIh9tEOgBY4XRBAB2g9mtEFvwi9xfvEBCQHGr5xDAzuETdKaxjiLUuH6risQN8XRXddC6bCJIlKKTBNupQI8XGep84pDqsPkk9kRsBcUe2wesYwBtDgKxNy3e2ABx4pflqEkKP0maryqG8RLMnPplvslHp7PthfYRu9hphqHr4DAmuf9tapDdBIVyetqtrgx1792QnPPa5Dy9xU2avKNLopdbeqmQmRACbckuKjADzTMOVcaCrnEOG05BIeTOPi0lu9Sg9eshuyrvYRhzWJ9qM9VzAxm2GbE74cILVCsadgxI5RihfcJWbUgm87l0Z04Zpak53eVZBDEp6urZwvDRjsNH7u2CWvwDFH75tEE206a0t2umgYWcDW0CeKg9OxcO4mFPh9VCr0EW24bSSzPowSVgBInunKYEFL2kB1NKdFlHA8XhCoFxqhBBXINASaF7Hakm3tqKbUHE5YX67vgItfAE3ztwA7YAay2WClsyn5uuoeT38qqHYcqDH1EyGprEF151rjErVGuGiSbhnGLVWii76rOeK867dePzYTApenGf4QbIvheQsbIPXvXN0A0dmzuvlL8nDuagye0KfuM3gGEb2iH9c1LZNZutA8EkbjmQKds1xEkP9hfjSiH7iB1DccOIMIpLWYvQ2GDjO1pSW1omUMRmYjBAmUy6d8O5MuRzuNGJ6RaBLy4MmkH3GlTT6Z8ePi5nl7rRWLuiqg6K5dOOcVg7Yf2RATbV9jYUbGENHUVPXSkWs6JDxhUoCbWpdPOCWr3BOOBiusjexC911nCgkaGv5ZjcuzlwUGLG3MQNOHrgZyhyVx6ipaIKy7QnXWm9jzv69ZPbxcFc5CwS2F8UBbwh4DRiZWamKa62rdWIh397uUTmWbQFBmnfzWxQocft7CZbDdlX1Vx0f8eL44Ye4stTfUAUHAPc83JKOc2CG88FcsRw7eUpwzDyhhabpIaOrIJMcubyLF7viSLQen7TTaT50OiIs37QVlCwSSZHCyaiasmpO1GdH7JifKyo1zXUlcpJrKHiErhpOQZ25kDY0go9Awek9je8nr8EPCXcW3QA1GwS5e8HYFUh7PoLWHKlUOn5tULSyDwycrjQJTpHmUvQcLx4m4bctUZ1XAoj1FRQ5pZnajP7BN",
"telephone"=>"0021478091647", "password"=>"5037", "email"=>"
[email protected]"},
"user_image"=>#<File:/tmp/RackMultipart2865-2>}
User Columns (1.2ms) SHOW FIELDS FROM `users`
Address Columns (1.1ms) SHOW FIELDS FROM `addresses`
SQL (0.6ms) BEGIN
Image Columns (1.0ms) SHOW FIELDS FROM `images`
Image Exists (0.8ms) SELECT `images`.id FROM `images` WHERE
(`images`.`filename` = BINARY '784854821person.jpg') LIMIT 1
Image Create (0.8ms) INSERT INTO `images` (`size`, `content_type`,
`thumbnail`, `filename`, `height`, `parent_id`, `width`) VALUES(671520,
'image/jpeg; charset=ISO-8859-1', NULL, '784854821person.jpg', NULL, NULL,
NULL)
Address Create (0.8ms) INSERT INTO `addresses` (`city`, `zip`,
`latitude`, `country`, `street1`, `street2`, `longitude`, `state`)
VALUES('tjbyvtnbdxjkc', '15314', 33.0, 'USA', '760 Zcitkzgt Ave',
'rbelueeukdzsp', -177.0, 'SE')
User Exists (0.9ms) SELECT `users`.id FROM `users` WHERE
(`users`.`username` = BINARY 'b8l8xgl0dt') LIMIT 1
SQL (2.7ms) ROLLBACK
Rendering template within layouts/site
Rendering users/new
Rendered users/_form (4.5ms)
Rendered addresses/_form (2.9ms)
Rendered users/_change (8.0ms)
Rendered users/_login (0.4ms)
Rendered layouts/_messages (0.1ms)
Rendered events/_calendar (14.9ms)
Completed in 105ms (View: 27, DB: 10) | 200 OK [http://192.168.1.12/users]
SQL (0.4ms) SET SQL_AUTO_IS_NULL=0
*
Everytime it tries to create user, it already exists... So... shouldn't the
database be already loaded?
regards,
--
Bruno Guimarães Sousa
www.ifba.edu.br
PONTONET - DGTI - IFBA
Ciência da Computação UFBA
Registered Linux user #465914
2010/5/26 Bruno Guimarães Sousa <[email protected]>
> -> About creating a user, it is working fine with production environment
> when I test it through the browser. Now that tried with development env,
> faban tests didn't complain about "Succeeded in creating user" message
> error. Why is that?
>
> -> About the mpstat problem, it means there is no fix? that's what I
> understood :(
>
>
>
> --
> Bruno Guimarães Sousa
> www.ifba.edu.br
> PONTONET - DGTI - IFBA
> Ciência da Computação UFBA
> Registered Linux user #465914
>
>
> On Wed, May 26, 2010 at 12:51 AM, Shanti Subramanyam <
> [email protected]> wrote:
>
>> The first error is specific to the rails implementation. It probably means
>> the database insert of the user record failed. Look in your rails appserver
>> log or first try running in development mode.
>>
>> As Vasileios mentioned, please also check the mail archives in the
>> future.
>>
>> Shanti
>>
>> 2010/5/25 Bruno Guimarães Sousa <[email protected]>
>>
>>> Benchmark is working properly, almost 100%
>>>
>>>
>>> makalu -> olio master driver
>>> k2 -> app server
>>>
>>> But still getting some errors:
>>>
>>> this one goes all over the log:
>>> 19:12:52 makalu WARNING*
>>> exception<http://csgengenharia.homeftp.net:9980/LogReader?runId=OlioDriver.2L&exception=17>
>>> * UIDriverAgent[0].33.doAddPerson: Could not find success message
>>> 'Succeeded in creating user. in result body
>>> Note: Error not counted in result.
>>> Either transaction start or end time is not within steady
>>> state.Message:java.lang.Exception: Could not find success message
>>> 'Succeeded in creating
>>> user. in result body
>>>
>>>
>>> this one (note: "iostat -x 10" command works perfectly on K2 server):
>>> 19:14:05 k2 WARNING Timed out waiting for command
>>> [/usr/local/faban/bin/Linux/iostat, -x, 10]
>>> and this one:
>>> 19:14:30 makalu WARNING [/usr/local/faban/bin/fenxi, process,
>>> /usr/local/faban/output/OlioDriver.2L/,
>>> /usr/local/faban/output/OlioDriver.2L//post/, OlioDriver.2L]
>>> stderr:
>>> Error in executing perl /usr/local/faban/master/webapps/fenxi/txt2db/
>>> mpstat.pl
>>> Error in executing perl /usr/local/faban/master/webapps/fenxi/txt2db/
>>> mpstat.pl
>>> what can it be?
>>>
>>> --
>>> Bruno Guimarães Sousa
>>> www.ifba.edu.br
>>> PONTONET - DGTI - IFBA
>>> Ciência da Computação UFBA
>>> Registered Linux user #465914
>>>
>>
>>
>
