https://www.ejabberd.im/node/3910 en https://www.ejabberd.im/node/3910#comment-55401 <p>Спасибо за помощь.</p> <p>моя ошибка, невнимательно прочитал Release Notes.</p> Fri, 12 Mar 2010 12:18:30 +0000 mccoder comment 55401 at https://www.ejabberd.im https://www.ejabberd.im/node/3910#comment-55400 <p>Ну надо обновить mysql драйвер.</p> Fri, 12 Mar 2010 07:22:54 +0000 zinid comment 55400 at https://www.ejabberd.im https://www.ejabberd.im/node/3910#comment-55399 <p>Release of Erlang 5.6/OTP R12B</p> <p>название папок:<br /> mysql-2007.0702<br /> odbc-2.10<br /> mnesia-4.4</p> Thu, 11 Mar 2010 18:06:51 +0000 mccoder comment 55399 at https://www.ejabberd.im https://www.ejabberd.im/node/3910#comment-55398 <p>Какая версия mysql драйвера?</p> <p>Вот из лога:</p> <p> * src/odbc/odbc_queries.erl: replaced string:join/2 function.<br /> Removed ugly "catch" statement from update_t/4.<br /> WARNING: this change requires last version of mysql driver.<br /> You can update it from ejabberd-modules repository.</p> Thu, 11 Mar 2010 16:31:54 +0000 zinid comment 55398 at https://www.ejabberd.im https://www.ejabberd.im/node/3910#comment-55397 <p>До него и после ничего нет, а вот сами 10 rollback запросов:</p> <div class="codeblock"><code>begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback<br />begin<br />select username, jid, nick, subscription, ask, askmessage, server, subscribe, type from rosterusers where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />update rosterusers set username=&#039;[MY_NAME]&#039;, jid=&#039;[CONTACT_JID]&#039;, nick=&#039;[CONTACT_NAME]&#039;, subscription=&#039;B&#039;, ask=&#039;N&#039;, askmessage=&#039;&#039;, server=&#039;N&#039;, subscribe=&#039;&#039;, type=&#039;item&#039; where username=&#039;[MY_NAME]&#039; and jid=&#039;[CONTACT_JID]&#039;<br />insert into rosterusers(username, jid, nick, subscription, ask, askmessage, server, subscribe, type) values (&#039;[MY_NAME]&#039;, &#039;[CONTACT_JID]&#039;, &#039;[CONTACT_NAME]&#039;, &#039;B&#039;, &#039;N&#039;, &#039;&#039;, &#039;N&#039;, &#039;&#039;, &#039;item&#039;)<br />rollback</code></div> <p>получается что после обновления он неполучает положительного ответа, и поэтому считает что в бд записи нет и пытается её вставить.</p> Thu, 11 Mar 2010 12:08:18 +0000 mccoder comment 55397 at https://www.ejabberd.im https://www.ejabberd.im/node/3910#comment-55393 <p>Этот баг я уже где-то видел, но не могу воспроизвести.<br /> У вас есть возможность залогировать запросы mysql и показать ту часть где затыкается? В логе надо будет найти кучу rollback (по дефолту - 10) и прихватить ещё пару-тройку запросов которые были до него и после него.</p> Thu, 11 Mar 2010 06:21:16 +0000 zinid comment 55393 at https://www.ejabberd.im