[Insert Permission fails randomly]

>Description:
While running a program which does repeated "Replace Into table"
commands successfully, the program exited when it received a bogus
MySQL error:
"1142 (insert command denied to user: 'username@remotehost.claimlynx.com' for table 'mytablename')".
Retrying the exact same SQL command with the same exact user on the
same host completes successfully. Database is a production database,
and NO permission changes (nor ANY changes to database "mysql")
have been made in months.
>How-To-Repeat:
This occurs randomly. Most of the time SQL statements complete
correctly.
>Fix:
Only work-around is to re-run program, an unacceptable solution
as there are many dependencies, and the program typically takes
12 to 18 hours each day to run to completion.

>Submitter-Id:
>Originator: Chris Johnson
>Organization:

>MySQL support: none
>Synopsis: Insert permission fails randomly
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (FreeBSD port: mysql-server-3.23.49)

>Environment:

System: FreeBSD cheetah.claimlynx.com 4.6.2-RELEASE FreeBSD 4.6.2-RELEASE #3: Sat Aug 31 15:24:40 CDT 2002 wmo@cheetah.claimlynx.com:/usr/src/sys/compile/CHEETAH i386

NOTE: Dual-CPU machine running native FreeBSD thread support, so pretty much
MySQL only uses one CPU.


Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1223390 Aug 31 15:07 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Aug 31 15:07 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 580520 Aug 31 15:07 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.49' --enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local i386--freebsd4.5
Perl: This is perl, version 5.005_03 built for i386-freebsd

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13335@lists.mysql.com
To unsubscribe, e-mail

Re: [Insert Permission fails randomly]

On Thursday 19 December 2002 19:02, chris@claimlynx.com wrote:
> >Description:
> While running a program which does repeated "Replace Into table"
> commands successfully, the program exited when it received a bogus
> MySQL error:
> "1142 (insert command denied to user: 'username@remotehost.claimlynx.com'
for table 'mytablename')".
> Retrying the exact same SQL command with the same exact user on the
> same host completes successfully. Database is a production database,
> and NO permission changes (nor ANY changes to database "mysql")
> have been made in months.
> >How-To-Repeat:
> This occurs randomly. Most of the time SQL statements complete
> correctly.
> >Fix:
> Only work-around is to re-run program, an unacceptable solution
> as there are many dependencies, and the program typically takes
> 12 to 18 hours each day to run to completion.


Actually this looks like rather strange problem. It could be somehow related
to realpath problem in FreeBSD which was recently fixed, but it is not that
likely

I would ask you to try in MySQL 3.23.54 also has this problem on the place,
and this is the fact to try to create minimal repeatable case for it.
It does not matter if it takes 40 hours to repeat. We can run it on our
FreeBSD system for required amount of time.




--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13337@lists.mysql.com
To unsubscribe, e-mail