--- title: Tripleplay MySQL error 2002 description: Triplay service not running and gives error after reboot --- [Skip to content](https://service.spor-group.com/sportal/tripleplay-mysql-error-2002#main-content) English - United Kingdom Show submenu for translations [More support](https://service.spor-group.com/sportal/kb-tickets/new?hsLang=en-gb) [Customer Portal](https://service.spor-group.com/tickets?hsLang=en-gb) [![Untitled design (1)](https://service.spor-group.com/hs-fs/hubfs/Untitled%20design%20(1).png?width=80&height=80&name=Untitled%20design%20(1).png)](https://www.wearespor.com/) Open main navigation Close main navigation - English - United Kingdom Show submenu for translations - [More support](https://service.spor-group.com/sportal/kb-tickets/new) - [Customer Portal](https://service.spor-group.com/tickets) - [See Our Pricing](https://app.priceguide.ai/estimator/recGXDMSCiHBft2hE) [See Our Pricing](https://app.priceguide.ai/estimator/recGXDMSCiHBft2hE) How can we help you? - There are no suggestions because the search field is empty. 1. [SPOR Group Knowledge Base](https://service.spor-group.com/sportal?hsLang=en-gb) 2. [Troubleshooting](https://service.spor-group.com/sportal/troubleshooting?hsLang=en-gb) # Tripleplay MySQL error 2002 Phase 1 — access the tripleplay server / player device 1 Identify and locate the Tripleplay server or player hardware The MySQL instance runs on the Tripleplay server (or on the player itself if it's a self-contained unit). You need physical or remote access to it. - Locate the Tripleplay server/PC/appliance serving the 1st floor — typically in an AV rack, comms room, or IT cupboard on or near the 1st floor. - Confirm the device is powered on and has not frozen — check for fan noise, drive activity lights, or a display output. - If the device has a screen and keyboard, proceed locally. If it's headless, connect via Remote Desktop (RDP) or SSH using administrator credentials. The 6th floor working confirms the upstream network is fine. The fault is specific to the 1st floor Tripleplay server instance or its database. 2 Check whether the device shut down cleanly or is in a fault state An unclean shutdown during a power outage can leave MySQL in a locked or corrupt state. - Check the Windows Event Viewer (if Windows): Start → Event Viewer → Windows Logs → Application/System. Look for critical errors around the time of the outage. - On Linux: run`sudo journalctl -xe`or check`/var/log/syslog`for MySQL crash entries. - Note any disk errors or filesystem warnings — these must be addressed before starting MySQL. --- Phase 2 — restart the MySQL service 3 Restart MySQL via Windows Services (Windows OS) If the Tripleplay server runs on Windows, use the Services panel to restart MySQL. - Press**Win + R**, type`services.msc`and press Enter. - Scroll to find**MySQL**or**MySQL80**(or similar version). Check its status — it will likely show*Stopped*. - Right-click the MySQL service and select**Start**. Wait for the status to change to*Running*. - Once running, return to the Tripleplay display and check if the error has cleared. Win + R → services.msc → Find MySQL → Right-click → Start Error cleared → services restored Service won't start → proceed to step 5 4 Restart MySQL via command line (Windows or Linux) Alternatively, or if the Services panel is unavailable, restart MySQL from an elevated command prompt or terminal. - **Windows**— open Command Prompt as Administrator: net stop MySQL net start MySQL - **Linux (systemd)**— open a terminal with sudo access: sudo systemctl restart mysql sudo systemctl status mysql - Confirm the status shows**active (running)**before testing Tripleplay. Error cleared → services restored Service fails to start → proceed to step 5 --- Phase 3 — if MySQL fails to start (crash recovery) 5 Check MySQL error logs for the specific failure reason MySQL logs tell you exactly why the service won't start — essential before attempting any repair. - **Windows:**Check`C:\ProgramData\MySQL\MySQL Server X.X\Data\[hostname].err` - **Linux:**Check`/var/log/mysql/error.log`or run`sudo journalctl -u mysql -n 50` - Look for phrases like*"InnoDB: Database was not shut down normally"*or*"crashed table"*— these confirm an unclean shutdown from the power loss. Do not attempt manual database file repairs without first backing up the MySQL data directory. Contact your Tripleplay support partner if you are unsure. 6 Attempt InnoDB crash recovery (if log indicates unclean shutdown) MySQL can often self-recover from an unclean shutdown using its built-in InnoDB recovery mode. - Open the MySQL configuration file:`my.ini`(Windows) or`/etc/mysql/my.cnf`(Linux). - Under the`[mysqld]`section, add the following line: \[mysqld\] innodb\_force\_recovery = 1 - Save the file and attempt to start MySQL again (step 3 or 4). - If MySQL starts successfully,**immediately take a full database backup**, then remove the`innodb_force_recovery`line and restart MySQL normally. - If recovery level 1 fails, increase to 2, then 3 — but do not go above 3 without guidance from Tripleplay support, as higher values risk data loss. `innodb_force_recovery` must be removed after successful recovery. Running in recovery mode permanently causes data integrity issues. MySQL starts → test Tripleplay, backup DB, remove recovery flag Still failing → proceed to step 7 --- Phase 4 — fix auto-start & escalate 7 Set MySQL to start automatically on boot Even once resolved, prevent recurrence by ensuring MySQL is configured to auto-start on system boot. - **Windows:**In`services.msc`, right-click MySQL → Properties → set Startup type to**Automatic**. - **Linux:** sudo systemctl enable mysql - Confirm by checking the service startup type is now set to Automatic before closing. Also check that the Tripleplay application service itself is set to start automatically and is configured to start *after* MySQL (service dependency ordering).    How do I manage devices remotely so that I don't need to escalate issues as they happen? Our SPORTrack platform gives you the ability to remotely monitor and manage all of your devices, across the globe. [Check out the SPORTrack platform here.](https://www.spor-group.net/sportrack)   - [Setting Up Your Video Conference Rooms](https://service.spor-group.com/sportal/setting-up-your-video-conference-rooms?hsLang=en-gb) - [Troubleshooting](https://service.spor-group.com/sportal/troubleshooting?hsLang=en-gb) - [Podcasts](https://service.spor-group.com/sportal/podcasts?hsLang=en-gb) - [The Problem With AV](https://service.spor-group.com/sportal/the-problem-with-av?hsLang=en-gb) - [Reviews](https://service.spor-group.com/sportal/reviews?hsLang=en-gb) - [How Much Does AV Cost](https://service.spor-group.com/sportal/how-much-does-av-cost?hsLang=en-gb) - [Comparisons](https://service.spor-group.com/sportal/comparisons?hsLang=en-gb) - [Support](https://service.spor-group.com/sportal/support?hsLang=en-gb) - [Room Guides](https://service.spor-group.com/sportal/room-guides?hsLang=en-gb) [![Untitled design (1)](https://service.spor-group.com/hs-fs/hubfs/Untitled%20design%20(1).png?width=100&height=100&name=Untitled%20design%20(1).png "Untitled design (1)")](http://wearespor.com) 2nd Floor Right Suite, Burlington House, Maidenhead, United Kingdom, SL6 1SQ Copyright © 2025, SPOR Group