6.5.3 running on RedHat Linux 6.0. Front-end running on MS Access 2000
over ODBC on WinNT
I have recently been experiencing some worrying problems whereby an
"INSERT INTO..." query executed in Access succeeds to all appearances.
Opening the linked table or querying it from Access shows that the
records are present. However, on the server itself these records are
not there, nor are they there if you quit Access and enter it again.
I have debug logs to level 2 off the server, and the psql odbc driver
log. I'm trying to understand them to work out if it was my query
which was somehow causing the problem. I'm not very conscious of where
the responsibility is under ODBC connections to report problems, with
the server, or with the driver.
I think I have solved the problems by dropping all indices, rebuilding
them, and redesigning the problematic queries. (One of the functions
in one had an incorrectly specified parameter - however, Access did
not complain while building the insert, and the final insert looks
correct).
I am worried as to whether this might happen again, and worried that
it could happen at all. I don't know whether the problem is in the
client, the server, or the ODBC driver, but the trouble about this
kind of error is that it is the worst type - records apparently being
inserted correctly, but in fact not being so.
I attach a part of the server log - the inserts seem to be being done
on a one-by-one basis, and the partial log attached contains all
references to one of them. Could someone maybe take a look, and see if
what is recorded in these logs explains the behaviour? It seems
particularly odd, because the final insert appears to have nothing
wrong with it!
Yours,
Moray McConnachie
----------------------------------------------------------------------
----------------
[EMAIL PROTECTED]
postmaster: BackendStartup: pid 774 user moray db maint socket 5
postmaster child[774]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1340
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "regno" ,"typeid" ,"internalid" FROM "internalprphs" WHERE ("regno" =
6229 )
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 774 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 775 user moray db maint socket 5
postmaster child[775]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1341
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "typeid" FROM "machines" WHERE ("regno" = 6229 )
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 775 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 776 user moray db maint socket 5
postmaster child[776]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1342
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "price" FROM "prices" WHERE ((("typeid" = 6 ) AND ("subsidyid" = 'v' ) )
AND ("validfrom" <= '2000-11-30' ) ) ORDER BY "prices"."validfrom" DESC
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 776 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 777 user moray db maint socket 5
postmaster child[777]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1343
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "generictypeid" FROM "types" WHERE ("typeid" = 6 )
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 777 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 778 user moray db maint socket 5
postmaster child[778]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1344
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "generictype" FROM "subsettypes" WHERE ("generictypeid" = 0 )
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 778 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 779 user moray db maint socket 5
postmaster child[779]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1345
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "regno" ,"ramsize" ,"hdsize" ,"screensize" FROM "machines" WHERE
("regno" = 6229 )
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 779 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 780 user moray db maint socket 5
postmaster child[780]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1346
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "name" ,"subsidyid" ,"price" ,"unit" ,"base" ,"validfrom"
,"priceconstid" FROM "priceconstants" WHERE ((("name" LIKE 'RAM%' ) AND ("subsidyid" =
'v' ) ) AND ("validfrom" <= '2000-11-30' ) ) ORDER BY "priceconstants"."validfrom"
DESC
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 780 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 781 user moray db maint socket 5
postmaster child[781]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1347
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "name" ,"subsidyid" ,"price" ,"unit" ,"base" ,"validfrom"
,"priceconstid" FROM "priceconstants" WHERE ((("name" LIKE 'HD%' ) AND ("subsidyid" =
'v' ) ) AND ("validfrom" <= '2000-11-30' ) ) ORDER BY "priceconstants"."validfrom"
DESC
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 781 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 782 user moray db maint socket 5
postmaster child[782]: starting with (/usr/local/pgsql/bin/postgres -d2 -e -v131072 -p
maint )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = moray
RemoteHost = a.b.c.d
RemotePort = 1348
DatabaseName = maint
Verbose = 2
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "price" FROM "pricescreens" WHERE ((("size" >= 0 ) AND ("subsidyid" =
'v' ) ) AND ("validfrom" <= '2000-11-30' ) ) ORDER BY "pricescreens"."validfrom"
DESC,"pricescreens"."size"
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
StartTransactionCommand
query: INSERT INTO "invoicedebits" ("regno","accountid","debitdate","amount","genre")
VALUES (6229,1700,'1999-12-01',23.830000,'renew')
ProcessQuery
CommitTransactionCommand
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 782 exited with status 0
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling writing 5
postmaster: BackendStartup: pid 783 user moray db maint socket 5
