Hi,
I use postgresql in serving Ads and counting impression of the ad banners.
whenever an Ad is served I do a update.
update banner_stats set imp=imp+1 where uniqid=4330
in a transaction.
In a busy web environment like ours there are high chances that the same page is
displyed
concurrently
> ~~
> Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
> ~~
It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record simultaneously.
thanks for ur response bhuvan,
i will read that doc and try it again.
regds
mallah.
On Monday 20 January 2003 03:32 pm, Bhuvan A wrote:
> > ~~
> > Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> > /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
Hi All,
I have table with almost 3,500 records with 9 fields which is similar
structure to Table1. From that I am porting to following structure
Table 1.
T1f1 integer serial (primary key),
T1f2 varchar(100) (unique),
T1f3 integer default 0,
T1f4 text,
T1f5 boolean default 'f',
T1f6 boolean defau
Bhuvan A <[EMAIL PROTECTED]> writes:
>> ~~
>> Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
>> /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
>> ~~
> It is a genuine error, occurs while two or more transaction process tries
> to
On Fri, Jan 17, 2003 at 04:29:37PM +, Adam Witney wrote:
> This was the error message issued by that program:
> ld.so.1: /usr/local/pgsql7.3.1/bin/postgres: fatal: libreadline.so.4: open
> failed: No such file or directory
Looks like it can't find your readline libraries. Time to poke at
your
On Mon, 20 Jan 2003, Tom Lane wrote:
>
> Bhuvan A <[EMAIL PROTECTED]> writes:
> >> Error:...deadlock detected...
> > ... You can overcome this by locking the table in share row
> > exclusive mode also...
>
> ...use shorter transactions (one per page, not one per several pages).
Hmm... with his qu
are there any tools for postgres that would assist a dba in the
monitoring of a postgres database?
for example, send alerts when data files are filling up, send alerts if
the database goes down, etc.
---(end of broadcast)---
TIP 1: subscribe and unsu
Dear Sir,
I'm a graduate student studying computer science in the Univ. of Edinburgh.
After I donwload the 'PostgreSQL 7.3.1', I run the command "/configure" in its
directory on my computer as root. However, the result is ":bad interpreter: no
such file or directory". My OS is redhat 7.3 and gmake
> > ~~
> > Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> > /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
> > ~~
>
> It is a genuine error, occurs while two or more transaction process tries
> to update/delete a same record sim
Ron Mayer <[EMAIL PROTECTED]> writes:
> Is it true that the problem happens when updates are done
> in a different order by two transactions like this:
> trans.1: "update banner_stats set imp=imp+1 where uniqid=4330"
> trans.2: "update banner_stats set imp=imp+1 where uniqid=10"
> trans.1: "
On Mon, 20 Jan 2003, Tom Lane wrote:
>
> If I understood correctly, he's tracking webpage hits; so the updates
> are going to correspond to the sequence in which visitors move to
> different webpages.
Ah... I was thinking he was counting banners served within a
single page (perhaps a banner on to
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "codeWarrior" <[EMAIL PROTECTED]> writes:
> > I noticed that the server generated logfile gets real big real fast --
(15
> > queries and it's already at 1.5MB) -- Is there a switch / option to
recycle
>
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows,
Hi all,
I just tried a fresh install of pg 7.3.1 on a SuSE 8.1 box. I keep getting
messages like
Failed to initialize lc_messages to ''
during initdb. I already tried --locale=C but no help. Anyone any ideas?
regards
GB
---(end of broadcast)---
Thanks man; Iappreciate the data.
Stephan Szabo wrote:
>
> On Thu, 9 Jan 2003, Jack Flak wrote:
>
>> Stephan,
>>
>> That's very interesting! I didn't even know about these other "hidden"
>> fields. How many others are there?
>
> Let's see, I think the set is
> ctid, oid, xmin, cmin, xmax, cm
On Thu, 16 Jan 2003, Tim Lynch wrote:
> First, sorry for the OT, flame me off-list!
>
> I'm a sysadmin being impressed into dba service. i've been getting along
> pretty well writing queries and making reports, but i've got some questions.
> suggestions for a good list/forum for help?
>
> from t
UNION! thanks everyone!
i'll take this stuff up on the pgsql-sql list in the future.
union does intra- and inter- table distinct, notice `red' and `two':
test=> select str from foo ;
str
-
one
two
two
red
(4 rows)
test=> select str from bar ;
str
red
orange
yellow
green
Dear Sir,
I have downloaded fallowing files from http://www.postgresql.org
1. mx-2.0.1-1.i386.rpm
2. postgresql-odbc-7.1.2-5PGDG.i386.rpm
3. postgresql-7.1.2-5PGDG.i386.rpm
4. postgresql-perl-7.1.2-5PGDG.i386.rpm
5. postgresql-contrib-7.1.2-5PGDG.i386.rpm
6. postgresql-python-7.1.2-5PGDG.i386.r
I got this error message:
pg_restore: [archiver] input file does not appear to be a valid archive
after the command:
pg_restore -d mydb_name mydb_name.dump.tar
the tar file was created with the command
pg_dump -b -f mydb_name.dump.tar -F t mydb_name
==
This is exactly what is said in the Man
Hi:
I need to register all the operations (INSERT/UPDATE/DELETE) that users
does.
Something like an log file for the backbone (like a /var/log/messages,
where all done is registered).
Can any help me?
Thanks.
--
SAMTEK, Consultores Informática y Telecomunicaciones
Calificado como Agente Tec
On Wed, 15 Jan 2003, Yudha Setiawan wrote:
> Somebody gimme your hand plz.
>
> Using my previous Database I used to be like that;
> " ALTER TRIGGER tr_T_DtlPO ON dbo.T_DtlPO FOR UPDATE AS
> bla..bla..bla...
> IF @OldQty <> @NewQty BEGIN
> ROLLBACK
> INSERT INTO T_My_ListError(fc_cod
I'm going to CC this to the -general list as well, it's possible that -admin
isn't the right list for this thread.
You can not rollback or commit within a function. That would require nested
transactions which aren't implemented yet. Obviously that precludes use of your
'begin work' in your funct
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root# chown post
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root# chown
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root# chown po
Hi Zhiqiang,
You might take a look at the following link:
http://www.tek-tips.com/viewthread.cfm?SQID=449717&SPID=699&page=1
After you have postgres user properly setup, you can use pgaccess to
configure other users.
LelandJ
- Original Message -
From: "Zhiqiang Feng" <[EMAIL PROTECTED
First of all your "su postgres" problem. You will note, that the first time
you executed "su postgres" you were root (and thus didn't need a password), the
second time you were a non-root user, zf2linux, and thus you DO need a
password.
The second problem is who postgreSQL thinks you are. Wha
Hi,
Writing a web-based application using PostgreSQL as the back-end
database. The master create functions look something like this:
1. Accept ID from user.
2. Verify that ID doesn't exist in database. Start transaction.
Create blank record with ID as key.
3. Accept remaining data for record
Hi,
Guys thanks for the response..
I am using perl DBI.
In fact i have tried doing the commit immediately
after the update in the script then i saw my pg_stat_activity
reporting lots of queued update transactions.
I would like to discuss this problem further but not
able to do so at the mome
30 matches
Mail list logo
