What is talxy?
Re: Deadlock followup
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > PHP web-programming > Re: Deadlock followup 7 August 2003 07:06:54

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

Re: Deadlock followup

Alex Borges 7 August 2003 07:06:54
 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_off­set'
Aug 6 18:05:49 plain postgres[18669]: [69] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','tz_off­set','-5')
Aug 6 18:05:49 plain postgres[18669]: [70] LOG: query: delete from
phpgw_config where config_name='asyncs­ervice'
Aug 6 18:05:49 plain postgres[18669]: [71] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','asyncs­ervice','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='phpgwap­i'
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='phpgwap­i'
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='phpgwap­i'
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='phpgwap­i'
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='phpgwap­i'
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-develo­pers mailing list> Phpgroupware-develo­pers@gnu.org> http://mail.gnu.org­/mailman/listinfo/ph­pgroupware-developer­s>
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > PHP web-programming > Re: Deadlock followup 7 August 2003 07:06:54

see also:
Build not working with Ant 1.6.0
JBoss Test Results: 57 % ( 421 / 727 )…
[ jboss-Bugs-872998 ] Element [code]…
пройди тесты:
see also:
10 Reasons to Buy a DSLR Camera
MSOffice 2007
What Grandma knows

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .