Re: [Phpgroupware-developers] Deadlock followup

[Alex Borges]

Here is a small trace of the deadlock

Aug  6 18:05:49 plain postgres[18669]: [68] LOG:  query: delete from
phpgw_config where config_name='tz_offset'
Aug  6 18:05:49 plain postgres[18669]: [69] LOG:  query: insert into
phpgw_config (config_app,config_name,config_value) values
('phpgwapi','tz_offset','-5')
Aug  6 18:05:49 plain postgres[18669]: [70] LOG:  query: delete from
phpgw_config where config_name='asyncservice'
Aug  6 18:05:49 plain postgres[18669]: [71] LOG:  query: insert into
phpgw_config (config_app,config_name,config_value) values
('phpgwapi','asyncservice','off')
Aug  6 18:05:49 plain postgres[18669]: [72] LOG:  query: commit
Aug  6 18:05:49 plain postgres[18670]: [13] LOG:  query: lock table
phpgw_app_sessions in share mode
Aug  6 18:05:49 plain postgres[18670]: [14] LOG:  query: delete from
phpgw_config where config_app='phpgwapi'
Aug  6 18:05:49 plain postgres[18671]: [13] LOG:  query: lock table
phpgw_app_sessions in share mode
Aug  6 18:05:49 plain postgres[18671]: [14] LOG:  query: delete from
phpgw_config where config_app='phpgwapi'
Aug  6 18:05:49 plain postgres[18671]: [15] ERROR:  deadlock detected
Aug  6 18:05:49 plain postgres[18671]: [16] LOG:  query: rollback
Aug  6 18:05:49 plain postgres[18673]: [13] LOG:  query: lock table
phpgw_app_sessions in share mode
Aug  6 18:05:49 plain postgres[18673]: [14] LOG:  query: delete from
phpgw_config where config_app='phpgwapi'
Aug  6 18:05:49 plain postgres[18673]: [15] ERROR:  deadlock detected
Aug  6 18:05:49 plain postgres[18673]: [16] LOG:  query: rollback
Aug  6 18:05:49 plain postgres[18674]: [13] LOG:  query: lock table
phpgw_app_sessions in share mode
Aug  6 18:05:49 plain postgres[18674]: [14] LOG:  query: delete from
phpgw_config where config_app='phpgwapi'
Aug  6 18:05:49 plain postgres[18674]: [15] ERROR:  deadlock detected
Aug  6 18:05:49 plain postgres[18674]: [16] LOG:  query: rollback
Aug  6 18:05:49 plain postgres[18676]: [1] LOG:  connection received:
host=127.0.0.1 port=37685
Aug  6 18:05:49 plain postgres[18675]: [13] LOG:  query: lock table
phpgw_app_sessions in share mode
Aug  6 18:05:49 plain postgres[18675]: [14] LOG:  query: delete from
phpgw_config where config_app='phpgwapi'
Aug  6 18:05:49 plain postgres[18675]: [15] ERROR:  deadlock detected




El mi? 06-08-2003 a las 22:44, Alex Borges escribió:
> In doing performance testing on the thing (elza), im finding some ugly
> Deadlock Detected errors under postgres. Im just testing 100 users
> performing the login procedure until each user reaches home.php
> 
> This is postgres 7.3 . Stand by for more info.
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>