Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > "too many trigg...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 17 Topic 15207 of 17598
Post > Topic >>

"too many trigger records found for relation xyz"

by mpartio@[EMAIL PROTECTED] ("Mikko Partio") Apr 8, 2008 at 10:14 AM

------=_Part_26478_22127058.1207638864147
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all

Postgres version 8.3.1

I just created a bunch of tables (~10) with identical structure; all
tables
have 6 foreign key references to other tables and a primary key. To my
surprise, some of the tables were created ok, some missed primary key and
some didn't get created at all.

Postgres complained:

2008-04-08 08:50:41 EEST [721]: [27-1] ERROR:  relation 543058 deleted
while
still in use

and

2008-04-08 08:50:41 EEST [721]: [36-1] ERROR:  could not find tuple for
relation 54309

and

2008-04-08 08:50:42 EEST [721]: [114-1] ERROR:  duplicate key value
violates
unique constraint "pg_class_oid_index"

When I tried to remove the tables, the same errors kept coming up

2008-04-08 08:53:15 EEST [27794]: [5-1] ERROR:  duplicate key value
violates
unique constraint "pg_class_oid_index"
2008-04-08 08:53:15 EEST [27794]: [6-1] STATEMENT:  drop table xyz ;

I searched google for a while, and then tried again and this time I was
able
to drop all but one of the tables. When I try to drop the one remaining
table, I get this error message:

2008-04-08 10:09:31 EEST [27794]: [95-1] ERROR:  too many trigger records
found for relation "xyz"

The database had a bunch of autovacuum runs and an im****t process copying
data to tem****ary tables at the time I tried to create the tables. What
could cause such behaviour, and how can I remove the one remaining table?

Regards

Mikko

------=_Part_26478_22127058.1207638864147
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all<br><br>Postgres version 8.3.1<br><br>I just created a bunch of
tables (~10) with identical structure; all tables have 6 foreign key
references to other tables and a primary key. To my surprise, some of the
tables were created ok, some missed primary key and some didn&#39;t get
created at all.<br>
<br>Postgres complained:<br><br>2008-04-08 08:50:41 EEST [721]: [27-1]
ERROR:&nbsp; relation 543058 deleted while still in
use<br><br>and<br><br>2008-04-08 08:50:41 EEST [721]: [36-1] ERROR:&nbsp;
could not find tuple for relation 54309<br>
<br>and<br><br>2008-04-08 08:50:42 EEST [721]: [114-1] ERROR:&nbsp;
duplicate key value violates unique constraint
&quot;pg_class_oid_index&quot;<br><br>When I tried to remove the tables,
the same errors kept coming up<br><br>
2008-04-08 08:53:15 EEST [27794]: [5-1] ERROR:&nbsp; duplicate key value
violates unique constraint &quot;pg_class_oid_index&quot;<br>2008-04-08
08:53:15 EEST [27794]: [6-1] STATEMENT:&nbsp; drop table xyz ;<br><br>I
searched google for a while, and then tried again and this time I was able
to drop all but one of the tables. When I try to drop the one remaining
table, I get this error message:<br>
<br>2008-04-08 10:09:31 EEST [27794]: [95-1] ERROR:&nbsp; too many trigger
records found for relation &quot;xyz&quot;<br><br>The database had a bunch
of autovacuum runs and an im****t process copying data to tem****ary tables
at the time I tried to create the tables. What could cause such behaviour,
and how can I remove the one remaining table?<br>
<br>Regards<br><br>Mikko<br><br><br><br><br><br><br><br>

------=_Part_26478_22127058.1207638864147--
 




 17 Posts in Topic:
"too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 10:14:24 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 10:27:34 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 12:20:51 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 12:37:17 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 12:19:41 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 13:37:59 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 12:45:38 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 14:05:06 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 13:49:41 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 16:26:11 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 15:47:30 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 17:26:14 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 17:38:46 
Re: "too many trigger records found for relation xyz"
Zdenek.Kotala@[EMAIL PROT  2008-04-08 17:38:37 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 20:49:47 
Re: "too many trigger records found for relation xyz"
tgl@[EMAIL PROTECTED] (T  2008-04-08 14:30:48 
Re: "too many trigger records found for relation xyz"
mpartio@[EMAIL PROTECTED]  2008-04-08 21:37:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:34:19 CST 2008.