#170 DB_DataObject error []: DB Error: already exists

Closed
opened 3 years ago by aab · 6 comments
aab commented 3 years ago

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

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
aab commented 3 years ago
Poster

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.

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.
aab commented 3 years ago
Poster

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
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 ````
Diogo Cordeiro commented 3 years ago
Owner

I think that this was fixed already...?

I think that this was fixed already...?

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
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 ```
aab commented 3 years ago
Poster

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 INTOsession(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' )````

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' )````
aab reopened 3 years ago
XRevan86 commented 3 years ago
Collaborator

@Guillaume, that was my typo, fixed in 8745a3e824.

@Guillaume, that was my typo, fixed in 8745a3e824861bbfd83637d690ae9bc8070488a3.
Sign in to join this conversation.
No Milestone
No assignee
4 Participants
Loading...
Cancel
Save
There is no content yet.