Discussion:
ER error
(too old to reply)
Laurie Gustin
2013-05-14 22:03:11 UTC
Permalink
Im wondering if anyone has seen this error?

15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.

The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still
going back and forth but I am unable to completely sync up the data.

When I do cdr list server (or cdr view servers) it shows all servers
connected

I did cdr stop and cdr start to try to 'jumpstart' things... and get
this error on start

15:54:57 CDR GC: operation database syscdr exclusive failed (error -154).
it tries 5 times... then doesnt say anything more


I am trying to sync again now - after the cdr stop/start. My next course of
action is to bounce the whole engine. But I dont really want to do that.

Any help is appreciated.

Laurie :)
FRANK
2013-05-15 14:46:43 UTC
Permalink
Laurie,

What is your IDS version?

Are outputs of cdr list server all the same in all replication nodes?

Thanks,
Frank
Post by Laurie Gustin
Im wondering if anyone has seen this error?
15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.
The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still
going back and forth but I am unable to completely sync up the data.
When I do cdr list server (or cdr view servers) it shows all servers
connected
I did cdr stop and cdr start to try to 'jumpstart' things... and get
this error on start
15:54:57 CDR GC: operation database syscdr exclusive failed (error -154).
it tries 5 times... then doesnt say anything more
I am trying to sync again now - after the cdr stop/start. My next course
of action is to bounce the whole engine. But I dont really want to do that.
Any help is appreciated.
Laurie :)
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Laurie Gustin
2013-05-15 14:59:25 UTC
Permalink
IDS 11.70 FC7

yes - output for cdr list server is the same.. and shows all servers
connected
Post by FRANK
Laurie,
What is your IDS version?
Are outputs of cdr list server all the same in all replication nodes?
Thanks,
Frank
Post by Laurie Gustin
Im wondering if anyone has seen this error?
15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.
The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still
going back and forth but I am unable to completely sync up the data.
When I do cdr list server (or cdr view servers) it shows all servers
connected
I did cdr stop and cdr start to try to 'jumpstart' things... and get
this error on start
15:54:57 CDR GC: operation database syscdr exclusive failed (error -154).
it tries 5 times... then doesnt say anything more
I am trying to sync again now - after the cdr stop/start. My next course
of action is to bounce the whole engine. But I dont really want to do that.
Any help is appreciated.
Laurie :)
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
FRANK
2013-05-15 17:37:23 UTC
Permalink
Another option is cdr delete server.... to rebuild the ER. It might
cleanup the leftover
Frank
Post by Laurie Gustin
IDS 11.70 FC7
yes - output for cdr list server is the same.. and shows all servers
connected
Post by FRANK
Laurie,
What is your IDS version?
Are outputs of cdr list server all the same in all replication
nodes?
Thanks,
Frank
Post by Laurie Gustin
Im wondering if anyone has seen this error?
15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.
The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still
going back and forth but I am unable to completely sync up the data.
When I do cdr list server (or cdr view servers) it shows all servers
connected
I did cdr stop and cdr start to try to 'jumpstart' things... and get
this error on start
15:54:57 CDR GC: operation database syscdr exclusive failed (error
-154).
it tries 5 times... then doesnt say anything more
I am trying to sync again now - after the cdr stop/start. My next course
of action is to bounce the whole engine. But I dont really want to do that.
Any help is appreciated.
Laurie :)
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Laurie Gustin
2013-05-15 17:48:49 UTC
Permalink
I found the problem... there was a trigger that accessed data on a third
server - that's where the connection problem was. :(

Thanks!
Post by FRANK
Another option is cdr delete server.... to rebuild the ER. It might
cleanup the leftover
Frank
Post by Laurie Gustin
IDS 11.70 FC7
yes - output for cdr list server is the same.. and shows all servers
connected
Post by FRANK
Laurie,
What is your IDS version?
Are outputs of cdr list server all the same in all replication
nodes?
Thanks,
Frank
Post by Laurie Gustin
Im wondering if anyone has seen this error?
15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.
The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still
going back and forth but I am unable to completely sync up the data.
When I do cdr list server (or cdr view servers) it shows all servers
connected
I did cdr stop and cdr start to try to 'jumpstart' things... and get
this error on start
15:54:57 CDR GC: operation database syscdr exclusive failed (error
-154).
it tries 5 times... then doesnt say anything more
I am trying to sync again now - after the cdr stop/start. My next
course of action is to bounce the whole engine. But I dont really want to
do that.
Any help is appreciated.
Laurie :)
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Loading...