Stack Exchange

I have a situation for which I would appreciate any valuable pointers. I have sql transactional replication configured as below. sql01sqla ---> publisher sql01sqlc --> subscriber sql01sqle ---> distributor. I am testing if I can recover my replication flow , in the event of losing the distribution host, I have put distribution database in full recovery model and am taking log backups every 15mins. After configuring transactional replication, and ensuring a table is in sync, i stopped the agents (log reader and distribution ) on the distribution host. inserted a few records on publication and ensure the log back job of the publisher db is disabled as well. Now restored distribution d...

The operating system retued error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAbanking_sys_log.LDF'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. (Microsoft SQL Server, Error: 823) Let's block ads! بخوانید...

I have an SQL select, that gives two rows back. The SQL update gives the error message 1093 back; mysqli error: [1093: Table 'HD_TICKET' is specified twice, both as a target for 'UPDATE' and as a separate source for data] update HD_TICKET, HD_STATUS as T5 set HD_TICKET.HD_STATUS_ID = T5.ID, HD_TICKET.TIME_OPENED = IF(T5.STATE = 'opened', NOW(), HD_TICKET.TIME_OPENED), HD_TICKET.TIME_CLOSED = IF(T5.STATE = 'closed', NOW(), HD_TICKET.TIME_CLOSED), HD_TICKET.TIME_STALLED = IF(T5.STATE = 'stalled', NOW(), HD_TICKET.TIME_STALLED), HD_TICKET.SATISFACTION_RATING = IF(T5.STATE = 'closed', NULL, HD_TICKET.SATISFACTION_RATING), HD_TICKET.SATISFACTION_COMMENT = IF(T5.STATE = 'closed', NUL...

We have maintained one MySQL master server and two slave MySQL server. One of the MySQL slave server was down for more than a week. I tried to re-import all the database and restart the slave. But got the error 1594: MySql Version (Master): mysql Ver 14.14 Distrib 5.7.13 MySql Version (Slave): mysql Ver 14.14 Distrib 5.7.13 Replication method: GTID based Steps followed to re-import the DB and start the slave: mysql>stop slave; mysql>reset master; shell>mysql -u root -p < masterdbdump.sql mysql> start slave; Slave status after this: mysql> show slave statusG *************************** 1. row *************************** Slave_IO_State: Waiting for m...