+ Post New Thread
Results 1 to 12 of 12
Internet Related/Filtering/Firewall Thread, Smoothwall Database Errors in Technical; We're getting a lot of database errors in the system log, with a request to reindex it. How do we ...
  1. #1
    MartinT's Avatar
    Join Date
    Jul 2007
    Location
    Ascot
    Posts
    169
    Thank Post
    19
    Thanked 12 Times in 12 Posts
    Rep Power
    17

    Smoothwall Database Errors

    We're getting a lot of database errors in the system log, with a request to reindex it. How do we do that? I rebooted Smoothwall yesterday and they went away for a while, but the entries are back again at the rate of several per second. Excerpt:

    -----------------------------------------------------------------

    10:48:52 smoothwall Database parser: Attempting individual inserts...
    10:48:52 smoothwall Fallback: Entered: 1450 / 2000
    10:48:52 smoothwall Database parser: ERROR: DBD::Pg::st execute failed: ERROR: index "guardian_get_parameters_protocol_idx" contains unexpected zero page at block 167516 HINT: Please REINDEX it.
    10:48:52 smoothwall Database parser: Attempting individual inserts...
    10:48:52 smoothwall Database parser: ERROR: DBD::Pg::st execute failed: ERROR: index "guardian_get_parameters_protocol_idx" contains unexpected zero page at block 167516 HINT: Please REINDEX it.
    10:48:52 smoothwall Database parser: Attempting individual inserts...
    10:48:52 smoothwall Database parser: ERROR: Can't call method "execute" on an undefined value at /modules/guardian/usr/lib/smoothwall/commonlogparsing.pm line 203.

  2. #2


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    867
    Thanked 850 Times in 672 Posts
    Rep Power
    196
    Looks like you may need a database rebuild... worth getting in touch with support.

  3. #3
    MartinT's Avatar
    Join Date
    Jul 2007
    Location
    Ascot
    Posts
    169
    Thank Post
    19
    Thanked 12 Times in 12 Posts
    Rep Power
    17
    Thanks, will do.

  4. #4
    MartinT's Avatar
    Join Date
    Jul 2007
    Location
    Ascot
    Posts
    169
    Thank Post
    19
    Thanked 12 Times in 12 Posts
    Rep Power
    17
    Ticket raised. As a matter of interest, is there a way of forcing a database check/repair on reboot? I notice that every few reboots Smoothwall seems to perform additional file system checks but I don't know how to make it do them. Can it be done from the console after the system is up?

  5. #5


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    867
    Thanked 850 Times in 672 Posts
    Rep Power
    196
    Martin, the FS check is much more low level. A database check would take even longer. We plan to give much more user control over the FS check at some point - they really are not needed so frequently.

  6. #6
    MartinT's Avatar
    Join Date
    Jul 2007
    Location
    Ascot
    Posts
    169
    Thank Post
    19
    Thanked 12 Times in 12 Posts
    Rep Power
    17
    Now fixed with:
    # /usr/bin/smoothwall/databasetools.pl --reindex

  7. #7


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    867
    Thanked 850 Times in 672 Posts
    Rep Power
    196
    Excellent. Give a man a a fish and all that cobblers.

    Probably should be a button on t'gui for that, but everyone says the GUI has too many buttons

  8. #8

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,362
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    303
    Quote Originally Posted by tom_newton View Post
    Excellent. Give a man a a fish and all that cobblers.

    Probably should be a button on t'gui for that, but everyone says the GUI has too many buttons
    I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable

  9. Thanks to john from:

    tom_newton (11th June 2010)

  10. #9


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    867
    Thanked 850 Times in 672 Posts
    Rep Power
    196
    Quote Originally Posted by john View Post
    I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable
    Good idea! Thanks.

  11. #10


    Join Date
    Jan 2008
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0
    Quote Originally Posted by MartinT View Post
    Now fixed with:
    # /usr/bin/smoothwall/databasetools.pl --reindex
    Just a quick note that on the Database Backup page ( information >> settings >> database backup ) the "Optimize Database" button will perform this from the UI. Not that it's especially clear from the title that this is what it does.

    /me wanders off to add things to the V8 design notes

    Quote Originally Posted by john View Post
    I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable
    Oddly enough this is one of the things I've been looking at in V8 the last few days. The dashboard and services pages should both present click-through links to something a bit more tangible about the services they're representing (start / stop / restart, logs, configuration etc) although we're still at the experimental stage

  12. 2 Thanks to datalas:

    john (14th June 2010), tom_newton (14th June 2010)

  13. #11


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    867
    Thanked 850 Times in 672 Posts
    Rep Power
    196
    @ZeroHour: can you give Datalas (aka Darren) here "SmoothWall" rank -he's from SmoothWall, and he's rank, so he definitely deserves it

  14. #12

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,628
    Thank Post
    920
    Thanked 1,336 Times in 816 Posts
    Blog Entries
    1
    Rep Power
    448
    Quote Originally Posted by tom_newton View Post
    @ZeroHour: can you give Datalas (aka Darren) here "SmoothWall" rank -he's from SmoothWall, and he's rank, so he definitely deserves it
    Done, cheers

  15. Thanks to ZeroHour from:

    tom_newton (14th June 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Smoothwall database problem
    By theeldergeek in forum Internet Related/Filtering/Firewall
    Replies: 10
    Last Post: 18th June 2010, 10:02 AM
  2. Database server service on Smoothwall Network Guardian keeps stopping
    By Fonz_Valo in forum Internet Related/Filtering/Firewall
    Replies: 5
    Last Post: 9th December 2009, 01:14 PM
  3. Replies: 0
    Last Post: 2nd July 2007, 03:27 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •