sqlgrey-users

[Sqlgrey-users] prepared cache still active?

[Daniel J M. <dan...@au...>]

What does this warning mean?  I get thousands of them a day on a
relatively new installation of sqlgrey 1.6.6:
Oct  3 16:44:38 sa sqlgrey: warning: prepare_cached(SELECT 1 FROM
optout_domain WHERE domain = ?) statement handle DBI::st=HASH(0x853e7b4)
still Active at /usr/sbin/sqlgrey line 246 


-- 
Daniel J McDonald, CCIE # 2495, CISSP # 78281, CNX
Austin Energy
http://www.austinenergy.com

Re: [Sqlgrey-users] prepared cache still active?

[Dan F. <da...@ha...>]

Hi Daniel.


Daniel J McDonald wrote:
> Oct  3 16:44:38 sa sqlgrey: warning: prepare_cached(SELECT 1 FROM
> optout_domain WHERE domain = ?) statement handle DBI::st=HASH(0x853e7b4)
> still Active at /usr/sbin/sqlgrey line 246 
You probably have the buggy version of DBD::mysql.

See http://sourceforge.net/mailarchive/message.php?msg_id=36332668
(its the mailing list archive of this list)

The last person who had this problem, downgraded the DBD::mysql and it 
worked for him..

Hope this helps.
- Dan

Re: [Sqlgrey-users] prepared cache still active?

[Daniel J M. <dan...@au...>]

On Thu, 2006-10-05 at 18:33 +0200, Dan Faerch wrote:
> Hi Daniel.
> 
> 
> Daniel J McDonald wrote:
> > Oct  3 16:44:38 sa sqlgrey: warning: prepare_cached(SELECT 1 FROM
> > optout_domain WHERE domain = ?) statement handle DBI::st=HASH(0x853e7b4)
> > still Active at /usr/sbin/sqlgrey line 246 
> You probably have the buggy version of DBD::mysql.
> 
> See http://sourceforge.net/mailarchive/message.php?msg_id=36332668
> (its the mailing list archive of this list)
> 
> The last person who had this problem, downgraded the DBD::mysql and it 
> worked for him..

Looks like it was fixed in 3.0007; there was a release note about it, so
I tried an upgrade rather than a downgrade.

It appears to be working.  Thanks for the tip!


-- 
Daniel J McDonald, CCIE # 2495, CISSP # 78281, CNX
Austin Energy
http://www.austinenergy.com

[Sqlgrey-users] sqlgrey dying

[Steve H. <st...@th...>]

sqlgrey has recently started dying, see log entries below:


Jan  5 14:58:02 frigga sqlgrey: fatal: Quantifier follows nothing in
regex; marked by <-- HERE in m/+ <-- HERE [.*-]+_-jjv[=\?\*~\.]+?
identify[.*-]+co[.*-]+uk|identify[.*-]+co[.*-]+uk[=\?\*~\.]+?+[.*-]+_-
jjv|+[.*-]+_-jjv/ at /usr/sbin/sqlgrey line 997.

Jan  9 03:36:14 frigga sqlgrey: fatal: Quantifier follows nothing in
regex; marked by <-- HERE in m/+ <-- HERE [.*-]+_-ndih[=\?\*~\.]+?
michaelwood[.*-]+co[.*-]+uk|michaelwood[.*-]+co[.*-]+uk[=\?\*~\.]+?
+[.*-]+_-ndih|+[.*-]+_-ndih/ at /usr/sbin/sqlgrey line 997.


In the lines above both identify.co.uk & michaelwood.co.uk are domains
hosted by us.

We are running  V1.7.1


-- 
thorNET
Internet Services, Consultancy & Training
www.thornet.co.uk

Re: [Sqlgrey-users] sqlgrey dying

[Lionel B. <lio...@bo...>]

Steve Heaven wrote the following on 09.01.2007 10:34 :
>
> sqlgrey has recently started dying, see log entries below:
>
>
> Jan  5 14:58:02 frigga sqlgrey: fatal: Quantifier follows nothing in 
> regex; marked by <-- HERE in m/+ <-- HERE 
> [.*-]+_-jjv[=\?\*~\.]+?identify[.*-]+co[.*-]+uk|identify[.*-]+co[.*-]+uk[=\?\*~\.]+?+[.*-]+_-jjv|+[.*-]+_-jjv/ 
> at /usr/sbin/sqlgrey line 997.
>
> Jan  9 03:36:14 frigga sqlgrey: fatal: Quantifier follows nothing in 
> regex; marked by <-- HERE in m/+ <-- HERE 
> [.*-]+_-ndih[=\?\*~\.]+?michaelwood[.*-]+co[.*-]+uk|michaelwood[.*-]+co[.*-]+uk[=\?\*~\.]+?+[.*-]+_-ndih|+[.*-]+_-ndih/ 
> at /usr/sbin/sqlgrey line 997.
>
>
> In the lines above both identify.co.uk & michaelwood.co.uk are domains 
> hosted by us.
>
> We are running  V1.7.1

If you need the development version functionalities, please use 1.7.4. 
If not, 1.6.7 is the latest stable version.

Bug reports for intermediate versions take more efforts to check and 
might even be solved in the latest versions.

Lionel.