Adam Cameron
zackster
08/31/2022, 7:33 AMfoundeo
isImageFile( url )
is several times slower than cfhttp + isImageFile( tempFile ) : https://luceeserver.atlassian.net/browse/LDEV-4177 so much so that it appears to request the url multiple timesUmair Khan
08/31/2022, 4:33 PMUmair Khan
08/31/2022, 4:34 PMGareth
09/05/2022, 6:53 AMgsr
09/06/2022, 2:47 AMsneiland
09/06/2022, 4:41 PMgert
09/06/2022, 6:21 PMgert
09/06/2022, 6:21 PMsneiland
09/06/2022, 6:22 PMrichard.herbert
09/06/2022, 7:23 PMzackster
09/06/2022, 8:54 PMzackster
09/07/2022, 9:13 AMAdam Cameron
<cfquery>
call that causes a DB error, is there any way of getting back the exact SQL string that was sent to the DB? In the returned exception all the param values have been inlined into the SQL (eg: I see SELECT * from tbl WHERE col = 'param value'
not SELECT * from tbl WHERE col = ?
(and then a separate struct of the param values that were passed).
Reason being... the error I am getting is with how Lucee is passing the param values, and I can't troubleshoot it if I can't see what it's passing.
I could likely get it back from the underlying JDBC exception, but Lucee swallows that (see https://luceeserver.atlassian.net/browse/LDEV-3738).
Am just wondering if there's any other way.
The issue is that somehow an SQL string / <cfqueryparam>
combo I am getting is somehow passing more params than it is param markers (ie, the ?
in the SQL string), and I'm trying to work out why. Error is Parameter index out of range (3 > number of parameters, which is 2)
The SQL string is getting munged by some CFWheels stupidity, but I am trying to work out how I'm not just getting a SQL syntax error (which I should), rather than this param count mismatch.
To recap, the question is just this: "is there any way of getting back the exact SQL string that was sent to the DB?"
The rest is context.John
09/07/2022, 3:18 PMJohn
09/07/2022, 3:19 PMAdam Cameron
davla
09/08/2022, 2:20 PMBrandon Brown
09/09/2022, 3:44 PMstillnet
09/09/2022, 4:33 PMfile or directory [<C://config/ColdSpring.json>] does not existIt's like there is a mapping pointing / to C:\, but I have checked and I don't see any odd mappings.
ryan
09/09/2022, 5:13 PMcachedWithin
directive by wanting to use an application or session scoped variable that is utilized by specific functions. Any change in the variable will then make a sweeping change to all functions utilizing cachedWithin with this variable. I even attempted to set a variable inside like so cachedWithin = createTimeSpan(0,0,variableHere,0)
, but every attempt leads to an error needing a literal value. Is there any way to create a cache on functions with a variable? Is there a reason why we cannot use a variable on a cachedWithin
directive?zackster
09/13/2022, 8:34 AMgavinbaumanis
09/13/2022, 2:12 PMcd loader
mvn test
from a CMD prompt that I started with "Run as Administrator".
So before I went into a rabbit-hole - I thought I would ask if there was something already setup - that I could use.
Thanks!Adam Cameron
https://i2.paste.pics/84cc995581c45ab856f26f3818da25ec.png▾
leftbower
09/14/2022, 11:47 PMvar userSessions = createObject( "java", "coldfusion.runtime.SessionTracker" ).getSessionCollection( application.applicationName );
userSessions.each( ( user ) => structClear( userSessions[ user ] ) );
zackster
09/15/2022, 4:04 PMJordan Clark
09/15/2022, 4:38 PMortussolutions/commandbox:jdk11-alpine
with lucee-light@5.3.9.133, the build pipeline downloads the lex extensions we use like s3, json, jdts, etc directly into ${BOX_SERVER_APP_SERVERHOMEDIRECTORY}/WEB-INF/lucee-server/deploy/
so they are warmed up and deployed, then each instance doesn't have to download the extensions from the lucee release server. This has been running basically fine like this for a couple years. The build that got deployed last night started throwing the error:
S3 uploadFormFile failed The OSGi Bundle with name [s3.extension] is not available in version [0.9.4.155-SNAPSHOT] locally (/app/server/WEB-INF/lucee-server/bundles) or from the update provider (<http://release.lucee.org>), the following versions are available locally [0.9.4.154, 0.9.4.154].
We didn't change what version of the s3 extension we use (0.9.4.154), or what version of lucee we use, it was just a code push. The only thing I can think that changed between docker builds is the base docker image, but even then I can't figure why that would make lucee v5.3.9.133 thinks it needs a different s3 extension version to run?
This has happened twice before, in exactly the same way. The fix for the problem was to bump the s3 extension to the snapshot release 0.9.4.155-SNAPSHOT, then lucee was happy and working the same. Its a bit unsettling when this to issue happens, I've come to expect docker images to be very consistent, I wouldn't expect this type of compatibility issue unless I was changing the lucee server.
Next steps is we're looking to change our build process from lucee-light to lucee regular, hoping the bundled extensions are more consistent, has anyone else run into this issue?Adam Cameron
{lucee-config}
to an actual file system path. Reason: the logging info one gets from Administrator.getLogSettings
lists the log paths as - eg - {lucee-config}/logs/exception.log
. Which is lovely, but about as useful as a chocolate teapot if I want to actually access the file.
Anyone know how to get the value of {lucee-config}
? And for bonus points: {lucee-server}
and {lucee-web}
, which are also used as placeholders in various other settings.
This seems to be obvious functionality for Administrator, given it uses these values so much..?
Cheers.Anders Lars
09/16/2022, 1:19 PM