170 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. ---
  2. title: DB_DataObject error []: DB Error: already exists
  3. author: notabug.org/aab
  4. time: Wed, 08 Jul 2020 10:22:02 UTC
  5. status: open
  6. ---
  7. author: notabug.org
  8. time: Wed, 08 Jul 2020 10:22:02 UTC
  9. content: -----
  10. Maybe this is related to having "Handle sessions ourselves" in /panel/sessions: [error] 23651#23651: *899202 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught ServerException: [500]: [Session:2pvdjps6eahe6inilv36kbhs24] DB_DataObject error []: DB Error: already exists
  11. -----
  12. author: notabug.org
  13. time: Thu, 16 Jul 2020 20:55:41 UTC
  14. content: -----
  15. I forgot to mention that, other than that message in logs, everything works fine, that is, sessions are not closed unless you do it manually.
  16. -----
  17. author: notabug.org
  18. time: Wed, 22 Jul 2020 15:44:02 UTC
  19. content: -----
  20. After enabling debug mode, this seems related to ```` 2020-07-22 13:02:28 LOG_WARNING: [gnusocial.net:16353.0fa828fc GET /avatar/65990-48-20200122043859.jpeg] Session cookie "e9da9dfa3nrjs783mc5ifpmb67" is set but started value is null ````
  21. -----
  22. author: notabug.org
  23. time: Wed, 05 Aug 2020 16:59:38 UTC
  24. content: -----
  25. I think that this was fixed already...?
  26. -----
  27. author: notabug.org
  28. time: Sun, 09 Aug 2020 08:43:08 UTC
  29. content: -----
  30. Still getting the same error with plugins/Embed/scripts/fixup_files.php: ``` sudo -u www-data php plugins/Embed/scripts/fixup_files.php --limit 2020-08-01 --broken-oembed Found 1505 files. Will refetch for file with ID: 1777091, URL https://www.eff.org/takedowns/self-described-twitter-troll-ryan-hintze-discovers-new-way-troll-twitter-dmca PHP Fatal error: Uncaught ServerException: [500]: [File:1777091] DB_DataObject error []: DB Error: syntax error thrown in /var/www/social/classes/Memcached_DataObject.php on line 942 ```
  31. -----
  32. author: notabug.org
  33. time: Tue, 11 Aug 2020 11:55:15 UTC
  34. content: -----
  35. Found some of these in mysql log, maybe related: ```` 2020-08-13 19:45:53 gnusocial[gnusocial] @ localhost [] ERROR 1062: Duplicate entry 'fudagekj8bdsi2j8vr3mcjqitv' for key 'PRIMARY' : INSERT INTO `session` (`id` , `session_data` , `created` ) VALUES ('fudagekj8bdsi2j8vr3mcjqitv' , 'started|i:1597340752;returnto|s:33:\"https://gnusocial.net/main/public\";' , '2020-08-13 17:45:53' ) 2020-08-13 19:48:17 gnusocial[gnusocial] @ localhost [] ERROR 1062: Duplicate entry '24nufa1ppjghiu2ggrspa8khau' for key 'PRIMARY' : INSERT INTO `session` (`id` , `session_data` , `created` ) VALUES ('24nufa1ppjghiu2ggrspa8khau' , 'started|i:1597340896;returnto|s:33:\"https://gnusocial.net/main/public\";' , '2020-08-13 17:48:17' ) 2020-08-13 20:06:14 gnusocial[gnusocial] @ localhost [] ERROR 1062: Duplicate entry 'gp1vp8830qhn624268dso9neju' for key 'PRIMARY' : INSERT INTO `session` (`id` , `session_data` , `created` ) VALUES ('gp1vp8830qhn624268dso9neju' , 'started|i:1597341973;returnto|s:33:\"https://gnusocial.net/main/public\";' , '2020-08-13 18:06:14' ) 2020-08-13 20:15:17 gnusocial[gnusocial] @ localhost [] ERROR 1062: Duplicate entry 'va48mj7nnkl2plr3nf9rub8ic5' for key 'PRIMARY' : INSERT INTO `session` (`id` , `session_data` , `created` ) VALUES ('va48mj7nnkl2plr3nf9rub8ic5' , 'started|i:1597342517;' , '2020-08-13 18:15:17' )````
  36. -----
  37. author: notabug.org
  38. time: Thu, 13 Aug 2020 19:53:18 UTC
  39. content: -----
  40. @Guillaume, that was my typo, fixed in 8745a3e824861bbfd83637d690ae9bc8070488a3.
  41. -----