+ 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
    162
    Thank Post
    18
    Thanked 11 Times in 11 Posts
    Rep Power
    15

    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,447
    Thank Post
    865
    Thanked 839 Times in 662 Posts
    Rep Power
    194
    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
    162
    Thank Post
    18
    Thanked 11 Times in 11 Posts
    Rep Power
    15
    Thanks, will do.

  4. #4
    MartinT's Avatar
    Join Date
    Jul 2007
    Location
    Ascot
    Posts
    162
    Thank Post
    18
    Thanked 11 Times in 11 Posts
    Rep Power
    15
    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,447
    Thank Post
    865
    Thanked 839 Times in 662 Posts
    Rep Power
    194
    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
    162
    Thank Post
    18
    Thanked 11 Times in 11 Posts
    Rep Power
    15
    Now fixed with:
    # /usr/bin/smoothwall/databasetools.pl --reindex

  7. #7


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,447
    Thank Post
    865
    Thanked 839 Times in 662 Posts
    Rep Power
    194
    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,439
    Thank Post
    1,468
    Thanked 1,035 Times in 908 Posts
    Rep Power
    299
    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,447
    Thank Post
    865
    Thanked 839 Times in 662 Posts
    Rep Power
    194
    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,447
    Thank Post
    865
    Thanked 839 Times in 662 Posts
    Rep Power
    194
    @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,571
    Thank Post
    868
    Thanked 1,293 Times in 786 Posts
    Blog Entries
    1
    Rep Power
    436
    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
  •