4.5.2.xxx serious blocking issue (mysql datasources unusable)

dev google-group-archive
1

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

2

I will look into it with highest priority
I keep you posted

MichaAm Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

–
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
<javascript:_e(%7B%7D,‘cvml’,‘lucee%2Bunsubscribe@googlegroups.com’);>.
To post to this group, send email to lucee@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee@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
https://groups.google.com/d/msgid/lucee/CAMaJE6v20%3DrWv63%2B%3D8KK%2BtphpOruEOxX%3DtOuvNxVwr5cB04CrQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

3

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.2015-09-01 14:11 GMT+02:00 Michael Offner <@Michael_Offner>:

I will look into it with highest priority
I keep you posted

Micha

Am Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

–
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 lucee@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
https://groups.google.com/d/msgid/lucee/CAMaJE6v20%3DrWv63%2B%3D8KK%2BtphpOruEOxX%3DtOuvNxVwr5cB04CrQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
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 lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAG%2BEEBxgXNSCrz6%2BUP7f1Vx2jba%2BPBTJccPoy8CEmN2AsNKahQ%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAG%2BEEBxgXNSCrz6%2BUP7f1Vx2jba%2BPBTJccPoy8CEmN2AsNKahQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Michael van Leest

4

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

5

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

Thanks!2015-09-07 23:32 GMT+02:00 Alex Skinner <@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

On 7 September 2015 at 11:18, Tom Chiverton <@Tom_Chiverton> wrote:

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

Tom

On Tuesday, September 1, 2015 at 1:11:08 PM UTC+1, Micha wrote:

I will look into it with highest priority
I keep you posted

Micha

Am Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

–
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 lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/0a35ae3f-bd2a-465f-9d2f-78883961e31e%40googlegroups.com
https://groups.google.com/d/msgid/lucee/0a35ae3f-bd2a-465f-9d2f-78883961e31e%40googlegroups.com?utm_medium=email&utm_source=footer
.

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: info@pixl8.co.uk

Follow us on: Facebook http://www.facebook.com/pixl8 Twitter
http://www.twitter.com/pixl8 LinkedIn http://www.linkedin.com/pixl8

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

–
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 lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAFrbJ5VzBLS-UhKUyAejbtxTnHpWWcdh8xwTP51K72wOeCY8ZA%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAFrbJ5VzBLS-UhKUyAejbtxTnHpWWcdh8xwTP51K72wOeCY8ZA%40mail.gmail.com?utm_medium=email&utm_source=footer
.

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

–
Michael van Leest

6

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!On Monday, 7 September 2015 11:18:03 UTC+1, Tom Chiverton wrote:

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

Tom

On Tuesday, September 1, 2015 at 1:11:08 PM UTC+1, Micha wrote:

I will look into it with highest priority
I keep you posted

Micha

Am Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

7

Just replied on JIRA. Will provide some example code and data tomorrow when
I’m at the office.2015-09-07 23:23 GMT+02:00 Simon Hooker <@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!

On Monday, 7 September 2015 11:18:03 UTC+1, Tom Chiverton wrote:

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

Tom

On Tuesday, September 1, 2015 at 1:11:08 PM UTC+1, Micha wrote:

I will look into it with highest priority
I keep you posted

Micha

Am Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

–
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 lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/3e0a1d89-590d-416c-af9f-afa3b254f052%40googlegroups.com
https://groups.google.com/d/msgid/lucee/3e0a1d89-590d-416c-af9f-afa3b254f052%40googlegroups.com?utm_medium=email&utm_source=footer
.

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

–
Michael van Leest

8

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

TomOn Tuesday, September 1, 2015 at 1:11:08 PM UTC+1, Micha wrote:

I will look into it with highest priority
I keep you posted

Micha

Am Dienstag, 1. September 2015 schrieb 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
[LDEV-471] - Lucee

9

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

What are the contents of your my.cnfOn 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
[LDEV-471] - Lucee

–
Michael van Leest

10

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 <javascript:>> 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
[LDEV-471] - Lucee

–
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 lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sent from Gmail Mobile

11

@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 <@Terry_Whitney> 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
[LDEV-471] - Lucee

–
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
<javascript:_e(%7B%7D,‘cvml’,‘lucee%2Bunsubscribe@googlegroups.com’);>.
To post to this group, send email to lucee@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee@googlegroups.com’);>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5820b065-da51-429e-9835-b689d831409b%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Sent from Gmail Mobile