Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 534
log sequence number is in the future，数据文件中页面的LSN（日志序列号）比当前系统的LSN更高 - Bluetooth forum - bluetooth蓝牙技术
Bluetooth & UWB forum

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbjdownloads/cbjdownloads.php on line 49

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php on line 48

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php on line 47

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 217

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 219

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 227

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 231

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 234

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
Technical discuss

log sequence number is in the future，数据文件中页面的LSN（日志序列号）比当前系统的LSN更高


Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    service
  • [
    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    service]

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    帖子作者

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    离线
  • 管理员
  • 管理员
更多
2026-02-07 21:28 #1118
Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
by service
新帖
物理备份一定要先停止mysql.
Code:
sudo systemctl stop mysql

错误解决方法：
根据MySQL官方文档，当出现“log sequence number is in the future”错误时，可以尝试使用innodb_force_recovery模式启动，然后导出数据，最后重新初始化数据库并导入。停止服务并强制修复# 1. 立即停止MySQL服务
Code:
sudo systemctl stop mysql

# 2. 检查是否完全停止
Code:
sudo killall -9 mysqld mysqld_safe 2>/dev/null

# 3. 修改配置文件，使用强制恢复
Code:
sudo nano /etc/mysql/my.cnf
在配置文件中添加：
Code:
[mysqld] innodb_force_recovery = 6  # 使用最高级别强制启动 skip-slave-start innodb_purge_threads = 0 innodb_use_native_aio = 0
 尝试启动并导出数据
Code:
# 4. 启动MySQL（强制恢复模式） sudo systemctl start mysql # 5. 检查启动状态（给点时间启动） sleep 10 sudo systemctl status mysql tail -n 20 /var/log/mysql/error.log # 6. 如果启动成功，立即导出数据 # 使用最快的方式导出，忽略可能的错误 mysqldump -u root -p --quick --single-transaction --all-databases 2>/dev/null > /tmp/emergency_export.sql # 或者逐个导出关键数据库 for db in $(mysql -u root -p -e "SHOW DATABASES;" 2>/dev/null | grep -v Database | grep -v performance_schema | grep -v information_schema | grep -v mysql | grep -v sys); do     echo "导出数据库: $db"     mysqldump -u root -p --quick --single-transaction "$db" 2>/dev/null > "/tmp/${db}_export.sql" done
在恢复模式下导出数据（与上面一样的）当MySQL成功启动后：
Code:
# 1. 导出所有数据（这是最关键的一步） mysqldump -u root -p --all-databases --triggers --routines --events --single-transaction > /tmp/mysql_full_backup.sql # 2. 检查导出文件大小和内容 ls -lh /tmp/mysql_full_backup.sql head -20 /tmp/mysql_full_backup.sql # 3. 也可以单独导出问题数据库 mysqldump -u root -p --databases btrafavi --triggers --routines --events > /tmp/btrafavi_backup.sql
清理并重新初始化
Code:
# 1. 停止MySQL服务 sudo systemctl stop mysql # 2. 移除强制恢复参数 sudo sed -i '/innodb_force_recovery/d' /etc/mysql/my.cnf # 3. 备份并清理数据目录（官方推荐做法） sudo mv /var/lib/mysql /var/lib/mysql_broken_$(date +%Y%m%d_%H%M%S) # 4. 重新创建数据目录 sudo mkdir /var/lib/mysql sudo chown mysql:mysql /var/lib/mysql # 5. 重新初始化MySQL数据目录 sudo mysqld --initialize --user=mysql --lower-case-table-names=0 # 6. 获取临时root密码 sudo grep 'temporary password' /var/log/mysql/error.log
重新安装和配置
Code:
# 1. 启动MySQL服务 sudo systemctl start mysql # 2. 使用临时密码登录并修改密码 mysql -u root -p # 输入临时密码后执行： ALTER USER 'root'@'localhost' IDENTIFIED BY '你的新密码'; FLUSH PRIVILEGES; EXIT; # 3. 使用新密码登录并导入数据 mysql -u root -p < /tmp/mysql_full_backup.sql # 4. 如果导入过程中出现错误，可以尝试分批导入 mysql -u root -p -e "CREATE DATABASE IF NOT EXISTS btchina;" mysql -u root -p btrafavi < /tmp/btrafavi_backup.sql /code][b]验证修复结果[/b][code] # 1. 检查错误日志 sudo tail -n 50 /var/log/mysql/error.log # 2. 运行MySQL表检查 mysqlcheck -u root -p --all-databases --check # 3. 测试问题表 mysql -u root -p -e "USE btchina; SELECT COUNT(*) FROM ff583_session;" mysql -u root -p -e "USE btchina; SELECT COUNT(*) FROM ff583_scheduler_tasks;" # 4. 检查InnoDB状态 mysql -u root -p -e "SHOW ENGINE INNODB STATUS\G" | grep -A 20 "LATEST DETECTED DEADLOCK\|LOG"
📚 官方修复流程参考：[url] [/url]

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 234

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239

请 登录 或 注册一个帐号 参加讨论

核心： Kunena 论坛
FaLang translation system by Faboba

微信

rafavi01 rafavi 18519213808


Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100
mysqli object is already closed (500 Whoops, looks like something went wrong.)

Error

HTTP 500 Whoops, looks like something went wrong.

mysqli object is already closed

Exception

Error

in /var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php (line 318)
  1. */
  2. public function disconnect()
  3. {
  4. // Close the connection.
  5. if (\is_callable([$this->connection, 'close'])) {
  6. $this->connection->close();
  7. }
  9. parent::disconnect();
  10. }
in /var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> close (line 318)
  1. */
  2. public function disconnect()
  3. {
  4. // Close the connection.
  5. if (\is_callable([$this->connection, 'close'])) {
  6. $this->connection->close();
  7. }
  9. parent::disconnect();
  10. }
in /var/www/html/libraries/vendor/joomla/database/src/DatabaseDriver.php -> disconnect (line 496)
  1. *
  2. * @since 2.0.0
  3. */
  4. public function __destruct()
  5. {
  6. $this->disconnect();
  7. }
  9. /**
  10. * Alter database's character set.
  11. *
DatabaseDriver->__destruct()

Stack Trace

Error 
Error:
mysqli object is already closed

  at /var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:318
  at mysqli->close()
     (/var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:318)
  at Joomla\Database\Mysqli\MysqliDriver->disconnect()
     (/var/www/html/libraries/vendor/joomla/database/src/DatabaseDriver.php:496)
  at Joomla\Database\DatabaseDriver->__destruct()

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100