Mysql error 1317

MySQL ошибка 1317 вызывает репликацию из библиотеки и отключить, Русские Блоги, лучший сайт для обмена техническими статьями программиста.

Среда: сервер Percona для MySQL 5.5.18

1. Сообщите журнал ошибок:

171212 19:59:58 [ERROR] Slave SQL: Query partially completed on the master (error on master: 1317) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'SAVEPOINT `ZZG`', Error_code: 1317
171212 19:59:58 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000052' position 6786

2. Вновь появится

　Terminal A

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into y select * from x limit 1;
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> savepoint ZZG;
Query OK, 0 rows affected (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

　Terminal B

Когда терминал A выполняется для вставки, выполните запрос Kill, чтобы имитировать вставку терминала A. В настоящее время терминал A продолжает выполнять вышеуказанную операцию до конца коммита.

Проанализировать Binlog терминала А

mysqlbinlog mysql-bin.000052 --base64-output=decode-rows -vv |less

Получить следующие результаты

#171212 20:01:22 server id 1  end_log_pos 7929  Write_rows: table id 62 flags: STMT_END_F
### INSERT INTO test.y
### SET
###   @1='def' /* VARSTRING(1536) meta=1536 nullable=0 is_null=0 */
###   @2='information_schema' /* VARSTRING(192) meta=192 nullable=0 is_null=0 */
###   @3='CHARACTER_SETS' /* VARSTRING(192) meta=192 nullable=0 is_null=0 */
###   @4='SYSTEM VIEW' /* VARSTRING(192) meta=192 nullable=0 is_null=0 */
###   @5='MEMORY' /* VARSTRING(192) meta=192 nullable=1 is_null=0 */
###   @6=10 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @7='Fixed' /* VARSTRING(30) meta=30 nullable=1 is_null=0 */
###   @8=NULL /* VARSTRING(30) meta=0 nullable=1 is_null=1 */
###   @9=384 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @10=0 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @11=8388480 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @12=0 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
###   @14=NULL /* LONGINT meta=0 nullable=1 is_null=1 */
###   @15=2017-12-12 18:54:45 /* DATETIME meta=0 nullable=1 is_null=0 */
###   @16=NULL /* DATETIME meta=0 nullable=1 is_null=1 */
###   @17=NULL /* DATETIME meta=0 nullable=1 is_null=1 */
###   @18='utf8_general_ci' /* VARSTRING(96) meta=96 nullable=1 is_null=0 */
###   @19=NULL /* VARSTRING(96) meta=0 nullable=1 is_null=1 */
###   @20='max_rows=21845' /* VARSTRING(765) meta=765 nullable=1 is_null=0 */
###   @21='' /* VARSTRING(6144) meta=6144 nullable=0 is_null=0 */
# at 7929
#171212 20:01:38 server id 1  end_log_pos 8007  Query   thread_id=3575  exec_time=0     error_code=1317
SET TIMESTAMP=1513080098/*!*/;
SAVEPOINT `ZZG`
/*!*/;
# at 8007
#171212 20:01:45 server id 1  end_log_pos 8034  Xid = 10115
COMMIT/*!*/;
DELIMITER ;
# End of log file

Эта ошибка_кода = 1317 не отражена в журнале MySQL Master, но он непосредственно приводит к репликации библиотеки.

171212 19:59:58 [ERROR] Slave SQL: Query partially completed on the master (error on master: 1317) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'SAVEPOINT `ZZG`', Error_code: 1317
171212 19:59:58 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000052' position 6786

В настоящее время основная библиотека не влияет. Вставка основной библиотеки представлен нормально, но из библиотеки не получают эту вставку.SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; В настоящее время эта транзакция будет пропущена, а основная библиотека будет скопирована. Но как только основная библиотека имеет изменение этого или нескольких данных, репликация библиотеки снова будет отключена

Перепечатано: https://www.cnblogs.com/coye/p/8029730.html

Источник

Hi,
That’s not the first time I get such error, on no particular request or table and it begins to worry me.
It even happens very often regarding the few amount of requests I can do. I’m afraid about what will happen once the website will be on production.
I own a PRO hosting at OVH. So, I doubt the problem could come from their side…

Here are the infos I can provide from Debugkit. I hope this will evoke something.

From VARIABLES page:

messageSQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted url/Sitraexports/processexport
errorUnserializable object - CakeDatabaseException. Error: SQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted in /home/modulwoo/www/2ndGuideTest/vendor    /cakephp/cakephp/src/Database/Schema/Collection.php, line 130
code500
_serialize(array)

From SQL LOG

SHOW FULL COLUMNS FROM `paiements`  16  8
SHOW INDEXES FROM `paiements`   1   0
SELECT * FROM information_schema.key_column_usage AS kcu INNER JOIN information_schema.referential_constraints AS rc ON (kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME) WHERE kcu.TABLE_SCHEMA = 'modulwoomobtst' AND kcu.TABLE_NAME = 'paiements' and rc.TABLE_NAME = 'paiements'

Stacktrace:

2015-04-22 20:48:30 Error: [CakeDatabaseException] SQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted
Request URL: /Sitraexports/processexport
Stack Trace:
#0 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(102): CakeDatabaseSchemaCollection->_reflect('ForeignKey', 'paiements', Array, Object(CakeDatabaseSchemaTable))
#1 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php(65): CakeDatabaseSchemaCollection->describe('paiements', Array)
#2 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Table.php(425): CakeDatabaseSchemaCachedCollection->describe('paiements')
#3 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Query.php(141): CakeORMTable->schema()
#4 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Query.php(123): CakeORMQuery->addDefaultTypes(Object(AppModelTablePaiementsTable))
#5 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Table.php(1147): CakeORMQuery->__construct(Object(CakeDatabaseConnection), Object(AppModelTablePaiementsTable))
#6 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Table.php(882): CakeORMTable->query()
#7 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Association.php(582): CakeORMTable->find('all', Array)
#8 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Association/SelectableAssociationTrait.php(95): CakeORMAssociation->find('all', Array)
#9 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Association/BelongsToMany.php(924): CakeORMAssociationBelongsToMany->_buildBaseQuery(Array)
#10 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Association/SelectableAssociationTrait.php(52): CakeORMAssociationBelongsToMany->_buildQuery(Array)
#11 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/EagerLoader.php(539): CakeORMAssociationBelongsToMany->eagerLoader(Array)
#12 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Query.php(645): CakeORMEagerLoader->loadExternal(Object(CakeORMQuery), Object(CakeDatabaseLogLoggingStatement))
#13 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php(218): CakeORMQuery->_execute()
#14 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/ORM/Query.php(596): CakeORMQuery->_all()
#15 /home/modulwoo/www/2ndGuideTest/src/Controller/SitraexportsController.php(144): CakeORMQuery->all()
#16 [internal function]: AppControllerSitraexportsController->processexport()
#17 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Controller/Controller.php(404): call_user_func_array(Array, Array)
#18 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Routing/Dispatcher.php(114): CakeControllerController->invokeAction()
#19 /home/modulwoo/www/2ndGuideTest/vendor/cakephp/cakephp/src/Routing/Dispatcher.php(87): CakeRoutingDispatcher->_invoke(Object(AppControllerSitraexportsController))
#20 /home/modulwoo/www/2ndGuideTest/webroot/index.php(37): CakeRoutingDispatcher->dispatch(Object(CakeNetworkRequest), Object(CakeNetworkResponse))
#21 {main}

Paiements table is just read to build a list of possible values.

Of course I can repeat the exact same request many times without problem before getting it back, maybe, or maybe not… :-/

Regards,
Alain

Источник

Get Involved

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Query execution was interrupted [1317]

Dear All,
I get the error 1317 as you can see on subject. Searching for this error I found it may be related to the amount of forums. Topics stating that are pretty old, so I would like to know if the latest version of phpBB still have the same issue.

Regards,
Gianni

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Re: Query execution was interrupted [1317]

Post

by gambr » Sun Jan 17, 2016 5:39 pm

Dear Robert,
I’m aware that more details are required to resolve such an issue but my question was just to know if phpBB already have problems depending on the number of forums like I read on some posts of few years ago.

I’m currently not the admin of the forum so I can not provide the required details. I have a degree in computer science and I’m just offering support.

Regards,
Gianni

User avatar

cprgolds

Registered User
Posts: 459
Joined: Thu Oct 11, 2007 5:49 am
Location: Portland, Oregon

Re: Query execution was interrupted [1317]

Post

by cprgolds » Tue Jan 19, 2016 1:25 am

Gianni,

Its very possible that your hosting service has some limits on SQL query time. Can you give a link to your hosting plan.

Without more information, as Robert requested, its hard to help.

In addition it would be useful to know how many users and how many messages you have.

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Re: Query execution was interrupted [1317]

Post

by gambr » Tue Jan 26, 2016 8:00 pm

Dear Robert and cprgolds,
I got the informations required to fill the Support Request Template Generator. As you can see phpBB version is 3.0.1 so feel free to move this topic to the appropriate forum.

Support Request Template
What version of phpBB are you using? phpBB 3.0.1
What is your board’s URL? http://www.funghiemicologia.com
Who do you host your board with? www.aruba.it
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? Yes
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.0.0
What MODs do you have installed? board 3 portal
What styles do you currently have installed? prosilver, subsilver 2
What language(s) is your board currently using? italian
Which database type/version are you using? MySQL 4
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? No answer given
Please describe your problem. SQL ERROR [ mysql4 ]

Query execution was interrupted [1317]

Lost connection to MySQL server during query [2013]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND in_message = 0 ORDER BY filetime DESC’ at line 4 [1064]
Generated by SRT Generator

User avatar

cprgolds

Registered User
Posts: 459
Joined: Thu Oct 11, 2007 5:49 am
Location: Portland, Oregon

Re: Query execution was interrupted [1317]

Post

by cprgolds » Wed Jan 27, 2016 8:17 am

I took a look at your board and randomly displayed some messages. I display about 10 and the got the error message that you show.

This is the message I tried to display:

Picture0001.png
Picture0001.png (10.65 KiB) Viewed 713 times

I tried to reproduce the error and the message displayed OK.

This would make me think that it is a hosting problem, but that’s only a guess. Maybe someone has some better advice.

Ciao!

Rick

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Re: Query execution was interrupted [1317]

Post

by gambr » Wed Jan 27, 2016 1:51 pm

There are some SQL errors that happen randomly.
It seems that new user registration always get an error at the end of the registration procedure.
I experienced that error 1317 happens most frequently than others while browsing the forum pages that is moving from page x to the next page of a topic, or while submitting a new message to a topic. Some user reported the disappearing of the «instant message» link on the board. And in one case that happens olso to me but just one day: now it seems OK for all users.
Yesterday the forum admin tried to browse the pages (some one is open to non-registered users) and he told me the same error happens.
Someone suggested to remove some forums, now Rick tells there may be an hosting problem.
Is there something we could try to check if the problem can be solved updating the forum to v 3.1.x, or remove some forums or what else to verify for the hosting?

Regards,
Gianni

User avatar

Lumpy Burgertushie

Registered User
Posts: 69045
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Query execution was interrupted [1317]

Post

by Lumpy Burgertushie » Wed Jan 27, 2016 4:32 pm

with a version that old it could be that your host has updated their php or some other software and made your board no longer compatible.

yes, you should update/upgrade.

however, I don’t think you will be able to go straight from 3.0.1 to 3.1 or even to 3.0.14

you will probably need to go from 3.0.1 to at least 3.0.2 first. then you can go straight to 3.1 if you wish.

you should really do this on a test board. you can either make a duplicate of your board elsewhere on the server or on your home computer. get it all working correctly and then try it on your live site.

there are plenty of posts here and articles in the knowledge base to help you with how to do that.
check the menu at the top of this page.

luck,
robert

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Re: Query execution was interrupted [1317]

Post

by gambr » Thu Feb 04, 2016 10:15 pm

Hallo again,
the admin told me he already tried with the database repairing tool in vain. So, we have to try something different (i.e. update the forum engine). About that the admin asked if there is a way to install a 3.1.x from scratch and then use the old DB, just to avoid the forum update. I think the update process could also update the database schema, tables and fields according to the new phpBB requirements. Moreover all forum settings would be lost. Is that right?

Regards,
Gianni

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

gambr

Registered User
Posts: 124
Joined: Fri Jan 15, 2016 2:33 pm

Re: Query execution was interrupted [1317]

Post

by gambr » Tue Mar 01, 2016 2:38 pm

Updated phpBB to 3.0.14 the problem is still there.
After login and pushing to «my posts» link the error1317 appears very often. In that case after a couple of page reload the result page is shown.

Any idea?

Regards,
Gianni

Источник

Понравилась статья? Поделить с друзьями:
  • Mysql error 1130 localhost is not allowed to connect to this mysql server
  • Mysql error 1130 hy000 host is not allowed to connect to this mysql server
  • Mysql error 1114 что это
  • Mysql error 1114 как исправить
  • Mysql error 1100