Skip to content

Instantly share code, notes, and snippets.

@ology
Created June 16, 2023 18:30
Show Gist options
  • Save ology/b4e2dd2edaf9199d90de94869d52a275 to your computer and use it in GitHub Desktop.
Save ology/b4e2dd2edaf9199d90de94869d52a275 to your computer and use it in GitHub Desktop.
Dancer + Mysql mystery - logs-in select people. Others - no dice.
...
Jun 15 21:33:53 chess uwsgi_psgi[179061]: [pid: 179061|app: 0|req: 1450/1450] 143.110.222.166 () {36 vars in 512 bytes} [Thu Jun 15 21:33:53 2023] GET / => generated 0 bytes
in 12 msecs (HTTP/1.1 302) 6 headers in 293 bytes (0 switches on core 0)
Jun 15 21:37:39 chess uwsgi_psgi[179061]: [pid: 179061|app: 0|req: 1451/1451] 216.244.66.245 () {36 vars in 515 bytes} [Thu Jun 15 21:37:39 2023] GET /robots.txt => generated
26 bytes in 5 msecs via sendfile() (HTTP/1.1 200) 3 headers in 111 bytes (0 switches on core 0)
Jun 15 21:42:19 chess uwsgi_psgi[179061]: _ANON__('HASH(0x555a86dd4580)') called at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Trace begun at (eval 342) line 1
Jun 15 21:42:19 chess uwsgi_psgi[179061]: main::__ANON__('DBIx::Class::Exception=HASH(0x555a86ddb910)') called at /usr/local/share/perl/5.30.0/DBIx/Class/Exception.pm line 77
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::Exception::throw('DBIx::Class::Exception', 'Unable to satisfy requested constraint \'primary\', missing values for colu
mn(s): \'id\'', 0) called at /usr/local/share/perl/5.30.0/DBIx/Class/Schema.pm line 1118
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::Schema::throw_exception('Family::Site::Schema=HASH(0x555a81f0fa58)', 'Unable to satisfy requested constraint \'primary\
', missing values for column(s): \'id\'') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSource.pm line 2379
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSource::throw_exception('DBIx::Class::ResultSource::Table=HASH(0x555a8619c7e0)', 'Unable to satisfy requested con
straint \'primary\', missing values for column(s): \'id\'') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSource.pm line 1616
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint('DBIx::Class::ResultSource::Table=HASH(0x555a8619c7e0)', 'constra
int_name', 'primary', 'values', 'HASH(0x555a86dda478)', 'columns_info', 'HASH(0x555a86d38be0)') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSet.pm line 881
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSet::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 102
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a86ddbfe8)', 'Try::Tiny::Catch=REF(0x555a86d5ae88)') called at /usr/local/share/perl/5.30.0/DBIx/Class/Res
ultSet.pm line 892
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSet::find('DBIx::Class::ResultSet=HASH(0x555a86835cd8)', 'HASH(0x555a86dd44d8)') called at /home/gene/repos/Famil
y-Site/lib/Family/Site.pm line 1482
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Family::Site::is_admin('Gene') called at /home/gene/repos/Family-Site/lib/Family/Site.pm line 405
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Family::Site::__ANON__ at /usr/local/share/perl/5.30.0/Dancer/Plugin/Auth/Extensible.pm line 228
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Plugin::Auth::Extensible::__ANON__ at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 274
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::execute('Dancer::Route=HASH(0x555a851f8348)') called at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 189
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 100
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a86de75a0)', 'Try::Tiny::Catch=REF(0x555a86d5b170)') called at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 203
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::run('Dancer::Route=HASH(0x555a851f8348)', 'Dancer::Request=HASH(0x555a86d5acd8)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 137
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 102
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a859208c0)', 'Try::Tiny::Catch=REF(0x555a86de61d8)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 146
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::get_action_response('Dancer::Renderer') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 33
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::render_action('Dancer::Renderer') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 84
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 100
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a8297db20)', 'Try::Tiny::Catch=REF(0x555a86de5920)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 114
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::render_request('Dancer::Request=HASH(0x555a86d5acd8)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 76
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::handle_request('Dancer::Handler::PSGI=HASH(0x555a81f12ba0)', 'Dancer::Request=HASH(0x555a86d5acd8)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 124
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::__ANON__('HASH(0x555a86d2d1f8)') called at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Trace begun at (eval 342) line 1
Jun 15 21:42:19 chess uwsgi_psgi[179061]: main::__ANON__('DBIx::Class::Exception=HASH(0x555a86de3598)') called at /usr/local/share/perl/5.30.0/DBIx/Class/Exception.pm line 77
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::Exception::throw('DBIx::Class::Exception', 'Unable to satisfy requested constraint \'primary\', missing values for column(s): \'id\'', 0) called at /usr/local/share/perl/5.30.0/DBIx/Class/Schema.pm line 1118
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::Schema::throw_exception('Family::Site::Schema=HASH(0x555a81f0fa58)', 'Unable to satisfy requested constraint \'primary\', missing values for column(s): \'id\'') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSource.pm line 2379
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSource::throw_exception('DBIx::Class::ResultSource::Table=HASH(0x555a8619c7e0)', 'Unable to satisfy requested constraint \'primary\', missing values for column(s): \'id\'') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSource.pm line 1616
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint('DBIx::Class::ResultSource::Table=HASH(0x555a8619c7e0)', 'constraint_name', 'primary', 'values', 'HASH(0x555a86dda8b0)', 'columns_info', 'HASH(0x555a86d5aa50)') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSet.pm line 881
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSet::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 102
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a86de6760)', 'Try::Tiny::Catch=REF(0x555a86dd48c8)') called at /usr/local/share/perl/5.30.0/DBIx/Class/ResultSet.pm line 892
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::ResultSet::find('DBIx::Class::ResultSet=HASH(0x555a865ea7f0)', 'HASH(0x555a86ddb730)') called at /home/gene/repos/Family-Site/lib/Family/Site.pm line 1482
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Family::Site::is_admin('Gene') called at /home/gene/repos/Family-Site/lib/Family/Site.pm line 405
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Family::Site::__ANON__ at /usr/local/share/perl/5.30.0/Dancer/Plugin/Auth/Extensible.pm line 228
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Plugin::Auth::Extensible::__ANON__ at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 274
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::execute('Dancer::Route=HASH(0x555a851f8348)') called at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 189
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 100
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a850cdbf0)', 'Try::Tiny::Catch=REF(0x555a8592d9b0)') called at /usr/local/share/perl/5.30.0/Dancer/Route.pm line 203
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::run('Dancer::Route=HASH(0x555a851f8348)', 'Dancer::Request=HASH(0x555a86d169d0)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 137
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 102
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a86d330f8)', 'Try::Tiny::Catch=REF(0x555a859afd60)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 146
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Route::run('Dancer::Route=HASH(0x555a851f8348)', 'Dancer::Request=HASH(0x555a86d169d0)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 137
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 102
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a86d330f8)', 'Try::Tiny::Catch=REF(0x555a859afd60)') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 146
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::get_action_response('Dancer::Renderer') called at /usr/local/share/perl/5.30.0/Dancer/Renderer.pm line 33
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Renderer::render_action('Dancer::Renderer') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 84
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::try {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 100
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /usr/local/share/perl/5.30.0/Try/Tiny.pm line 93
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Try::Tiny::try('CODE(0x555a8297db20)', 'Try::Tiny::Catch=REF(0x555a86d85170)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 114
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::render_request('Dancer::Request=HASH(0x555a86d169d0)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 76
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::handle_request('Dancer::Handler::PSGI=HASH(0x555a81f12ba0)', 'Dancer::Request=HASH(0x555a86d169d0)') called at /usr/local/share/perl/5.30.0/Dancer/Handler.pm line 124
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Dancer::Handler::__ANON__('HASH(0x555a85213300)') called at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: eval {...} at /home/gene/repos/Family-Site/bin/app.pl line 0
Jun 15 21:42:19 chess uwsgi_psgi[179061]: Trace begun at (eval 342) line 1
Jun 15 21:42:19 chess uwsgi_psgi[179061]: main::__ANON__('DBIx::Class::Exception=HASH(0x555a86de5db8)') called at /usr/local/share/perl/5.30.0/DBIx/Class/Exception.pm line 77
Jun 15 21:42:19 chess uwsgi_psgi[179061]: DBIx::Class::Exception::throw('DBIx::Class::Exception', 'Unable to satisfy requested constraint \'primary\', missing values for column(s): \'id\'', 0) called at /usr/lo[pid: 179061|app: 0|req: 1452/1452] 68.67.106.77 () {48 vars in 788 bytes} [Thu Jun 15 21:42:19 2023] GET /log => generated 4258 bytes in 141 msecs (HTTP/1.1 200) 4 headers in 143 bytes (0 switches on core 0)
Jun 15 21:42:19 chess uwsgi_psgi[179061]: [pid: 179061|app: 0|req: 1453/1453] 68.67.106.77 () {46 vars in 711 bytes} [Thu Jun 15 21:42:19 2023] GET /javascripts/jquery.masonry.min.js => generated 5483 bytes in 1 msecs via sendfile() (HTTP/1.1 200) 3 headers in 125 bytes (0 switches on core 0)
Jun 15 21:42:19 chess uwsgi_psgi[179061]: [pid: 179061|app: 0|req: 1454/1454] 68.67.106.77 () {46 vars in 695 bytes} [Thu Jun 15 21:42:19 2023] GET /javascripts/jquery.min.js => generated 86927 bytes in 1 msecs via sendfile() (HTTP/1.1 200) 3 headers in 126 bytes (0 switches on core 0)
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment