4.5.2.xxx serious blocking issue (mysql datasources unusable)

[Michael van Leest]

Hi,

I wanted to make sure that this issue gets some attention as it blocks any use of the 4.5.2 version/updates. If a (mysql) datasource is being used, a weird error comes up complaining about negative delay. This is still the case with the latest 4.5.2.010 update.

The ticket about this issue is LDEV-471

https://luceeserver.atlassian.net/browse/LDEV-471

--

Michael van Leest

[Michael Offner]

I will look into it with highest priority

I keep you posted 

Micha

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAMaJE6v20%3DrWv63%2B%3D8KK%2BtphpOruEOxX%3DtOuvNxVwr5cB04CrQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Michael van Leest]

Thanks Michael. I'll keep an eye out on JIRA.

If you need any extra tests or error messages from me, just let me know.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAG%2BEEBxgXNSCrz6%2BUP7f1Vx2jba%2BPBTJccPoy8CEmN2AsNKahQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Michael van Leest

[Tom Chiverton]

It's been a week now and MySQL still can't be used on the dev. channel.

Tom

[Simon Hooker]

Hi there

I'm unable to reproduce this, I run my CI servers on 4.5.2.005 using CommandBox with no MySQL issues at all.

If anyone is able to provide me code + sql dumps + versions numbers that let me reproduce the issue then I will happily look into it, but at present I can't reproduce the problem with my environments!

[Alex Skinner]

Hi Tom,

Have you also experienced this issue because I think we need to revise the description.

It is not accurate to say that if you update the dev provider to latest version of Lucee that MySQL doesn't work or its blocked there has to be more to it than that?

We need a reproducable test case.

I fear it may depend how you are connecting to MySQL, I have just updated my local installation and am using MariaDB but it if was a Lucee/driver issue one would expect similar behaviour have no issues connecting to the database. Simon Hooker has tested mysql

From my crude analysis of the stack trace attached to the ticket this seems unrelated.

Can the original poster create a test case please ?

If you look at the Lucee admin you can see your exact settings used, please redact any access credentials but what would really help is something we can run, failing that a screen grab of your config options in the admin would be good ?

What about timeout values for the Datasource what are these set to ?

Thanks

Alex

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/0a35ae3f-bd2a-465f-9d2f-78883961e31e%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Alex Skinner
Managing Director

Pixl8 Interactive, 3 Tun Yard, Peardon Street, London SW8 3HT, United Kingdom T: +44 [0] 845 260 0726• W: www.pixl8.co.uk• E: in...@pixl8.co.uk

Follow us on: Facebook Twitter LinkedIn

CONFIDENTIAL AND PRIVILEGED - This e-mail and any attachment is intended solely for the addressee, is strictly confidential and may also be subject to legal, professional or other privilege or may be protected by work product immunity or other legal rules. If you are not the addressee please do not read, print, re-transmit, store or act in reliance on it or any attachments. Instead, please email it back to the sender and then immediately permanently delete it. Pixl8 Interactive Ltd Registered in England. Registered number: 04336501. Registered office: 8 Spur Road, Cosham, Portsmouth, Hampshire, PO6 3EB

[Michael van Leest]

Just replied on JIRA. Will provide some example code and data tomorrow when I'm at the office.

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/3e0a1d89-590d-416c-af9f-afa3b254f052%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Michael van Leest

[Michael van Leest]

@Alex: messages just crossed each other. Will provide example tomorrow when I'm at the office.

Thanks!

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAFrbJ5VzBLS-UhKUyAejbtxTnHpWWcdh8xwTP51K72wOeCY8ZA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Michael van Leest

[Terry Whitney]

I would look at the max connections before blaming the code.

What are the contents of your my.cnf

[Michael van Leest]

@Terry: when I run the same code (local) on 4.5.1.xxx all is fine. When I upgrade to any 4.5.2.xxx and restart, the error comes up. When the upgrade is removed and Lucee is restarted, the code works again. So imho my.conf is not the issue.

I'll be in the office in a couple of hours to get some code together for a test case.

--

See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Sent from Gmail Mobile

[Terry Whitney]

If you have a really large query cache table defined, this might happen. Seen something similar with Tomcat jsp pages.

Did you stop and then start your db engine after the upgrade?

On Tuesday, September 8, 2015 at 9:41:19 AM UTC-4, Michael van Leest wrote:

@Terry: when I run the same code (local) on 4.5.1.xxx all is fine. When I upgrade to any 4.5.2.xxx and restart, the error comes up. When the upgrade is removed and Lucee is restarted, the code works again. So imho my.conf is not the issue.

I'll be in the office in a couple of hours to get some code together for a test case.

On Tuesday, September 8, 2015, Terry Whitney <twhitn...@gmail.com> wrote:

I would look at the max connections before blaming the code.

What are the contents of your my.cnf

On Tuesday, September 1, 2015 at 5:07:32 AM UTC-4, Michael van Leest wrote:

Hi,

I wanted to make sure that this issue gets some attention as it blocks any use of the 4.5.2 version/updates. If a (mysql) datasource is being used, a weird error comes up complaining about negative delay. This is still the case with the latest 4.5.2.010 update.

The ticket about this issue is LDEV-471

https://luceeserver.atlassian.net/browse/LDEV-471

--

Michael van Leest

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.