Public bug reported:
Binary package hint: samba
Ubuntu 8.04 / Samba 3.028a
when sharing a Microsoft Access mdb file for read AND write access to at
least 2 clients on different PCs your mdb may get corrupted (in my case
it always does in a few days or weeks). It took me months to figure this
out but now I finally have a clear test case which fails in a few
seconds every time it is performed against samba/ubuntu when on the
other hand it never fails on smb/windows.
My test case involves repeatedly calling a part of a complex Microsoft
Access front-end application that simulates intensive user read/write
activity against an mdb back-end which is placed either on an Ubuntu
Server or on a Windows 2003 server (actually running on a VM within that
Ubuntu Server). If it's necessary I can share that application (you'll
need two windows clients to run it). Executing the application from two
clients in a specific order[2] results in the two clients getting an
Access error[1]. The exact same test never fails if I'm sharing the
back-end mdb on a Windows 2003 server.
Haven't yet tested on newer versions of Linux.
_________________
[1] The two clients are creating records with an auto-number field which is
supposed to be incrementing by one for every new record. At the point of
failure the auto-number field is 100 but client A thinks it's 90 and tries to
create a record with id 91 and client B thinks it's 95 and tries to create a
record with id 96 (and of course both attempts produce an error).
[2] The order is this:
a) start the application on client-A (the app begins rapid and continuous
reading/modifying/creating records on more that one tables)
b) start the same application on client-B
c) quit the application from client-B
d) restart it
** Affects: samba (Ubuntu)
Importance: Undecided
Status: New
** Tags: corruption mdb
--
Corruption on mdbs with multiple clients
https://bugs.launchpad.net/bugs/668310
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to samba in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
