Issue 22374 - 'Invalid Cursor State' entering new records in MySQL with Auto_Increment
Summary: 'Invalid Cursor State' entering new records in MySQL with Auto_Increment
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-12 12:13 UTC by bryancole
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description bryancole 2003-11-12 12:13:32 UTC
When I try to enter a new record into a MySQL table which has an "Auto
Increment" field, I get the following error:

"[unixODBC][Driver Manager] Invalid Cursor State"

The error means I'm unable to 'leave' the new-record field cleanly. However, a
new record *is* added to the table each time I try to leave the record-field.

Repeated attempts at leaving the record-field (generating an Invalid Cursor
State error each time) results in OO seg-fautling. The stack-trace is appended
below.

cheers,
Bryan

 
Fatal exception: Signal 6
Stack:
/home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb2e2a]
/home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb2fb4]
/home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb307a]
/lib/tls/libpthread.so.0[0x4112c7c8]
/lib/tls/libc.so.6(abort+0x1d3)[0x42028b93]
/home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x41262424]
/home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x41262471]
/home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x412625e5]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc6OTo
ols14ThrowExceptionEPNS0_11OConnectionEslsRKN3com3sun4star3uno9ReferenceINS7_10X
InterfaceEEEht+0x44d)[0x4726dd0b]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc6OTo
ols8getValueEPNS0_11OConnectionEllsRhRKN3com3sun4star3uno9ReferenceINS8_10XInter
faceEEEPvl+0x8e)[0x4726d0a2]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR
esultSet8getValueElsPvl+0x100)[0x47263532]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR
esultSet6getIntEl+0x47)[0x47263f2b]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR
esultSet7fillRowEl+0x47b)[0x47269503]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR
esultSet8getValueElsPvl+0x6f)[0x472634a1]
/home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR
esultSet6getIntEl+0x47)[0x47263f2b]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470c0f9c]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4709152b]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4709a8dc]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a3d69]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a7562]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a4a2f]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a2dd5]
/home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4706a73d]
/home/bryan/OpenOffice.org1.1/program/libsvx645li.so(_ZN13DbGridControl10SeekCur
sorElh+0x121)[0x43d6b0ed]
/home/bryan/OpenOffice.org1.1/program/libsvx645li.so(_ZN13DbGridControl7SeekRowE
l+0x34)[0x43d691d0]
/home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN9BrowseBox13ImplPaintDat
aER12OutputDeviceRK9Rectanglehh+0x2a4)[0x4063d018]
/home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN9BrowseBox9PaintDataER6W
indowRK9Rectangle+0xae)[0x4063da0a]
/home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN14BrowserDataWin5PaintER
K9Rectangle+0x56)[0x40641dc4]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x3d6)[0x40211950]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP
K6Regiont+0x49d)[0x40211a17]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window20ImplCallOverlap
PaintEv+0x6a)[0x40211b46]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window18ImplHandlePaint
HdlEPv+0x2c)[0x40211bda]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window26LinkStubImplHan
dlePaintHdlEPvS0_+0x26)[0x40211ba6]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN5Timer7TimeoutEv+0x1f)[0
x400eaf6b]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_Z21ImplTimerCallbackProcv+
0x82)[0x400eacba]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZNK7SalData7TimeoutEv+0x12
)[0x402af29a]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN7SalXLib12CheckTimeoutEb
+0xd6)[0x402aede6]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN7SalXLib5YieldEh+0x2e7)[
0x402af0db]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11SalInstance5YieldEh+0x
34)[0x402b7f70]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11Application5YieldEv+0x
61)[0x400e53c9]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11Application7ExecuteEv+
0x35)[0x400e52db]
/home/bryan/OpenOffice.org1.1/program/soffice.bin(_ZN7desktop7Desktop4MainEv+0x1
acc)[0x8064eac]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_Z6SVMainv+0x49)[0x400ea197 ]
/home/bryan/OpenOffice.org1.1/program/libvcl645li.so(main+0x1c)[0x402adb7c]
/lib/tls/libc.so.6(__libc_start_main+0xe4)[0x420156a4]
/home/bryan/OpenOffice.org1.1/program/soffice.bin(_ZN6Window11RequestHelpERK9Hel
pEvent+0x3d)[0x805e311]
Aborted
[bryan@bryan program]$
Comment 1 bryancole 2003-11-17 11:11:17 UTC
Upgrading MyODBC-2.5 to version 3.51 fixed this problem. I.e. it's not
an OpenOffice issue. I'll set this to 'Invalid'.

Bryan
Comment 2 marc.neumann 2003-11-20 08:14:18 UTC
Hi

so I close this issue.

BYe Marc
Comment 3 hans_werner67 2004-02-02 12:18:56 UTC
change subcomponent to 'none'