<div>
Thanks, star_trek. I wonder why the library lists it as an &quot;invalid&quot; error code. That table is very useful and yes, repairing the table provides a fix. I'll need to investigate to find out how often this is happening now. I'm seeing it on a couple of servers.
</div>


Thanks, star_trek. I wonder why the library lists it as an "invalid" error code. That table is very useful and yes, repairing the table provides a fix. I'll need to investigate to find out how often this is happening now. I'm seeing it on a couple of servers.

<div>
<div class="content wysiwyg-content">
We have a-b-a replication between servers in data centres and have started seeing the following appearing when you run show slave status:<br />
<br />
Query caused different errors on master and slave. Error on master: 'Invalid error code' (126), Error on slave: 'no error' (0). Default database: 'EMFMTA_1_2'. Query: 'REPLACE INTO rescan_schedule SELECT MailInID,RecipID,ADDDATE(N<wbr />OW(),INTER<wbr />VAL IFNULL(ELT(Attempts,60,60,<wbr />120,240,48<wbr />0,900,1800<wbr />,3600,7200<wbr />,14400),SU<wbr />BSTRING_IN<wbr />DEX('60,60<wbr />,120,240,4<wbr />80,900,180<wbr />0,3600,720<wbr />0,14400','<wbr />,',IF(Atte<wbr />mpts&lt;1,1,-<wbr />1))) SECOND),NULL FROM recip WHERE RecipID in (2181280448,2181280452)'<br />
<br />
The servers are both the same MySQL version (5.0.18-max-log). What might cause an &quot;invalid error code&quot;? <br />
<br />

</div>
</div>


We have a-b-a replication between servers in data centres and have started seeing the following appearing when you run show slave status:

Query caused different errors on master and slave. Error on master: 'Invalid error code' (126), Error on slave: 'no error' (0). Default database: 'EMFMTA_1_2'. Query: 'REPLACE INTO rescan_schedule SELECT MailInID,RecipID,ADDDATE(NOW(),INTERVAL IFNULL(ELT(Attempts,60,60,120,240,480,900,1800,3600,7200,14400),SUBSTRING_INDEX('60,60,120,240,480,900,1800,3600,7200,14400',',',IF(Attempts<1,1,-1))) SECOND),NULL FROM recip WHERE RecipID in (2181280448,2181280452)'

The servers are both the same MySQL version (5.0.18-max-log). What might cause an "invalid error code"? 



Invalid error code (126)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.