MySQL Forums
Forum List  »  Replication

[ERROR] Failed to open the relay log '/var/lib/mysql/mysqld-relay-bin.000052' (relay_log_pos 98)
Posted by: Reegal Kalariya
Date: January 14, 2013 12:43PM

Hi All,

I am not able to login to MySQL and we are getting error as below. I have not restarted any server since long time but than i don't see why we are having this issue?

Please help.

130114 10:49:43 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/ms-data/mysql-db/mysqld-relay-bin' to avoid this problem.
130114 10:49:44 [ERROR] Failed to open the relay log '/var/lib/mysql/mysqld-relay-bin.000052' (relay_log_pos 98)
130114 10:49:44 [ERROR] Could not find target log during relay log initialization
130114 10:49:44 [ERROR] Failed to initialize the master info structure
130114 10:49:44 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.41-community-log' socket: '/ms-data/mysql-db/mysql.sock' port: 3306 MySQL Community Edition (GPL)
130114 10:51:02 - mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=26
max_connections=300
threads_connected=26
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1620813 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0xf52d27c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xff85d138, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80a653e
0x8364788
0x838111e
0x8380821
0x832c02e
0x832c652
0x80e2842
0x80dd0f6
0x80dc0d1
0x80dd5ec
0x80dda95
0x80b9209
0x81aa90a
0x81aa5be
0x81aa7e3
0x81a7eff
0x81a8ef4
0x80bd65b
0x80bf908
0x80b7668
0x80b6ef3
0x80b63f5
0x8361f3c
0x838c41a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8ef04d0 = select
`Ticker` AS Ticker,
`FiscalYearEnd` AS FiscalYearEnd,
`ExchangeTradedCode` AS Exchange,
`ZacksX-IndustryDescription` AS Industry,
`ZacksX-SectorDescription` AS Sector,
`ZacksM-IndustryIndustryCode` AS SubIndustry,
`CompanyPeer1` AS Peer1,
`Peer1Ticker` AS Peer1Ticker,
`CompanyPeer1` AS Peer1CompanyName,
`CompanyPeer2` AS Peer2,
`Peer2Ticker` AS Peer2Ticker,
`CompanyPeer2` AS Peer2CompanyName,
`CompanyPeer3` AS Peer3,
`Peer3Ticker` AS Peer3Ticker,
`CompanyPeer3` AS Peer3CompanyName,
`CompanyPeer4` AS Peer4,
`Peer4Ticker` AS Peer4Ticker,
`CompanyPeer4` AS Peer4CompanyName,
`CompanyPeer5` AS Peer5,
`Peer5Ticker` AS Peer5Ticker,
`CompanyPeer5` AS Peer5CompanyName,
`CompanyPeer6` AS Peer6,
`Peer6Ticker` AS Peer6Ticker,
`CompanyPeer6` AS Peer6CompanyName,
`CompanyPeer7` AS Peer7,
`Peer7Ticker` AS Peer7Ticker,
`CompanyPeer7` AS Peer7CompanyName,
`AnalystCoverage` AS AnalystCoverage,
`MostRecent
thd->thread_id=35
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
130114 10:54:00 [Warning] Aborted connection 13 to db: 'db_rebalance' user: 'usr_rebalcalc' host: 'idcrebalancedev.bxc.is-teledata.com' (Got timeout reading communication packets)
130114 10:54:00 [Warning] Aborted connection 11 to db: 'db_rebalance' user: 'usr_rebalcalc' host: 'idcrebalancedev.bxc.is-teledata.com' (Got timeout reading communication packets)
130114 10:54:00 [Warning] Aborted connection 12 to db: 'db_rebalance' user: 'usr_rebalcalc' host: 'idcrebalancedev.bxc.is-teledata.com' (Got timeout reading communication packets)

Options: ReplyQuote


Subject
Views
Written By
Posted
[ERROR] Failed to open the relay log '/var/lib/mysql/mysqld-relay-bin.000052' (relay_log_pos 98)
4677
January 14, 2013 12:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.