[Info-ingres] E_DM1205_ATP_NO_BT_FOUND Audit records found for an unknown transaction.

[Ingres Forums]

tried that too, here's what i just ran:

auditdb -b11-jun-2015:10:00:00 -table=pending_sub -file=k1.audit -uref
ref

it gave:

Thu Jun 11 11:01:43 2015 E_DM1205_ATP_NO_BT_FOUND       Audit records
found for an unknown transaction.
LSN=(1198794541,1215003063), COMP_LSN=(0,0), DBID=0x4465409D,
XID=0x00004774C66BA962
REP          Length:   366  Flags: JOURNAL,NONJNLTAB,PHYSLOCK
HEADER:  0000016E 011B006A 000A0001 4465409D 00004774 C66BA962
4774272D 486B79B7 00000001
HEADER:  00000000 00000001 00000000 0001FE01 0001FE01 00000800
00000001 00010000 0007000A
TABLE: (1,0) NAME(iirelation,$ingres) OTID: [255,1] NTID:
[255,1] SIZE: old 248, new 248
Compressed Sizes: old 248, new 1, diff_offset 213
OLD ROW (length 248 bytes):
[   0]: 000002A1 00000000 5F736966 75746572 64656E72 6574695F
2020736D 20202020  >........fis_returned_items      <
[  32]: 20202020 20202020 20666572 20202020 20202020 20202020
20202020 20202020  >        ref                     <
[  64]: 20202020 20202020 00000005 000B0004 0071100C 00000006
00000005 00000001  >        ..........q.............<
[  96]: 00000001 00000000 5578A1D8 000AC0E9 61746164 20203331
20202020 20202020  >..........xU....data13          <
[ 128]: 20202020 20202020 20202020 20202020 20302E39 44654150
00000000 00000000  >                9.0 PAeD........<
[ 160]: 5578A1D8 00500000 00460050 00000000 00000000 00000800
00000000 00000000  >..xU..P.P.F.....................<
[ 192]: 00000000 00000003 00000010 00000010 00010000 00000800
00000000 00000000  >................................<
[ 224]: 0000000A 00000019 00000019 00000000 00000000 00000000
50018400 01000000  >...........................P....<
COMPRESSED NEW ROW (length 1 bytes):
[   0]: 50018400 01000000 01001200 9D000000 74446540 B4000047
2DC66BB3 FC477427  >...P............ at eDtG....k.-'tG.<


-- 
kyledarrenhanson
------------------------------------------------------------------------
kyledarrenhanson's Profile: http://community.actian.com/forum/member.php?userid=394
View this thread: http://community.actian.com/forum/showthread.php?t=17564