whats all this about

  123pete 00:28 27 Jun 05
Locked

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The error occurred in D:\inetpub\click here\discuss\actions\max_ID.cfm: line 8
Called from D:\inetpub\click here\discuss\actions\act_createthread.cfm: line 66
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 157
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 150
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 16
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 1
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 130
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 2
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 1
Called from D:\inetpub\click here\index.cfm: line 6
Called from D:\inetpub\click here\discuss\actions\max_ID.cfm: line 8
Called from D:\inetpub\click here\discuss\actions\act_createthread.cfm: line 66
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 157
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 150
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 16
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 1
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 130
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 2
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 1
Called from D:\inetpub\click here\index.cfm: line 6

6 : cfquery name="getmaxID" datasource="#attributes.datasource#">
7 : select max(#attributes.PrimaryKEY#) as Max_ID
8 : from #attributes.tablename#
9 : /cfquery>
10 :



--------------------------------------------------------------------------------

can not fit the rest

  p;3 00:52 27 Jun 05

there is an 800 word limit per posting on this forum; so whatever it is you have got you will need to split it up;and can you tell folks what you were doing when whatever this is happened? and your operating system etc please :) were you trying to download something or....

  123pete 01:23 27 Jun 05

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The error occurred in D:\inetpub\click here\discuss\actions\max_ID.cfm: line 8
Called from D:\inetpub\click here\discuss\actions\act_createthread.cfm: line 66
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 157
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 150
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 16
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 1
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 130
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 2
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 1
Called from D:\inetpub\click here\index.cfm: line 6
Called from D:\inetpub\click here\discuss\actions\max_ID.cfm: line 8
Called from D:\inetpub\click here\discuss\actions\act_createthread.cfm: line 66
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 157
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 150
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 16
Called from D:\inetpub\click here\discuss\fbx_Switch.cfm: line 1
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 130
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 2
Called from D:\inetpub\click here\fbx_fusebox30_CF50.cfm: line 1
Called from D:\inetpub\click here\index.cfm: line 6

6 : <cfquery name="getmaxID" datasource="#attributes.datasource#">
7 : select max(#attributes.PrimaryKEY#) as Max_ID
8 : from #attributes.tablename#
9 : </cfquery>
10 :

  123pete 01:26 27 Jun 05

SQL select max(messageid) as Max_ID from discussion_messages
DATASOURCE pcadvisor
VENDORERRORCODE 1205
SQLSTATE 40001

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.2.0; .NET CLR 1.1.4322; yplus 5.3.00b)
Remote Address 81.129.200.190
Referrer click here
Date/Time 27-Jun-05 12:24 AM

Stack Trace (click to expand)
at cfmax_ID2ecfm1499661228.runPage(D:\inetpub\click here\discuss\actions\max_ID.cfm:8) at cfact_createthread2ecfm949719150.runPage(D:\inetpub\click here\discuss\actions\act_createthread.cfm:66) at cffbx_Switch2ecfm94192426._factor23(D:\inetpub\click here\discuss\fbx_Switch.cfm:157) at cffbx_Switch2ecfm94192426._factor32(D:\inetpub\click here\discuss\fbx_Switch.cfm:150) at cffbx_Switch2ecfm94192426._factor33(D:\inetpub\click here\discuss\fbx_Switch.cfm:16) at cffbx_Switch2ecfm94192426.runPage(D:\inetpub\click here\discuss\fbx_Switch.cfm:1) at cffbx_fusebox30_CF502ecfm955921668._factor5(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:130) at cffbx_fusebox30_CF502ecfm955921668._factor6(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:2) at cffbx_fusebox30_CF502ecfm955921668.runPage(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm954787176.runPage(D:\inetpub\click here\index.cfm:6) at cfmax_ID2ecfm1499661228.runPage(D:\inetpub\click here\discuss\actions\max_ID.cfm:8) at cfact_createthread2ecfm949719150.runPage(D:\inetpub\click here\discuss\actions\act_createthread.cfm:66) at cffbx_Switch2ecfm94192426._factor23(D:\inetpub\click here\discuss\fbx_Switch.cfm:157) at cffbx_Switch2ecfm94192426._factor32(D:\inetpub\click here\discuss\fbx_Switch.cfm:150) at cffbx_Switch2ecfm94192426._factor33(D:\inetpub\click here\discuss\fbx_Switch.cfm:16) at cffbx_Switch2ecfm94192426.runPage(D:\inetpub\click here\discuss\fbx_Switch.cfm:1) at cffbx_fusebox30_CF502ecfm955921668._factor5(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:130) at cffbx_fusebox30_CF502ecfm955921668._factor6(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:2) at cffbx_fusebox30_CF502ecfm955921668.runPage(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm954787176.runPage(D:\inetpub\click here\index.cfm:6)


java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java:230)
at coldfusion.sql.QueryTable.populate(QueryTable.java:159)
at coldfusion.sql.Executive.getRowSet(Executive.java:505)
at coldfusion.sql.Executive.executeQuery(Executive.java:974)
at coldfusion.sql.Executive.executeQuery(Executive.java:886)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
at

  123pete 01:30 27 Jun 05

at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfmax_ID2ecfm1499661228.runPage(D:\inetpub\click here\discuss\actions\max_ID.cfm:8)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:60)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881)
at cfact_createthread2ecfm949719150.runPage(D:\inetpub\click here\discuss\actions\act_createthread.cfm:66)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cffbx_Switch2ecfm94192426._factor23(D:\inetpub\click here\discuss\fbx_Switch.cfm:157)
at cffbx_Switch2ecfm94192426._factor32(D:\inetpub\click here\discuss\fbx_Switch.cfm:150)
at cffbx_Switch2ecfm94192426._factor33(D:\inetpub\click here\discuss\fbx_Switch.cfm:16)
at cffbx_Switch2ecfm94192426.runPage(D:\inetpub\click here\discuss\fbx_Switch.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cffbx_fusebox30_CF502ecfm955921668._factor5(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:130)
at cffbx_fusebox30_CF502ecfm955921668._factor6(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:2)
at cffbx_fusebox30_CF502ecfm955921668.runPage(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cfindex2ecfm954787176.runPage(D:\inetpub\click here\index.cfm:6)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

  123pete 01:32 27 Jun 05

at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfmax_ID2ecfm1499661228.runPage(D:\inetpub\click here\discuss\actions\max_ID.cfm:8)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:60)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881)
at cfact_createthread2ecfm949719150.runPage(D:\inetpub\click here\discuss\actions\act_createthread.cfm:66)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cffbx_Switch2ecfm94192426._factor23(D:\inetpub\click here\discuss\fbx_Switch.cfm:157)
at cffbx_Switch2ecfm94192426._factor32(D:\inetpub\click here\discuss\fbx_Switch.cfm:150)
at cffbx_Switch2ecfm94192426._factor33(D:\inetpub\click here\discuss\fbx_Switch.cfm:16)
at cffbx_Switch2ecfm94192426.runPage(D:\inetpub\click here\discuss\fbx_Switch.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cffbx_fusebox30_CF502ecfm955921668._factor5(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:130)
at cffbx_fusebox30_CF502ecfm955921668._factor6(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:2)
at cffbx_fusebox30_CF502ecfm955921668.runPage(D:\inetpub\click here\fbx_fusebox30_CF50.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at cfindex2ecfm954787176.runPage(D:\inetpub\click here\index.cfm:6)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)

  dagwoood 01:33 27 Jun 05

Myself and some other forum members were receiving these error messages a couple of months ago when the site was slow for some users.

The FE was aware of the problem and took measures to correct it.

HTH, dagwoood.

  123pete 01:37 27 Jun 05

at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

ONLY WANTED TO START DESCUSION.
I'M USING WIDOWS XP.

  p;3 18:48 27 Jun 05

is this still an issue?

  Djohn 18:53 27 Jun 05

Just a slight glitch in the early hours that has now been fixed, I'm sure that very few of us would even understand it let alone be able to discuss it. ;o)

  p;3 19:10 27 Jun 05

sorry; bad turn of phrase; I probably logged out before this happened; I presume this thread issue is now for the green tick :))

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…