Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Query execution was interrupted, maximum statement execution time exceeded
sp_NewPost Add Reply sp_NewTopic Add Topic
September 7, 2020
4:05 pm
SMSer
Guest
Guests

Thanks Henk,
its caused by too many records in the messageout table. delete unnecessary rows resolve this issue.

September 7, 2020
10:51 am
Henk Helmantel
Admin
Forum Posts: 1196
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

This error comes from the MySQL database, it indicates that the database transaction takes longer than the default timeout value of MySQL transactions.

The database queries that Diafaan SMS Server send to the MySQL database are not very complex, normally they should not trigger this error. The most likely explanation for this error is that the number of records in one of the database tables is getting too large, it might be necessary to remove records or move records to another database table.

If you have changed the 'MaximumBatchSize' property of the SQL Connector to a very high value then this could also cause the error. It is best to leave this value to the default of 500.

Regards, Henk

September 6, 2020
2:23 pm
SMSer
Guest
Guests

I am use sql connector it show Query execution was interrupted, maximum statement execution time exceeded, database transaction rolled back many times.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 578

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 949

Posts: 3265

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1196