Ruger Security-9 Compact 9mm Pistol

  • Item Number: 3818
  • /
  • View More Items by Ruger
  • /
  • Condition: NEW
In Stock and Ready to Ship
    $379.00
    $294.99
  • Includes free shipping
  • Limited-time Deal
Share this
  • SPRINGFIELD HELLCAT 9MM BLACK MICRO COMPACT PISTOL

    Springfield Hellcat 9mm Black Micro Compact Pistol
    $569.00 $499.99

  • RUGER EC9S 9MM STRIKER-FIRED PISTOL

    Ruger EC9s 9mm Striker-Fired Pistol
    $299.00 $199.99

  • HI POINT C-9 YEET CANNON G1 9MM PISTOL

    Hi Point C-9 Yeet Cannon G1 9mm High-Impact Polymer Frame Pistol
    $199.00 $169.00

  • SPRINGFIELD XDS MOD.2 9MM INSTANT GEAR UP PACKAGE

    Springfield XDS Mod.2 9mm Instant Gear Up Package with 5 Mags, Range Bag, Holster and Mag Pouch
    $568.00 $419.99

  • KIMBER MICRO 9 STAINLESS 9MM W/ ROSEWOOD GRIPS

    Kimber Micro 9 Stainless 9mm Luger with Rosewood Grips
    $654.00 $528.00

  • SIG SAUER P320 X-FIVE LEGION 9MM FULL-SIZE PISTOL

    Sig Sauer P320 X-Five Legion 9mm Full-Size Pistol with 3 Magazines
    $1,082.00 $899.99

  • FNH FNS-9 COMPACT 9MM FDE WITH NIGHT SIGHTS

    FNH FNS-9 Compact 9mm Flat Dark Earth Pistol with Night Sights
    $649.00 $419.99

  • SPRINGFIELD XD MOD.2 9MM SUB-COMPACT INSTANT GEAR UP PACKAGE

    Springfield XD Mod.2 9mm Sub-Compact Pistol with Instant Gear Up Package
    $579.00 $449.99

  • BERETTA BU9 NANO 9MM

    Beretta BU9 Nano 9mm Centerfire Pistol
    $450.00 $249.99

  • SCCY CPX-2 TT 9MM STAINLESS STEEL

    SCCY CPX-2 9mm Black Pistol with Stainless Slide
    $339.00 $179.99

  • FNH FN 509 TACTICAL FDE 9MM 17  24 RND MAGS

    FNH FN 509 Tactical 9mm Flat Dark Earth (FDE) Striker-Fired Optics Ready Pistol
    $1,049.00 $899.00

  • SCCY CPX-2 9MM PINK STAINLESS PISTOL

    SCCY CPX-2 9mm Pink Pistol with Stainless Slide
    $339.00 $179.99

  • Federal 9mm Luger 115 gr FMJ Aluminum Case Champion 100/Box

    Federal 9mm Luger 115 gr FMJ Aluminum Case Champion 100/Box
    $15.99
    ($0.16 / round)

  • CCI 9mm 115 gr FMJ Blazer Brass 50/Box

    CCI 9mm 115 gr FMJ Blazer Brass 50/Box
    $16.95 $8.99
    ($0.18 / round)

  • CCI 9mm 124 gr FMJ Blazer Brass 50/Box

    CCI 9mm 124 gr FMJ Blazer Brass 50/Box
    $16.95 $8.99
    ($0.18 / round)

  • Magtech 9mm Luger 115 gr FMJ Centerfire Ammo 50/Box

    Magtech 9mm Luger 115 gr FMJ Centerfire Ammo 50/Box
    Bulk discount:
    $7.99 ($0.16 / round)

  • Federal 9mm Luger 115 gr TSJ American Eagle Syntech

    Federal 9mm Luger 115 gr TSJ American Eagle Syntech
    $19.95 $9.99
    ($0.20 / round)

  • Federal 9mm Luger 115 gr  FMJ Black Pack 250/Box

    Federal 9mm Luger 115 gr FMJ Black Pack 250/Box
    $47.99
    ($0.19 / round)

  • Federal 9mm Luger 124 gr FMJ American Eagle 50/Box

    Federal 9mm Luger 124 gr FMJ American Eagle 50/Box
    $17.95 $10.99
    ($0.22 / round)

  • Hornady 9mm Luger+P 135 gr FlexLock Critical Duty 25/Box

    Hornady 9mm Luger+P 135 gr FlexLock Critical Duty 25/Box
    $30.71 $19.55
    ($0.78 / round)

  • Sig Sauer 9mm NATO +P 124 gr JHP V-Crown M17 Military Grade 20/Box

    Sig Sauer 9mm NATO +P 124 gr JHP V-Crown M17 Military Grade 20/Box
    $20.95 $13.78
    ($0.69 / round)

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 248) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in C:/inetpub/wwwroot/products2_similaritems_firearms.cfm: line 117
Called from C:/inetpub/wwwroot/products2_similaritems.cfm: line 8
Called from C:/inetpub/wwwroot/products2.cfm: line 967
Called from C:/inetpub/wwwroot/products2.cfm: line 75
Called from C:/inetpub/wwwroot/products2.cfm: line 1
Called from C:/inetpub/wwwroot/products2_similaritems_firearms.cfm: line 117
Called from C:/inetpub/wwwroot/products2_similaritems.cfm: line 8
Called from C:/inetpub/wwwroot/products2.cfm: line 967
Called from C:/inetpub/wwwroot/products2.cfm: line 75
Called from C:/inetpub/wwwroot/products2.cfm: line 1
115 : 								from tb_skus a 
116 : 								left join tb_sku_buckets e on (e.sku_id = a.sku_id) 
117 : 								where a.style_id = #getproducts.style_id# and e.store_id = #application.qoh_store# 
118 : 								group by a.style_id, e.qc
119 : 								</cfquery>

SQLSTATE   40001
DATASOURCE   celerantsql
VENDORERRORCODE   1205
SQL    select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold from tb_skus a left join tb_sku_buckets e on (e.sku_id = a.sku_id) where a.style_id = 217965 and e.store_id = 10 group by a.style_id, e.qc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.227.2.109
Referrer  
Date/Time   17-Oct-19 02:40 PM
Stack Trace
at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:/inetpub/wwwroot/products2_similaritems_firearms.cfm:117) at cfproducts2_similaritems2ecfm788571315.runPage(C:/inetpub/wwwroot/products2_similaritems.cfm:8) at cfproducts22ecfm199348766._factor15(C:/inetpub/wwwroot/products2.cfm:967) at cfproducts22ecfm199348766._factor19(C:/inetpub/wwwroot/products2.cfm:75) at cfproducts22ecfm199348766.runPage(C:/inetpub/wwwroot/products2.cfm:1) at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:/inetpub/wwwroot/products2_similaritems_firearms.cfm:117) at cfproducts2_similaritems2ecfm788571315.runPage(C:/inetpub/wwwroot/products2_similaritems.cfm:8) at cfproducts22ecfm199348766._factor15(C:/inetpub/wwwroot/products2.cfm:967) at cfproducts22ecfm199348766._factor19(C:/inetpub/wwwroot/products2.cfm:75) at cfproducts22ecfm199348766.runPage(C:/inetpub/wwwroot/products2.cfm:1)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 248) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.$fr$execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1537)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:\inetpub\wwwroot\products2_similaritems_firearms.cfm:117)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfproducts2_similaritems2ecfm788571315.runPage(C:\inetpub\wwwroot\products2_similaritems.cfm:8)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfproducts22ecfm199348766._factor15(C:\inetpub\wwwroot\products2.cfm:967)
	at cfproducts22ecfm199348766._factor19(C:\inetpub\wwwroot\products2.cfm:75)
	at cfproducts22ecfm199348766.runPage(C:\inetpub\wwwroot\products2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:223)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)