Skip to content

Prepared stored procedure does not work anymore after some time #2633

Closed
@JDBC-0

Description

@JDBC-0

Driver version

12.8.1

SQL Server version

Microsoft SQL Server 2019 (RTM-CU29-GDR) (KB5046860) - 15.0.4410.1 (X64) Oct 23 2024 15:50:49 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: )

Client Operating System

Microsoft Windows [Version 10.0.14393]

JAVA/JVM version

21.0.5

Table schema

Problem description

We have a simple store procedure as a prepared statement that is executed several thousand times a day and only contains 2 simple UPDATE statements. It works most of the time, but after some weeks7months, suddenly the procuedure does not do anything anymore. We printed log statements before and after execution, there is no exception .... when it happens, it does not heal itself anymore! The only "solution" is to completely exit the whole application for the next start to prepare all statements again.

Expected behavior

A working prepared stored procedure should work all the time - no matter how often called.

Actual behavior

After several weeks7Months (with thousands of calls), it suddenly does not execute the UPDATE statements in the procedure code anymore. The call is finished in "0 ms". We expect the driver to somehow got corrupted and even does not through any exception but simple swallows the call / bug.

Error message/stack trace

Nothing, alas.

Any other details that can be helpful

Occurs only after many calls by accident.

JDBC trace logs

Metadata

Metadata

Assignees

Labels

Under InvestigationUsed for issues under investigationWaiting for ResponseWaiting for a reply from the original poster, or affiliated party

Type

No type

Projects

Status

Closed Issues

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions