What do the numbers near a user name on the user list mean?
Re: Followup and fix
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: Followup and fix 7 August 2003 08:02:21
  Recent blog posts: 
Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded&helli­p;

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded&helli­p;

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

  They have birthday today: 
xiongchong
henna diah
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
users & groups
i installed the latest version, which is 0.9.14.6. My user and group accounts are located in an ldap…

[SMARTY] break out of…
Hello list, my question: I have a foreach-loop. How can I break this loop before it ends? Greetings…

Fatal error: Call to a member…
Hello I am pleased if someone could explain me since is wrong the following function call: ($row…

Assigning PHP Arrays to…
Hi, Question: How can assign a PHP array to a Javascript array? Example…
  Recent forum topics: 
why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/­Ticket/Display.html?­id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…
  Recent forum comments:
RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@n­ospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.in­etserver.asp.general­: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.­net> wrote: Using…
  Moderators:
 Administrator
 Protorioris

Re: Followup and fix

Alex Borges 7 August 2003 08:02:21
 I thinks this is why its going on:

Aug 6 18:13:39 plain postgres[18842]: [12] LOG: query: lock table>phpgw_config in share mode

Share mode makes it so that the data cannot be concurrently changed i
think. The problem is that it doesnt conflict with itself, i think,
because we can see later.....


Aug 6 18:13:39 plain postgres[18838]: [62] LOG: query: delete from
phpgw_config where config_name='mcrypt­_mode'
Aug 6 18:13:39 plain postgres[18838]: [63] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','mcrypt­_mode','cbc')
Aug 6 18:13:39 plain postgres[18838]: [64] LOG: query: delete from
phpgw_config where config_name='file_r­epository'
Aug 6 18:13:39 plain postgres[18838]: [65] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','file_r­epository','sql')
Aug 6 18:13:39 plain postgres[18838]: [66] LOG: query: delete from
phpgw_config where config_name='file_s­tore_contents'
Aug 6 18:13:39 plain postgres[18838]: [67-1] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
Aug 6 18:13:39 plain postgres[18838]: [67-2]
('phpgwapi','file_s­tore_contents','file­system')
Aug 6 18:13:39 plain postgres[18838]: [68] LOG: query: delete from
phpgw_config where config_name='tz_off­set'
Aug 6 18:13:39 plain postgres[18838]: [69] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','tz_off­set','-5')
Aug 6 18:13:39 plain postgres[18838]: [70] LOG: query: delete from
phpgw_config where config_name='asyncs­ervice'
Aug 6 18:13:39 plain postgres[18838]: [71] LOG: query: insert into
phpgw_config (config_app,config_­name,config_value) values
('phpgwapi','asyncs­ervice','off')
Aug 6 18:13:39 plain postgres[18838]: [72] LOG: query: commit

Till here, we are OkAY, it has been commited. The problem i think is the
next one:

First, no begin here....

Aug 6 18:13:39 plain postgres[18839]: [13] LOG: query: lock table
phpgw_app_sessions in share mode
Aug 6 18:13:39 plain postgres[18839]: [14] LOG: query: delete from
phpgw_config where config_app='phpgwap­i'

HERE..... it lets you lock it!

SHARED locks are not self exclusive, this means that two transactions
can lock the same table, hence the deadlock at the end


Aug 6 18:13:39 plain postgres[18840]: [13] LOG: query: lock table
phpgw_app_sessions in share mode
Aug 6 18:13:39 plain postgres[18840]: [14] LOG: query: delete from
phpgw_config where config_app='phpgwap­i'
Aug 6 18:13:39 plain postgres[18840]: [15] ERROR: deadlock detected

Aha, a deadlock it causes you....


So, i looked into it and i found this code in db_pgsql:
{
while ($t = each($table))
{
! $result =
pg_Exec($this->Link­_ID,'lock table ' . $t[1] . ' in share mode');
}
}
else
{
! $result =
pg_Exec($this->Link­_ID, 'lock table ' . $table . ' in share mode');
}
}

Which is wrong, cause writes should be an exclusive share. I changed it
to this:

{
while ($t = each($table))
{
! $result =
pg_Exec($this->Link­_ID,'lock table ' . $t[1] . ' in exclusive mode');
}
}
else
{
! $result =
pg_Exec($this->Link­_ID, 'lock table ' . $table . ' in shared mode');
}
}


And it now works.... savanah patch is:1802

yay


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: Followup and fix 7 August 2003 08:02:21
see also:
Problem with SSL request via Windows…
Apache 1.39: Automatically logging…
Issues with proxying and subfolders
пройди тесты:
see also:
C prazdnikom vcex!
MOJA PYKA
Ckoro pjatnica 13.]:-) :-D
  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 .