res 7.4.2
What does that mean? Can it be fixed? How?
TIA
Ulrich
--
Ulrich Wisser / System Developer
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
_
d: ERROR: left link
changed unexpectedly
Any ideas what is wrong? Or how to fix it?
Ulrich
--
Ulrich Wisser / System Developer
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893
ekend.
Ulrich
Ulrich Wisser <[EMAIL PROTECTED]> writes:
vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link
changed unexpectedly
Hm, is this repeatable? When I wrote the code I thought it was
a can't-happen case, which is why the error message is so terse
U 2.46s/6.06u sec elapsed 186.45 sec.
ERROR: left link changed unexpectedly
To me this looks as the index userclick_i01 is corrupted.
I can not recompile PG, this is a production system. Is there anything
else I could do to find out which file is affected?
Ulrich
Lane wrote:
Ulrich Wisser &
rclick_i01
userclick_i02
userclick_i03
userclick_i04
userclick_i05
userclick_i06
userclick_i07
(7 rows)
How do I proceed? How can I tell which files are involved?
Regards,
Ulrich
--
Ulrich Wisser / System Developer
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+4
Hi,
I installed the latest postgresql packages on my Fedora Core 3 box.
PG will not start, even initdb on a new directory fails. Any ideas what
could be wrong? Any ideas how to debug?
Thanks
Ulrich
---(end of broadcast)---
TIP 6: Have you searched o
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?
Here is my error message:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VER
-
Hash: SHA1
Hi,
Are you using the latest selinux_policy_targeted package? I mean, is
your system up2date?
Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work tog
Hi Tom,
sudo /sbin/restorecon -R /var/lib/pgsql
worked like a charm!
Thank you very much!
Ulrich
--
Ulrich Wisser
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
ecurity in general). I just went with the
default install and here I am.
Ulrich
--
Ulrich Wisser
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
___
Hi,
today I started to wonder about type conversion. I want to get all rows
of a table dated between two given dates. Until now I use
select * from mytable where to_date('20040115', 'MMDD') <= timestamp
and timestamp <= to_date('20040215', MMDD')
Does that query include the 15th January a
Hello,
my web application grows slower and slower over time. After some
profiling I came to the conclusion that my SQL queries are the biggest
time spenders (25 seconds). Obviously I need to optimise my queries and
maybe introduce some new indexes.
The problem is, that my application uses dynam
Hello,
the maintainance chapter in the docs gave me the impression that a
reindex of some tables would be a good idea. Last night I took the
database down, started up in single user mode and tried to reindex.
The reindex of tables did work fine, but a reindex of the database
did not. Please see
Hello,
yesterday I took our database down and started in single user mode.
After reindexing of three tables I thought a vacuum would be a good idea.
backend> VACUUM FULL VERBOSE ANALYZE
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Hi Tom,
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
Should these errors worry me?
Yeah, they should. A REINDEX will probably get you out of the immediate
problem, but the more interesting question is how
Hi,
after some more debugging I found that my application does on average 3
inserts per second. Which is not very fast, but fast enough for now. But
now and then the whole insert proces will be stalled and drop to 0.1
inserts per second. In the output of "ps aux Op" I see postgres in the
state
Hi Igor,
wouldn't
select g_name,count(*),sum(u_act) from g1 join users using(g_id)
group by g_name
do the job?
/Ulrich
Result can be obtained by:
SELECT g1.g_name,
(select count(*) from users u1 where g1.g_id = u1.g_id) as users_count,
(select count(*) from users u2 where g1.g_id = u2.g_id and u_ac
are inserting two child records that reference the same parent
(at the same time) one insert will block.
John Sidney-Woollett
Ulrich Wisser wrote:
Hi,
after some more debugging I found that my application does on average
3 inserts per second. Which is not very fast, but fast enough for now.
But
Hi,
what does that line from my logfile mean?
Adding missing FROM-clause entry for table "customer"
Would pg change my SQL queries on the fly?
TIA
/Ulrich
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if y
Hi,
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
Vacuum and reindex seem to be quite easy, as I can setup a small script
with both commands. But what about pg_dump. That seems "somewhat" more
complex.
TIA
Ulrich
--
Daniel Martini wrote:
Hi,
Citing Ulrich Wisser <[EMAIL PROTECTED]>:
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
Vacuum and reindex seem to be quite easy, as I can setup a small script
with both commands. But what about pg_dump
Hi,
lately I've been acused of "stone-age maintenance procedures".
Hopefully I will find some help to develop from stone-age to roman
empire. ;-)
To optimize the performance and to minimize the maintainance needs I
would like to ask you guys about some values in my postgresql.conf.
select versi
Hi Elie,
Now I got the right information from the DB in Hebrew and french.
Still can't save value in Hebrew from client (browser) to server and in
french if I save 'été' in a column varchar(3) I got a range over exception.
you are working through the web. That makes the whole thing a lot more
com
Hi,
yes, I have been hit by the, now also known to me, foreign key locking
"feature". And yes I did read that I should use "defer" to solve the
problem. Question is:
Do I have to recreate my schema with all foreign keys set to "initially
defered deferable"?
Ulrich
---(e
24 matches
Mail list logo