dbTalk Databases Forums  

Problem with log, question marks with select instead of values...

mailing.database.mysql-java mailing.database.mysql-java


Discuss Problem with log, question marks with select instead of values... in the mailing.database.mysql-java forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rafal Zawadzki
 
Posts: n/a

Default Problem with log, question marks with select instead of values... - 10-28-2005 , 03:46 AM






--nextPart4032956.KGeXfVGMTK
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi. I am using mysql connector, version 3.11.

I found, that in /var/log/mysq.log there is no values for Execute statemen=
t=20
with select. Instead of them, there are questions marks. When I run update =
or=20
instert, there is no problem, there are values in log file. MySQL version=20
4.1, and i've tried it with connectoy 3.10 version also. On the other=20
machines, everything is ok. Any idea?

44 Execute [1] select entry0_.id as id, entry0_.access_count as access2=
_,=20
entry0_.created as created, entry0_.cache_key as cache4_,=20
entry0_.last_accessed as last5_, entry0_.value as value, entry0_.region as=
=20
region from query_cache_store entry0_ where=20
(entry0_.region=3D? )and(entry0_.cache_key=3D? ) order by id desc limit 1

Thanks,

=2D-=20
Rafa=C5=82 Zawadzki
eo Networks Sp. z o.o.

--nextPart4032956.KGeXfVGMTK
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBDYeRI8+Mv6rzrRT8RAjRSAJ0Z9vkJ55yz4DKSvgtYex Mu4ib0/QCeOjV9
iCkp5ZIuiiiUWY5rQxxTnEM=
=dzhW
-----END PGP SIGNATURE-----

--nextPart4032956.KGeXfVGMTK--

Reply With Quote
  #2  
Old   
Mark Matthews
 
Posts: n/a

Default Re: Problem with log, question marks with select instead of values... - 10-28-2005 , 09:01 AM






-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rafal Zawadzki wrote:
Quote:
Hi. I am using mysql connector, version 3.11.

I found, that in /var/log/mysq.log there is no values for Execute statement
with select. Instead of them, there are questions marks. When I run update or
instert, there is no problem, there are values in log file. MySQL version
4.1, and i've tried it with connectoy 3.10 version also. On the other
machines, everything is ok. Any idea?

44 Execute [1] select entry0_.id as id, entry0_.access_count as access2_,
entry0_.created as created, entry0_.cache_key as cache4_,
entry0_.last_accessed as last5_, entry0_.value as value, entry0_.region as
region from query_cache_store entry0_ where
(entry0_.region=? )and(entry0_.cache_key=? ) order by id desc limit 1

Thanks,

Rafal,

See http://bugs.mysql.com/?id=14346 (it's a server bug).

-Mark

- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDYi8StvXNTca6JD8RAn9wAKCyJcvSv1kKtmwB93Cd0m 8SDkhl5ACeKLZ3
uDBZLxY+I55YVd7WzaQR+fM=
=zvp2
-----END PGP SIGNATURE-----

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw



Reply With Quote
  #3  
Old   
Rafal Zawadzki
 
Posts: n/a

Default Re: Problem with log, question marks with select instead of values... - 10-28-2005 , 09:43 AM



--nextPart2477501.jN3re3N93B
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

### Mark Matthews <mark (AT) mysql (DOT) com> wrote message to Rafal Zawadzki=20
<rafal.zawadzki (AT) eo (DOT) pl> ###
### this is reply for: Re: Problem with log, question marks with select=20
instead of values... ###

Quote:
Rafal,

See http://bugs.mysql.com/?id=3D14346 (it's a server bug).

-Mark
It is another bug

I've got prepared statements, there are in the log. There is no values with=
=20
execut statements...

=2D-=20
Rafa=C5=82 Zawadzki
Deploy/Release Manager
eo Networks Sp. z o.o.

--nextPart2477501.jN3re3N93B
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBDYjmQ8+Mv6rzrRT8RAjtJAJ4qdny9fV4r0JBkivZMVP xhPbPlWwCfR01g
pgNH1lynTbTupLTseufhjwE=
=Y2TW
-----END PGP SIGNATURE-----

--nextPart2477501.jN3re3N93B--


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.